} 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() : ''; } $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() : ''; }
function republish_url() { $conn = getConnection(); $pCats = $conn->osc_dbFetchResult("SELECT * FROM %st_plugin_category WHERE s_plugin_name = '%s' AND fk_i_category_id = '%d'", DB_TABLE_PREFIX, 'adManage', osc_item_category_id()); $pCatCount = count($pCats); $adManage_url = ''; $rSecret = $conn->osc_dbFetchResult("SELECT * FROM %st_item_adManage_limit WHERE fk_i_item_id = '%d'", DB_TABLE_PREFIX, osc_item_id()); if (($rSecret['r_times'] < osc_adManage_repubTimes() || osc_adManage_repubTimes() == 0) && $pCatCount != 0) { if (osc_item_is_expired()) { $adManage_url = osc_base_url() . 'oc-content/plugins/advanced_ad_management/item_republish.php?repub=republish&id=' . osc_item_id() . '&rSecret=' . $rSecret['r_secret']; } } return $adManage_url; }
<?php //set include define('ABS_PATH', dirname(dirname(dirname(dirname(__FILE__)))) . '/'); require_once ABS_PATH . 'oc-load.php'; $repub = Params::getParam('repub'); if ($repub == 'republish') { // repost item $secret = Params::getParam('secret') ? Params::getParam('secret') : ''; $rSecret = Params::getParam('rSecret') ? Params::getParam('rSecret') : ''; $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); }