source: quests/UpdateStatistic.php@ 167

<?php


    //zji‘tìní pøeložených
    $NumberTranslate = 0;
/*    $LastEntry = '';
 //   $Database->SelectDatabase('Quests');    
    $ID = $Database->SQLCommand("SELECT * FROM czquests");
    while ($Line = mysql_fetch_array($ID)) {
      If ($Line['entry'] <> $LastEntry) {
        ++$NumberTranslate;  
        $LastEntry = $Line['entry'];
      } else {
        //stejný Q
      }
    } */

    $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM czquests WHERE State = '2'"));
    $NumberTranslate = $ID[0];
 //   echo $NumberTranslate;
    //zji‘tìní v‘ech
   // $AJQuests = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM ajquests"));
 //   $NumberTranslate = 4000;
 // echo '<br>Pøeloženo:<br>';

   $NumberAJQuests = ReadVar('NumberQuests');
    $Percent = ($NumberTranslate/$NumberAJQuests)*100;
   // echo $Percent;
  //  echo $NumberTranslate.'/'.ReadVar('NumberQuests').'<br>';
 //   $Database->Disconnect();

  $PercentBar = $Percent*4;
  $obrazek = imagecreatetruecolor(400,60);
  $Color1 = imagecolorallocate($obrazek,225,246,247);
  $Color2 = imagecolorallocate($obrazek,77,225,251);
  $Color3 = imagecolorallocate($obrazek,2,59,199);
  imagefilledrectangle($obrazek,0,0,400,59,$Color1);
  imagefilledrectangle($obrazek,0,0,$PercentBar,59,$Color2);
  imagestring($obrazek, 10, 120, 15, $NumberTranslate.'/'.$NumberAJQuests, $Color3);
  imagestring($obrazek, 10, 120, 30, $Percent.' %', $Color3);
  imagestring($obrazek, 1, 240, 50, 'Aktualizováno: '.date("m.d.y  H:i"), $Color3);
 // header('Content-Type: image/png');
  imagepng($obrazek,'percent.png');
  imagedestroy($obrazek);

  $ID = $Database->SQLCommand("SELECT * FROM user");
  while ($LineUser = mysql_fetch_array($ID)) {
      $User = $LineUser['user'];
      $Number = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM czquests WHERE user='$User' AND complete = '1'"));
    //  echo $Line[0];
      $Database->SQLCommand("Update user SET NumberTranslateQuests = '$Number[0]' WHERE user='$User'");
  }

  $Soubor = fopen('UserTranslate.php', 'w');
  $ID = $Database->SQLCommand("SELECT * FROM user order by 6 DESC");
  while ($Line = mysql_fetch_array($ID)) {
    fputs($Soubor,'<tr><td>'.$Line['user'].'</td><td>'.$Line['NumberTranslateQuests'].'</td></tr>
    ');
  }  
  fclose($Soubor);



?>