Changeset 455 for trunk/admin.php

Timestamp:

Apr 13, 2010, 10:03:12 AM (14 years ago)

Author:

george

Message:

• Upraveno: Přístup k databázi převeden na objektový pomocí rozšířené PHP třídy mysqli. Při práci s databází použít globální objekt $System a jeho prvek $Database ($System->Database->query("SELECT ...");.
• Upraveno: Při vkládání nové zprávy do Kecátka neprovádět přesměrování, ale rovnou zobrazit výpis. U některých překladatelů toto způsobovalo opakované vložení zprávy.

File:

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

trunk/admin.php

@@ -41 +41 @@
 function SaveNew()
 {
-  global $Database, $Config, $User;
+  global $System, $Config, $User;
   
   if(array_key_exists('text', $_POST)) 
   {
     $querty = 'INSERT INTO `News` ( `Time` ,`User` ,`Text`) VALUES ( NOW( ) , '.$User->Id.', "'.$_POST['text'].'")';
-    $Database->SQLCommand($querty);
+    $System->Database->query($querty);
     echo('Aktualita uložena!');
     WriteLog('Vložena nová aktualita', LOG_TYPE_ADMINISTRATION);
@@ -54 +54 @@
 function DeleteOldUsers()
 {
-  global $Database;
+  global $System;
   
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `User`');
-  $DbRow2 = mysql_fetch_row($DbResult);
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `User`');
+  $DbRow2 = $DbResult->fetch_row();
 
   $Condition = ' WHERE (`TranslatedCount`= 0)'. // Without translated texts
@@ -67 +67 @@
     ' AND (NOT EXISTS (SELECT `ID` FROM `ShoutBox` WHERE `User`.`Name` = `ShoutBox`.`User`))'. // Without shoutbox messages
     '';
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `User`'.$Condition);
-  $DbRow = mysql_fetch_row($DbResult);
-  $Database->SQLCommand('DELETE FROM `User`'.$Condition);
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `User`'.$Condition);
+  $DbRow = $DbResult->fetch_row();
+  $System->Database->query('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`');
-  $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)');
-  $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)');
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `Log`');
+  $DbRow2 = $DbResult->fetch_row();
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `Log` WHERE (NOT EXISTS (SELECT `ID` FROM `User` WHERE `User`.`ID` = `Log`.`User`)) AND (`User` != 0)');
+  $DbRow = $DbResult->fetch_row();
+  $System->Database->query('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/>');     
       
   // Delete invalid ExportUser
-  $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`))');
-  $DbRow = mysql_fetch_row($DbResult);
-  $Database->SQLCommand('DELETE FROM `ExportUser` WHERE (NOT EXISTS (SELECT `Id` FROM `User` WHERE `User`.`ID` = `ExportUser`.`User`))');
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `ExportUser`');
+  $DbRow2 = $DbResult->fetch_row();
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `ExportUser` WHERE (NOT EXISTS (SELECT `Id` FROM `User` WHERE `User`.`ID` = `ExportUser`.`User`))');
+  $DbRow = $DbResult->fetch_row();
+  $System->Database->query('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/>');     
 
   // Delete all teams without users
-  $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');
-  $DbRow = mysql_fetch_row($DbResult);
-  $Database->SQLCommand('DELETE FROM `Team` WHERE (SELECT COUNT(*) FROM `User` WHERE `User`.`team` = `Team`.`Id`) = 0');
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `Team`');
+  $DbRow2 = $DbResult->fetch_row();
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `Team` WHERE (SELECT COUNT(*) FROM `User` WHERE `User`.`Team` = `Team`.`Id`) = 0');
+  $DbRow = $DbResult->fetch_row();
+  $System->Database->query('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`);');
+  $System->Database->query('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);
@@ -104 +104 @@
 function DeleteErrorLog()
 {
-  global $Database;
+  global $System;
   
-  $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);
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `Log` WHERE `Type`='.LOG_TYPE_ERROR);
+  $DbRow = $DbResult->fetch_row();
+  $System->Database->query('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/>');