Changeset 198

Timestamp:

Jun 5, 2009, 6:44:57 PM (16 years ago)

Author:

george

Message:

• Upraveno: Přepracován slovníček z malého nepraktického okna na plnou stránku, kterou je možné mít otevřenou v záložce.
• Přidáno: Slovníček je nyní vícejazykový a umožňuje vkládat samostatně české a slovenské překlady.
• Přidáno: Každý uživatel může přidat svoji variantu překladu.
• Přidáno: Možnost upravit a smazat překlad slova.

Location:

trunk

Files:

• dictionary.php (modified) (5 diffs)
• form.php (modified) (1 diff)
• includes/global.php (modified) (4 diffs)
• includes/global_function.php (modified) (2 diffs)
• registrace.php (modified) (3 diffs)
• style/style.css (modified) (1 diff)
• team.php (modified) (2 diffs)
• userlist.php (modified) (1 diff)

trunk/dictionary.php

@@ -3 +3 @@
 include('includes/global.php');
 
-function GetIDbyName($Table) {
+function GetIDbyName($Table) 
+{
         global $TranslationTree;
-        foreach($TranslationTree as $TableID => $Value) {
+  
+        foreach($TranslationTree as $TableID => $Value) 
+  {
                 //echo $Value['TablePrefix'].'='.$Table.'<br>';
         if ($Value['TablePrefix'] == $Table) return $TableID;
@@ -11 +14 @@
 }
 
-
-function GetTranslatNames($Text) {
-  global $Database,$mode;
+function GetTranslatNames($Text) 
+{
+  global $Database, $mode;
+  
         if ($mode == 0) echo ('..Přesné');
         if ($mode == 1) echo ('..Všechny přeložené');
@@ -19 +23 @@
         echo('<div style="overflow: auto; width: 100%; height: 345px;"><table width="98%" class="BaseTable">');
         echo('<tr><th>Originál</th>'.'<th>Překlad</th>');
- $TablesColumn = array('gameobject' => 'Name',
-  'creature' => 'name',
-  'item' => 'Name',
-  'transports' => 'Name',
-  'areatrigger_teleport' => 'Name',
-  'areatrigger_tavern' => 'Name',);
+  $TablesColumn = array
+  (
+    'gameobject' => 'Name',
+    'creature' => 'name',
+    'item' => 'Name',
+    'transports' => 'Name',
+    'areatrigger_teleport' => 'Name',
+    'areatrigger_tavern' => 'Name',
+  );
  /* $TablesID = array('gameobject' => 5,
   'creature' => 6,
@@ -32 +39 @@
   'areatrigger_tavern' => 'Name',); */
   
-  
-  
- foreach($TablesColumn as $Table => $Column) {
-  
-  $sql = 'SELECT ID,'.$Column.',(SELECT Name 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 ('; 
-
-  for($i = 0; $i < count($ArrStr); $i++)
-  {
-        if (strpos($ArrStr[$i],'\'s') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-4);
-        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 ';
+  foreach($TablesColumn as $Table => $Column) 
+  {  
+    $sql = 'SELECT ID,'.$Column.',(SELECT Name 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 ('; 
+ 
+    for($i = 0; $i < count($ArrStr); $i++)
+    {
+          if (strpos($ArrStr[$i],'\'s') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-4);
+          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 ';
+    }
+    $where = substr($where,0,strlen($where)-4);
+    $where .= ')';
+          echo ('</tr>');
+
+          $ID = $Database->SQLCommand($sql.$where.$groupby);
+          while($Line = mysql_fetch_assoc($ID)) 
+    {
+        if ($mode == 0) 
+      {
+                if (strpos(strtolower($Text),strtolower($Line[$Column])) > 0) 
+        {
+                  echo('<tr><td>'.$Line[$Column].'</td>');
+                  if ($Line['tran'] <> '') echo('<td>'.$Line['tran'].'</td></tr>');
+                        else echo('<td><a target="_NEW2" href="form.php?group='.GetIDbyName($Table).'&amp;ID='.$Line['ID'].'">Překládat</a></td></tr>');
+                }
+        } else 
+      {
+                echo('<tr><td>'.$Line[$Column].'</td>');
+            if ($Line['tran'] <> '') echo('<td>'.$Line['tran'].'</td></tr>');
+                        else echo('<td><a target="_NEW2" href="form.php?group='.GetIDbyName($Table).'&amp;ID='.$Line['ID'].'">Překládat</a></td></tr>');
+        }
+          }
   }
-  $where = substr($where,0,strlen($where)-4);
-  $where .= ')';
-        echo ('</tr>');
-
-        $ID = $Database->SQLCommand($sql.$where.$groupby);
-        while($Line = mysql_fetch_assoc($ID)) {
-        if ($mode == 0) {
-                if (strpos(strtolower($Text),strtolower($Line[$Column])) > 0) {
-                         echo('<tr><td>'.$Line[$Column].'</td>');
-                         if ($Line['tran'] <> '') echo('<td>'.$Line['tran'].'</td></tr>');
-                         else echo('<td><a target="_NEW2" href="form.php?group='.GetIDbyName($Table).'&amp;ID='.$Line['ID'].'">Překládat</a></td></tr>');
-                }
-        } else {
-                echo('<tr><td>'.$Line[$Column].'</td>');
-                         if ($Line['tran'] <> '') echo('<td>'.$Line['tran'].'</td></tr>');
-                         else echo('<td><a target="_NEW2" href="form.php?group='.GetIDbyName($Table).'&amp;ID='.$Line['ID'].'">Překládat</a></td></tr>');
-        }
-        }
- }
         echo('</table></div>');
 }
 
-
-echo('<?xml version="1.0" encoding="'.$Config['Web']['Charset'].'"?>
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
-<head>
-<meta http-equiv="content-type" content="text/html; charset=utf-8" /> 
-<link rel="stylesheet" href="'.$Config['Web']['BaseURL'].'style/style.css" type="text/css" media="all" />
-<script type="text/javascript" src="'.$Config['Web']['BaseURL'].'global.js"></script>
-<link rel="SHORTCUT ICON" href="'.$Config['Web']['BaseURL'].'images/favicon.ico" />
-<title>Projekt překládání textů WoW - slovníček</title>
-</head>
-<body style="margin: 0px; font-family: Verdana, Arial, Sans-Serif;">');
-  
-  
-  
-if (array_key_exists('group',$_GET)) {  
-  
+if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page']; 
+else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1;
+
+if(!isset($_SESSION['language'])) 
+{
+  if(Licence(LICENCE_USER)) 
+  {
+    $DbResult = $Database->SQLCommand('SELECT Language FROM user WHERE ID='.$_SESSION['UserID']);
+    $User = mysql_fetch_assoc($DbResult);
+    $_SESSION['language'] = $User['Language'];
+  } else $_SESSION['language'] = 1;
+}
+if(array_key_exists('language', $_GET)) $_SESSION['language'] = $_GET['language'];
+
+ShowPage();
+
+echo('<h3>Slovníček</h3>');
+  
+if(array_key_exists('group', $_GET)) 
+{   
         if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1;
         if(array_key_exists('mode', $_GET)) $mode = $_GET['mode']; else $mode = 0; //0 = přesné názvy, 1=všechny názvy, 2=nepřeložené
         $Table = $TranslationTree[$GroupId]['TablePrefix'];
 
-        if(array_key_exists('ID', $_GET)) {
-                $TextID = $_GET['ID'];  
+        if(array_key_exists('ID', $_GET)) 
+  {
+    $TextID = $_GET['ID'];  
                 echo ('Přeložené názvy vztahující se k překladu: <a target="_NEW" href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a><br />'. 
         '<a href="?mode=1&amp;group='.$GroupId.'&amp;ID='.$TextID.'" title="Zobrazit všechny podobné výsledky">Všechny</a> '.
         '<a href="?mode=0&amp;group='.$GroupId.'&amp;ID='.$TextID.'" title="Zobrazit pouze přesné výsledky">Přesné</a> '.
         '<a href="?mode=2&amp;group='.$GroupId.'&amp;ID='.$TextID.'" title="Zobrazit všechny nepřeložené">Nepřeložené</a> ');
-                $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM '.$Table.' Where ID = '.$TextID));
-                if(!$Line) die('Překlad nenalezen.');
+    $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM '.$Table.' Where ID = '.$TextID));
+    if(!$Line) die('Překlad nenalezen.');
                 
                 $Text = '';
@@ -114 +126 @@
                                 GetTranslatNames($Text);
         }
-        
-} else {  
-if(array_key_exists('insert', $_GET)) 
-{
-  echo('<form action="dictionary.php" method="post">
-          <input type="text" name="AJWord"> Anglické slovo<br />
-          <input type="text" name="CZWord"> České slovo<br />
-          <input type="text" name="description">  Popis<br />
-          <input type="submit" value="Uložit">
-          </form>');    
-  $WinWidth = 230;
-} else  
-{
-  $WinWidth = 345;
-  if (array_key_exists('AJWord', $_POST)) 
-  {
-    $AJWord = $_POST['AJWord'];
-    $CZWord = $_POST['CZWord'];
-    $description = $_POST['description'];
-    $user = @$_SESSION['UserID'];
-    $Database->SQLCommand("INSERT INTO `dictionary` ( `AJWord` , `CZWord` , `description` , `user` ) VALUES ('$AJWord', '$CZWord', '$description', '$user');");
-    echo('Záznam byl uložen!');
-    $WinWidth = 325;
-  }    
-}
-
-echo('<form action="dictionary.php" method="get" style="margin: 0px; padding: 0px;">
-<table style="width: 100%; height: 100%;">');
- 
-if(array_key_exists('search', $_GET)) 
-{
-  $Search = $_GET['search'];
 } else 
-{
-  $Search = '';
-}
+{  
+  if(array_key_exists('action', $_GET)) 
+  {
+    if(($_GET['action'] == 'insert')  and Licence(LICENCE_USER))
+    {
+      echo('<form action="dictionary.php?action=save" method="post">'.
+      '<fieldset><legend>Vložení nového slova</legend>'.
+      '<table><tr><td>'.
+      'Původní anglické slovo:</td><td><input type="text" name="Original" /></td></tr>'.
+      '<tr><td>Přeložené:</td><td><input type="text" name="Translated" /></td></tr>'.
+      '<tr><td>Popis:</td><td><input type="text" name="Description" /></td></tr>'.
+      '<tr><td colspan="2"><input type="submit" value="Uložit" /></td></tr>'.
+      '</td></tr></table>'.
+      '</fieldset>'.
+      '</form>');    
+    } else
+    if(($_GET['action'] == 'save') and Licence(LICENCE_USER))
+    {
+      $DbResult = $Database->SQLCommand('SELECT * FROM `dictionary` WHERE `Text` = "'.$_POST['Original'].'" AND Language=0');
+      if(mysql_num_rows($DbResult) > 0)
+      {
+        $DbRow = mysql_fetch_assoc($DbResult);
+        $Entry = $DbRow['Entry'];
+      } else 
+      {
+        $DbResult = $Database->SQLCommand('SELECT MAX(Entry) FROM dictionary');
+        $DbRow = mysql_fetch_row($DbResult);
+        $Entry = $DbRow[0] + 1;
+        $Database->SQLCommand('INSERT INTO `dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Original'].'", "'.$Entry.'", "", 0, 0);');
+      }
+      
+      $DbResult = $Database->SQLCommand('SELECT Id FROM `dictionary` WHERE `Entry` = '.$Entry.' AND Language='.$_SESSION['language'].' AND User='.$_SESSION['UserID']);
+      if(mysql_num_rows($DbResult) > 0)
+      {
+        $DbRow = mysql_fetch_assoc($DbResult);
+        $Database->SQLCommand('UPDATE `dictionary` SET `Text`="'.$_POST['Translated'].'", `Description` = "'.$_POST['Description'].'" WHERE Id='.$DbRow['Id']);
+      } else      
+        $Database->SQLCommand('INSERT INTO `dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Translated'].'", "'.$Entry.'", "'.$_POST['Description'].'", '.$_SESSION['UserID'].', '.$_SESSION['language'].')');
+      echo('Záznam byl uložen!');
+    } else
+    if(($_GET['action'] == 'remove') and Licence(LICENCE_USER))
+    {
+      $Database->SQLCommand('DELETE FROM dictionary WHERE User='.$_SESSION['UserID'].' AND Language='.$_SESSION['language'].' AND Entry='.$_GET['entry']);
+    } else
+    if(($_GET['action'] == 'modify')  and Licence(LICENCE_USER))
+    {
+      $DbResult = $Database->SQLCommand('SELECT * FROM dictionary WHERE User='.$_SESSION['UserID'].' AND Entry='.$_GET['entry'].' AND Language='.$_SESSION['language']);
+      $DbRow = mysql_fetch_assoc($DbResult);
+      $DbResult = $Database->SQLCommand('SELECT * FROM dictionary WHERE User=0 AND Entry='.$_GET['entry'].' AND Language=0');
+      $DbRow2 = mysql_fetch_assoc($DbResult);
+      echo('<form action="dictionary.php?action=save" method="post">'.
+      '<fieldset><legend>Upravení slova</legend>'.
+      '<table><tr><td>'.
+      'Původní anglické slovo:</td><td><input type="text" name="Original" value="'.$DbRow2['Text'].'" /></td></tr>'.
+      '<tr><td>Přeložené:</td><td><input type="text" name="Translated"  value="'.$DbRow['Text'].'" /></td></tr>'.
+      '<tr><td>Popis:</td><td><input type="text" name="Description"  value="'.$DbRow['Description'].'" /></td></tr>'.
+      '<tr><td colspan="2"><input type="submit" value="Uložit" /></td></tr>'.
+      '</td></tr></table>'.
+      '</fieldset>'.
+      '</form>');    
+    } 
+  }
+
+  echo('<form action="dictionary.php" method="get" style="margin: 0px; padding: 0px;">'.
+  '<table style="width: 100%; height: 100%;">');
+
+  if(array_key_exists('search', $_GET)) $Search = $_GET['search'];
+    else $Search = '';
        
-echo('<tr><td>
-  <input type="text" value="'.$Search.'" name="search" size="30" />
-  <input type="submit" value="Vyhledat" />');
-if(Licence(LICENCE_USER))
-  echo(' <a href="dictionary.php?insert">Vložit slovo</a>');
+  echo('<tr><td>
+    <input type="text" value="'.$Search.'" name="search" size="30" />
+    <input type="submit" value="Vyhledat" />');
+  if(Licence(LICENCE_USER)) echo(' <a href="dictionary.php?action=insert">Vložit slovo</a>');
            
-echo('</td></tr>'); 
-echo('<tr><td>
-<div style="overflow: auto; width: 100%; height: '.$WinWidth.'px;">');
-//todo select    
-if($Search <> '') 
-{
-  $sql = "SELECT * FROM `dictionary` WHERE LOWER(AJWord) LIKE LOWER('%$Search%') OR LOWER(CZWord) LIKE LOWER('%$Search%') OR LOWER(description) LIKE LOWER('%$Search%')";
-} else 
-{
-  $sql = "SELECT * FROM `dictionary`";
-}
-echo('<table width="98%" class="BaseTable">
-  <tr><th>Eng</th>
-  <th>Cze</th>
-  <th>  Popis</th></tr>');
-$ID = $Database->SQLCommand($sql);
-while ($Line = mysql_fetch_array($ID)) 
-{
-  echo('<tr>
-  <td>'.$Line['AJWord'].'</td>
-  <td><strong>'.$Line['CZWord'].'</strong></td>
-  <td>'.$Line['description'].'</td></tr>');
-}
-echo('</table>');  
-
-echo('</div></td></tr>'); 
-
-echo('</table></form>');
-
-}
-
-echo ('</body></html>');
+  echo('</td></tr>'); 
+  echo('<tr><td>Jazyk: ');
+  foreach($LanguageList as $Language)
+    if($Language['Enabled'] == 1)
+    {
+      if($Language['Id'] == $_SESSION['language']) echo('<strong>');
+      echo(' <a href="?language='.$Language['Id'].'">'.$Language['Name'].'</a>');
+      if($Language['Id'] == $_SESSION['language']) echo('</strong>');
+    }
+  echo('</td></tr>');
+  echo('<tr><td>
+  <div style="overflow: auto; width: 100%; height: 100%;">');
+
+  if($Search <> '') 
+  {
+    $sql = 'SELECT `user`.`user` AS `UserName`, `user`. `ID` AS `UserID`, `T3`.`Entry`, `T3`.`Original`, `T3`.`Translated`, `T3`.`Description` FROM (SELECT T2.User, `T1`.Language, `T1`.`Text` AS Original, `T2`.`Text` AS `Translated`, `T2`.`Description`, `T1`.`Entry` AS `Entry` FROM `dictionary` AS `T1` JOIN `dictionary` AS `T2` ON `T2`.`Entry` = `T1`.`Entry` AND `T2`.`Language` = '.$_SESSION['language'].' WHERE LOWER(T1.Text) LIKE LOWER("%'.$Search.'%") OR LOWER(T1.Description) LIKE LOWER("%'.$Search.'%") ) AS T3 JOIN `user` ON `user`.`ID` = `T3`.`User` WHERE `T3`.`Language` = 0';
+  } else $sql = 'SELECT `user`.`user` AS `UserName`, `ID` AS `UserID`, `T3`.`Entry`, `T3`.`Original`, `T3`.`Translated`, `T3`.`Description` FROM (SELECT T2.User, `T1`.Language, `T1`.`Text` AS Original, `T2`.`Text` AS `Translated`, `T2`.`Description`, `T1`.`Entry` AS `Entry` FROM `dictionary` AS `T1` JOIN `dictionary` AS `T2` ON `T2`.`Entry` = `T1`.`Entry` AND `T2`.`Language` = '.$_SESSION['language'].') AS T3 JOIN `user` ON `user`.`ID` = `T3`.`User` WHERE `T3`.`Language` = 0';
+  $sql .= ' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];
+
+  ListPaging('?Page=', '('.$sql.') AS T1', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
+  echo('<table width="98%" class="BaseTable">
+    <tr><th>'.$LanguageList[0]['Name'].'</th>
+    <th>'.$LanguageList[$_SESSION['language']]['Name'].'</th>
+    <th>Popis</th><th>Překladatel</th>');
+    if(Licence(LICENCE_USER)) echo('<th>Akce</th>');
+    echo('</tr>');
+  $ID = $Database->SQLCommand($sql);
+  while ($Line = mysql_fetch_assoc($ID)) 
+  {
+    echo('<tr>
+    <td>'.$Line['Original'].'</td>
+    <td><strong>'.$Line['Translated'].'</strong></td>
+    <td>'.$Line['Description'].'</td>
+    <td>'.$Line['UserName'].'</td>');
+    if(Licence(LICENCE_USER))
+    {
+      if($Line['UserID'] == $_SESSION['UserID']) 
+        echo('<td><a href="?action=remove&amp;entry='.$Line['Entry'].'">Smazat</a> <a href="?action=modify&amp;entry='.$Line['Entry'].'">Upravit</a></td>');
+        else echo('<td></td>');
+    }
+    echo('</tr>');
+  }
+  echo('</table>');  
+  ListPaging('?Page=', '('.$sql.') AS T1', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
+  echo('</div></td></tr>'); 
+  echo('</table></form>');
+}
+
+ShowFooter();
 
 ?>

trunk/form.php

@@ -69 +69 @@
   if(Licence(LICENCE_USER)) 
   {
-        if(($GroupId < 4) or ($GroupId == 10) or ($GroupId == 11)) echo ('<a href="" onclick="javascript:window.open(\'dictionary.php?group='.$GroupId.'&amp;ID='.$LineAJ['ID'].'\', \'Slovník\', \'width=400, height=390\'); return false;" Title="Zobrazit přeložené názvy věci, postav, a herních objektů k tomuto překladu">Vyhledat v názvech</a>');
+        if(($GroupId < 4) or ($GroupId == 10) or ($GroupId == 11)) echo ('<a href="dictionary.php?group='.$GroupId.'&amp;ID='.$LineAJ['ID'].'" target="_blank"  title="Zobrazit přeložené názvy věci, postav, a herních objektů k tomuto překladu">Vyhledat v názvech</a>');
     echo(' <input type="submit" value="Uložit do rozepsaných" name="save" title="Klikněte na uložit pro pozdější dokončení překladu" />
     <input type="submit" value="Dokončeno" name="End" title="Klikněte na Dokončeno jesli jsou všechny texty hotové a chcete již publikovat" /> ');

trunk/includes/global.php

@@ -36 +36 @@
   global $Database;
   
-  echo('<strong>Shoutbox:</strong><a href="action.php?action=shoutbox">Vložit</a>'.
-  '<div class="box"><table>');
+  echo('<strong>Shoutbox:</strong>');
+  if(Licence(LICENCE_USER)) echo(' <a href="action.php?action=shoutbox">Vložit</a>');
+  echo('<div class="box"><table>');
   $ID = $Database->SQLCommand('SELECT * FROM shoutbox ORDER BY ID DESC LIMIT 20');
   while($Line = mysql_fetch_assoc($ID))
@@ -92 +93 @@
     $Config['Web']['BaseURL'].'index.php' => array(LICENCE_ANONYMOUS, 'Hlavní stránka', 'Domů'),
     'http://wow.zdechov.net/forum/viewforum.php?f=22' => array(LICENCE_ANONYMOUS, 'Diskuze na téma překládání', 'Fórum projektu'),
-          'javascript:void(0)' => array(LICENCE_ANONYMOUS, 'Slovník WoW výrazů', 'Slovníček', 'javascript:window.open(\''.$Config['Web']['BaseURL'].'dictionary.php\', \'Slovník\', \'width=400, height=390\'); return false;'),
+          $Config['Web']['BaseURL'].'dictionary.php' => array(LICENCE_ANONYMOUS, 'Slovník WoW výrazů', 'Slovníček'),
           $Config['Web']['BaseURL'].'banners.php' => array(LICENCE_ANONYMOUS, 'Weby odkazující na tento projekt bennerem', 'Odkazují na nás'),
           $Config['Web']['BaseURL'].'statistic.php' => array(LICENCE_ANONYMOUS, 'Stav dokončení překládů', 'Stav dokončení'),
@@ -131 +132 @@
 
   echo('<strong>Překladové skupiny:</strong><br /><div id="TranslationMenu">');
-  if(Licence(LICENCE_USER)) {
-   echo ('<a title="Všechny překlady, které jste přeložil" href="'.$Config['Web']['BaseURL'].'TranslationList.php?user='.$_SESSION['UserID'].'&amp;action=userall">Všechny moje texty</a><br />');
-   echo ('<a title="Všechny překlady, které jste rozepsal a nedokončil" href="'.$Config['Web']['BaseURL'].'TranslationList.php?user='.$_SESSION['UserID'].'&amp;not&amp;action=userall">Rozpracované texty</a>');
-  //TODO: počet nedokončených  
-   echo ('<br /><br />');
+  if(Licence(LICENCE_USER)) 
+  {
+    echo ('<a title="Všechny překlady, které jste přeložil" href="'.$Config['Web']['BaseURL'].'TranslationList.php?user='.$_SESSION['UserID'].'&amp;action=userall">Všechny moje texty</a><br />');
+    echo ('<a title="Všechny překlady, které jste rozepsal a nedokončil" href="'.$Config['Web']['BaseURL'].'TranslationList.php?user='.$_SESSION['UserID'].'&amp;not&amp;action=userall">Rozpracované texty</a>');
+    //TODO: počet nedokončených  
+    echo ('<br /><br />');
   }
   foreach($TranslationTree as $Group)
@@ -236 +238 @@
   if(Licence(0)) $Database->SQLCommand('UPDATE user SET LastIP = "'.$_SERVER['REMOTE_ADDR'].'", LastLogin = NOW() WHERE ID = '.$_SESSION['UserID']);
 
-  echo ('<table class="page"><tr><td class="menu">');
+  echo('<table class="page"><tr><td class="menu">');
   ShowMainMenu();
       

trunk/includes/global_function.php

@@ -31 +31 @@
   global $Database;
         
+  echo('<div style="text-align: center">');
   $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Table.' '.$Where));        
   $ItemCount = floor($Line[0] / $ItemsPerPage);
@@ -42 +43 @@
       else echo('<a href="'.$Address.$Page.'">'.$Page.'</a> ');
   }
-  echo('<br />');       
+  echo('</div>');
 }
 

trunk/registrace.php

@@ -18 +18 @@
   if($Pass == $Pass2) 
   {
-    $Line = mysql_fetch_row($Database->SQLCommand("SELECT * FROM user WHERE user = '$User'"));
+    $Line = mysql_fetch_row($Database->SQLCommand('SELECT * FROM user WHERE user = "'.$User.'"'));
     if(!$Line) 
         {
@@ -30 +30 @@
       $_SESSION['Pass'] = $Pass;
     
-      $Line = mysql_fetch_array($Database->SQLCommand("SELECT ID FROM user WHERE user = '".$_SESSION['User']."'"));
+      $Line = mysql_fetch_array($Database->SQLCommand('SELECT ID FROM user WHERE user = "'.$_SESSION['User'].'"'));
       $_SESSION['UserID'] = $Line['ID']; 
       WriteLog('Uživatel se zaregistroval: '.$User, 3);
@@ -75 +75 @@
       ');
                 $ID = $Database->SQLCommand('SELECT name,ID FROM team');
-                while($Line = mysql_fetch_assoc($ID)) {
+                while($Line = mysql_fetch_assoc($ID))
+    {
                         echo('<option value="0'.$Line['ID'].'">'.$Line['name'].'</option>');
-        }
-            
-      
+        }
       echo('</select></td>
     </tr>

trunk/style/style.css

@@ -11 +11 @@
 {
   text-align: center;
+  margin: 2px 2px 2px 2px;
 }
 

trunk/team.php

@@ -62 +62 @@
   } else
   {
-        echo('<a href="?create">Vytvořit překladatelský tým</a><br /><br />');
-    echo('<strong>Seznam překladatelských týmů:</strong><br />');
+    echo('<h3>Seznam překladatelských týmů</h3>');
 
     if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page']; 
@@ -111 +110 @@
 
     ListPaging('?Page=', 'team', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
+        echo('<br /><div style="text-align: center;"><a href="?create">Vytvořit překladatelský tým</a></div>');
   }
 }          

trunk/userlist.php

@@ -7 +7 @@
 include('img_level.php');
 
-echo('<strong>Seznam uživatelů:</strong><br />');
+echo('<h3>Seznam uživatelů</h3>');
 if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page']; 
 else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1;