Changeset 251 for quests/statistic.php

Timestamp:

Jan 20, 2008, 8:44:37 PM (17 years ago)

Author:

maron

Message:

NPC_text

File:

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

quests/statistic.php

@@ -5 +5 @@
 ?>
 
-<b>Statistika pøelo¾ených questù:</b><br>
+<b>Statistika:</b><br>
  <img alt="quests" src="quests_statistic.php" title="statistika pøekladu úkolù"><br />
+<br />
+ <img alt="npc_text" src="npc_statistic.php" title="statistika pøekladu NPC_textù"><br />
 <br />
 <b>Statistika v závislosti na èase: </b><a href="http://game-server.zdechov.net/statistic/?Measure=18">Pøelo¾ených textù</a><br>
@@ -33 +35 @@
 
   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ù">Známka</a></th>
+  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených questù">Pøel. Q.</a></th>
+  <th><a href="statistic.php?order=NumberTranslateNPC&amp;desc='.$desc.'" Title="Poèet pøelo¾ených NPC_textù">Pøel. N.</a></th>
+  <th><a href="statistic.php?order=vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Z. Q</a></th>
+  <th><a href="statistic.php?order=voteNPC&amp;desc='.$desc.'" Title="Prùmìrná známka NPC_text">Z. N.</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>';
@@ -40 +44 @@
   $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,GM,
   (SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate,
-  (SELECT avg(vote) FROM `quests` WHERE User = user.id AND Complete = 1) as vote
+  (SELECT count(*) FROM `npc_text` WHERE User = user.id AND User <> 0) as NumberTranslateNPC,
+  (SELECT avg(vote) FROM `quests` WHERE User = user.id AND Complete = 1) as vote,
+  (SELECT avg(Vote) FROM `npc_text` WHERE User = user.id AND Complete = 1) as voteNPC
    FROM `user` ORDER BY $order $desc");
       while ($Line = mysql_fetch_array($ID))
         echo '<tr><td>'.$Line['user'].'</td>
         <td>'.$Line['NumberTranslate'].'</td>
+        <td>'.$Line['NumberTranslateNPC'].'</td>
         <td>'.substr($Line['vote'], 0, 4).'</td>
+        <td>'.substr($Line['voteNPC'], 0, 4).'</td>
         <td>'.$Moderators[$Line['GM']].'</td>
         <td>'.$Line['LastLogin'].'</td></tr>';