<?php
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
/*Что сделанно
Добавил постраничную навигацию в подкаталоги и вывод видео файлов
*/
$user_id = $user['id'];
$id = isset($_REQUEST['id']) ? abs(intval($_REQUEST['id'])) : false;
$act = isset($_GET['act']) ? trim($_GET['act']) : '';
$realtime = time();
if (!empty($id))
{
$req = mysql_query("SELECT * FROM `vid` WHERE `id` = '$id' LIMIT 1");
if (mysql_num_rows($req))
{
$video = mysql_fetch_assoc($req);
switch ($act)
{
case 'ves':
$req = mysql_query("SELECT * FROM `viduser` WHERE `idvid` = '$id' AND iduser='$user_id' LIMIT 1");
if (mysql_num_rows($req))
{
$set['title'] = 'Понравилось';
include_once '../sys/inc/thead.php';
title();
$req = mysql_query("SELECT * FROM `viduser` WHERE `idvid` = '$id' AND do='2' ORDER BY `data` DESC ");
while ($res = mysql_fetch_assoc($req))
{
$reqw = mysql_query("SELECT * FROM `user` WHERE `id` = '" . $res['iduser'] .
"'");
$users = mysql_fetch_assoc($reqw);
echo ($i % 2) ? '<div class="list2">' : '<div class="list1">';
echo '<a href="../info.php?id=' . $users['id'] . '">' . $users['nick'] .
'</a> Пишет.';
echo '<br />' . $res['komm'] . '<br />';
echo '</div>';
++$i;
}
echo ' [<a href="online.php?id=' . $id . '">К видео</a>]';
include_once '../sys/inc/tfoot.php';
exit;
} else
{
if (!$user_id)
{
include_once '../sys/inc/thead.php';
title();
echo 'Только для зарегистрированных';
include_once '../sys/inc/tfoot.php';
exit;
}
if (isset($_POST['submit']))
{
$text = $_POST['text'];
$ref = isset($_GET['id']) ? abs(intval($_GET['id'])) : 0;
if (empty($text))
{
include_once '../sys/inc/thead.php';
title();
echo 'Введите комментарий!';
include_once '../sys/inc/tfoot.php';
exit;
}
$count = intval($video['plus']) + 1;
mysql_query("INSERT INTO `viduser` (idvid, iduser, do, komm) VALUES ('$id', '$user_id', '2', '$text')");
// mysql_query("UPDATE `vid` SET plus='$count' WHERE id='$id'");
header("location: online.php?id=$id");
}
include_once '../sys/inc/thead.php';
title();
echo "<form action='online.php?act=ves&id=" . $id .
"' method='post'>Нравится? Почему:<br/>
<input type='text' name='text'/><br/>
<input type='submit' name='submit' value='Ok!'/></form>";
echo ' [<a href="online.php?id=' . $id . '">К видео</a>]';
include_once '../sys/inc/tfoot.php';
exit;
}
break;
case 'no':
$req = mysql_query("SELECT * FROM `viduser` WHERE `idvid` = '$id' AND iduser='$user_id' LIMIT 1");
if (mysql_num_rows($req))
{
$set['title'] = 'Не понравилось!';
include_once '../sys/inc/thead.php';
title();
$req = mysql_query("SELECT * FROM `viduser` WHERE `idvid` = '$id' AND do='1' ORDER BY `data` DESC ");
while ($res = mysql_fetch_assoc($req))
{
$reqw = mysql_query("SELECT * FROM `user` WHERE `id` = '" . $res['iduser'] . "'");
$users = mysql_fetch_assoc($reqw);
echo ($i % 2) ? '<div class="list2">' : '<div class="list1">';
echo '<a href="../info.php?id=' . $users['id'] . '">' . $users['nick'] .
'</a> Пишет.';
echo '<br />' . $res['komm'] . '<br />';
echo '</div>';
++$i;
}
echo ' [<a href="online.php?id=' . $id . '">К видео</a>]';
} else
{
if (!$user_id)
{
include_once '../sys/inc/thead.php';
title();
echo 'Только для зарегистрированных';
include_once '../sys/inc/tfoot.php';
exit;
}
if (isset($_POST['submit']))
{
$text = $_POST['text'];
$ref = isset($_GET['id']) ? abs(intval($_GET['id'])) : 0;
if (empty($text))
{
include_once '../sys/inc/thead.php';
title();
echo 'Введите комментарий!';
include_once '../sys/inc/tfoot.php';
exit;
}
$count = intval($video['minus']) + 1;
mysql_query("INSERT INTO `viduser` (idvid, iduser, do, komm) VALUES ('$id', '$user_id', '1', '$text')");
// mysql_query("UPDATE `vid` SET minus='$count' WHERE id='$id'");
header("location: online.php?id=$id");
}
include_once '../sys/inc/thead.php';
title();
echo "<form action='online.php?act=no&id=" . $id .
"' method='post'>Плохое видео? Почему:<br/>
<input type='text' name='text'/><br/>
<input type='submit' name='submit' value='Ok!'/></form>";
echo ' [<a href="online.php?id=' . $id . '">К видео</a>]';
include_once '../sys/inc/tfoot.php';
exit;
}
break;
default:
if($_SESSION['online'] != $id)
{
$_SESSION['online'] = $id;
$count = intval($video['count']) + 1;
mysql_query("UPDATE `vid` SET `count` = '" . $count . "' WHERE `id` = '" . $id .
"'");
}
$textl = $video['name'];
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `komvid` WHERE `refid`='$id'"),
0);
$idv = $video['id'];
$v = mysql_result(mysql_query("SELECT COUNT(*) FROM `viduser` WHERE `idvid`='$idv' AND do='2'"),
0);
$n = mysql_result(mysql_query("SELECT COUNT(*) FROM `viduser` WHERE `idvid`='$idv' AND do='1'"),
0);
include_once '../sys/inc/thead.php';
title();
echo '» Смотреть онлайн <strong>' . $video['name'] . '</strong>';
$tex1t = htmlspecialchars($video['text']);
echo '<center><iframe width="560" height="315" src="' . $tex1t .
'" frameborder="0" ></iframe>
<br /><small>Просмотров: ' . $video['count'] .
' | Добавил: <a href="../info.php?id=' . $video['iduser'] . '">' . $video['login'] .
'</a> (' . date("d.m.Y / H:i", $video['data'] * 3600) . ') ';
echo ' | <a href="komm.php?id=' . $video['id'] . '">Комм:</a> (' . $count .
')';
echo ' | <a href="online.php?act=ves&id=' . $video['id'] .
'">Ок:</a> (' . $v . ')';
echo ' | <a href="online.php?act=no&id=' . $video['id'] .
'">Фу:</a> (-' . $n . ')';
echo '<br />' . $video['opis'] . '</small></center>';
echo '<div class="phdr"><a href="index.php?id=' . $video['refid'] .
'"> К разделу</a></div>';
}
} else
{
include_once '../sys/inc/thead.php';
title();
echo 'Видео не существует или было удаленно Администратором';
include_once '../sys/inc/tfoot.php';
exit;
}
} else
{
include_once '../sys/inc/thead.php';
title();
echo 'Ничего не выбранно';
include_once '../sys/inc/tfoot.php';
exit;
}
include_once '../sys/inc/tfoot.php';
?>