<?PHP
/* ====================
Seditio - Website engine
Copyright Neocrome & Seditio Team
http://www.neocrome.net
http://www.seditio.org
[BEGIN_SED]
File=plugins/cleaner/cleaner.php
Version=175
Updated=2006-sep-07
Type=Plugin
Author=Neocrome
Description=
[END_SED]
[BEGIN_SED_EXTPLUGIN]
Code=cleaner
Part=main
File=cleaner
Hooks=admin.home
Tags=
Order=10
[END_SED_EXTPLUGIN]
==================== */
if (!defined('SED_CODE')) { die('Wrong URL.'); }
if ($cfg['plugin']['cleaner']['userprune']>0)
{
$timeago = $sys['now_offset'] - ($cfg['plugin']['cleaner']['userprune'] * 86400);
$sqltmp1 = sed_sql_query("SELECT user_id FROM $db_users WHERE user_maingrp='2' AND user_lastlog='0' AND user_regdate<$timeago");
$sqltmp2 = sed_sql_query("DELETE FROM $db_users WHERE user_maingrp='2' AND user_lastlog='0' AND user_regdate<$timeago");
$deleted = sed_sql_affectedrows();
while ($row = sed_sql_fetchassoc($sqltmp1))
{
$sqltmp2 = sed_sql_query("DELETE FROM $db_users WHERE user_id='".$row['user_id']."'");
$sqltmp2 = sed_sql_query("DELETE FROM $db_groups_users WHERE gru_userid='".$row['user_id']."'");
}
if ($deleted>0)
{ sed_log("Cleaner plugin deleted ".$deleted." inactivated user account(s)", 'adm'); }
}
if ($cfg['plugin']['cleaner']['logprune']>0)
{
$timeago = $sys['now_offset'] - ($cfg['plugin']['cleaner']['logprune'] * 86400);
$sqltmp = sed_sql_query("DELETE FROM $db_logger WHERE log_date<$timeago");
$deleted = sed_sql_affectedrows();
if ($deleted>0)
{ sed_log('Cleaner plugin deleted '.$deleted.' log entries older than '.$cfg['plugin']['cleaner']['logprune'].' days', 'adm'); }
}
if ($cfg['plugin']['cleaner']['refprune']>0)
{
$timeago = $sys['now_offset'] - ($cfg['plugin']['cleaner']['refprune'] * 86400);
$sqltmp = sed_sql_query("DELETE FROM $db_referers WHERE ref_date<$timeago");
$deleted = sed_sql_affectedrows();
if ($deleted>0)
{ sed_log('Cleaner plugin deleted '.$deleted.' referers entries older than '.$cfg['plugin']['cleaner']['refprune'].' days', 'adm'); }
}
if ($cfg['plugin']['cleaner']['pmnotread']>0)
{
$timeago = $sys['now_offset'] - ($cfg['plugin']['cleaner']['pmnotread'] * 86400);
$sqltmp = sed_sql_query("DELETE FROM $db_pm WHERE pm_date<$timeago AND pm_state=0");
$deleted = sed_sql_affectedrows();
if ($deleted>0)
{ sed_log("Cleaner plugin deleted ".$deleted." PM not read since ".$cfg['plugin']['cleaner']['pmnotread']." days", 'adm'); }
}
if ($cfg['plugin']['cleaner']['pmnotarchived']>0)
{
$timeago = $sys['now_offset'] - ($cfg['plugin']['cleaner']['pmnotarchived'] * 86400);
$sqltmp = sed_sql_query("DELETE FROM $db_pm WHERE pm_date<$timeago AND pm_state=1");
$deleted = sed_sql_affectedrows();
if ($deleted>0)
{ sed_log("Cleaner plugin deleted ".$deleted." PM not archived since ".$cfg['plugin']['cleaner']['pmnotarchived']." days", 'adm'); }
}
if ($cfg['plugin']['cleaner']['pmold']>0)
{
$timeago = $sys['now_offset'] - ($cfg['plugin']['cleaner']['pmold'] * 86400);
$sqltmp = sed_sql_query("DELETE FROM $db_pm WHERE pm_date<$timeago");
$deleted = sed_sql_affectedrows();
if ($deleted>0)
{ sed_log("Cleaner plugin deleted ".$deleted." PM older than ".$cfg['plugin']['cleaner']['pmold']." days", 'adm'); }
}
?>