Users

[GraNdMaStEr-B]

I decided to go another way with my forums so i deleted everything(members) and started fresh, but now when ppl join the forum there user ID number is where it left off when i deleted everything. How do I reset it so when ppl join it will start at 2 (since I own the site and im ID#1)??

thanks!

[lstintxs100]

Did you create a new database or just erase the old members.

The table in the database for userID auto increments. It keeps track of the last number used and adds one to it for the next user.

the database MySQL have an history of "incrementation"... the users table is what we call "auto-increment" it store in memory the last ID of the entry, and will start after the last entry, even if it was deleted in the past, because it is not reversable...

the only way you could drop all these old IDs is by completely erase your forum database and start over...

[Dismounted]

You can artificially change the next value through a query. It is not recommended if you don't know what you're doing, and shouldn't actually be done in general.
[sql]ALTER TABLE user AUTO_INCREMENT = 302[/sql]

[GraNdMaStEr-B]

thank you

[Marco van Herwaarden]

Be carefull not to set it to a value lower then any of the current rows in the database.

PS I would not suggest any such changes at all. The userid is just a number used internally and does not have any meaning, so it does not server any purpose to change them.