Changeset 365 for trunk/team.php

Timestamp:

Mar 9, 2010, 11:29:05 AM (14 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/team.php (modified) (6 diffs)

trunk/team.php

@@ -31 +31 @@
   echo($Order['Output']);
 
-  if(array_key_exists('search', $_GET))  $_SESSION['search'] = ' WHERE `name` LIKE "%'.$_GET['search'].'%" OR `description` LIKE "%'.$_GET['search'].'%"'; 
+  if(array_key_exists('search', $_GET))  $_SESSION['search'] = ' WHERE `Name` LIKE "%'.$_GET['search'].'%" OR `Description` LIKE "%'.$_GET['search'].'%"'; 
     else if(!array_key_exists('search', $_SESSION)) $_SESSION['search'] = '';
     if (array_key_exists('search', $_GET) and ($_GET['search'] == '')) $_SESSION['search'] = '';
@@ -46 +46 @@
     if(!is_numeric($_SESSION['team'])) echo(' <a href="?Where">Zrušit filtr týmů</a><br />');
     */
-    $DbResult = $Database->SQLCommand('SELECT `Team` FROM `user` WHERE `ID`='.$_SESSION['UserID']);
+    $DbResult = $Database->SQLCommand('SELECT `Team` FROM `User` WHERE `ID`='.$_SESSION['UserID']);
     $User = mysql_fetch_assoc($DbResult);   
 
-    $ID = $Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM `user` WHERE `user`.`team` = `Team`.`Id`) AS `NumberUser`, (SELECT `user` FROM `user` WHERE `user`.`ID`=`Team`.`Leader`) AS `LeaderName` FROM `Team` '.$_SESSION['search'].$Order['SQL'].$PageList['SQLLimit']);
+    $ID = $Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM `User` WHERE `User`.`Team` = `Team`.`Id`) AS `NumberUser`, (SELECT `Name` FROM `User` WHERE `User`.`ID`=`Team`.`Leader`) AS `LeaderName` FROM `Team` '.$_SESSION['search'].$Order['SQL'].$PageList['SQLLimit']);
     while($Team = mysql_fetch_assoc($ID)) 
     {
@@ -81 +81 @@
     if(array_key_exists('id', $_GET))
     { 
-      $Database->SQLCommand('UPDATE `user` SET `team` = '.$_GET['id'].' WHERE `ID` = '.$_SESSION['UserID']); 
+      $Database->SQLCommand('UPDATE `User` SET `Team` = '.$_GET['id'].' WHERE `ID` = '.$_SESSION['UserID']); 
       echo('<strong>Vstoupil jsi do týmu</strong><br /><br />');    
       WriteLog('Uživatel vstoupil do týmu '.$_GET['id'], LOG_TYPE_USER);
 
       // Delete all teams without users
-      $Database->SQLCommand('DELETE FROM `Team` WHERE (SELECT COUNT(*) FROM `user` WHERE `user`.`team` = `Team`.`Id`) = 0');
+      $Database->SQLCommand('DELETE FROM `Team` WHERE (SELECT COUNT(*) FROM `User` WHERE `User`.`Team` = `Team`.`Id`) = 0');
         
       // Set new leader for teams where old leader went to other team
-      $Database->SQLCommand('UPDATE Team SET Leader=(SELECT Id FROM `user` WHERE user.Team=Team.Id ORDER BY user.RegistrationTime LIMIT 1) WHERE Leader NOT IN (SELECT ID FROM user WHERE user.Team=Team.Id);');
+      $Database->SQLCommand('UPDATE `Team` SET `Leader`=(SELECT `Id` FROM `User` WHERE `User`.`Team`=`Team`.`Id` ORDER BY `User`.`RegistrationTime` LIMIT 1) WHERE `Leader` NOT IN (SELECT `ID` FROM `User` WHERE `User`.`Team`=`Team`.`Id`);');
         
       ShowTeamList();
@@ -110 +110 @@
       {
         $Database->SQLCommand('INSERT INTO `Team` (`Name` ,`Description`, `URL`, `TimeCreate`,`Leader`) VALUES ("'.trim($_POST['Name']).'", "'.trim($_POST['Description']).'", "'.$_POST['URL'].'", NOW(), '.$_SESSION['UserID'].')');  
-        $Database->SQLCommand('UPDATE `user` SET `team` = '.mysql_insert_id().' WHERE `ID` = '.$_SESSION['UserID']); 
+        $Database->SQLCommand('UPDATE `User` SET `Team` = '.mysql_insert_id().' WHERE `ID` = '.$_SESSION['UserID']); 
         echo('<strong>Překladatelský tým vytvořen</strong><br /><br />');
         WriteLog('Překladatelský tým vytvořen '.$_POST['Name'], LOG_TYPE_USER);
 
         // Delete all teams without users
-        $Database->SQLCommand('DELETE FROM `Team` WHERE (SELECT COUNT(*) FROM `user` WHERE `user`.`team` = `Team`.`Id`) = 0');    
+        $Database->SQLCommand('DELETE FROM `Team` WHERE (SELECT COUNT(*) FROM `User` WHERE `User`.`Team` = `Team`.`Id`) = 0');    
       } else echo('Již existuje tým se stejným jménem');
     } else echo('Chybí údaje formuláře');
@@ -195 +195 @@
     ImgLevelUpdate();
       
-    $Team = mysql_fetch_assoc($Database->SQLCommand('SELECT *, (SELECT count(*) FROM `user` WHERE `team` = `Team`.`Id`) AS `NumberUser`, (SELECT SUM(`TranslatedCount`) FROM `user` WHERE `team` = `Team`.`Id`) AS `NumberTranslate` FROM `Team` WHERE `Id`='.$_GET['id'])); 
-    $DbResult = $Database->SQLCommand('SELECT user FROM user WHERE ID='.$Team['Leader']);
+    $Team = mysql_fetch_assoc($Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM `User` WHERE `Team` = `Team`.`Id`) AS `NumberUser`, (SELECT SUM(`TranslatedCount`) FROM `User` WHERE `team` = `Team`.`Id`) AS `NumberTranslate` FROM `Team` WHERE `Id`='.$_GET['id'])); 
+    $DbResult = $Database->SQLCommand('SELECT `Name` FROM `User` WHERE `ID`='.$Team['Leader']);
     if(mysql_num_rows($DbResult) > 0) 
     {
       $Leader = mysql_fetch_assoc($DbResult);
-      $Leader = $Leader['user'];
+      $Leader = $Leader['Name'];
     } else $Leader = '';
     
@@ -227 +227 @@
   if(Licence(LICENCE_USER))
   {   
-    $Database->SQLCommand('UPDATE `user` SET `team` = 0 WHERE `ID` = '.$_SESSION['UserID']); 
+    $Database->SQLCommand('UPDATE `User` SET `Team` = 0 WHERE `ID` = '.$_SESSION['UserID']); 
     echo('<strong>Nyní nejste členem žádného týmu</strong><br /><br />');    
     WriteLog('Uživatel vystoupil z týmu', LOG_TYPE_USER);
 
     // Delete all teams without users
-    $Database->SQLCommand('DELETE FROM `Team` WHERE (SELECT COUNT(*) FROM `user` WHERE `user`.`team` = `Team`.`Id`) = 0');
+    $Database->SQLCommand('DELETE FROM `Team` WHERE (SELECT COUNT(*) FROM `User` WHERE `User`.`Team` = `Team`.`Id`) = 0');
         
     // Set new leader for teams where old leader went to other team
-    $Database->SQLCommand('UPDATE Team SET Leader=(SELECT Id FROM `user` WHERE user.Team=Team.Id ORDER BY user.RegistrationTime LIMIT 1) WHERE Leader NOT IN (SELECT ID FROM user WHERE user.Team=Team.Id);');
+    $Database->SQLCommand('UPDATE `Team` SET `Leader`=(SELECT `Id` FROM `User` WHERE `User`.`Team`=`Team`.`Id` ORDER BY `User`.`RegistrationTime` LIMIT 1) WHERE `Leader` NOT IN (SELECT `ID` FROM `User` WHERE `User`.`Team`=`Team`.`Id`);');
         
     ShowTeamList();