Changeset 56

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.

Location:

trunk

Files:

• fill_database.php (modified) (1 diff)
• images/FRIZQT__.ttf (added)
• images/MORPHEUS.ttf (added)
• images/SKURRI.ttf (added)
• img_statistic.php (modified) (2 diffs)
• sql/updates/56.sql (added)
• statistic.php (modified) (1 diff)

trunk/fill_database.php

@@ -11 +11 @@
   {
         echo('<br />'.$Group['Name'].'<br />');
-        $Columns = '`'.$Config['Database']['DatabaseMangos'].'`.`'.$Group['MangosTable'].'`.`'.$Group['MangosTableIndex'].'`';
+        $Columns = '`'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`.`'.$Group['MangosTableIndex'].'`';
         foreach($Group['Items'] as $GroupItem)
-          $Columns .= ', `'.$Config['Database']['DatabaseMangos'].'`.`'.$Group['MangosTable'].'`.`'.$GroupItem['MangosColumn'].'` AS `'.$GroupItem['Column'].'`';
-        $Query = 'SELECT '.$Columns.' FROM `'.$Config['Database']['DatabaseMangos'].'`.`'.$Group['MangosTable'].'`'; 
+          $Columns .= ', `'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`.`'.$GroupItem['MangosColumn'].'` AS `'.$GroupItem['Column'].'`';
+        $Query = 'SELECT '.$Columns.' FROM `'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`'; 
         //echo($Query.'<br />');        
         $Count = 0;

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); 
+           
 ?>

trunk/statistic.php

@@ -5 +5 @@
 echo('<strong>Statistika:</strong><br />');
 foreach($TranslationTree as $Group)
-  if($Group['TablePrefix'] != '') echo('<img alt="'.$Group['TablePrefix'].'" src="img_statistic.php?TypeText='.$Group['TablePrefix'].'" title="statistika překladů '.$Group['Name'].'" style="margin: 2px 0px 0px 0px;" /><br />');
+  if($Group['TablePrefix'] != '') 
+        echo('<img alt="'.$Group['TablePrefix'].'" src="img_statistic.php?group='.$Group['Id'].'" title="statistika překladů '.$Group['Name'].'" style="margin: 2px 0px 0px 0px;" /><br />');
 
 echo('<br />