ลบข้อความส่วนตัวของสมาชิกตามจำนวนวันที่กำหนด

'removepoll' => array('Poll.php', 'RemovePoll'),

'removepm' => array('PersonalMessage.php', 'removepm'),

</tr>
</table>';

// Pop up a box to say function completed if the user has been redirected back here from a function they ran.

// Delete the specified personal messages.

// RemovePrivateMessage
function removepm()
{
global $db_prefix, $modSettings;

//Can they use the Force?
if(!allowedTo('admin_forum'))
redirectexit();

// Make sure they came from our site..
checkSession();

// serch for pm unread and other condition
$request = db_query("SELECT t2.is_read, t2.ID_MEMBER FROM {$db_prefix}personal_messages AS t1, {$db_prefix}pm_recipients AS t2
WHERE t1.ID_PM = t2.ID_PM AND t1.msgtime < " . (time() - 3600 * 24 * $_POST['maxpmdays']), __FILE__, __LINE__);

while ($row = mysql_fetch_assoc($request))
{
//if PM is unread --> decrement unreadMessages from members table.
if ( $row['is_read'] == '0' )
db_query("UPDATE {$db_prefix}members SET unreadMessages = unreadMessages - 1 WHERE ID_MEMBER = " . $row['ID_MEMBER'], __FILE__, __LINE__);

//decrement instantMessages from members table
db_query("UPDATE {$db_prefix}members SET instantMessages = instantMessages - 1 WHERE ID_MEMBER = " . $row['ID_MEMBER'], __FILE__, __LINE__);

//delete pm
db_query("DELETE t1, t2 FROM {$db_prefix}personal_messages AS t1, {$db_prefix}pm_recipients AS t2
WHERE t1.ID_PM = t2.ID_PM AND t1.msgtime < " . (time() - 3600 * 24 * $_POST['maxpmdays']), __FILE__, __LINE__);
}

redirectexit('action=maintain;done');
}

?>