"; 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 = db_query($SQLreset, "Reset Active"); 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 "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\n"; $SQL = " SELECT d.UID, d.nr, d.len, d.lenWeight, f.nr AS nrFree, f.len AS lenFree, d.lenWeight - COALESCE(f.len, 0) as lenReal FROM (SELECT e.UID, COUNT(s.Len) as nr, SUM(s.Len) as len, SUM( s.Len*(1+(((HOUR(s.DateS)+2)%24)<10 and ((HOUR(s.DateE)+2)%24)<=10)) ) as lenWeight FROM `Shifts` AS s INNER JOIN `ShiftEntry` AS e USING(SID) WHERE NOT UID=0 GROUP BY UID) as d LEFT JOIN (SELECT UID, COUNT(Length) AS nr, SUM(Length) AS len FROM `ShiftFreeloader` GROUP BY UID) AS f USING(UID) ORDER BY lenReal DESC, nr DESC, UID"; $Erg = mysql_query($SQL, $con); echo mysql_error($con); $rowcount = mysql_num_rows($Erg); $aktivecount=0; 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\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_Time"). " Weight	Freeloader ". Get_Text("pub_aktive_Anzahl"). "	Freeloader ". Get_Text("pub_aktive_Time"). "	". Get_Text("pub_aktive_Time"). " result	". Get_Text("pub_aktive_Active"). "
". UID2Nick(mysql_result($Erg, $i, "UID")). "	". mysql_result($Erg, $i, "nr"). "x	". mysql_result($Erg, $i, "len"). "h	". mysql_result($Erg, $i, "lenWeight"). "h	". mysql_result($Erg, $i, "nrFree"). "x	". mysql_result($Erg, $i, "lenFree"). "h	". mysql_result($Erg, $i, "lenReal"). "h	"; if (IsSet($_POST["Anzahl"])) { if( $_POST["Anzahl"] < mysql_result($Erg, $i, "lenReal") ) { $aktivecount++; if( $_POST["SendType"]=="Show..") echo "show set"; else { $SQL2="UPDATE `User` SET `Aktiv`='1' WHERE `UID`='". mysql_result($Erg, $i, "UID"). "' LIMIT 1"; $Erg2 = db_query($SQL2, "update Active State"); if ($Erg2 != 1) echo "Fehler beim speichern bei Engel ".UID2Nick(mysql_result($Erg, $i, "UID")); else echo "write set"; } } } echo "

"; echo "
Anzahl eintraege: $aktivecount / $rowcount (Aktive/Mitschichten)

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