89 lines
2.6 KiB
PHP
89 lines
2.6 KiB
PHP
|
<?php
|
||
|
|
set_time_limit(0);
|
||
|
|
require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
|
||
|
|
|
||
|
|
ini_set('display_errors', 1);
|
||
|
|
error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);
|
||
|
|
|
||
|
|
?>
|
||
|
|
<!doctype html>
|
||
|
|
<html>
|
||
|
|
<head>
|
||
|
|
<meta charset="utf-8">
|
||
|
|
<title>Получение просмотров пакетов объектов на Zipal.ru</title>
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<body>
|
||
|
|
<?php
|
||
|
|
|
||
|
|
$sql = "SELECT id, user_id, zipal_id, object_id from advertising_package_object_publish WHERE sended = 1 and published = 1 and active = 1";
|
||
|
|
$rez_obj = mysql_query($sql);
|
||
|
|
|
||
|
|
while($object = mysql_fetch_assoc($rez_obj)) {
|
||
|
|
|
||
|
|
$objId = $object['object_id'];
|
||
|
|
|
||
|
|
$curUser = new User();
|
||
|
|
$curUser->get($object['user_id']);
|
||
|
|
|
||
|
|
$requestToSend = [];
|
||
|
|
|
||
|
|
$login = $curUser->zipal_login;
|
||
|
|
$password = $curUser->zipal_password;
|
||
|
|
|
||
|
|
if (empty($login) || empty($password)) {
|
||
|
|
$login = $curUser->agencyZipalLogin;
|
||
|
|
$password = $curUser->agencyZipalPassword;
|
||
|
|
}
|
||
|
|
|
||
|
|
$requestToSend = [];
|
||
|
|
|
||
|
|
$requestToSend['login'] = $login;
|
||
|
|
$requestToSend['password'] = $password;
|
||
|
|
$requestToSend['method'] = 'GetAdViews';
|
||
|
|
$requestToSend['request'] = [];
|
||
|
|
$requestToSend['request']['requestType'] = 'GetAdViewsRequestType';
|
||
|
|
$requestToSend['request']['id'] = $object['zipal_id'];
|
||
|
|
$requestToSend['request']['byDestination'] = true;
|
||
|
|
|
||
|
|
$request = json_encode($requestToSend);
|
||
|
|
|
||
|
|
//echo $request;
|
||
|
|
//echo "<br/>";
|
||
|
|
|
||
|
|
$user_agent = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; HTC_Touch_Diamond2_T5353; Windows Phone 6.5)';
|
||
|
|
|
||
|
|
//делаем запрос к zipal
|
||
|
|
$result = curl_request_zipal_json("https://zipal.ru/ws/json", $object['user_id'], $user_agent, $request);
|
||
|
|
|
||
|
|
//echo $result;
|
||
|
|
|
||
|
|
$jsonResult = json_decode($result, true);
|
||
|
|
|
||
|
|
if ($jsonResult['resultCode'] == "OK") {
|
||
|
|
|
||
|
|
if (count($jsonResult['result']['destination']) > 0) {
|
||
|
|
foreach ($jsonResult['result']['destination'] as $dest) {
|
||
|
|
|
||
|
|
$zipalCode = $dest['destination'];
|
||
|
|
$views = $dest['adViews'];
|
||
|
|
|
||
|
|
$sql = "SELECT id FROM object_feed_stat WHERE zipal_id = '$object[zipal_id]' and object_id = $objId and zipal_code = '$zipalCode'";
|
||
|
|
$rez = mysql_query($sql);
|
||
|
|
|
||
|
|
if (mysql_num_rows($rez) > 0) {
|
||
|
|
//если нашли запись - обновляем кол-во просмотров
|
||
|
|
$stat = mysql_fetch_assoc($rez);
|
||
|
|
$id = $stat['id'];
|
||
|
|
$sql = "UPDATE object_feed_stat SET view_count = $views WHERE id=$id";
|
||
|
|
mysql_query($sql);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
//sleep(1);
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</body>
|
||
|
|
</html>
|