XF 2.0 [SQL/RegEx problem] How can I remove all quoted content from one user in database?

Lagaf

Member
Hi there,

following problem: we have a user with ~10K posts, who got banned. He now claimed to remove all his posts over the whole forum, so we deleted all of his posts physically. Now, and thats the main problem, there are thousands of QUOTES by other users, which quoted this banned user. He now demands that all those thousands of quotes are also removed from the forum.

We cannot do this manually, so I hope it's possible with a SQL/RegEx statement to remove those quotes concerning this user. I have marked the beginning and ending tag portions in fat letters. Can someone please help me out with the proper sql-regex statement? Thank you very much in advance!

[ QUOTE="UsernameXY, post: 729631, member: 47089"]This is a quote which should be deleted by a SQL/RegEx command.[/QUOTE ]
[ QUOTE="UsernameXY
, post: 976454, member: 47089"]This is another quote which should be deleted by a SQL/RegEx command.[/QUOTE ]
Kind regards, Dominik
 
Back
Top Bottom