"; 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"); ?>