<?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']);    

  include ('define.php');

for ($i=0;$i<count($define_images);++$i) {
  	
  $TypeTexts = $define_images[$i]["sql"];
  echo $define_images[$i]["File"];

//  echo  "SELECT count(distinct(entry)) FROM $TypeTexts WHERE Language <> '0' AND Complete = '1'";
  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(distinct(entry)) FROM $TypeTexts WHERE ".$define_images[$i]["where"]));
  $NumberTranslate = $ID[0];
  
  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM $TypeTexts WHERE Language = '0'"));
  $NumberAJ = $ID[0];

  $Percent = ($NumberTranslate/$NumberAJ)*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.'/'.$NumberAJ, $Color3);
  imagestring($obrazek, 3, 300, 15, $TypeTexts, $Color3);
  imagestring($obrazek, 10, 120, 30, $Percent.' %', $Color3);
  imagestring($obrazek, 1, 240, 50, 'Aktualizováno: '.date("m.d.y  H:i"), $Color3);
  
  imagepng($obrazek, 'compile_png/'.$define_images[$i]["File"].'.png');
  imagedestroy($obrazek);
  echo ': <b>HOTOVO</b><br />';
}
  
  
 // echo '<img src="statistic.png">';
          
?>
