reset users to 1

[Skivey]

I have a hacked website which I am duplicating into a different domain. I have 2 vb licenses.

What I need to do is I need to delete all users forums posts etc..... and have user 1 only, so I am starting from scratch.

The forum is mass hacked, so it isnt easy to replicate.

I have succeeded in deleting everything so far including the users forum posts threads forums.... everything, but the problem I have atm is when I registered account number 2 it was user 3652, how do I reset the user count?

thanks

Matt

[Simon Lloyd]

you'd have to empty tables in the database and then reset those tables that had auto increment back to 1. But if you are starting fresh why not just install as new? you can then import a style to change it to how it looked.

[Skivey]

no really i cant, it has over 300 hacks..... im searching the db for the last usernumber, I managed to reset 1 thing but that didnt work... ill find the others i hopes

--------------- Added [DATE]1329049592[/DATE] at [TIME]1329049592[/TIME] ---------------

replaced all what I thought was the counters.... didnt work grrr still starting too high

[kh99]

You need to do this query:

ALTER TABLE user AUTO_INCREMENT = 1;

But like Simon Lloyd says, it's hard to imagine mods that you couldn't export and reimport. I think even manual database changes could be copied over by exporting just the db structure.

[Skivey]

oh man you legend! thanks so much

[Simon Lloyd]

Just one other note, if you really do have over 300 hacks then you're asking for trouble, you should really try and prune those down to "Must haves" it will save you a ton of processor time and bandwidth and decrease the likelyhood of your site being hacked again!

[Skivey]

id love to prune it down, i just dont have the knowledge to do so. Maybe in the future when I have money then possibly...