source: quests/statistic.php@ 277

<?php

  include('includes/global.php');

?>

<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>
<br />
Poèet stáhnutí pøelo¾ených textù: <b>
<?php
       
      $ID = $Database->SQLCommand("SELECT count(distinct(IP)) FROM log WHERE type = 2");
      $Line = mysql_fetch_row($ID);
      echo $Line[0];
?>
</b><br /><br />
<b>Seznam u¾ivatelù: </b>
<table border="1" cellpadding="2" cellspacing="0">
<?php  

  if(array_key_exists('order', $_GET)) {
    $order = $_GET['order'];
    $desc = $_GET['desc'];
  } else {
    $order = 'NumberTranslate';
    $desc = '';
  }

  if ($desc == '') $desc = 'desc'; else $desc = '';

  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ø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>';

  $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,GM,
  (SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate,
  (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>';
          
          
  echo '</table>';
          
  ShowFooter();      
?>