diff options
Diffstat (limited to 'admin/aktiv.php')
-rwxr-xr-x | admin/aktiv.php | 96 |
1 files changed, 0 insertions, 96 deletions
diff --git a/admin/aktiv.php b/admin/aktiv.php deleted file mode 100755 index e0ddf3a4..00000000 --- a/admin/aktiv.php +++ /dev/null @@ -1,96 +0,0 @@ -<?PHP - -$title = "akive Engel"; -$header = "Liste der aktiven Engel"; -include ("./inc/header.php"); -include ("./inc/funktion_db_list.php"); -include ("./inc/funktion_user.php"); - -echo "<form action=\"./aktiv.php\" method=\"post\">"; -echo Get_Text("pub_aktive_Text1")."<br>\n"; -echo Get_Text("pub_aktive_Text2")."<br><br>\n"; - -// auswahlbox -echo Get_Text("pub_aktive_Text31")."\n"; -echo "<select name=\"Anzahl\">\n"; -for( $i=0; $i<50; $i++) - echo "\t<option value=\"$i\">$i</option>\n"; -echo "</select>"; -echo Get_Text("pub_aktive_Text32")."<br><br>\n"; -echo "<input type=\"submit\" name=\"SendType\" value=\"Show..\">\n"; -echo "<input type=\"submit\" name=\"SendType\" value=\"Write..\">\n"; -echo "</form>\n"; - -echo "<form action=\"./aktiv.php\" method=\"post\">\n"; - echo "\t<br><input type=\"submit\" name=\"ResetActive\" value=\"reset Active setting\">\n"; -echo "</form>\n"; - -if( Isset($_POST["ResetActive"]) ) -{ - $SQLreset = "UPDATE `User` SET `Aktiv` = '0'"; - $ErgReset = mysql_query($SQLreset, $con); - if ($ErgReset != 1) - echo "Fehler beim zuruecksetzen der Activ\n"; - else - echo "Active wurde erfolgreich zurueckgesetzt\n"; -} - -if( IsSet($_POST["Anzahl"]) ) - echo "<br>\n\n".Get_Text("pub_aktive_Text5_1"). $_POST["Anzahl"]. Get_Text("pub_aktive_Text5_2"). ":"; - -echo "<br><br>\n\n"; - -//ausgabe tabelle -echo "<table width=\"100%\" class=\"border\" cellpadding=\"2\" cellspacing=\"1\">\n"; -echo "<tr class=\"contenttopic\">\n"; -echo "\t<td>". Get_Text("pub_aktive_Nick"). "</td>\n"; -echo "\t<td>". Get_Text("pub_aktive_Anzahl"). "</td>\n"; -echo "\t<td>". Get_Text("pub_aktive_Time"). "</td>\n"; -echo "\t<td>". Get_Text("pub_aktive_Active"). "</td>\n"; -echo "</tr>\n"; - -$SQL = "SELECT ShiftEntry.UID, COUNT(ShiftEntry.UID) AS NR, SUM(Shifts.Len) as LEN ". - "FROM `ShiftEntry` ". - "LEFT JOIN `Shifts` ON ShiftEntry.SID=Shifts.SID ". - "WHERE NOT UID=0 ". - "GROUP BY UID ". - "ORDER BY LEN DESC, NR DESC, UID "; -$Erg = mysql_query($SQL, $con); -echo mysql_error($con); -$rowcount = mysql_num_rows($Erg); - -echo "Anzahl eintraege: $rowcount<br><br>"; - -for ($i=0; $i<$rowcount; $i++) -{ - echo "\n\n\t<tr class=\"content\">\n"; - echo "\t\t<td>". UID2Nick(mysql_result($Erg, $i, "UID")). "</td>\n"; - echo "\t\t<td>". mysql_result($Erg, $i, "NR"). "</td>\n"; - echo "\t\t<td>". mysql_result($Erg, $i, "LEN"). "h</td>\n"; - echo "\t\t<td>"; - if (IsSet($_POST["Anzahl"])) - { - if( $_POST["Anzahl"] < mysql_result($Erg, $i, "LEN") ) - { - if( $_POST["SendType"]=="Show..") - echo "show set"; - else - { - $SQL2="UPDATE User SET Aktiv=1 WHERE UID=". mysql_result($Erg, $i, "UID"). " LIMIT 1"; - $Erg2 = mysql_query($SQL2, $con); - if ($Erg2 != 1) - echo "Fehler beim speichern bei Engel ".UID2Nick(mysql_result($Erg, $i, "UID")); - else - echo "write set"; - } - } - } - echo "</td>\n"; - echo "\t</tr>\n"; -} // ende Auflistung aktive Engel - -echo "</table>"; - -include ("./inc/footer.php"); -?> - |