Changeset 286 for trunk/TranslationList.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/TranslationList.php (modified) (14 diffs)

trunk/TranslationList.php

@@ -6 +6 @@
 
 $TranslationItemPerPage = 200;
-if(array_key_exists('group', $_GET)) $GroupId = $_GET['group'] * 1; else $GroupId = 1;
+$GroupId = LoadGroupIdParameter();
 if(array_key_exists('connexion_id', $_GET)) { 
   $_SESSION['connexion_id'] = $_GET['connexion_id'];
-}
-$DbResult = $Database->SQLCommand('SELECT Id FROM `group` WHERE `Id`='.$GroupId);
-if(mysql_num_rows($DbResult) == 0)
-{
-  echo('Neexistující id překladové skupiny.');
-  ShowFooter();
-  die();
 }
 $Table = $TranslationTree[$GroupId]['TablePrefix'];
@@ -144 +137 @@
 if($Action == 'connexion') 
 { //SELECT * FROM spell WHERE entry IN(SELECT entry FROM connexion_item WHERE connexion = 1)
-        $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT Name FROM connexion WHERE `Id` = '.$_SESSION['connexion_id']));
+  $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT Name FROM connexion WHERE `Id` = '.$_SESSION['connexion_id']));
     echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
         <a title="Zde je seznam souvislostí" href="?group='.$GroupId.'&amp;action=connexion">Souvislosti</a> - > 
@@ -166 +159 @@
       <td>'.$Line['Name'].'</td>');
     }
-        echo ('</table>');
+  echo ('</table>');
 } else
 if($Action == 'nocomplete') 
@@ -196 +189 @@
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
         <a title="Přeložené questy přilášeného uživatele" href="?group='.$GroupId.'&amp;action=my">Moje překlady</a><br /><br />');
-  WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_SESSION['UserID'], '', 'my');
+  WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = '.$Table.'.`user`) AS `User` FROM `'.$Table.'` Where `user` = '.$_SESSION['UserID'], '', 'my');
 } else
 if(($Action == 'mydevelop') and Licence(LICENCE_USER)) 
@@ -202 +195 @@
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
     <a title="Nedokončené texty" href="?group='.$GroupId.'&amp;action=mydevelop">Rozepsané překlady</a><br /><br />');
