View Full Version : Mysql delete user id *help*
Almax1
09-14-2003, 09:53 AM
In Mysql i want to delete user id's @ 0 and there posts but i am unsure how to run the query
user id's @ 0 (removed members) are still being called up from some hacks :(
help needed please anyone ?
I don't understand what you mean, user ids at 0? Please could you explain some more...
Almax1
09-14-2003, 10:05 AM
I don't understand what you mean, user ids at 0? Please could you explain some more...
In a recent board move some members were not transferred to the new place there user ids are now 0 i want to delete them from the mysql database as they are still being called up with some hacks installed
Oh, so you want to remove all users who have userid = 0?
DELETE FROM user WHERE userid=0;
BACKUP YOUR DATABASE BEFORE DOING THIS. I won't be held responsible for things going wrong :).
Xenon
09-14-2003, 12:47 PM
there won't be a single user with userid 0.
you just can delete posts from guests:
DELETE FROM post WHERE userid = 0
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.