PDA

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 ?

N9ne
09-14-2003, 09:59 AM
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

N9ne
09-14-2003, 12:13 PM
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