hirev Posted October 22, 2008 Posted October 22, 2008 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. ___________________________ Quote
Uridium Posted October 22, 2008 Posted October 22, 2008 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 Quote
Floydian Posted October 22, 2008 Posted October 22, 2008 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. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.