summaryrefslogtreecommitdiff
path: root/admin/aktiv.php
diff options
context:
space:
mode:
Diffstat (limited to 'admin/aktiv.php')
-rwxr-xr-xadmin/aktiv.php96
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");
-?>
-