Файл: AdmPanel/zap.php
Строк: 821
<?php
$title = 'Панель управления сайтом - Управление записями';
$str='zap';
require_once('Sys/head.php');
require_once('../Sys/upload.php');
reg();
level(2);
echo'<div id="st21">';
switch($act)
{
default:
echo'
<div class="st2"> <h2 class="titlev">Управление записями</h2>
</div>';
echo '
';
echo '
';
$count = $mysqli->query("SELECT `id` FROM `".$prefix."zap` WHERE `ZapSt` = '0'")->num_rows;
if($count > 0)
{
$total = intval(($count-1)/$set['AdmpageZap'])+1;
$page = (isset($_GET['page'])) ? abs(intval($_GET['page'])) : '';
if(empty($page) OR $page < 0)
{
$page = 1;
}
if($page > $total)
{
$page = $total;
}
$past = intval($count/$set['AdmpageZap']);
$start = $page*$set['AdmpageZap']-$set['AdmpageZap'];
$stati = $mysqli->query("SELECT * FROM `".$prefix."zap` WHERE `ZapSt` = '0' ORDER BY `time` DESC LIMIT ".$start.",".$set['AdmpageZap']."");
while($row = $stati->fetch_assoc())
{
$start++;
echo '<div class="st2">
';
echo ' <h2 class="title"> '.$start.'. '.bbCodes(nl2br($row['name'])).'<div align="right"><span style="color:#000000" class="date"><big>'.data($row['time']).'</big></span> </div>
</h2>
<div class="middle_back">';
echo bbCodes(nl2br($row['text'])).'<br/>';
echo '<br/>';
$cats = $mysqli->query("SELECT `name` FROM `".$prefix."cat` WHERE `id` = '".$row['cat']."'");
$cat = $cats->fetch_assoc();
echo '<div align="right">Категория: <b>'.bbCodes(nl2br($cat['name'])).'</b><br/>';
echo 'Добавил: <b>'.$row['user'].'</b><br/>';
echo '<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/ZapKomments/comments/'.$row['id'].'">Управление Комментариями</a> <b>('.$row['comments'].')</b> | ';
echo '<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/zap/editZap/'.$row['id'].'">Редактировать</a> | <a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/zap/deleteZap/'.$row['id'].'">Удалить</a><br/>';
echo '</div></div></div>';
}
if($count > $set['AdmpageZap'])
{
navigation($total,$page,'http://'.$_SERVER['HTTP_HOST'].'/zap/');
}
}
else
{
echo '<div class="st2">
<h2 class="title"></h2><div class="middle_back">';
echo 'Записей нет.<br/>';
echo '</div></div>';
}
//echo '</div>';
break;
case 'view':
$query = $mysqli->query("SELECT * FROM `".$prefix."cat` WHERE `id` = '".$id."'");
if($query->num_rows == 0)
{
echo '<div class="st2">
<h2 class="titlev">Категории</h2>
</div>
<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo 'Вы ошиблись категорией.<br/>';
echo '</div></div></div>';
require_once ('../Sys/foot.php');
exit;
}
$cat = $query->fetch_array();
echo '
<div class="st2">
<h2 class="titlev"><strong>'.bbCodes(nl2br($cat['name'])).'</strong></h2>
</div>';
$count = $mysqli->query("SELECT `id` FROM `".$prefix."zap` WHERE `cat` = '".$cat['id']."' AND `ZapSt` = '0' ORDER BY `time` DESC")->num_rows;
if($count == 0)
{
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo 'Здесь еще не чего нет!<br/>';
echo '</div></div></div>';
require_once ('../Sys/foot.php');
exit;
}
$total = intval(($count-1)/$set['AdmpageZap'])+1;
$page = (isset($_GET['page'])) ? abs(intval($_GET['page'])) : '';
if(empty($page) OR $page < 0)
{
$page = 1;
}
if($page > $total)
{
$page = $total;
}
$past = intval($count/$set['AdmpageZap']);
$start = $page*$set['AdmpageZap']-$set['AdmpageZap'];
$stati = $mysqli->query("SELECT * FROM `".$prefix."zap` WHERE `cat` = '".$cat['id']."' AND `ZapSt` = '0' ORDER BY `time` DESC LIMIT ".$start.",".$set['AdmpageZap']."");
echo'
';
while($row = $stati->fetch_assoc())
{
$start++;
echo '<div class="st2">
<h2 class="title">'.$start.'. '.bbCodes(nl2br($row['name'])).'<div align="right"><span style="color:#000000" class="date"><big>'.data($row['time']).'</big></span> </div>
</h2>';
echo '<div class="middle_back">';
echo bbCodes(nl2br($row['text'])).'<br/>';
echo '<br/>';
$cats = $mysqli->query("SELECT `name` FROM `".$prefix."cat` WHERE `id` = '".$row['cat']."'");
$cat = $cats->fetch_assoc();
echo '<div align="right">Категория: <b>'. bbCodes(nl2br($cat['name'])).'</b><br/>';
echo 'Добавил: <b>'.$row['user'].'</b><br/>';
echo '<div align="left"><a href="http://'.$_SERVER['HTTP_HOST'].'/zap/comments/'.$row['id'].'">Комментарии</a>('.$row['comments'].')</div>';
if(isset($user_data))
{
$EditStati = ($user_data['level'] == 2) ? '<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/ZapKomments/comments/'.$row['id'].'">Управление Комментариями</a> <b>('.$row['comments'].')</b> |
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/zap/editZap/'.$row['id'].'">Редактировать</a> | <a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/zap/deleteZap/'.$row['id'].'">Удалить</a><br/> ' : '';
}
echo ' '.$EditStati.'';
echo '</div></div></div> ';
}
if($count > $set['AdmpageZap'])
{
navigation($total,$page,'http://'.$_SERVER['HTTP_HOST'].'/controlPanel/zap/');
}
//echo'</div>';
break;
case 'add':
echo '
<div class="st2">
<h2 class="title">Добавить запись</h2>
<div class="middle_back">';
if(isset($_POST['ok']) OR isset($_POST['okfile']))
{
$name = filter($_POST['name']);
$text = filter($_POST['text']);
$cat = abs(intval($_POST['cat']));
$ZapSt = abs(intval($_POST['ZapSt']));
$ComPower = abs(intval($_POST['ComPower']));
$UserPower = abs(intval($_POST['UserPower']));
$linkname = filter($_POST['linkname']);
}
if(isset($_POST['ok']))
{
$error = '';
if(empty($name) AND empty($text))
{
$error .= 'Не заполнены поля.<br/>';
}
$issetCat = $mysqli->query("SELECT `id` FROM `".$prefix."cat` WHERE `id` = '".$cat."'")->num_rows;
if($issetCat == 0)
{
$error .= 'Нет такой категории.<br/>';
}
if(!empty($error))
{ echo'';
echo '<div class="error">';
echo 'В результате заполнения полей , выявились ошибки:<br/>';
echo $error;
echo '<br />';
echo '</div>';
}
else
{
$mysqli->query("INSERT INTO `".$prefix."zap` VALUES ('', '".$name."', '".$text."', '".$time."', '".$user_data['login']."', '0', '".$cat."', '".$ZapSt."', '".$ComPower."', '".$UserPower."')");
if(!empty($linkname))
{
$prid = $mysqli->query("SELECT * FROM `".$prefix."zap` WHERE `name` = '".$name."' AND `text` = '".$text."' AND `user` = '".$user_data['login']."' AND `cat` = '".$cat."' AND `ZapSt` = '".$ZapSt."' AND `ComPower` = '".$ComPower."' AND `UserPower` = '".$UserPower."' ORDER BY `id` DESC")->fetch_assoc();
$mysqli->query("INSERT INTO `".$prefix."link` SET `name` = '".$linkname."', `url` = 'http://".$_SERVER['HTTP_HOST']."/p".$prid['id']."', `uid` = '0', `mest` = '2'");
if($cache['cacheMenu'] > 0)
{
if(file_exists('../Cache/cacheMenu2.cache')) unlink('../Cache/cacheMenu2.cache');
}
}
if($ZapSt==0){
$mysqli->query("UPDATE `".$prefix."cat` SET `count` = (`count` + 1) WHERE `id` = '".$cat."'");
}
echo '';
echo 'Запись успешно добавлена! <br/>';
echo '';
}
}
if(isset($_POST['okfile']))
{
if($_FILES['image']['error']==0 AND !empty($_FILES['image']['tmp_name']))
{
$handle = new upload($_FILES['image']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}
}
if($_FILES['image2']['error']==0 AND !empty($_FILES['image2']['tmp_name']))
{ $handle = new upload($_FILES['image2']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee2 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image3']['error']==0 AND !empty($_FILES['image3']['tmp_name']))
{ $handle = new upload($_FILES['image3']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee3 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image4']['error']==0 AND !empty($_FILES['image4']['tmp_name']))
{ $handle = new upload($_FILES['image4']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee4 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image5']['error']==0 AND !empty($_FILES['image5']['tmp_name']))
{ $handle = new upload($_FILES['image5']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee5 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image6']['error']==0 AND !empty($_FILES['image6']['tmp_name']))
{ $handle = new upload($_FILES['image6']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee6 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image7']['error']==0 AND !empty($_FILES['image7']['tmp_name']))
{ $handle = new upload($_FILES['image7']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee7 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image8']['error']==0 AND !empty($_FILES['image8']['tmp_name']))
{ $handle = new upload($_FILES['image8']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee8 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image9']['error']==0 AND !empty($_FILES['image9']['tmp_name']))
{ $handle = new upload($_FILES['image9']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee9 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image10']['error']==0 AND !empty($_FILES['image10']['tmp_name']))
{ $handle = new upload($_FILES['image10']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee10 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
}
echo'<br /><form enctype="multipart/form-data" action="" method="post" name="post">';
echo '<div id="2" style="display:none;"> ';
//$razm = '1'; // если нужна большая панель ВВ то должно быть 1
$setid = '222'; // id ссылки раскрывающего меню выбора цвета
$inputNamebb = 'name'; // name формы ввода
require_once('../javascript/panelbb.php');
echo'</div>';
echo'Название записи: ';
echo"<a href="javascript:ShowOrHide('2');">Показать BB коды</a><br />";
echo" <textarea class="form" name="name" cols="73" rows="1" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);">".$_POST['name']."</textarea><br /><br />n"; //echo'<input type="text" class="form" name="name" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);"> ';
echo '<div id="4" style="display:none;"> ';
echo'Выберите изображение:';
echo"<a href="javascript:ShowOrHide('5');">Добавить больше изображений</a>";
echo'<br/><input type="file" name="image" value=""/> <input type="submit" class="button" name="okfile" value="Добавить файлы"/>';
echo '<div id="5" style="display:none;">';
echo' <input type="file" name="image2" value=""/><br/>';
echo' <input type="file" name="image3" value=""/><br/>';
echo' <input type="file" name="image4" value=""/><br/>';
echo' <input type="file" name="image5" value=""/><br/>';
echo' <input type="file" name="image6" value=""/><br/>';
echo' <input type="file" name="image7" value=""/><br/>';
echo' <input type="file" name="image8" value=""/><br/>';
echo' <input type="file" name="image9" value=""/><br/>';
echo' <input type="file" name="image10" value=""/><br/>';
echo'</div>';
echo' <br /><br />';
echo'</div>';
echo '<div id="3" style="display:none;"> ';
$razm2 = '1'; // если нужна большая панель ВВ то должно быть 1
$setid2 = '333'; // id ссылки раскрывающего меню выбора цвета
$inputNamebb2 = 'text'; // name формы ввода
require_once('../javascript/panelbb2.php');
echo'</div>';
echo'
Текст записи: ';
echo"<a href="javascript:ShowOrHide('3');">Показать BB коды</a> | <a href="javascript:ShowOrHide('4');">Закачать изображение</a><br />";
echo" <textarea class="form" name="text" cols="73" rows="35" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);">".$namee."".$namee2."".$namee3."".$namee4."".$namee5."".$namee6."".$namee7."".$namee8."".$namee9."".$namee10."".$_POST['text']."</textarea><br /><br />n"; //echo'<input type="text" class="form" name="name" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);"> ';
echo' Категория:<br/>
<select name="cat">
';
$cats = $mysqli->query("SELECT * FROM `".$prefix."cat` ORDER BY `position` ASC");
if($cats->num_rows > 0)
{
while($catv = $cats->fetch_array())
{ $selected = ($cat == $catv['id']) ? ' selected="selected"' : '';
echo '<option value="'.$catv['id'].'" '.$selected.'>'.bbCodes(nl2br($catv['name'])).'</option>';
}
}
echo '</select><br/><br/>';
echo'Запись или Страница:<br/>';
echo '<select name="ZapSt">';
if ($ZapSt == 0)
{
echo '<option value="0">Запись</option>';
echo '<option value="1">Страница</option>';
}
else
{
echo '<option value="1">Страница</option>';
echo '<option value="0">Запись</option>';
}
echo'</select><br /><br /> ';
echo 'Комментарии: ';
$checkComPower0 = $ComPower == 0 ? 'checked' : '';
$checkComPower1 = $ComPower == 1 ? 'checked' : '';
echo ' <input type="radio" '.$checkComPower1.' name="ComPower" class="button" value="1"/>Вкл';
echo ' <input type="radio" '.$checkComPower0.' name="ComPower" class="button" value="0"/>Выкл<br/><br /><br />';
echo 'Показать информацию об авторе и дату: ';
$checkUserPower0 = $UserPower == 0 ? 'checked' : '';
$checkUserPower1 = $UserPower == 1 ? 'checked' : '';
echo ' <input type="radio" '.$checkUserPower1.' name="UserPower" class="button" value="1"/>Вкл';
echo ' <input type="radio" '.$checkUserPower0.' name="UserPower" class="button" value="0"/>Выкл<br/><br /><br />';
echo'Создать ссылку (введите имя ссылки):<br /> ';
echo' <textarea class="form" name="linkname" cols="73" rows="1">'.$_POST['linkname'].'</textarea><br /><br />';
echo'<input name="ok" type="submit" class="button" value="Добавить" />
</form>
</div> </div>
';
break;
case 'deleteZap':
if($id)
{
$zapIsset = $mysqli->query("SELECT `cat`, `ZapSt` FROM `".$prefix."zap` WHERE `id` = '".$id."'");
$zap = $zapIsset->fetch_assoc();
$mysqli->query("DELETE FROM `".$prefix."zap_comments` WHERE `nid` = '".$id."'");
$mysqli->query("DELETE FROM `".$prefix."zap` WHERE `id` = '".$id."'");
if($zap['ZapSt']==0){
$mysqli->query("UPDATE `".$prefix."cat` SET `count` = (`count` - 1) WHERE `id` = '".$zap['cat']."'");
}
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo 'Запись успешно удалена.<br/>';
echo '</div></div>';
}
else
{
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo 'Не выбрана запись.<br/>';
echo '</div></div>';
}
break;
case 'editZap':
if($id)
{
$isset = $mysqli->query("SELECT * FROM `".$prefix."zap` WHERE `id` = '".$id."'");
if($isset->num_rows > 0)
{
$stati = $isset->fetch_assoc();
echo '<div class="st2">
<h2 class="title">Изменение записи</h2>
';
echo' <div class="middle_back">';
if(isset($_POST['ok']) OR isset($_POST['okfile']))
{
$name = filter($_POST['name']);
$text = filter($_POST['text']);
$cat = abs(intval($_POST['cat']));
$stcat = abs(intval($_POST['stcat']));
$ZapSt = abs(intval($_POST['ZapSt']));
$ComPower = abs(intval($_POST['ComPower']));
$UserPower = abs(intval($_POST['UserPower']));
$linkname = filter($_POST['linkname']);
}
if(isset($_POST['ok']) OR isset($_POST['okfile']))
{
$error = '';
if(empty($name) AND empty($text))
{
$error .= 'Ошибка!Не заполнены поля!<br/>';
}
$issetCat = $mysqli->query("SELECT `id` FROM `".$prefix."cat` WHERE `id` = '".$cat."'")->num_rows;
if($issetCat == 0)
{
$error .= 'Нет такой категории.<br/>';
}
if(!empty($error))
{
echo '
<div class="error">';
echo 'В результате заполнения полей , выявились ошибки:<br/>';
echo $error;
echo '<br/>';
echo '</div>';
}
else
{
if(!empty($linkname))
{
$mysqli->query("INSERT INTO `".$prefix."link` SET `name` = '".$linkname."', `url` = 'http://".$_SERVER['HTTP_HOST']."/p".$id."', `uid` = '0', `mest` = '2'");
if($cache['cacheMenu'] > 0)
{
if(file_exists('../Cache/cacheMenu2.cache')) unlink('../Cache/cacheMenu2.cache');
}
}
if (($stati['ZapSt'] == 0) AND ($ZapSt == 0))//если была и осталась запись
{
$mysqli->query("UPDATE `".$prefix."cat` SET `count` = (`count` - 1) WHERE `id` = '".$stcat."'");
$mysqli->query("UPDATE `".$prefix."cat` SET `count` = (`count` + 1) WHERE `id` = '".$cat."'");
}
if(($stati['ZapSt'] == 0) AND ($ZapSt == 1))//если была запись стала страница
{
$mysqli->query("UPDATE `".$prefix."cat` SET `count` = (`count` - 1) WHERE `id` = '".$stcat."'");
}
if(($stati['ZapSt'] == 1) AND ($ZapSt == 0))//если была страница стала запись
{
$mysqli->query("UPDATE `".$prefix."cat` SET `count` = (`count` + 1) WHERE `id` = '".$cat."'");
}
$mysqli->query("UPDATE `".$prefix."zap` SET `name` = '".$name."', `text` = '".$text."', `cat` = '".$cat."', `ZapSt` = '".$ZapSt."', `ComPower` = '".$ComPower."', `UserPower` = '".$UserPower."' WHERE `id` = '".$id."'");
if(!isset($_POST['okfile'])){
echo 'Запись успешно изменена<br /><br /> ';
}
}
}
if(isset($_POST['okfile']))
{
if($_FILES['image']['error']==0 AND !empty($_FILES['image']['tmp_name']))
{
$handle = new upload($_FILES['image']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}
}
if($_FILES['image2']['error']==0 AND !empty($_FILES['image2']['tmp_name']))
{ $handle = new upload($_FILES['image2']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee2 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image3']['error']==0 AND !empty($_FILES['image3']['tmp_name']))
{ $handle = new upload($_FILES['image3']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee3 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image4']['error']==0 AND !empty($_FILES['image4']['tmp_name']))
{ $handle = new upload($_FILES['image4']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee4 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image5']['error']==0 AND !empty($_FILES['image5']['tmp_name']))
{ $handle = new upload($_FILES['image5']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee5 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image6']['error']==0 AND !empty($_FILES['image6']['tmp_name']))
{ $handle = new upload($_FILES['image6']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee6 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image7']['error']==0 AND !empty($_FILES['image7']['tmp_name']))
{ $handle = new upload($_FILES['image7']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee7 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image8']['error']==0 AND !empty($_FILES['image8']['tmp_name']))
{ $handle = new upload($_FILES['image8']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee8 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image9']['error']==0 AND !empty($_FILES['image9']['tmp_name']))
{ $handle = new upload($_FILES['image9']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee9 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
if($_FILES['image10']['error']==0 AND !empty($_FILES['image10']['tmp_name']))
{ $handle = new upload($_FILES['image10']);
if ($handle->uploaded)
{ $handle->allowed = array('image/jpeg','image/gif','image/png');
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_x = 500;
$handle->process('../imgfile/');
if ($handle->processed)
{
$mysqli->query("INSERT INTO `".$prefix."image` SET `name` = '".$handle->file_dst_name."', `time` = '".$time."'");
$namee10 = "[img]http://".$_SERVER['HTTP_HOST']."/imgfile/".$handle->file_dst_name."[/img]";
echo 'Загружен: <b>'.$handle->file_dst_name.'</b><br />';
}
else
{
echo 'Ошибка загрузки:<br/> '.$handle->error.'<br /><br />';
}
$handle->clean();
}}
}
$isset2 = $mysqli->query("SELECT * FROM `".$prefix."zap` WHERE `id` = '".$id."'");
$stati = $isset2->fetch_assoc();
echo '<br />
<form enctype="multipart/form-data" action="" method="post" name="post">';
echo' <div id="2" style="display:none;"> ';
//$razm = '1'; // если нужна большая панель ВВ то должно быть 1
$setid = '222'; // id ссылки раскрывающего меню выбора цвета
$inputNamebb = 'name'; // name формы ввода
require_once('../javascript/panelbb.php');
echo'</div>';
echo'Название записи: ';
echo"<a href="javascript:ShowOrHide('2');">Показать BB коды</a><br />";
echo" <textarea class="form" name="name" cols="73" rows="1" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);">".$stati['name']."</textarea><br /><br />n";
echo '<div id="4" style="display:none;"> ';
echo'Выберите изображение:';
echo"<a href="javascript:ShowOrHide('5');">Добавить больше изображений</a>";
echo'<br/><input type="file" name="image" value=""/> <input type="submit" class="button" name="okfile" value="Добавить файлы"/>';
echo '<div id="5" style="display:none;">';
echo' <input type="file" name="image2" value=""/><br/>';
echo' <input type="file" name="image3" value=""/><br/>';
echo' <input type="file" name="image4" value=""/><br/>';
echo' <input type="file" name="image5" value=""/><br/>';
echo' <input type="file" name="image6" value=""/><br/>';
echo' <input type="file" name="image7" value=""/><br/>';
echo' <input type="file" name="image8" value=""/><br/>';
echo' <input type="file" name="image9" value=""/><br/>';
echo' <input type="file" name="image10" value=""/><br/>';
echo'</div>';
echo' <br /><br />';
echo'</div>';
echo '<div id="3" style="display:none;"> ';
$razm2 = '1'; // если нужна большая панель ВВ то должно быть 1
$setid2 = '333'; // id ссылки раскрывающего меню выбора цвета
$inputNamebb2 = 'text'; // name формы ввода
require_once('../javascript/panelbb2.php');
echo'</div>';
echo'
Текст записи: ';
echo"<a href="javascript:ShowOrHide('3');">Показать BB коды</a> | <a href="javascript:ShowOrHide('4');">Закачать изображение</a><br />";
echo" <textarea class="form" name="text" cols="73" rows="35" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);">".$namee."".$namee2."".$namee3."".$namee4."".$namee5."".$namee6."".$namee7."".$namee8."".$namee9."".$namee10."".$stati['text']."</textarea><br /><br />n"; //echo'<input type="text" class="form" name="name" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);"> ';
echo'Категория:<br/>
<select name="cat">
';
$cats = $mysqli->query("SELECT * FROM `".$prefix."cat` ORDER BY `position` ASC");
if($cats->num_rows > 0)
{
while($catv = $cats->fetch_assoc())
{
$selected = ($stati['cat'] == $catv['id']) ? ' selected="selected"' : '';
echo '<option value="'.$catv['id'].'" '.$selected.'>'.bbCodes(nl2br($catv['name'])).'</option>
';
}
}
echo '</select><br/><br />
Запись или Страница:<br/>';
echo '<select name="ZapSt">';
if ($stati['ZapSt'] == 0)
{
echo '<option value="0">Запись</option>';
echo '<option value="1">Страница</option>';
}
else
{
echo '<option value="1">Страница</option>';
echo '<option value="0">Запись</option>';
}
echo'</select><br /><br /> ';
echo 'Комментарии: ';
$checkComPower0 = $stati['ComPower'] == 0 ? 'checked' : '';
$checkComPower1 = $stati['ComPower'] == 1 ? 'checked' : '';
echo ' <input type="radio" '.$checkComPower1.' name="ComPower" class="button" value="1"/>Вкл';
echo ' <input type="radio" '.$checkComPower0.' name="ComPower" class="button" value="0"/>Выкл<br/><br /><br />';
echo 'Показать информацию об авторе и дату: ';
$checkUserPower0 = $stati['UserPower'] == 0 ? 'checked' : '';
$checkUserPower1 = $stati['UserPower'] == 1 ? 'checked' : '';
echo ' <input type="radio" '.$checkUserPower1.' name="UserPower" class="button" value="1"/>Вкл';
echo ' <input type="radio" '.$checkUserPower0.' name="UserPower" class="button" value="0"/>Выкл<br/><br /><br />';
echo'Создать ссылку (введите имя ссылки):<br /> ';
echo' <textarea class="form" name="linkname" cols="73" rows="1"></textarea><br /><br />';
echo'<input name="stcat" type="hidden" value="'.$stati['cat'].'">
<input type="submit" class="button" name="ok" value="Изменить"/>
</form>';
echo'</div></div>';
}
else
{
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back"><div class="error">';
echo 'Данной записи нет.<br/>';
echo '</div></div></div>';
}
}
else
{
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back"><div class="error">';
echo 'Не выбрана запись.<br/>';
echo '</div></div></div>';
}
break;
}
echo '</div>';
?>