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

trunk/registrace.php

@@ -7 +7 @@
 if(array_key_exists('user', $_POST)) 
 {
-  $User = $_POST['user'];
+  $UserName = $_POST['user'];
   $Pass = $_POST['pass'];
   $Pass2 = $_POST['pass2'];
@@ -19 +19 @@
   if($Pass == $Pass2) 
   {
-    $Line = mysql_fetch_row($Database->SQLCommand('SELECT * FROM user WHERE user = "'.$User.'"'));
+    $Line = mysql_fetch_row($Database->SQLCommand('SELECT * FROM `User` WHERE `User` = "'.$User.'"'));
     if(!$Line) 
     {
       $Address = $_SERVER['REMOTE_ADDR'];
       $Salt = GetPasswordSalt();
-      $Database->SQLCommand('INSERT INTO `user` (`user` , `pass` , `Salt`, `LastIP` , `LastLogin` , `Email` , `Language` , `team` , `NeedUpdate`, `RegistrationTime` )
-      VALUES ("'.$User.'", sha1(CONCAT(sha1("'.$Pass.'"), "'.$Salt.'")), "'.$Salt.'", "'.$Address.'", NOW(), "'.$Email.'", '.$Language.', '.$Team.', 1, NOW())');
-   //   $Database->SQLCommand("INSERT INTO user () VALUES('$User','$Pass','0','$Addres',now(),'0','$Email')");
+      $Database->SQLCommand('INSERT INTO `User` (`Name` , `Pass` , `Salt`, `LastIP` , `LastLogin` , `Email` , `Language` , `Team` , `NeedUpdate`, `RegistrationTime` )
+      VALUES ("'.$UserName.'", sha1(CONCAT(sha1("'.$Pass.'"), "'.$Salt.'")), "'.$Salt.'", "'.$Address.'", NOW(), "'.$Email.'", '.$Language.', '.$Team.', 1, NOW())');
       echo('Registrace proběhla úspěšně.<br />');
       
-      $_SESSION['User'] = $User;
+      $_SESSION['User'] = $UserName;
       $_SESSION['Pass'] = $Pass;
     
-      $Line = mysql_fetch_array($Database->SQLCommand('SELECT ID FROM user WHERE user = "'.$_SESSION['User'].'"'));
+      $Line = mysql_fetch_array($Database->SQLCommand('SELECT `ID` FROM `User` WHERE `Name` = "'.$_SESSION['User'].'"'));
       $_SESSION['UserID'] = $Line['ID']; 
       WriteLog('Uživatel se zaregistroval: '.$User, LOG_TYPE_USER);