The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Mysql i want to delete user id's @ 0 my attempt
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 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 help needed please anyone ? DELETE FROM table_post WHERE userid = '0' ORDER BY timestamp LIMIT 1 does this sound right ? |
#2
|
|||
|
|||
LIMIT 1 means only one post with userid 0 will be removed. Remove that if you want to remove all posts which have userid 0. You may also want to make sure you have the correct name for the posts table, it is not called table_post on VB
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|