From 866c47ec603595e8fe67da5f0e5d162a70b1f7b4 Mon Sep 17 00:00:00 2001
From: cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>
Date: Sun, 6 Nov 2005 17:14:25 +0000
Subject: move files

git-svn-id: svn://svn.cccv.de/engel-system@20 29ba0400-6e00-0410-a75a-ca02368028f8
---
 www-ssl/admin/aktiv.php | 96 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 96 insertions(+)
 create mode 100755 www-ssl/admin/aktiv.php

(limited to 'www-ssl/admin/aktiv.php')

diff --git a/www-ssl/admin/aktiv.php b/www-ssl/admin/aktiv.php
new file mode 100755
index 00000000..e0ddf3a4
--- /dev/null
+++ b/www-ssl/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($_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");
+?>
+
-- 
cgit v1.2.3-54-g00ecf