diff options
Diffstat (limited to 'admin/aktiv.php')
| -rwxr-xr-x | admin/aktiv.php | 96 |
1 files changed, 96 insertions, 0 deletions
diff --git a/admin/aktiv.php b/admin/aktiv.php new file mode 100755 index 00000000..419be35c --- /dev/null +++ b/admin/aktiv.php @@ -0,0 +1,96 @@ +<?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($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($Anzahl) ) + echo "<br>\n\n".Get_Text("pub_aktive_Text5_1"). $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($Anzahl)) + { + if( $Anzahl < mysql_result($Erg, $i, "LEN") ) + { + if( $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"); +?> + |