Manipulating post table with phpmyadmin

[0ptima]

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


update post set pagetext = replace(pagetext,'\n________\nspammer text (http://spam.net/)','')
where `userid` = 123



This seems to do the trick and I tested it on a local installation. I was would like to know if there are any consequences of running such a query on my real forum and if there is a better way of deleting the spam links. Thanks.

[Alfa1]

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.

[0ptima]

Thanks for the idea. How would I do that? (im on vb 3.8)

[souperman]

You're query seems fine. I would add a LIMIT 100 and run it a few times just so your db doesn't hang.