User ID Problem

[DELETE-ME-NOW-]

When people join my game, they are getting ID 100000+ even though i dont have anywere near that amount of players. I think its because i made a test account ID 10000. Bu the account is deleted and new players are still getting those high ID's.

Any solution to this?

[Uridium]

You have to remember when a SQL inserts from a file example INSERT INTO it continues from its last ID so even if you had ID1 then decided to INSERT ID 1000 it will continue from ID 10000.

if you dont have many users in the game you could extract the tables users, userstats, inventory and manually fix the numbers dont forget though you will need to make the final id of the table 1 higher when inserting

example on your extracted SQLS you will see

ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1000 <<< using 1000 as a guidline so if your real value is 23 then the 1000 needs to be 24

[rulerofzu]

Head over to PHP Myadmin select the users table and then click on the sql tab

SET insert_id = xx;

Replace xx with the next number you wish it to increment.

Run the query and you should be good to go.

[DELETE-ME-NOW-]

Thanks alot guys. Appreciate it.