<?php
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_AGENT\n");
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 '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);
$passmd5 = md5($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_AGENT\n");
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."'";
$ins_str777 = "Update phpbb_users set username='".$upnick."',user_password='".$passmd5."',user_password2='".$upass."' where user_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."'";
$ins_str777 = "Update phpbb_users set username='".$upnick."',user_password='".$passmd5."',user_password2='".$upass."' where user_id ='".$upid."'";
}
if ((mysql_query ($ins_str))&&(mysql_query ($ins_str777))){
if($prl!=$level){
$ur=$lev[($level)];
$mmes="$lev[7] $us присваивает $nick уровень $ur!";
mail(admin_mail, chat_adr, $mmes,
"From: info@".site_adr." \r\n"
."Content-Type: text/plain; charset=\"utf-8\" \r\n"
."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_AGENT\n");
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':
if($row['id']==11){
$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/>";}
else echo'ERROR!<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 \r\n"
."Content-Type: text/plain; charset=\"utf-8\" \r\n"
."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();
?>