Changeset 111 for trunk

Timestamp:

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

Author:

maron

Message:

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

Location:

trunk

Files:

• img_level.php (modified) (1 diff)
• save.php (modified) (1 diff)
• sql/structure.sql (modified) (1 diff)
• sql/updates/111.sql (added)

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();      

trunk/save.php

@@ -49 +49 @@
         //echo($sql);
     $Database->SQLCommand($sql);
+    $Database->SQLCommand('UPDATE `user` SET `NeedUpdate` = 1 WHERE ID = '.$UserID); //informace o nutnosti načíst XP
     //  echo $sql.'<br />';      
     echo('Změny v překladu: <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> uloženy!<br />');

trunk/sql/structure.sql

@@ -446 +446 @@
   `Language` int(11) NOT NULL default '1',
   `ExportSetting` text collate utf8_czech_ci NOT NULL,
+  `XP` int(11) NOT NULL default '0',
+  `NeedUpdate` int(11) NOT NULL default '0',
   PRIMARY KEY  (`ID`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=553 ;