37 lines
1.6 KiB
PHP
37 lines
1.6 KiB
PHP
<?php
|
|
|
|
require_once($_SERVER['DOCUMENT_ROOT'] . "/config.php");
|
|
|
|
ini_set('display_errors', 1);
|
|
error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);
|
|
|
|
if ($_SESSION['id'] && $_GET['objectId'] && is_numeric($_GET['objectId'])) {
|
|
|
|
$get = clearInputData($_GET);
|
|
|
|
$objectId = $get['objectId'];
|
|
$packageId = $get['packageId'];
|
|
|
|
$userId = $_SESSION['id'];
|
|
|
|
$sqlPackData = "SELECT * from advertising_package WHERE id = $packageId";
|
|
$package = mysql_fetch_assoc(mysql_query($sqlPackData));
|
|
|
|
$sql = "SELECT count(id) FROM advertising_package_object_publish WHERE zipal_id is not null and object_id = $objectId and advertising_package_id = $packageId";
|
|
$rez = mysql_query($sql);
|
|
$count = mysql_result($rez,0);
|
|
|
|
//если объект уже был отправлен, то распубликовываем, иначе удаляем
|
|
if ($count > 0) {
|
|
$sql = "UPDATE advertising_package_object_publish SET sended = 1, published = 1, unpublish = 1, active = 0, unpublish_user_id = $userId WHERE object_id = $objectId and advertising_package_id = $packageId";
|
|
mysql_query($sql);
|
|
} else {
|
|
$sql = "DELETE from advertising_package_object_publish WHERE object_id = $objectId and advertising_package_id = $packageId";
|
|
mysql_query($sql);
|
|
}
|
|
|
|
$logText = "Отправлен на отмену публикации через пакет $package[name] (ID = $packageId)";
|
|
|
|
$sqlLog = "INSERT INTO object_publish_log(object_id, created_at, user_id, log_text) VALUES ('$objectId', NOW(), '$userId', '$logText')";
|
|
mysql_query($sqlLog);
|
|
} |