function item_adManage_cron()
{
$conn = getConnection();
$allItems = $conn->osc_dbFetchResults("SELECT * FROM %st_item", DB_TABLE_PREFIX);
foreach ($allItems as $itemA) {
$pCats = $conn->osc_dbFetchResult("SELECT * FROM %st_plugin_category WHERE s_plugin_name = '%s' AND fk_i_category_id = '%d'", DB_TABLE_PREFIX, 'adManage', $itemA['fk_i_category_id']);
$pCatCount = count($pCats);
$repub = $conn->osc_dbFetchResult("SELECT * FROM %st_item_adManage_limit WHERE fk_i_item_id = %d", DB_TABLE_PREFIX, $itemA['pk_i_id']);
if (osc_expire_date($itemA['pk_i_id']) == TRUE && $pCatCount != 0) {
item_expire_email($itemA['pk_i_id'], $repub['r_secret'], osc_adManage_expire());
$conn->osc_dbExec("INSERT %st_item_adManage_log (fk_i_item_id, log_date, error_action) VALUES ('%d', '%s', '%s')", DB_TABLE_PREFIX, $itemA['pk_i_id'], date('Y-m-d H:i:s'), 'Ad about to expire email sent. Successful');
}
if (osc_item_adManage_adEmailEx() == 1) {
if (item_is_expired($itemA)) {
$exEmailed = $conn->osc_dbFetchResult("SELECT * FROM %st_item_adManage_limit WHERE fk_i_item_id= '%d'", DB_TABLE_PREFIX, $itemA['pk_i_id']);
if ($exEmailed['ex_email'] != 1) {
item_expired_email($itemA['pk_i_id'], $repub['r_secret'], osc_item_adManage_deleteDays());
$conn->osc_dbExec("UPDATE %st_item_adManage_limit SET ex_email = '%d' WHERE fk_i_item_id = '%d'", DB_TABLE_PREFIX, 1, $itemA['pk_i_id']);
$conn->osc_dbExec("INSERT %st_item_adManage_log (fk_i_item_id, log_date, error_action) VALUES ('%d', '%s', '%s')", DB_TABLE_PREFIX, $itemA['pk_i_id'], date('Y-m-d H:i:s'), 'Expired email sent. Successful');
}
// end check of expired email has been sent.
}
// end of is item expired check.
}
// end of if expired email enabled
if (osc_item_adManage_deleteDays() != 0) {
if ($pCatCount != 0) {
if (item_is_expired($itemA, osc_item_adManage_deleteDays())) {
$item = Item::newInstance()->listWhere("i.pk_i_id = '%s' AND ((i.s_secret = '%s') OR (i.fk_i_user_id = '%d'))", $itemA['pk_i_id'], $itemA['s_secret'], $itemA['fk_i_user_id']);
if (count($item) == 1) {
$mItems = new ItemActions(false);
$success = $mItems->delete($item[0]['s_secret'], $item[0]['pk_i_id']);
if ($success) {
$conn->osc_dbExec("INSERT %st_item_adManage_log (fk_i_item_id, log_date, error_action) VALUES ('%d', '%s', '%s')", DB_TABLE_PREFIX, $itemA['pk_i_id'], date('Y-m-d H:i:s'), 'Cron item deleted. Successful.');
} else {
$conn->osc_dbExec("INSERT %st_item_adManage_log (fk_i_item_id, log_date, error_action) VALUES ('%d', '%s', '%s')", DB_TABLE_PREFIX, $itemA['pk_i_id'], date('Y-m-d H:i:s'), 'Cron item could not be deleted.');
}
// end success
}
// end count of items that need to be deleted.
$conn->osc_dbExec("INSERT %st_item_adManage_log (fk_i_item_id, log_date, error_action) VALUES ('%d', '%s', '%s')", DB_TABLE_PREFIX, $itemA['pk_i_id'], date('Y-m-d H:i:s'), 'Cron item could not be deleted item not found.');
}
// end of if item is expired past set expired date
}
// end check if item is in pCatCount
}
// end check if deleteDays is not equal to zero.
}
//end of foreach
}
if ($days > 999) {
$days = 999;
}
// Set maximum days as per the sql structure of the field: i_expiration_days = int(3)
$conn = getConnection();
$conn->osc_dbExec("UPDATE %st_category SET i_expiration_days = '%s'", DB_TABLE_PREFIX, $days);
osc_add_flash_ok_message(__('Ad expiration successfully set for all categories'), 'admin');
echo '<script>location.href="' . osc_admin_render_plugin_url('advanced_ad_management/admin.php?mUpdated=1') . '"</script>';
}
//end Ad Expiration section
$expire_days = '';
$dao_preference = new Preference();
if (Params::getParam('expire') != '') {
$expire_days = Params::getParam('expire');
} else {
$expire_days = osc_adManage_expire() != '' ? osc_adManage_expire() : '';
}
$payPost = '';
$dao_preference = new Preference();
if (Params::getParam('payPost') != '') {
$payPost = Params::getParam('payPost');
} else {
$payPost = osc_adManage_payperpost() != '' ? osc_adManage_payperpost() : '';
}
$rTimes = '';
$dao_preference = new Preference();
if (Params::getParam('rTimes') != '') {
$rTimes = Params::getParam('rTimes');
} else {
$rTimes = osc_adManage_repubTimes() != '' ? osc_adManage_repubTimes() : '';
}
