Can you change the type="text" to type="password" in the register form at the passwords? And please fix this error when i click to the validate link in the email:
Code:
QUERY ERROR: Duplicate entry '2147483647' for key 'PRIMARY'
Query was INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( '***', '***', md5('***'), 1, 100, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, 'Male', unix_timestamp(), '***', -1, '***', '***')
I replaced my data with ***.Query was INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( '***', '***', md5('***'), 1, 100, 0, 0, 1, 12, 12, 100, 100, 5, 5, 100, 100, 1, 'Male', unix_timestamp(), '***', -1, '***', '***')
Auto increment '' of TABLE 'user' COLUMN 'userid' was set due the FB script at max so every new user ended up with the same ID.
I set the auto increment count back to 1700 and everything works fine again now.
I was forced to delete some registration validation records so new signup is needed.
I also change the input type to password
Sorry for any inconvenience cost due this.
Manny thanks for the error detection!
You can have a columb for the facebook id too. Then you have a 'id' and an 'facebook_id' but facebook_id can be null if the user not used fb.
I tried that, but it didn't work out yet, seems there are some troubles with the session and redirection also
