source: trunk/img_statistic.php@ 49

<?php
session_start();
include('includes/config.php');
include('includes/databaseconection.php');

// SQL injection hack protection
foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($_POST[$Index]);
foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($_GET[$Index]);

//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']);    

  $TypeTexts = $_GET['TypeText'];

//  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 Language <> '0' AND Complete = '1'"));
  $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, 40);
  $Color1 = imagecolorallocate($obrazek, 225, 246, 247);
  $Color2 = imagecolorallocate($obrazek, 77, 225, 251);
  $Color3 = imagecolorallocate($obrazek, 2, 9, 199);
  imagefilledrectangle($obrazek, 0, 0, 400, 39, $Color1);
  imagefilledrectangle($obrazek, 0, 0, $PercentBar, 59, $Color2);
  imagestring($obrazek, 10, 120, 5, $NumberTranslate.'/'.$NumberAJ, $Color3);
  imagestring($obrazek, 3, 300, 5, $TypeTexts, $Color3);
  imagestring($obrazek, 10, 120, 20, $Percent.' %', $Color3);
  imagestring($obrazek, 1, 240, 30, 'Aktualizace: '.date("m.d.y  H:i"), $Color3);
 
  header('Content-Type: image/png');
  imagepng($obrazek);
  imagedestroy($obrazek);
  
 // echo '<img src="statistic.png">';
          
?>