Thanks!
Quote:
irmtfan wrote:
at least about pm i do it without any problem for 2 years.
i use a very simple script:<?php
define("user", "dbuser");
define("pass", "dbpass");
define("host", "localhost");
define("db", "dbname");
$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.
$result = mysql_query($sql, $cxn);
?>
and run it every day with a cron.
MP manager can purge pm too but i dont use it because i need to do it automatically every day.
and about notification its in the Herve todo list for the future version of his new module xoopscare.