Changeset 506

Timestamp:

Feb 14, 2013, 9:02:05 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Části týkající se generování stránky přesunuty z global.php do souboru Page.php.
• Upraveno: Obecné funkce sloučeny z global_function.php do global.php.
• Upraveno: Zrušeno načítání globálního seznamu jazyků na začátku souboru global.php. Seznam se načte podle potřeby až samotnými skripty.

Location:

trunk

Files:

• Options.php (modified) (1 diff)
• dictionary.php (modified) (1 diff)
• export/create_addon.php (modified) (2 diffs)
• export/export.php (modified) (5 diffs)
• includes/Page.php (added)
• includes/global.php (modified) (5 diffs)
• includes/global_function.php (deleted)
• includes/system.php (modified) (1 diff)
• statistic.php (modified) (1 diff)
• user.php (modified) (2 diffs)

trunk/Options.php

@@ -55 +55 @@
 
     $Output .= '  <fieldset><legend>Překladatelský tým</legend>';
-    $DbResult = $System->Database->query('SELECT * FROM `Team`');
+    $DbResult = $System->Database->query('SELECT `Id`, `Name` FROM `Team`');
     $Output .= '<a href="team.php?action=create">Vytvořit tým</a><br />'.
       '<a href="team.php?action=leave">Opustit tým</a><br />'.

trunk/dictionary.php

@@ -45 +45 @@
   return($Output);
 }
+
+$LanguageList = GetLanguageList();
 
 if(!isset($_SESSION['language'])) 

trunk/export/create_addon.php

