Delate Users TOTALY! [Archive]

VirtualHogwarts

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

11-30-2003, 11:53 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?
after you remove the users, update most of the counters

VirtualHogwarts

12-01-2003, 12:57 AM

i tried that ... didnt work

Gio Takahashi

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

12-01-2003, 03:04 AM

what QUARY should i run?

Zachery

12-01-2003, 04:09 AM

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

VirtualHogwarts

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

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 :)