Changeset 288 for quests/statistic.php

Timestamp:

Jan 30, 2008, 9:40:23 PM (17 years ago)

Author:

maron

Message:

oprava emailu

File:

• quests/statistic.php (modified) (1 diff)

quests/statistic.php

@@ -57 +57 @@
   $ID = $Database->SQLCommand("
   SELECT ID,user, LastLogin, GM, (
-     (SELECT count(*) FROM `quests` WHERE User = user.ID AND User <> 0 AND Complete = 1) + 
-     (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND User <> 0 AND Complete = 1) +
-     (SELECT count(*) FROM `page_text` WHERE User = user.ID AND User <> 0 AND Complete = 1)
+     (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)
    ) as NumberTranslate, (
        IFNULL((SELECT sum(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1),0)