Changeset 286 for trunk/includes/global_function.php

Timestamp:

Dec 22, 2009, 10:22:38 AM (15 years ago)

Author:

george

Message:

• Opraveno: Kontrola správného zadání Id překladové skupiny.
• Opraveno: Kontrola správného zadání Id překladového jazyka.
• Upraveno: Zobrazovat PageFooter pouze pokud již byl zobrazen PageHeader.
• Opraveno: Chyba určení počtu stránek pro zobrazení stránkování.

File:

• trunk/includes/global_function.php (modified) (6 diffs)

trunk/includes/global_function.php

@@ -36 +36 @@
   $Around = round($Config['Web']['VisiblePagingItems'] / 2);
   $Result = '';
-  $PageCount = ceil($TotalCount / $ItemPerPage);
+  $PageCount = floor($TotalCount / $ItemPerPage) + 1;
   
   if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 0;
@@ -43 +43 @@
   if($_SESSION['Page'] >= $PageCount) $_SESSION['Page'] = $PageCount - 1;
   $CurrentPage = $_SESSION['Page'];
+  
         
   $Result .= 'Počet položek: <strong>'.$TotalCount.'</strong> &nbsp; Stránky: ';
@@ -184 +185 @@
   
   $Result = array();
-  $DbResult = $Database->SQLCommand('SELECT * FROM `language`');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `language` WHERE `Enabled` = 1');
   while($DbRow = mysql_fetch_assoc($DbResult))
     $Result[$DbRow['Id']] = $DbRow;
@@ -278 +279 @@
     if($Prev) echo('<a href="form.php?group='.$GroupId.'&amp;ID='.$Next['ID'].'">Předcházející '.$Next['ID'].'</a> ');
     else echo('<a href="form.php?group='.$GroupId.'&amp;ID='.$Next['ID'].'">Následující '.$Next['ID'].'</a> ');
-       return 'form.php?group='.$GroupId.'&amp;ID='.$Next['ID'];
-  }
-}
-
+      return 'form.php?group='.$GroupId.'&amp;ID='.$Next['ID'];
+  }
+}
 
 function HaveSameText($Group, $DbRow2, $Value)
@@ -334 +334 @@
 function GetBuildNumber($Version)
 {
-  global $Database,$BuildNumbers;
-  
-  if (isset($BuildNumbers[$Version]) == false) 
-  {
-    $sql = 'SELECT BuildNumber FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+  global $Database, $BuildNumbers;
+  
+  if(isset($BuildNumbers[$Version]) == false) 
+  {
+    $sql = 'SELECT `BuildNumber` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
     $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
     $BuildNumbers[$Version] = $DbRow['BuildNumber'];
@@ -347 +347 @@
 function GetVersionWOW($BuildNumber)
 {
-  global $Database,$VersionsWOW;
-  if (isset($VersionsWOW[$BuildNumber]) == false) 
-  {
-    $sql = 'SELECT Version FROM `wow_client_version` WHERE BuildNumber = "'.$BuildNumber.'"';
+  global $Database, $VersionsWOW;
+  
+  if(isset($VersionsWOW[$BuildNumber]) == false) 
+  {
+    $sql = 'SELECT `Version` FROM `wow_client_version` WHERE `BuildNumber` = "'.$BuildNumber.'"';
     $Version = mysql_fetch_assoc($Database->SQLCommand($sql));
     $VersionsWOW[$BuildNumber] = $Version['Version'];
   }
-    return($VersionsWOW[$BuildNumber]);
-}
-
-function GetDBCColumns($Version,$DBCFileName)
-{
-  global $Database,$DBCColumns;
-  if (isset($DBCColumns[$Version][$DBCFileName]) == false) 
-  {
-    $sql = 'SELECT DBCColumns_'.$DBCFileName.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+  return($VersionsWOW[$BuildNumber]);
+}
+
+function GetDBCColumns($Version, $DBCFileName)
+{
+  global $Database, $DBCColumns;
+  
+  if(isset($DBCColumns[$Version][$DBCFileName]) == false) 
+  {
+    $sql = 'SELECT `DBCColumns_'.$DBCFileName.'` AS `DBCColumns` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
     $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
     $DBCColumns[$Version][$DBCFileName] = $DbRow['DBCColumns'];
   }
-    return($DBCColumns[$Version][$DBCFileName]);
-}
-
-function GetDBCColumnIndex($Version,$DBCFileName,$Column)
-{
-  global $Database,$DBCColumnIndex;
-  if (isset($DBCColumnIndex[$Version][$DBCFileName][$Column]) == false) 
-  {
-    $sql = 'SELECT '.$DBCFileName.'_'.$Column.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+  return($DBCColumns[$Version][$DBCFileName]);
+}
+
+function GetDBCColumnIndex($Version, $DBCFileName, $Column)
+{
+  global $Database, $DBCColumnIndex;
+  
+  if(isset($DBCColumnIndex[$Version][$DBCFileName][$Column]) == false) 
+  {
+    $sql = 'SELECT `'.$DBCFileName.'_'.$Column.'` AS `DBCColumns` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
     $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
     $DBCColumnIndex[$Version][$DBCFileName][$Column] = $DbRow['DBCColumns'];
   }
-    return($DBCColumnIndex[$Version][$DBCFileName][$Column]);
+  return($DBCColumnIndex[$Version][$DBCFileName][$Column]);
+}
+
+function LoadGroupIdParameter()
+{
+  global $TranslationTree;
+  
+  if(array_key_exists('group', $_GET)) $GroupId = $_GET['group'] * 1; 
+    else $GroupId = 1;
+  
+  if(isset($TranslationTree[$GroupId]) == false)
+  {
+    echo('Překladová skupina dle zadaného Id neexistuje.');
+    ShowFooter();
+    die();
+  }
+  return($GroupId);
+}
+
+function LoadLanguageIdParameter()
+{
+  global $LanguageList;
+  
+  if(array_key_exists('language', $_GET)) $LanguageId = $_GET['language'] * 1; 
+    else $LanguageId = 1;
+  
+  if(isset($LanguageList[$LanguageId]) == false)
+  {
+    echo('Jazyk dle zadaného Id neexistuje.');
+    ShowFooter();
+    die();
+  }
+  return($LanguageId);
 }