<?php



defined('_IN_JOHNCMS') or die('Error: restricted access');

if(empty($_SESSION['error']))

$_SESSION['error'] = '';

//Функция отображения рейтинга

function rating($id, $type = 0) {

if(!$id)

return '<img class="ico" src="../images/stars/stars_5.gif" alt="0" />';

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_rating` WHERE `news`='$id'"), 0); 

if($total) {

$query = mysql_query("SELECT `golos`, COUNT(*) as `count` FROM `cms_news_rating` WHERE `news`='$id' GROUP BY `golos`");

$array['plus'] = 0;

$array['minus'] = 0;

while (($row = mysql_fetch_assoc($query)) !== false) {

if(isset($row['golos']) && $row['golos'] == 1) $array['plus'] = $row['count'];

else if(isset($row['golos']) && $row['golos'] == 2) $array['minus'] = $row['count'];

else {

$array['plus'] = 0;

$array['minus'] = 0;

}

}

if($array['plus'] > $array['minus']) {

if($array['minus'] == 0) {

if($array['plus'] == 1) $count = 60;

else if($array['plus'] == 2) $count = 60;

else if($array['plus'] == 3) $count = 60;

else if($array['plus'] == 4) $count = 70;

else if($array['plus'] == 5) $count = 70;

else if($array['plus'] == 6) $count = 80;

else if($array['plus'] == 7) $count = 80;

else if($array['plus'] == 8) $count = 90;

else if($array['plus'] == 9) $count = 90;

else if($array['plus'] >= 10) $count = 100;

} else {

$count = round($array['minus'] / $array['plus'], 1) * 100;

if($count == 0)$count = 100;

else $count = (100 - $count);

}

} else if($array['plus'] < $array['minus']) {

if($array['plus'] == 0) {

if($array['minus'] == 1) $count = 40;

else if($array['minus'] == 2) $count = 40;

else if($array['minus'] == 3) $count = 40;

else if($array['minus'] == 4) $count = 30;

else if($array['minus'] == 5) $count = 30;

else if($array['minus'] == 6) $count = 20;

else if($array['minus'] == 7) $count = 20;

else if($array['minus'] == 8) $count = 10;

else if($array['minus'] == 9) $count = 10;

else if($array['minus'] >= 10) $count = 0;

} else {

$pr = (round($array['plus'] / $array['minus'], 1) * 100);

$count = $pr;

}

} else

$count = 50;

$percent = $count;

if($percent == 100)$stars = 10;

else if($percent < 100 && $percent >= 90) $stars = 9;

else if($percent < 100 && $percent >= 90) $stars = 9;

else if($percent < 90 && $percent >= 80) $stars = 8;

else if($percent < 80 && $percent >= 70) $stars = 7;

else if($percent < 70 && $percent >= 60) $stars = 6;

else if($percent < 60 && $percent >= 50) $stars = 5;

else if($percent < 50 && $percent >= 40) $stars = 4;

else if($percent < 40 && $percent >= 30) $stars = 3;

else if($percent < 30 && $percent >= 20) $stars = 2;

else if($percent < 20 && $percent >= 10) $stars = 2;

else if($percent < 10 && $percent > 0) $stars = 1;

else if($percent == 0) $stars = 0;

if($type == 0) return '<img class="ico" src="../images/stars/stars_'.$stars.'.gif" alt="&bull;" />';

else return $percent;

} else return '<img class="ico" src="../images/stars/stars_5.gif" alt="&bull;" />';

}

if($id) {

$query = mysql_query("SELECT `cms_news`.*, `cms_news_cat`.`name` as `catname`, `cms_news_cat`.`id` as `catid` FROM `cms_news` LEFT JOIN `cms_news_cat` ON `cms_news`.`refid`=`cms_news_cat`.`id` WHERE `cms_news`.`id`='$id'".($rights < 7 ? " AND `cms_news`.`time`<='" . time() . "'":"")." LIMIT 1;");

if (mysql_num_rows($query)) {

//Показываем новость

$res1 = mysql_fetch_assoc($query);

$textl = $lng['news'] . ' | ' . htmlentities($res1['name'], ENT_QUOTES, 'UTF-8');

require_once('../incfiles/head.php');

echo '<div class="phdr"><h3>' . htmlentities($res1['name'], ENT_QUOTES, 'UTF-8') . '</h3></div>';

echo '<div class="menu">';

//Выводим картинку

if(file_exists('../files/news/news_' . $id . '.png') !== false)

echo '<img style="float: left; margin: 5px 6px 2px 2px; border: 0px;" src="../files/news/news_' . $id . '.png" alt=""/>';

$text = functions::checkout($res1['text'], 1, 1);

$text = str_replace('Arsenal', '<a target="_blank" href="'.$set['homeurl'].'/1920-Arsenal_-_Umumiy_malumot.html">Arsenal</a>', $text);

if ($set_user['smileys'])

$text = functions::smileys($text);

echo $text;

echo '<div style="clear:both;"></div></div>';

//Обрабатываем голосование

if(isset($_POST['plus_x']) || isset($_POST['plus_y'])) {

if($res1['user_id'] == $user_id) {

$_SESSION['error'] = '<div class="list1 red">' . $lng_news['my_vote'] . '!</div>';

} else {

$plus = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_rating` WHERE `news`='$id' AND `user_id`='$user_id' LIMIT 1;"), 0);

if($plus) {

$_SESSION['error'] = '<div class="list1 red">' . $lng_news['already_voted'] . '!</div>';

} else {

mysql_query("INSERT INTO `cms_news_rating` SET

`news`='$id',

`user_id`='$user_id', `golos`='1';");

$_SESSION['error'] = '<div class="list1 green">' . $lng_news['ok_vote'] . '!</div>';

}

}

Header('Location: index.php?act=view&id=' . $id);

exit;

} else if(isset($_POST['minus_x']) || isset($_POST['minus_y'])) {

if($res1['user_id'] == $user_id) {

$_SESSION['error'] = '<div class="list1 red">' . $lng_news['my_vote'] . '!</div>';

} else {

$plus = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_news_rating` WHERE `news`='$id' AND `user_id`='$user_id' LIMIT 1;"), 0);

if($plus) {

$_SESSION['error'] = '<div class="list1 red">' . $lng_news['already_voted'] . '!</div>';

} else {

mysql_query("INSERT INTO `cms_news_rating` SET

`news`='$id',

`user_id`='$user_id', `golos`='2';");

$_SESSION['error'] = '<div class="list1 green">' . $lng_news['ok_vote'] . '!</div>';

}

}

Header('Location: index.php?act=view&id=' . $id);

exit;

}

//Сообщение об оставленном голосе

echo $_SESSION['error'];

//Выводим автора новости

$us = mysql_query("SELECT `id`, `name` FROM `users` WHERE `id` = '{$res1['user_id']}'");

if (mysql_num_rows($us)) {

$rowuse = mysql_fetch_assoc($us);

$name_use = $user_id ? '<a href="../users/profile.php?user=' . $rowuse['id'] . '">' . $rowuse['name'] . '</a>' : $rowuse['name'];

} else {

$name_use = $lng['guest'];

}

//

echo '<div class="list2"><span class="underline">' . $lng['rating'] . ':</span> ' . rating($id) . '<br />

'.($user_id ? '<form action="index.php?act=view&amp;id=' . $id . '" method="post"><div>

<input style="cursor:none; border: 0px; padding: 0;padding-top: 2px; margin: 0;" type="image" name="plus" value="15" src="../images/like_yes1.gif" alt="' . $lng_news['like'] . '"/><input class="rate" style="cursor:none; border: 0px; margin: 0; padding: 0;padding-top: 2px;" type="image" src="../images/like_no1.gif" name="minus" alt="-"/>

</div></form>':'<img class="ico" src="../images/like_yes1.gif" alt="+" /><img class="ico" src="../images/like_no1.gif" alt="-" /><br />').'

</div><div class="gmenu">

' . $lng_news['posted'] . ': ' . $name_use . '<br />

' . $lng_news['time_posted'] . ': ' . date('d.m.o / H:i', $res1['time'] + $sdvigclock * 3600) . '<br />

'.($res1['time'] > time()?'<div class="func">' . $lng_news['begin_show_through'] . ': ' . timer($res1['time'] - time()) . '</div>':'').'

</div>';



include 'comments.php';



echo '' . ($rights >= 7 ? '<div class="menu"><div class="func">

<a href="../panel/index.php?act=news&amp;mod=newsedit&amp;id=' . $id . '">' . $lng['edit'] . '</a><br />

<a href="../panel/index.php?act=news&amp;mod=delnews&amp;id=' . $id . '">' . $lng['delete'] . '</a><br />

</div></div>':'') . '

<div class="bmenu"><a href="index.php?id=' . $res1['catid'] . '">' . htmlentities($res1['catname'], ENT_QUOTES, 'UTF-8') . '</a></div>';

} else {

$textl = $lng['news'];

require_once('../incfiles/head.php');

echo functions::display_error($lng_news['news_does_not_exist']);

}

} else {

$textl = $lng['news'];

require_once('../incfiles/head.php');

echo functions::display_error($lng_news['news_is_not_chose']);

}

unset($_SESSION['error']);