<?
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_access('adm_narutorules',null,'index.php?'.SID);
$set['title']='Правила сайта';
include_once '../sys/inc/thead.php';
title();
aut();
if (isset($_GET['add']))
{
if (isset($_POST['title']) && $_POST['title']!=NULL && isset($_POST['text']) && $_POST['text']!=NULL)
{
$title = mysql_escape_string(htmlspecialchars($_POST['title']));
$text = mysql_escape_string(htmlspecialchars($_POST['text']));
mysql_query("INSERT INTO `narutorules` (`title`, `text`, `time`) VALUES ('$title', '$text', '$time')");
msg('Правило добавлено !');
}

echo '<form method="post" action="narutorules.php?add">';
echo 'Название:<br/><input name="title" type="text"/><br/>';
echo 'Текст:<br/><textarea name="text"></textarea><br/>';
echo '<input value="Добавить" type="submit"/><br/>';
echo '</form>';

echo '<div class="foot">';
if ($user['level']>3)
{
echo '&laquo;<a href="narutorules.php">Список правил</a><br/>';
echo '&laquo;<a href="/adm_panel/">В админку</a><br/>';
}
echo '</div>';
}

if (isset($_GET['view']) && $_GET['view']!=NULL && $_GET['view']=intval($_GET['view']))
{
$view = mysql_fetch_array(mysql_query("SELECT * FROM `narutorules` WHERE `id` = '".intval($_GET['view'])."' LIMIT 1"));

echo '<div class="p_m">'.$view['title'].'  ('.vremja($view['time']).')</div>';
echo '<div class="p_m">Текст:<br> '.output_text($view['text']).'</div><a href="narutorules.php?edit='.$view['id'].'"></a>';
echo '<a href="narutorules.php?edit='.$view['id'].'">Изменить правило</a><br/>';
echo '<a href="narutorules.php?del='.$view['id'].'">Удалить правило</a><br/>';
echo '<div class="foot">';
if ($user['level']>3)
{
echo '&laquo;<a href="narutorules.php">В правила</a><br/>';
echo '&laquo;<a href="/adm_panel/">В админку</a><br/>';
}
echo '</div>';
}


if (isset($_GET['edit']) && $_GET['edit']!=NULL && $_GET['edit']=intval($_GET['edit']))
{

if (isset($_POST['title']) && isset($_POST['text']))
{
$title = mysql_escape_string(htmlspecialchars($_POST['title']));
$text = mysql_escape_string(htmlspecialchars($_POST['text']));

mysql_query("UPDATE `narutorules` SET `title` = '$title', `text` = '$text' WHERE `id` = '".intval($_GET['edit'])."'");
msg('Правило изменено !');
{header("Location: narutorules.php?".SID);exit;}

}

$edit = mysql_fetch_array(mysql_query("SELECT * FROM `narutorules` WHERE `id` = '".intval($_GET['edit'])."' LIMIT 1"));

echo '<form method="post" action="narutorules.php?edit='.$edit['id'].'">';
echo 'Заголовок:<br/><input name="title" type="text" value="'.$edit['title'].'"/><br/>';
echo 'Текст:<br/><textarea name="text">'.$edit['text'].'</textarea><br/>';
echo '<input value="Изменить" type="submit"/><br/>';
echo '</form>';

echo '<div class="foot">';
echo '&laquo;<a href="narutorules.php">В правила</a><br/>';
echo '&laquo;<a href="/adm_panel/">В админку</a><br/>';
echo '</div>';
}


if (isset($_GET['del']) && $_GET['del']!=NULL && $_GET['del'] = intval($_GET['del']))
{
$del = intval($_GET['del']);

mysql_query("DELETE FROM `narutorules` WHERE `id` = '$del' LIMIT 1");
msg('Правило удалено !');
}


if (!isset($_GET['view']) && !isset($_GET['edit']) && !isset($_GET['add']))
{
$k_narutorules=mysql_result(mysql_query("SELECT COUNT(*) FROM `narutorules`"),0);
$k_page=k_page($k_narutorules,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<table class='post'>\n";
if ($k_narutorules==0)
{
echo "   <tr>\n";
echo "  <td class='p_t'>\n";
echo "Нет правил. <a href='narutorules.php?add'>Добавить?</a> \n";
echo "  </td>\n";
echo "   </tr>\n";

}
$q=mysql_query("SELECT * FROM `narutorules` ORDER BY `id` ASC LIMIT $start, $set[p_str]");
while ($narutorules = mysql_fetch_array($q))
{
echo "   <tr>\n";

echo "  <td class='p_t'>\n";
echo '<a href="narutorules.php?view='.$narutorules['id'].'">'.$narutorules['title'].'</a> [<a href="narutorules.php?edit='.$narutorules['id'].'">изм.</a>] [<a href="narutorules.php?del='.$narutorules['id'].'">удал.</a>]<br/>';
echo "  </td>\n";
echo "   </tr>\n";
echo "   <tr>\n";
}

echo "</table>\n";
if ($k_page>1)str("?",$k_page,$page);

if ($user['level']>=3){
echo "<div class='foot'>\n";
echo '&raquo;<a href="narutorules.php?add">Добавить правило</a>';echo ' '.$k_narutorules.' правил(а)<br>';

echo "&laquo;<a href='/adm_panel/'>В админку</a><br />\n";
echo "</div>\n";
}
}
include_once '../sys/inc/tfoot.php';
?>