Changeset 124 for trunk

Timestamp:

Feb 22, 2009, 9:41:58 PM (16 years ago)

Author:

maron

Message:

Překladatelské týmy (změna struktury)

Location:

trunk

Files:

• Options.php (modified) (3 diffs)
• includes/global.php (modified) (1 diff)
• sql/structure.sql (modified) (1 diff)
• sql/updates/124.sql (added)
• team.php (added)
• userlist.php (modified) (4 diffs)

trunk/Options.php

@@ -16 +16 @@
     $Language = $_POST['Language'];
 
-    $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE ID = ".$_SESSION['UserID']));
+    $Line = mysql_fetch_assoc($Database->SQLCommand("SELECT * FROM user WHERE ID = ".$_SESSION['UserID']));
     if(($Line['pass'] == $OldPass) and ($NewPass == $NewPass2)) 
         {
@@ -27 +27 @@
   } else 
   {
-    $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE ID = ".$_SESSION['UserID']));    
+    $Line = mysql_fetch_assoc($Database->SQLCommand("SELECT * FROM user WHERE ID = ".$_SESSION['UserID']));    
     echo('<form action="Options.php" method="post">
         <fieldset><legend>Nastavení uživatele</legend>
@@ -58 +58 @@
   </table></fieldset>
 </form>');
+
+        echo (' <fieldset><legend>Překladatelský tým</legend>');
+        $ID = $Database->SQLCommand("SELECT * FROM team");
+                echo('<a href="?create">Vytvořit překladatelský tým</a><br /><br />
+                <form action="team.php" method="get"><select name="gointeam">');
+    While($LineTeam = mysql_fetch_assoc($ID)) {
+                echo('<option value="'.$LineTeam['ID'].'"'); 
+                        if ($LineTeam['ID'] == $Line['team']) echo(' selected="selected"');
+                         echo('>'.$LineTeam['name'].'</option>');
+        }    
+                echo('</select> <input type="submit" value="Vstoupit" />
+                </form>');      
+        echo ('</fieldset>      ');
+
   }
 } else echo 'Nejste přihlášený!'; 

trunk/includes/global.php

@@ -80 +80 @@
         'statistic.php' => array(LICENCE_ANONYMOUS, 'Stav dokončení překládů', 'Stav dokončení'),
         'userlist.php' => array(LICENCE_ANONYMOUS, 'Seznam registrovaných uživatelů', 'Seznam uživatelů'),
+        'team.php' => array(LICENCE_ANONYMOUS, 'Seznam překladatelských týmů', 'Seznam týmů'),
         'export/' => array(LICENCE_ANONYMOUS, 'Zde si můžete stáhnout přeložené texty', 'Stahování'),
         'registrace.php' => array(LICENCE_ANONYMOUS, 'Registrace uživatele pro překládání', 'Registrace'),

trunk/sql/structure.sql

@@ -498 +498 @@
   PRIMARY KEY  (`ID`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=551 ;
+
+ALTER TABLE `user` ADD `team` INT NOT NULL ;
+
+ALTER TABLE `user` ADD INDEX ( `team` ) ;
+
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `team`
+--
+
+CREATE TABLE IF NOT EXISTS `team` (
+  `ID` int(11) NOT NULL auto_increment,
+  `name` text NOT NULL,
+  `description` text NOT NULL,
+  PRIMARY KEY  (`ID`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+

trunk/userlist.php

@@ -5 +5 @@
 ShowPage();
 
-include('img_level.php');
+//include('img_level.php');
 
 echo('<strong>Seznam uživatelů:</strong><br />');
@@ -14 +14 @@
 if(array_key_exists('Desc', $_GET)) $_SESSION['Desc'] = $_GET['Desc']; 
 else if(!array_key_exists('Desc', $_SESSION)) $_SESSION['Desc'] = '';
-ListPaging('?Page=', 'user', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
 
+if(array_key_exists('Where', $_GET)) {
+         $_SESSION['Where'] = ' WHERE '.$_GET['Where']; 
+     if($_GET['Where'] == '') $_SESSION['Where'] = '';
+ }
+else if(!array_key_exists('Where', $_SESSION)) $_SESSION['Where'] = '';
+
+if ($_SESSION['Where'] <> '') echo (' <a href="?Where">Zrušit filtr uživatelů</a><br />');
+
+ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
 echo('<table class="BaseTable">');
 
 $desc = $_SESSION['Desc']; 
 if($desc == '') $desc = 'DESC'; else $desc = '';
+
+//ochrana proti špatným údajům v session z jiných tabulek
+if (($_SESSION['Order'] <> 'user') and ($_SESSION['Order'] <> 'XP') and ($_SESSION['Order'] <> 'NumberTranslate') and ($_SESSION['Order'] <> 'GM') and ($_SESSION['Order'] <> 'LastLogin'))
+$_SESSION['Order'] = 'NumberTranslate';
 
 echo('<tr><th><a href="?Order=user&amp;Desc='.$desc.'">Jméno</a></th>
@@ -36 +48 @@
   }
 
-$Query = 'SELECT ID, user.user, LastLogin, GM, ('.substr($Columns, 0, -3).') as NumberTranslate FROM `user`'.$Joins.' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];
+$Query = 'SELECT ID, user.user, LastLogin, GM, ('.substr($Columns, 0, -3).') as NumberTranslate FROM `user`'.$Joins.' '.$_SESSION['Where'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];
 
 $ID = $Database->SQLCommand($Query);
@@ -52 +64 @@
 }
 echo('</table>');
-ListPaging('?Page=', 'user', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
+ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']);
           
 ShowFooter();