"; echo Get_Text("pub_aktive_Text1")."
\n"; echo Get_Text("pub_aktive_Text2")."

\n"; // auswahlbox echo Get_Text("pub_aktive_Text31")."\n"; echo "\n"; for( $i=0; $i<50; $i++) echo "\t$i\n"; echo ""; echo Get_Text("pub_aktive_Text32")."

\n"; echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo "\t
\n"; echo "

\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 "
\n\n".Get_Text("pub_aktive_Text5_1"). $_POST["Anzahl"]. Get_Text("pub_aktive_Text5_2"). ":"; echo "

\n\n"; //ausgabe tabelle echo "\n"; echo "\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\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

"; for ($i=0; $i<$rowcount; $i++) { echo "\n\n\t\n"; echo "\t\t\n"; echo "\t\t\n"; echo "\t\t\n"; echo "\t\t\n"; echo "\t\n"; } // ende Auflistung aktive Engel echo "

". Get_Text("pub_aktive_Nick"). "	". Get_Text("pub_aktive_Anzahl"). "	". Get_Text("pub_aktive_Time"). "	". Get_Text("pub_aktive_Active"). "
". UID2Nick(mysql_result($Erg, $i, "UID")). "	". mysql_result($Erg, $i, "NR"). "	". mysql_result($Erg, $i, "LEN"). "h	"; 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 "

"; include ("./inc/footer.php"); ?>