13
OK. Here is the truly working version of this script. It's been tested extensively and it worked fine. I hope you guys have some luck with it.
1. user_id is hardcoded as '1' (my lack of XOOPS knowledge)
2. $xoopsUserIsAdmin is still a question
3. And more work to be done.
Installation: just save the code as deletepm.php file place it in your XOOPS home directory. You can call the file using
http://www.yoursite.com/deletepm.phpAnything else, please feel free to add and share with me.
<?php
//======================================================//
//Author: Chao Moua
//Date: October 29, 2004
//Version: 1.0.1
//CMS Version: XOOPS 2.0.X
//Description: This script will give admin the option to delete select messages that are X days old excluding admin's inbox messages.
//======================================================//
//$xoopsOption['pagetype'] = "admin";
include "mainfile.php";
include "header.php";
//Check for xoopsUser
if (empty($xoopsModuleConfig['anonpost']) && !is_object($xoopsUser)) {
redirect_header("index.php", 0, _NOPERM);
exit();
}
else{
$user_id = $xoopsUser->getVar("uid"); //Get Admin user_id
$user_name = $xoopsUser->getVar("uname"); //Get Admin username
}
//Security check for Admin only
if ($xoopsUserIsAdmin && $user_id == '1' )
{
if (isset($_POST['delete']))
{
$cxn = mysql_connect(XOOPS_DB_HOST , XOOPS_DB_USER, XOOPS_DB_PASS);
mysql_select_db(db);
$delete_time = time() - ( ($delete_day) * 24 * 60 * 60 ); //Credit for the delete_time formula goes to irmtfan at https://xoops.org
$delete_status = $msg_status;
//Reassigning value to $msg_status
if ( $msg_status == 'unread' ) {
$msg_status = '0';
}
elseif ($msg_status == 'read' ) {
$msg_status = '1';
}
elseif ($msg_status == 'all') {
$delete_status = 'read and unread';
}
//Condition to delete selected private messages
if ( empty($delete_day) && $msg_status == 'all' ) {
$sql = "DELETE FROM xoops_priv_msgs WHERE msg_time < '$delete_time' AND to_userid != 1";
$result = mysql_query($sql, $cxn);
echo "<br />All <b>$delete_status</b> Private Messages have been Deleted.<br />";
}
elseif ( empty($delete_day) && $msg_status != 'all' ) {
$sql = "DELETE FROM xoops_priv_msgs WHERE read_msg = '$msg_status' AND msg_time < '$delete_time' AND to_userid != 1";
$result = mysql_query($sql, $cxn);
echo "<br />All <b>$delete_status</b> Private Messages have been Deleted.<br />";
}
elseif ( $delete_day >= '1' && $msg_status == 'all' ) {
$sql = "DELETE FROM xoops_priv_msgs WHERE msg_time < '$delete_time' AND to_userid != 1";
$result = mysql_query($sql, $cxn);
echo "<br />All <b>$delete_status $delete_day</b> days old Private Messages have been Deleted.<br />";
}
else {
$sql = "DELETE FROM xoops_priv_msgs WHERE read_msg = '$msg_status' AND msg_time < '$delete_time' AND to_userid != 1";
$result = mysql_query($sql, $cxn);
echo "<br />All <b>$delete_status $delete_day</b> days old Private Messages have been Deleted.<br />";
}
}
else {
//Admin form to delete private messages
echo "Welcome, <b>$user_name</b>.<br /><br />";
echo "<b>Warning:</b> You are about to delete private messages that are X days old.<br /> ";
echo "Deleted messages cannot be recovered. <br />";
echo "User ID 1 or Primary Admin's private messages will not be deleted. <br />";
echo "IF YOU ENTER NOTHING, ALL SELECT UP-TO-DATE MESSAGES will be deleted!<br />";
echo "<b>Use this script at your own risk.</b><br />";
echo "<form enctype="multipart/form-data" method="post" action="deletepm.php">";
echo "Delete ";
echo "<select size="1" name="msg_status" value="$msg_status"><option>unread</option><option>read</option><option>all</option></select>";
echo " private messages that are ";
echo "<input type="text" name="delete_day" value="30" size="3"> days old. ";
echo "<input type="submit" name="delete" value="delete" />";
echo "</form>";
}
} else {
redirect_header("index.php",0, _NOPERM);
exit();
}
//Print information about the process
echo "<br />";
echo "SQL Command: <b>$sql</b> <br />";
echo "SQL Result: <b>$result </b><br />";
echo "CXN: <b>$cxn</b> <br />";
echo "Affected rows: <b>";
print $xoopsDB->getAffectedRows();
echo "</b><br />";
echo "Output msg_status: <b>$msg_status</b><br />";
echo "Output delete_status: <b>$delete_status</b><br />";
echo "<br />Your admin ID is: <b>$xoopsUserIsAdmin : $user_name </b><br />"; //Show admin ID
echo "<br /><br /><br />";
echo ">><a href="deletepm.php">Delete more messages</a>";
//author Chao Moua
echo "<br /><br /><br />";
echo "<hr />";
echo "Script written by Chao Moua 10-29-2004";
//include footer.php
include "footer.php";
?>