Quote from: KriszDev on July 16, 2014, 05:05:00 AM

Quote from: gensen on July 15, 2014, 10:52:46 PM

Quote from: KriszDev on July 15, 2014, 03:27:13 PM

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 ***.

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 Angry