source: trunk/img_statistic.php@ 57

Last change on this file since 57 was 57, checked in by george, 16 years ago
  • Upraveno: Stránka statistika rozdělena na stránky Stav dokončení a Seznam uživatelů.
  • Přidáno: Stránkování seznamu uživatelů.
  • Opraveno: Přidány indexy do tabulek překladů pro sloupce Complete a Language. Díky tomu se výrazně zrychlilo zobrazení seznamu uživatelů.
File size: 2.0 KB
Line 
1<?php
2
3session_start();
4include('includes/config.php');
5include('includes/databaseconection.php');
6include('includes/global_function.php');
7
8// SQL injection hack protection
9foreach($_POST as $Index => $Item) $_POST[$Index] = addslashes($_POST[$Index]);
10foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($_GET[$Index]);
11
12// Open database connection
13$Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']);
14$Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
15$Database->SelectDatabase($Config['Database']['Database']);
16
17$FontFile = 'images/FRIZQT__.ttf';
18$TranslationTree = GetTranslationTree();
19$Group = $TranslationTree[$_GET['group']];
20
21$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE (Language <> 0) AND (Complete = 1)'));
22$NumberTranslate = $ID[0];
23
24$ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Group['TablePrefix'].' WHERE (Language = 0)'));
25$NumberAJ = $ID[0];
26
27if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; else $Percent = 0;
28$Percent = substr($Percent, 0, 5);
29
30$PercentBar = $Percent * 4;
31$Image = ImageCreateTrueColor(400, 32);
32$Color1 = imagecolorallocate($Image, 225, 246, 247);
33$Color2 = imagecolorallocate($Image, 77, 225, 251);
34$Color3 = imagecolorallocate($Image, 2, 9, 199);
35imagefilledrectangle($Image, 0, 0, 400, 31, $Color1);
36imagefilledrectangle($Image, 0, 0, $PercentBar, 59, $Color2);
37$FontSize = 10;
38ImageTTFText($Image, $FontSize, 0, 120, 13, $Color3, $FontFile, $NumberTranslate.'/'.$NumberAJ);
39ImageTTFText($Image, $FontSize, 0, 240, 13, $Color3, $FontFile, $Group['Name']);
40ImageTTFText($Image, $FontSize, 0, 120, 29, $Color3, $FontFile, $Percent.'%');
41$FontSize = 6;
42ImageTTFText($Image, $FontSize, 0, 240, 28, $Color3, $FontFile, 'Aktualizace: '.date("m.d.y H:i"));
43
44Header("Content-type: image/png");
45ImagePNG($Image);
46ImageDestroy($Image);
47
48?>
Note: See TracBrowser for help on using the repository browser.