Changeset 111 for trunk/img_level.php

Timestamp:

Feb 19, 2009, 4:28:50 PM (15 years ago)

Author:

maron

Message:

Optimalizace načítání obrázků (změna struktury)

File:

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

trunk/img_level.php

@@ -93 +93 @@
 
 //hlavní kod
-if ($nothide) 
-        $ID = $Database->SQLCommand('SELECT * FROM user');
-else
-        $ID = $Database->SQLCommand('SELECT * FROM user WHERE DATE_SUB(NOW(), INTERVAL 2 DAY) < LastLogin');
+        if ($nothide) $ID = $Database->SQLCommand('SELECT ID,user FROM user');
+        else $ID = $Database->SQLCommand('SELECT ID,user FROM user WHERE NeedUpdate = 1');
+
 while ($LineUser = mysql_fetch_array($ID)) {
-        $xp = GetXPFromTranslation($LineUser['ID']);
-        $Database->SQLCommand('UPDATE user SET XP = '.$xp.' WHERE ID = '.$LineUser['ID']);
-        CreateImg($LineUser['user'],$xp);
-if ($nothide)   echo ('<img src="tmp/'.$LineUser['user'].'/level.png" /><br>');
+        $xp = GetXPFromTranslation($LineUser['ID']); //načítání XP
+        $Database->SQLCommand('UPDATE user SET XP = '.$xp.' WHERE ID = '.$LineUser['ID']);  //ukládání XP pro řazení
+        CreateImg($LineUser['user'],$xp);  //vytváření obrázku
+        if ($nothide)   echo ('<img src="tmp/'.$LineUser['user'].'/level.png" /><br>');
 }
+        $Database->SQLCommand('UPDATE user SET NeedUpdate = 0');
 
 if ($nothide) ShowFooter();