-  WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_SESSION['UserID'].' AND Complete = 0', '', 'mydevelop');
+  WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` Where `user` = '.$_SESSION['UserID'].' AND `Complete` = 0', '', 'mydevelop');
 } else      
 if($Action == 'users') 
@@ -208 +201 @@
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
         <strong>Vypsání textů od určitých uživatelů</strong><br /><br />');
-  $users = @$_POST['users'];
-  
-  $WhereUsers = '';
-    
+  if(array_key_exists('users', $_POST)) $users = $_POST['users'];
+    else $users = array();
+  
+  $WhereUsers = '';    
   for($i = 0; $i < Count($users); $i++)
   {
-    if($WhereUsers <> '') $WhereUsers .= ' OR User = '.$users[$i];
-      else $WhereUsers .= ' User = '.$users[$i];
-  }
-  WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where '.$WhereUsers, '', 'users');
+    if($WhereUsers <> '') $WhereUsers .= ' OR `User` = '.$users[$i];
+      else $WhereUsers .= ' `User` = '.$users[$i];
+  }
+  if($WhereUsers == '') $WhereUsers = '0';
+  
+  
+  WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE '.$WhereUsers, '', 'users');
 } else     
 if($Action == 'userall') 
 {
-  $ID = $Database->SQLCommand('SELECT user FROM user WHERE id = '.$_GET['user']);
+  $ID = $Database->SQLCommand('SELECT `user` FROM `user` WHERE `id` = '.$_GET['user']);
   $Line = mysql_fetch_row($ID);
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a>'.
@@ -232 +228 @@
   {
     if(array_key_exists('not', $_GET)) {
-       $sql = 'SELECT COUNT(*) FROM '.$Group['TablePrefix'].' WHERE Complete = 0 AND user='.$_GET['user'];
+       $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `Complete` = 0 AND `user`='.$_GET['user'];
          $ID = $Database->SQLCommand($sql);
          $Line = mysql_fetch_row($ID);
@@ -239 +235 @@
        $Total += $Line[0];
     } else {
-         $sql = 'SELECT COUNT(*) FROM '.$Group['TablePrefix'].' WHERE user='.$_GET['user'];
+         $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `user`='.$_GET['user'];
          $ID = $Database->SQLCommand($sql);
          $Line = mysql_fetch_row($ID);
@@ -289 +285 @@
   if(array_key_exists('user', $_GET))
   {
-    $ID = $Database->SQLCommand('SELECT user FROM user WHERE id = '.($_GET['user'] * 1));
+    $ID = $Database->SQLCommand('SELECT `user` FROM `user` WHERE `id` = '.($_GET['user'] * 1));
     if(mysql_num_rows($ID) > 0)
     {
@@ -296 +292 @@
         '<strong>Vypis překladů uživatele '.$Line[0].': </strong><br /><br />');
       if(array_key_exists('not', $_GET)) 
-        WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where Complete = 0 AND user = '.$_GET['user'], '', 'userid');
-      else WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_GET['user'], '', 'userid');
+        WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` Where `Complete` = 0 AND `user` = '.$_GET['user'], '', 'userid');
+      else WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` Where `user` = '.$_GET['user'], '', 'userid');
     } else echo('Nebyl nalezen uživatel se zadaným id');
   } else echo('Je nutno zadat id uživatele.');
@@ -306 +302 @@
   else $Search = $_POST['search'];
   
-  $sql = 'SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
+  $sql = 'SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
     OR `entry` LIKE "%'.$Search.'%"
     OR `Language` LIKE "%'.$Search.'%"
@@ -323 +319 @@
   else $Search = $_POST['ID'];
  
-  $sql = 'SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM `'.$Table.'` WHERE `entry` LIKE "'.$Search.'"';
+  $sql = 'SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE `entry` LIKE "'.$Search.'"';
     
   WriteQuests($sql, '', 'searchentry='.$Search);
@@ -333 +329 @@
         <strong>Výpis všech textů s limitem na stránku</strong><br /><br />');
 
-  WritePages('?group='.$GroupId.'&amp;action=all', ' AS items WHERE (items.Language = 0)');
-
-  WriteQuests('SELECT * FROM '.$Table.' AS items WHERE (items.Language = 0)', $_SESSION['limitx'].','.$_SESSION['limity'], 'all');
+  WritePages('?group='.$GroupId.'&amp;action=all', ' AS `items` WHERE (`items`.`Language` = 0)');
+
+  WriteQuests('SELECT * FROM `'.$Table.'` AS `items` WHERE (`items`.`Language` = 0)', $_SESSION['limitx'].','.$_SESSION['limity'], 'all');
 } else      
 if($Action == 'filter') 
@@ -359 +355 @@
         
   echo('<tr><td><form action="?group='.$GroupId.'&amp;action=users" method="post"><div>'.
-    '<select name="users[]" size="10" multiple="multiple">');
-        
-  $ID = $Database->SQLCommand('SELECT user, ID FROM `user` WHERE
-    EXISTS(SELECT 1 FROM '.$Table.' WHERE user = user.ID) ORDER BY user');
+    '<select name="users[]" size="10" multiple="multiple" class="UserList">');
+        
+  $ID = $Database->SQLCommand('SELECT `user`, `ID` FROM `user` WHERE
+    EXISTS(SELECT 1 FROM `'.$Table.'` WHERE `user` = `user`.`ID`) ORDER BY `user`');
   if($ID)
   while($Line = mysql_fetch_assoc($ID))