$text = $_POST['text'];
$text = iconv( "utf-8", "windows-1251", $text);
if ($_POST['vindex'] == 'on') {$vindex = 1; } else {$vindex = 0;};
$catquery = mysql_query("SELECT catvis FROM categories WHERE id = "._filter($category)."");
$rower = mysql_fetch_array($catquery);
if ($rower['catvis'] == 1) {$vindex = 1;}
$date = time();
$send = mysql_query("INSERT INTO posts VALUES(NULL, '"._filter($category)."','"._filter($name)."','"._filter2($text)."','"._filter($date)."', 0, 0, "._filter($vindex).", 0)");
if ($send == 'true')
{
?>
Вы добавили новость!
<?
exit;
}
else
{
?>
Ошибка!
<?
$text = iconv( "utf-8", "windows-1251", $text);
$page = $_POST['page'];
$page = iconv( "utf-8", "windows-1251", $page);
$rusname = rus2translit($name);
$rusname = strtolower($rusname);
$date = time();
$proverka = mysql_query("SELECT * FROM pages WHERE page='"._filter($page)."'");
if(mysql_num_rows($proverka) >= 1)
{
m_error("Такая страница уже существует");
exit;
}
$send = mysql_query("INSERT INTO pages VALUES(NULL,'"._filter($name)."','"._filter2($text)."','"._filter($date)."','"._filter($page)."', '0')");
if ($send == 'true')
{
?>
Страница добавлена!
<?
exit;
}
else
{
?>
Неизвестная ошибка
<?
$name = iconv( "utf-8", "windows-1251", $name);
$text = $_POST['text'];
$text = iconv( "utf-8", "windows-1251", $text);
$page = $_POST['page'];
$page = iconv( "utf-8", "windows-1251", $page);
$ids = $_POST['sid'];
$proverka = mysql_query("SELECT * FROM pages WHERE page='"._filter($page)."'");
if ($_POST['vis'] == 'yes') {$vindex = 1; } else {$vindex = 0;};
if(mysql_num_rows($proverka) >= 2)
{
m_error("Такая страница уже существует");
exit;
}
$send = mysql_query("UPDATE pages SET name = '"._filter($name)."', text='"._filter2($text)."', page='"._filter($page)."', visible='"._filter($vindex)."' WHERE id='"._filter($ids)."'");
if ($send == 'true')
{
?>Вы успешно отредактировали страницу
<?
}
else
{
?>
Ошибка!
<?
