Changeset 295 for quests/statistic.php

Timestamp:

Feb 7, 2008, 5:27:54 PM (17 years ago)

Author:

maron

Message:

Client texty - zatím bez zobrazení na webu, oprava logu, oprava shoutboxu, ukládání webů, na kterých je banner

File:

• quests/statistic.php (modified) (3 diffs)

quests/statistic.php

@@ -6 +6 @@
 
 <b>Statistika:</b><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 />
+ <img alt="quests" src="img_statistic.php?TypeText=quests" title="statistika pøekladu úkolù" style="margin: 2px 0px 0px 0px;"><br />
+ <img alt="npc_text" src="img_statistic.php?TypeText=npc_text" title="statistika pøekladu NPC_textù" style="margin: 2px 0px 0px 0px;"><br />
+ <img alt="page_text" src="img_statistic.php?TypeText=page_text" title="statistika pøekladu page_textù" style="margin: 2px 0px 0px 0px;"><br />
+<?php // <img alt="page_text" src="img_statistic.php?TypeText=client_text" title="statistika pøekladu client_textù" style="margin: 2px 0px 0px 0px;"><br />
+?>
 
 <br>
@@ -36 +38 @@
 
   echo '<tr><th><a href="statistic.php?order=user&amp;desc='.$desc.'">Jméno</a></th>
-  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených questù">Pøelo¾ených</a></th>
-  <th><a href="statistic.php?order=Vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Prùmìrná známka</a></th>
+  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených textù">Pøelo¾ených</a></th>
+  <th><a href="statistic.php?order=Vote&amp;desc='.$desc.'" Title="Prùmìrná známka textù">Prùmìrná známka</a></th>
   <th><a href="statistic.php?order=GM&amp;desc='.$desc.'">Oprávnìní</a></th>
   <th><a href="statistic.php?order=LastLogin&amp;desc='.$desc.'">Poslední pøipojení</a></th></tr>';
@@ -57 +59 @@
   $ID = $Database->SQLCommand("
   SELECT ID,user, LastLogin, GM, (
-     (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)
+     (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)
+    + (SELECT count(*) FROM `client_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 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)
+     + IFNULL((SELECT sum(Vote) AS Vote FROM `client_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 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)
+     + (SELECT count(Vote) AS Vote FROM `client_text` WHERE User = user.ID AND Complete =1 AND Language <> 0)
      ) AS Vote
    FROM `user` ORDER BY $order $desc");