Changeset 302 for trunk/img_level.php

Timestamp:

Dec 29, 2009, 12:58:13 PM (15 years ago)

Author:

george

Message:

• Upraveno: Tabulka týmů doplněna o položy URL web stránek, identifikaci vůdce týmu a času vytvoření týmu.
• Opraveno: Vstupování do týmů ze stránky nastavení překladatele.

File:

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

trunk/img_level.php

@@ -118 +118 @@
 
 // Hlavní kod pro překladatelské týmy
-if($nothide) $ID = $Database->SQLCommand('SELECT ID,name,(SELECT avg(XP) FROM user WHERE team = team.ID) as average FROM team');
-  else $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)');
+if($nothide) $ID = $Database->SQLCommand('SELECT ID,name,(SELECT avg(XP) FROM user WHERE team = Team.Id) as average FROM Team');
+  else $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)) 
 {