Файл: region_clean/journal/index.php
Строк: 940
<?php
#######################################
## Mod By KoT (borispol) [76-75-072] ##
#######################################
require_once "../start.php";
require_once "../sid.php";
header("Cache-Control: no-cache");
if ($ver == "wml") header ("Content-type:text/vnd.wap.wml; charset=utf-8");
else header("Content-Type:text/html; charset=UTF-8");
require_once "../inc.php";
$link = connect_db();
list($row, $id, $ps, $fsize1, $fsize2) = check_login($link);
require_once "../version.php";
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>
<card id="index" title="Журнал чата">
<p align="center">";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="../css/css.css"/>
<title>Журнал чата</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="center">";
}
$config_bookpost = 5;
$day = date("d.m.y");
$timer = date("H:i");
$idsd = $_SESSION['id'];
echo '<div class="c4">Главная журнала</div><br/>';
if ($action == '') {
echo '<a href="index.php?'.$ses.'&ref='.$ref.'">[Обновить]</a><br/><a href="index.php?action=top&'.$ses.'&ref='.$ref.'">[ТОП Статей]</a><br/><a href="index.php?action=new&'.$ses.'&ref='.$ref.'">[Новые за сегодня]</a><br/><br/>';
$resultx = mysql_query("SELECT `id`,`name`,`about`,`type`,`down_type`,`realid` FROM `journal` WHERE `type`='r' order by realid;");
$count_users_on_pagex = mysql_num_rows($resultx);
for($i = 0; $i < $count_users_on_pagex; $i++)
{
$row = mysql_fetch_array($resultx);
$uid = $row[0];
$name = $row[1];
$about = $row[2];
$type = $row[3];
$downtype = $row[4];
$realid = $row[5];
if ($downtype == 1) { echo'<a href="index.php?action=cat&uid='.$uid.'&'.$ses.'&ref='.$ref.'">'.$name.'</a>';
$resultxd = mysql_query("SELECT count(`id`) FROM `journal` WHERE `refid`='".$uid."';");
$cntDataxd = mysql_fetch_row($resultxd);
$count_usersxd = $cntDataxd[0];
echo "<br/>Категорий: ".$count_usersxd."";
echo '<br/><small>'.$about.'</small><br/><br/>';
}
if ($downtype == 0) { echo'<a href="index.php?action=view&uid='.$uid.'&'.$ses.'&ref='.$ref.'">'.$name.'</a> ';
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='a' AND `refid`='".$uid."';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
$dates = date("d.m.y");
$resultx = mysql_query("SELECT count(`id`) FROM `journal` WHERE `new_date`='".$dates."' AND `refid`='".$uid."';");
$cntDatax = mysql_fetch_row($resultx);
$count_usersx = $cntDatax[0];
if ($count_usersx == 0) {
echo "<br/>Cтатей: ".$count_users;
}
if ($count_usersx != 0) {
echo "<br/>Cтатей: ".$count_users."<br/>За сегодня: +".$count_usersx."";
}
echo '<br/><small>'.$about.'</small>';
}
}
$dates = date("d.m.y");
echo '<div class="c4">Глобальная статистика журнала:<br/>';
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='a';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
echo 'Статей: <b>'.$count_users.'</b><br/>';
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `new_date`='".$dates."';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
echo 'Статей сегодня: <b>'.$count_users.'</b><br/>';
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='k';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
echo 'Комментариев: <b>'.$count_users.'</b><br/>';
$result = mysql_query("SELECT sum(`vote_col`) FROM `journal` WHERE `type`='a';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
echo 'Оценок: <b>'.$count_users.'</b><br/>';
$result = mysql_query("SELECT sum(`count`) FROM `journal` WHERE `type`='a';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
echo 'Прочтений: <b>'.$count_users.'</b></div><br/>';
}
if ($action == "cat") {
$uid = intval($_GET['uid']);
if (!is_numeric($uid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo '<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($_GET['uid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $uid . "';");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "r")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if ($ms['down_type'] != 1)
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
echo '<a href="index.php?action=cat&uid='.$uid.'&'.$ses.'&ref='.$ref.'">[Обновить]</a><br/><br/>';
$resultx = mysql_query("SELECT `id`,`name`,`about` FROM `journal` WHERE `type`='f' AND `refid`='".$uid."';");
$count_users_on_pagex = mysql_num_rows($resultx);
for($i = 0; $i < $count_users_on_pagex; $i++)
{
$row = mysql_fetch_array($resultx);
$fid = $row[0];
$name = $row[1];
$about = $row[2];
echo '<a href="index.php?action=view&fid='.$fid.'&'.$ses.'&ref='.$ref.'">'.$name.'</a> ';
$result12 = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='a' AND `refid`='".$fid."';");
$cntData12 = mysql_fetch_row($result12);
$count_users12 = $cntData12[0];
$dates = date("d.m.y");
$resultx1 = mysql_query("SELECT count(`id`) FROM `journal` WHERE `new_date`='".$dates."' AND `refid`='".$fid."';");
$cntDatax1 = mysql_fetch_row($resultx1);
$count_usersx1 = $cntDatax1[0];
if ($count_usersx1 == 0) {
echo "<br/>Cтатей: " . $count_users12;
}
if ($count_usersx1 != 0) {
echo "<br/>Cтатей: ".$count_users12."<br/>За сегодня: +" . $count_usersx1;
}
echo '<br/><small>'.$about.'</small><br/><br/>';
}
if ($count_users_on_pagex == 0) {
echo 'Пока категории не созданы...<br/><br/>';
}
}
if ($action == "view") {
if (empty($_GET['p'])) $page = 1;
else $page = intval($_GET['p']);
$fid = intval($_GET['fid']);
if (!is_numeric($fid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($_GET['fid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $fid . "';");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "r" and $ms['type'] != "f")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
echo '<a href="index.php?action=view&fid='.$fid.'&'.$ses.'&ref='.$ref.'">Обновить</a>';
$filex = file("journalist.dat");
$countx = count($filex);
$switchx = 0;
$wordx = "$idsd";
for ($ix = 0; $ix < $countx; $ix++) {
if (trim($filex[$ix]) == $wordx) { $switchx=1; } }
$filexd = file("editors.dat");
$countxd = count($filexd);
$switchxd = 0;
$wordxd = "$idsd";
for ($ixd = 0; $ixd < $countxd; $ixd++) {
if (trim($filexd[$ixd]) == $wordxd) { $switchxd=1; } }
if ($switchx == 1 or $switchxd == 1)
{
echo ' | <a href="index.php?action=add&fid='.$fid.'&'.$ses.'&ref='.$ref.'">Новая статья</a><br/>'; }
echo '<br/>';
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='a' AND `refid`='".$fid."';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
$max_page = ceil($count_users / 5);
$page = ($page > $max_page) ? (($max_page == 0) ? $page : $max_page) : $page;
$start = 5*($page-1);
$end = 5;
$resultx = mysql_query("SELECT `id`,`name`,`about`,`type`,`down_type`,`realid`,`refid`,`nick`,`vote`,`vote_col`,`date`,`new_date` FROM `journal` WHERE `type`='a' AND `refid`='".$fid."' ORDER BY realid DESC LIMIT $start,$end;");
$count_users_on_pagex = mysql_num_rows($resultx);
for($i = 0; $i < $count_users_on_pagex; $i++)
{
$row = mysql_fetch_array($resultx);
$rid = $row[0];
$name = $row[1];
$about = $row[2];
$type = $row[3];
$downtype = $row[4];
$realid = $row[5];
$refid = $row[6];
$nick = $row[7];
$vote = $row[8];
$vote_col = $row[9];
$dats = $row[10];
$ndats = $row[11];
$dats = date("d.m.y / H:i",$dats);
$rs = mysql_query("SELECT `user` FROM `users` WHERE `id`='".mysql_real_escape_string($nick)."';");
$rowx = mysql_fetch_array($rs);
$uz = $rowx[0];
$currdate = date("d.m.y");
$hoursx = date("H:i",$dats);
if ($ndats == $currdate) { $cxx = "Сегодня"; $sxx = "/ $hoursx"; }
if ($ndats != $currdate) { $cxx = $dats; $sxx = ""; }
echo'<a href="index.php?action=read&rid='.$rid.'&'.$ses.'&ref='.$ref.'">'.$name.'</a><br/><small>'.$about.'</small><br/>Добавил: <a href="../info.php?'.$ses.'&nk='.$nick.'&ref='.$ref.'">'.$uz.'</a><br/>Дата: '.$cxx.' '.$sxx.'<br/>';
}
echo '<br/>';
if ($i == 0)
{
echo '<br/><center><b>Статей пока нет!</b></center><br/>';
}
if ($max_page > 1)
{
$ba = ceil($count_users/5);
$ba2 = $ba * 5 - 5;
echo 'Страницы:';
$asd = $start - (5 * 4);
$asd2 = $start + (5 * 5);
if ($asd < $count_users and $asd > 0) {
echo ' <a href="index.php?action=view&fid='.$fid.'&p=1&'.$ses.'&ref='.$ref.'">1</a> ... ';
}
for($i = $asd; $i < $asd2;)
{
if ($i < $count_users and $i >= 0) {
$ii = floor(1 + $i/5);
if ($start == $i) {
echo ' <b>('.$ii.')</b>';
}
else
{
echo ' <a href="index.php?action=view&fid='.$fid.'&p='.$ii.'&'.$ses.'&ref='.$ref.'">'.$ii.'</a>';
}
}
$i = $i + 5;
}
if ($asd2 < $count_users) {
echo ' ... <a href="index.php?action=view&fid='.$fid.'&p='.$ba.'&'.$ses.'&ref='.$ref.'">'.$ba.'</a>';
}
}
echo '<br/><br/>';
}
if ($action == "add") {
$fid = intval($_GET['fid']);
if (!is_numeric($fid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
/*if (empty($_GET['fid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}*/
$typ = mysql_query("select * from `journal` where id='" . $fid . "';");
$ms = mysql_fetch_array($typ);
/*if ($ms[type] != "r" && $ms[type] != "f")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
*/
$filex = file("journalist.dat");
$countx = count($filex);
$switchx = 0;
$wordx = "$idsd";
for ($ix=0; $ix < $countx; $ix++) {
if (trim($filex[$ix]) == $wordx) { $switchx=1; } }
$filexd = file("editors.dat");
$countxd = count($filexd);
$switchxd = 0;
$wordxd = "$idsd";
for ($ixd = 0; $ixd < $countxd; $ixd++) {
if (trim($filexd[$ixd]) == $wordxd) { $switchxd=1; } }
if ($switchx == 1 or $switchxd == 1)
{
if ($ver != "wml") {
echo'<form action="index.php?action=addn&'.$ses.'&ref='.$ref.'&fid='.$fid.'" method="post">
<b>Название:</b> <br/><input type="text" name="name"/><br/>
<b>Небольшое превью к статье: **</b><br/>
<textarea cols="35" rows="3" name="msg"></textarea><br/>
<b>Полный текст статьи:</b><br/>
<textarea cols="35" rows="5" name="article"></textarea><br/>
<b>Разрешать голосование?</b><br/><b>Да</b> <input name="trans" type="checkbox" value="y" /><br/>
<b>Разрешать комментарии?</b><br/><b>Да</b> <input name="trans2" type="checkbox" value="y" /><br/>
<br/><input type="submit" class="ibutton" value="Старт!" /></form>';
} else {
echo 'Название:<br/><input name="name"/><br/>
Небольшое превью к статье: *<br/><input name="msg"/><br/>
Полный текст статьи:<br/><input name="article"/><br/>
Разрешать голосование?<select name="trans"><option value="0">Нет</option><option value="y">Да</option></select><br/>
Разрешать комментарии?<select name="trans2"><option value="0">Нет</option><option value="y">Да</option></select><br/>
<anchor>Создать!
<go href="index.php?action=addn&'.$ses.'&ref='.$ref.'&fid='.$fid.'" method="post">
<postfield name="msg" value="$(msg)"/>
<postfield name="name" value="$(name)"/>
<postfield name="article" value="$(article)"/>
<postfield name="trans" value="$(trans)"/>
<postfield name="trans2" value="$(trans2)"/>
</go></anchor><br/>--------------------<br/>';
}
echo '** Данный пункт можно пропускать<br/><br/>';
}
else { echo 'Ты не журналист журнала<br/><br/>';
}
}
if ($action == "addn") {
$fid = intval($_GET['fid']);
if (!is_numeric($fid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
/*if (empty($_GET['fid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}*/
$typ = mysql_query("select * from `journal` where id='" . $fid . "';");
$ms = mysql_fetch_array($typ);
/*if ($ms[type] != "r" && $ms[type] != "f")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
*/
$filex = file("journalist.dat");
$countx = count($filex);
$switchx = 0;
$wordx = "$idsd";
for ($ix = 0; $ix < $countx; $ix++) {
if (trim($filex[$ix]) == $wordx) { $switchx=1; } }
$filexd = file("editors.dat");
$countxd = count($filexd);
$switchxd = 0;
$wordxd = "$idsd";
for ($ixd = 0; $ixd < $countxd; $ixd++) {
if (trim($filexd[$ixd]) == $wordxd) { $switchxd=1; } }
if ($switchx == 1 or $switchxd == 1)
{
$dates = date("d.m.y");
$times = date("H:i");
$time = time();
$fid = $_GET['fid'];
$msg = mysql_real_escape_string(check(trim($msg)));
$name = mysql_real_escape_string(check(trim($name)));
$article = mysql_real_escape_string(trim(htmlspecialchars($article)));
$nick = mysql_real_escape_string(check(trim($nick)));
$trans = check($trans);
$trans2 = check($trans2);
if (empty($article)) {
echo 'Введи текст статьи!!!
<br/><br/><a href="index.php?'.$ses.'&ref='.$ref.'">Назад</a><br/>
<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($name)) {
echo 'Введи название статьи!!!
<br/><br/><a href="index.php?'.$ses.'&ref='.$ref.'">Назад</a><br/>
<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if ($trans == "y") { $votes = 1; }
if ($trans != "y") { $votes = 0; }
if ($trans2 == "y") { $comments = 1; }
if ($trans2 != "y") { $comments = 0; }
$r = mysql_query ("select id,user from users where id='$id';");
$arr = mysql_fetch_array($r);
$login = $arr['user'];
$usid = $arr['id'];
$q = mysql_query("select * from `journal` where type='a' order by realid desc ;");
$q1 = mysql_num_rows($q);
if ($q1 == 0)
{
$rid = 1;
} else
{
while ($arr = mysql_fetch_assoc($q))
{
$arr1[] = $arr[realid];
}
$rid = $arr1[0] + 1;
}
$rand = mt_rand(100000000,999999999);
$retime = time();
mysql_query("insert into `journal` values(0,'".$fid."','".$name."','" . $msg . "','".$usid."','a','".$article."','".$comments."','','0','0','".$votes."','".$rand."','".$rid."','".$retime ."','0','".$dates."');");
echo 'Статья успешно добавлена в категорию!<br/><br/>';
if ($votes == 1) { echo 'За данную статью можно голосовать пользователям и '; }
if ($votes == 0) { echo 'За данную статью нельзя голосовать пользователям и '; }
if ($comments == 1) { echo 'можно комментаровать!<br/><br/>'; }
if ($comments == 0) { echo 'нельзя комментаровать!<br/><br/>'; }
}
else { echo 'Ты не журналист!<br/><br/>'; }
}
if ($action == "read") {
$rid = intval($_GET['rid']);
if (!is_numeric($rid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo '<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($_GET['rid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $rid . "';");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "a")
{
echo 'Ошибка! Статьи не существует!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$tp = mysql_query("select * from `journal` where id = '" . $rid . "';");
$tp1 = mysql_fetch_array($tp);
$simvol = 2000;
$libcount = intval($tp1[count]) + 1;
mysql_query("update `journal` set `count`='" . $libcount . "' where id='" . $rid . "';");
echo "<b>".$ms['name']."</b><br/><br/>" . $ms['text'];
echo '<br/><br/>';
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='k' AND `refid`='".$rid."';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
$tit = round($ms['vote']/$ms['vote_col']/2,1);
echo '<br/>Оценка: '.$tit.'<br/>
Всего оценок: <b>'.$ms[vote_col].'</b><br/>
Всего прочтений: <b>'.$ms[count].'</b><br/>';
if ($ms['comm'] == 1) {
echo '<a href="index.php?action=komm&rid='.$rid.'&'.$ses.'&ref='.$ref.'">Комментарии</a> (<b>'.$count_users.'</b>)<br/>';}
if ($ms['down_type'] == 1) {
echo '<br/>Оценить ';
if ($ver != "wml") {
echo '<form action="index.php?action=vote&rid='.$rid.'&'.$ses.'&ref='.$ref.'" method="post" name="vote">
<select name="ocenka">
<option value="10">Отлично</option>
<option value="8">Хорошо</option>
<option value="6">Нормально</option>
<option value="4">Плохо</option>
<option value="2">Отстой</option>
</select>
<input type="submit" class="ibutton" value="Oценить" /></form><br/>';
} else {
echo '<br/><select name="ocenka">
<option value="10">Отлично</option>
<option value="8">Хорошо</option>
<option value="6">Нормально</option>
<option value="4">Плохо</option>
<option value="2">Отстой</option>
</select><br/>
<anchor>Oценить<go href="index.php?action=vote&rid='.$rid.'&'.$ses.'&ref='.$ref.'" method="post">
<postfield name="ocenka" value="$(ocenka)"/>
</go></anchor>';
}
}
$filex = file("editors.dat");
$countx = count($filex);
$switchx = 0;
$wordx = "$idsd";
for ($ix = 0; $ix < $countx; $ix++) {
if (trim($filex[$ix]) == $wordx) { $switchx = 1; } }
if ($switchx == 1)
{
echo '[ <a href="index.php?action=viewvote&rid='.$rid.'&'.$ses.'&ref='.$ref.'">Кто голосовал?</a> ]<br/>';
echo '[ <a href="index.php?action=edit_page&rid='.$rid.'&'.$ses.'&ref='.$ref.'">Изменить</a> |
<a href="index.php?action=del_page&rid='.$rid.'&'.$ses.'&ref='.$ref.'">Удалить</a> ]<br/><br/>';
}
}
if ($action == "vote") {
$rid = intval($_GET['rid']);
if (!is_numeric($rid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($_GET['rid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $rid . "';");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "a")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $rid . "';");
$ms = mysql_fetch_array($typ);
echo '<div class="c4">Оценка статьи</div><br/>';
if ($ms['count'] != 0) {
if ($ocenka != "" and ctype_digit($ocenka)) {
$filex = file("../journal_vote/$rid.dat");
$countx = count($filex);
$switchx = 0;
$wordx = "$idsd";
for ($ix = 0; $ix < $countx; $ix++) {
if (trim($filex[$ix]) == $wordx) { $switchx=1; } }
if ($switchx == 1)
{
echo 'Ты уже голосовал(а) за эту статью!<br/><br/>';
} else {
$fp=fopen("../journal_vote/".$rid.".dat","a+");
flock ($fp,LOCK_EX);
fputs($fp,"$idsdrn");
flock ($fp,LOCK_UN);
fclose($fp);
$new_vote = $ms[vote_col] + 1;
$golos = round($ms[vote] + $ocenka);
$new_vote = intval($new_vote);
$golos = intval($golos);
mysql_query("update `journal` set `vote_col`='" . $new_vote . "', `vote`='" . $golos . "' where id='" . $rid . "';");
$ocenka2 = round($ocenka/2);
echo '<br/>Спасибо твоя оценка: <b>"'.$ocenka2.'"</b> принята<br/><br/>';
$typ = mysql_query("select * from `journal` where id='" . $rid . "';");
$ms = mysql_fetch_array($typ);
$tit = round($ms[vote]/2/$ms[vote_col],1);
echo 'Всего оценивало: '.$ms[vote_col].'<br/>
Средняя оценка: '.$tit.'<br/>
<a href="index.php?action=read&rid='.$rid.'&'.$ses.'&ref='.$ref.'">К статье</a><br/>';
}
} else { echo '<br/>Ошибка, ты не указал(а) оценку<br/>';
}
} else { echo '<br/>Ты не можешь оценивать т.к. никто еще не читал статью<br/>';
}
}
if ($action == "komm") {
if (empty($_GET['p'])) $page = 1;
else $page = intval($_GET['p']);
$rid = intval($_GET['rid']);
if (!is_numeric($rid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo '<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($_GET['rid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $rid . "';");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "a")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
echo '<a href="index.php?action=komm&rid='.$rid.'&'.$ses.'&ref='.$ref.'">Обновить</a>';
echo '<br/>';
if ($ver != "wml") {
echo '<form action="index.php?action=kommgo&'.$ses.'&ref='.$ref.'&rid='.$rid.'" method="post"><br/>
<b>Твой текст:</b><br/>
<textarea cols="25" rows="3" name="msg"></textarea><br/>
<br/><input type="submit" class="ibutton" value="ОК!" /></form>';}else{
echo 'Твой текст:<br/>
<input name="msg"/><br/>
<anchor>ОК!<go href="index.php?action=kommgo&'.$ses.'&ref='.$ref.'&rid='.$rid.'" method="post">
<postfield name="msg" value="$(msg)"/>
</go></anchor><br/>--------------------<br/>';
}
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='k' AND `refid`='".$rid."';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
$max_page = ceil ($count_users / 5);
$page = ($page > $max_page) ? (($max_page == 0)? $page : $max_page) : $page;
$start = 5*($page-1);
$end = 5;
$resultx = mysql_query("SELECT `id`,`name`,`text`,`type`,`down_type`,`realid`,`refid`,`nick`,`vote`,`vote_col`,`date` FROM `journal` WHERE `type`='k' AND `refid`='".$rid."' ORDER BY date DESC LIMIT $start,$end;");
$count_users_on_pagex = mysql_num_rows($resultx);
for($i = 0; $i < $count_users_on_pagex; $i++)
{
$row = mysql_fetch_array($resultx);
$xid = $row[0];
$name = $row[1];
$text = $row[2];
$type = $row[3];
$downtype = $row[4];
$realid = $row[5];
$refid = $row[6];
$nick = $row[7];
$vote = $row[8];
$vote_col = $row[9];
$dats = $row[10];
$dats = date("d.m.y / H:i",$dats);
$rs = mysql_query("SELECT `user` FROM `users` WHERE `id`='".mysql_real_escape_string($nick)."';");
$rowx = mysql_fetch_array($rs);
$uz = $rowx[0];
echo '<a href="../info.php?'.$ses.'&nk='.$nick.'&ref='.$ref.'">'.$uz.'</a> ('.$dats.')<br/><small>'.$text.'</small><br/><br/>';
}
echo '<br/>';
if ($i == 0)
{
echo '<br/><center><b>Комментов пока нет!</b></center><br/>';
}
if ($max_page > 1)
{
$ba=ceil($count_users/5);
$ba2=$ba*5-5;
echo 'Страницы:';
$asd = $start-(5*4);
$asd2 = $start+(5*5);
if ($asd < $count_users and $asd > 0) {
echo ' <a href="index.php?action=komm&rid='.$rid.'&p=1&'.$ses.'&ref='.$ref.'">1</a> ... ';
}
for($i = $asd; $i < $asd2;)
{
if ($i < $count_users and $i >= 0) {
$ii=floor(1+$i/5);
if ($start == $i) {
echo ' <b>('.$ii.')</b>';
}
else {
echo ' <a href="index.php?action=komm&rid='.$rid.'&p='.$ii.'&'.$ses.'&ref='.$ref.'">'.$ii.'</a>';
} }
$i = $i + 5;
}
if ($asd2 < $count_users) {
echo ' ... <a href="index.php?action=komm&rid='.$rid.'&p='.$ba.'&'.$ses.'&ref='.$ref.'">'.$ba.'</a>';
}
}
echo '<br/><br/>';
echo '<a href="index.php?action=read&rid='.$rid.'&'.$ses.'&ref='.$ref.'">К статье</a><br/>';
}
if ($action == "kommgo") {
$time = time();
$msg = $_POST['msg'];
$rid = $_GET['rid'];
$msg = mysql_real_escape_string(check($msg));
$rid = intval($rid);
$idsd = intval($idsd);
if (empty($msg)) {
echo 'Нечего добавлять!<br/>';
echo '<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$r = mysql_query ("select id,user from users where id='$id';");
$arr = mysql_fetch_array($r);
$login = $arr['user'];
$usid = $arr['id'];
mysql_query("insert into `journal` values(0,'".$rid."','','','" . $idsd . "','k','" . $msg . "','','','','','".$type."','','','" . $time . "','','');");
echo 'Комментарий принят!<br/><br/>';
}
if ($action == "edit_page") {
$filex = file("editors.dat");
$countx = count($filex);
$switchx = 0;
$wordx = "$idsd";
for ($ix=0; $ix < $countx; $ix++) {
if (trim($filex[$ix]) == $wordx) { $switchx=1; } }
if ($switchx == 1)
{
$uid = intval($_GET['rid']);
if (!is_numeric($rid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo '<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($_GET['rid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $rid . "';");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "a")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
echo "Изменить название:<br/><form action='index.php?action=edit_page_go&rid=".$rid."&".$ses."&ref=".$ref."' method='post'><input type='text' name='nf' value='" . $ms['name'] . "'/><br/>Изменить превью:<br/><textarea cols='35' rows='15' name='ab'>" . $ms['about'] . "</textarea><br/>Изменить текст:<br/><textarea cols='35' rows='15' name='text'>" . $ms['text'] . "</textarea><br/><br/>Разрешить комменты **:<br/><input type='text' name='comm' value='" . $ms['comm'] . "'/><br/>Разрешить голосование **:<br/><input type='text' name='vote' value='" . $ms['down_type'] . "'/><br/>** - Разрешить (Единица), запретить (Ноль)<br/><input type='submit' name='submit' class='ibutton' value='Ok!'/><br/></form>";
} else { echo 'Ты не админ журнала!<br/><br/>';
}
}
if ($action == "edit_page_go") {
if (eregi("[^0-1]", $comm))
{
echo '0 или 1 в разрешениях комментов!<br/>';
echo '<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (eregi("[^0-1]", $vote))
{
echo '0 или 1 в разрешениях комментов!<br/>';
echo '<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$filex = file("editors.dat");
$countx = count($filex);
$switchx = 0;
$wordx = "$idsd";
for ($ix = 0; $ix < $countx; $ix++) {
if (trim($filex[$ix]) == $wordx) { $switchx = 1; } }
if ($switchx == 1)
{
$nf = mysql_real_escape_string(check(trim($_POST['nf'])));
$ab = mysql_real_escape_string(check(trim($_POST['ab'])));
$text = mysql_real_escape_string(check(trim($_POST['text'])));
$comm = intval($_POST['comm']);
$vote = intval($_POST['vote']);
$rid = intval($_GET['rid']);
if (!is_numeric($rid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo '<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($_GET['rid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $rid . "';");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "a")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
mysql_query("update `journal` set name='" . $nf . "', about='" . $ab . "', text='" . $text . "', comm='" . $comm . "', down_type='" . $vote . "' where id='" . $rid . "';");
echo 'Статья изменена!<br/><br/>';
}
else { echo 'Ты не админ журнала!<br/><br/>'; }
}
//---------------------------------------- УДАЛЕНИЕ СООБЩЕНИЯ -------------------------------------------//
if ($action == "del_page") {
$filex = file("editors.dat");
$countx = count($filex);
$switchx = 0;
$wordx = "$idsd";
for ($ix = 0; $ix < $countx; $ix++) {
if (trim($filex[$ix]) == $wordx) { $switchx=1; } }
if ($switchx == 1)
{
$rid = intval($_GET['rid']);
if (!is_numeric($rid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($_GET['rid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $rid . "';");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "a")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$raz = mysql_query("select * from `journal` where refid='" . $rid . "' and type='a' ;");
while ($raz1 = mysql_fetch_assoc($raz))
{
$tem = mysql_query("select * from `journal` where refid='".intval($raz1['id'])."' and type='k';");
while ($tem1 = mysql_fetch_assoc($tem))
{
mysql_query("delete from `journal` where `id`='".intval($tem1['id'])."';");
}
mysql_query("delete from `journal` where `id`='".intval($raz1['id'])."';");
}
mysql_query("delete from `journal` where `id`='" . $rid . "';");
echo 'Готово!<br/><br/>';
} else { echo 'Ты не админ журнала!<br/><br/>';
}
}
if ($action == "viewvote") {
$filex = file("editors.dat");
$countx = count($filex);
$switchx = 0;
$wordx = "$idsd";
for ($ix = 0; $ix < $countx; $ix++) {
if (trim($filex[$ix]) == $wordx) { $switchx=1; } }
if ($switchx == 1)
{
$rid = intval($_GET['rid']);
if (!is_numeric($rid))
{
echo 'Попытка взлома! Я тебя запомнил <font color="#FF0000">'.$_SERVER['REMOTE_ADDR'].'</font><br/>';
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
if (empty($_GET['rid'])) {
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
$typ = mysql_query("select * from `journal` where id='" . $rid . "';");
$ms = mysql_fetch_array($typ);
if ($ms['type'] != "a")
{
echo 'Ошибка!<br/>';
include_once '../foot.php';
ob_end_flush();
exit;
}
echo '<b>Кто голосовал:</b><br/>';
$file = file("../journal_vote/".$rid.".dat");
$total = count($file);
if (empty($_GET['start'])) $start = 0;
else $start = intval($_GET['start']);
if ($total < $start + $config_bookpost) { $end = $total; }
else {
$end = $start + $config_bookpost;
}
for ($fm = $start; $fm < $end; $fm++) {
$file = file("../journal_vote/".$rid.".dat");
$file = array_reverse($file);
$dt = explode("|",$file[$fm]);
$num = $total - $fm-1;
if ($fm >= 0) {
$rx = mysql_query("select user from users where id ='".$dt[0]."';");
$arrx = mysql_fetch_array($rx);
$userx = $arrx[0];
echo "<a href="../info.php?$ses&nk=$idx&ref=$ref"><b>".$userx."</b></a>";
echo '<br/>';
}
}
if ($total < 1) { echo '<br/><b>Голосов еще нет!</b><br/>'; }
echo $divide;
if ($start != 0) {
echo '<a href="index.php?action=viewvote&rid='.$rid.'&start='.($start - $config_bookpost).'&'.$ses.'&ref='.$ref.'"><-Назад </a> ';
} else {
echo '<-Назад ';
}
echo '|';
if ($total > $start + $config_bookpost) {
echo ' <a href="index.php?action=viewvote&rid='.$rid.'&start='.($start + $config_bookpost).'&'.$ses.'&ref='.$ref.'">Далее-></a>';
} else {
echo' Далее->';
}
$ba=ceil($total/$config_bookpost);
$ba2=$ba*$config_bookpost-$config_bookpost;
echo '<br/>Страницы:';
$asd2=$start+($config_bookpost*4);
if ($asd < $total and $asd > 0) {
echo ' <a href="index.php?action=viewvote&rid='.$rid.'&start=0&'.$ses.'&ref='.$ref.'">1</a> ... ';
}
for($i=$asd; $i < $asd2;)
{
if ($i < $total and $i >= 0) {
$ii=floor(1+$i/$config_bookpost);
if ($start == $i) {
echo ' <b>('.$ii.')</b>';
} else {
echo ' <a href="index.php?action=viewvote&rid='.$rid.'&start='.$i.'&'.$ses.'&ref='.$ref.'">'.$ii.'</a>';
}
}
$i=$i+$config_bookpost;
}
if ($asd2 < $total) {
echo ' ... <a href="index.php?action=viewvote&rid='.$rid.'&start='.$ba2.'&'.$ses.'&ref='.$ref.'">'.$ba.'</a>';
}
echo '<br/><br/>Всего голосов : <b>'.(int)$total.'</b><br/><a href="index.php?action=read&rid='.$rid.'&'.$ses.'&ref='.$ref.'">К статье</a><br/>';
} else { echo 'Ты не админ журнала!<br/><br/>'; }
}
if ($action == "top") {
if (empty($_GET['p'])) $page = 1;
else $page = intval($_GET['p']);
echo 'Топ-рейтинг статей<br/>Условие: прочтения | <a href="index.php?action=top_vote&'.$ses.'&ref='.$ref.'">оценка</a> <br/><br/><a href="index.php?action=top&'.$ses.'&ref='.$ref.'">Обновить список</a>';
echo '<br/><br/>';
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='a' AND `count`!='';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
$max_page = ceil ($count_users / 5);
$page = ($page > $max_page) ? (($max_page == 0)? $page : $max_page) : $page;
$start = 5*($page-1);
$end = 5;
$resultx = mysql_query("SELECT `id`,`name`,`about`,`refid`,`nick`,`date`,`new_date`,`count` FROM `journal` WHERE `type`='a' AND `count`!='' ORDER BY count DESC LIMIT $start,$end;");
$count_users_on_pagex = mysql_num_rows($resultx);
for($i = 0; $i < $count_users_on_pagex; $i++)
{
$row = mysql_fetch_array($resultx);
$rid = $row[0];
$name = $row[1];
$about = $row[2];
$refid = $row[3];
$nick = $row[4];
$dats = $row[5];
$ndats = $row[6];
$ct = $row[7];
$dats = date("d.m.y / H:i",$dats);
$rs = mysql_query("SELECT `user` FROM `users` WHERE `id`='".mysql_real_escape_string($nick)."';");
$rowx = mysql_fetch_array($rs);
$uz = $rowx[0];
$rsd = mysql_query("SELECT `id`,`name` FROM `journal` WHERE `id`='".intval($refid)."';");
$rowxd = mysql_fetch_array($rsd);
$catsid = $rowxd[0];
$catsnm = $rowxd[1];
$currdate = date("d.m.y");
$hoursx = date("H:i",$dats);
if ($ndats == $currdate) { $cxx = "Сегодня"; $sxx = "/ $hoursx"; }
if ($ndats != $currdate) { $cxx = $dats; $sxx = ""; }
echo '<a href="index.php?action=read&rid='.$rid.'&'.$ses.'&ref='.$ref.'">'.$name.'</a><br/><small>'.$about.'</small><br/>Прочтений: '.$ct.'<br/>Категория: <a href="index.php?action=view&uid='.$catsid.'&'.$ses.'&ref='.$ref.'">'.$catsnm.'</a><br/>Добавил: <a href="../info.php?'.$ses.'&nk='.$nick.'&ref='.$ref.'">'.$uz.'</a><br/>Дата: '.$cxx.' '.$sxx.'<br/>';
}
echo '<br/>';
if ($i == 0)
{
echo '<br/><center><b>Статей прочитанных пока нет!</b></center><br/>';
}
if ($max_page > 1)
{
$ba = ceil($count_users/5);
$ba2 = $ba*5-5;
echo 'Страницы:';
$asd = $start-(5*4);
$asd2 = $start+(5*5);
if ($asd < $count_users and $asd > 0) {
echo ' <a href="index.php?action=top&p=1&'.$ses.'&ref='.$ref.'">1</a> ... ';
}
for($i = $asd; $i < $asd2;)
{
if ($i < $count_users and $i >= 0) {
$ii = floor(1+$i/5);
if ($start == $i) {
echo ' <b>('.$ii.')</b>';
}
else
{
echo ' <a href="index.php?action=top&p='.$ii.'&'.$ses.'&ref='.$ref.'">'.$ii.'</a>';
}
}
$i = $i + 5;
}
if ($asd2 < $count_users) {
echo ' ... <a href="index.php?action=top&p='.$ba.'&'.$ses.'&ref='.$ref.'">'.$ba.'</a>';
}
}
echo '<br/>';
}
if ($action == "top_vote") {
if (empty($_GET['p'])) $page = 1;
else $page = intval($_GET['p']);
echo 'Топ-рейтинг статей<br/>Условие: <a href="index.php?action=top&'.$ses.'&ref='.$ref.'">прочтения</a> | оценка<br/><br/><a href="index.php?action=top&'.$ses.'&ref='.$ref.'">Обновить список</a>';
echo'<br/><br/>';
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='a' AND `vote_col`!='';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
$max_page = ceil ($count_users / 5);
$page = ($page > $max_page) ? (($max_page == 0) ? $page : $max_page) : $page;
$start = 5*($page-1);
$end = 5;
$resultx = mysql_query("SELECT `id`,`name`,`about`,`refid`,`nick`,`date`,`new_date`,`vote`,`vote_col` FROM `journal` WHERE `type`='a' AND `vote_col`!='' ORDER BY vote_col DESC LIMIT $start,$end;");
$count_users_on_pagex = mysql_num_rows($resultx);
for($i = 0; $i < $count_users_on_pagex; $i++)
{
$row = mysql_fetch_array($resultx);
$rid = $row[0];
$name = $row[1];
$about = $row[2];
$refid = $row[3];
$nick = $row[4];
$dats = $row[5];
$ndats = $row[6];
$ct = $row[7];
$ct_col = $row[8];
$dats = date("d.m.y / H:i",$dats);
$rs = mysql_query("SELECT `user` FROM `users` WHERE `id`='".mysql_real_escape_string($nick)."';");
$rowx = mysql_fetch_array($rs);
$uz = $rowx[0];
$rsd = mysql_query("SELECT `id`,`name` FROM `journal` WHERE `id`='".intval($refid)."';");
$rowxd = mysql_fetch_array($rsd);
$catsid = $rowxd[0];
$catsnm = $rowxd[1];
$currdate = date("d.m.y");
$hoursx = date("H:i",$dats);
if ($ndats == $currdate) { $cxx = "Сегодня"; $sxx = "/ $hoursx"; }
if ($ndats != $currdate) { $cxx = $dats; $sxx = ""; }
$tit=round($ct/$ct_col/2,1);
echo '<a href="index.php?action=read&rid='.$rid.'&'.$ses.'&ref='.$ref.'">'.$name.'</a><br/><small>'.$about.'</small><br/>Кол-во оценок: '.$ct_col.'<br/>Категория: <a href="index.php?action=view&uid='.$catsid.'&'.$ses.'&ref='.$ref.'">'.$catsnm.'</a><br/>Добавил: <a href="../info.php?'.$ses.'&nk='.$nick.'&ref='.$ref.'">'.$uz.'</a><br/>Дата: '.$cxx.' '.$sxx.'<br/><br/>';
}
echo '<br/>';
if ($i == 0)
{
echo '<br/><center><b>Статей оцениных пока нет!</b></center><br/>';
}
if ($max_page > 1)
{
$ba=ceil($count_users/5);
$ba2=$ba*5-5;
echo 'Страницы:';
$asd = $start-(5*4);
$asd2 = $start+(5*5);
if ($asd < $count_users and $asd > 0) {
echo ' <a href="index.php?action=top_vote&p=1&'.$ses.'&ref='.$ref.'">1</a> ... ';
}
for($i=$asd; $i < $asd2;)
{
if ($i < $count_users and $i >= 0) {
$ii=floor(1+$i/5);
if ($start == $i) {
echo ' <b>('.$ii.')</b>';
}
else
{
echo ' <a href="index.php?action=top_vote&p='.$ii.'&'.$ses.'&ref='.$ref.'">'.$ii.'</a>';
}
}
$i=$i+5;
}
if ($asd2 < $count_users) {
echo ' ... <a href="index.php?action=top_vote&p='.$ba.'&'.$ses.'&ref='.$ref.'">'.$ba.'</a>';
}
}
echo '<br/>';
}
if ($action == "new") {
if (empty($_GET['p'])) $page = 1;
else $page = intval($_GET['p']);
echo'Новые статьи<br/>Условие: За сегодня<br/><a href="index.php?action=new&'.$ses.'&ref='.$ref.'">Обновить список</a>';
echo'<br/><br/>';
$curr = date("d.m.y");
$result = mysql_query("SELECT count(`id`) FROM `journal` WHERE `type`='a' AND `new_date`='".$curr."';");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
$max_page = ceil ($count_users / 5);
$page = ($page > $max_page) ? (($max_page == 0) ? $page : $max_page) : $page;
$start = 5*($page-1);
$end = 5;
$resultx = mysql_query("SELECT `id`,`name`,`about`,`refid`,`nick`,`date`,`new_date`,`vote`,`vote_col` FROM `journal` WHERE `type`='a' AND `new_date`='".$curr."' ORDER BY count DESC LIMIT $start,$end;");
$count_users_on_pagex = mysql_num_rows($resultx);
for($i = 0; $i < $count_users_on_pagex; $i++)
{
$row = mysql_fetch_array($resultx);
$rid = $row[0];
$name = $row[1];
$about = $row[2];
$refid = $row[3];
$nick = $row[4];
$dats = $row[5];
$ndats = $row[6];
$ct = $row[7];
$ct_col = $row[8];
$dats = date("d.m.y / H:i",$dats);
$rs = mysql_query("SELECT `user` FROM `users` WHERE `id`='".mysql_real_escape_string($nick)."';");
$rowx = mysql_fetch_array($rs);
$uz = $rowx[0];
$rsd = mysql_query("SELECT `id`,`name` FROM `journal` WHERE `id`='".intval($refid)."';");
$rowxd = mysql_fetch_array($rsd);
$catsid = $rowxd[0];
$catsnm = $rowxd[1];
$currdate = date("d.m.y");
$hoursx = date("H:i",$dats);
if ($ndats == $currdate) { $cxx = "Сегодня"; $sxx = "/ $hoursx"; }
if ($ndats != $currdate) { $cxx = $dats; $sxx = ""; }
$tit=round($ct/$ct_col/2,1);
echo '<a href="index.php?action=read&rid='.$rid.'&'.$ses.'&ref='.$ref.'">'.$name.'</a><br/><small>'.$about.'</small><br/>Прочтений: '.$ct.'<br/>Рейтинг: '.$tit.' / '.$ct_col.'<br/>Категория: <a href="index.php?action=view&uid='.$catsid.'&'.$ses.'&ref='.$ref.'">'.$catsnm.'</a><br/>Добавил: <a href="../info.php?'.$ses.'&nk='.$nick.'&ref='.$ref.'">'.$uz.'</a><br/><br/>';
}
echo '<br/>';
if ($i == 0)
{
echo '<center><b>Сегодня новых статей нет!</b></center>';
}
if ($max_page > 1)
{
$ba=ceil($count_users/5);
$ba2=$ba*5-5;
echo 'Страницы:';
$asd = $start-(5*4);
$asd2 = $start+(5*5);
if ($asd < $count_users and $asd > 0) {
echo ' <a href="index.php?action=new&p=1&'.$ses.'&ref='.$ref.'">1</a> ... ';
}
for($i=$asd; $i < $asd2;)
{
if ($i < $count_users and $i >= 0) {
$ii=floor(1+$i/5);
if ($start == $i) {
echo ' <b>('.$ii.')</b>';
}
else
{
echo ' <a href="index.php?action=new&p='.$ii.'&'.$ses.'&ref='.$ref.'">'.$ii.'</a>';
}
}
$i = $i + 5;
}
if ($asd2 < $count_users) {
echo ' ... <a href="index.php?action=new&p='.$ba.'&'.$ses.'&ref='.$ref.'">'.$ba.'</a>';
}
}
echo '<br/>';
}
echo '<div class = "d1"><a href="index.php?'.$ses.'&ref='.$ref.'">Главная журнала</a></div>';
$r = mysql_query ("select id,user,level from users where id='$idsd';");
$arr = mysql_fetch_array($r);
$lev = $arr['level'];
if ($lev > 7) {
echo '<div class = "d1"><a href="admin.php?action=readlist&'.$ses.'&ref='.$ref.'">Список редакторов</a></div>
<div class = "d1"><a href="admin.php?action=readlist2&'.$ses.'&ref='.$ref.'">Список журналистов</a></div>';
}
echo '<div class = "d1"><a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a></div>';
include_once '../foot.php';
ob_end_flush();
exit;
?>