From 75448045cfe70054c8f4bae1bcfaf9bb0f70d330 Mon Sep 17 00:00:00 2001 From: Moritz helios Rudert Date: Wed, 1 Jun 2011 12:13:39 +0200 Subject: fixes --- www-ssl/admin/debug.php | 42 +++++++++++++++++++++--------------------- 1 file changed, 21 insertions(+), 21 deletions(-) mode change 100755 => 100644 www-ssl/admin/debug.php (limited to 'www-ssl/admin/debug.php') diff --git a/www-ssl/admin/debug.php b/www-ssl/admin/debug.php old mode 100755 new mode 100644 index b01a8a6c..b2c6357f --- a/www-ssl/admin/debug.php +++ b/www-ssl/admin/debug.php @@ -1,4 +1,4 @@ -Web Counter"; funktion_db_list("Counter"); /* -echo "

Raeume


"; +echo "

Raeume


"; funktion_db_list("Raeume"); -echo "

Schichtbelegung


"; +echo "

Schichtbelegung


"; funktion_db_list("Schichtbelegung"); -echo "

Schichtplan


Hier findest du alle bisher eingetragenen Schichten:"; +echo "

Schichtplan


Hier findest du alle bisher eingetragenen Schichten:"; funktion_db_list("Schichtplan"); -echo "

User


"; +echo "

User


"; funktion_db_list("User"); -echo "

News


"; +echo "

News


"; funktion_db_list("News"); -echo "

FAQ


"; +echo "

FAQ


"; funktion_db_list("FAQ"); echo "Deaktiviert"; @@ -32,34 +32,34 @@ echo "Deaktiviert"; echo "
\n"; funktion_db_element_list_2row( "Tshirt-Size aller engel", - "SELECT `Size`, COUNT(`Size`) FROM `User` GROUP BY `Size`"); -echo "
\n"; + "SELECT `Size`, COUNT(`Size`) FROM `User` GROUP BY `Size`"); +echo "
\n"; funktion_db_element_list_2row( "Tshirt ausgegeben", - "SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Tshirt`='1' GROUP BY `Size`"); -echo "
\n"; + "SELECT `Size`, COUNT(`Size`) FROM `User` WHERE `Tshirt`='1' GROUP BY `Size`"); +echo "
\n"; funktion_db_element_list_2row( "Tshirt nicht ausgegeben (Gekommen=1)", - "SELECT COUNT(`Size`), `Size` FROM `User` WHERE `Gekommen`='1' and `Tshirt`='0' GROUP BY `Size`"); + "SELECT COUNT(`Size`), `Size` FROM `User` WHERE `Gekommen`='1' and `Tshirt`='0' GROUP BY `Size`"); echo "
\n"; funktion_db_element_list_2row( "Hometown", - "SELECT COUNT(`Hometown`), `Hometown` FROM `User` GROUP BY `Hometown`"); -echo "
\n"; + "SELECT COUNT(`Hometown`), `Hometown` FROM `User` GROUP BY `Hometown`"); +echo "
\n"; funktion_db_element_list_2row( "Engeltypen", - "SELECT COUNT(`Art`), `Art` FROM `User` GROUP BY `Art`"); + "SELECT COUNT(`Art`), `Art` FROM `User` GROUP BY `Art`"); echo "
\n"; funktion_db_element_list_2row( "Gesamte Arbeit", - "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID)"); -echo "
\n"; + "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID)"); +echo "
\n"; funktion_db_element_list_2row( "Geleisteter Arbeit", - "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (ShiftEntry.UID!=0)"); + "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (ShiftEntry.UID!=0)"); echo "
\n"; funktion_db_element_list_2row( "Gesamte Arbeit (Ohne Raum aufabau (RID=7)", - "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (Shifts.RID!=7)"); -echo "
\n"; + "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (Shifts.RID!=7)"); +echo "
\n"; funktion_db_element_list_2row( "Geleisteter Arbeit (Ohne Raum aufabau (RID=7)", - "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (ShiftEntry.UID!=0) AND (Shifts.RID!=7)"); + "SELECT COUNT(*) AS `Count [x]`, SUM(Shifts.Len) as `Sum [h]` from Shifts LEFT JOIN ShiftEntry USING(SID) WHERE (ShiftEntry.UID!=0) AND (Shifts.RID!=7)"); -- cgit v1.2.3-54-g00ecf