Changeset 365 for trunk/img_level.php

Timestamp:

Mar 9, 2010, 11:29:05 AM (15 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/img_level.php (modified) (4 diffs)

trunk/img_level.php

@@ -72 +72 @@
           else $groupby .= ', '.$TextItem['Column'];
       } 
-      $IDtran = $Database->SQLCommand('SELECT * FROM `'.$Group['TablePrefix'].'` WHERE User = '.$user_ID.' AND Complete = 1 '.$groupby);
+      $IDtran = $Database->SQLCommand('SELECT * FROM `'.$Group['TablePrefix'].'` WHERE `User` = '.$user_ID.' AND `Complete` = 1 '.$groupby);
       while($Line = mysql_fetch_array($IDtran)) 
       {   //jednotlivé překlady
@@ -106 +106 @@
 
   // Hlavní kod pro uživatele
-  $ID = $Database->SQLCommand('SELECT `ID`, `user` FROM `user` WHERE `NeedUpdate` = 1');
+  $ID = $Database->SQLCommand('SELECT `ID`, `Name` FROM `User` WHERE `NeedUpdate` = 1');
   while($LineUser = mysql_fetch_array($ID)) 
   {
@@ -120 +120 @@
     
     $xp = GetXPFromTranslation($LineUser['ID']); 
-    $Database->SQLCommand('UPDATE `user` SET `XP` = '.$xp.', `TranslatedCount` = '.$TranslatedCount.' WHERE `user`.`ID` = '.$LineUser['ID']);
-    CreateImg('user', $LineUser['user'], $xp);
+    $Database->SQLCommand('UPDATE `User` SET `XP` = '.$xp.', `TranslatedCount` = '.$TranslatedCount.' WHERE `User`.`ID` = '.$LineUser['ID']);
+    CreateImg('user', $LineUser['Name'], $xp);
   }
 
   // Hlavní kod pro překladatelské týmy
-  $ID = $Database->SQLCommand('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)');
+  $ID = $Database->SQLCommand('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 = mysql_fetch_array($ID)) 
   {
-    CreateImg('team', $LineTeam['name'], substr($LineTeam['average'], 0, strpos($LineTeam['average'],'.')));  //vytváření obrázku
+    CreateImg('team', $LineTeam['Name'], substr($LineTeam['Average'], 0, strpos($LineTeam['Average'],'.')));  //vytváření obrázku
   }
-  $Database->SQLCommand('UPDATE `user` SET `NeedUpdate` = 0');
+  $Database->SQLCommand('UPDATE `User` SET `NeedUpdate` = 0');
 }
 
@@ -138 +138 @@
   
   // Do update for all users
-  $Database->SQLCommand('UPDATE `user` SET `NeedUpdate` = 1');
+  $Database->SQLCommand('UPDATE `User` SET `NeedUpdate` = 1');
   ImgLevelUpdate();
   
   echo('<strong>Uživatelé</strong><br/>');
-  $ID = $Database->SQLCommand('SELECT `ID`, `user` FROM `user`');
+  $ID = $Database->SQLCommand('SELECT `ID`, `Name` FROM `User`');
   while($LineUser = mysql_fetch_array($ID)) 
   {
-    echo('<img src="tmp/user/'.$LineUser['user'].'/level.png" /> '.$LineUser['user'].'<br />');
+    echo('<img src="tmp/user/'.$LineUser['Name'].'/level.png" /> '.$LineUser['Name'].'<br />');
   }
 
   echo('<br/><strong>Týmy</strong><br/>');
-  $ID = $Database->SQLCommand('SELECT ID, Name FROM Team');
+  $ID = $Database->SQLCommand('SELECT `ID`, `Name` FROM `Team`');
   while($LineTeam = mysql_fetch_array($ID)) 
   {