The Arcive of vBulletin Modifications Site.

VirtualHogwarts · #1 11-30-2003, 11:47 PM

I want to dealte everyone minus member 1 .. theres like 6 test users LMAO and when I deatle them and reregistar they still go up a # in the usercount, so is there a way to restore it without re installing cuz I did MYSQL changes.

ANY HELP?

Zachery · #2 11-30-2003, 11:53 PM

Quote:

Originally Posted by VirtualHogwarts

I want to dealte everyone minus member 1 .. theres like 6 test users LMAO and when I deatle them and reregistar they still go up a # in the usercount, so is there a way to restore it without re installing cuz I did MYSQL changes.

ANY HELP?

after you remove the users, update most of the counters

VirtualHogwarts · #3 12-01-2003, 12:57 AM

i tried that ... didnt work

Gio Takahashi · #4 12-01-2003, 02:50 AM

When you delete users, their user ID remain intact in the database, delete those user IDs in the database using phpmyadmin, I belive that might work.

VirtualHogwarts · #5 12-01-2003, 03:04 AM

what QUARY should i run?

Zachery · #6 12-01-2003, 04:09 AM

just manually browse the the database via phpmyadmin (i dont know mysql so lol

)

VirtualHogwarts · #7 12-01-2003, 09:54 AM

I dealted them from the MYSQL and re-resistard and I was still Member # 8 ... any ideas?

Dean C · #8 12-01-2003, 03:54 PM

There's so many references to users in vB from the user to userfield table. Would have to run a lot of queries