<?php

  include('includes/global.php');
  
  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(entry) FROM quests WHERE Language <> '0' AND Complete = '1'"));
  $NumberTranslate = $ID[0];
  
  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM quests WHERE Language = '0'"));
  $NumberAJQuests = $ID[0];

  $Percent = ($NumberTranslate/$NumberAJQuests)*100;

  $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,'statistic.png');
  imagedestroy($obrazek);
  
  echo '<img src="statistic.png">';
          
  ShowFooter();      
?>
