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
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.