Changeset 293

Timestamp:

Jan 31, 2008, 9:47:31 PM (17 years ago)

Author:

maron

Message:

úprava statistiky

Location:

quests

Files:

• img_statistic.php (added)
• npc_statistic.php (deleted)
• page_statistic.php (deleted)
• quests_statistic.php (deleted)
• statistic.php (modified) (2 diffs)

quests/statistic.php

@@ -6 +6 @@
 
 <b>Statistika:</b><br>
- <img alt="quests" src="quests_statistic.php" title="statistika pøekladu úkolù" style="margin: 5px 0px 0px 0px;"><br />
- <img alt="npc_text" src="npc_statistic.php" title="statistika pøekladu NPC_textù" style="margin: 5px 0px 0px 0px;"><br />
- <img alt="npc_text" src="page_statistic.php" title="statistika pøekladu page_textù" style="margin: 5px 0px 0px 0px;"><br />
+ <img alt="quests" src="img_statistic.php?TypeText=quests" title="statistika pøekladu úkolù" style="margin: 5px 0px 0px 0px;"><br />
+ <img alt="npc_text" src="img_statistic.php?TypeText=npc_text" title="statistika pøekladu NPC_textù" style="margin: 5px 0px 0px 0px;"><br />
+ <img alt="page_text" src="img_statistic.php?TypeText=page_text" title="statistika pøekladu page_textù" style="margin: 5px 0px 0px 0px;"><br />
 
 <br>
@@ -57 +57 @@
   $ID = $Database->SQLCommand("
   SELECT ID,user, LastLogin, GM, (
-     (SELECT count(*) FROM `quests` WHERE User = user.ID AND Complete = 1) + 
-     (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND Complete = 1) +
-     (SELECT count(*) FROM `page_text` WHERE User = user.ID AND Complete = 1)
+     (SELECT count(*) FROM `quests` WHERE User = user.ID AND Complete = 1 AND Language <> 0) + 
+     (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0) +
+     (SELECT count(*) FROM `page_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
    ) as NumberTranslate, (
-       IFNULL((SELECT sum(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1),0)
-     + IFNULL((SELECT sum(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1),0)
-     + IFNULL((SELECT sum(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1),0)
+       IFNULL((SELECT sum(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
+     + IFNULL((SELECT sum(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
+     + IFNULL((SELECT sum(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
      ) / (
-       (SELECT count(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1)
-     + (SELECT count(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1)
-     + (SELECT count(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1)
+       (SELECT count(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1 AND Language <> 0)
+     + (SELECT count(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1 AND Language <> 0)
+     + (SELECT count(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1 AND Language <> 0)
      ) AS Vote
    FROM `user` ORDER BY $order $desc");