Файл: adultscript-2.0.3-pro/files/mobile/templates/default/extend/ajax/channel_subscribe.plugin.php
Строк: 61
<?php
defined('_VALID') or die('Restricted Access!');
function ajax_plugin_channel_subscribe()
{
$data = array('status' => 0, 'code' => '', 'msg' => '', 'debug' => '');
VLanguage::load('frontend.channel');
if (isset($_POST['channel_id'])) {
$user_id = (VAuth::loggedin()) ? (int) $_SESSION['user_id'] : 0;
if (!$user_id) {
$data['msg'] = __('subscribe-login');
return json_encode($data);
}
$channel_id = (int) trim($_POST['channel_id']);
$db = VF::factory('database');
$db->query("SELECT channel_id
FROM #__channel_subscribers
WHERE channel_id = ".$channel_id."
AND user_id = ".$user_id."
LIMIT 1");
if ($db->affected_rows()) {
$data['msg'] = __('subscribe-already');
return json_encode($data);
}
$db->query("SELECT total_subscribers
FROM #__channel
WHERE channel_id = ".$channel_id."
LIMIT 1");
if ($db->affected_rows()) {
$total_subscribers = (int) $db->fetch_field('total_subscribers');
$db->query("UPDATE #__channel
SET total_subscribers = total_subscribers+1
WHERE channel_id = ".$channel_id."
LIMIT 1");
$db->query("INSERT INTO #__channel_subscribers
SET channel_id = ".$channel_id.",
user_id = ".$user_id.",
add_time = ".time());
$data['code'] = __('subscribed').' ('.($total_subscribers+1).')';
$data['msg'] = __('subscribed');
$data['status'] = 1;
} else {
$data['msg'] = __('channel-invalid');;
}
}
return json_encode($data);
}
?>