retrieveSettings(); $td = new TimeDate(); $currDate = $td->get_gmt_db_date(); if ( $admin->settings['sugarfeed_flushdate'] != $currDate ) { if ( isset($GLOBALS['db']) ) { $db = $GLOBALS['db']; } if ( ! isset($db) ) { $db = DBManagerFactory::getInstance(); } $tmpTime = time(); $tmpSF = new SugarFeed(); $flushBefore = gmdate($td->dbDayFormat,gmmktime(0,0,0,gmdate('m'),gmdate('d')-14,gmdate('Y'))); $db->query("DELETE FROM ".$tmpSF->table_name." WHERE date_entered < '".$db->quote($flushBefore)."'"); $admin->saveSetting('sugarfeed','flushdate',$currDate); // Flush the cache $admin->retrieveSettings(FALSE,TRUE); } } }