Файл: admin/servis.php
Строк: 749
<?
require'../includes.php';
$align='left';
$title='Админка';
head();
aut();
levels(9);
who_add(0,'enter');
if($sid!=1)exit();
switch($mod){
default:
echo '» <a href="?mod=snews">Новости</a><br />';
echo '» <a href="?mod=all">Все чаты</a> ('.mysql_result(query("select count(*) as num from chats"),0).')<br />';
echo '» <a href="support">Поддержка</a>(<b>'.mysql_result(query("select count(*) as num from support WHERE to_id = '1' and `readin` = '0'"),0).'</b>/'.mysql_result(query("select count(*) as num from support WHERE to_id = '1'"),0).')<br />';
echo '» <a href="?mod=rassylka">Рассылка в поддержку</a><br />';
echo '» <a href="?mod=barmen">Бот Бармен</a><br />';
echo '» <a href="?mod=sbanners">Реклама и баннеры</a><br />';
echo '» <a href="?mod=report">Сообщения об ошибках</a> ('.mysql_result(query("select count(*) as num from report"),0).')<br />';
break;
case 'report':
if (isset($_GET['delk'])){
query("DELETE FROM `report` WHERE `id` = '".intval($_GET['delk'])."'");
header ('Location: ?mod='.$mod.'&'.SID);
}
echo '<br />';
$max = $user['max'];
$k_post=mysql_result(query("select count(*) as num from report"),0);
$k_page=k_page($k_post,$max);
$page=page($k_page);
$start=$max*$page-$max;
$r = query ("Select * from report order by time desc LIMIT $start, $max");
if ($k_post == 0)echo 'Сообщений пока нет<br />';
$post_k=$start+1;
while($a = @mysql_fetch_assoc($r)){
$us = @mysql_fetch_assoc(query ("Select * from users WHERE id = '$a[user_id]'"));
echo links.''.nik2($a['user_id']).' <b>['.$us['sid'].']</b>';
echo '<small><a href="?mod='.$mod.'&delk='.$a['id'].'">[X]</a></small>';
echo '('.times($a['time']).')'.div;
echo text($a['msg']);
echo '<dl></dl>';
}
if ($k_page>1){
echo "<dl><dt></dt></dl>";
str('?mod='.$mod.'&',$k_page,$page); // Вывод страниц
echo "<br /><dl><dt></dt></dl><br />";
}
break;
case 'snews':
if (empty($act)){
if (isset($_GET['delk'])){
if($user[level]>=5){
query("DELETE FROM `snews` WHERE `id` = '".check(intval($_GET['delk']))."'");
query("DELETE FROM `snewskom` WHERE `new` = '".check(intval($_GET['delk']))."'");
}
header ('Location: ?mod='.$mod.'&'.SID);
}
echo '<a href="?mod='.$mod.'&act=add">Добавить новость</a><dt></dt>';
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(query("select count(*) as num from snews "),0);
$k_page=k_page($k_post,$max);
$page=page($k_page);
$start=$max*$page-$max;
$r = query ("Select * from snews order by time desc LIMIT $start, $max");
if ($k_post == 0)echo 'Новостей нет<br />';
$post_k=$start+1;
while($a = mysql_fetch_assoc($r)){
echo links.''.nik($a[user_id]).' ('.times($a['time']).') <a href="?mod='.$mod.'&delk='.$a[id].'">[Удал]</a>|<a href="?mod='.$mod.'&act=edit&new='.$a[id].'">[Изм]</a>'.div;
echo text($a[msg]);
echo '<dl></dl>';
}
if ($k_page>1){
echo "<dl><dt></dt></dl>";
str('?mod='.$mod.'&',$k_page,$page); // Вывод страниц
echo "<br /><dl><dt></dt></dl><br />";
}
}else if($act=='add'){
if ($ver!='wml'){echo '<form action="?mod='.$mod.'&act=addi&'.SID.'" method="post">';
echo'Новость:<br /><textarea cols="'.$user['pole2'].'" rows="'.$user['pole1'].'" name="msg" ></textarea><br />';echo '<br /><input type="submit" class="ibutton" value="Добавить"/></form><br /><br />';
}else{
echo 'Новость:<br /><input name="msg'.$ref.'" title="Новость"/><br/>';
echo '<br /><anchor title="go">Добавить<go href="?mod='.$mod.'&act=addi&'.SID.'" method="post">';
echo '<postfield name="msg" value="$msg'.$ref.'"/></go></anchor><br/>';
}
}else if($act=='addi'){
$msg = check($_POST['msg']);
if (strlen2($msg)<5){echo 'Новость слишком короткая!'; exit;}
if ($user['translit']==1)$msg = translit($msg);
if (query ("INSERT INTO snews (user_id,time,msg) VALUES ('$user[id]','$time','$msg')")){header ('Location: ?mod='.$mod.'&'.SID); exit;
}else echo 'Ошибка!<br />';
}else if($act=='edit'){ // Изменение
$new = check(intval($_GET['new']));
$a = mysql_fetch_assoc(query ("Select * from snews WHERE id = '".$new."'"));
if ($ver!='wml'){echo '<form action="?mod='.$mod.'&new='.$new.'&act=editi&'.SID.'" method="post">';
$datamainfile = str_replace('<br />',"n",text($a[msg],false,true,false,false,false));
echo'Новость:<br /><textarea cols="'.$user['pole2'].'" rows="'.$user['pole1'].'" name="msg" >'.$datamainfile.'</textarea><br />';echo '<br /><input type="submit" class="ibutton" value="Изменить"/></form><br /><br />';
}else{
echo 'Новость:<br /><input name="msg'.$ref.'" value="'.text($a[msg],false,true,false,false,false).'" title="Новость"/><br/>';
echo '<br /><anchor title="go">Изменить<go href="?mod='.$mod.'&new='.$new.'&act=editi&'.SID.'" method="post">';
echo '<postfield name="msg" value="$msg'.$ref.'"/></go></anchor><br/>';
}
}else if($act==editi){
$new = check(intval($_GET['new']));
$msg = check($_POST['msg']);
if (strlen2($msg)<5){echo 'Новость слишком короткая!'; exit;}
if ($user['translit']==1)$msg = translit($msg);
if (query("UPDATE `snews` SET `msg` = '$msg' WHERE `id` = '".$new."'")){header ('Location: ?mod='.$mod.'&'.SID); exit;
}else echo 'Ошибка!<br />';
}
break;
case 'all':
$max = isset($_REQUEST['max']) ? check($_REQUEST['max']) : '10';
$sort = isset($_REQUEST['sort']) ? check($_REQUEST['sort']) : 'desc';
$k_post=mysql_result(query("select count(*) as num from chats"),0);
$k_page=k_page($k_post,$max);
$page=page($k_page);
$start=$max*$page-$max;
echo "<form method="GET" action="?mod=$mod">
<input type="hidden" />Чатов на стр.:<select class="do_button" name="max">n";
if($max==5)echo "<option value="5">5</option>n";
if($max==10)echo "<option value="10">10</option>n";
if($max==15)echo "<option value="15">15</option>n";
if($max==20)echo "<option value="20">20</option>n";
echo "<option value="5">5</option>n";
echo "<option value="10">10</option>n";
echo "<option value="15">15</option>n";
echo "<option value="20">20</option></select>n";
echo "<input type="hidden" name="sort" value="$sort"/>
<br/><input type="submit" class="ibutton" value="Сменить"/></p></form>";
echo "Сортировать по:<br />n";
if ($sort=='asc'){
echo "По возрастанию ci|";
echo "<a href="?mod=$mod&page=$page&sort=desc&max=$max">По убыванию ci</a>n";
}else if ($sort=='desc'){
echo "<a href="?mod=$mod&page=$page&sort=asc&max=$max">По возрастанию ci</a>|";
echo "По убыванию cin";
}
echo '<dl><dt></dt></dl><br />';
$r = query ("Select * from chats order by sid ".$sort." LIMIT $start, $max");
if ($k_post == 0)echo 'Чатов нет<br />';
if ($sort=='desc') $k_page2 = $k_post-$start; //321
else $post_k=$start+1; //123
while($a = mysql_fetch_assoc($r)){
$uss=mysql_fetch_assoc(query ("Select * from users WHERE `sid` = '$a[sid]' order by id asc LIMIT 1"));
echo links.'<b>SID: '.$a['sid'].'</b>. <b><a href="/'.$a['sid'].'">'.$a['name'].'</a></b>'.div;
echo 'Главная: <a href="http://'.$a['link'].'">http://'.$a['link'].'</a><br />
Зарегистрирован: '.times($uss['timereg']).'<br />
Online: '.mysql_result(query("SELECT COUNT(*) FROM `who` WHERE `sid` = '$a[sid]'"),0).'<br />
Рег: '.mysql_result(query("select count(id) as num from users WHERE `sid` = '$a[sid]'"),0).'<br />';
echo 'Домен: '.$a['dom'].' <a href="?mod=dom&id_chat='.$a['sid'].'">[изменить]</a><br />';
echo '<a href="?mod=inf&id_chat='.$a['sid'].'">Инфа</a> <b>|</b> <a href="?mod=delete&id_chat='.$a['sid'].'">Удалить</a> <b>|</b> </b> <a href="support?mod=add&to='.$uss['sid'].'">Написать</a><br />';
echo '<dl></dl>';
}
if ($k_page>1){
echo "<dl><dt></dt></dl>";
str("?mod=$mod&sort=$sort&max=$max&",$k_page,$page); // Вывод страниц
echo "<br /><dl><dt></dt></dl><br />";
}
break;
case 'dom':
$id_chat = isset ($_REQUEST['id_chat']) ? abs(intval(check($_REQUEST['id_chat']))) : false;
$a = mysql_fetch_assoc(query ("Select * from chats WHERE `sid` = '$id_chat'"));
if (empty($act)){
if(isset($_REQUEST['act2']))echo '<b>Изменено!</b><br />';
if ($ver!='wml')echo '<form action="?mod='.$mod.'&act=act&id_chat='.$id_chat.'&'.SID.'" method="post">';
echo '<b>Чат '.$id_chat.'</b><br />Домен:<br /><input name="dom" value="'.$a['dom'].'" title="Text"/><br/>';
if ($ver=='wml'){
echo '<br /><anchor title="go">Изменить<go href="?mod='.$mod.'&act=act&id_chat='.$id_chat.'&'.SID.'" method="post">';
echo '
<postfield name="name" value="$name"/>
</go></anchor><br />';
;
}else{
echo '<br /><input type="submit" class="ibutton" value="Изменить"/></form><br />';
}
}else{
if (query("UPDATE `chats` SET `dom` = '".check($_POST['dom'])."' WHERE `sid` = '$id_chat'")){header ('Location: ?mod='.$mod.'&act2=act2&id_chat='.$id_chat.'&'.SID); exit;
}else echo 'Ошибка!<br />';
}
break;
case 'rassylka':
if (empty($act)){
if(isset($_REQUEST['act2']))echo '<b>Изменено!</b><br />';
if ($ver!='wml')echo '<form action="?mod='.$mod.'&act=act&'.SID.'" method="post">';
if ($ver=='wml')echo '<br />Сообщение:<br /><input name="msg'.$ref.'" title="Text"/><br/>';
else echo '<br />Сообщение:<br /><textarea cols="'.$user['pole2'].'" rows="'.$user['pole1'].'" name="msg"></textarea><br/><br />';
if ($ver=='wml'){
echo '<br /><anchor title="go">Отправить<go href="?mod='.$mod.'&act=act&'.SID.'" method="post">';
echo '
<postfield name="msg" value="$msg"/>
</go></anchor><br />';
;
}else{
echo '<br /><input type="submit" class="ibutton" value="Отправить"/></form><br />';
}
}else{
$msg = check($_POST['msg']);
$k_post=mysql_result(query("select count(*) as num from chats"),0);
$r = query ("Select * from chats order by sid asc");
if ($k_post == 0)echo 'Чатов нет<br />';
$post_k=0;
while($a = mysql_fetch_assoc($r)){
$uss=mysql_fetch_assoc(query ("Select * from users WHERE `sid` = '$a[sid]' order by id asc LIMIT 1"));
if (query ("INSERT INTO support (user,user_id,to_user,to_id,time,msg) VALUES ('$a[sid]','$user[user]','$user[id]','".$uss['user']."','".$uss['id']."','$time','$msg')")){
$post_k++;
}
}
echo '<br />Отправлено в <b>'.$post_k.'</b> из <b>'.$k_post.'</b> чатов<br />';
}
break;
case 'inf':
$id_chat = isset ($_REQUEST['id_chat']) ? abs(intval(check($_REQUEST['id_chat']))) : false;
echo 'Информация о чате: <b>'.$id_chat.'</b><br />';
$a = mysql_fetch_assoc(query ("Select * from chats WHERE `sid` = '$id_chat'"));
//$us = mysql_fetch_assoc(query ("Select * from users WHERE `sid` = '$id_chat'")};
$uss=mysql_fetch_assoc(query ("Select * from users WHERE `sid` = '$a[sid]' order by id asc LIMIT 1"));
$uss2=mysql_fetch_assoc(query ("Select * from users WHERE `sid` = '$a[sid]' order by id desc LIMIT 1"));
$gfh2 = mysql_fetch_assoc(query ("Select * from online WHERE sid = '".$a['sid']."' LIMIT 1;"));
echo 'Чат: <a href="/'.$a['sid'].'">'.$a['name'].'</a><br />Главная: <a href="http://'.$a['link'].'">http://'.$a['link'].'</a><br />
Зарегистрирован: '.times($uss['timereg']).'<br />
Рефералов: <b>'.mysql_result(query("select count(*) as num from refchats WHERE `sid` = '$a[sid]'"),0).'</b><br />
Online: '.mysql_result(query("SELECT COUNT(*) FROM `who` WHERE `sid` = '$a[sid]'"),0).' | Мах: <b>'.$gfh2['onl'].'</b> ['.times($gfh2['time']).']<br />
Рег: '.mysql_result(query("select count(id) as num from users WHERE `sid` = '$a[sid]'"),0).' | Последняя: '.times($uss2['timereg']).'<br />';
echo 'Анкет в знакомствах: '.mysql_result(query("select count(*) as num from users WHERE `sid` = '$a[sid]' and love_city!='0'"),0).'<br />';
echo '<dt></dt>';
echo 'Админ: '.nik2($uss['id']).'<br />';
echo 'Его IP: <a href="users?mod=ban_ip&ipus='.user_inf2($uss['id'],'user_ip').'">'.user_inf2($uss['id'],'user_ip').'</a> | Soft: '.user_inf2($uss['id'],'user_soft').'';
echo '<dt></dt>';
echo 'Фоток в знакомствах: <b>'.mysql_result(query("select count(*) as num from users WHERE `sid` = '$a[sid]' and love_city!='0' and love_photo!=''"),0).'</b><br />';
echo 'Альбомов/Фото/Комментариев: <b>'.mysql_result(query("select count(*) as num from foto_albom WHERE `sid` = '$a[sid]'"),0).'/'.mysql_result(query("select count(*) as num from foto_add WHERE `sid` = '$a[sid]'"),0).'/'.mysql_result(query("select count(*) as num from foto_komm WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Фото в галерее: <b>'.mysql_result(query("select count(*) as num from users WHERE `sid` = '$a[sid]' and photo !=''"),0).'</b><br/>';
echo 'Файлообменник: <b>'.mysql_result(query("select count(*) as num from fo_files WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Видео в анкетах: <b>'.mysql_result(query("select count(*) as num from video WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Музыки в анкетах: <b>'.mysql_result(query("select count(*) as num from audio WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo '<dt></dt>';
echo 'Комнат: <b>'.mysql_result(query("SELECT COUNT(*) FROM `rooms` WHERE `sid` = '$a[sid]'"),0).'</b><br />';
echo "Сообщений в чате: <b>".mysql_result(query("select COUNT(*) from message where `sid` = '$a[sid]';"),0)."</b><br/>";
echo "Сообщений в форуме: <b>".mysql_result(query("SELECT count(*) FROM `forum_msg` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Тем в форуме: <b>".mysql_result(query("SELECT count(*) FROM `forum_t` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Разделов: <b>".mysql_result(query("SELECT count(*) FROM `forum_r` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Форумов: <b>".mysql_result(query("SELECT count(*) FROM `forum_f` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Записок в базе: <b>".mysql_result(query("SELECT count(*) FROM `privat` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Новостей: <b>".mysql_result(query("SELECT count(*) FROM `news` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Конкурсов: <b>".mysql_result(query("SELECT count(*) FROM `konkurs` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Акций: <b>".mysql_result(query("SELECT count(*) FROM `akcyi` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Встречь: <b>".mysql_result(query("SELECT count(*) FROM `vstr` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Объявлений: <b>".mysql_result(query("SELECT count(*) FROM `objavs` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo "Свадеб: <b>".mysql_result(query("SELECT count(*) FROM `zags` where `sid` = '$a[sid]';"), 0)."</b><br/>";
echo 'Групп: <b>'.mysql_result(query("select count(*) as num from groups WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Дневников: <b>'.mysql_result(query("select count(*) as num from diaries WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
/////////////////////
echo 'Сообщений на стене: <b>'.mysql_result(query("select count(*) as num from stena WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Изображений на стене: <b>'.mysql_result(query("select count(*) as num from stena WHERE `sid` = '$a[sid]' and `img` != ''"),0).'</b><br/>';
//
echo 'Людей в игноре: <b>'.mysql_result(query("select count(*) as num from ignor WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Друзей: <b>'.mysql_result(query("select count(*) as num from friends WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Голосов за фото: <b>'.mysql_result(query("select count(*) as num from vote_photo WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Комментариев к фото: <b>'.mysql_result(query("select count(*) as num from komm_photo WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Голосов за юзеров: <b>'.mysql_result(query("select count(*) as num from vote_us WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Мнений о юзерах: <b>'.mysql_result(query("select count(*) as num from opinions WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Подарков: <b>'.mysql_result(query("select count(*) as num from opinions WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Переводов в банке: <b>'.mysql_result(query("select count(*) as num from perevod WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
echo 'Голосований/Голосов: <b>'.mysql_result(query("select count(*) as num from votes WHERE `sid` = '$a[sid]'"),0).'/'.mysql_result(query("select count(*) as num from voting WHERE `sid` = '$a[sid]'"),0).'</b><br/>';
break;
case 'sbanners':
if (empty($act)){
if (isset($_GET['delk'])){
if($user[level]>=5){
query("DELETE FROM `sbanners` WHERE `id` = '".check(intval($_GET['delk']))."'");
}
header ('Location: ?mod='.$mod.'&'.SID);
}
echo '<a href="?mod='.$mod.'&act=add">Добавить</a><dt></dt>';
$max = $user['max'];
$k_post=mysql_result(query("select count(*) as num from sbanners"),0);
$k_page=k_page($k_post,$max);
$page=page($k_page);
$start=$max*$page-$max;
$r = query ("Select * from sbanners order by id LIMIT $start, $max");
if ($k_post == 0)echo 'Ссылок и беннеров нет<br />';
$post_k=$start+1;
while($a = @mysql_fetch_assoc($r)){
if($a['gde']==1)$gde = 'Только на главной';
else if($a['gde']==2)$gde = 'На главной и в Прихожей';
else if($a['gde']==3)$gde = 'На всех страницах';
if($a['v_n']==1)$v_n = 'Внизу страници';
else if($a['v_n']==2)$v_n = 'Вверху страници';
if($a['tip']==1){echo links.'Ссылка: <b>'.$a['link_name'].'</b> <a href="?mod='.$mod.'&delk='.$a[id].'">[Удал]</a>|<a href="?mod='.$mod.'&act=edit&link='.$a[id].'">[Изм]</a>'.div;
echo 'Адрес: '.$a['link'].'<b>|</b>'.$gde.'<b>|</b>'.$v_n.'';
}else if($a['tip']==2){ echo links.'<b>Баннер </b><a href="?mod='.$mod.'&delk='.$a[id].'">[Удал]</a>|<a href="?mod='.$mod.'&act=edit&link='.$a[id].'">[Изм]</a>'.div;
echo 'Адрес: '.$a['link'].'<b>|</b>Адрес картинки: '.$a['link_name'].'<b>|</b>'.$gde.'<b>|</b>'.$v_n.'';
}
echo '<dl></dl>';
}
if ($k_page>1){
echo "<dl><dt></dt></dl>";
str('?mod='.$mod.'&',$k_page,$page); // Вывод страниц
echo "<br /><dl><dt></dt></dl><br />";
}
}else if($act=='add'){
if ($ver!='wml'){echo '<form action="?mod='.$mod.'&act=addi&'.SID.'" method="post">';
echo'Ссылка: (с http://)<br /><textarea cols="'.$user['pole2'].'" rows="'.$user['pole1'].'" name="link" ></textarea><br />';
echo'Название ссылки или адрес картинки баннера: (с http://)<br /><textarea cols="'.$user['pole2'].'" rows="'.$user['pole1'].'" name="link_name" ></textarea><br />';
echo 'Тип:<br/>
<select name="tip">';
echo '<option value="1">Ссылка</option>
<option value="2">Баннер</option>
</select><br/>';
echo 'Где показывать:<br/>
<select name="gde">';
echo '<option value="1">Только на главной</option>
<option value="2">На главной и в Прихожей</option>
<option value="3">На всех страницах</option>
</select><br/><br />
<select name="v_n">';
echo '<option value="1">Внизу страници</option>
<option value="2">Вверху страници</option>
</select><br/>';
echo '<br /><input type="submit" class="ibutton" value="Добавить"/></form><br /><br />';
}else{
echo 'Ссылка: (с http://)<br /><input name="link'.$ref.'" title="Ссылка"/><br/>';
echo 'Название ссылки или адрес картинки баннера: (с http://)<br /><input name="link_name'.$ref.'" title="Название"/><br/>';
echo 'Тип:<br/>
<select name="tip">';
echo '<option value="1">Ссылка</option>
<option value="2">Баннер</option>
</select><br/>';
echo 'Где показывать:<br/>
<select name="gde">';
echo '<option value="1">Только на главной</option>
<option value="2">На главной и в Прихожей</option>
<option value="3">На всех страницах</option>
</select><br/>
<select name="v_n">';
echo '<option value="1">Внизу страници</option>
<option value="2">Вверху страници</option>
</select><br/>';
echo '<br /><anchor title="go">Добавить<go href="?mod='.$mod.'&act=addi&'.SID.'" method="post">';
echo '<postfield name="link" value="$link'.$ref.'"/>
<postfield name="link_name" value="$link_name'.$ref.'"/>
<postfield name="tip" value="$tip'.$ref.'"/>
<postfield name="gde" value="$gde'.$ref.'"/>
<postfield name="v_n" value="$v_n'.$ref.'"/>
</go></anchor><br/>';
}
}else if($act=='addi'){
$link = check($_POST['link']);
$link_name = check($_POST['link_name']);
$tip= check(intval($_POST['tip']));
$gde= check(intval($_POST['gde']));
$v_n= check(intval($_POST['v_n']));
if (query ("INSERT INTO sbanners (link,link_name,tip,gde,v_n) VALUES ('$link','$link_name','$tip','$gde','$v_n')")){header ('Location: ?mod='.$mod.'&'.SID); exit;
}else echo 'Ошибка!<br />';
}else if($act=='edit'){ // Изменение
$link = check(intval($_GET['link']));
$a = @mysql_fetch_assoc(query ("Select * from sbanners WHERE id = '".$link."'"));
if ($ver!='wml'){echo '<form action="?mod='.$mod.'&link='.$link.'&act=editi&'.SID.'" method="post">';
echo'Ссылка: (с http://)<br /><textarea cols="'.$user['pole2'].'" rows="'.$user['pole1'].'" name="link2" >'.$a['link'].'</textarea><br />';
echo'Название ссылки или адрес картинки баннера: (с http://)<br /><textarea cols="'.$user['pole2'].'" rows="'.$user['pole1'].'" name="link_name" >'.$a['link_name'].'</textarea><br />';
echo 'Тип:<br/>
<select name="tip">';
echo '<option value="1">Ссылка</option>
<option value="2">Баннер</option>
</select><br/>';
echo 'Где показывать:<br/>
<select name="gde">';
echo '<option value="1">Только на главной</option>
<option value="2">На главной и в Прихожей</option>
<option value="3">На всех страницах</option>
</select><br/><br />
<select name="v_n">';
echo '<option value="1">Внизу страници</option>
<option value="2">Вверху страници</option>
</select><br/>';
echo '<br /><input type="submit" class="ibutton" value="Добавить"/></form><br /><br />';
}else{
echo 'Ссылка: (с http://)<br /><input name="link2'.$ref.'" value="'.$a['link'].'" title="Ссылка"/><br/>';
echo 'Название ссылки или адрес картинки баннера: (с http://)<br /><input name="link_name'.$ref.'" value="'.$a['link_name'].'" title="Название"/><br/>';
echo 'Тип:<br/>
<select name="tip">';
echo '<option value="1">Ссылка</option>
<option value="2">Баннер</option>
</select><br/>';
echo 'Где показывать:<br/>
<select name="gde">';
echo '<option value="1">Только на главной</option>
<option value="2">На главной и в Прихожей</option>
<option value="3">На всех страницах</option>
</select><br/>
<select name="v_n">';
echo '<option value="1">Внизу страници</option>
<option value="2">Вверху страници</option>
</select><br/>';
echo '<br /><anchor title="go">Добавить<go href="?mod='.$mod.'&act=addi&'.SID.'" method="post">';
echo '<postfield name="link2" value="$link2'.$ref.'"/>
<postfield name="link_name" value="$link_name'.$ref.'"/>
<postfield name="tip" value="$tip'.$ref.'"/>
<postfield name="gde" value="$gde'.$ref.'"/>
<postfield name="v_n" value="$v_n'.$ref.'"/>
</go></anchor><br/>';
}
}else if($act==editi){
$link = check(intval($_GET['link']));
$link2 = check($_POST['link2']);
$link_name = check($_POST['link_name']);
$tip= check(intval($_POST['tip']));
$gde= check(intval($_POST['gde']));
$v_n= check(intval($_POST['v_n']));
if (query("UPDATE `sbanners` SET `link` = '$link2', `link_name` = '$link_name', `tip` = '$tip', `gde` = '$gde', `v_n` = '$v_n' WHERE `id` = '".$link."'")){header ('Location: ?mod='.$mod.'&'.SID); exit;
}else echo 'Ошибка!<br />';
}
break;
case 'delete':
$id_chat = isset ($_REQUEST['id_chat']) ? abs(intval(check($_REQUEST['id_chat']))) : false;
if (empty($act)){
echo 'Вы уверены что хотите <b>безвозвратно</b> удалить чат <b>'.$id_chat.'</b>?';
echo gbinroom.'<a href="?mod=delete&id_chat='.$id_chat.'&act=del">Да</a> | <a href="?">НЕТ</a>'.div;
}else{
$r = query ("Select * from users WHERE `sid` = '$id_chat' and photo != '' ");
while($a = mysql_fetch_assoc($r)){
///Удаление фото из анкеты///////////////////
unlink (H.$a['photo'].''); //
/////////////////////////////////////////////
}
$r = query ("Select * from users WHERE `sid` = '$id_chat' and love_photo != '' ");
while($a = mysql_fetch_assoc($r)){
///Удаление фото из анкеты знакомств///////////////////
unlink (H.$a['love_photo'].''); //
/////////////////////////////////////////////
}
///Удаление альбомов//////////////////////////////////////////////////////////////////
query("delete from `foto_albom` WHERE `sid` = '$id_chat';");
$q = query("SELECT * FROM `foto_add` WHERE `sid` = '$id_chat';");
while($d = mysql_fetch_assoc($q)){
$flag = unlink (H.'files/album/album_'.$d[album].'_'.$d[id].$d[format]);}
query("delete from `foto_add` WHERE `sid` = '$id_chat';");
/////////////////////////////////////////////////////////////////////////////////////////
///Удаление музыки//////////////////////////////////////////////////////////////////
$q = query("SELECT * FROM `audio` WHERE `sid` = '$id_chat';");
while($d = mysql_fetch_assoc($q)){
unlink (H."files/audio/".$d['adres']."");}
query("delete from `audio` WHERE `sid` = '$id_chat';");
/////////////////////////////////////////////////////////////////////////////////////////
///Удаление видео//////////////////////////////////////////////////////////////////
$q = query("SELECT * FROM `video` WHERE `sid` = '$id_chat';");
while($d = mysql_fetch_assoc($q)){
unlink (H."files/video/".$d['adres']."");}
query("delete from `video` WHERE `sid` = '$id_chat';");
/////////////////////////////////////////////////////////////////////////////////////////
///Удаление файлов форума/////////////////////////////////////////////////////////////////
$q = query("SELECT * FROM `forum_msg` WHERE `sid` = '$id_chat' and file != '';");
while($d = mysql_fetch_assoc($q)){
unlink (H.'files/forum/'.$d['file'].'');
}
query("delete from `forum_msg` WHERE `sid` = '$id_chat';");
query("delete from `forum_b` WHERE `sid` = '$id_chat';");
query("delete from `forum_f` WHERE `sid` = '$id_chat';");
query("delete from `forum_r` WHERE `sid` = '$id_chat';");
query("delete from `forum_s` WHERE `sid` = '$id_chat';");
query("delete from `forum_t` WHERE `sid` = '$id_chat';");
/////////////////////////////////////////////////////////////////////////////////////////
///Удаление файлов обмена/////////////////////////////////////////////////////////////////
$q = query("SELECT * FROM `fo_files` WHERE `sid` = '$id_chat';");
while($d = mysql_fetch_assoc($q)){
unlink (H.'fo/'.$d['path'].'');
}
query("delete from `fo_files` WHERE `sid` = '$id_chat';");
/////////////////////////////////////////////////////////////////////////////////////////
///Удаление 2cat обмена/////////////////////////////////////////////////////////////////
$q = query("SELECT * FROM `fo_cat2` WHERE `sid` = '$id_chat';");
while($d = mysql_fetch_assoc($q)){
rmdir (H.'fo/'.$d['path'].'');
}
query("delete from `fo_cat2` WHERE `sid` = '$id_chat';");
/////////////////////////////////////////////////////////////////////////////////////////
///Удаление 1cat обмена/////////////////////////////////////////////////////////////////
$q = query("SELECT * FROM `fo_cat` WHERE `sid` = '$id_chat';");
while($d = mysql_fetch_assoc($q)){
rmdir (H.'fo/'.$d['path'].'');
}
query("delete from `fo_cat` WHERE `sid` = '$id_chat';");
query("delete from `fo_komm` WHERE `sid` = '$id_chat';");
/////////////////////////////////////////////////////////////////////////////////////////
///Удаление лого групп/////////////////////////////////////////////////////////////////
$q = query("SELECT * FROM `groups` WHERE `sid` = '$id_chat' and logo != '';");
while($d = mysql_fetch_assoc($q)){
unlink (H.''.$d['logo'].'');
}
query("delete from `groups` WHERE `sid` = '$id_chat';");
query("delete from `group_chat` WHERE `sid` = '$id_chat';");
query("delete from `group_news` WHERE `sid` = '$id_chat';");
query("delete from `group_newskom` WHERE `sid` = '$id_chat';");
query("delete from `group_users` WHERE `sid` = '$id_chat';");
/////////////////////////////////////////////////////////////////////////////////////////
///Удаление избр. стены/////////////////////////////////////////////////////////////////
$q = query("SELECT * FROM `stena` WHERE `sid` = '$id_chat' and img != '';");
while($d = mysql_fetch_assoc($q)){
unlink (H.'files/stena/'.$d['img']);
}
/////////////////////////////////////////////////////////////////////////////////////////
///Удаление лого чата/////////////////////////////////////////////////////////////////
$q = query("SELECT * FROM `chats` WHERE `sid` = '$id_chat' and logo != '' or logo != 'files/logo/1.gif'' ;");
while($d = mysql_fetch_assoc($q)){
unlink (H.$d['logo']);
}
/////////////////////////////////////////////////////////////////////////////////////////
/// Прочее ///////////////////////////////////////////////////////////////
query("delete from `online` WHERE `sid` = '$id_chat';");
query("delete from `votes` WHERE `sid` = '$id_chat';");
query("delete from `voting` WHERE `sid` = '$id_chat';");
query("delete from `fermer_gr` WHERE `sid` = '$id_chat';");
query("delete from `fermer_dog` WHERE `sid` = '$id_chat';");
query("delete from `fermer_vor` WHERE `sid` = '$id_chat';");
query("delete from `fermer_sclad` WHERE `sid` = '$id_chat';");
query("delete from `fermer_semen` WHERE `sid` = '$id_chat';");
query("delete from `fermer_udobr` WHERE `sid` = '$id_chat';");
query("delete from `fermer_udobr_name` WHERE `sid` = '$id_chat';");
query("delete from `fermer_name` WHERE `sid` = '$id_chat';");
query("delete from `zags` WHERE `sid` = '$id_chat';");
query("delete from `banners` WHERE `sid` = '$id_chat';");
query("delete from `akcyi` WHERE `sid` = '$id_chat';");
query("delete from `audio_komm` WHERE `sid` = '$id_chat';");
query("delete from `bannip` WHERE `sid` = '$id_chat';");
query("delete from `bannlist` WHERE `sid` = '$id_chat';");
query("delete from `board` WHERE `sid` = '$id_chat';");
query("delete from `botst` WHERE `sid` = '$id_chat';");
query("delete from `diaries` WHERE `sid` = '$id_chat';");
query("delete from `diaskomm` WHERE `sid` = '$id_chat';");
query("delete from `gifts` WHERE `sid` = '$id_chat';");
query("delete from `konkurs` WHERE `sid` = '$id_chat';");
query("delete from `levels` WHERE `sid` = '$id_chat';");
query("delete from `logs` WHERE `sid` = '$id_chat';");
query("delete from `news` WHERE `sid` = '$id_chat';");
query("delete from `newskom` WHERE `sid` = '$id_chat';");
query("delete from `objavs` WHERE `sid` = '$id_chat';");
query("delete from `oko` WHERE `sid` = '$id_chat';");
query("delete from `omessage` WHERE `sid` = '$id_chat';");
query("delete from `rooms` WHERE `sid` = '$id_chat';");
query("delete from `video_komm` WHERE `sid` = '$id_chat';");
query("delete from `vopros` WHERE `sid` = '$id_chat';");
query("delete from `vopros2` WHERE `sid` = '$id_chat';");
query("delete from `vote_diaries` WHERE `sid` = '$id_chat';");
query("delete from `vstr` WHERE `sid` = '$id_chat';");
query("delete from `xstatus` WHERE `sid` = '$id_chat';");
query("delete from `vote_us` WHERE `sid` = '$id_chat';");
query("delete from `vote_photo` WHERE `sid` = '$id_chat';");
query("delete from `stena` WHERE `sid` = '$id_chat';");
query("delete from `questions` WHERE `sid` = '$id_chat';");
query("delete from `privat` WHERE `sid` = '$id_chat';");
query("delete from `support` WHERE `sid` = '$id_chat';");
query("delete from `perevod` WHERE `sid` = '$id_chat';");
query("delete from `opinions` WHERE `sid` = '$id_chat';");
query("delete from `message` WHERE `sid` = '$id_chat';");
query("delete from `komm_photo` WHERE `sid` = '$id_chat';");
query("delete from `ignor` WHERE `sid` = '$id_chat';");
query("delete from `friends` WHERE `sid` = '$id_chat';");
query("delete from `foto_komm` WHERE `sid` = '$id_chat';");
query("delete from `who` WHERE `sid` = '$id_chat';");
///////////////////////////////////////////////////////////////////////////
query("delete from users WHERE `sid` = '$id_chat';");
query("delete from chats WHERE `sid` = '$id_chat';");
echo 'Чат <b>'.$id_chat.'</b> удален!';
}
break;
case 'mysql':
echo "<b>Выполнить MySQL запрос</b><br />n";
if (isset($_GET['set']) && $_GET['set']=='set' && isset($_POST['qwerty']))
{
$sql=trim(str_replace("'","'",$_POST['qwerty']));
$sql=explode(";",$sql);
$k_z=0; $k_z_ok=0;
for ($i=0;$i<count($sql);$i++)
{
if ($sql[$i]!=''){
$k_z++;
if(query($sql[$i]))
{
$k_z_ok++;
}
}
}
if ($k_z_ok>0)
{
if ($k_z_ok==1 && $k_z=1)
echo "<span style="color:red"><b>Запрос выполнен</b></span><br />";
else
echo "<span style="color:red"><b>Выполнено $k_z_ok запросов из $k_z</b></span><br />";
}
elseif($k_z>0 && $k_z_ok==0)
echo "<span style="color:red"><b>Ошибка выполнения запроса</b></span><br />";
}
echo "<form method="post" action="?mod=$mod&set=set">n";
echo "<textarea name="qwerty" class="form" cols="".$user['pole2']."" rows="".$user['pole1'].""></textarea><br />n";
echo "<input value="Выполнить" class="form" type="submit" />n";
echo "</form>n";
break;
case 'barmen':
echo '» <a href="?mod=bar_cat">Категории</a><br />
» <a href="?mod=bar_t">Управление товарами</a><br />';
break;
case 'bar_cat':
if (empty($act)){
if (isset($_GET['delk'])){
if($user[level]>=5){
query("DELETE FROM `bar_cat` WHERE `id` = '".check(intval($_GET['delk']))."'");
query("DELETE FROM `barmen` `cat` = '".check(intval($_GET['delk']))."'");
}
header ('Location: ?mod='.$mod.'&'.SID);
}
echo '<a href="?mod='.$mod.'&act=add">Добавить категорию</a><dt></dt>';
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(query("select count(*) as num from bar_cat"),0);
$k_page=k_page($k_post,$max);
$page=page($k_page);
$start=$max*$page-$max;
$r = query ("Select * from bar_cat order by pos LIMIT $start, $max");
if ($k_post == 0)echo 'Категорий нет<br />';
$post_k=$start+1;
while($a = mysql_fetch_assoc($r)){
$c = mysql_result(query("select count(*) from `barmen` where `cat`='".$a['id']."'"),0);
echo links.'<b>'.$a['name'].'</b> ('.$c.') <a href="?mod='.$mod.'&delk='.$a[id].'">[Удал]</a>|<a href="?mod='.$mod.'&act=edit&cat='.$a[id].'">[Изм]</a>'.div;
echo '<dl></dl>';
}
if ($k_page>1){
echo "<dl><dt></dt></dl>";
str('?mod='.$mod.'&',$k_page,$page); // Вывод страниц
echo "<br /><dl><dt></dt></dl><br />";
}
}else if($act=='add'){
if ($ver!='wml'){echo '<form action="?mod='.$mod.'&act=addi&'.SID.'" method="post">';
echo 'Категория:<br /><input name="name" title="Категория"/><br/>';
echo 'Положение:<br /><input name="pos" title="Категория"/><br/>';
echo '<br /><input type="submit" class="ibutton" value="Добавить"/></form><br /><br />';
}else{
echo 'Категория:<br /><input name="name'.$ref.'" title="Категория"/><br/>';
echo 'Положение:<br /><input name="pos" title="Категория"/><br/>';
echo '<br /><anchor title="go">Добавить<go href="?mod='.$mod.'&act=addi&'.SID.'" method="post">';
echo '<postfield name="pos" value="$pos'.$ref.'"/>
<postfield name="msg" value="$msg'.$ref.'"/></go></anchor><br/>';
}
}else if($act=='addi'){
$name = check($_POST['name']);
$pos = check($_POST['pos']);
if (query ("INSERT INTO bar_cat (name,pos,img) VALUES ('$name','$pos','')")){header ('Location: ?mod='.$mod.'&'.SID); exit;
}else echo 'Ошибка!<br />';
}else if($act=='edit'){ // Изменение
$cat = check(intval($_GET['cat']));
$a = mysql_fetch_assoc(query ("Select * from bar_cat WHERE id = '".$cat."'"));
if ($ver!='wml'){echo '<form action="?mod='.$mod.'&cat='.$cat.'&act=editi&'.SID.'" method="post">';
echo 'Категория:<br /><input name="name" value="'.$a['name'].'" title="Категория"/><br/>';
echo 'Положение:<br /><input name="pos" value="'.$a['pos'].'" title="Категория"/><br/>';
echo '<br /><input type="submit" class="ibutton" value="Изменить"/></form><br /><br />';
}else{
echo 'Категория:<br /><input name="name'.$ref.'" value="'.$a['name'].'" title="Категория"/><br/>';
echo 'Положение:<br /><input name="pos" value="'.$a['pos'].'" title="Категория"/><br/>';
echo '<br /><anchor title="go">Изменить<go href="?mod='.$mod.'&cat='.$cat.'&act=addi&'.SID.'" method="post">';
echo '<postfield name="pos" value="$pos'.$ref.'"/>
<postfield name="msg" value="$msg'.$ref.'"/></go></anchor><br/>';
}
}else if($act==editi){
$cat = check(intval($_GET['cat']));
$name = check($_POST['name']);
$pos = check($_POST['pos']);
if (query("UPDATE `bar_cat` SET `name` = '$name', `pos` = '$pos' WHERE `id` = '".$cat."'")){header ('Location: ?mod='.$mod.'&'.SID); exit;
}else echo 'Ошибка!<br />';
}
break;
case 'bar_t':
$cat = check(intval($_GET['cat']));
if (empty($act)){
echo '<br />';
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(query("select count(*) as num from bar_cat"),0);
$k_page=k_page($k_post,$max);
$page=page($k_page);
$start=$max*$page-$max;
$r = query ("Select * from bar_cat order by pos LIMIT $start, $max");
if ($k_post == 0)echo 'Категорий нет<br />';
$post_k=$start+1;
while($a = mysql_fetch_assoc($r)){
$c = mysql_result(query("select count(*) from `barmen` where `cat`='".$a['id']."'"),0);
echo links.'<a href="?mod='.$mod.'&act=cat&cat='.$a['id'].'"><b>'.$a['name'].'</b></a> ('.$c.')'.div;
echo '<dl></dl>';
}
if ($k_page>1){
echo "<dl><dt></dt></dl>";
str('?mod='.$mod.'&',$k_page,$page); // Вывод страниц
echo "<br /><dl><dt></dt></dl><br />";
}
}else if($act=='cat'){
$cat = check(intval($_GET['cat']));
if (isset($_GET['delk'])){
if($user[level]>=5){
query("DELETE FROM `barmen` WHERE `id` = '".check(intval($_GET['delk']))."'");
}
header ('Location: ?mod='.$mod.'&act=cat&cat='.$cat.'&'.SID);
}
echo '<a href="?mod='.$mod.'&act=add&cat='.$cat.'">Добавить</a><dt></dt>';
if (empty($user['max'])) $user['max']=10;
$max = $user['max'];
$k_post=mysql_result(query("select count(*) as num from barmen WHERE `cat` = '$cat'"),0);
$k_page=k_page($k_post,$max);
$page=page($k_page);
$start=$max*$page-$max;
$r = query ("Select * from barmen WHERE `cat` = '$cat' order by id LIMIT $start, $max");
if ($k_post == 0)echo 'Ничего нет<br />';
$post_k=$start+1;
while($a = mysql_fetch_assoc($r)){
echo links.'<img src="/bots/barmen/'.$a['img'].'" alt=""><b>'.$a['name'].'</b>|'.$a['proc'].'%|'.($a['time']).' мин|'.$a['cena'].'пост|<a href="?mod='.$mod.'&act=cat&cat='.$cat.'&delk='.$a[id].'">[Удал]</a>|<a href="?mod='.$mod.'&act=edit&cat='.$cat.'&bar='.$a[id].'">[Изм]</a>'.div;
echo '<dl></dl>';
}
if ($k_page>1){
echo "<dl><dt></dt></dl>";
str('?mod='.$mod.'&act=cat&cat='.$cat.'&',$k_page,$page); // Вывод страниц
echo "<br /><dl><dt></dt></dl><br />";
}
}else if($act=='add'){
if ($ver!='wml'){echo '<form action="?mod='.$mod.'&cat='.$cat.'&act=addi&'.SID.'" method="post">';
echo 'Название:<br /><input name="name" value="'.$a['name'].'" title="Название"/><br/>';
echo 'Картинка:<br /><input name="img" value="'.$a['img'].'" title="Картинка"/><br/>';
echo 'Сообщение:<br /><input name="msg" value="'.$a['msg'].'" title="Сообщение"/><br/>';
echo 'Цена:<br /><input name="cena" value="'.$a['cena'].'" title="Цена"/><br/>';
echo 'Проценты:<br /><input name="proc" value="'.$a['proc'].'" title="Проценты"/><br/>';
echo 'Время:<br /><input name="times" value="'.$a['time'].'" title="Время"/><br/>
<br /><input type="submit" class="ibutton" value="Добавить"/></form><br /><br />';
}else{
echo 'Название:<br /><input name="name" value="'.$a['name'].'" title="Название"/><br/>';
echo 'Картинка:<br /><input name="img" value="'.$a['img'].'" title="Картинка"/><br/>';
echo 'Сообщение:<br /><input name="msg" value="'.$a['msg'].'" title="Сообщение"/><br/>';
echo 'Цена:<br /><input name="cena" value="'.$a['cena'].'" title="Цена"/><br/>';
echo 'Проценты:<br /><input name="proc" value="'.$a['proc'].'" title="Проценты"/><br/>';
echo 'Время:<br /><input name="times" value="'.$a['time'].'" title="Время"/><br/>
<br /><anchor title="go">Добавить<go href="?mod='.$mod.'&cat='.$cat.'&act=addi&'.SID.'" method="post">';
echo '
<postfield name="name" value="$name'.$ref.'"/>
<postfield name="img" value="$img'.$ref.'"/>
<postfield name="msg" value="$msg'.$ref.'"/>
<postfield name="cena" value="$cena'.$ref.'"/>
<postfield name="proc" value="$proc'.$ref.'"/>
<postfield name="times" value="$times'.$ref.'"/>
</go></anchor><br/>';
}
}else if($act==addi){
$cat = check(intval($_GET['cat']));
$name = check($_POST['name']);
$img = check($_POST['img']);
$msg = check($_POST['msg']);
$cena = check($_POST['cena']);
$proc = check($_POST['proc']);
$times = check($_POST['times']);
if (query ("INSERT INTO barmen (cat,name,msg,img,cena,proc,time) VALUES ('$cat','$name','$msg','$img','$cena','$proc','$times')")){header ('Location: ?mod='.$mod.'&act=cat&cat='.$cat.'&'.SID); exit;
}else echo 'Ошибка!<br />';
}else if($act=='edit'){ // Изменение
$bar = check(intval($_GET['bar']));
$a = mysql_fetch_assoc(query ("Select * from barmen WHERE id = '".$bar."'"));
if ($ver!='wml'){echo '<form action="?mod='.$mod.'&cat='.$cat.'&bar='.$bar.'&act=editi&'.SID.'" method="post">';
echo 'Название:<br /><input name="name" value="'.$a['name'].'" title="Название"/><br/>';
echo 'Картинка:<br /><input name="img" value="'.$a['img'].'" title="Картинка"/><br/>';
echo 'Сообщение:<br /><input name="msg" value="'.$a['msg'].'" title="Сообщение"/><br/>';
echo 'Цена:<br /><input name="cena" value="'.$a['cena'].'" title="Цена"/><br/>';
echo 'Проценты:<br /><input name="proc" value="'.$a['proc'].'" title="Проценты"/><br/>';
echo 'Время:<br /><input name="times" value="'.$a['time'].'" title="Время"/><br/>
<br /><input type="submit" class="ibutton" value="Изменить"/></form><br /><br />';
}else{
echo 'Название:<br /><input name="name" value="'.$a['name'].'" title="Название"/><br/>';
echo 'Картинка:<br /><input name="img" value="'.$a['img'].'" title="Картинка"/><br/>';
echo 'Сообщение:<br /><input name="msg" value="'.$a['msg'].'" title="Сообщение"/><br/>';
echo 'Цена:<br /><input name="cena" value="'.$a['cena'].'" title="Цена"/><br/>';
echo 'Проценты:<br /><input name="proc" value="'.$a['proc'].'" title="Проценты"/><br/>';
echo 'Время:<br /><input name="times" value="'.$a['time'].'" title="Время"/><br/>
<br /><anchor title="go">Изменить<go href="?mod='.$mod.'&cat='.$cat.'&bar='.$bar.'&act=editi&'.SID.'" method="post">';
echo '
<postfield name="name" value="$name'.$ref.'"/>
<postfield name="img" value="$img'.$ref.'"/>
<postfield name="msg" value="$msg'.$ref.'"/>
<postfield name="cena" value="$cena'.$ref.'"/>
<postfield name="proc" value="$proc'.$ref.'"/>
<postfield name="times" value="$times'.$ref.'"/>
</go></anchor><br/>';
}
}else if($act==editi){
$bar = check(intval($_GET['bar']));
$name = check($_POST['name']);
$img = check($_POST['img']);
$msg = check($_POST['msg']);
$cena = check($_POST['cena']);
$proc = check($_POST['proc']);
$times = check($_POST['times']);
$cats = check($_POST['cats']);
if (query("UPDATE `barmen` SET `name` = '$name', `img` = '$img', `msg` = '$msg', `cena` = '$cena', `proc` = '$proc', `time` = '$times', `cat` = '$cat' WHERE `id` = '".$bar."'")){header ('Location: ?mod='.$mod.'&act=cat&cat='.$cat.'&'.SID); exit;
}else echo 'Ошибка!<br />';
}
break;
case 'mysql':
echo "<b>Выполнить MySQL запрос</b><br />n";
if (isset($_GET['set']) && $_GET['set']=='set' && isset($_POST['qwerty']))
{
$sql=trim(str_replace("'","'",$_POST['qwerty']));
$sql=explode(";",$sql);
$k_z=0; $k_z_ok=0;
for ($i=0;$i<count($sql);$i++)
{
if ($sql[$i]!=''){
$k_z++;
if(query($sql[$i]))
{
$k_z_ok++;
}
}
}
if ($k_z_ok>0)
{
if ($k_z_ok==1 && $k_z=1)
echo "<span style="color:red"><b>Запрос выполнен</b></span><br />";
else
echo "<span style="color:red"><b>Выполнено $k_z_ok запросов из $k_z</b></span><br />";
}
elseif($k_z>0 && $k_z_ok==0)
echo "<span style="color:red"><b>Ошибка выполнения запроса</b></span><br />";
}
echo "<form method="post" action="?go=$go&set=set">n";
echo "<textarea name="qwerty" class="form" cols="".$user['pole2']."" rows="".$user['pole1'].""></textarea><br />n";
echo "<input value="Выполнить" class="form" type="submit" />n";
echo "</form>n";
break;
}
echo '<br />';
if ($mod)echo gb.'<a href="?">Админка</a>'.div;
echo gb.'<a href="index">В админку</a><br />'.div;
echo gb.'<a href="'.H.'enter">Прихожая</a>'.div;
foot();
?>