Changeset 365 for trunk/Options.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/Options.php (modified) (2 diffs)

trunk/Options.php

@@ -17 +17 @@
     $redirecting = $_POST['redirecting'];
 
-   // $Line = mysql_fetch_assoc($Database->SQLCommand("SELECT * FROM user WHERE ID = ".$_SESSION['UserID']));
     if(($_SESSION['Pass'] == $OldPass) and ($NewPass == $NewPass2)) 
     {
       // Update password
       $Salt = GetPasswordSalt();
-      $Database->SQLCommand('UPDATE user SET pass = sha1(CONCAT(sha1("'.$NewPass.'"), "'.$Salt.'")), Salt="'.$Salt.'" WHERE ID = '.$_SESSION['UserID']);
+      $Database->SQLCommand('UPDATE `User` SET `Pass` = sha1(CONCAT(sha1("'.$NewPass.'"), "'.$Salt.'")), `Salt`="'.$Salt.'" WHERE `ID` = '.$_SESSION['UserID']);
       echo('Heslo změněno!<br />');
     } else echo('<br />Hesla se neshodují!<br />');
     
-    $Database->SQLCommand('UPDATE user SET Email = "'.$Email.'", Language = "'.$Language.'", redirecting = "'.$redirecting.'" WHERE ID = '.$_SESSION['UserID']);
+    $Database->SQLCommand('UPDATE `User` SET `Email` = "'.$Email.'", `Language` = "'.$Language.'", `Redirecting` = "'.$redirecting.'" WHERE `ID` = '.$_SESSION['UserID']);
     echo('Úprava nastavení proběhla v pořádku, Email: <b>'.$Email.'</b> Uživatel: <b>'.$User.'</b><br />');
     WriteLog('Úprava nastavení!', LOG_TYPE_USER);
   } else 
   {
-    $Line = mysql_fetch_assoc($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>
@@ -86 +85 @@
     {
       echo('<option value="'.$LineTeam['Id'].'"'); 
-      if ($LineTeam['Id'] == $Line['team']) echo(' selected="selected"');
+      if ($LineTeam['Id'] == $Line['Team']) echo(' selected="selected"');
         echo('>'.$LineTeam['Name'].'</option>');
     }