Example #1
0
} 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() : '';
}
Example #2
0
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;
}
Example #3
0
<?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);
                    }