$twig = new Twig_Environment($loader);
if (SET_DEBUG) {
$twig->enableDebug();
} else {
$twig->disableDebug();
}
// ... load the template
outputStatus('Load html template ...');
$template = $twig->loadTemplate('send_recommended/send_all.html');
outputStatus('Region ' . $region);
foreach ($sections as $section => $secParams) {
outputStatus('Traverse section ' . $section);
$formatter_conf = array('section' => $section, 'region' => $region, 'months' => $values['months'], 'base_domain' => $values['base_domain']);
// var_dump($formatter_conf);die;
$spx_config = $region . '_sphinx_' . $section;
$alertHandler->resetArrays();
$liveDB = new DBAdapter2(array('host' => $conf->dbserver->host, 'username' => $conf->dbserver->username, 'password' => $conf->dbserver->password, 'schema' => $values['live_schema']));
// First drop all alerts older than specified!
$moreToFetch = TRUE;
$offset = 0;
$limit = 1000;
// initialize main results container
$finalResults = array();
$idsToUpdate = array();
outputStatus('Change status of older alerts to PENDING.');
// first delete all searches older than max_age_days
if (USE_TEST_MAIL_ARRAY == FALSE) {
deleteOldSearches($liveDB, $section, $secParams['max_age_days']);
}
// start the loop to itterate the database
// for the remaining search alerts