Changeset 365 for trunk/admin.php

Timestamp:

Mar 9, 2010, 11:29:05 AM (14 years ago)

Author:

george

Message:

• Upraveno: Jména tabulek v databází upraveny na stejná s prvními velkými písmeny.
• Upraveno: Doplněny SQL uvozovky do mnoha SQL dotazů.

File:

• trunk/admin.php (modified) (6 diffs)

trunk/admin.php

@@ -44 +44 @@
   if(array_key_exists('text', $_POST)) 
   {
-    $querty = 'INSERT INTO `news` ( `Time` ,`User` ,`Text`) VALUES ( NOW( ) , '.$_SESSION['UserID'].', "'.$_POST['text'].'")';
+    $querty = 'INSERT INTO `News` ( `Time` ,`User` ,`Text`) VALUES ( NOW( ) , '.$_SESSION['UserID'].', "'.$_POST['text'].'")';
     $Database->SQLCommand($querty);
     echo('Aktualita uložena!');
@@ -55 +55 @@
   global $Database;
   
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `user`');
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `User`');
   $DbRow2 = mysql_fetch_row($DbResult);
 
@@ -61 +61 @@
     ' AND (`ID` != 128)'. // Skip user Neznámý
     ' AND (`LastLogin` < DATE_SUB(NOW(), INTERVAL 3 MONTH))'. // Time limit
-    ' AND (NOT EXISTS (SELECT `Id` FROM `Export` WHERE `user`.`ID` = `Export`.`User`))'. // Without exports
-    ' AND (NOT EXISTS (SELECT `ID` FROM `dictionary` WHERE `user`.`ID` = `dictionary`.`user`))'. // Without dictionary words
-    ' AND (NOT EXISTS (SELECT `Id` FROM `news` WHERE `user`.`ID` = `news`.`user`))'. // Without news
-    ' AND (NOT EXISTS (SELECT `ID` FROM `shoutbox` WHERE `user`.`user` = `shoutbox`.`user`))'. // Without shoutbox messages
+    ' AND (NOT EXISTS (SELECT `Id` FROM `Export` WHERE `User`.`ID` = `Export`.`User`))'. // Without exports
+    ' AND (NOT EXISTS (SELECT `ID` FROM `Dictionary` WHERE `User`.`ID` = `Dictionary`.`User`))'. // Without dictionary words
+    ' AND (NOT EXISTS (SELECT `Id` FROM `News` WHERE `User`.`ID` = `News`.`User`))'. // Without news
+    ' AND (NOT EXISTS (SELECT `ID` FROM `ShoutBox` WHERE `User`.`User` = `ShoutBox`.`User`))'. // Without shoutbox messages
     '';
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `user`'.$Condition);
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `User`'.$Condition);
   $DbRow = mysql_fetch_row($DbResult);
-  $Database->SQLCommand('DELETE FROM `user`'.$Condition);
+  $Database->SQLCommand('DELETE FROM `User`'.$Condition);
   echo('Smazáno '.$DbRow[0].' účtů ze všech '.$DbRow2[0].'<br/>');
 
   // Delete logs without user
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `log`');
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Log`');
   $DbRow2 = mysql_fetch_row($DbResult);
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `log` WHERE (NOT EXISTS (SELECT `ID` FROM `user` WHERE `user`.`ID` = `log`.`user`)) AND (user != 0)');
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Log` WHERE (NOT EXISTS (SELECT `ID` FROM `User` WHERE `User`.`ID` = `Log`.`User`)) AND (`User` != 0)');
   $DbRow = mysql_fetch_row($DbResult);
-  $Database->SQLCommand('DELETE FROM `log` WHERE (NOT EXISTS (SELECT `ID` FROM `user` WHERE `user`.`ID` = `log`.`user`)) AND (user != 0)');
+  $Database->SQLCommand('DELETE FROM `Log` WHERE (NOT EXISTS (SELECT `ID` FROM `User` WHERE `User`.`ID` = `Log`.`User`)) AND (`User` != 0)');
   echo('Smazáno '.$DbRow[0].' položek logu ze všech '.$DbRow2[0].'<br/>');     
       
@@ -82 +82 @@
   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `ExportUser`');
   $DbRow2 = mysql_fetch_row($DbResult);
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `ExportUser` WHERE (NOT EXISTS (SELECT `Id` FROM `user` WHERE `user`.`ID` = `ExportUser`.`User`))');
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `ExportUser` WHERE (NOT EXISTS (SELECT `Id` FROM `User` WHERE `User`.`ID` = `ExportUser`.`User`))');
   $DbRow = mysql_fetch_row($DbResult);
-  $Database->SQLCommand('DELETE FROM `ExportUser` WHERE (NOT EXISTS (SELECT `Id` FROM `user` WHERE `user`.`ID` = `ExportUser`.`User`))');
+  $Database->SQLCommand('DELETE FROM `ExportUser` WHERE (NOT EXISTS (SELECT `Id` FROM `User` WHERE `User`.`ID` = `ExportUser`.`User`))');
   echo('Smazáno '.$DbRow[0].' položek výběru překladatelů u exportů ze všech '.$DbRow2[0].'<br/>');     
 
@@ -90 +90 @@
   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Team`');
   $DbRow2 = mysql_fetch_row($DbResult);
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Team` WHERE (SELECT COUNT(*) FROM `user` WHERE `user`.`Team` = `Team`.`Id`) = 0');
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Team` WHERE (SELECT COUNT(*) FROM `User` WHERE `User`.`Team` = `Team`.`Id`) = 0');
   $DbRow = mysql_fetch_row($DbResult);
-  $Database->SQLCommand('DELETE FROM `Team` WHERE (SELECT COUNT(*) FROM `user` WHERE `user`.`team` = `Team`.`Id`) = 0');
+  $Database->SQLCommand('DELETE FROM `Team` WHERE (SELECT COUNT(*) FROM `User` WHERE `User`.`team` = `Team`.`Id`) = 0');
   echo('Smazáno '.$DbRow[0].' týmů ze všech '.$DbRow2[0].'<br/>');     
         
   // Set new leader for teams where old leader went to other team
-  $Database->SQLCommand('UPDATE Team SET Leader=(SELECT Id FROM `user` WHERE user.Team=Team.Id ORDER BY user.RegistrationTime LIMIT 1) WHERE Leader NOT IN (SELECT ID FROM user WHERE user.Team=Team.Id);');
+  $Database->SQLCommand('UPDATE `Team` SET `Leader`=(SELECT `Id` FROM `User` WHERE `User`.`Team`=`Team`.`Id` ORDER BY `User`.`RegistrationTime` LIMIT 1) WHERE `Leader` NOT IN (SELECT `ID` FROM `User` WHERE `User`.`Team`=`Team`.`Id`);');
   
   WriteLog('Smazány staré uživatelské účty', LOG_TYPE_ADMINISTRATION);
@@ -105 +105 @@
   global $Database;
   
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `log` WHERE `type`='.LOG_TYPE_ERROR);
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Log` WHERE `Type`='.LOG_TYPE_ERROR);
   $DbRow = mysql_fetch_row($DbResult);
-  $Database->SQLCommand('DELETE FROM `log` WHERE `type`='.LOG_TYPE_ERROR);
+  $Database->SQLCommand('DELETE FROM `Log` WHERE `Type`='.LOG_TYPE_ERROR);
   WriteLog('Vymazány chybové záznamy', LOG_TYPE_ADMINISTRATION);  
   echo('Smazáno všech '.$DbRow[0].' chybových záznamů.<br/>');