@@ -97 +97 @@
   function MakeLanguageFiles()
   {
-    global $TranslationTree, $CreatedFileList, $LanguageList;
+    global $TranslationTree, $CreatedFileList;
    
     $this->LoadFilters();
@@ -181 +181 @@
   function MakeClientStrings()
   {
-    global $TranslationTree, $LanguageList;
+    global $TranslationTree;
   
     $this->LoadFilters();

trunk/export/export.php

@@ -70 +70 @@
   function ExportToMangosSQL()
   {
-    global $TranslationTree, $LanguageList, $User, $Config;
+    global $TranslationTree, $User, $Config;
   
     $this->LoadFilters();
@@ -136 +136 @@
   function ExportToAoWoWSQL() 
   {
-    global $Config, $TranslationTree, $AoWoWconf, $LanguageList;
+    global $Config, $TranslationTree, $AoWoWconf;
   
     require_once('../aowow/configs/config.php');
@@ -192 +192 @@
   function ExportToXML()
   {
-    global $TranslationTree, $LanguageList, $User;
+    global $TranslationTree, $User;
   
     $this->LoadFilters($this->Id);
@@ -243 +243 @@
   function ExportToDBC()
   {
-    global $TranslationTree, $LanguageList, $Config;
+    global $TranslationTree, $Config;
   
     $this->LoadFilters();
@@ -330 +330 @@
   function ExportToLua()
   {
-    global $TranslationTree, $LanguageList;
+    global $TranslationTree;
   
     $this->LoadFilters();

trunk/includes/global.php

@@ -14 +14 @@
 foreach($_GET as $Index => $Item) $_GET[$Index] = addslashes($_GET[$Index]);
 
-include_once(dirname(__FILE__).'/global_function.php');
 if(file_exists(dirname(__FILE__).'/config.php')) include_once(dirname(__FILE__).'/config.php');
   else die('Nenalezen konfigurační soubor config.php ve složce includes. '.
@@ -23 +22 @@
 include_once(dirname(__FILE__).'/system.php');
 include_once(dirname(__FILE__).'/user.php');
+include_once(dirname(__FILE__).'/Page.php');
 
 $System = new System();
@@ -31 +31 @@
 
 $TranslationTree = GetTranslationTree();
-$LanguageList = GetLanguageList();
 
 LogReferrer();
@@ -47 +46 @@
 }
 
-function ShowShoutbox()
-{
-  global $System, $Config, $User, $System;
-  
-  $Output = '<strong><a href="'.$System->Link('/action.php?action=ShoutBoxView').'">Kecátko:</a></strong>';
-  if($User->Licence(LICENCE_USER)) 
-    $Output .= ' <a href="'.$System->Link('/action.php?action=shoutbox').'">Vložit</a>';
-  $Output .= '<div class="box"><table>';
-  $DbResult = $System->Database->query('SELECT * FROM `ShoutBox` ORDER BY `ID` DESC LIMIT 30');
-  while($Line = $DbResult->fetch_assoc())
-    $Output .= '<tr><td><strong>'.$Line['UserName'].'</strong>: '.MakeActiveLinks($Line['Text']).'</td></tr>';
-  $Output .= '</table></div>';
-  return($Output);
-}
-
-function ShowTopBar()
-{
-  global $Config, $System, $User, $System;
-  
-  $Output = '<div class="Menu">';
-  $Output .= '<span class="MenuItem"></span>';
-  if($User->Licence(LICENCE_USER))
-  {
-    //$DbResult = $System->Database->query('SELECT `Id`, `Name` FROM `Team` WHERE `Id`='.$User->Team);
-    //$Team = $DbResult->fetch_assoc();
-    //$Output .= ''<span class="MenuItem">Moje překlady: <a href="">Dokončené</a> <a href="">Rozpracované</a> <a href="">Exporty</a> Tým: <a href="">'.$Team['name'].'</a></span>';
-    $Output .= '<span class="MenuItem2">'.$User->Name.' <a href="'.$System->Link('/?action=logout').'">Odhlášení</a> <a href="'.$System->Link('/Options.php').'">Nastavení</a>'.
-      ' <a title="Vámi přeložené texty" href="'.$System->Link('/TranslationList.php?user='.$User->Id.'&amp;group=0&amp;state=2&amp;text=&amp;entry=').'">Přeložené</a>'.
-      ' <a title="Vaše rozpracované text" href="'.$System->Link('/TranslationList.php?user='.$User->Id.'&amp;group=0&amp;state=3&amp;text=&amp;entry=').'">Rozpracované</a>'.
-      ' <a title="Nikým nepřeložené texty" href="'.$System->Link('/TranslationList.php?user=0&amp;group=0&amp;state=1&amp;text=&amp;entry=').'">Nepřeložené</a>'.
-      '</span>';
-  } else 
-  {
-    $Output .= '<span class="MenuItem2"><form action="'.$System->Link('/?action=login').'" method="post"> Jméno: <input type="text" name="LoginUser" size="8 " /> Heslo: <td><input type="password" name="LoginPass" size="8" /> <input type="submit" value="Přihlásit" /></form> &nbsp; <a href="'.$System->Link('/registrace.php').'">Registrace</a></span>';
-  }
-  $Output .= '</div>';
-  return($Output);
-}
-
-function ShowLoginBox()
-{
-  global $User;
-  
-  $Output = '';
-  if($User->Licence(LICENCE_USER)) 
-  {
-     // $Output .= 'Jste přihlášen jako: <b>'.$User->Id.'</b> <a href="index.php?Logout">Odhlásit</a>';
-  } else 
-  {
-    $Output .= '<strong>Přihlášení:</strong>
-  <form action="" method="post">
-  <table>
-    <tr>
-      <td><input type="text" name="LoginUser" size="13" /></td>
-    </tr>
-    <tr>
-      <td><input type="password" name="LoginPass" size="13" /></td>
-    </tr>
-    <tr>
-      <th><input type="submit" value="Přihlásit" /></th>
-    </tr>
-  </table>
-  </form>';
-  }
-  return($Output);
-}
-
-function ShowSearchBox()
-{
-  global $System;
-  
-  $Output = '<strong>Hledání:</strong>'.
-  '<form action="'.$System->Link('/action.php').'" method="get"><div>'.
-  '<input type="hidden" name="action" value="search" />'.
-  '<table>'.
-  '<tr>'.
-      '<td><input type="text" name="search" size="13" /></td>'.
-    '</tr>'.
-    '<tr>'.
-      '<th><input type="submit" value="Hledat" /></th>'.
-    '</tr>'.
-  '</table></div>'.
-  '</form>';
-  return($Output);
-}
-
-function ShowMainMenu()
-{ 
-  global $TranslationTree, $Config, $User, $System;
-  
-  $Menu = array
-  (
-    $System->Link('/') => array(LICENCE_ANONYMOUS, 'Hlavní stránka', 'Domů'),
-    $System->Link('/dictionary.php') => array(LICENCE_ANONYMOUS, 'Slovník WoW výrazů', 'Slovníček'),
-    $System->Link('/statistic.php') => array(LICENCE_ANONYMOUS, 'Stav dokončení překládů', 'Stav dokončení'),
-    $System->Link('/userlist.php?action=nofilter') => array(LICENCE_ANONYMOUS, 'Seznam registrovaných uživatelů', 'Překladatelé'),
-    $System->Link('/team.php?search=') => array(LICENCE_ANONYMOUS, 'Seznam překladatelských týmů', 'Týmy'),
-    $System->Link('/serverlist.php') => array(LICENCE_ANONYMOUS, 'Seznam serverů, kde je nasazena čeština v praxi', 'Servery'),
-    $System->Link('/export/') => array(LICENCE_ANONYMOUS, 'Zde si můžete stáhnout přeložené texty', 'Exporty'),
-    $System->Link('/download.php') => array(LICENCE_ANONYMOUS, 'Stahování různých pomocných souborů a programů', 'Soubory'),
-    $System->Link('/info.php') => array(LICENCE_ANONYMOUS, 'Informace k překladu hry', 'Informace'),
-    $System->Link('/TranslationList.php?action=grouplist') => array(LICENCE_ANONYMOUS, 'Informace o překladových skupinách', 'Zdroje dat'), 
-    $System->Link('/banners.php') => array(LICENCE_ANONYMOUS, 'Informace k propagaci tohoto projektu', 'Propagace'),
-    $System->Link('/promotion.php') => array(LICENCE_ANONYMOUS, 'Prezentace a motivace překladu', 'Prezentace'),
-    $System->Link('/version.php') => array(LICENCE_ANONYMOUS, 'Seznam verzí herního klienta', 'Verze hry'), 
-    $System->Link('/aowow/') => array(LICENCE_ANONYMOUS, 'Vyhledávací databáze podobná WoWHead s překlady', 'AoWoW'), 
-'http://embed.mibbit.com/?server=game.zdechov.net%3A6667&amp;channel=%23wowpreklad&amp;forcePrompt=true&amp;charset=utf-8' => array(LICENCE_ANONYMOUS, 'IRC chat pro překladatele', 'Chat'),
-    $System->Link('/admin/') => array(LICENCE_ADMIN, 'Volby pro správu', 'Administrace'), 
-  );
-  
-  $Output = '<strong>Hlavní menu:</strong>'.
-    '<div class="verticalmenu"><ul>'; 
-  foreach($Menu as $MenuTarget => $MenuItem)
-  {
-    if(isset($MenuItem[3])) $OnClick = ' onclick="'.$MenuItem[3].'"'; 
-      else $OnClick = '';
-    if($User->Licence($MenuItem[0])) 
-      $Output .= '<li><a class="verticalmenua" title="'.$MenuItem[1].'" href="'.$MenuTarget.'"'.$OnClick.'>'.$MenuItem[2].'</a></li>';
-  }    
-  $Output .= '</ul></div>';
-  return($Output);
-}
-
-function ShowTranslatedMenu()
-{
-  global $TranslationTree, $User, $System;
-
-  $Output = '<strong>Překladové skupiny:</strong><br /><div id="TranslationMenu">';
-  foreach($TranslationTree as $Group)
-  {
-    $Output .= '<div id="menuitem-group'.$Group['Id'].'" onmouseover="show(\'group'.$Group['Id'].'\')" onmouseout="hide(\'group'.$Group['Id'].'\')">'.
-      '<a href="'.$System->Link('/TranslationList.php?group='.$Group['Id'].'&amp;action=filter').'">'.$Group['Name'].'</a></div>'.
-      '<div id="group'.$Group['Id'].'" class="hidden-menu-item" onmouseover="show(\'group'.$Group['Id'].'\')" onmouseout="hide(\'group'.$Group['Id'].'\')">';
-    $Output .= '&nbsp;<a title="Zde můžete začít překládat" href="'.$System->Link('/TranslationList.php?group='.$Group['Id'].'&amp;state=1&amp;user=0&amp;entry=&amp;text=').'">Nepřeložené</a><br />'.
-    '&nbsp;<a title="Přeložené texty, můžete zde hlasovat, nebo opravovat překlady" href="'.$System->Link('/TranslationList.php?group='.$Group['Id'].'&amp;state=2&amp;user=0&amp;entry=&amp;text=').'">Přeložené</a><br />'; 
-    if($User->Licence(LICENCE_USER)) 
-    {
-      $Output .= '&nbsp;<a title="Nedokončené překlady" href="'.$System->Link('/TranslationList.php?group='.$Group['Id'].'&amp;state=3').'">Rozepsané</a><br />
-        &nbsp;<a title="Všechny překlady, které jste přeložil" href="'.$System->Link('/TranslationList.php?group='.$Group['Id'].'&amp;state=1&amp;user='.$User->Id).'&amp;entry=&amp;text=">Vlastní</a><br />';
-    }
-    $Output .= '&nbsp;<a title="Sestavit speciální filtr" href="'.$System->Link('/TranslationList.php?group='.$Group['Id'].'&amp;action=filter').'">Filtr</a><br />';
-    $Output .= '</div>';
-  }
-  $Output .= '</div>';
-  return($Output);
-}
-
-function ShowOnlineUserList()
-{
-  global $System, $Moderators, $User;
-  
-  $Output = 'Online překladatelé:<br />';
-  $DbResult = $System->Database->query('SELECT `Name`, `GM`, `ID` FROM `User` WHERE `LastLogin` >= NOW() - 300 AND ((`LastLogout` < `LastLogin`) OR (ISNULL(`LastLogout`)))');
-  while($DbUser = $DbResult->fetch_assoc())
-  {
-    if($User->Licence(LICENCE_MODERATOR)) 
-      $Name = '<a href="user.php?user='.$DbUser['ID'].'">'.$DbUser['Name'].'</a>';
-      else $Name = $DbUser['Name'];
-    $TextGM = '';
-    $Output .= '<strong>'.$Name.'</strong>'.$TextGM.'<br />';
-  }
-  return($Output);
-}
-
-function ShowHeader()
-{
-  global $User, $RSSChannels, $System;  
-  
-  $Output = '<?xml version="1.0" encoding="'.$System->Config['Web']['Charset'].'"?>
-  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="cz">'.
-'<head>'.
-'<meta http-equiv="content-type" content="application/xhtml+xml; charset='.$System->Config['Web']['Charset'].'" />'.
-'<meta name="keywords" content="wow, quest, questy, questů, preklad, mangos, překlad, překládání, přeložený, přeložení, čeština, world of warcraft, open source, free, addon" />'.
-'<meta name="description" content="'.$System->Config['Web']['Title'].'" />'.
-'<meta name="robots" content="all" />'.
-'<link rel="stylesheet" href="'.$System->Link('/style/style.css').'" type="text/css" media="all" />'.
-'<script type="text/javascript" src="'.$System->Link('/style/global.js').'"></script>'.
-'<link rel="shortcut icon" href="'.$System->Link('/images/favicon.ico').'" />';
-  if(isset($RSSChannels)) 
-  foreach($RSSChannels as $Channel)
-    $Output .= ' <link rel="alternate" title="'.$Channel['Title'].'" href="'.
-      $System->Link('/rss.php?channel='.$Channel['Channel']).'" type="application/rss+xml" />';
-  $Output .= '<title>'.$System->Config['Web']['Title'].'</title>
-</head>
-<body>';
-
-  $Output .= ShowTopBar();
-  $Output .= '<table class="page"><tr><td class="menu">';
-  $Output .= ShowMainMenu();
-  $Output .= ShowOnlineUserList();
-  $Output .= '<br />';
-  $Output .= ShowSearchBox();
-  $Output .= '</td><td id="border-left"></td><td class="content">';
-  if(isset($Message)) $Output .= ShowMessage($Message, $MessageType);
-  return($Output);
-}
-
-function ShowFooter()
-{
-  global $System, $ScriptStartTime, $User;
-
-    $ScriptGenerateDuration = round(GetMicrotime() - $ScriptStartTime, 2);
-
-    $Output = '</td>'.
-      '<td class="menu2">';
-    $Output .= ShowTranslatedMenu();
-    $Output .= '</td>'.
-    '</tr><tr>'.
-    '<td colspan="4" class="page-bottom">Autoři: '.$System->Config['Web']['Authors'].
-    ' &nbsp; <a href="http://svn.zdechov.net/trac/wowpreklad/browser/trunk">Zdrojové soubory</a> &nbsp; '.
-    '<a href="http://svn.zdechov.net/trac/wowpreklad/log/trunk?verbose=on">Novinky</a> &nbsp; '.
-    $System->Config['Web']['WebCounter'];
-  
-    $Output .= '</td></tr>';
-    if($System->Config['Web']['ShowRuntimeInfo'] == true) 
-      $Output .= '<tr><td colspan="3" style="text-align: center;">Doba generování: '.$ScriptGenerateDuration.' s / '.ini_get('max_execution_time').' s &nbsp;&nbsp; Použitá paměť: '.HumanSize(memory_get_peak_usage(FALSE)).' / '.ini_get('memory_limit').'B &nbsp;&nbsp; <a href="http://validator.w3.org/check?uri='.htmlentities('http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'].'?'.$_SERVER['QUERY_STRING']).'">HTML validator</a></td></tr>';
-    $Output .= '</table>'.
-      '</body>'.
-      '</html>';
-    $User->Store();
-    return($Output); 
-}
-
-function ShowPage($Content)
-{
-  global $Config;
-  
-  $Output = ShowHeader().$Content.ShowFooter();
-  //if($Config['Web']['FormatOutput']) $Output = FormatOutput($Output);
-  echo($Output);
-}
-
 $UnitNames = array('B', 'kB', 'MB', 'GB', 'TB', 'PB', 'EB');
  
@@ -321 +87 @@
 }
 
+// Log types
+define('LOG_TYPE_TRANSLATION', 1);
+define('LOG_TYPE_DOWNLOAD', 2);
+define('LOG_TYPE_USER', 3);
+define('LOG_TYPE_MODERATOR', 4);
+define('LOG_TYPE_ERROR', 10);
+define('LOG_TYPE_IMPORT', 11);
+define('LOG_TYPE_EXPORT', 12);
+define('LOG_TYPE_CZWOW', 13);
+define('LOG_TYPE_ADMINISTRATION', 14);
+
+
+function utf2ascii($text)
+{
+  $return = Str_Replace(
+    Array("á","č","ď","é","ě","í","ľ","ň","ó","ř","š","ť","ú","ů","ý","ž","Á","Č","Ď","É","Ě","Í","Ľ","Ň","Ó","Ř","Š","Ť","Ú","Ů","Ý","Ž") ,
+    Array("a","c","d","e","e","i","l","n","o","r","s","t","u","u","y","z","A","C","D","E","E","I","L","N","O","R","S","T","U","U","Y","Z") ,
+    $text);
+  //$return = Str_Replace(Array(" ", "_"), "-", $return); //nahradí mezery a podtržítka pomlčkami
+  //$return = Str_Replace(Array("(",")",".","!",",","\"","'"), "", $return); //odstraní ().!,"'
+  //$return = StrToLower($return); // velká písmena nahradí malými.
+  return($return);
+}
+
+function getmonthyears($Days) 
+{
+  $month = floor($Days / 30);
+  $year = floor($month / 12);
+  $Days = floor($Days - $month * 30);
+  $month = $month - $year * 12; 
+  return($year.'r '.$month.'m '.$Days.'d');
+}
+
+function GetPageList($TotalCount)
+{
+  global $System;
+    
+  $QueryItems = GetQueryStringArray($_SERVER['QUERY_STRING']);
+  
+  $ItemPerPage = $System->Config['Web']['ItemsPerPage'];
+  $Around = round($System->Config['Web']['VisiblePagingItems'] / 2);
+  $Result = '';
+  $PageCount = floor($TotalCount / $ItemPerPage) + 1;
+  
+  if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 0;
+  if(array_key_exists('page', $_GET)) $_SESSION['Page'] = $_GET['page'] * 1;
+  if($_SESSION['Page'] < 0) $_SESSION['Page'] = 0;
+  if($_SESSION['Page'] >= $PageCount) $_SESSION['Page'] = $PageCount - 1;
+  $CurrentPage = $_SESSION['Page'];
+  
+        
+  $Result .= 'Počet položek: <strong>'.$TotalCount.'</strong> &nbsp; Stránky: ';
+
+  $Result = '';
+  if($PageCount > 1)
+  {
+    if($CurrentPage > 0) 
+    {
+      $QueryItems['page'] = 0;      
+      $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">&lt;&lt;</a> ';
+      $QueryItems['page'] = ($CurrentPage - 1);
+      $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">&lt;</a> ';
+    }
+    $PagesMax = $PageCount - 1;
+    $PagesMin = 0;
+    if($PagesMax > ($CurrentPage + $Around)) $PagesMax = $CurrentPage + $Around;
+    if($PagesMin < ($CurrentPage - $Around))
+    {
+      $Result.= ' ... ';
+      $PagesMin = $CurrentPage - $Around;
+    }
+    for($i = $PagesMin; $i <= $PagesMax; $i++)
+    {
+      if($i == $CurrentPage) $Result.= '<strong>'.($i + 1).'</strong> ';
+      else {
+       $QueryItems['page'] = $i;
+       $Result .= '<a href="?'.SetQueryStringArray($QueryItems).'">'.($i + 1).'</a> ';
+      }
+    } 
+    if($PagesMax < ($PageCount - 1)) $Result .= ' ... ';
+    if($CurrentPage < ($PageCount - 1)) 
+    {
+      $QueryItems['page'] = ($CurrentPage + 1);
+      $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">&gt;</a> ';
+      $QueryItems['page'] = ($PageCount - 1);
+      $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">&gt;&gt;</a>';
+    }
+  }
+  $Result = '<div style="text-align: center">'.$Result.'</div>';
+  return(array('SQLLimit' => ' LIMIT '.$CurrentPage * $ItemPerPage.', '.$ItemPerPage, 
+    'Page' => $CurrentPage,
+    'Output' => $Result,
+  ));
+}
+
+$OrderDirSQL = array('ASC', 'DESC');
+$OrderArrowImage = array('sort_asc.png', 'sort_desc.png');
+
+function GetOrderTableHeader($Columns, $DefaultColumn, $DefaultOrder = 0)
+{
+  global $OrderDirSQL, $OrderArrowImage, $Config, $System;
+  
+  if(array_key_exists('OrderCol', $_GET)) $_SESSION['OrderCol'] = $_GET['OrderCol'];
+  if(array_key_exists('OrderDir', $_GET)) $_SESSION['OrderDir'] = $_GET['OrderDir'];
+  if(!array_key_exists('OrderCol', $_SESSION)) $_SESSION['OrderCol'] = $DefaultColumn;
+  if(!array_key_exists('OrderDir', $_SESSION)) $_SESSION['OrderDir'] = $DefaultOrder;
+  
+  // Check OrderCol
+  $Found = false;
+  foreach($Columns as $Column)
+  {
+    if($Column['Name'] == $_SESSION['OrderCol'])
+    {
+      $Found = true;    
+      break;
+    }
+  }
+  if($Found == false)
+  {
+    $_SESSION['OrderCol'] = $DefaultColumn;
+    $_SESSION['OrderDir'] = $DefaultOrder;
+  }
+  // Check OrderDir
+  if(($_SESSION['OrderDir'] != 0) and ($_SESSION['OrderDir'] != 1)) $_SESSION['OrderDir'] = 0;
+  
+  $Result = '';
+  $QueryItems = GetQueryStringArray($_SERVER['QUERY_STRING']);
+  foreach($Columns as $Index => $Column)
+  {
+    $QueryItems['OrderCol'] = $Column['Name'];
+    $QueryItems['OrderDir'] = 1 - $_SESSION['OrderDir'];
+    if($Column['Name'] == $_SESSION['OrderCol']) $ArrowImage = '<img  style="vertical-align: middle; border: 0px;" src="'.$System->Link('/images/'.$OrderArrowImage[$_SESSION['OrderDir']]).'" alt="order arrow">';
+      else $ArrowImage = '';
+    if($Column['Name'] == '') $Result .= '<th>'.$Column['Title'].'</th>';
+      else $Result .= '<th><a href="?'.SetQueryStringArray($QueryItems).'">'.$Column['Title'].$ArrowImage.'</a></th>';
+  }
+  return(array(
+    'SQL' => ' ORDER BY `'.$_SESSION['OrderCol'].'` '.$OrderDirSQL[$_SESSION['OrderDir']],
+    'Output' => '<tr>'.$Result.'</tr>',
+    'Column' => $_SESSION['OrderCol'],
+    'Direction' => $_SESSION['OrderDir'],
+  ));
+}
+
+function FormatOutput($s)
+{
+  $out = '';
+  $nn = 0;
+  $n = 0;
+  while($s != '')
+  {
+    $start = strpos($s, '<');
+    $end = strpos($s, '>');
+    if($start != 0) 
+    {
+      $end = $start - 1;
+      $start = 0;
+    }
+    $line = trim(substr($s, $start, $end + 1));
+    if(strlen($line) > 0) 
+    if($line[0] == '<')
+    {
+      if($s[$start + 1] == '/') 
+      {
+        $n = $n - 2;
+        $nn = $n;
+      } else 
+      {
+        if(strpos($line, ' ')) $cmd = substr($line, 1, strpos($line, ' ') - 1);
+        else $cmd = substr($line, 1, strlen($line) - 2);
+        //echo('['.$cmd.']');
+        if(strpos($s, '</'.$cmd.'>')) $n = $n + 2;
+      }   
+    }// else $line = '['.$line.']';
+    //if($line != '') echo(htmlspecialchars(str_repeat(' ',$nn).$line."\n"));
+    if($line != '') $out .= (str_repeat(' ', $nn).$line."\n");
+    $s = substr($s, $end + 1, strlen($s));
+    $nn = $n;
+  }
+  return($out);
+}
+
+function WriteLanguages($Selected)
+{
+  global $LanguageList, $System;
+  
+  $Output = '<select name="Language">';
+  $DbResult = $System->Database->select('Language', '`Id`, `Name`', '`Enabled` = 1');
+  while($Language = $DbResult->fetch_assoc())
+  {
+    $Output .= '<option value="'.$Language['Id'].'"'; 
+    if($Selected == $Language['Id']) 
+      $Output .= ' selected="selected"';
+    $Output .= '>'.$Language['Name'].'</option>';
+  }    
+  $Output .= '</select>';
+  return($Output);    
+}
+
+function WriteLanguagesWithoutSel($Selected)
+{
+  global $LanguageList;
+  
+  $Output = '';
+  foreach($LanguageList as $Language)
+  {
+    if($Selected == $Language['Id']) $Output .= $Language['Name'];
+  }
+  return($Output);
+}
+
+function MysqlDateTimeToTime($Time)
+{
+  $Parts = explode(' ', $Time);
+  $DateParts = explode('-', $Parts[0]); 
+  $TimeParts = explode(':', $Parts[1]);
+  $Result = mktime($TimeParts[0], $TimeParts[1], $TimeParts[2], $DateParts[1], $DateParts[2], $DateParts[0]); 
+  return($Result);  
+}
+
+function GetLanguageList()
+{ 
+  global $System;
+  
+  $Result = array();
+  $DbResult = $System->Database->query('SELECT * FROM `Language` WHERE `Enabled` = 1');
+  while($DbRow = $DbResult->fetch_assoc())
+    $Result[$DbRow['Id']] = $DbRow;
+  return($Result);
+}
+
+function GetTranslationTree()
+{ 
+  global $System;
+  
+  $Result = array();
+  $DbResult = $System->Database->query('SELECT *, UNIX_TIMESTAMP(`LastImport`) AS `LastImportTime` FROM `Group` ORDER BY `Name`');
+  while($DbRow = $DbResult->fetch_assoc())
+  {
+    $DbRow['Items'] = array();
+    $Result[$DbRow['Id']] = $DbRow;
+  }
+  $DbResult = $System->Database->query('SELECT * FROM `GroupItem` ORDER BY `Group`, `Sequence`');
+  while($DbRow = $DbResult->fetch_assoc())
+  {
+    $Result[$DbRow['Group']]['Items'][] = $DbRow;
+  }
+  return($Result);
+}
+
+$Moderators = array('Překladatel', 'Moderátor', 'Administrátor');
+
+function WriteLog($Text, $Type)
+{
+  global $System, $User;
+ 
+  if(!isset($_SERVER['REMOTE_ADDR'])) $IP = 'Konzole';
+    else $IP = addslashes($_SERVER['REMOTE_ADDR']);
+
+  if(!is_null($User->Id)) $UserId = $User->Id;
+    else $UserId = 'NULL';
+  $Query = 'INSERT INTO `Log` ( `User` , `Type` , `Text` , `Date` , `IP` )
+   VALUES ('.$UserId.', '.$Type.', "'.addslashes($Text).'", NOW(), "'.$IP.'")';
+  $System->Database->query($Query);
+}
+
+function HumanDate($SQLDateTime)
+{
+  $DateTimeParts = explode(' ', $SQLDateTime);
+  if($DateTimeParts[0] != '0000-00-00')
+  {
+    $DateParts = explode('-', $DateTimeParts[0]);
+    return(($DateParts[2] * 1).'.'.($DateParts[1] * 1).'.'.($DateParts[0] * 1));
+  } else return('&nbsp;');
+}
+
+function FollowingTran($TextID, $Table, $GroupId, $Prev = false) 
+{ 
+  global $System;
+  
+  if($Prev)
+  {
+    $sql = 'SELECT ID FROM '.$Table.' as item WHERE Language = 0 AND NOT EXISTS(SELECT entry FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = item.entry) AND ID < '.$TextID.' ORDER BY ID DESC LIMIT 1';
+  } else
+  {
+    $sql = 'SELECT ID FROM '.$Table.' as item WHERE Language = 0 AND NOT EXISTS(SELECT entry FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = item.entry) AND ID > '.$TextID.' ORDER BY ID LIMIT 1';
+  }
+  
+  $DbResult = $System->Database->query($sql);
+  $Next = $DbResult->fetch_assoc();
+  if($Next) 
+  {
+    if($Prev) $Output = '<a href="form.php?group='.$GroupId.'&amp;ID='.$Next['ID'].'">Předcházející '.$Next['ID'].'</a> ';
+    else $Output = '<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']);
+  }
+}
+
+function GetBuildNumber($Version)
+{
+  global $System, $BuildNumbers;
+  
+  if(isset($BuildNumbers[$Version]) == false) 
+  {
+    $sql = 'SELECT `BuildNumber` FROM `ClientVersion` WHERE `Version` = "'.$Version.'"';
+    $DbResult = $System->Database->query($sql);
+    $DbRow = $DbResult->fetch_assoc();
+    $BuildNumbers[$Version] = $DbRow['BuildNumber'];
+  }
+  return($BuildNumbers[$Version]);
+}
+
+function GetVersionWOW($BuildNumber)
+{
+  global $System, $VersionsWOW;
+  
+  if(isset($VersionsWOW[$BuildNumber]) == false) 
+  {
+    $sql = 'SELECT `Version` FROM `ClientVersion` WHERE `BuildNumber` = "'.$BuildNumber.'"';
+    $DbResult = $System->Database->query($sql);
+    $Version = $DbResult->fetch_assoc();
+    $VersionsWOW[$BuildNumber] = $Version['Version'];
+  }
+  return($VersionsWOW[$BuildNumber]);
+}
+
+function LoadGroupIdParameter()
+{
+  global $TranslationTree;
+  
+  if(array_key_exists('group', $_GET)) $GroupId = $_GET['group'] * 1; 
+    else $GroupId = 1;
+  
+  if(isset($TranslationTree[$GroupId]) == false) ErrorMessage('Překladová skupina dle zadaného Id neexistuje.');
+  return($GroupId);
+}
+
+function LoadLanguageIdParameter()
+{
+  global $LanguageList;
+  
+  if(array_key_exists('language', $_GET)) $LanguageId = $_GET['language'] * 1; 
+    else $LanguageId = 1;
+  
+  if(isset($LanguageList[$LanguageId]) == false)
+  {
+    ErrorMessage(ShowMessage('Jazyk dle zadaného Id neexistuje.', MESSAGE_CRITICAL));
+  }
+  return($LanguageId);
+}
+
+function LoadCommandLineParameters()
+{
+  if(!array_key_exists('REMOTE_ADDR', $_SERVER))
+  {
+    foreach($_SERVER['argv'] as $Parameter)
+    {
+      if(strpos($Parameter, '=') !== false)
+      {
+        $Index = substr($Parameter, 0, strpos($Parameter, '='));
+        $Parameter = substr($Parameter, strpos($Parameter, '=') + 1);
+        //echo($Index.'  ----  '.$Parameter);
+        $_GET[$Index] = $Parameter;
+      }
+    } 
+  }
+}
+
+function ShowTabs($Tabs)
+{
+  $QueryItems = GetQueryStringArray($_SERVER['QUERY_STRING']);
+  
+  if(array_key_exists('Tab', $_GET)) $_SESSION['Tab'] = $_GET['Tab'];
+  if(!array_key_exists('Tab', $_SESSION)) $_SESSION['Tab'] = 0;
+  if(($_SESSION['Tab'] < 0) or ($_SESSION['Tab'] > (count($Tabs) - 1))) $_SESSION['Tab'] = 0;
+  $Output = '<div id="header">'.
+    '<ul>';
+  foreach($Tabs as $Index => $Tab)
+  {
+    $QueryItems['Tab'] = $Index;
+    if($Index == $_SESSION['Tab']) $Selected = ' id="selected"'; 
+      else $Selected = '';
+    $Output .= '<li'.$Selected.'><a href="?'.SetQueryStringArray($QueryItems).'">'.$Tab.'</a></li>';
+  }
+  $Output .= '</ul></div>';
+  return($Output);
+}
+
+function CheckBox($Name, $Checked = false, $Id = '', $Class = '', $Disabled = false)
+{
+  if($Id) $Id = ' id="'.$Id.'"'; else $Id = '';
+  if($Class) $Class = ' class="'.$Class.'"'; else $Class = '';
+  if($Checked) $Checked = ' checked="checked"'; else $Checked = '';
+  if($Disabled) $Disabled = ' disabled="disabled"'; else $Disabled = '';
+  return('<input type="checkbox" value="checked" name="'.$Name.'"'.$Checked.$Disabled.$Id.$Class.' />');
+}
+
+function RadioButton($Name, $Value, $Checked = false, $OnClick = '', $Disabled = false)
+{
+  if($Checked) $Checked = ' checked="checked"'; else $Checked = '';
+  if($OnClick != '') $OnClick = ' onclick="'.$OnClick.'"'; else $OnClick = '';
+  if($Disabled) $Disabled = ' disabled="disabled"'; else $Disabled = '';
+  return('<input type="radio" name="'.$Name.'" value="'.$Value.'"'.$Checked.$Disabled.$OnClick.'/>');
+}
+
+function SelectOption($Name, $Text, $Selected = false)
+{
+  if($Selected) $Selected = ' selected="selected"'; else $Selected = '';
+  return('<option value="'.$Name.'"'.$Selected.'>'.$Text.'</option>');
+}
+
+function DeleteDirectory($dirname) 
+{
+  if(is_dir($dirname))
+  {
+    $dir_handle = opendir($dirname);
+    if(!$dir_handle) return(false);
+    while($file = readdir($dir_handle)) 
+    {
+      if(($file != '.') and ($file != '..'))
+      {
+        if(!is_dir($dirname.'/'.$file)) unlink($dirname.'/'.$file);
+          else DeleteDirectory($dirname.'/'.$file);    
+      }
+    }
+    closedir($dir_handle);
+    rmdir($dirname);
+  }
+  return(true);
+}
+
+function ErrorMessage($Text)
+{
+  ShowPage($Text);
+  die();
+}
+
+function GetIDbyName($Table) 
+{
+  global $TranslationTree;
+  
+  foreach($TranslationTree as $TableID => $Value) 
+  {
+    if($Value['TablePrefix'] == $Table) return $TableID;
+  }
+}
+
+function GetTranslatNames($Text,$mode,$TablesColumn) 
+{
+  global $System;
+  
+ /* $TablesID = array('gameobject' => 5,
+  'creature' => 6,
+  'item' => 4,
+  'transports' => 'Name',
+  'areatrigger_teleport' => 'Name',
+  'areatrigger_tavern' => 'Name',); */
+    $buff = array();
+  
+  foreach($TablesColumn as $Table => $Column) 
+  {  
+    $sql = 'SELECT `ID`,`'.$Column.'`, (SELECT `'.$Column.'` FROM `'.$Table.'` AS `T` WHERE `O`.`Entry` = `T`.`Entry` AND `Language` <> 0 LIMIT 1) AS `Tran` FROM `'.$Table.'` AS `O` WHERE ';
+    $groupby = ' GROUP BY `'.$Column.'`';
+  
+    $ArrStr = explode(' ', $Text);
+    $where = '`Language` = 0 ';
+    if ($mode == 1) $where .= ' AND EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE (`Sub`.`Language` <> 0) AND (`Sub`.`Entry` = `O`.`Entry`))';
+    if ($mode == 2) $where .= ' AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE (`Sub`.`Language` <> 0) AND (`Sub`.`Entry` = `O`.`Entry`))';
+    $where .= ' AND ('; 
+    
+    $SqlOK = false;
+    if (count($ArrStr) > 0) {
+      for($i = 0; $i < count($ArrStr); $i++)
+      {
+        if (strpos($ArrStr[$i],"'s") > 0)
+       $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-2);
+        if (strpos($ArrStr[$i],',') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1);
+        if (strpos($ArrStr[$i],'.') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1);
+        if (strpos($ArrStr[$i],'!') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1);
+        if (strpos($ArrStr[$i],'?') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1);
+
+        if (strlen($ArrStr[$i]) > 4) {
+          $where .= '(`O`.`'.$Column.'` LIKE "%'.addslashes($ArrStr[$i]).'%") OR ';
+          $SqlOK = true;
+      }
+      }
+      $where = substr($where, 0, strlen($where) - 4);
+      $where .= ')';
+      if ($SqlOK) {
+        $DbResult = $System->Database->query($sql.$where.$groupby);
+    //  echo ($sql.'|'.$where.'|'.$groupby);
+        while($Line = $DbResult->fetch_assoc()) 
+        {
+          $buff[] = array($Line['ID'], GetIDbyName($Table), $Line[$Column], $Line['Tran']);
+        }
+    }
+    }
+  }
+    return $buff;
+}
+
+function ProgressBar($Width, $Percent, $Text = '')
+{
+  $Pixels = $Width * ($Percent / 100);
+  if($Pixels > $Width) $Pixels = $Width;
+  if($Text == '') $Text = $Percent;
+  
+  return('<div class="progressbar" style="width: '.$Width.'px">'.
+    '<div class="bar" style="width: '.$Pixels.'px;"></div>'.  
+    '<div class="text" style="width: '.$Width.'px">'.$Text.'</div>'.  
+    '</div>');
+}
+
+function GetLevelMinMax($XP)
+{
+  $IndexLevel = 100;
+  
+  if($XP > 0) $Level = floor(sqrt($XP / $IndexLevel));
+    else $Level = 0;
+  $MinXP = $Level * $Level * $IndexLevel;
+  $MaxXP = ($Level + 1) * ($Level + 1) * $IndexLevel;
+  $MaxXP = $MaxXP - $MinXP;
+  $XP = $XP - $MinXP;
+  return(array('Level' => $Level, 'XP' => $XP, 'MaxXP' => $MaxXP));
+}
+
+function GetParameter($Name, $Default = '', $Numeric = false, $Session = false)
+{
+  $Result = $Default;
+  if(array_key_exists($Name, $_GET)) $Result = $_GET[$Name];
+  else if(array_key_exists($Name, $_POST)) $Result = $_POST[$Name];
+  else if($Session and array_key_exists($Name, $_SESSION)) $Result = $_SESSION[$Name];
+  if($Numeric and !is_numeric($Result)) $Result = $Default;
+  if($Session) $_SESSION[$Name] = $Result;
+  return($Result);
+}
+
+function LogReferrer()
+{
+  global $System;
+
+  if(array_key_exists('HTTP_REFERER', $_SERVER)) 
+  {
+    $Referrer = addslashes($_SERVER['HTTP_REFERER']);
+    $HostName = substr($Referrer, strpos($Referrer, '/') + 2);
+    $HostName = substr($HostName, 0, strpos($HostName, '/'));
+    if($HostName != $System->Config['Web']['Host'])
+    {
+      $DbResult = $System->Database->query('SELECT `Id` FROM `Referrer` WHERE `Web` = "'.$HostName.'"');
+      if($DbResult->num_rows > 0)
+      {
+        $DbRow = $DbResult->fetch_assoc();
+        $System->Database->query('UPDATE `Referrer` SET `Hits` = `Hits` + 1, `DateLast` = NOW(), `LastURL` = "'.addslashes($Referrer).'" WHERE `Id` = '.$DbRow['Id']);
+      } else $System->Database->query('INSERT INTO `Referrer` (`Web`, `DateFirst`, `DateLast`, `LastURL`, `Hits`) VALUES ("'.$HostName.'", NOW(), NOW( ), "'.addslashes($Referrer).'", 1)');
+    }
+  }
+}
+
+function MakeActiveLinks($Content)
+{
+  $Content = htmlspecialchars($Content);
+  $Content = str_replace("\n", ' <br/>', $Content);
+  $Content = str_replace("\r", '', $Content);
+  
+  $Result = '';  
+  $I = 0;
+  while(strpos($Content, 'http://') !== false)
+  {
+    $I = strpos($Content, 'http://');
+    $Result .= substr($Content, 0, $I);
+    $Content = substr($Content, $I);
+    $SpacePos = strpos($Content, ' ');
+    if($SpacePos !== false) $URL = substr($Content, 0, strpos($Content, ' '));
+      else $URL = substr($Content, 0);
+    
+    $Result .= '<a href="'.$URL.'">'.$URL.'</a>';
+    $Content = substr($Content, strlen($URL));
+  }
+  $Result .= $Content;
+  return($Result);
+}
+
+define('MESSAGE_WARNING', 0);
+define('MESSAGE_CRITICAL', 1);
+define('MESSAGE_INFORMATION', 2);
+
+function ShowMessage($Text, $Type = MESSAGE_INFORMATION)
+{
+  global $System;
+  
+  $IconName = array(
+        MESSAGE_INFORMATION => 'information', 
+    MESSAGE_WARNING => 'warning', 
+    MESSAGE_CRITICAL => 'critical'
+  );
+  $BackgroundColor = array(
+        MESSAGE_INFORMATION => '#e0e0ff', 
+    MESSAGE_WARNING => '#ffffe0', 
+        MESSAGE_CRITICAL => '#ffe0e0'
+  );
+  
+  return('<div class="message" style="background-color: '.$BackgroundColor[$Type].
+        ';"><table><tr><td class="icon"><img src="'.
+        $System->Link('/images/message/'.$IconName[$Type].'.png').'" alt="'.
+        $IconName[$Type].'"><td>'.$Text.'</td></tr></table></div>');
+}
+
+
 ?>

trunk/includes/system.php

@@ -30 +30 @@
   function Init()
   {
-    include('config.php');
+        global $Config;    
     $this->Config = $Config;
     $this->Database->HostName = $this->Config['Database']['Host'];

trunk/statistic.php

@@ -2 +2 @@
 
 include('includes/global.php');
+
+$LanguageList = GetLanguageList();
 
 if(array_key_exists('Version', $_GET)) $_SESSION['StatVersion'] = $_GET['Version'];

trunk/user.php

@@ -22 +22 @@
 if(array_key_exists('user', $_GET) and $User->Licence(LICENCE_MODERATOR)) 
 {  
-  $Query = 'SELECT * FROM `User` WHERE `ID` = '.$_GET['user'];
+  $Query = 'SELECT `User`.*, `Language`.`Name` AS `LanguageName` FROM `User` '.
+    'LEFT JOIN `Language` ON `Language`.`Id` = `User`.`Language` WHERE `User`.`Id` = '.$_GET['user'];
   $DbResult = $System->Database->query($Query);
   $UserLine = $DbResult->fetch_array();
@@ -28 +29 @@
   $Output .= 'ID: <strong>'.$UserLine['ID'].'</strong><br />'.
     'Jméno: <strong>'.$UserLine['Name'].'</strong><br />'.
-    'Výchozí jazyk: <strong>'.$LanguageList[$UserLine['Language']]['Name'].'</strong><br />'.
+    'Výchozí jazyk: <strong>'.$UserLine['LanguageName'].'</strong><br />'.
     'Poslední připojení: <strong>'.$UserLine['LastLogin'].'</strong><br />'.
     'Poslední IP: <strong>'.$UserLine['LastIP'].'</strong><br />'.