<?PHP

/* ====================
Seditio - Website engine
Copyright Neocrome & Seditio Team
http://www.neocrome.net
http://www.seditio.org

[BEGIN_SED]
File=plugins/cleaner/cleaner.php
Version=177
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'); }
	}

?>