Print Page - Removing the offensive PMs

Poker Forums => The Rail => Topic started by: mikkyT on October 29, 2006, 10:54:09 PM

Title: Removing the offensive PMs
Post by: mikkyT on October 29, 2006, 10:54:09 PM

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

Title: Re: Removing the offensive PMs
Post by: mikkyT on October 29, 2006, 10:56:54 PM

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

Title: Re: Removing the offensive PMs
Post by: Ironside on October 30, 2006, 03:49:26 AM

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

Title: Re: Removing the offensive PMs
Post by: mikkyT on October 30, 2006, 04:04:26 AM

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

Title: Re: Removing the offensive PMs
Post by: snoopy1239 on October 30, 2006, 01:53:23 PM

thanks anyway, mikkyt

blonde poker forum

Poker Forums => The Rail => Topic started by: mikkyT on October 29, 2006, 10:54:09 PM