<?php
session_start();
include('includes/config.php');
include('includes/databaseconection.php');

//připojení do databáze
$Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
$Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
$Database->SelectDatabase($Config['Database']['Database']);    



  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(distinct(entry)) FROM page_text WHERE Language <> '0' AND Complete = '1'"));
  $NumberTranslate = $ID[0];
  
  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM page_text WHERE Language = '0'"));
  $NumberAJpage = $ID[0];

  $Percent = ($NumberTranslate/$NumberAJpage)*100;
  $Percent = substr($Percent, 0, 5);

  $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.'/'.$NumberAJpage, $Color3);
  imagestring($obrazek, 3, 300, 15, 'page_texty', $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);
  imagedestroy($obrazek);
  
 // echo '<img src="statistic.png">';
          
?>
