Файл: in4at/apanel.php
Строк: 1938
<?php
##################################################################################################
## Script name : In4at ##
## Version : Final ##
## Made by : XPYCT(Сергей Мищенко) ##
## E-mail : bce-ok@bk.ru ##
## ICQ : 447-50-50-62 ##
## Site : http://vkontakte.ru/id31604521 ##
## Внимание! Скрипт распространяется бесплатно! Модификация W4at by XPYCT ##
##################################################################################################
define('REQ_2_chat', true);
require('4at_set.php');
require('db_con.php');
require('style.php');
if($py!==spy_code) require('us_info.php');
require('func.php');
if($row['level']<7){
echo head;
if($vv!=0) echo '<div class="d0"><b>Ошибка</b></div>';
else echo '<card id="error" title="Ошибка"><p align="center">';
echo $fsize1;
echo '<b>У вас нет прав доступа!</b>';
echo $fsize2;
echo foot;
mysql_close($link);
exit;
}
$us=$row['user'];
$login=$row['user'];
if(isset($rm)) $rum='&rm='.$rm;
else $rum='';
$fi=fopen("syst/admlog.dat", "a+");
flock($fi,LOCK_EX);
$dat=date("d/m/y");
$vrem=date("H:i");
fwrite($fi, "$us ($dat $vrem) - ip: $REMOTE_ADDR, soft: $HTTP_USER_AGENTn");
fwrite($fi, "************n");
fflush($fi);
flock($fi,LOCK_UN);
fclose($fi);
$alltraf=$row['alltraf'];
$ql=mysql_query("select name from levels");
while($levarr=mysql_fetch_array($ql)){
$lev[]=$levarr['name'];}
$z=mysql_fetch_array(mysql_query("Select user from users where id='1' LIMIT 1;"));
$adm=$z['user'];
ob_start();
echo head;
if($vv!=0) echo '<div class="d0"><b>Aдмuнka</b></div>';
else echo '<card id="apanel" title="Aдмuнka"><p>';
echo $fsize1;
$time=date("H:i");
switch($go){
default:
echo '<b>'.$adm.'</b> ['.$time.']<br/>';
echo 'Привет, '.$us.'!<br/>';
echo divide;
echo 'Huk | id юзepa:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?go=user&$wp" method="post">";
echo "<input name="nick$ref" title="nick"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Искать"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Искать<go href="apanel.php?go=user&$wp" method="post">";
echo "<postfield name="nick" value="$(nick$ref)"/>";
echo '</go></anchor><br/>';
}
echo divide;
echo "<a href="apanel.php?$wp&go=forum">Форум</a><br/>";
echo "<a href="apanel.php?$wp&go=editrooms">Koмнaты</a><br/>";
echo "<a href="apanel.php?$wp&go=editlevels">Cтaтycы</a><br/>";
echo "<a href="apanel.php?$wp&go=bots">Бoты/настройка чата</a><br/>";
echo "<a href="apanel.php?$wp&go=reg">Рега/магазин</a><br/>";
echo divide;
echo "<a href="apanel.php?$wp&go=clear">Чucтka koмнaт</a><br/>";
echo "<a href="apanel.php?$wp&go=optimize">Oптuмuзaцuя</a><br/>";
if(($id==11)||($id==22)||($id==12)) {echo "<a href="apanel.php?$wp&go=clearus">Чucтka юзepoв</a><br/>";
echo "<a href="apanel.php?$wp&go=ipblock">Бан по IP</a><br/>n";
echo "<a href="apanel.php?$wp&go=clearzap">Чиcткa записок</a><br/>n";
echo "<a href="apanel.php?$wp&go=clearzapsv">Чиcткa сохраненых записок</a><br/>n";
}
echo divide;
echo "<a href="apanel.php?$wp&go=kick_view">Выпнутые</a><br/>";
echo "<a href="apanel.php?$wp&go=ign_view">Кто в игноре</a><br/>";
echo "<a href="apanel.php?$wp&go=unban">Paзбaнuть нuku</a><br/>";
echo "<a href="apanel.php?$wp&go=clbanip">Paзбaнuть ip+soft</a><br/>";
echo "<a href="apanel.php?$wp&go=blockip">Paзбaнuть ip</a><br/>";
echo divide;
echo "<a href="apanel.php?$wp&go=pdup">Разделы подарков</a><br/>";
echo "<a href="dpod.php?$wp">Добавить подарок</a><br/>";
echo "<a href="apanel.php?$wp&go=tell">Ckaзaть в чaт</a><br/>";
echo "<a href="apanel.php?$wp&go=mnews">Дoбaвuть нoвocть</a><br/>";
echo "<a href="apanel.php?$wp&go=dnews">Удaлuть нoвocть</a><br/>";
echo "<a href="apanel.php?$wp&go=mmeet">Дoбaвuть вcтpeчy</a><br/>";
echo "<a href="apanel.php?$wp&go=dmeet">Удaлuть вcтpeчy</a><br/>";
echo "<a href="apanel.php?$wp&go=mobi">Дoбaвuть Супер-oбъявлeнue</a><br/>";
echo "<a href="apanel.php?$wp&go=dobi">Удaлuть Супер-oбъявлeнue</a><br/>";
echo "<a href="apanel.php?$wp&go=mob">Дoбaвuть oбъявлeнue</a><br/>";
echo "<a href="apanel.php?$wp&go=dob">Удaлuть oбъявлeнue</a><br/>";
echo "<a href="apanel.php?$wp&go=mkonk">Дoбaвuть конкурс</a><br/>";
echo "<a href="apanel.php?$wp&go=dkonk">Удaлuть конкурс</a><br/>";
echo "<a href="apanel.php?$wp&go=mgaz">Дoбaвuть в газету</a><br/>";
echo "<a href="apanel.php?$wp&go=dgaz">Удaлuть из газеты</a><br/>";
echo "<a href="apanel.php?$wp&go=addanek">Дoбaвuть aнekдoт</a><br/>";
echo "<a href="apanel.php?$wp&go=addvopr">Дoбaвuть вoпpoc</a><br/>";
echo divide;
echo "<a href="apanel.php?$wp&go=logs">Жypнaл</a><br/>";
if(($id==11)||($id==22)||($id==12)){
echo "<a href="apanel.php?$wp&go=spam">Paccылka писем</a><br/>";
echo "<a href="apanel.php?$wp&go=submail">Email-Paccылka</a><br/>";
if(($id==11)||($id==22)){echo "<a href="apanel.php?$wp&go=zapiski">Чтение записок</a><br/>";
echo "<a href="apanel.php?$wp&go=oproom">Восстановить комнаты</a><br/>";
echo "<a href="apanel.php?$wp&go=darenda">Аренда</a><br/>";
}
echo "<a href="apanel.php?$wp&go=priz">Подарки</a><br/>";
echo "<a href="apanel.php?$wp&go=link">Ссылки</a><br/>";
}
break;
case 'ipblock':
if(empty($action)){
echo 'IP подсудимого:<br/><i>Пример: 127.0.0.1 без отступов и пробелов<br/>
Или по маске 127.0.0, 127.0, будут забанены все IP совпадающие по начальным цифрам</i><br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=ipblock&action=add" method="post">";
echo "<input name="ban$ref"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=ipblock&action=add" method="post">";
echo "<postfield name="ban" value="$(ban$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
mysql_query("INSERT INTO badip SET ip = '".$ban."'");
echo '<b>'.$ban.' Забанен!</b><br/>';
}
break;
case 'addpd':
if(empty($action)){
echo 'Название раздела:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=addpd&action=add" method="post">";
echo "<input name="title$ref"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=addpd&action=add" method="post">";
echo "<postfield name="title" value="$(title$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
$title=check($title);
if($row['translit']==1) $title=trun_to_rus($title);
mysql_query("insert into raz_pod values(0,'$title');");
echo '<b>Раздел добавлен!</b><br/>';
}
break;
case 'efpd':
$set=mysql_fetch_array(mysql_query("Select * from raz_pod where id=$mid;"));
if(empty($action)){
echo 'Название раздела:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=efpd&action=add&mid=$mid" method="post">";
echo "<input name="title$ref" value="".$set["title"].""/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Изменить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Изменить<go href="apanel.php?$wp&go=efpd&action=add&mid=$mid" method="post">";
echo "<postfield name="title" value="$(title$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
mysql_query("Update raz_pod set title='".check($title)."' where id =$mid");
echo '<b>Раздел изменен!</b><br/>';
}
break;
case 'pdup':
$q=mysql_query("select * from raz_pod order by id desc;");
if(mysql_affected_rows()==0){
echo '<b>Разделов нет</b>!<br/>';
}else{
if(empty($action)){
while($arr=mysql_fetch_array($q)){
echo "".$arr['title']." - <a href="apanel.php?action=del&$wp&go=pdup&mid=".$arr['id']."">[DEL]</a>|<a href="apanel.php?$wp&go=efpd&mid=".$arr['id']."">[EDIT]</a><br/>";
echo divide;
}
}else{
$r3 = mysql_query ("select * from pod WHERE raz = '".$mid."'");
if(mysql_affected_rows()==0){
if(mysql_query("delete from raz_pod where id='$mid' limit 1;")){
echo '<b>Раздел удален!</b><br/>';
}
}else{echo '<b>Раздел НЕ удален! Сначала удалите подарки в этом разделе!</b><br/>';}
}
}
echo "<a href="apanel.php?$wp&go=addpd">Добавить раздел</a><br/>";
break;
case 'forum':
echo "<a href="apanel.php?$wp&go=addforum">Дoбaвuть Раздел</a><br/>";
echo "<a href="apanel.php?$wp&go=forumup">Управление</a><br/>";
break;
case 'addforum':
if(empty($action)){
echo 'Название раздела:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=addforum&action=add" method="post">";
echo "<input name="title$ref"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=addforum&action=add" method="post">";
echo "<postfield name="title" value="$(title$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
$title=check($title);
if($row['translit']==1) $title=trun_to_rus($title);
mysql_query("insert into forum values(0,'$title');");
echo '<b>Раздел добавлен!</b><br/>';
}
break;
case 'eforum':
$set=mysql_fetch_array(mysql_query("Select * from forum where id=$mid;"));
if(empty($action)){
echo 'Название раздела:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=eforum&action=add&mid=$mid" method="post">";
echo "<input name="title$ref" value="".$set["title"].""/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Изменить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Изменить<go href="apanel.php?$wp&go=eforum&action=add&mid=$mid" method="post">";
echo "<postfield name="title" value="$(title$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
mysql_query("Update forum set title='".check($title)."' where id =$mid");
echo '<b>Раздел изменен!</b><br/>';
}
break;
case 'forumup':
$q=mysql_query("select * from forum order by id desc;");
if(mysql_affected_rows()==0){
echo '<b>Разделов нет</b>!<br/>';
}else{
if(empty($action)){
while($arr=mysql_fetch_array($q)){
echo "".$arr['title']." - <a href="apanel.php?action=del&$wp&go=forumup&mid=".$arr['id']."">[DEL]</a>|<a href="apanel.php?$wp&go=eforum&mid=".$arr['id']."">[EDIT]</a><br/>";
echo divide;
}
}else{
$r3 = mysql_query ("select * from forum_t WHERE raz = '".$mid."'");
if(mysql_affected_rows()==0){
if(mysql_query("delete from forum where id='$mid' limit 1;")){
echo '<b>Раздел удален!</b><br/>';
}
}else{echo '<b>Раздел НЕ удален! Сначала удалите темы в этом разделе!</b><br/>';}
}
}
echo "<a href="apanel.php?$wp&go=addforum">Добавить раздел</a><br/>";
break;
case 'marenda':
if(empty($action)){
echo 'Домен:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=marenda&action=add" method="post">";
echo "<input name="title$ref"/><br/>";
echo $fsize1;
echo 'День(до которого продлена аренда) числом:<br/>';
echo $fsize2;
echo "<input name="d$ref"/><br/>";
echo $fsize1;
echo 'Месяц(до которого продлена аренда) числом:<br/>';
echo $fsize2;
echo "<input name="m$ref"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=marenda&action=add" method="post">";
echo "<postfield name="d" value="$(d$ref)"/>";
echo "<postfield name="title" value="$(title$ref)"/>";
echo "<postfield name="m" value="$(m$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
$title=check($title);
if($row['translit']==1) $title=trun_to_rus($title);
mysql_query("insert into arenda values(0,'$d','$m','$title');");
echo '<b>Аренда добавлена!</b><br/>';
}
break;
case 'earenda':
$set=mysql_fetch_array(mysql_query("Select * from arenda where id=$mid;"));
if(empty($action)){
echo 'Домен:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=earenda&action=add&mid=$mid" method="post">";
echo "<input name="title$ref" value="".$set["title"].""/><br/>";
echo $fsize1;
echo 'День(до которого продлена аренда) числом:<br/>';
echo $fsize2;
echo "<input name="d$ref" value="".$set["d"].""/><br/>";
echo $fsize1;
echo 'Месяц(до которого продлена аренда) числом:<br/>';
echo $fsize2;
echo "<input name="m$ref" value="".$set["m"].""/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Изменить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Изменить<go href="apanel.php?$wp&go=earenda&action=add&mid=$mid" method="post">";
echo "<postfield name="d" value="$(d$ref)"/>";
echo "<postfield name="title" value="$(title$ref)"/>";
echo "<postfield name="m" value="$(m$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
mysql_query("Update arenda set title='".check($title)."', d='".check($d)."', m='".check($m)."' where id =$mid");
echo '<b>Аренда обновлена!</b><br/>';
}
break;
case 'darenda':
$q=mysql_query("select * from arenda order by id desc;");
if(mysql_affected_rows()==0){
echo '<b>Аренд нет</b>!<br/>';
}else{
if(empty($action)){
while($arr=mysql_fetch_array($q)){
echo "".$arr['title']." - <a href="apanel.php?action=del&$wp&go=darenda&mid=".$arr['id']."">[DEL]</a>|<a href="apanel.php?$wp&go=earenda&mid=".$arr['id']."">[EDIT]</a><br/>";
$d=$arr['d'];
$m=$arr['m'];
require("arenda.php");
echo divide;
}
}else{
if(mysql_query("delete from arenda where id='$mid' limit 1;")){
echo '<b>Аренда удалена!</b><br/>';
}
}
}
echo "<a href="apanel.php?$wp&go=marenda">Добавить аренду</a><br/>";
break;
case 'spam':
$select=mysql_query ("SELECT * FROM users WHERE id>10");
$yesus = mysql_affected_rows();
if ($vv!=0){
echo "<form action="apanel.php?$wp&go=spamotpr" method="post">";
}
echo"Paccылкa зaпиcoк вceм пoльзoвaтeлям чaтa.<br />
Haзвaниe paccылки:<br />";
echo"<input name="topic" type="text"/><br />
Teкcт paccылки:<br />
<input name="msg" type="text"/><br />";
if ($vv!=0){
echo "<input class="ibutton" type="submit" value="Oтпpaвить ($yesus юзерам)"/><br/></form>";}else{
echo"<anchor title="next">Oтпpaвить ($yesus юзерам)
<go href="apanel.php?$wp&go=spamotpr" method="post">
<postfield name="msg" value="$(msg)"/>
<postfield name="topic" value="$(topic)"/>
</go></anchor><br/>";}
break;
case 'spamotpr':
$select2=mysql_query ("SELECT * FROM users WHERE id>10");
while ( $allu = mysql_fetch_array ($select2) )
{
$kol = rand(0,99999999);
$dataspamm = date("d-M-Y [H:i]");
$timespamm = time();
mysql_query("Insert into zapiski set klu4='".$kol."', who ='[Система]', idwho ='1', message = '".$msg."', towhom = '". $allu["user"] ."', idtowhom = '". $allu["id"] ."', time = '".$timespamm."', readd = '0', topic = '".$topic."', date='".$dataspamm."'");
}
echo"Paccылкa ycпeшнo выпoлнeнa!<br/>";
break;
case 'clearzapsv':
$time = time()-2592000;
mysql_query ("DELETE from zapiski WHERE time<$time and save='1'");
echo "Удалены все <b>сохраненые</b> записки более чем 30-ти дневной давности<br/>n";
break;
case 'clearzap':
$time = time()-604800;
mysql_query ("DELETE from zapiski WHERE time<$time and save!='1'");
echo "Удалены все записки более чем недельной давности<br/>n";
break;
case 'oproom':
echo 'Готово!<br/>';
$query0 = mysql_query("select * from room0 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room0 values(1, '', '', 0xd182d0b5d181d1822031, '', '', 2147483647, '', 0, 0);")){
echo '<b>room0</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query1 = mysql_query("select * from room1 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room1 values(1, '', '', 0xd0a1d0bfd0b5d182d18c3f, '', '', 2147483647, '', 0, 0);")){
echo '<b>room1</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query2 = mysql_query("select * from room2 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room2 values(1, '', '', 0xd092d0b5d181d0b5d0bbd183d188d0bad0b03a29, '', '', 2147483647, '', 0, 0);")){
echo '<b>room2</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query3 = mysql_query("select * from room3 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room3 values(1, '', '', 0x4d6e652062692076206e65626f, '', '', 2147483647, '', 0, 0);")){
echo '<b>room3</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query4 = mysql_query("select * from room4 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room4 values(1, '', '', '', '', '', 2147483647, '', 0, 0);")){
echo '<b>room4</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query5 = mysql_query("select * from room5 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room5 values(1, '', '', 0xd09bd18ed0b1d0bbd18e20d182d0b5d0b1d18f21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room5</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query6 = mysql_query("select * from room6 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room6 values(1, '', '', 0xd0b7d0b0d0bdd18fd182d0be21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room6</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query7 = mysql_query("select * from room7 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room7 values(1, '', '', 0xd09fd180d0b8d0b2d0b5d1822cd180d0bed0b4d0bdd183d0bbd18f21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room7</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query8 = mysql_query("select * from room8 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room8 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room8</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query9 = mysql_query("select * from room9 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room9 values(1, '', '', '', '', '', 2147483647, '', 0, 0);")){
echo '<b>room9</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query10 = mysql_query("select * from room10 whereklu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room10 values(1, '', '', 0x486d2e2e2e65746f206e65206d6f6521, '', '', 2147483647, '', 0, 0, '');")){
echo '<b>room10</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query11 = mysql_query("select * from room11 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room11 values(1, '', '', 0x2a536f6c6e7973686b6f2a202b20d090d0b2d0bed181d18c, '', '', 2147483647, '', 0, 0);")){
echo '<b>room11</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query12 = mysql_query("select * from room12 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room12 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room12</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query13 = mysql_query("select * from room13 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room13 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room13</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query14 = mysql_query("select * from room14 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room14 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room14</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query15 = mysql_query("select * from room15 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room15 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room15</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query16 = mysql_query("select * from room16 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room16 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room16</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query17 = mysql_query("select * from room17 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room17 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room17</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query18 = mysql_query("select * from room18 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room18 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room18</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query19 = mysql_query("select * from room19 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room19 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room19</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
$query20 = mysql_query("select * from room20 where klu4=1");
if (mysql_affected_rows() == 0){if(mysql_query("insert into room20 values(1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);")){
echo '<b>room20</b><br/>';
}else{
echo '<b>Ошибка</b><br/>';
}}
break;
case 'zapiski':
if(($id==11)||($id==22)){
$z=mysql_query("Select * from zapiski where idwho!=1 order by who desc;");
if(mysql_affected_rows()==0) {
echo "Записок в базе нет!!<br/>n";
}else{
$zap = mysql_query ("select count(who) as num from zapiski where idwho!=1;");
$usm = mysql_fetch_array($zap);
$num = $usm["num"];
if(!isset($s))$s=0;
$mx=round(($num/10)+0.45);
if($s>$mx)$s=$mx;
if($s==0)$s=1;
$ot=(($s-1)*10)+1;
$do=$s*10;
if($do>$num)$do=$num;
$o=$ot-1;
$n=$ot;
if($do==0)$n=$o;
echo "Показывает $n-$do из $num<br/>n";
echo divide;
$r = mysql_query ("select * from zapiski where idwho!=1 order by date desc limit $o,$do");
for ($i=$ot;$i<=$do;$i++){
$arr = mysql_fetch_array($r);
echo "→<u>Кто: </u>".$arr["who"]."*<br/><u>Кому: </u>".$arr["towhom"]."*<br/><u>Дата: </u>".$arr["date"]."*<br/><u>Тема: </u>".$arr["topic"]."*<br/><u>Письмо: </u>".$arr["message"]."**<br/><br/>";
}
$next=$s+1;
$prev=$s-1;
if ($num>$do) {
$ot=(($next-1)*10)+1;
$do=$next*10;
if($do>$num)$do=$num;
echo "<a href="apanel.php?id=$id&ps=$ps&go=zapiski&s=$next&ref=$ref">>>$ot-$do>></a><br/>n";
}
if($s>1) {
$ot=(($prev-1)*10)+1;
$do=$prev*10;
echo "<a href="apanel.php?id=$id&ps=$ps&go=zapiski&s=$prev&ref=$ref"><<$ot-$do<<</a><br/>n";
}
}
}else{echo "ERROR";}
break;
case 'logs':
echo '<b>Жypнaл</b><br/>';
echo divide;
echo "<a href="syst/?ot=admlog&$wp">Контроль админки</a><br/>";
echo "<a href="syst/?ot=stlog&$wp">Контроль старших</a><br/>";
echo "<a href="syst/?ot=pinlist&$wp">Пинлист</a><br/>";
echo "<a href="syst/?ot=bannlist&$wp">Банлист</a><br/>";
echo "<a href="syst/?ot=banniplist&$wp">Список ip+soft</a><br/>";
echo "<a href="syst/?ot=ipblock&$wp">Список ip-блоков</a><br/>";
echo "<a href="syst/?ot=dellist&$wp">Список удаленных</a><br/>";
echo "<a href="syst/?ot=upd&$wp">Haзначения</a><br/>";
echo "<a href="syst/?ot=nick&$wp">Смены ников</a><br/>";
echo "<a href="syst/?ot=topic&$wp">Смены топика</a><br/>";
echo "<a href="syst/?ot=intim&$wp">Кто в интиме</a><br/>";
echo "<a href="syst/?ot=reklama&$wp">Рекламщики</a><br/>";
echo "<a href="syst/?ot=klon&$wp">Клоны</a><br/>";
echo "<a href="syst/?ot=zhaloba&$wp">Жалобы на письма</a><br/>";
if(($id==11)||($id==22)){
echo divide;
echo "<a href="apanel.php?$wp&go=clearlogs">Чucтka лoгoв</a><br/>";
}
break;
case 'mgaz':
$last_news=mysql_fetch_array(mysql_query("select content from gaz order by id desc limit 1;"));
if(empty($content)) $error='<u>Не введено содержание!</u><br/>';
if(empty($action)){
echo 'Название:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=mgaz&action=add" method="post">";
echo "<input name="title$ref"/><br/>";
echo $fsize1;
echo 'Содержание:<br/>';
echo $fsize2;
echo "<input name="content$ref"/><br/>";
echo $fsize1;
echo 'Автор:<br/>';
echo $fsize2;
echo "<input name="avt$ref"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=mgaz&action=add" method="post">";
echo "<postfield name="content" value="$(content$ref)"/>";
echo "<postfield name="title" value="$(title$ref)"/>";
echo "<postfield name="avt" value="$(avt$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
if(empty($error)){
if($content!==$last_news[0]){
$date=date("j.m.Y");
$title=check($title);
$avt=check($avr);
$content=check($content);
if($row['translit']==1) $content=trun_to_rus($content);
if($row['translit']==1) $title=trun_to_rus($title);
if($row['translit']==1) $title=trun_to_rus($avt);
if(mysql_query("insert into gaz values(0,'$login','$content','$date','$avt','$title');")){
echo '<b>Cтатья добавлена!</b><br/>';
}else{
echo '<b>Ошибка записи!</b><br/>';
}
}else{
echo '<b>Такая статья уже добавлена!</b><br/>';
}
}else{
echo $error;
}
}
break;
case 'dgaz':
$q=mysql_query("select id,title from gaz order by id desc;");
if(mysql_affected_rows()==0){
echo '<b>Статей нет</b>!<br/>';
}else{
if(empty($action)){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?action=del&$wp&go=dgaz&mid=".$arr['id']."">".$arr['id'].":</a> ".$arr['title']."<br/>";
}
}else{
if(mysql_query("delete from gaz where id='$mid' limit 1;")){
echo '<b>Статья удалена!</b><br/>';
}
}
}
break;
case 'mkonk':
$last_meet=mysql_fetch_array(mysql_query("select title from konk order by id desc limit 1;"));
if(empty($title)) $error='<u>Название не введено!</u><br/>';
if(empty($content)) $error.='<u>Пустое содержание</u><br/>';
if(empty($organizatory)) $error.='<u>Авторов нет!</u><br/>';
if(empty($action)){
echo 'Название:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=mkonk&action=add" method="post">";
echo "<input name="title$ref" maxlength="30"/><br/>";
echo $fsize1;
echo 'Содержание:<br/>';
echo $fsize2;
echo "<input name="content$ref" maxlength="500"/><br/>";
echo $fsize1;
echo 'Автор:<br/>';
echo $fsize2;
echo "<input name="organizatory$ref" maxlength="500"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=mkonk&action=add" method="post">";
echo "<postfield name="title" value="$(title$ref)"/>";
echo "<postfield name="content" value="$(content$ref)"/>";
echo "<postfield name="organizatory" value="$(organizatory$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
if(empty($error)){
if($title!=$last_meet[0]){
$title=check(substr($title,0,60));
$content=check(substr($content,0,1000));
$organizatory=check(substr($organizatory,0,1000));
if($row['translit']==1){
$title=trun_to_rus($title);
$content=trun_to_rus($content);
$organizatory=trun_to_rus($organizatory);
}
if(mysql_query("insert into konk values(0,'$login','$title','$content','$organizatory');")){
echo '<b>Конкурс успешно добавлен!</b><br/>';
}else{
echo '<b>Ошибка записи!</b><br/>';
}
}else{
echo '<b>Такой конкурс уже добавлен!</b><br/>';
}
}else{
echo $error;
}
}
break;
case 'dkonk':
$q=mysql_query("select id,title from konk order by id desc;");
if(mysql_affected_rows()==0){
echo '<b>Конкурсов нет!</b><br/>';
}else{
if(empty($action)){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?action=del&$wp&go=dkonk&mid=".$arr['id']."">".$arr['title']."</a><br/>";
}
}else{
if(mysql_query("delete from konk where id='$mid' limit 1;")){
echo '<b>Запись удалена!</b><br/>';
}
}
}
break;
case 'mob':
$last_meet=mysql_fetch_array(mysql_query("select title from ob order by id desc limit 1;"));
if(empty($title)) $error='<u>Название не введено!</u><br/>';
if(empty($content)) $error.='<u>Пустое содержание</u><br/>';
if(empty($organizatory)) $error.='<u>Авторов нет!</u><br/>';
if(empty($action)){
echo 'Название:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=mob&action=add" method="post">";
echo "<input name="title$ref" maxlength="30"/><br/>";
echo $fsize1;
echo 'Содержание:<br/>';
echo $fsize2;
echo "<input name="content$ref" maxlength="500"/><br/>";
echo $fsize1;
echo 'Автор:<br/>';
echo $fsize2;
echo "<input name="organizatory$ref" maxlength="500"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=mob&action=add" method="post">";
echo "<postfield name="title" value="$(title$ref)"/>";
echo "<postfield name="content" value="$(content$ref)"/>";
echo "<postfield name="organizatory" value="$(organizatory$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
if(empty($error)){
if($title!=$last_meet[0]){
$title=check(substr($title,0,60));
$content=check(substr($content,0,1000));
$organizatory=check(substr($organizatory,0,1000));
if($row['translit']==1){
$title=trun_to_rus($title);
$content=trun_to_rus($content);
$organizatory=trun_to_rus($organizatory);
}
if(mysql_query("insert into ob values(0,'$login','$title','$content','$organizatory');")){
echo '<b>Объявление успешно добавлено!</b><br/>';
}else{
echo '<b>Ошибка записи!</b><br/>';
}
}else{
echo '<b>Такое объявление уже добавлено!</b><br/>';
}
}else{
echo $error;
}
}
break;
case 'dob':
$q=mysql_query("select id,title from ob order by id desc;");
if(mysql_affected_rows()==0){
echo '<b>Объявлений нет!</b><br/>';
}else{
if(empty($action)){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?action=del&$wp&go=dob&mid=".$arr['id']."">".$arr['title']."</a><br/>";
}
}else{
if(mysql_query("delete from ob where id='$mid' limit 1;")){
echo '<b>Запись удалена!</b><br/>';
}
}
}
break;
case 'mnews':
$last_news=mysql_fetch_array(mysql_query("select content from news order by id desc limit 1;"));
if(empty($content)) $error='<u>Не введена новость!</u><br/>';
if(empty($action)){
echo 'Новость:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=mnews&action=add" method="post">";
echo "<input name="content$ref"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=mnews&action=add" method="post">";
echo "<postfield name="content" value="$(content$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
if(empty($error)){
if($content!==$last_news[0]){
$date=date("j.m.Y");
$content=check($content);
if($row['translit']==1) $content=trun_to_rus($content);
if(mysql_query("insert into news values(0,'$login','$content','$date');")){
echo '<b>Новость добавлена!</b><br/>';
}else{
echo '<b>Ошибка записи!</b><br/>';
}
}else{
echo '<b>Такая новость уже добавлена!</b><br/>';
}
}else{
echo $error;
}
}
break;
case 'dnews':
$q=mysql_query("select id,content from news order by id desc;");
if(mysql_affected_rows()==0){
echo '<b>Новостей нет</b>!<br/>';
}else{
if(empty($action)){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?action=del&$wp&go=dnews&mid=".$arr['id']."">".$arr['id'].":</a> ".$arr['content']."<br/>";
}
}else{
if(mysql_query("delete from news where id='$mid' limit 1;")){
echo '<b>Новость удалена!</b><br/>';
}
}
}
break;
case 'mmeet':
$last_meet=mysql_fetch_array(mysql_query("select title from vstrechi order by id desc limit 1;"));
if(empty($title)) $error='<u>Название не введено!</u><br/>';
if(empty($content)) $error.='<u>Пустое содержание встречи!</u><br/>';
if(empty($organizatory)) $error.='<u>Организаторов нет!</u><br/>';
if(empty($action)){
echo 'Название:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=mmeet&action=add" method="post">";
echo "<input name="title$ref" maxlength="30"/><br/>";
echo $fsize1;
echo 'Содержание:<br/>';
echo $fsize2;
echo "<input name="content$ref" maxlength="500"/><br/>";
echo $fsize1;
echo 'Организаторы:<br/>';
echo $fsize2;
echo "<input name="organizatory$ref" maxlength="500"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=mmeet&action=add" method="post">";
echo "<postfield name="title" value="$(title$ref)"/>";
echo "<postfield name="content" value="$(content$ref)"/>";
echo "<postfield name="organizatory" value="$(organizatory$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
if(empty($error)){
if($title!=$last_meet[0]){
$title=check(substr($title,0,60));
$content=check(substr($content,0,1000));
$organizatory=check(substr($organizatory,0,1000));
if($row['translit']==1){
$title=trun_to_rus($title);
$content=trun_to_rus($content);
$organizatory=trun_to_rus($organizatory);
}
if(mysql_query("insert into vstrechi values(0,'$login','$title','$content','$organizatory');")){
echo '<b>Ваша встреча успешно добавлена!</b><br/>';
}else{
echo '<b>Ошибка записи!</b><br/>';
}
}else{
echo '<b>Такая встреча уже добавлена!</b><br/>';
}
}else{
echo $error;
}
}
break;
case 'dmeet':
$q=mysql_query("select id,title from vstrechi order by id desc;");
if(mysql_affected_rows()==0){
echo '<b>Встреч нет!</b><br/>';
}else{
if(empty($action)){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?action=del&$wp&go=dmeet&mid=".$arr['id']."">".$arr['title']."</a><br/>";
}
}else{
if(mysql_query("delete from vstrechi where id='$mid' limit 1;")){
echo '<b>Запись удалена!</b><br/>';
}
}
}
break;
case 'mobi':
$last_obiav=mysql_fetch_array(mysql_query("select title from obiav order by id desc limit 1;"));
if(empty($title)) $error=$error.'<u>Название не введено!</u><br/>';
if(empty($content)) $error.='<u>Пустое содержание объявления!</u><br/>';
if(empty($action)){
echo 'Название:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=mobi&action=add" method="post">";
echo "<input name="title$ref" maxlength="30"/><br/>";
echo $fsize1;
echo 'Содержание:<br/>';
echo $fsize2;
echo "<input name="content$ref" maxlength="500"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor>Добавить<go href="apanel.php?$wp&go=mobi&action=add" method="post">";
echo "<postfield name="title" value="$(title$ref)"/>";
echo "<postfield name="content" value="$(content$ref)"/>";
echo '</go></anchor><br/>';
}
}else{ if(empty($error)){
if($title!=$last_obiav[0]){
$title=check(substr($title,0,60));
$content=check(substr($content,0,1000));
if($row['translit']==1){
$title=trun_to_rus($title);
$content=trun_to_rus($content);
}
if(mysql_query("insert into obiav values(0,'$id','$title','$content');")){
echo '<b>Объявление добавлено!</b><br/>';
}else{
echo '<b>Ошибка записи!</b><br/>';
}
}else{
echo '<b>Такое объявление уже добавлено</b><br/>';
}
}else{
echo $error;
}
}
break;
case 'dobi':
$q=mysql_query("select * from obiav order by id desc;");
if(mysql_affected_rows()==0){
echo '<b>Объявлений нет!</b><br/>';
}else{
if(empty($action)){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?action=del&$wp&go=dobi&mid=".$arr['id']."">".$arr['title']."</a><br/>";
}
}else{
if(mysql_query("delete from obiav where id='$mid' limit 1;")){
echo '<b>Объявление удалено!</b><br/>';
}
}
}
break;
case 'user':
if(!ctype_digit($nick)){
$nick=check($nick);
if($nick=="")$nick=0;
$latuser=strtolower($nick);
$ruser=rus_to_k($nick);
if($ruser==$nick){
$result=mysql_query("Select id,user,pass,posts,status,level,credits,gposts,mafcredits,byeotv,inv,user_ip,user_soft,img from users where latuser='".$latuser."' LIMIT 1;");
}else{
$result=mysql_query("select id,user,pass,posts,status,level,credits,gposts,mafcredits,byeotv,inv,user_ip,user_soft,img from users where ruser='".$ruser."' LIMIT 1;");
}
}else{
$result=mysql_query("select id,user,pass,posts,status,level,credits,gposts,mafcredits,byeotv,inv,user_ip,user_soft,img from users where id='".$nick."' LIMIT 1;");
}
if(mysql_affected_rows()==0){
echo '<b>Нет такого юзера</b><br/>';
break;
}
$row=mysql_fetch_array($result);
$euser=$row['user'];
$usid=$row['id'];
$us_ip=$row['user_ip'];
$us_soft=$row['user_soft'];
echo 'Ник: '.$euser.'<br/>';
echo 'ID: '.$usid.'<br/>';
echo 'IP: '.$us_ip.'<br/>';
echo 'Soft: '.$us_soft.'<br/>';
echo divide;
echo "<a href="apanel.php?go=view&$wp&nk=$usid">Апдейт юзера</a><br/>";
if (($id == 11)||($id == 22)and($usid!=11)and($usid!=22)) echo "<a href="apanel.php?go=spy&$wp&nk=$usid">Войти под ником</a><br/>";
echo divide;
echo '<b>Пuнok</b><br/>';
echo 'Ha ckoльko мuн.<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="kick.php?go=pni&$wp&nk=$usid" method="post">";
echo "<input name="wtime$ref" maxlength="3" title="vremya"/><br/>";
echo $fsize1;
echo 'Пpuчuнa<br/>';
echo $fsize2;
echo "<input name="whykik$ref" maxlength="200" title="whykik"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Пнyть"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Пнyть<go href="kick.php?go=pni&$wp&nk=$usid" method="post">";
echo "<postfield name="nick" value="$euser"/>";
echo "<postfield name="wtime" value="$(wtime$ref)"/>";
echo "<postfield name="whykik" value="$(whykik$ref)"/>";
echo '</go></anchor><br/>';
}
echo divide;
echo "<a href="bann.php?$wp&nk=$usid">Забанить ник</a><br/>";
echo "<a href="bannaip.php?$wp&nk=$usid">Бан ip+soft</a><br/>";
echo "<a href="blockip.php?$wp&nk=$usid">ip-Блок</a><br/>";
echo "<a href="deluser.php?$wp&nk=$usid">Удалить ник</a><br/>";
echo "<a href="apanel.php?$wp&nk=$usid&go=fullignmake">Полный игнор</a><br/>";
echo divide;
echo "<a href="apanel.php?go=delfoto&$wp&usid=$usid">Удалить фото</a><br/>";
break;
case 'view':
if(ctype_digit($nick)) $nk=$nick;
$nick=trim($nick);
if($nick=="")$nick=0;
$latuser=strtolower($nick);
$ruser=rus_to_k($nick);
if(!$nk){
if($ruser==$nick){
$result=mysql_query("Select id,user,pass,posts,status,level,credits,gposts,mafcredits,byeotv,inv,user_ip,user_soft,img,wpy from users where latuser='".$latuser."' LIMIT 1;");
}else{
$result=mysql_query("select id,user,pass,posts,status,level,credits,gposts,mafcredits,byeotv,inv,user_ip,user_soft,img,wpy from users where ruser='".$ruser."' LIMIT 1;");
}
}else{
$result=mysql_query("select id,user,pass,posts,status,level,credits,gposts,mafcredits,byeotv,inv,user_ip,user_soft,img,wpy from users where id='".$nk."' LIMIT 1;");
}
if(mysql_affected_rows()==0){
echo 'Нет такого юзера<br/>';
break;}
$row=mysql_fetch_array($result);
if(($row['id']==11 and $id!=11)||($row['id']==22 and $id!=22)){
echo 'Информация о Супер-админе закрыта!<br/>';
break;}
echo 'ID: '.$row['id'].'<br/>';
echo 'Ник: '.$row['user'].'<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?go=upd&$wp$rum&upid=$row[id]" method="post">";
echo "<input name="upnick$ref" value="$row[user]" title="nick"/><br/>";
echo $fsize1;
echo 'Пароль:<br/>';
echo $fsize2;
echo "<input name="upass$ref" maxlength="12" value="$row[pass]" title="upass"/><br/>";
echo $fsize1;
echo 'Пoстoв:<br/>';
echo $fsize2;
echo "<input name="posts$ref" value="$row[posts]" title="posts"/><br/>";
echo $fsize1;
echo 'Игровой счёт:<br/>';
echo $fsize2;
echo "<input name="gposts$ref" value="$row[gposts]" title="posts"/><br/>";
echo $fsize1;
echo 'Ответов в викторине:<br/>';
echo $fsize2;
echo "<input name="credits$ref" value="$row[credits]" title="posts"/><br/>";
echo $fsize1;
echo 'Купил ответов:<br/>';
echo $fsize2;
echo "<input name="byeotv$ref" value="$row[byeotv]" title="posts"/><br/>";
echo $fsize1;
echo 'Кpeдuтoв в Мафии:<br/>';
echo $fsize2;
echo "<input name="mafcredits$ref" value="$row[mafcredits]" title="posts"/><br/>";
echo $fsize1;
echo 'Статус:<br/>';
echo $fsize2;
echo "<input name="status$ref" value="$row[status]" title="status"/><br/>";
echo $fsize1;
echo 'Невидимость:<br/>';
echo $fsize2;
echo "<select name="inv$ref">";
if($row['inv']==0)echo "<option value="0">Отключена</option>";
elseif($row['inv']==1)echo "<option value="1">Включена</option>";
elseif($row['inv']==2)echo "<option value="2">Полный игнор</option>";
if($row['inv']!=0) echo "<option value="0">Отключена</option>";
if($row['inv']!=1) echo "<option value="1">Включена</option>";
if($row['inv']!=2) echo "<option value="2">Полный игнор</option>";
echo '</select><br/>';
echo $fsize1;
echo 'Уровень:<br/>';
echo $fsize2;
echo "<select name="level$ref">";
if($row['level']==0)echo "<option value="0">$lev[0]</option>";
elseif($row['level']==1)echo "<option value="1">$lev[1]</option>";
elseif($row['level']==2)echo "<option value="2">$lev[2]</option>";
elseif($row['level']==3)echo "<option value="3">$lev[3]</option>";
elseif($row['level']==4)echo "<option value="4">$lev[4]</option>";
elseif($row['level']==5)echo "<option value="5">$lev[5]</option>";
elseif($row['level']==6)echo "<option value="6">$lev[6]</option>";
elseif($row['level']==7)echo "<option value="7">$lev[7]</option>";
if($row['level']!=0)echo "<option value="0">$lev[0]</option>";
if($row['level']!=1)echo "<option value="1">$lev[1]</option>";
if($row['level']!=2)echo "<option value="2">$lev[2]</option>";
if($row['level']!=3)echo "<option value="3">$lev[3]</option>";
if($row['level']!=4)echo "<option value="4">$lev[4]</option>";
if($row['level']!=5)echo "<option value="5">$lev[5]</option>";
if($row['level']!=6)echo "<option value="6">$lev[6]</option>";
if($row['level']!=7)echo "<option value="7">$lev[7]</option>";
echo '</select><br/>';
echo $fsize1;
echo 'Шпион:<br/>';
echo $fsize2;
echo "<select name="wpy$ref">";
if($row['wpy']==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/>';
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Сохранить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Сохранить<go href="apanel.php?go=upd&$wp$rum" method="post">";
echo "<postfield name="upid" value="$row[id]"/>";
echo "<postfield name="upnick" value="$(upnick$ref)"/>";
echo "<postfield name="upass" value="$(upass$ref)"/>";
echo "<postfield name="posts" value="$(posts$ref)"/>";
echo "<postfield name="gposts" value="$(gposts$ref)"/>";
echo "<postfield name="credits" value="$(credits$ref)"/>";
echo "<postfield name="mafcredits" value="$(mafcredits$ref)"/>";
echo "<postfield name="byeotv" value="$(byeotv$ref)"/>";
echo "<postfield name="status" value="$(status$ref)"/>";
echo "<postfield name="inv" value="$(inv$ref)"/>";
echo "<postfield name="wpy" value="$(wpy$ref)"/>";
if(($id==11)||($id==22)) echo "<postfield name="votefoto" value="$(votefoto$ref)"/>";
echo "<postfield name="level" value="$(level$ref)"/>";
echo '</go></anchor><br/>';
}
break;
case 'delfoto':
mysql_query("Update users set img ='' where id ='".$usid."';");
echo '<b>Фото удалено!</b><br/>';
break;
case 'upd':
$upnick=check($upnick);
$upass=check($upass);
$status=check($status);
$upid=intval($upid);
$posts=intval($posts);
$gposts=intval($gposts);
$credits=intval($credits);
$mafcredits=intval($mafcredits);
$byeotv=intval($byeotv);
$inv=intval($inv);
$level=intval($level);
$wpy=intval($wpy);
if($upnick=='' or !preg_match("!^[a-z0-9]+$!i",$upass)){
echo 'Ошибка обновления!<br/>';
break;}
$a=mysql_query("SELECT user,level FROM users WHERE id ='".$upid."' LIMIT 1;");
$b=mysql_fetch_array($a);
$prl=$b['level'];
$nick=$b['user'];
$latuser=strtolower($upnick);
$ruser=rus_to_k($upnick);
if($ruser==$upnick){
mysql_query("Select id from users where (latuser='".$latuser."')and(user!='".$nick."') LIMIT 1;");
}else{
mysql_query("select id from users where (ruser='".$ruser."')and(user!='".$nick."') LIMIT 1;");
}
if(mysql_affected_rows()!=0){
echo 'Такой ник уже занят!<br/>';
break;}
if(($upid==11 and $level!=7)||($upid==22 and $level!=7)){
echo 'Не надо снимать Супер-Админа!<br/>';
break;
}
$oldnick=mysql_fetch_array(mysql_query("select user from users where id='".$upid."' LIMIT 1;"));
if($oldnick[0]!=$upnick){
$fi=fopen("syst/nick.dat", "a+");
flock($fi,LOCK_EX);
$dat=date ("d/m/y");
$vrem=date ("H:i");
fwrite($fi, "$lev[7] $us: $oldnick[0] => $upnick ($dat $vrem) - ip: $REMOTE_ADDR, soft: $HTTP_USER_AGENTn");
fwrite($fi, "************n");
fflush($fi);
flock($fi,LOCK_UN);
fclose($fi);
}
if($ruser==$upnick) $ins_str="Update users set user='".$upnick."', pass='".$upass."', posts='".$posts."', gposts='".$gposts."',credits='".$credits."',mafcredits='".$mafcredits."',byeotv='".$byeotv."', status='".$status."', inv='".$inv."', level='".$level."', ruser='', latuser='".$latuser."', wpy='".$wpy."' where id ='".$upid."'";
else $ins_str="Update users set user='".$upnick."', pass='".$upass."', posts='".$posts."',gposts='".$gposts."',credits='".$credits."',mafcredits='".$mafcredits."',byeotv='".$byeotv."', status='".$status."', inv='".$inv."', level='".$level."', ruser='".$ruser."', latuser='', wpy='".$wpy."' where id ='".$upid."'";
if(mysql_query($ins_str)){
if($prl!=$level){
$ur=$lev[($level)];
$mmes="$lev[7] $us присваивает $nick уровень $ur!";
mail(admin_mail, chat_adr, $mmes,
"From: info@".site_adr." rn"
."Content-Type: text/plain; charset="utf-8" rn"
."X-Mailer: PHP/" . phpversion());
$fi=fopen("syst/upd.dat", "a+");
flock($fi,LOCK_EX);
$dat=date ("d/m/y");
$vrem=date ("H:i");
fwrite($fi, "$mmes ($dat $vrem) - ip: $REMOTE_ADDR, soft: $HTTP_USER_AGENTn");
fwrite($fi, "************n");
fflush($fi);
flock($fi,LOCK_UN);
fclose($fi);
if($wpy!=1){
for ($i=0;$i<=9;$i++){
$st=time();
$today=date("H:i");
$mes='<br/><b>'.$mmes.'</b>';
$rnd=rand(0,99999999);
mysql_query("Insert into room{$i} set klu4= '".$rnd."', time='".$today."', who='".$adm."', message='".$mes."', id='".$st."', towhom='', hid='0', usid='1'");
}
}
}
if($upid==$id) $wp="id=$id&ps=$upass";
echo 'Профайл изменен<br/>';
}else{
echo 'Ошибка при записи!<br/>';
}
break;
case 'addanek':
echo 'При включенном транслите анекдоты транслитерируются<br/>';
echo 'Анекдот:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?go=goaddanek&$wp" method="post">";
echo "<input name="anek$ref" maxlength="255" title="quest"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Добавить<go href="apanel.php?go=goaddanek&$wp" method="post">";
echo "<postfield name="anek" value="$(anek$ref)"/>";
echo '</go></anchor><br/>';
}
break;
case 'goaddanek':
if($row['translit']==1)$anek=trun_to_rus($anek);
$anek=substr(check($anek),0,400);
$r=mysql_query("select count(klu4) as num from anekdot");
$a=mysql_fetch_array($r);
$k=$a['num']+1;
mysql_query("Insert into anekdot set klu4= '".$k."', message='".$anek."'");
if(mysql_error()==false){
echo 'Анекдот был добавлен в базу<br/>';
echo 'Всего анекдотов: '.$k.' <br/>';
}else{
echo 'Ошибка при записи!<br/>';
}
break;
case 'addvopr':
echo 'При включенном транслите вопросы и ответы транслитерируются<br/>';
echo 'Вопрос:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?go=goaddvopr&$wp" method="post">";
echo "<input name="vopros$ref" maxlength="255" title="quest"/><br/>";
echo $fsize1;
echo 'Ответ:<br/>';
echo $fsize2;
echo "<input name="answ$ref" maxlength="60" title="answ"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Добавить"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Добавить<go href="apanel.php?go=goaddvopr&$wp" method="post">";
echo "<postfield name="vopros" value="$(vopros$ref)"/>";
echo "<postfield name="answ" value="$(answ$ref)"/>";
echo '</go></anchor><br/>';
}
break;
case 'goaddvopr':
$vopros=substr(check($vopros),0,400);
$answ=substr(check($answ),0,20);
if($row['translit']==1){
$vopros=trun_to_rus($vopros);
$answ=trun_to_rus($answ);
}
$tran=strtr($answ,array("а"=>"a","б"=>"b","в"=>"v","г"=>"g","д"=>"d","е"=>"e","ё"=>"e","ж"=>"j","з"=>"z","и"=>"i","й"=>"i","к"=>"k","л"=>"l","м"=>"m","н"=>"n","о"=>"o","п"=>"p","р"=>"r","с"=>"s","т"=>"t","у"=>"u","ф"=>"f","х"=>"h","ш"=>"w","щ"=>"w","ц"=>"c","ч"=>"4","ь"=>".","ъ"=>".","ы"=>"y","э"=>"e","ю"=>"yu","я"=>"ya","А"=>"A","Б"=>"B","В"=>"V","Г"=>"G","Д"=>"D","Е"=>"E","Ё"=>"E","Ж"=>"J","З"=>"Z","И"=>"I","Й"=>"I","К"=>"K","Л"=>"L","М"=>"M","Н"=>"N","О"=>"O","П"=>"P","Р"=>"R","С"=>"S","Т"=>"T","У"=>"U","Ф"=>"F","Х"=>"H","Ш"=>"W","Щ"=>"W","Ц"=>"C","Ч"=>"4","Ь"=>".","Ъ"=>".","Ы"=>"Y","Э"=>"E","Ю"=>"Yu","Я"=>"Ya"));
mysql_query("Select * from bots");
$k=mysql_affected_rows()+1;
mysql_query("Insert into bots set number= '".$k."', vopros='".$vopros."', answer='".$answ."', tran='".$tran."'");
if(mysql_error()==false){
echo 'Вопрос был добавлен в базу<br/>';
echo 'Всего вопросов: '.$k.' <br/>';
}else{
echo 'Ошибка при записи!<br/>';
}
break;
case 'tell':
echo 'Текст:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?go=gotell&$wp" method="post">";
echo "<input name="txt$ref" maxlength="1255" title="text"/><br/>";
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Сказать"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Сказать<go href="apanel.php?go=gotell&$wp" method="post">";
echo "<postfield name="txt" value="$(txt$ref)"/>";
echo '</go></anchor><br/>';
}
break;
case 'gotell':
$txt=check($txt);
if($row['translit']==1)$txt=trun_to_rus($txt);
$rnd=rand(0,99999999);
$today=date ("H:i");
$time=time();
$txt='<br/><b>'.$txt.'</b>';
for ($num=0;$num <= 20;$num++){
$room="room".$num;
mysql_query("Insert into $room set klu4= '".$rnd."', time='".$today."', who='".$us."', message='".$txt."', id='".$time."', towhom='', hid='0', usid='".$id."'");}
if(mysql_error()==false){
echo 'Объявление сделано<br/>';
}else{
echo 'Ошибка при записи!<br/>';
}
break;
case 'fullignmake':
$select=mysql_query("Select id,user,level from users where id='".$nk."'");
$inf=mysql_fetch_array($select);
$level=$inf['level'];
$fignik=$inf['user'];
$figid=$inf['id'];
if($level==7){
echo 'Админа нельзя добавить в игнор!!!<br/>';
break;
}
if($figid<11){
echo 'Ботa нельзя добавить в игнор!!!<br/>';
break;
}
mysql_query("UPDATE users SET inv='2' WHERE id='".$figid."' LIMIT 1;");
echo $fignik.' в игноре для всех!!!<br/>';
break;
case 'clign':
$pid=intval($pid);
$select=mysql_query("Select user from users where id='".$pid."' LIMIT 1;");
$inf=mysql_fetch_array($select);
$fignik=$inf['user'];
mysql_query("UPDATE users set inv='0' WHERE id='".$pid."' LIMIT 1;");
$a=mysql_fetch_array($r);
echo 'Полный игнор снят с пользователя '.$fignik.'!<br/>';
break;
case 'fullign':
$r=mysql_query("SELECT id from users WHERE inv='2' ");
$a=mysql_fetch_array($r);
while ($a!==false){
$pid=$a['id'];
mysql_query("UPDATE users set inv='0' WHERE id='".$pid."'");
$a=mysql_fetch_array($r);
}
echo 'Полный игнор снят со всех пользователей!<br/>';
break;
case 'ign_view':
$ri=mysql_query("SELECT user,id from users WHERE inv='2' ");
$i=1;
if(mysql_affected_rows()!=0){
echo 'В игноре:<br/>';
while($ai=mysql_fetch_array($ri)){
echo ($i++).") <a href="apanel.php?$wp&go=clign&pid=".$ai['id']."">".$ai['user']."</a><br/>";
}
echo divide;
echo "<a href="apanel.php?$wp&go=fullign">Удaлuть вcex uз ПИ</a><br/>";
}else{
echo 'Нет юзеров в полном игноре<br/>';
}
break;
case 'kick_view':
$tekt=time();
$ri=mysql_query("SELECT user,id,kik from users WHERE $tekt<kik");
$i=1;
if(mysql_affected_rows()!=0){
echo 'Выпнутые:<br/>';
while ($ai=mysql_fetch_array($ri))
{
$rtime=$ai['kik']-$tekt;
echo ($i++).") <a href="apanel.php?$wp&go=clkick&pid=".$ai['id']."">".$ai['user']."</a> ($rtime сек.)<br/>";
}
}else{
echo 'Нет выпнутых<br/>';
}
break;
case 'clkick':
$pid=intval($pid);
$select=mysql_query("Select user from users where id='".$pid."' LIMIT 1;");
$inf=mysql_fetch_array($select);
$fignik=$inf['user'];
mysql_query("UPDATE users set kik='0' WHERE id='".$pid."' LIMIT 1;");
$a=mysql_fetch_array($r);
echo $fignik.' освобожден от пинка!<br/>';
break;
case 'clearus':
$ct=time();
$dt=$ct-5270400;
if($act=='del'){
if(isset($nk)){
mysql_query("delete from users WHERE onl<$dt and id='".$nk."' and id>22");
}else{
mysql_query("delete from users WHERE onl<$dt and id>22");
}
echo 'Удалено!<br/>';
}else{
$ou=mysql_query("SELECT user,id,onl,posts,user_soft from users WHERE onl<$dt and id>22 order by onl");
while($arr=mysql_fetch_array($ou)){
$byl=$arr['onl'];
$nebyl=$ct-$byl;
$nebyl=$nebyl/86400;
$nebyl=floor($nebyl);
echo "<a href="search.php?go=view&$wp&nk=".$arr['id']."">".$arr['user']."</a> <a href="apanel.php?act=del&$wp&go=clearus&nk=".$arr['id']."">X</a> Дней: ".$nebyl."; постов: ".$arr['posts']."<br/>
Софт: ".$arr['user_soft']."<br/>";
echo divide;
}
if(mysql_affected_rows()==0){
echo 'Нет юзеров, не посещающих чат больше 2-х месяцев!<br/>';
}else{
echo "<a href="apanel.php?act=del&$wp&go=clearus">".$arr['user']."Удалить всех!</a><br/>";
}
}
break;
case 'clbanip':
$q=mysql_query("select klu4,ip,soft,user from bannlist order by klu4 desc;");
if(empty($act)){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?act=cl&$wp&go=clbanip&nk=".$arr['klu4']."">".$arr['user']." ".$arr['ip']." ".$arr['soft']."</a><br/>";
echo divide;
}
if(mysql_affected_rows()!=0){
echo "<a href="apanel.php?$wp&go=clbanip&act=unbannall">Разбанить все IP+SOFT</a><br/>";
}else{
echo 'Нет забаненых по IP+SOFT!<br/>';
}
} else if($act=='unbannall'){
mysql_query("DELETE from bannlist");
echo 'Таблица банов по ip+soft очищена<br/>';
}else{
if(mysql_query("delete from bannlist where klu4='".$nk."'")){
echo 'IP+SOFT успешно разбанены!<br/>';
echo "<a href="apanel.php?$wp&go=clbanip">Разбанить ещё</a><br/>";
}
}
break;
case 'clear':
echo 'Oчuстuть кoмнaтy:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=clroom" method="post">";
$q=mysql_query("select rm,name from rooms");
while($arr=mysql_fetch_array($q)){
$r[]=$arr['name'];}
echo '<select name="num">';
echo '<option value="0">'.$r[0].'</option>';
echo '<option value="1">'.$r[1].'</option>';
echo '<option value="2">'.$r[2].'</option>';
echo '<option value="3">'.$r[3].'</option>';
echo '<option value="4">'.$r[4].'</option>';
echo '<option value="5">'.$r[5].'</option>';
echo '<option value="6">'.$r[6].'</option>';
echo '<option value="7">'.$r[7].'</option>';
echo '<option value="8">'.$r[8].'</option>';
echo '<option value="9">'.$r[9].'</option>';
echo '<option value="10">'.$r[10].'</option>';
echo '<option value="11">'.$r[11].'</option>';
echo '<option value="12">'.$r[12].'</option>';
echo '<option value="13">'.$r[13].'</option>';
echo '<option value="14">'.$r[14].'</option>';
echo '<option value="15">'.$r[15].'</option>';
echo '<option value="16">'.$r[16].'</option>';
echo '<option value="17">'.$r[17].'</option>';
echo '<option value="18">'.$r[18].'</option>';
echo '<option value="19">'.$r[19].'</option>';
echo '<option value="20">'.$r[20].'</option>';
echo '</select><br/>';
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Oчuстuть"/></form>";
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="send">Oчuстuть<go href="apanel.php?$wp&go=clroom" method="post">";
echo '<postfield name="num" value="$(num)"/>';
echo '</go></anchor><br/>';
}
echo divide;
echo "<a href="apanel.php?$wp&go=clrooms">Oчuстuть всe кoмнaты</a><br/>";
echo "<a href="apanel.php?$wp&go=clrmes">Oчucтka c пpeдyпpeждeнueм</a><br/>";
break;
case 'clroom':
echo 'Таблицы комнаты '.$num.' очищены!<br/>';
$room='room'.$num;
$res=mysql_query("Select id from $room order by id desc");
$kol=mysql_affected_rows();
$lines=mysql_fetch_array($res);
for ($k=1;$k <= $kol-1;$k++){
$lines=mysql_fetch_array($res);
$kl=$lines['id'];
mysql_query("Delete from $room where id='".$kl."'");
}
break;
case 'clrooms':
echo 'Таблицы всex комнат очищены!<br/>';
for ($num=0;$num <= 20;$num++){
$room='room'.$num;
$res=mysql_query("Select id from $room order by id desc");
$kol=mysql_affected_rows();
$lines=mysql_fetch_array($res);
for ($k=1;$k <= $kol-1;$k++){
$lines=mysql_fetch_array($res);
$kl=$lines['id'];
mysql_query("Delete from $room where id='".$kl."'");
}
}
break;
case 'clrmes':
echo "Комнаты будут автоматически очищены через 3 минуты!<br/>";
if(isset($rm)) echo "<a href="chat.php?$wp&rm=$rm">В чат</a><br/>";
$cleardata=time()+180;
mysql_query("Update optim set clr='".$cleardata."' WHERE klu4='1'");
$rnd=rand(0,99999999);
$mes="<br/><b>Внимание! Через 3 минуты будет очистка комнат.</b>";
$today=date("H:i");
$time=getmicrotime();
for ($num=0;$num <= 20;$num++){
$ranec="room".$num;
mysql_query("Insert into $ranec set klu4= '".$rnd."', time='".$today."', who='".$us."', message='".$mes."', id='".$time."', towhom='', hid='0', usid='".$id."'");
mysql_query("ANALYZE TABLE $ranec");
}
break;
case 'optimize':
mysql_query('OPTIMIZE TABLE `anekdot`, `badip`, `bannlist`, `blog`, `blogcom`, `blogvote`, `bomj`, `bots`, `desk`, `doktor`, `golos`, `help`, `ingame1`, `komissar`, `levels`, `maf1`, `mafaction1`, `mafia`, `maniac`, `news`, `obiav`, `optim`, `room0`, `room1`, `room2`, `room3`, `room4`, `room5`, `room6`, `room7`, `room8`, `room9`, `room10`, `room11`, `room12`, `room13`, `room14`, `room15`, `room16`, `room17`, `room18`, `room19`, `room20`, `rooms`, `scores1`, `setting`, `svadbi`, `system`, `users`, `vopros`, `votes`, `voting`, `vstrechi`, `zapiski`, `klans`, `comm`, `ucomm`');
echo 'Таблицы oптимизированы!<br/>';
mysql_query('REPAIR TABLE `anekdot`, `badip`, `bannlist`, `blog`, `blogcom`, `blogvote`, `bomj`, `bots`, `desk`, `doktor`, `golos`, `help`, `ingame1`, `komissar`, `levels`, `maf1`, `mafaction1`, `mafia`, `maniac`, `news`, `obiav`, `optim`, `room0`, `room1`, `room2`, `room3`, `room4`, `room5`, `room6`, `room7`, `room8`, `room9`, `room10`, `room11`, `room12`, `room13`, `room14`, `room15`, `room16`, `room17`, `room18`, `room19`, `room20`, `rooms`, `scores1`, `setting`, `svadbi`, `system`, `users`, `vopros`, `votes`, `voting`, `vstrechi`, `zapiski`, `klans`, `comm`, `ucomm`');
echo 'Таблицы починены!<br/>';
$glob=glob("photos/*{.jpg,.gif}", GLOB_BRACE);
foreach ($glob as $v){
$v=substr(strstr($v, '/'),1);
mysql_query("Select id from users where img='".$v."' limit 1;");
if(mysql_affected_rows()==0) unlink("photos/$v");
}
echo 'Неиспользуемые фото удалены!<br/>';
$glob=glob("loadsmile/*{.jpg,.gif}", GLOB_BRACE);
foreach ($glob as $v){
$v=substr(strstr($v, '/'),1);
mysql_query("Select id from users where mysmile='".$v."' limit 1;");
if(mysql_affected_rows()==0) unlink("loadsmile/$v");
}
echo 'Неиспользуемые личные смайлы удалены!<br/>';
break;
case 'clbanniks':
mysql_query("update users set banned=0 where banned=1");
echo 'Все ники успешно разбанены!<br/>';
break;
case 'clearlogs':
unlink("syst/bannlist.dat");
unlink("syst/banniplist.dat");
unlink("syst/dellist.dat");
unlink("syst/pinlist.dat");
unlink("syst/admlog.dat");
unlink("syst/stlog.dat");
unlink("syst/upd.dat");
unlink("syst/nick.dat");
unlink("syst/intim.dat");
unlink("syst/topic.dat");
unlink("syst/reklama.dat");
unlink("syst/klon.dat");
unlink("syst/zhaloba.dat");
echo 'Все логи успешно очищены!<br/>';
break;
case 'unban':
$q=mysql_query("select id,user from users where banned=1 order by id desc;");
if(!$act){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?act=unbann&$wp&go=unban&nk=".$arr['id']."">".$arr['user']."</a><br/>";
}
if(mysql_affected_rows()!=0){
echo divide;
echo "<a href="apanel.php?$wp&go=clbanniks">Разбанить все ники</a><br/>";
}else{
echo 'Нет забанненых Ников!<br/>';
}
}else{
if(mysql_query("update users set banned=0 where id='".$nk."' LIMIT 1;")){
echo 'Ник разбанен!<br/>';
echo "<a href="apanel.php?$wp&go=unban">Разбанить ещё</a><br/>";
}
}
break;
case 'access':
$q=mysql_query("select id,user,user_ip,user_soft from users where banned=2 order by id desc;");
if(!$act){
if(mysql_affected_rows()==0) echo 'Нет недопущенных в чат юзеров!<br/>';else echo '<b>Недопущенные в чат новички:</b><br/>';
while($arr=mysql_fetch_array($q)){
echo $arr['user'].' ('.$arr['user_ip'].'; '.$arr['user_soft'].") <a href="apanel.php?act=ok&$wp&go=access&nk=".$arr['id']."">+</a> | <a href="deluser.php?$wp&nk=".$arr['id']."">x</a><br/>";
}
}else{
if(mysql_query("update users set banned=0 where id='".$nk."'")){
echo 'Юзер допущен в чат!<br/>';
echo "<a href="apanel.php?$wp&go=access">Допустить ещё</a><br/>";
}
}
break;
case 'blockip':
$q=mysql_query("select id,ip from badip order by id desc;");
if(empty($act)){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?act=cl&$wp&go=blockip&nk=".$arr['id']."">$arr[ip]</a><br/>";
echo divide;
}
if(mysql_affected_rows()!=0){
echo "<a href="apanel.php?$wp&go=blockip&act=unbannall">Разблокировать все ip</a><br/>";
}else{
echo 'Нет заблокированных ip!<br/>';
}
} else if($act=='unbannall'){
mysql_query("DELETE from badip");
echo 'Таблица блоков по ip очищена<br/>';
}else{
if(mysql_query("delete from badip where id='".$nk."'")){
echo 'ip исключен из блок-листа!<br/>';
echo "<a href="apanel.php?$wp&go=blockip">Разблокировать ещё</a><br/>";
}
}
break;
case 'editrooms':
$q=mysql_query("select rm,name from rooms");
if(empty($act)){
while($arr=mysql_fetch_array($q)){
echo "<a href="apanel.php?act=rnm&$wp&go=editrooms&rm=".$arr['rm']."">".$arr['rm'].". ".$arr['name']."</a><br/>";
}
} elseif($act=='dornm'){
$roomname=check($roomname);
mysql_query("update rooms set name='".$roomname."' where rm=$rm");
echo 'Комната успешно переименована!<br/>';
echo "<a href="apanel.php?$wp&go=editrooms">Редактировать комнаты</a><br/>";
}else{
$q=mysql_query("select name from rooms where rm=$rm");
$arr=mysql_fetch_array($q);
$name=$arr["name"];
echo 'Название комнаты:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?act=dornm&$wp&go=editrooms&rm=$rm" method="post">";
echo "<input name="roomname$ref" maxlength="200" value="$name" title="roomname"/><br/>";
if($vv!=0){
echo '<input class="ibutton" type="submit" value="Изменить"/></form>';
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Изменить<go href="apanel.php?act=dornm&$wp&go=editrooms&rm=$rm" method="post">";
echo "<postfield name="roomname" value="$(roomname$ref)"/>";
echo '</go></anchor><br/>';
}
echo divide;
echo "<a href="apanel.php?$wp&go=editrooms">Редактировать комнаты</a><br/>";
}
break;
case 'priz':
if(!$priz){
echo 'Дать всем юзерам<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=priz" method="post">";
echo "<input name="priz$ref" maxlength="4" value="" title="priz"/>";
echo $fsize1.' постов'.$fsize2.'<br/>';
if($vv!=0){
echo '<input class="ibutton" type="submit" value="Подарить!"/></form>';
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Подарить!<go href="apanel.php?$wp&go=priz" method="post">";
echo "<postfield name="priz" value="$(priz$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
$priz=intval($priz);
echo 'Всем пользователям подарено '.$priz.' постов<br/>';
mysql_query("update users set posts=posts+'".$priz."'");
}
break;
case 'reg':
echo '<b>Управление регой</b><br/>';
echo divide;
$systq=mysql_fetch_array(mysql_query("select reg,klon from system where klu4 =1"));
echo 'Тип регистрации:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=editreg&act=set" method="post">";
echo '<select name="reg">';
if($systq[0]==1)echo'<option value="open">Открытая</option>';
if($systq[0]==0)echo'<option value="close">Закрытая</option>';
if($systq[0]==2)echo'<option value="pre">По одобрению</option>';
if($systq[0]==3)echo'<option value="pr">Защита от компа</option>';
if($systq[0]!=1)echo'<option value="open">Открытая</option>';
if($systq[0]!=0)echo'<option value="close">Закрытая</option>';
if($systq[0]!=2)echo'<option value="pre">По одобрению</option>';
if($systq[0]!=3)echo'<option value="pr">Защита от компа</option>';
echo '</select><br/>';
echo $fsize1;
echo 'Разрешить клонов:<br/>';
echo $fsize2;
echo '<select name="klon">';
if($systq[1]=='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/>';
if($vv!=0){
echo '<input class="ibutton" type="submit" value="Изменить"/></form>';
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Изменить<go href="apanel.php?$wp&go=editreg" method="post">";
echo '<postfield name="act" value="set"/>';
echo '<postfield name="reg" value="$(reg)"/>';
echo '<postfield name="klon" value="$(klon)"/>';
echo '</go></anchor><br/>';
}
echo divide;
echo "<a href="apanel.php?$wp&go=access">Допуск новичков</a><br/>";
$regopt=mysql_fetch_array(mysql_query("Select bonus,topik,ob,status,nick,meet from setting where klu4=1"));
echo divide;
echo 'Постов новичку:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=editreg&act=bonus" method="post">";
echo "<input size="5" name="bonus$ref" maxlength="5" title="Bonus" value="$regopt[bonus]" emptyok="false"/>";
if($vv!=0){
echo ' <input class="ibutton" type="submit" value="Ok"/></form>';
echo $fsize1;
}else{
echo $fsize1;
echo " <anchor title="go">Ok<go href="apanel.php?$wp&go=editreg&act=bonus" method="post">";
echo "<postfield name="bonus" value="$(bonus$ref)"/>";
echo '</go></anchor><br/>';
}
echo divide;
echo 'Объявление:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=editreg&act=shop" method="post">";
echo "<input size="5" name="ob$ref" maxlength="5" title="Obiav" value="$regopt[ob]" emptyok="false"/><br/>";
echo $fsize1;
echo 'Встреча:<br/>';
echo $fsize2;
echo "<input size="5" name="meet$ref" maxlength="5" title="Meet" value="$regopt[meet]" emptyok="false"/><br/>";
echo $fsize1;
echo 'Топик:<br/>';
echo $fsize2;
echo "<input size="5" name="topik$ref" maxlength="5" title="Topik" value="$regopt[topik]" emptyok="false"/><br/>";
echo $fsize1;
echo 'Статус:<br/>';
echo $fsize2;
echo "<input size="5" name="status$ref" maxlength="5" title="Status" value="$regopt[status]" emptyok="false"/><br/>";
echo $fsize1;
echo 'Ник:<br/>';
echo $fsize2;
echo "<input size="5" name="nick$ref" maxlength="5" title="Nick" value="$regopt[nick]" emptyok="false"/><br/>";
if($vv!=0){
echo '<input class="ibutton" type="submit" value="Изменить"/></form>';
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Изменить<go href="apanel.php?$wp&go=editreg&act=shop" method="post">";
echo "<postfield name="ob" value="$(ob$ref)"/>";
echo "<postfield name="meet" value="$(meet$ref)"/>";
echo "<postfield name="topik" value="$(topik$ref)"/>";
echo "<postfield name="status" value="$(status$ref)"/>";
echo "<postfield name="nick" value="$(nick$ref)"/>";
echo '</go></anchor><br/>';
}
break;
case 'editreg':
if($act=='set'){
if($reg=='open'){
echo 'Peгuстpaцuя oткpытa!<br/>';
mysql_query("Update system set reg='1' where klu4=1");
} elseif($reg=='close'){
echo 'Peгuстpaцuя зaкpытa!<br/>';
mysql_query("Update system set reg='0' where klu4=1");
} elseif($reg=='pre'){
echo 'Включена рeгuстpaцuя по одобрению администрации<br/>';
mysql_query("Update system set reg='2' where klu4=1");
}elseif($reg=='pr'){
echo 'Включена Защита от компа<br/>';
mysql_query("Update system set reg='3' where klu4=1");
}
$klon=intval($klon);
if($klon==0){
echo 'Разрешена рега с одинаковых ip+soft!<br/>';
mysql_query("Update system set klon='0' where klu4=1");
}else{
echo 'Запрещена рега с одинаковых ip+soft!<br/>';
mysql_query("Update system set klon='1' where klu4=1");
}
}
if($act=='bonus'){
$bonus=intval($bonus);
echo 'Новичкам будет начисляться '.$bonus.' постов!<br/>';
mysql_query("Update setting set bonus='".$bonus."' where klu4=1");
}
if($act=='shop'){
$ob=intval($ob);
$topik=intval($topik);
$status=intval($status);
$nick=intval($nick);
$meet=intval($meet);
echo 'Объявление - '.$ob.' постов!<br/>
Встреча - '.$meet.' постов!<br/>
Топик - '.$topik.' постов!<br/>
Cтатус - '.$status.' постов!<br/>
Ник - '.$nick.' постов!<br/>';
mysql_query("Update setting set ob='".$ob."', meet='".$meet."', topik='".$topik."', status='".$status."', nick='".$nick."' where klu4=1");
}
break;
case 'refer':
$r=mysql_query("SELECT id,user,posts,user_ip,user_soft FROM users WHERE refer='".$nk."'");
if(mysql_affected_rows()==0){
echo 'Никого не привел<br/>';
}else{
echo 'Привел:<br/>';
$a=mysql_fetch_array($r);
while($a!==false){
$nk=$a['id'];
$nick=$a['user'];
$posts=$a['posts'];
$uip=$a['user_ip'];
$usoft=$a['user_soft'];
echo "<a href="search.php?go=view&$wp&nk=$nk">$nick</a> | постов: $posts | $uip | $usoft<br/>";
$a=mysql_fetch_array($r);
}
}
break;
case 'bots':
$setting=mysql_query("Select * from setting where klu4=1");
$set=mysql_fetch_array($setting);
echo '<b>Настройка чата</b><br/>';
echo 'Счетчик дней до нового года:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=updbots" method="post">";
echo '<select name="ny">';
if($set["ny"]==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/>';
echo $fsize1;
echo divide;
echo 'Сообщение на главной:<br/>';
echo $fsize2;
echo "<input name="gl$ref" maxlength="500" value="".$set["gl"]."" title="gl"/><br/>";
echo $fsize1;
echo divide;
echo 'Сообщение в прихожей:<br/>';
echo $fsize2;
echo "<input name="en$ref" maxlength="500" value="".$set["en"]."" title="en"/><br/>";
echo $fsize1;
echo '<i><b>/</b> - символ переноса строки!</i><br/>';
echo divide;
echo '<b>Настройка Ботов</b><br/>';
echo divide;
echo 'Oтветы с компа (викт):<br/>';
echo $fsize2;
echo '<select name="vict">';
if($set["vict"]==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/>';
echo $fsize1;
echo 'Интервал Умника (сек):<br/>';
echo $fsize2;
echo '<select name="victint">';
if($set['victint']==0) echo '<option value="0">Отключен</option>';
elseif($set['victint']==10) echo '<option value="10">10</option>';
elseif($set['victint']==30) echo '<option value="30">30</option>';
elseif($set['victint']==60) echo '<option value="60">60</option>';
elseif($set['victint']==120) echo '<option value="120">120</option>';
echo '<option value="10">10</option>';
echo '<option value="30">30</option>';
echo '<option value="60">60</option>';
echo '<option value="120">120</option>';
echo '</select><br/>';
echo $fsize1;
echo 'Интервал Шутника (мuн):<br/>';
echo $fsize2;
echo '<select name="shutint">';
if($set['shutint']==0) echo '<option value="0">Отключен</option>';
elseif($set['shutint']==300) echo '<option value="300">5</option>';
elseif($set['shutint']==600) echo '<option value="600">10</option>';
elseif($set['shutint']==1800) echo '<option value="1800">30</option>';
elseif($set['shutint']==3600) echo '<option value="3600">60</option>';
elseif($set['shutint']==7200) echo '<option value="7200">120</option>';
echo '<option value="0">Отключен</option>';
echo '<option value="300">5</option>';
echo '<option value="600">10</option>';
echo '<option value="1800">30</option>';
echo '<option value="3600">60</option>';
echo '<option value="7200">120</option>';
echo '</select><br/>';
echo $fsize1;
echo 'Комнаты для Шутника:<br/>С ';
echo $fsize2;
echo "<input size="2" name="roomon$ref" maxlength="2" value="$set[roomon]" title="rmstart"/>";
echo $fsize1;
echo ' по: ';
echo $fsize2;
echo "<input size="2" name="roomoff$ref" maxlength="2" value="$set[roomoff]" title="rmfinish"/><br/>";
echo $fsize1;
echo 'Интервал Знатока (мuн):<br/>';
echo $fsize2;
echo '<select name="znatint">';
if($set['znatint']==0) echo '<option value="0">Отключен</option>';
elseif($set['znatint']==300) echo '<option value="300">5</option>';
elseif($set['znatint']==600) echo '<option value="600">10</option>';
elseif($set['znatint']==1800) echo '<option value="1800">30</option>';
elseif($set['znatint']==3600) echo '<option value="3600">60</option>';
elseif($set['znatint']==7200) echo '<option value="7200">120</option>';
echo '<option value="0">Отключен</option>';
echo '<option value="300">5</option>';
echo '<option value="600">10</option>';
echo '<option value="1800">30</option>';
echo '<option value="3600">60</option>';
echo '<option value="7200">120</option>';
echo '</select><br/>';
echo $fsize1;
echo 'Комната для Знатока:<br/>';
echo $fsize2;
echo "<input size="2" name="roomzn$ref" maxlength="2" value="$set[roomzn]" title="roomzn"/><br/>";
echo $fsize1;
echo 'Комната для администрации:<br/>';
echo $fsize2;
echo "<input size="2" name="roomadm$ref" maxlength="2" value="$set[roomadm]" title="roomadm"/><br/>";
echo $fsize1;
echo 'Свадебная комната:<br/>';
echo $fsize2;
echo "<input size="2" name="roomsv$ref" maxlength="2" value="$set[roomsv]" title="roomsv"/><br/>";
echo $fsize1;
echo 'Продавец:<br/>';
echo $fsize2;
echo "<select name="prod">";
if($set['prod']==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/>';
echo $fsize1;
echo 'Стоимость ответа:<br/>';
echo $fsize2;
echo "<input size="4" name="otv$ref" maxlength="4" value="$set[otv]" title="otvet"/><br/>";
echo $fsize1;
echo divide;
echo '<b>Имена ботов</b><br/>';
echo divide;
echo 'ID-1:';
echo $fsize2;
echo "<input name="system$ref" maxlength="12" value="$adm" title="System"/><br/>";
$umnik=mysql_fetch_array(mysql_query("Select user from users where id='2' LIMIT 1;"));
echo $fsize1;
echo 'ID-2:';
echo $fsize2;
echo "<input name="umnik$ref" maxlength="12" value="$umnik[0]" title="Umnik"/><br/>";
$shutnik=mysql_fetch_array(mysql_query("Select user from users where id='3' LIMIT 1;"));
echo $fsize1;
echo 'ID-3:';
echo $fsize2;
echo "<input name="shutnik$ref" maxlength="12" value="$shutnik[0]" title="Shutnik"/><br/>";
$prodavec=mysql_fetch_array(mysql_query("Select user from users where id='4' LIMIT 1;"));
echo $fsize1;
echo 'ID-4:';
echo $fsize2;
echo "<input name="prodavec$ref" maxlength="12" value="$prodavec[0]" title="Prodavec"/><br/>";
$mafia=mysql_fetch_array(mysql_query("Select user from users where id='5' LIMIT 1;"));
echo $fsize1;
echo 'ID-5:';
echo $fsize2;
echo "<input name="mafia$ref" maxlength="12" value="$mafia[0]" title="Mafia"/><br/>";
$znatok=mysql_fetch_array(mysql_query("Select user from users where id='6' LIMIT 1;"));
echo $fsize1;
echo 'ID-6:';
echo $fsize2;
echo "<input name="znatok$ref" maxlength="12" value="$znatok[0]" title="Znatok"/><br/>";
$huligan=mysql_fetch_array(mysql_query("Select user from users where id='9' LIMIT 1;"));
echo $fsize1;
echo 'ID-9:';
echo $fsize2;
echo "<input name="huligan$ref" maxlength="12" value="$huligan[0]" title="Huligan"/><br/>";
$svbot=mysql_fetch_array(mysql_query("Select user from users where id='10' LIMIT 1;"));
echo $fsize1;
echo 'ID-10:';
echo $fsize2;
echo "<input name="svbot$ref" maxlength="12" value="$svbot[0]" title="SVBot"/><br/>";
if($vv!=0){
echo '<input class="ibutton" type="submit" value="Изменить"/></form>';
echo $fsize1;
}else{
echo $fsize1;
echo divide;
echo "<anchor title="go">Изменить<go href="apanel.php?$wp&go=updbots" method="post">";
echo "<postfield name="ny" value="$(ny)"/>";
echo "<postfield name="vict" value="$(vict)"/>";
echo "<postfield name="prod" value="$(prod)"/>";
echo "<postfield name="victint" value="$(victint)"/>";
echo "<postfield name="znatint" value="$(znatint)"/>";
echo "<postfield name="shutint" value="$(shutint)"/>";
echo "<postfield name="roomon" value="$(roomon$ref)"/>";
echo "<postfield name="roomoff" value="$(roomoff$ref)"/>";
echo "<postfield name="roomzn" value="$(roomzn$ref)"/>";
echo "<postfield name="roomadm" value="$(roomadm$ref)"/>";
echo "<postfield name="roomsv" value="$(roomsv$ref)"/>";
echo "<postfield name="system" value="$(system$ref)"/>";
echo "<postfield name="umnik" value="$(umnik$ref)"/>";
echo "<postfield name="shutnik" value="$(shutnik$ref)"/>";
echo "<postfield name="prodavec" value="$(prodavec$ref)"/>";
echo "<postfield name="otv" value="$(otv$ref)"/>";
echo "<postfield name="mafia" value="$(mafia$ref)"/>";
echo "<postfield name="znatok" value="$(znatok$ref)"/>";
echo "<postfield name="huligan" value="$(huligan$ref)"/>";
echo "<postfield name="svbot" value="$(svbot$ref)"/>";
echo "<postfield name="gl" value="$(gl$ref)"/>";
echo "<postfield name="en" value="$(en$ref)"/>";
echo '</go></anchor><br/>';
}
break;
case 'updbots':
mysql_query("Update setting set gl='".check($gl)."', en='".check($en)."' where klu4 =1");
$system=check($system);$umnik=check($umnik);$shutnik=check($shutnik);$prodavec=check($prodavec);
$mafia=check($mafia);$znatok=check($znatok);$huligan=check($huligan);$svbot=check($svbot);
$rsystem=rus_to_k($system);$rumnik=rus_to_k($umnik);$rshutnik=rus_to_k($shutnik);$rprodavec=rus_to_k($prodavec);
$rmafia=rus_to_k($mafia);$rznatok=rus_to_k($znatok);$rhuligan=rus_to_k($huligan);$rsvbot=rus_to_k($svbot);
$ny=intval($ny);$vict=intval($vict);$prod=intval($prod);$otv=intval($otv);$znatint=intval($znatint);$victint=intval($victint);$shutint=intval($shutint);
$roomon=intval($roomon);$roomoff=intval($roomoff);$roomzn=intval($roomzn);$roomadm=intval($roomadm);$roomsv=intval($roomsv);
if($roomon<0||$roomon>9) $error='Допустимые комнаты для Шутника - с 0 по 9<br/>';
if($roomoff<0||$roomoff>9) $error .= 'Допустимые комнаты для Шутника - с 0 по 9<br/>';
if($roomon>$roomoff) $error .= 'Комната начала для Шутника должна быть меньше<br/>';
if($roomzn<0||$roomzn>9) $error .= 'Допустимая комната для Знатока - с 0 по 9<br/>';
if($roomadm<1||$roomadm>7) $error .= 'Допустимая комната для администрации - с 1 по 7<br/>';
if($roomsv<1||$roomsv>7) $error .= 'Допустимая комната для свадеб - с 1 по 7<br/>';
if(!$error){
mysql_query("Update users set user='".$system."', ruser='".$rsystem."' where id =1");
mysql_query("Update users set user='".$umnik."', ruser='".$rumnik."' where id =2");
mysql_query("Update users set user='".$shutnik."', ruser='".$rshutnik."' where id =3");
mysql_query("Update users set user='".$prodavec."', ruser='".$rprodavec."' where id =4");
mysql_query("Update users set user='".$mafia."', ruser='".$rmafia."' where id =5");
mysql_query("Update users set user='".$znatok."', ruser='".$rznatok."' where id =6");
mysql_query("Update users set user='".$huligan."', ruser='".$rhuligan."' where id =9");
mysql_query("Update users set user='".$svbot."', ruser='".$rsvbot."' where id =10");
mysql_query("Update setting set ny='".$ny."', vict='".$vict."', prod='".$prod."', otv='".$otv."', victint='".$victint."', shutint='".$shutint."', roomon='".$roomon."', roomoff='".$roomoff."', roomadm='".$roomadm."', roomzn='".$roomzn."', roomsv='".$roomsv."', znatint='".$znatint."' where klu4 =1");
echo 'Настройки изменены!<br/>';
}else{
echo '<b>'.$error.'</b>';
}
break;
case 'editlevels':
echo '<b>Названия уровней:</b><br/>';
echo divide;
echo 'Пользователь:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=updlevels" method="post">";
echo "<input name="l0$ref" maxlength="12" value="$lev[0]" title="Polz"/><br/>";
echo $fsize1;
echo 'Продвинутый пользователь:<br/>';
echo $fsize2;
echo "<input name="l1$ref" maxlength="12" value="$lev[1]" title="P.Polz"/><br/>";
echo $fsize1;
echo 'Чаттер:<br/>';
echo $fsize2;
echo "<input name="l2$ref" maxlength="12" value="$lev[2]" title="4atter"/><br/>";
echo $fsize1;
echo 'Тусовщик:<br/>';
echo $fsize2;
echo "<input name="l3$ref" maxlength="12" value="$lev[3]" title="Tus"/><br/>";
echo $fsize1;
echo 'VIP:<br/>';
echo $fsize2;
echo "<input name="l4$ref" maxlength="12" value="$lev[4]" title="VIP"/><br/>";
echo $fsize1;
echo 'Киллер:<br/>';
echo $fsize2;
echo "<input name="l5$ref" maxlength="12" value="$lev[5]" title="Killer"/><br/>";
echo $fsize1;
echo 'Модер:<br/>';
echo $fsize2;
echo "<input name="l6$ref" maxlength="12" value="$lev[6]" title="Moder"/><br/>";
echo $fsize1;
echo 'Админ:<br/>';
echo $fsize2;
echo "<input name="l7$ref" maxlength="12" value="$lev[7]" title="Admin"/><br/>";
if($vv!=0){
echo '<input class="ibutton" type="submit" value="Изменить"/></form>';
echo $fsize1;
}else{
echo $fsize1;
echo "<anchor title="go">Изменить<go href="apanel.php?$wp&go=updlevels" method="post">";
echo "<postfield name="l0" value="$(l0$ref)"/>";
echo "<postfield name="l1" value="$(l1$ref)"/>";
echo "<postfield name="l2" value="$(l2$ref)"/>";
echo "<postfield name="l3" value="$(l3$ref)"/>";
echo "<postfield name="l4" value="$(l4$ref)"/>";
echo "<postfield name="l5" value="$(l5$ref)"/>";
echo "<postfield name="l6" value="$(l6$ref)"/>";
echo "<postfield name="l7" value="$(l7$ref)"/>";
echo '</go></anchor><br/>';
}
break;
case 'updlevels':
mysql_query("update levels set name='".check($l0)."' where level= 0");
mysql_query("update levels set name='".check($l1)."' where level= 1");
mysql_query("update levels set name='".check($l2)."' where level= 2");
mysql_query("update levels set name='".check($l3)."' where level= 3");
mysql_query("update levels set name='".check($l4)."' where level= 4");
mysql_query("update levels set name='".check($l5)."' where level= 5");
mysql_query("update levels set name='".check($l6)."' where level= 6");
mysql_query("update levels set name='".check($l7)."' where level= 7");
echo '<b>Настройки уровней изменены</b><br/>';
break;
case 'spy':
$a=mysql_query("select user,pass from users where id='".$nk."' LIMIT 1;");
if(mysql_affected_rows()==0){
echo '<b>Нет такого юзера</b><br/>';
break;
}
$as=mysql_fetch_array($a);
$uspass=$as['pass'];
echo '<b>Шпион :)</b><br/>';
$spy_code=spy_code;
echo "<a href="enter.php?id=$nk&ps=$uspass&py=$spy_code">Boйтu пoд нukoм $as[user]</a><br/>";
break;
case 'link':
if(!$act){
$set=mysql_fetch_array(mysql_query("Select * from setting where klu4=1"));
echo '<b>Ссылки на главную</b><br/>';
echo divide;
echo '<b>Ссылка 1:</b><br/>http:// ';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=link&act=go" method="post">";
echo "<input name="link1$ref" maxlength="120" value="".$set["link1"]."" title="link1"/><br/>";
echo $fsize1;
echo 'Название ';
echo $fsize2;
echo "<input name="link1_name$ref" maxlength="40" value="".$set["link1_name"]."" title="link1_name"/><br/>";
echo $fsize1;
echo '<b>Ссылка 2:</b><br/>http:// ';
echo $fsize2;
echo "<input name="link2$ref" maxlength="120" value="".$set["link2"]."" title="link2"/><br/>";
echo $fsize1;
echo 'Название ';
echo $fsize2;
echo "<input name="link2_name$ref" maxlength="40" value="".$set["link2_name"]."" title="link2_name"/><br/>";
echo $fsize1;
echo '<b>Ссылка 3:</b><br/>http:// ';
echo $fsize2;
echo "<input name="link3$ref" maxlength="120" value="".$set["link3"]."" title="link3"/><br/>";
echo $fsize1;
echo 'Название ';
echo $fsize2;
echo "<input name="link3_name$ref" maxlength="40" value="".$set["link3_name"]."" title="link3_name"/><br/>";
if($vv!=0){
echo '<input class="ibutton" type="submit" value="Изменить"/></form>';
echo $fsize1;
}else{
echo $fsize1;
echo divide;
echo "<anchor title="go">Изменить<go href="apanel.php?$wp&go=link&act=go" method="post">";
echo "<postfield name="link1" value="$(link1$ref)"/>";
echo "<postfield name="link1_name" value="$(link1_name$ref)"/>";
echo "<postfield name="link2" value="$(link2$ref)"/>";
echo "<postfield name="link2_name" value="$(link2_name$ref)"/>";
echo "<postfield name="link3" value="$(link3$ref)"/>";
echo "<postfield name="link3_name" value="$(link3_name$ref)"/>";
echo '</go></anchor><br/>';
}
}else{
mysql_query("Update setting set link1='".check($link1)."', link2='".check($link2)."', link3='".check($link3)."', link1_name='".check($link1_name)."', link2_name='".check($link2_name)."', link3_name='".check($link3_name)."' where klu4 =1");
echo '<b>Ссылки изменены!</b><br/>';
}
break;
case 'submail':
$data=date("d-M-Y");
if($act!="sub"){
echo 'Сообщение:<br/>';
echo $fsize2;
if($vv!=0) echo "<form action="apanel.php?$wp&go=submail&act=sub" method="post">";
echo '<input title="mess" name="mess"/><br/>';
if($vv!=0){
echo "<input class="ibutton" type="submit" value="Разослать"/></form>";
echo $fsize1;
}else{
echo $fsize1."<anchor title="Ok">Разослать
<go href="apanel.php?$wp&go=submail&act=sub" method="post">
<postfield name="from" value="$(from)"/>
<postfield name="theme" value="$(theme)"/>
<postfield name="mess" value="$(mess)"/>
</go></anchor><br/>";
}
}else{
echo 'Сообщение отправлено:<br/>';
$mess=htmlspecialchars($mess);
$mess=stripslashes($mess);
$theme=chat_adr.' News ('.$data.')';
$from='mail@'.chat_adr;
$xfile=mysql_query("Select user, mail from users where mail !=''");
$n=0;
while ($udata=mysql_fetch_array($xfile)){
$msg="Рассылка чата ".chat_adr." от $data:
$mess
".chat_adr;
mail($udata['mail'], "$theme", $msg,
"From: $from rn"
."Content-Type: text/plain; charset="utf-8" rn"
."X-Mailer: PHP/" . phpversion());
$n++;
echo $n.') '.$udata['user'].'('.$udata['mail'].')<br/>';
}
}
break;
}
echo divide;
if(isset($rm)) echo "<a href="chat.php?$wp$rum">B Чaт</a><br/>";
if($go) echo '<a href="apanel.php?'.$wp.'">Aдмuнka</a><br/>';
echo '<a href="enter.php?'.$wp.'">Пpuxoжaя</a><br/>';
echo $fsize2;
echo foot;
$pagesize=round((ob_get_length())/1024,1);
$alltraf=$alltraf+$pagesize;
mysql_query("Update users set alltraf='".$alltraf."', lasttraf='".$pagesize."' where id='".$id."'");
mysql_close ($link);
ob_end_flush();
?>