The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Manipulating post table with phpmyadmin
Somehow a member's account has been hacked and hundreds of posts have edited with links to spam.
I would like to run a mysql query on the post table to remove the spam links. I have come up with the following query Code:
update post set pagetext = replace(pagetext,'\n________\nspammer text','') where `userid` = 123 |
#2
|
||||
|
||||
I think it would be more efficient to use the post edit history instead. So instead of finding and replacing that spam text, roll back all posts that have been edited between date A and B, to the previous version.
|
#3
|
|||
|
|||
Thanks for the idea. How would I do that? (im on vb 3.8)
|
#4
|
|||
|
|||
You're query seems fine. I would add a LIMIT 100 and run it a few times just so your db doesn't hang.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|