Jump to content
MakeWebGames

Recommended Posts

Posted

Hi i am looking for a Mod to delete all users in my game and reuse the user ID's.

I am about to launch my game in the next few weeks and I have like 10 test accounts. I want to be able to start users at user ID 2 instead of 10 or 11.

if anyone knows a Query to do this or a mod that can do this can you post it.

Also i am sorry if this is the wrong section I am not sure where to post now that things are changed around and never noticed a mod request section.

 

 

___________________________

Posted

Re: delete user and reuse userID

why not just use the ones that you have now and change them to challenge bots just change their user_level to zero and remove passwords for their accounts

Posted

Re: delete user and reuse userID

Don't just run this query blindly, but...

 

truncate users;

 

That query drops the users table, then recreates a clean users table with the auto increment set at 1. That means the next person to sign up (who will be the first user) will have the "1" userid.

Don't forget to reset (or truncate) tables like inventory, userstats, and anything else that stores user specific data.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...