Changeset 56 for trunk/img_statistic.php

Timestamp:

Feb 2, 2009, 10:53:29 PM (15 years ago)

Author:

george

Message:

• Přidáno: Fonty z WoW.
• Upraveno: Zobrazování obrázků stavu dokončení ve statistice pomocí ttf fontů.
• Přidáno: Adresování odlišných databází zdrojů textů.
• Přidáno: Texty skriptů a EventAI ScriptDev2.

File:

• trunk/img_statistic.php (modified) (2 diffs)

trunk/img_statistic.php

@@ -1 +1 @@
 <?php
+
 session_start();
 include('includes/config.php');
 include('includes/databaseconection.php');
+include('includes/global_function.php');
 
 // SQL injection hack protection
@@ -8 +10 @@
 foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($_GET[$Index]);
 
-//připojení do databáze
+// Open database connection
 $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'];
+$FontFile = 'images/FRIZQT__.ttf';
+$TranslationTree = GetTranslationTree();
+$Group = $TranslationTree[$_GET['group']];
 
-//  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(distinct(entry)) FROM ".$Group['TablePrefix']." 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];
+$ID = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM ".$Group['TablePrefix']." WHERE Language = '0'"));
+$NumberAJ = $ID[0];
 
-  $Percent = ($NumberTranslate / $NumberAJ) * 100;
-  $Percent = substr($Percent, 0, 5);
+if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; else $Percent = 0;
+$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">';
-          
+$PercentBar = $Percent * 4;
+$Image = ImageCreateTrueColor(400, 32);
+$Color1 = imagecolorallocate($Image, 225, 246, 247);
+$Color2 = imagecolorallocate($Image, 77, 225, 251);
+$Color3 = imagecolorallocate($Image, 2, 9, 199);
+imagefilledrectangle($Image, 0, 0, 400, 31, $Color1);
+imagefilledrectangle($Image, 0, 0, $PercentBar, 59, $Color2);
+$FontSize = 10;
+ImageTTFText($Image, $FontSize, 0, 120, 13, $Color3, $FontFile, $NumberTranslate.'/'.$NumberAJ);
+ImageTTFText($Image, $FontSize, 0, 240, 13, $Color3, $FontFile, $Group['Name']);
+ImageTTFText($Image, $FontSize, 0, 120, 29, $Color3, $FontFile, $Percent.'%');
+$FontSize = 6;
+ImageTTFText($Image, $FontSize, 0, 240, 28, $Color3, $FontFile, 'Aktualizace: '.date("m.d.y  H:i"));
+
+Header("Content-type: image/png"); 
+ImagePNG($Image); 
+ImageDestroy($Image); 
+           
 ?>