Removing the offensive PMs

[mikkyT]

http://www.simplemachines.org/community/index.php?topic=115543.msg755538#msg755538

Code:

<?php
include_once('SSI.php');

// Find the IDs of the PMs that this moron sent...
$query = db_query("SELECT ID_PM FROM {$db_prefix}instant_messages WHERE ID_MEMBER_FROM='theirmemberid'");

// Delete them...
while($row = mysql_fetch_assoc($query))
{
    // Delete the actual PM
    $query2a = db_query("DELETE FROM {$db_prefix}instant_messagse WHERE ID_PM = '$row[ID_PM]'", __FILE__, __LINE__);
    // Remove all records of this PM from other users' inboxes now...
    $query2b = db_query("DELETE FROM {$db_prefix}im_recipients WHERE ID_PM = '$row[ID_PM]'", __FILE__, __LINE__);
}

Get someone who knows what they are doing to stick that code above into a file (eg runthis.php), upload the file to the server and open the page in a webbrowser.

It will delete the PMs from the user.

Remember to fill in THEMEMBERID with the ID of the spammer....

[mikkyT]

Side effect is that the number of PMs in the inbox will be out of sync I think...

[Ironside]

as you are quite well aware we are in process of changing our tech team just now

and i dont have access to the server

so untill we get a new tech team in place we cant do that

[mikkyT]

Fair enough (I wasn't aware that only the "tech" guys where the ones with the server details)

[snoopy1239]

thanks anyway, mikkyt