Web Threads

A useful MySQL query to delete a spam PM content on Simple Machines Forum.

Change the ‘numberhere’ to be the spammer’s user id number and change the table prefix to your own prefix if different. This does not delete the PM, but does replace the spam content.

 
UPDATE `smf_instant_messages` SET `body` = 'Message deleted due to spam' WHERE `ID_MEMBER_FROM` = 'numberhere';

Always always back up before running queries or making changes.

This is useful in the case of porn spam, however, people will have gotten any PM notifications of that.

Like

Unlike

Written by Web Threads

Follow Web Threads on Twitter