Changeset 771 for trunk/img_level.php

Timestamp:

Jan 31, 2014, 12:49:46 AM (10 years ago)

Author:

chronos

Message:

• Modified: Do not execute UPDATE query on user list display.

File:

• trunk/img_level.php (modified) (1 diff)

trunk/img_level.php

@@ -107 +107 @@
   // Main code for users
   $DbResult = $System->Database->query('SELECT `ID`, `Name` FROM `User` WHERE `NeedUpdate` = 1');
-  while($LineUser = $DbResult->fetch_array()) 
+  if($DbResult->num_rows > 0)
   {
-    // Build TranslatedCount query
-    $TranslatedCount = '(';
-    if(count($TranslationTree) > 0)
+    while($LineUser = $DbResult->fetch_array()) 
     {
-          foreach($TranslationTree as $Group)
-      if($Group['TablePrefix'] != '')
+      // Build TranslatedCount query
+      $TranslatedCount = '(';
+      if(count($TranslationTree) > 0)
       {
-        $Count = '(SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`Language` <> '.
-          $Config['OriginalLanguage'].') AND (`User`='.$LineUser['ID'].'))';
-        $TranslatedCount .= 'COALESCE('.$Count.', 0) + ';
-      }
-      $TranslatedCount = substr($TranslatedCount, 0, -3).')';
-    } else $TranslatedCount = 0;
+            foreach($TranslationTree as $Group)
+        if($Group['TablePrefix'] != '')
+        {
+          $Count = '(SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`Language` <> '.
+            $Config['OriginalLanguage'].') AND (`User`='.$LineUser['ID'].'))';
+          $TranslatedCount .= 'COALESCE('.$Count.', 0) + ';
+        }
+        $TranslatedCount = substr($TranslatedCount, 0, -3).')';
+      } else $TranslatedCount = 0;
     
-    $xp = GetXPFromTranslation($LineUser['ID']); 
-    $System->Database->query('UPDATE `User` SET `XP` = '.$xp.', `TranslatedCount` = '.$TranslatedCount.' WHERE `User`.`ID` = '.$LineUser['ID']);
-    CreateImg('user', $LineUser['Name'], $xp);
+      $xp = GetXPFromTranslation($LineUser['ID']); 
+      $System->Database->query('UPDATE `User` SET `XP` = '.$xp.', `TranslatedCount` = '.$TranslatedCount.' WHERE `User`.`ID` = '.$LineUser['ID']);
+      CreateImg('user', $LineUser['Name'], $xp);
+    }
+
+    // Main code for translation teams
+    $DbResult = $System->Database->query('SELECT `ID`, `Name`, (SELECT AVG(`XP`) FROM `User` WHERE `Team` = `Team`.`Id`) AS `Average` '.
+      'FROM `Team` WHERE `ID` IN (SELECT `Team` FROM `User` WHERE `NeedUpdate` = 1)');
+    while($LineTeam = $DbResult->fetch_array()) 
+    {
+      CreateImg('team', $LineTeam['Name'], substr($LineTeam['Average'], 0, strpos($LineTeam['Average'],'.')));  //image creation
+    }
+    $System->Database->query('UPDATE `User` SET `NeedUpdate` = 0');
   }
-
-  // Main code for translation teams
-  $DbResult = $System->Database->query('SELECT `ID`, `Name`, (SELECT AVG(`XP`) FROM `User` WHERE `Team` = `Team`.`Id`) AS `Average` '.
-    'FROM `Team` WHERE `ID` IN (SELECT `Team` FROM `User` WHERE `NeedUpdate` = 1)');
-  while($LineTeam = $DbResult->fetch_array()) 
-  {
-    CreateImg('team', $LineTeam['Name'], substr($LineTeam['Average'], 0, strpos($LineTeam['Average'],'.')));  //image creation
-  }
-  $System->Database->query('UPDATE `User` SET `NeedUpdate` = 0');
 }