source: quests/statistic.php@ 293

<?php

  include('includes/global.php');

?>

<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 />

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

/*
SELECT 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)
   ) as NumberTranslate, (
     SELECT IFNULL((SELECT AVG(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1),0)
     + IFNULL((SELECT AVG(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1),0)
     + IFNULL((SELECT AVG(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1),0)
     ) /3 AS Vote
   FROM `user`
   
   */

  $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)
   ) 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)
     ) / (
       (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");
   
      while ($Line = mysql_fetch_array($ID)) {
              
        if (Licence(1)) 
          $Name = '<a href="user.php?user='.$Line['ID'].'">'.$Line['user'].'</a>';
        else 
          $Name = $Line['user'];
        
        echo '<tr><td>'.$Name.'</td>
        <td>'.$Line['NumberTranslate'].'</td>
        <td>'.substr($Line['Vote'], 0, 4).'</td>
        <td>'.$Moderators[$Line['GM']].'</td>
        <td>'.$Line['LastLogin'].'</td></tr>';
          
      }
          
  echo '</table>';
          
  ShowFooter();      
?>