[Mccodes v2] userid help

[kevj2]

Hey guys i had a few user signup to my game but i then deleted them. but now if any one signs up there id is the next in line after the deleted so.For example if i deleted user id 2 the next register user would become 3 even thought 2 was avalable.How would i fix this

[Lithium]

Re: [Mccodes v2] userid help

on phpmyadmin, go to the correspondent table (user and userstats), on the "Operations" tab, inside "Table Options" change the "AUTO_INCREMENT" value to the next id you want to use

[kevj2]

Re: [Mccodes v2] userid help

i dont know waht one to put it in i have open it up but the auto increment is in a drop down what box do i type the number in?

[shrek1609]

Re: [Mccodes v2] userid help

run this in phpmyadmin

 

ALTER TABLE users AUTO_INCREMENT = 1

[Lithium]

Re: [Mccodes v2] userid help

 

run this in phpmyadmin

 

ALTER TABLE users AUTO_INCREMENT = 1

 

Not quite... that will generate an error as userid 1 is already in use.. ;)

[kevj2]

Re: [Mccodes v2] userid help

i got it guys thanks for the help :)

[shrek1609]

Re: [Mccodes v2] userid help

 

run this in phpmyadmin

 

ALTER TABLE users AUTO_INCREMENT = 1

 

Not quite... that will generate an error as userid 1 is already in use.. ;)

nope thats wrong it doesn't set it back to 1

that sets it to the last entry value +1

ie if last userid was 8 it will set it to 9

its what i use when i've deleted users