Файл: adultscript-2.0.3-pro/files/mobile/templates/default/extend/ajax/comment_pagination.plugin.php
Строк: 73
<?php
defined('_VALID') or die('Restricted Access!');
function ajax_plugin_comment_pagination()
{
$data = array('status' => 0, 'code' => '', 'msg' => '', 'debug' => '', 'page' => 1, 'end' => 0);
if (isset($_POST['video_id']) && isset($_POST['page'])) {
$video_id = (int) trim($_POST['video_id']);
$page = (int) trim($_POST['page']);
VLanguage::load('frontend.mobile');
$db = VF::factory('database');
$db->query("SELECT title, premium
FROM #__video
WHERE video_id = ".$video_id."
AND status = 1
LIMIT 1");
if ($db->affected_rows()) {
$title = $db->fetch_field('title');
$url = BASE_URL.'/'.$video_id.'/'.prepare_string($title, TRUE).'/';
$user_id = (VAuth::loggedin()) ? (int) $_SESSION['user_id'] : 0;
if (VF::cfg_item('module.mobile.view_comments')) {
$per_page = VF::cfg_item('module.mobile.comments_per_page');
$start = $page*$per_page;
$sql_count = "SELECT COUNT(*) AS total_comments
FROM #__video_comments
WHERE video_id = ".$video_id."
AND status = '1'";
$comments_total = $db->get_field($sql_count, 'total_comments');
$sql = "SELECT c.comment_id, c.parent_id, c.user_id,
c.nickname, c.comment, c.add_date,
u.username, u.gender, u.avatar
FROM #__video_comments AS c
LEFT JOIN #__user AS u ON (u.user_id = c.user_id)
WHERE c.video_id = ".$video_id."
AND c.status = '1'
ORDER BY c.comment_id DESC
LIMIT ".$start.",".$per_page;
$comments = $db->get_rows($sql);
$code = array();
if ($comments) {
foreach ($comments as $comment) {
$code[] = '<li id="comment-'.$comment['comment_id'].'">';
if (!empty($comment['user_id'])) {
$user = htmlspecialchars($comment['username'], ENT_QUOTES, 'UTF-8');
$avatar = ($comment['avatar'] != '') ? $comment['user_id'].'.'.$comment['avatar'] : 'nopic-'.$comment['gender'].'.gif';
$code[] = '<img src="'.BASE_URL.'/media/users/'.$avatar.'" alt="'.$user.' Avatar" />';
} else {
$code[] = '<img src="'.MEDIA_REL.'/users/nopic-hidden.gif" alt="" />';
$user = htmlspecialchars($comment['nickname'], ENT_QUOTES, 'UTF-8');
}
$code[] = '<p>'.nl2br(htmlspecialchars(wordwrap($comment['comment'], 700, "n"), ENT_QUOTES, 'UTF-8')).'</p>';
$code[] = '<p class="cfooter">'.__('by').' <strong>'.$user.'</strong> '.VDate::nice($comment['add_date']).'</p>';
}
}
$data['code'] = implode("n", $code);
$data['status'] = 1;
$data['page'] = $page+1;
if ($start >= $comments_total) {
$data['end'] = 1;
}
} else {
$data['msg'] = __('comments-disabled');
}
} else {
$data['msg'] = __('comment-missing');
}
} else {
$data['msg'] = 'Invalid ajax request!';
}
return json_encode($data);
}
?>