Location: PHPKode > projects > ADbNewsSender > ADbNewsSender_2.0.4/protected/maintenance/modules/archive_maint.php.inc
<?php
//Copyright (c) Florian Grannemann
//Last change in version: 2.0 Alpha 2
/*
    ******************************************************************************
    ADbNewsSender 2

    Copyright (C) 2009 Florian Grannemann (hide@address.com)
    Website: http://adbnewssender.sf.net


    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 3 of the License, or
    any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License			
    along with this program.  If not, see http://www.gnu.org/licenses/	
    ******************************************************************************
*/

//This maintenance modul deletes outdated archive entries
//function:
function maint_archive($MyCFGro,$MyDB)
{
	$newsletters=array();
	$newsletters=$MyCFGro->get_all_newsletters();
	$i=0;
	if(!@$MyDB->is_connected)
	{
	    if(!@$MyDB->connect())
	    {
		return;
	    }
	}
	while($i < count($newsletters))
	{
	    $result=@$MyDB->query("SELECT value from ADBNS2_NL_Config_Table_".$newsletters[$i]." WHERE name='Archive_storetime';");
	    $row=@$MyDB->fetch_row($result);
	    $storetime=intval($row[0]);
	    if($storetime <1)
	    {
		$storetime=1;
	    }
	    
	    $deletetime=strtotime("-$storetime months");
	
	    //deleting outdated entries:
	    @$MyDB->query("DELETE from ADBNS2_ArchiveTable_".$newsletters[$i]." WHERE date <= $deletetime;");
	    
	    $i++;
	    
	}
		
}

//function call:
maint_archive($MyCFGro,$MyDB);
Return current item: ADbNewsSender