I've got a recent request from a user to delete his user and its posts, up to here all is good, I deleted everything, but now the user realised that the quotes to his posts are still present on the board and he is threatening with a GDPR complaint.
I know this doesn't have wings to fly and this guy is just being a PITA, but is there a way to remove the quotes ?
I think it can be solved by running something like:
Code: Select all
SELECT * FROM `phpbb_posts` WHERE post_text like "%<QUOTE author=\"USERNAME%"
Code: Select all
$new_post_text = preg_replace('#<QUOTE author=\"USERNAME*>.*?</QUOTE>#si', '', $post_text);
But would I need to reparse the whole posts ? or would this be enough ?
Thanks in advance for all the help and support I can get.