} 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() : '';
}
$freeTimes = '';
$dao_preference = new Preference();
if (Params::getParam('freeTimes') != '') {
$freeTimes = Params::getParam('freeTimes');
} else {
$freeTimes = osc_item_adManage_freeRepubs() != '' ? osc_item_adManage_freeRepubs() : '';
}
$adEmailEx = '';
$dao_preference = new Preference();
if (Params::getParam('adEmailEx') != '') {
$adEmailEx = Params::getParam('adEmailEx');
} else {
$adEmailEx = osc_item_adManage_adEmailEx() != '' ? osc_item_adManage_adEmailEx() : '';
}
$deleteDays = '';
$dao_preference = new Preference();
if (Params::getParam('deleteDays') != '') {
$deleteDays = Params::getParam('deleteDays');
} else {
$deleteDays = osc_item_adManage_deleteDays() != '' ? osc_item_adManage_deleteDays() : '';
}
$id = Params::getParam('id') ? Params::getParam('id') : '';
$conn = getConnection();
$rSecretOk = $conn->osc_dbFetchResult("SELECT * FROM %st_item_adManage_limit WHERE fk_i_item_id = '%d' AND r_secret = '%s'", DB_TABLE_PREFIX, $id, $rSecret);
$item = $conn->osc_dbFetchResult("SELECT * FROM %st_item WHERE pk_i_id = '%d' AND (s_secret = '%s' OR fk_i_user_id = '%d')", DB_TABLE_PREFIX, $id, $secret, osc_logged_user_id());
if ($item['pk_i_id'] != 0 && $rSecretOk['r_secret'] != '') {
if ($rSecretOk['r_times'] < osc_adManage_repubTimes() || osc_adManage_repubTimes() == 0) {
$date = date('Y-m-d H:i:s');
$rTimes = $rSecretOk['r_times'] + 1;
$conn->osc_dbExec("UPDATE %st_item SET dt_pub_date = '%s' WHERE pk_i_id = '%d' ", DB_TABLE_PREFIX, $date, $id);
$category = Category::newInstance()->findByPrimaryKey($item['fk_i_category_id']);
$expiration = $category['i_expiration_days'];
Item::newInstance()->updateExpirationDate($item['pk_i_id'], $expiration, false);
$conn->osc_dbExec("UPDATE %st_item_adManage_limit SET r_secret = '%s', r_times = '%d' WHERE fk_i_item_id = '%d' ", DB_TABLE_PREFIX, osc_genRandomPassword(), $rTimes, $id);
$rTimes = 0;
if (osc_adManage_payperpost() == 1) {
if (osc_item_adManage_freeRepubs() == 0 || $rSecretOk['r_times'] >= osc_item_adManage_freeRepubs()) {
// This checks to see if there is a db table "t_paypal_publish", if so, set republished item as "unpaid"
$check_if_paypal_enabled = $conn->osc_dbFetchResult("SELECT b_paid FROM %st_paypal_publish WHERE fk_i_item_id = %d", DB_TABLE_PREFIX, $id);
if ($check_if_paypal_enabled) {
$conn->osc_dbExec("UPDATE %st_paypal_publish SET dt_date = '%s', b_paid = '0' WHERE fk_i_item_id = %d", DB_TABLE_PREFIX, date('Y-m-d H:i:s'), $id);
}
}
}
$conn->osc_dbExec("UPDATE %st_item_adManage_limit SET ex_email = '%d' WHERE fk_i_item_id = '%d'", DB_TABLE_PREFIX, 0, $id);
osc_add_flash_ok_message(__('Item has been republished', 'adManage'));
$conn->osc_dbExec("INSERT %st_item_adManage_log (fk_i_item_id, log_date, error_action) VALUES ('%d', '%s', '%s')", DB_TABLE_PREFIX, $id, date('Y-m-d H:i:s'), 'Item Republished. ' . date('Y-m-d H:i:s'));
header('Location: ' . $_SERVER['HTTP_REFERER']);
// header("Location: " . osc_base_url(true) . '?page=item&id=' . $id);
exit;
//else statement if the number of republish times has been reached
} else {
