irmtfan wrote:
in my site some users dont check the inbox for ages and the pms reach to 1000 or higher.
so this is a big problem in the site and i write ( with very help from others ) a php script to delete old unread pms . and that's it :

<?php
define("user", "user_db");  // write user of your database here
define("pass", "password"); // write password here
define("host", "localhost"); // change it if your localhost is different
define("db", "database_name"); //write name of your database here


$cxn = mysql_connect(host ,user, pass);
mysql_select_db(db);

$delete_time = time() - ( 30 * 24 * 60 * 60 );  // 30 days/month * 24 hrs/day
// * 60 minutes/hour * 60 seconds/min.

$sql = "DELETE from `xoops_priv_msgs` WHERE `read_msg` = '0' AND `msg_time` < '$delete_time'";
//This script would delete everything older than 30 days that has been not read.
//note: if your perfix is different plz notice that change the 'xoops' with your perfix at 'xoops_priv_msgs' table
$result = mysql_query($sql, $cxn);
?>

<?php

include "mainfile.php";
include "header.php";

/*
define("XOOPS_DB_USER", "username"); // write user of your database here
define("XOOPS_DB_PASS", "password"); // write password here
define("XOOPS_DB_HOST", "localhost"); // change it if your localhost is different
define("XOOPS_DB_NAME", "xoops"); //write name of your database here

$cxn = mysql_connect(XOOPS_DB_HOST , XOOPS_DB_USER, XOOPS_DB_PASS);
mysql_select_db(XOOPS_DB_NAME);
*/

if ($xoopsUserIsAdmin){

$delete_day = "30"; //Plan to use a drop-box to select day: 5, 10, 15, 30, 60, 90 etc...

echo "<br />Delete Days: $delete_day";
//$delete_time = time() - ( 30 * 24 * 60 * 60 ); // 30 days/month * 24 hrs/day
// * 60 minutes/hour * 60 seconds/min.
$delete_time = time() - ( ("$delete_day") * 24 * 60 * 60 );

echo "<br />Delete time is: $delete_time"; //Show delete time
echo "<br />The admin is: $xoopsUserIsAdmin"; //Show admin ID

$sql = "DELETE FROM `xoops_priv_msgs` WHERE `read_msg` = '0' AND `msg_time` < '$delete_time'";
//This script would delete everything older than 30 days that has been not read.
//note: if your perfix is different plz notice that change the 'xoops' with your perfix at 'xoops_priv_msgs' table
//$result = mysql_query($sql, $cxn);

echo "<br />Old Unread Private Messages Deleted: $delete_count"; //Need to count, but don't know how yet.
}else{
redirect_header("index.php",0);
exit();
}

include "footer.php";
?>