Changeset 365 for trunk/userlist.php

Timestamp:

Mar 9, 2010, 11:29:05 AM (15 years ago)

Author:

george

Message:

• Upraveno: Jména tabulek v databází upraveny na stejná s prvními velkými písmeny.
• Upraveno: Doplněny SQL uvozovky do mnoha SQL dotazů.

File:

• trunk/userlist.php (modified) (5 diffs)

trunk/userlist.php

@@ -11 +11 @@
 if(array_key_exists('search', $_GET))
 {
-  $_SESSION['Where'] = ' WHERE `user`.`user` LIKE "%'.$_GET['search'].'%"'; 
+  $_SESSION['Where'] = ' WHERE `User`.`User` LIKE "%'.$_GET['search'].'%"'; 
 }
 if(array_key_exists('team', $_GET))
 {
-  $_SESSION['Where'] = ' WHERE team='.$_GET['team']; 
+  $_SESSION['Where'] = ' WHERE `Team`='.$_GET['team']; 
   if($_GET['team'] == '') $_SESSION['Where'] = '';     
 }
@@ -26 +26 @@
 //if($_SESSION['Where'] <> '') echo(' <a href="?action=nofilter">Zrušit filtr uživatelů</a><br />');
 
-$DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `user`'.$_SESSION['Where']);
+$DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `User`'.$_SESSION['Where']);
 $DbRow = mysql_fetch_row($DbResult);
 $PageList = GetPageList($DbRow[0]);    
@@ -34 +34 @@
 
 $TableColumns = array(
-  array('Name' => 'user', 'Title' => 'Jméno'), 
+  array('Name' => 'User', 'Title' => 'Jméno'), 
   array('Name' => 'TranslatedCount', 'Title' => 'Přeložených'), 
   array('Name' => 'XP', 'Title' => 'Úroveň'), 
@@ -44 +44 @@
 
 
-$Query = 'SELECT `ID`, `user`.`user`, `LastLogin`, `GM`, `TranslatedCount` FROM `user` '.$_SESSION['Where'].$Order['SQL'].$PageList['SQLLimit'];
+$Query = 'SELECT `ID`, `User`.`Name`, `LastLogin`, `GM`, `TranslatedCount` FROM `User` '.$_SESSION['Where'].$Order['SQL'].$PageList['SQLLimit'];
 
 $ID = $Database->SQLCommand($Query);
@@ -50 +50 @@
 {
   if(Licence(LICENCE_MODERATOR)) 
-    $Name = '<a href="user.php?user='.$Line['ID'].'">'.$Line['user'].'</a>';
-    else $Name = $Line['user'];
+    $Name = '<a href="user.php?user='.$Line['ID'].'">'.$Line['Name'].'</a>';
+    else $Name = $Line['Name'];
         
     echo('<tr><td>'.$Name.'</td>
       <td style="text-align: center;"><a href="TranslationList.php?user='.$Line['ID'].'&amp;action=userall" title="Zobrazit Všechny jeho přeložené texty">'.$Line['TranslatedCount'].'</a></td>
-      <td><img src="tmp/user/'.$Line['user'].'/level.png" alt="Úroveň uživatele" /></td>
+      <td><img src="tmp/user/'.$Line['Name'].'/level.png" alt="Úroveň uživatele" /></td>
       <td>'.$Moderators[$Line['GM']].'</td>
       <td>'.HumanDate($Line['LastLogin']).'</td></tr>');