View Single Post
  #2  
Old 06-01-2009, 07:43 PM
Bloodrun's Avatar
Bloodrun Bloodrun is offline
I am, who I am.
 
Join Date: Apr 2009
Posts: 532
Gender: Male
Credits: 44,272
Bloodrun
Send a message via Yahoo to Bloodrun
Default RE: can't registered

Then, go to your register.php file, find where it says:
PHP Code:
        mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0')"); 
and place this at the very end:
PHP Code:
'' 
So that it will looks like this:
PHP Code:
        mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0', '')"); 
Why do we do this?
Let's let BMR777 explain that one:
Adding an extra field onto the users table requires you to edit register.php so the SQL query for creating a new user matches with the new database table structure. Failure to do this will BREAK the user registration system.
Reply With Quote