Changeset 449 for trunk/statistic.php

Timestamp:

Apr 12, 2010, 8:00:41 PM (15 years ago)

Author:

george

Message:

• Upraveno: Informaci o dostupných verzích vyčítat přímo z tabulky ClientVersion sloupce Imported namísto složitých detekcí.

File:

• trunk/statistic.php (modified) (3 diffs)

trunk/statistic.php

@@ -3 +3 @@
 include('includes/global.php');
 
-  if (array_key_exists('Version',$_GET)) 
-    $_SESSION['StatVersion'] = $_GET['Version'];
-  else 
-    if (!array_key_exists('StatVersion',$_SESSION)) 
-      $_SESSION['StatVersion'] = $Config['Web']['GameVersion'];
+if(array_key_exists('Version', $_GET)) $_SESSION['StatVersion'] = $_GET['Version'];
+if(!array_key_exists('StatVersion', $_SESSION)) $_SESSION['StatVersion'] = $Config['Web']['GameVersion'];
 
 function ShowStatTable()
@@ -57 +54 @@
     $Total += $Group['Total'];
   }
-  if ($Total <> '') 
-    echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Translated.'</strong></td><td><strong>'.$Total.'</strong></td><td><strong>'.ProgressBar(150, round($Translated / $Total * 100, 2)).'</strong></td></tr>');
-  else
-    echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Translated.'</strong></td><td><strong>'.$Total.'</strong></td><td><strong>'.ProgressBar(150, 0).'</strong></td></tr>');
+  if($Total <> 0) $TotalCount = round($Translated / $Total * 100, 2);
+    else $Total = 0;
+  echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Translated.'</strong></td><td><strong>'.$Total.'</strong></td><td><strong>'.ProgressBar(150, $Total).'</strong></td></tr>');
   echo('</table>');
 }
@@ -66 +62 @@
 ShowPage();
   
-  $ConfigVersion = $Config['Web']['GameVersion'];
-  echo ('Zobrazit statistiku pro verzi: <br />');
-  echo ('<a href="?Version=2.4.3">2.4.3</a> ');
-  $DbResult = $Database->SQLCommand('SELECT Version, Title FROM `ClientVersion` WHERE BuildNumber > 8209 AND Title <> "" ORDER BY Version');
-  while($DbRow = mysql_fetch_assoc($DbResult))
-  {   
-          if ($DbRow['Version'] == $Config['Web']['GameVersion']) $ConfigVersion = false;
-          echo ('<a href="?Version='.$DbRow['Version'].'" Title="'.$DbRow['Title'].'">'.$DbRow['Version'].'</a> ');
-  }
-  $DbResult = $Database->SQLCommand('SELECT MAX(Version) as max FROM `ClientVersion`');
-  $DbRow = mysql_fetch_assoc($DbResult);
-  if (($ConfigVersion <> false) and ($ConfigVersion <> $DbRow['max'])) echo ('<a href="?Version='.$ConfigVersion.'">'.$ConfigVersion.'</a> ');
-  echo ('<a href="?Version='.$DbRow['max'].'">'.$DbRow['max'].'</a> ');
+// Show client version selection
+echo('Zobrazit statistiku pro verzi: ');
+$DbResult = $System->Database->query('SELECT `Version`, `Title` FROM `ClientVersion` WHERE `Imported`=1 ORDER BY `Version`');
+while($DbRow = $DbResult->fetch_assoc())
+{   
+  echo('<a href="?Version='.$DbRow['Version'].'" title="'.$DbRow['Title'].'">'.$DbRow['Version'].'</a> ');
+}
 
-echo('<h3>Statistika dokončení překladů pro verzi '.$_SESSION['StatVersion'].'</h3><br/>Jazyk: <a href="statistic.php">Dohromady</a>');
+// Show language selection
+echo('<br /><br /><h3>Statistika dokončení překladů pro verzi '.$_SESSION['StatVersion'].'</h3><br/>');
+echo('Jazyk: <a href="statistic.php">Dohromady</a>');
 foreach($LanguageList as $Language) 
   if($Language['Enabled'] == 1) echo(' <a href="?language='.$Language['Id'].'">'.$Language['Name'].'</a>');