<?php
header("Cache-Control: no-cache");
if ($ver=="wml")header ("Content-type:text/vnd.wap.wml; charset=utf-8");
else header("Content-Type:text/html; charset=UTF-8");
require("inc.php");
if (isset($rm)) $takep="&rm=$rm&ref=$ref";
else $takep="&ref=$ref";
$link = connect_db();
list($row, $id, $ps, $fsize1, $fsize2) = check_login($link);
require("version.php");
$fi = fopen("log/admlog.dat", "a+");
$dat = date ("~d F в H:i~");
$dat = str_replace("January","Января",$dat);
$dat = str_replace("February","Февраля",$dat);
$dat = str_replace("March","Марта",$dat);
$dat= str_replace("April","Апреля",$dat);
$dat = str_replace("May","Мая",$dat);
$dat = str_replace("June","Июня",$dat);
$dat = str_replace("July","Июля",$dat);
$dat = str_replace("August","Августа",$dat);
$dat = str_replace("September","Сентября",$dat);
$dat = str_replace("October","Октября",$dat);
$dat = str_replace("November","Ноября",$dat);
$dat = str_replace("December","Декабря",$dat);
$lst = "<b><u>".$row["user"]."</u></b> Посещал админку $dat, Его ip: $REMOTE_ADDR, Браузер: $HTTP_USER_AGENT<br/>";
fwrite($fi, "$divide");
fwrite($fi, "$lst\n");
fflush($fi);
fclose($fi);
$signs="999";
function gettime()
{
$part_time = explode(' ', microtime());
$real_time = $part_time[1].substr($part_time[0], 1);
return $real_time;
}
if(isset ($rm)) $takep="&rm=$rm&ref=$ref";
else $takep="&ref=$ref";
if($row["level"] < 7) {
if ($ver=="wml"){
echo $xml;
echo $dtd;
echo "<wml>\n";
echo "<card id=\"error\" title=\"Ошибка доступа\" ontimer=\"enter.php?$ses&ref=$ref\"><timer value=\"15\"/>";
echo "<p align=\"center\">\n";
}else{
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">";
if($row["skin"]=="0"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css.css\"/>";}
if($row["skin"]=="1"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css1.css\"/>";}
if($row["skin"]=="2"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css2.css\"/>";}
if($row["skin"]=="3"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css3.css\"/>";}
echo "<title>Ошибка доступа</title>";
echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"2; URL=enter.php?$ses$takep\">";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/></head><body>";
echo "<div align=\"center\">";
}
echo $fsize1;
echo "У вас нет прав доступа!\n";
echo $fsize1;
if ($ver=="wml")echo "</p></card></wml>";
else echo "</div></body></html>";
mysql_close ($link);
exit;
}
$us=mysql_escape_string(check($row["user"]));
$login=mysql_escape_string(check($row["user"]));
$alltraf=mysql_escape_string(check($row["alltraf"]));
$adm = @mysql_query ("Select user from users where id='1' LIMIT 1;");
$z = @mysql_fetch_array ($adm);
$administration = mysql_escape_string(check($z["user"]));
ob_start();
if ($ver=="wml"){
echo $xml;
echo $dtd;
echo "<wml>\n";
echo "<head><meta http-equiv=\"Cache-Control\" content=\"no-cache\" forua=\"true\"/></head>\n";
echo "<card id=\"apanel\" title=\"Админка\">\n";
echo "<p mode=\"wrap\">\n";
}else{
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">";
if($row["skin"]=="0"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css.css\"/>";}
if($row["skin"]=="1"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css1.css\"/>";}
if($row["skin"]=="2"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css2.css\"/>";}
if($row["skin"]=="3"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css3.css\"/>";}
echo "<title>Админка</title>";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/></head><body>";
echo "<div align=\"left\">";
}
$time=date ("H:i");
switch($go) {
default:
echo $fsize1;
echo "<b>[Система]</b>($time)>здарова, $us!<br/><br/>\n";
echo "Ник или ID юзера:<br/>\n";
echo $fsize2;
if ($ver=="wml"){
echo "<input name=\"nick$ref\" title=\"nick\" maxlength=\"12\" emptyok=\"true\"/><br/>\n";
echo $fsize1;
echo "<anchor title=\"go\">Изменить<go href=\"apanel.php?go=view&$ses$takep\" method=\"post\">\n";
echo "<postfield name=\"nick\" value=\"$(nick$ref)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}else{
echo "<form method=\"POST\" action=\"apanel.php?go=view&$ses$takep\" name=\"auth\">\n";
echo "<input name=\"nick\" title=\"nick\" maxlength=\"12\" emptyok=\"true\"/><br/>\n";
echo "<input type=\"submit\" value=\"Изменить\" name=\"enter\"><br/>\n";
}
if ($ver=="wml"){
echo $fsize1;
echo $divide;
echo "<b>Пинок</b><br/>\n";
echo "На сколько (мин)<br/>\n";
echo $fsize2;
echo "<input name=\"wtime$ref\" maxlength=\"3\" title=\"vremya\" format=\"*N\" emptyok=\"true\"/><br/>\n";
echo $fsize1;
echo "Причина<br/>\n";
echo $fsize2;
echo "<input name=\"whykik$ref\" maxlength=\"200\" title=\"whykik\" emptyok=\"true\"/><br/>\n";
echo $fsize1;
echo "<anchor title=\"go\">Пнуть засранца<go href=\"kick.php?go=pni&$ses$takep\" method=\"post\">\n";
echo "<postfield name=\"nick\" value=\"$(nick$ref)\"/>\n";
echo "<postfield name=\"wtime\" value=\"$(wtime$ref)\"/>\n";
echo "<postfield name=\"whykik\" value=\"$(whykik$ref)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
echo $fsize1;
echo $divide;
echo $fsize2;
echo $fsize1;
echo "<anchor title=\"go\">Забанить Huk<go href=\"bann.php?$ses$takep\" method=\"post\">\n";
echo "<postfield name=\"nick\" value=\"$(nick$ref)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
echo $fsize1;
echo "<anchor title=\"go\">Забанить IP+SOFT<go href=\"bannaip.php?$ses$takep\" method=\"post\">\n";
echo "<postfield name=\"nick\" value=\"$(nick$ref)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
echo $fsize1;
echo "<anchor title=\"go\">Удалить юзера<go href=\"deluser.php?$ses$takep\" method=\"post\">\n";
echo "<postfield name=\"nick\" value=\"$(nick$ref)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}
echo $fsize1;
echo $divide;
echo "<a href=\"apanel.php?$ses&go=editrooms$takep\">Изм. название комнаты</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=editposroom$takep\">Изм. позицию комнаты</a><br/>\n";
if($row["level"]==8){
echo "<a href=\"apanel.php?$ses&go=bank$takep\">Изм.Курс банка</a><br/>\n";
echo "<a href=\"apanel.php?$ses$takep&go=kurs$takep\">Настройки Магазина</a><br/>\n";
echo "<a href=\"apanel.php?$ses$takep&go=setting$takep\">Основные настройки</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=editlevels$takep\">Изм. название статусов</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=bots$takep\">Изм. настроек Ботов</a><br/>\n";
echo "<a href=\"elections/admin.php?action=readlist&$ses&$takep\">Управление админами выборов</a><br/>\n";
echo "<a href=\"konkurs/admin.php?action=readlist&$ses&$takep\">Управление админами конкурсов</a><br/>\n";
echo "<a href=\"journal/admin.php?action=readlist&$ses&$takep\">Управление редакторами журнала</a><br/>\n";
echo "<a href=\"journal/admin.php?action=readlist2&$ses&$takep\">Управление журналистами</a><br/>\n";
}
if($row["id"]==10){
echo "<a href=\"clear.php?$ses$takep\">Сбросить подаренные подарки</a><br/>\n";
}
$filex=file("konkurs/adminlist.dat");
$countx=count($filex);
$switchx=0;
$wordx="".$row["id"]."";
for ($ix=0;$ix<$countx;$ix++){
if (trim($filex[$ix])==$wordx){$switchx=1;}}
if($switchx==1)
{echo "<a href=\"konkurs/admin.php?$ses&$takep\">Управление конкурсами</a><br/>\n";}
$filex=file("elections/adminlist.dat");
$countx=count($filex);
$switchx=0;
$wordx="".$row["id"]."";
for ($ix=0;$ix<$countx;$ix++){
if (trim($filex[$ix])==$wordx){$switchx=1;}}
if($switchx==1)
{echo "<a href=\"elections/admin.php?$ses&$takep\">Управление выборами</a><br/>\n";}
if($row["level"]>7){
echo "<a href=\"present/admin.php?$ses$takep\">Управление подарками</a><br/>\n";
}
if($row["level"]==8){
echo "<a href=\"loterea/admin.php?$ses$takep\">Управление лотереей</a><br/>\n";
}
if($row["level"]==8){
echo "<a href=\"forum/admin.php?$ses$takep\">Управление форумом</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=sertif$takep\">Создать брачный сертификат</a><br/>\n";
}
echo $divide;
echo "<a href=\"apanel.php?$ses&go=addshutki$takep\">Добавить шутку</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=addvopr$takep\">Добавить вопрос</a><br/>\n";
echo $divide;
echo "<a href=\"apanel.php?$ses&go=unban$takep\">Разбанить Ники</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=allrazban$takep\">Разбанить всех IP</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=unpin$takep\">Освободить выпнутого</a><br/>\n";
if($row["level"]==8){
echo "<a href=\"apanel.php?$ses&go=bann_panel$takep\">Черный список IP</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=spam$takep\">Paccылкa зaпиcoк вceм пoльзoвaтeлям</a><br/>\n";
}
echo $divide;
echo "<a href=\"apanel.php?$ses&go=fullign$takep\">Чистка Полного Игнора</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=zapiski$takep\">Чтение записок</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=clearzap$takep\">Чистка записок</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=clroom$takep\">Чистка комнат (немедленно)</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=clroomtime$takep\">Чистка комнат (через 3 минуты)</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=clearlogs$takep\">Чистка Логов</a><br/>\n";
if($row["level"]==8){
echo $divide;
echo "<a href=\"apanel.php?$ses&go=import_fraz$takep\">Импорт мата</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=import_frazi$takep\">Импорт фраз</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=import_vopros$takep\">Импорт вопросов</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=import_anekdot$takep\">Импорт анекдотов</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=import_shutki$takep\">Импорт шуток</a><br/>\n";
}
if($row["level"]==8){
echo "<a href=\"openlog.php?$ses$takep\">Логи Админки</a><br/>\n";
echo "<a href=\"openlogm.php?$ses$takep\">Логи Модерки</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=log_avt$takep\">Логи Авторитета</a><br/>\n";
echo "<a href=\"openlogr.php?$ses$takep\">Логи Админской комнаты</a><br/>\n";
echo "<a href=\"openlogi.php?$ses$takep\">Логи Интим-комнаты</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=logban$takep\">Баннлист</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=logbanip$takep\">Баннлист ip+soft</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=logpin$takep\">Пинлист</a><br/>\n";
}
echo $divide;
echo "<a href=\"apanel.php?$ses&go=welcome$takep\">Приветствие на главной</a><br/>";
echo "<a href=\"apanel.php?$ses&go=tell$takep\">Объявление в чат</a><br/>\n";
echo "<a href=\"apanel.php?$ses&go=mnews$takep\">Добавить новость</a><br/>";
echo "<a href=\"apanel.php?$ses&go=dnews$takep\">Удалить новость</a><br/>";
echo "<a href=\"apanel.php?$ses&go=mmeet$takep\">Добавить встречу</a><br/>";
echo "<a href=\"apanel.php?$ses&go=dmeet$takep\">Удалить встречу</a><br/>";
echo "<a href=\"apanel.php?$ses&go=mobi$takep\">Добавить объявление</a><br/>";
echo "<a href=\"apanel.php?$ses&go=dobi$takep\">Удалить объявление</a><br/>";
echo $divide;
echo "<a href=\"apanel.php?$ses&go=msvadbi$takep\">Добавить свадьбу</a><br/>";
echo "<a href=\"apanel.php?$ses&go=dsvadbi$takep\">Удалить свадьбу</a><br/>";
echo "<a href=\"apanel.php?$ses&go=razvod$takep\">Развести</a><br/>";
if($row["level"]==8){
echo $divide;
echo "<a href=\"apanel.php?$ses&go=link$takep\">Ссылки на главную</a><br/>";
}
echo $fsize2;
break;
case 'log_avt':
$p = intval(check($_GET['p']));
if (empty($_GET['p'])) $page = 1;
else $page=$_GET['p'];
if (eregi("[^0-9]", $p))
{ header ("Location: index.php?isset=403"); exit;}
// получаем кол во участников
$result = mysql_query("SELECT count(`id`) FROM `avtoritet`;");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
$max_page = ceil ($count_users / 10);
$page = ($page > $max_page) ? (($max_page == 0)? $page : $max_page) : $page;
$start = 10*($page-1); $end = 10;
$resultx=mysql_query("SELECT * FROM `avtoritet` ORDER BY `id` DESC LIMIT $start,$end;");
$count_users_on_pagex = mysql_num_rows($resultx);
for($i = 0; $i < $count_users_on_pagex; $i++)
{
$row = mysql_fetch_array($resultx);
$id_user = $row['id_user'];
$id_who = $row['id_who'];
$time_vers = $row['time'];
$colc = $row['col'];
$time_vers = date("d.m.Y / H:i",$time_vers);
$view=mysql_query("SELECT `id`,`user` FROM `users` WHERE `id`='" . $id_user . "';");
$rowd = mysql_fetch_array($view);
$id1 = $rowd[0];
$nick1 = $rowd[1];
$view2=mysql_query("SELECT `id`,`user` FROM `users` WHERE `id`='" . $id_who . "';");
$rowd2 = mysql_fetch_array($view2);
$id2 = $rowd2[0];
$nick2 = $rowd2[1];
if($colc==0){$x="-1";}
if($colc==1){$x="+1";}
echo'Кому: <a href="info.php?nk='.$id1.'&'.$ses.'">'.$nick1.'</a> ('.$x.')<br/>Кто: <a href="info.php?nk='.$id2.'&'.$ses.'">'.$nick2.'</a> ['.$time_vers.']';
}
echo"<br/>";
if($i==0)
{
echo "<b>Изменений пока нет...</b><br/>";
}
if ($max_page > 1)
{
$ba=ceil($count_users/10);
$ba2=$ba*10-10;
echo "Страницы:";
$asd=$start-(10*4);
$asd2=$start+(10*5);
if($asd<$count_users && $asd>0){echo ' <a href="apanel.php?'.$ses.'&go=log_avt&p=1'.$takep.'">1</a> ... ';}
for($i=$asd; $i<$asd2;)
{
if($i<$count_users && $i>=0){
$ii=floor(1+$i/10);
if ($start==$i) {
echo ' <b>('.$ii.')</b>';
}
else {
echo ' <a href="apanel.php?'.$ses.'&go=log_avt&p='.$ii.''.$takep.'">'.$ii.'</a>';
}}
$i=$i+10;}
if($asd2<$count_users){echo ' ... <a href="apanel.php?'.$ses.'&go=log_avt&p='.$ba.''.$takep.'">'.$ba.'</a>';}
}
break;
case 'logban':
echo $fsize1;
if ($ver=="xhtml"){echo"<div class='d2'>";}
echo "<b>Баннлист</b><br/>";
if ($ver=="xhtml"){echo"</div>";}
$start = gettime();
$log = file("log/bannlist.dat");
$log = array_reverse($log);
$text = @implode("",$log);
$string = substr("$text", $n, $signs);
$m=$n+$signs;
if ($ver=="xhtml"){echo"<div class='d1'>";}
echo "".$string."";
if ($ver=="xhtml"){echo"</div>";}
if ($string !=""){echo "<div class='d2'><br/>".$divide."<a href=\"apanel.php?$ses&go=logban&n=$m&$ses&ref=$ref\">Далее</a></div><br/>";};
echo $fsize2;
break;
case 'logbanip':
echo $fsize1;
if ($ver=="xhtml"){echo"<div class='d2'>";}
echo "<b>Баннлист ip+soft</b><br/>";
if ($ver=="xhtml"){echo"</div>";}
$start = gettime();
$log = file("log/banniplist.dat");
$log = array_reverse($log);
$text = @implode("",$log);
$string = substr("$text", $n, $signs);
$m=$n+$signs;
if ($ver=="xhtml"){echo"<div class='d1'>";}
echo "".$string."";
if ($ver=="xhtml"){echo"</div>";}
if ($string !=""){echo "<div class='d2'><br/>".$divide."<a href=\"apanel.php?$ses&go=logbanip&n=$m&$ses&ref=$ref\">Далее</a></div><br/>";};
echo $fsize2;
break;
case 'logpin':
echo $fsize1;
if ($ver=="xhtml"){echo"<div class='d2'>";}
echo "<b>Пиннлист</b><br/>";
if ($ver=="xhtml"){echo"</div>";}
$start = gettime();
$log = file("log/pinlist.dat");
$log = array_reverse($log);
$text = @implode("",$log);
$string = substr("$text", $n, $signs);
$m=$n+$signs;
if ($ver=="xhtml"){echo"<div class='d1'>";}
echo "".$string."";
if ($ver=="xhtml"){echo"</div>";}
if ($string !=""){echo "<br/><div class='d2'>".$divide."<a href=\"apanel.php?$ses&go=logpin&n=$m&$ses&ref=$ref\">Далее</a></div><br/>";};
echo $fsize2;
break;
case 'mnews':
$content=trim(mysql_escape_string(check($content)));
$date=date("j.m.Y");
if(empty($content)) $error=$error."<u>Пустое содержание встречи!</u><br/>";
if(empty($action)) {
echo $fsize1;
echo "Новость:<br/>";
echo $fsize2;
if ($ver=="wml"){
echo $fsize1;
echo "<anchor>Добавить<go href=\"apanel.php?$ses&go=mnews$takep\" method=\"post\">";
echo "<postfield name=\"action\" value=\"add\"/>";
echo "<postfield name=\"content\" value=\"$(content)\"/>";
echo "<postfield name=\"date\" value=\"$date\"/>";
echo "</go></anchor>";
echo $fsize2;
echo "<br/>";
}else{
echo "<form method=\"POST\" action=\"apanel.php?$ses&go=mnews$takep\" name=\"auth\">\n";
echo "<input name=\"content\"/><br/>";
echo "<input type=\"hidden\" name=\"action\" value=\"add\"/>";
echo "<input type=\"hidden\" name=\"date\" value=\"$date\"/>";
echo "<input type=\"submit\" value=\"Добавить\" name=\"enter\"><br/>\n";
}
} else {
if(empty($error)) {
if($content!=$last_news['content']) {
if(mysql_query("insert into news values(0,'".$login."','".$content."','".$date."');")) {
echo $fsize1;
echo "<b>Ваша новость успешно добавлена!</b><br/>";
echo $fsize2;
} else {
echo $fsize1;
echo "<b>Ошибка записи новости!</b><br/>";
echo $fsize2;
}
} else {
echo $fsize1;
echo "<b>Такая новость уже добавлена!</b><br/>";
echo $fsize2;
}
} else {
echo $fsize1;
echo $error;
echo $fsize2;
}
}
break;
//банк
case'bank':
echo "<form method=\"post\" action=\"apanel.php?$ses&go=bank_ok$takep\">";
$row =mysql_fetch_array(mysql_query("Select kurs from bank where id='1' LIMIT 1;"));
$kurs = $row["kurs"];
if ($ver=="xhtml"){echo"<div class='d3'>";}
echo"Смена Курса Банка чата!<br/><br/>";
if ($ver=="xhtml"){echo"</div>";}
if ($ver=="xhtml"){echo"<div class='d2'>";}
echo"<b>Текущий курс 1 доллар за $kurs пост(a)(ов)</b><br/><br/>";
if ($ver=="xhtml"){echo"</div>";}
if ($ver=="xhtml"){echo"<div class='d2'>";}
echo "Новый курс:<br/><input name=\"bank\" class=\"form\" value=\"$kurs\" type=\"text\" /><br/>\n";
echo "<input value=\"Изменить\" class=\"form\" type=\"submit\" />\n";
echo "</form>\n";
if ($ver=="xhtml"){echo"</div>";}
break;
case'bank_ok':
$bank=htmlspecialchars(stripslashes(trim($bank)));
if(@mysql_query("update `bank` set kurs='$bank' WHERE `id` = '1';"))
{
if ($ver=="xhtml"){echo"<div class='d2'>";}
echo"<b>Курс банка успешно изменён!</b><br/>";
if ($ver=="xhtml"){echo"</div>";}
if ($ver=="xhtml"){echo"<div class='d3'>";}
echo "<a href=\"apanel.php?$ses&go=bank$takep\">Назад</a><br/>\n";
if ($ver=="xhtml"){echo"</div>";}
}
else
{
if ($ver=="xhtml"){echo"<div class='d2'>";}
echo"<b>Ошибка</b><br/>";
if ($ver=="xhtml"){echo"</div>";}
if ($ver=="xhtml"){echo"<div class='d3'>";}
echo "<a href=\"apanel.php?$ses&go=bank$takep\">Назад</a><br/>\n";
if ($ver=="xhtml"){echo"</div>";}
}
break;
//банк
//спам
case 'spam':
$msg=trim(htmlspecialchars(stripslashes($msg)));
$msg = check($msg);
$topic=trim(htmlspecialchars(stripslashes($topic)));
$topic = check($topic);
$select=mysql_query ("SELECT * FROM users");
$yesus = mysql_affected_rows();
if ($ver=="xhtml");
print"<small>Paccылкa зaпиcoк вceм пoльзoвaтeлям чaтa.<br /></small><br/>";
if ($ver=="wml"){
print"<small>Haзвaниe paccылки:</small><br/>";
echo "
<input name=\"topic\" type=\"text\"/><br />
<small>Teкcт paccылки:</small><br/>
<input name=\"msg\" type=\"text\"/><br/>
<anchor title=\"next\">Oтпpaвить ($yesus пользователям)
<go href=\"apanel.php?$ses&go=spammsend$takep\" method=\"post\">
<postfield name=\"msg\" value=\"$(msg)\"/>
<postfield name=\"topic\" value=\"$(topic)\"/>
</go></anchor><br />
";
}else{
echo "<form method=\"POST\" action=\"apanel.php?$ses&go=spammsend$takep\" name=\"auth\">\n";
echo "<input type=\"hidden\" name=\"action\" value=\"add\"/>\n";
echo $fsize1;
if ($ver=="xhtml");
echo "тема:<br/>";
echo $fsize2;
echo "<input type=\"text\" name=\"topic\" value=\"$topic\"/><br/>\n";
echo $fsize1;
echo "Содержание:<br/>";
echo $fsize2;
echo "<input type=\"text\" name=\"msg\" value=\"$msg\"/><br/>\n";
echo "<input type=\"submit\" value=\"отправить\" name=\"enter\"><br/>\n";
}
if ($ver=="xhtml");
break;
case 'spammsend':
$select2=mysql_query ("SELECT * FROM users");
while ( $allu = mysql_fetch_array ($select2) )
{
$msg=trim(htmlspecialchars(stripslashes($msg)));
$msg = check($msg);
$mes="$msg (Это письмо сформировано автоматически службой уведомления чата, отвечать на него не нужно.)";
$topic=trim(htmlspecialchars(stripslashes($topic)));
$topic = check($topic);
$kol = rand(0,99999999);
$dataspamm = date("d-M-Y [H:i]");
$timespamm = time();
mysql_query("Insert into zapiski set klu4='".$kol."', who ='".$us."', idwho ='".$id."', message = '".$mes."', towhom = '". $allu["user"] ."', idtowhom = '". $allu["id"] ."', time = '".$timespamm."', readd = '0', topic = '".$topic."', date='".$dataspamm."'");
}
print"<small>Paccылкa ycпeшнo выпoлнeнa...</small><br />";
break;
//спам
case 'sertif':
$userm = mysql_query ("select count(id) as num from users where sex ='М' and id !='1' and id !='2' and id !='3' and id !='4' and id !='5' and id !='6' and id !='7' and id !='8' and id !='9' and para!='';");
$usm = mysql_fetch_array($userm);
$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 id,user,para from users where sex ='М' and para!='' and id !='1' and id !='2' and id !='3' and id !='4' and id !='5' and id !='6' and id !='7' and id !='8' and id !='9' and para!='' order by posts desc limit $o,$do");
for ($i=$ot;$i<=$do;$i++){
$arr = mysql_fetch_array($r);
$login=$arr['user'];
$usid=$arr['id'];
$para=$arr['para'];
$rx = mysql_query ("select id,user from users where para!='' and id='$para' order by posts desc limit $o,$do");
$arrx = mysql_fetch_array($rx);
$loginx=$arrx['user'];
$usidx=$arrx['id'];
echo ($i).") ".$login." + ".$loginx." <a href=\"apanel.php?$ses&go=gosertif&mid=$usid&fid=$usidx$takep\">[+]</a><br/>";
}
$next=$s+1;
$prev=$s-1;
if ($num>$do) {
$ot=(($next-1)*10)+1;
$do=$next*10;
if($do>$num)$do=$num;
echo $divide;
echo "<a href=\"apanel.php?$ses&go=sertif&s=$next$takep\">>>$ot-$do>></a><br/>\n";
}
if($s>1) {
$ot=(($prev-1)*10)+1;
$do=$prev*10;
echo "<a href=\"apanel.php?$ses&go=sertif&s=$prev$takep\"><<$ot-$do<<</a><br/>\n";
}
break;
case 'gosertif':
$xf = mysql_query("select * from `sertificat` where zhenih='" . $mid . "' AND nevesta='" . $fid . "';");
$df = mysql_fetch_array($xf);
if (!empty($df[id]))
{echo "Ошибка! Сертификат уже написан!"; include_once"../foot3.php"; ob_end_flush(); exit;}
$xf = mysql_query("select * from `users` where id='" . $mid . "';");
$df = mysql_fetch_array($xf);
if ($df[para] != "$fid")
{echo "Ошибка! Пара не зарегистрирована!"; include_once"../foot3.php"; ob_end_flush(); exit;}
$xf = mysql_query("select * from `users` where id='" . $fid . "';");
$df = mysql_fetch_array($xf);
if ($df[para] != "$mid")
{echo "Ошибка! Пара не зарегистрирована!"; include_once"../foot3.php"; ob_end_flush(); exit;}
$mid = intval(check($_GET['mid']));
if (eregi("[^0-9]", $mid))
{echo"ЗЫ. Попытка взлома!!!";
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once"../foot3.php"; ob_end_flush(); exit;}
if (empty($_GET['mid'])){echo "Ошибка!";include_once"../foot3.php"; ob_end_flush(); exit;}
$typ = mysql_query("select * from `users` where id='" . $mid . "';");
$ms = mysql_fetch_array($typ);
if ($ms[id] != "$mid")
{echo "Ошибка! Юзера просто несуществует! )"; include_once"../foot3.php"; ob_end_flush(); exit;}
$fid = intval(check($_GET['fid']));
if (eregi("[^0-9]", $fid))
{echo"ЗЫ. Попытка взлома!!!";
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once"../foot3.php"; ob_end_flush(); exit;}
if (empty($_GET['fid'])){echo "Ошибка!";include_once"../foot3.php"; ob_end_flush(); exit;}
$typ = mysql_query("select * from `users` where id='" . $fid . "';");
$ms = mysql_fetch_array($typ);
if ($ms[id] != "$fid")
{echo "Ошибка! Юзера просто несуществует! )"; include_once"../foot3.php"; ob_end_flush(); exit;}
if($ver!="wml"){
echo'<form action="apanel.php?'.$ses.'&go=addsertif&mid='.$mid.'&fid='.$fid.''.$takep.'" method="post">';
echo'<b>Дата свадьбы / время:</b> <br/><input type="text" name="date"/><br/>';
echo'<b>ID свидетель жениха:</b> <br/><input type="text" name="sv_zh"/><br/>';
echo'<b>ID свидетель невесты:</b> <br/><input type="text" name="sv_nev"/><br/>';
echo'<b>Кол-во гостей на свадьбе:</b> <br/><input type="text" name="kolvo"/><br/>';
echo'<br/><input type="submit" value="Создать" /></form>';}else{
echo'<b>Дата свадьбы / время:</b> <br/><input type="text" name="date"/><br/>';
echo'<b>ID свидетель жениха:</b> <br/><input type="text" name="sv_zh"/><br/>';
echo'<b>ID свидетель невесты:</b> <br/><input type="text" name="sv_nev"/><br/>';
echo'<b>Кол-во гостей на свадьбе:</b> <br/><input type="text" name="kolvo"/><br/>';
echo '<anchor>Создать!';
echo '<go href="apanel.php?'.$ses.'&go=addsertif&mid='.$mid.'&fid='.$fid.''.$takep.'" method="post">';
echo '<postfield name="date" value="$(date)"/>';
echo '<postfield name="sv_zh" value="$(sv_zh)"/>';
echo '<postfield name="sv_nev" value="$(sv_nev)"/>';
echo '<postfield name="kolvo" value="$(kolvo)"/>';
echo '</go></anchor><br/>--------------------<br/>';
}
break;
case 'addsertif':
$xf = mysql_query("select * from `sertificat` where zhenih='" . $mid . "' AND nevesta='" . $fid . "';");
$df = mysql_fetch_array($xf);
if (!empty($df[id]))
{echo "Ошибка! Сертификат уже написан!"; include_once"../foot3.php"; ob_end_flush(); exit;}
$xf = mysql_query("select * from `users` where id='" . $mid . "';");
$df = mysql_fetch_array($xf);
if ($df[para] != "$fid")
{echo "Ошибка! Пара не зарегистрирована!"; include_once"../foot3.php"; ob_end_flush(); exit;}
$xf = mysql_query("select * from `users` where id='" . $fid . "';");
$df = mysql_fetch_array($xf);
if ($df[para] != "$mid")
{echo "Ошибка! Пара не зарегистрирована!"; include_once"../foot3.php"; ob_end_flush(); exit;}
$kolvo = intval(check($_POST['kolvo']));
if (eregi("[^0-9]", $kolvo))
{echo"ЗЫ. Кол-во выражается в цифрах!!!";
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once"../foot3.php"; ob_end_flush(); exit;}
if (empty($_POST['kolvo'])){echo "Ошибка! НЕТ ГОСТЕЙ ЧТОЛЬ?";include_once"../foot3.php"; ob_end_flush(); exit;}
$mid = intval(check($_GET['mid']));
if (eregi("[^0-9]", $mid))
{echo"ЗЫ. Попытка взлома!!!";
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once"../foot3.php"; ob_end_flush(); exit;}
if (empty($_GET['mid'])){echo "Ошибка! ЖЕНИХ ПОТЕРЯЛСЯ!";include_once"../foot3.php"; ob_end_flush(); exit;}
$typ = mysql_query("select * from `users` where id='" . $mid . "';");
$ms = mysql_fetch_array($typ);
if ($ms[id] != "$mid")
{echo "Ошибка! Юзера просто несуществует! )"; include_once"../foot3.php"; ob_end_flush(); exit;}
$fid = intval(check($_GET['fid']));
if (eregi("[^0-9]", $fid))
{echo"ЗЫ. Попытка взлома!!!";
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once"../foot3.php"; ob_end_flush(); exit;}
if (empty($_GET['fid'])){echo "Ошибка! НЕВЕСТА ГДЕ?";include_once"../foot3.php"; ob_end_flush(); exit;}
$typ = mysql_query("select * from `users` where id='" . $fid . "';");
$ms = mysql_fetch_array($typ);
if ($ms[id] != "$fid")
{echo "Ошибка! Юзера просто несуществует! )"; include_once"../foot3.php"; ob_end_flush(); exit;}
$sv_zh = intval(check($_POST['sv_zh']));
if (eregi("[^0-9]", $sv_zh))
{echo"ЗЫ. ID пишется в цифрах!";
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once"../foot3.php"; ob_end_flush(); exit;}
if (empty($_POST['sv_zh'])){echo "Ошибка! СВИДЕТЕЛЯ НЕТ???";include_once"../foot3.php"; ob_end_flush(); exit;}
$typ = mysql_query("select * from `users` where id='" . $sv_zh . "';");
$ms = mysql_fetch_array($typ);
if ($ms[id] != "$sv_zh")
{echo "Ошибка! Юзера с ИД: $sv_zh несуществует! )"; include_once"../foot3.php"; ob_end_flush(); exit;}
$sv_nev = intval(check($_POST['sv_nev']));
if (eregi("[^0-9]", $sv_nev))
{echo"ЗЫ. ID пишется в цифрах!";
echo'<a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
include_once"../foot3.php"; ob_end_flush(); exit;}
if (empty($_POST['sv_nev'])){echo "Ошибка! СВИДЕТЕЛЯ НЕТ???";include_once"../foot3.php"; ob_end_flush(); exit;}
$typ = mysql_query("select * from `users` where id='" . $sv_nev . "';");
$ms = mysql_fetch_array($typ);
if ($ms[id] != "$sv_nev")
{echo "Ошибка! Юзера с ИД: $sv_nev несуществует! )"; include_once"../foot3.php"; ob_end_flush(); exit;}
$realtime = time();
mysql_query("insert into `sertificat` values(0,'".$mid."','".$fid."','" . $sv_zh . "','" . $sv_nev . "','" . $kolvo . "','" . $date . "','" . $realtime . "');");
echo"Сертификат успешно подписан!";
break;
case 'bann_panel':
$file = file("log/ban.dat");
$total = count($file);
if (empty($_GET['start'])) $start = 0;
else $start = $_GET['start'];
if ($total < $start + 10){ $end = $total; }
else {$end = $start + 10; }
for ($i = $start; $i < $end; $i++){
$file = file("log/ban.dat");
$file = array_reverse($file);
$data = explode("|",$file[$i]);
$i2=round($i+1);
$num=$total-$i-1;
echo $i2.'. '.$data[1].' ('.$data[2].')<br/><a href="apanel.php?'.$ses.'&go=razban&idx='.$num.''.$takep.'">Разбанить</a><hr/>';}
if($total<1){echo'<br/><b>CПИСОК ЧИСТ</b><br/><br/>';}
if ($start != 0) {echo '<a href="apanel.php?'.$ses.'&go=bann_panel&start='.($start - 10).''.$takep.'"><-Назад </a> ';}else{echo'<-Назад ';}
echo'|';
if ($total > $start + 10) {echo ' <a href="apanel.php?'.$ses.'&go=bann_panel&start='.($start + 10).''.$takep.'">Далее-></a>';}else{echo' Далее->';}
if($ver!=="wml"){
echo '<hr/><form method="post" action="apanel.php?'.$ses.'&go=zaban'.$takep.'">';
echo 'IP подсудимого:<br/><input name="ips" /><br/><br/>';
echo '<input value="Забанить" type="submit" /></form>';
}else{
echo'<br/>--------------------<br/>IP подсудимого:<br/>';
echo'<input name="ips"/><br/>';
echo'<anchor>Казнить';
echo'<go href="apanel.php?'.$ses.'&go=bann_panel'.$takep.'" method="post">';
echo'<postfield name="ips" value="$(ips)"/>';
echo'</go></anchor><br/>';
}
if($total>1){echo'<br/><img src="../images/img/error.gif" alt=""/> <a href="apanel.php?'.$ses.'&go=allrazban'.$takep.'">Очистить список</a>';}
break;
case 'zaban':
$rm = intval(check($_GET['rm']));
$nk = intval(check($_GET['nk']));
if(!empty($nk)){
$select = @mysql_query ("Select * from users where id='".$nk."'");
$inf = mysql_fetch_array ($select);
$us_ip = $inf["user_ip"];
$nick = $inf["user"];
$us_ip=check($us_ip);
$fp=fopen("log/ban.dat","a+");
flock ($fp,LOCK_EX);
fputs($fp,"|$us_ip|$nick|\r\n");
fflush ($fp);
flock ($fp,LOCK_UN);
fclose($fp);
$room="room".$rm;
$adm = @mysql_query ("Select user from users where id='1' LIMIT 1;");
$z = @mysql_fetch_array ($adm);
$administration = $z["user"];
$administration = mysql_escape_string(check($administration));
$rnd = rand(0,99999999);
$today=date ("H:i");
$time = time();
$room = "room".$rm;
$txt = "".$us." забанил юзера <b>".$nick."</b> по IP+SOFT.";
mysql_query ("Insert into $room set klu4= '".$rnd."', time='".$today."', who='".$administration."', message='".$txt."', id='".$time."', towhom='', hid='0', usid='1', komu=''");
echo'IP юзера '.$nick.' забанено!<br/><a href="chat.php?'.$ses.'&rm='.$rm.''.$takeps.'">Назад в комнату</a><br/>';
}else{
if(!empty($ips)){
$ips=check($ips);
$fp=fopen("log/ban.dat","a+");
flock ($fp,LOCK_EX);
fputs($fp,"|$ips|Неизвестен|\r\n");
fflush ($fp);
flock ($fp,LOCK_UN);
fclose($fp);
echo'Забанен!<br/><a href="apanel.php?'.$ses.'&go=bann_panel'.$takeps.'">Назад к панели</a><br/>';
}
}
break;
case 'allrazban':
$file=file("log/ban.dat");
$fp=fopen("log/ban.dat","a+");
flock ($fp,LOCK_EX);
ftruncate ($fp,0);
fflush ($fp);
flock ($fp,LOCK_UN);
fclose($fp);
echo'Список очищен!<br/><a href="apanel.php?'.$ses.'&go=bann_panel'.$takeps.'">Назад к панели</a><br/>';
break;
case 'razban':
if($idx!=""){
$file=file("log/ban.dat");
$fp=fopen("log/ban.dat","w");
flock ($fp,LOCK_EX);
for ($i=0;$i< sizeof($file);$i++) { if ($i==$idx) {unset($file[$i]);} }
fputs($fp, implode("",$file));
flock ($fp,LOCK_UN);
fclose($fp);
echo'Разбанен!<br/><a href="apanel.php?'.$ses.'&go=bann_panel'.$takeps.'">Назад к панели</a><br/>';
}
break;
case 'welcome':
$buff = file_get_contents("welcome.dat");
$buff = check ($buff);
echo 'Приветствие:<br/>';
if($ver!="wml"){
echo '<form method="post" action="apanel.php?'.$ses.'&go=welcome_end'.$takep.'">';
echo '<textarea name="buffs" cols="35" rows="5">'.$buff.'</textarea><br/>';
echo '<input value="Редактировать" type="submit"></form>';
}else{
echo '<input name="buffs" value="'.$buff.'"/><br/>';
echo '<anchor>Редактировать';
echo '<go href="apanel.php?'.$ses.'&go=welcome_end'.$takep.'" method="post">';
echo '<postfield name="buffs" value="$(buffs)"/>';
echo '</go></anchor><br/>--------------------<br/>';
}
break;
case 'welcome_end':
if($buffs!=""){
$buffs=mysql_escape_string(check($buffs));
$fp=fopen("welcome.dat","a+");
flock($fp,LOCK_EX);
ftruncate($fp,0);
fputs ($fp,$buffs);
fflush($fp);
flock($fp,LOCK_UN);
fclose ($fp);
echo '<b>Блок приветствия успешно отредактирован!</b><br/><br/>';
}else{
echo'<b>Вы не написали текст приветствия!</b><br/><br/>';}
break;
case 'dnews':
$q = mysql_query("select id,content from news order by id desc;");
if (mysql_affected_rows() == 0) {
echo $fsize1;
echo "Новостей нет!!!<br/>\n";
echo $fsize2;
} else {
if(empty($action)) {
while($arr=mysql_fetch_array($q)) {
echo $fsize1;
echo "<a href=\"apanel.php?action=del&$ses&go=dnews&mid=".$arr['id']."$takep\">".$arr['id'].":</a> ".$arr['content']."<br/>";
echo $fsize2;
}
} else {
if(mysql_query("delete from news where id='".$mid."' limit 1;")){
echo $fsize1;
echo "<b>Запись успешно удалена!</b><br/>";
echo $fsize2;
}
}
}
break;
case 'mmeet':
$title=trim(mysql_escape_string(check($title)));
$content=trim(mysql_escape_string(check($content)));
$organizatory=trim(mysql_escape_string(check($organizatory)));
if(empty($title)) $error=$error."<u>Название не введено!</u><br/>";
if(empty($content)) $error=$error."<u>Пустое содержание встречи!</u><br/>";
if(empty($organizatory)) $error=$error."<u>Организаторов нет!</u><br/>";
if(empty($action)) {
if ($ver=="wml"){
echo $fsize1;
echo "Название:<br/>";
echo $fsize2;
echo "<input name=\"title\"/><br/>";
echo $fsize1;
echo "Содержание:<br/>";
echo $fsize2;
echo "<input name=\"content\"/><br/>";
echo $fsize1;
echo "Организаторы:<br/>";
echo $fsize2;
echo "<input name=\"organizatory\"/><br/>";
echo $fsize1;
echo "<anchor>Добавить<go href=\"apanel.php?$ses&go=mmeet$takep\" method=\"post\">";
echo "<postfield name=\"action\" value=\"add\"/>";
echo "<postfield name=\"title\" value=\"$(title)\"/>";
echo "<postfield name=\"content\" value=\"$(content)\"/>";
echo "<postfield name=\"organizatory\" value=\"$(organizatory)\"/>";
echo "</go></anchor>";
echo $fsize2;
echo "<br/>";
}else{
echo "<form method=\"POST\" action=\"apanel.php?$ses&go=mmeet$takep\" name=\"auth\">\n";
echo "<input type=\"hidden\" name=\"action\" value=\"add\"/>\n";
echo $fsize1;
echo "Название:<br/>";
echo $fsize2;
echo "<input type=\"text\" name=\"title\" value=\"$title\"/><br/>\n";
echo $fsize1;
echo "Содержание:<br/>";
echo $fsize2;
echo "<input type=\"text\" name=\"content\" value=\"$content\"/><br/>\n";
echo $fsize1;
echo "Организаторы:<br/>";
echo $fsize2;
echo "<input type=\"text\" name=\"organizatory\" value=\"$organizatory\"/><br/>\n";
echo "<input type=\"submit\" value=\"Добавить\" name=\"enter\"><br/>\n";
}
}else{
if(empty($error)) {
if($title!=$last_meet['title']) {
if(mysql_query("insert into vstrechi values(0,'".$login."','".$title."','".$content."','".$organizatory."');")) {
echo $fsize1;
echo "<b>Ваша встреча успешно добавлена!</b><br/>";
echo $fsize2;
} else {
echo $fsize1;
echo "<b>Проблемы с базой данных!</b><br/>";
echo $fsize2;
}
} else {
echo $fsize1;
echo "<b>Такая встреча уже добавлена!</b><br/>";
echo $fsize2;
}
} else {
echo $fsize1;
echo $error;
echo $fsize2;
}
}
break;
case 'dmeet':
$q = mysql_query("select id,title from vstrechi order by id desc;");
if (mysql_affected_rows() == 0) {
echo $fsize1;
echo "Встреч нет!!!<br/>\n";
echo $fsize2;
} else {
if(empty($action)) {
while($arr=mysql_fetch_array($q)) {
echo $fsize1;
echo "<a href=\"apanel.php?action=del&$ses&go=dmeet&mid=".$arr['id']."$takep\">".$arr['title']."</a><br/>";
echo $fsize2;
}
} else {
if(mysql_query("delete from vstrechi where id='".$mid."' limit 1;")){
echo $fsize1;
echo "<b>Запись успешно удалена!</b><br/>";
echo $fsize2;
}
}
}
break;
case 'mobi':
$title=trim(mysql_escape_string(check($title)));
$content=trim(mysql_escape_string(check($content)));
$login=trim(mysql_escape_string(check($login)));
if(empty($title)) $error=$error."<u>Название не введено!</u><br/>";
if(empty($content)) $error=$error."<u>Пустое содержание встречи!</u><br/>";
if(empty($action)) {
if ($ver=="wml"){
echo $fsize1;
echo "Название:<br/>";
echo $fsize2;
echo "<input name=\"title\"/><br/>";
echo $fsize1;
echo "Содержание:<br/>";
echo $fsize2;
echo "<input name=\"content\"/><br/>";
echo $fsize1;
echo "<anchor>Добавить<go href=\"apanel.php?$ses&go=mobi$takep\" method=\"post\">";
echo "<postfield name=\"action\" value=\"add\"/>";
echo "<postfield name=\"title\" value=\"$(title)\"/>";
echo "<postfield name=\"content\" value=\"$(content)\"/>";
echo "</go></anchor>";
echo $fsize2;
echo "<br/>";
}else{
echo "<form method=\"POST\" action=\"apanel.php?$ses&go=mobi$takep\" name=\"auth\">\n";
echo "<input type=\"hidden\" name=\"action\" value=\"add\"/>\n";
echo $fsize1;
echo "Название:<br/>";
echo $fsize2;
echo "<input type=\"text\" name=\"title\"/><br/>\n";
echo $fsize1;
echo "Содержание:<br/>";
echo $fsize2;
echo "<input type=\"text\" name=\"content\"/><br/>\n";
echo "<input type=\"submit\" value=\"Добавить\" name=\"enter\"><br/>\n";
}
} else {
if(empty($error)) {
if($title!=$last_obiav['title']) {
if(mysql_query("insert into obiav values(0,'".$login."','".$title."','".$content."');")) {
echo $fsize1;
echo "<b>Ваше объявление успешно добавлено!</b><br/>";
echo $fsize2;
} else {
echo $fsize1;
echo "<b>Проблемы с базой данных!</b><br/>";
echo $fsize2;
}
} else {
echo $fsize1;
echo "<b>Такое объявление уже добавлено</b><br/>";
echo $fsize2;
}
} else {
echo $fsize1;
echo $error;
echo $fsize2;
}
}
break;
case 'dobi':
$q = mysql_query("select * from obiav order by id desc;");
if (mysql_affected_rows() == 0) {
echo $fsize1;
echo "Объявлений нет!!!<br/>\n";
echo $fsize2;
} else {
if(empty($action)) {
while($arr=mysql_fetch_array($q)) {
echo $fsize1;
echo "<a href=\"apanel.php?action=del&$ses&go=dobi&mid=".$arr['id']."$takep\">".$arr['title']."</a><br/>";
echo $fsize2;
}
} else {
if(mysql_query("delete from obiav where id='".$mid."' limit 1;")){
echo $fsize1;
echo "<b>Объявление успешно удалено!</b><br/>";
echo $fsize2;
}
}
}
break;
case 'view':
if (!ctype_digit($nick)) {
$nick=trim($nick);
if($nick=="")$nick=0;
$latuser=strtolower($nick);
$ruser = rus_to_k($nick);
if($ruser==$nick){
$select = mysql_query ("Select id,user,pass,posts,status,level,credits,gposts,mafcredits,votefoto,byeotv,inv,user_ip,user_soft,img from users where latuser = '".$latuser."'");
} else {
$select = mysql_query ("select id,user,pass,posts,status,level,credits,gposts,mafcredits,votefoto,byeotv,inv,user_ip,user_soft,img from users where ruser = '".$ruser."'");
}
} else {
if (!ctype_digit($nick)) {header("Location: index.php"); die;}
$select = mysql_query ("Select id,user,pass,posts,status,level,credits,gposts,mafcredits,votefoto,byeotv,inv,user_ip,user_soft,img from users where id = '".$nick."'");
}
if (mysql_affected_rows() == 0) {
echo $fsize1;
echo "Нет такого юзера<br/>\n";
echo $fsize2;
break;
}
$inf = mysql_fetch_array ($select);
$usid = $inf["id"];
$us_ip = $inf["user_ip"];
$us_soft = $inf["user_soft"];
$level2=$inf["level"];
if($level2 > $row["level"]){
echo $fsize1;
echo "Запрещено редактировать вышестоящих пользователей!<br/>\n";
echo $fsize2;
break;
}
echo $fsize1;
echo "<b>ID-Номер</b>:<br/>\n";
echo "$usid<br/>\n";
if($row["level"]==8) {
echo "<b>IP-юзера</b>:<br/>\n";
echo "$us_ip<br/>\n";
echo "<b>Soft-юзера</b>:<br/>\n";
echo "$us_soft<br/>\n";
}
if ($ver=="xhtml") {echo "<form method=\"POST\" action=\"apanel.php?go=upd&$ses$takep\" name=\"auth\">\n";
if($row["level"]!=8 && $ver!="wml") {
echo"<input type='hidden' name='gposts$re' value='$inf[gposts]' />";
echo"<input type='hidden' name='posts$re' value='$inf[posts]' />";
echo"<input type='hidden' name='credits$re' value='$inf[credits]' />";
echo"<input type='hidden' name='byeotv$re' value='$inf[byeotv]' />";
echo"<input type='hidden' name='mafcredits$re' value='$inf[mafcredits]' />";
echo"<input type='hidden' name='votefoto$re' value='$inf[votefoto]' />";
}
$re=="";}
else {$re=$ref;}
echo "<b>Ник</b>:<br/>\n";
echo $fsize2;
echo "<input name=\"upnick$re\" maxlength=\"35\" value=\"$inf[user]\" title=\"nick\"/><br/>\n";
echo $fsize1;
echo "<b>Пароль (заполнять только если изменять!!!)</b>:<br/>\n";
echo $fsize2;
echo "<input name=\"upass$re\" maxlength=\"32\" value=\"\" title=\"upass\"/><br/>\n";
echo $fsize1;
if($row["level"]==8) {
echo "<b>А постов та</b>:<br/>\n";
echo $fsize2;
echo "<input name=\"posts$re\" value=\"$inf[posts]\" title=\"posts\"/><br/>\n";
echo $fsize1;
echo "<b>Игровой баланс</b>:<br/>\n";
echo $fsize2;
echo "<input name=\"gposts$re\" value=\"$inf[gposts]\" title=\"posts\"/><br/>\n";
echo $fsize1;
echo "<b>Ответов в викторине</b>:<br/>\n";
echo $fsize2;
echo "<input name=\"credits$re\" value=\"$inf[credits]\" title=\"posts\"/><br/>\n";
echo $fsize1;
echo "<b>Куплено ответов</b>:<br/>\n";
echo $fsize2;
echo "<input name=\"byeotv$re\" value=\"$inf[byeotv]\" title=\"posts\"/><br/>\n";
echo $fsize1;
echo "<b>Кредитов в Мафие</b>:<br/>\n";
echo $fsize2;
echo "<input name=\"mafcredits$re\" value=\"$inf[mafcredits]\" title=\"posts\"/><br/>\n";
echo $fsize1;
echo "<b>Голосов за фото</b>:<br/>\n";
echo $fsize2;
echo "<input name=\"votefoto$re\" value=\"$inf[votefoto]\" title=\"votefoto\"/><br/>\n";
echo $fsize1; }
echo "<b>Статус</b>:<br/>\n";
echo $fsize2;
echo "<input name=\"status$re\" maxlength=\"12\" value=\"$inf[status]\" title=\"status\"/><br/>\n";
echo $fsize1;
echo "<b>Невидимость</b>:<br/>\n";
echo $fsize2;
echo "<select name=\"inv$re\">\n";
if ($inf["inv"] == 0)echo "<option value=\"0\">Отключена</option>\n";
elseif ($inf["inv"] == 1)echo "<option value=\"1\">Включена</option>\n";
elseif ($inf["inv"] == 2)echo "<option value=\"2\">Полный игнор</option>\n";
if ($inf["inv"]!=0) echo "<option value=\"0\">Отключена</option>\n";
if ($inf["inv"]!=1) echo "<option value=\"1\">Включена</option>\n";
if ($inf["inv"]!=2) echo "<option value=\"2\">Полный игнор</option>\n";
echo "</select><br/>\n";
echo $fsize1;
echo "<b>Уровень</b>:<br/>\n";
echo $fsize2;
echo "<select name=\"level$re\">\n";
if($inf["level"] != 0) {
$i = $inf["level"];
$levelselect = @mysql_query ("Select name from levels where level='".$i."'");
$levels = @mysql_fetch_array($levelselect);
$levelname=$levels["name"];;
echo "<option value=\"".$i."\">".$i."-".$levelname."</option>\n";
}
if (($inf["level"]!=8)&&($row["level"]==8)){
for($i = 0; $i <= 8; $i++) {
$levelselect = @mysql_query ("Select name from levels where level='".$i."'");
$levels = @mysql_fetch_array($levelselect);
$levelname=$levels["name"];;
echo "<option value=\"".$i."\">".$i."-".$levelname."</option>\n";
}
} else {
for($i = 0; $i <= 7; $i++) {
$levelselect = @mysql_query ("Select name from levels where level='".$i."'");
$levels = @mysql_fetch_array($levelselect);
$levelname=$levels["name"];;
echo "<option value=\"".$i."\">".$i."-".$levelname."</option>\n";
}
}
echo "</select><br/>\n";
if ($ver=="wml"){
echo $fsize1;
echo"изменить скин на XHTML чтобы ред. анкеты!!!<br/>";}else{
echo "<input type=\"hidden\" name=\"upid\" value=\"$usid\"/>\n";
echo "<input type=\"submit\" value=\"Сохранить\" name=\"enter\"><br/>\n";
}
if ($inf["img"]!=""){
echo $fsize1;
echo $divide;
echo "<a href=\"apanel.php?go=delfoto&$ses&usid=$usid$takep\">Удалить фото</a><br/>";
echo $fsize2;
}
echo "<br/><a href=\"deluser.php?$ses&nk=$usid&ref=$ref\">Удалить ник</a><br/>\n";
echo "<a href=\"kick.php?$ses&nk=$usid&ref=$ref\">Пнуть</a><br/>\n";
echo "<a href=\"bann.php?$ses&nk=$usid&rm=$rm&ref=$ref\">Забанить ник</a><br/>\n";
echo "<a href=\"bannaip.php?$ses&nk=$usid&rm=$rm&ref=$ref\">Банн ip+soft!!!</a><br/>\n";
break;
case 'delfoto':
echo $fsize1;
if (!ctype_digit($usid)) {header("Location: index.php"); die;}
$select2 = mysql_query ("Select img from users where id = '".$usid."'");
if (mysql_affected_rows() == 0) {
echo $fsize1;
echo "Нет такого юзера<br/>\n";
echo $fsize2;
break;
}
$inf2 = mysql_fetch_array ($select);
$myfotos = $inf2["img"];
$ras=explode(".", $myfotos);
$types=$ras[1];
if (!file_exists("photos/".$usid.".".$types."")){
echo "У юзера не установлено фото!<br/>\n";
}else{
if (!ctype_digit($usid)) { header("Location: index.php"); die; }
if(@mysql_query ("Update users set img ='' where id ='".$usid."';")){
unlink ("photos/".$usid.".".$types."");
echo "Ваше фото успешно удалено.<br/>";
}else{
echo "Ошибка удаления фото.<br/>";
}
}
echo $fsize2;
break;
case 'upd':
$upnick=trim($upnick);
if($upnick==""){
echo $fsize1;
echo "error<br/>\n";
echo $fsize2;
break;
}
if (!ctype_digit($upid)) {header("Location: index.php"); die;}
$a = mysql_query("SELECT user,level FROM users WHERE id ='".$upid."'");
$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."')");
} else {
mysql_query ("select id from users where (ruser = '".$ruser."')and(user != '".$nick."')");
}
$vn=mysql_fetch_array(mysql_query("SELECT `id` FROM `users` WHERE `user`='" . $upnick . "';"));
if($nick!=$upnick){
if(!empty($vn[0])){echo "Ник уже занят!!!<br/>";
echo "<a href=\"apanel.php?$ses$takep\">Админка</a><br/>\n";
echo "<a href=\"enter.php?$ses&ref=$ref\">Прихожая</a><br/>\n";
echo $fsize2;
if ($ver=="wml")echo "</p></card></wml>";
else echo "</div></body></html>";
$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();
exit;}}
$upnick = mysql_escape_string(check($upnick));
$upass = mysql_escape_string(check($upass));
$ruser = mysql_escape_string(check($ruser));
$latuser = mysql_escape_string(check($latuser));
$status = mysql_escape_string(check($status));
if($row["level"]==8) {
$credits = mysql_escape_string(check($credits));
$mafcredits = mysql_escape_string(check($mafcredits));
$gposts = mysql_escape_string(check($gposts));
}
$upnick = mysql_escape_string(check($upnick));
$upass = mysql_escape_string(check($upass));
$ruser = mysql_escape_string(check($ruser));
$latuser = mysql_escape_string(check($latuser));
$status = mysql_escape_string(check($status));
$credits = mysql_escape_string(check($credits));
$mafcredits = mysql_escape_string(check($mafcredits));
$gposts = mysql_escape_string(check($gposts));
if($row["level"]==8) {
if (!ctype_digit($posts)) {header("Location: index.php"); die;}
if (!ctype_digit($votefoto)) {header("Location: index.php"); die;}
if (!ctype_digit($byeotv)) {header("Location: index.php"); die;}}
if (!ctype_digit($inv)) {header("Location: index.php"); die;}
if (!ctype_digit($level)) {header("Location: index.php"); die;}
if (!ctype_digit($upid)) {header("Location: index.php"); die;}
if(!empty($upass)){
$pss = md5($upass);
if ($ruser==$upnick) $ins_str = "Update users set user='".$upnick."', pass='".$pss."', posts='".$posts."', gposts='".$gposts."', credits='".$credits."', mafcredits='".$mafcredits."', votefoto='".$votefoto."', byeotv='".$byeotv."', status='".$status."', inv='".$inv."', level='".$level."', ruser = '', latuser = '".$latuser."' where id ='".$upid."'";
else $ins_str = "Update users set user='".$upnick."', pass='".$pss."', posts='".$posts."',gposts='".$gposts."',credits='".$credits."',mafcredits='".$mafcredits."', votefoto='".$votefoto."', byeotv='".$byeotv."', status='".$status."', inv='".$inv."', level='".$level."', ruser = '".$ruser."', latuser = '' where id ='".$upid."'";}
if(empty($upass)){
$pss = md5($upass);
if ($ruser==$upnick) $ins_str = "Update users set user='".$upnick."', posts='".$posts."', gposts='".$gposts."', credits='".$credits."', mafcredits='".$mafcredits."', votefoto='".$votefoto."', byeotv='".$byeotv."', status='".$status."', inv='".$inv."', level='".$level."', ruser = '', latuser = '".$latuser."' where id ='".$upid."'";
else $ins_str = "Update users set user='".$upnick."', posts='".$posts."',gposts='".$gposts."',credits='".$credits."',mafcredits='".$mafcredits."', votefoto='".$votefoto."', byeotv='".$byeotv."', status='".$status."', inv='".$inv."', level='".$level."', ruser = '".$ruser."', latuser = '' where id ='".$upid."'";}
if (mysql_query ($ins_str)) {
if ($prl != $level){
$levelselect = @mysql_query ("Select name from levels where level='".$level."'");
$levels = @mysql_fetch_array($levelselect);
$ur=$levels["name"];
for ($i=0; $i<=23; $i++){
$st = time();
$today=date ("H:i");
$levelselect = @mysql_query ("Select name from levels where level='".$row["level"]."'");
$levels = @mysql_fetch_array($levelselect);
$lev=$levels["name"];
$mes = "<b>$lev $us присваивает $nick уровень $ur</b>";
$rnd = rand(0,99999999);
@mysql_query ("Insert into room{$i} set klu4= '".$rnd."', time='".$today."', who='".$administration."', message='".$mes."', id='".$st."', towhom='', hid='0', usid='1', komu=''");
}
$levelselect = @mysql_query ("Select name from levels where level='".$row["level"]."'");
$levels = @mysql_fetch_array($levelselect);
$lev=$levels["name"];
$data = date("d-M-Y [H:i]");
$kol = rand(0,99999999);
$time = time();
$topic = "Поздравляю!!!";
$message = "Приветствую <b>".$nick."</b>!!! и поздравляю. Вы заслужили того к чему стремились и ".$lev." <b>".$us."</b> привёл приговор в исполнение. Вы получили уровень <b>".$ur."</b>.";
@mysql_query("Insert into zapiski set klu4='".$kol."', who ='".$administration."', idwho ='1', message = '".$message."', towhom = '".$nick."', idtowhom = '".$upid."', time = '".$time."', readd = '0', topic = '".$topic."', date='".$data."'");
}
echo $fsize1;
echo "Профайл изменен<br/>\n";
echo $fsize2;
} else {
echo $fsize1;
echo "Database error:<br/>\n";
echo $fsize2;
echo " ".mysql_error()." ";
}
break;
case 'addshutki':
echo $fsize1;
echo "При включенном транслите шутки транслитерируются<br/>\n";
echo "Шутка:<br/>\n";
echo $fsize2;
if ($ver=="xhtml")echo "<form method=\"POST\" action=\"apanel.php?go=goaddshutki&$ses$takep\" name=\"auth\">\n";
echo "<input name=\"anek\" maxlength=\"255\" title=\"quest\"/><br/>\n";
echo $fsize1;
echo $divide;
echo $fsize2;
if ($ver=="wml"){
echo $fsize1;
echo "<anchor title=\"go\">Добавить<go href=\"apanel.php?go=goaddshutki&$ses$takep\" method=\"post\">\n";
echo "<postfield name=\"anek\" value=\"$(anek)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}else{
echo "<input type=\"submit\" value=\"Добавить\" name=\"enter\"><br/>\n";
}
break;
case 'goaddshutki':
if ($row["translit"]==1)$anek = trun_to_rus($anek);
$anek = str_replace(chr("13"), " ", $anek);
$anek = str_replace(chr("10"), " ", $anek);
$anek = trim(" $anek ");
$anek = ereg_replace(" +"," ",$anek);
$anek=substr($anek,0,400);
$anek = str_replace("\n", " ", $anek);
$anek = str_replace("$", "$$", $anek);
$anek = mysql_escape_string(check($anek));
$r = mysql_query("select * from shutki");
$k = mysql_affected_rows()+1;
mysql_query ("Insert into shutki set klu4= '".$k."', message='".$anek."'");
if (mysql_error() == false){
echo $fsize1;
echo "Анекдот был добавлен в базу<br/>\n";
echo "Всего анекдотов: $k <br/>\n";
echo $fsize2;
} else {
echo $fsize1;
echo "Ошибка при записи!<br/>\n";
echo $fsize2;
echo "ERROR ".mysql_error()." ";
}
break;
case 'addvopr':
echo $fsize1;
echo "При включенном транслите вопросы и ответы транслитерируются<br/>\n";
echo "Вопрос:<br/>\n";
echo $fsize2;
if ($ver=="xhtml")echo "<form method=\"POST\" action=\"apanel.php?go=goaddvopr&$ses$takep\" name=\"auth\">\n";
echo "<input name=\"vopros\" maxlength=\"255\" title=\"quest\"/><br/>\n";
echo $fsize1;
echo "Ответ:<br/>\n";
echo $fsize2;
echo "<input name=\"answ\" maxlength=\"60\" title=\"answ\"/><br/>\n";
if ($ver=="wml"){
echo $fsize1;
echo "<anchor title=\"go\">Добавить<go href=\"apanel.php?go=goaddvopr&$ses$takep\" method=\"post\">\n";
echo "<postfield name=\"vopros\" value=\"$(vopros)\"/>\n";
echo "<postfield name=\"answ\" value=\"$(answ)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}else{
echo "<input type=\"submit\" value=\"Добавить\" name=\"enter\"><br/>\n";
}
break;
case 'goaddvopr':
$vopros = mysql_escape_string(check($vopros));
$answ = mysql_escape_string(check($answ));
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 $fsize1;
echo "Вопрос был добавлен в базу<br/>\n";
echo "Всего вопросов: $k <br/>\n";
echo $fsize2;
} else {
echo $fsize1;
echo "Ошибка при записи!<br/>\n";
echo $fsize2;
echo "ERROR ".mysql_error()." ";
}
break;
case 'tell':
echo $fsize1;
echo "Текст:<br/>\n";
echo $fsize2;
if ($ver=="xhtml")echo "<form method=\"POST\" action=\"apanel.php?go=gotell&$ses$takep\" name=\"auth\">\n";
echo "<input name=\"txt\" maxlength=\"1255\" title=\"text\"/><br/>\n";
if ($ver=="wml"){
echo $fsize1;
echo "<anchor title=\"go\">Ok<go href=\"apanel.php?go=gotell&$ses$takep\" method=\"post\">\n";
echo "<postfield name=\"txt\" value=\"$(txt)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}else{
echo "<input type=\"submit\" value=\"Ok\" name=\"enter\"><br/>\n";
}
break;
case 'gotell':
if ($row["translit"]==1)$txt = trun_to_rus($txt);
$rnd = rand(0,99999999);
$today=date ("H:i");
$time = time();
$txt = mysql_escape_string(check($txt));
$txt = "<b>$txt</b>";
for ($num = 0; $num <= 22; $num++){
$room = "room".$num;
if (!ctype_digit($id)) {header("Location: index.php"); die;}
mysql_query ("Insert into $room set klu4= '".$rnd."', time='".$today."', who='".$us."', message='".$txt."', id='".$time."', towhom='', hid='0', usid='".$id."', komu=''"); }
if (mysql_error() == false){
echo $fsize1;
echo "Объявление сделано<br/>\n";
echo $fsize2;
} else {
echo $fsize1;
echo "Ошибка при записи!<br/>\n";
echo $fsize2;
echo "ERROR ".mysql_error()." ";
}
break;
case 'fullign':
$r = mysql_query ("SELECT * from users WHERE inv = '2' ");
$a = mysql_fetch_array($r);
while ($a !== false){
$pid = $a["id"];
if (!ctype_digit($pid)) {header("Location: index.php"); die;}
mysql_query("UPDATE users set inv = '0' WHERE id = '".$pid."'");
$a = mysql_fetch_array($r);
}
echo $fsize1;
echo "Полный Игнор снят со всех пользователей!<br/>\n";
echo $fsize2;
break;
case 'clearzap':
$time = time()-604800;
mysql_query ("DELETE from zapiski WHERE time<$time");
echo $fsize1;
echo "Удалены все записки более чем недельной давности<br/>\n";
echo $fsize2;
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 $fsize1;
echo "<a href=\"apanel.php?act=cl&$ses&go=clbanip&nk=".$arr['klu4']."$takep\">".$arr['user']." ".$arr['ip']." ".$arr['soft']."</a><br/>";
echo $divide;
echo $fsize2;
}
if (mysql_affected_rows() != 0){
echo $fsize1;
echo "<a href=\"apanel.php?$ses&go=clbanip&act=unbannall$takep\">Разбанить все IP+SOFT</a><br/>";
echo $fsize2;
} else {
echo $fsize1;
echo "Нет забаненых по IP+SOFT!<br/>";
echo $fsize2;
}
} else if ($act=="unbannall") {
mysql_query ("DELETE from bannlist");
echo $fsize1;
echo "Таблица банов по ip+soft очищена<br/>\n";
echo $fsize2;
} else {
if (!ctype_digit($nk)) {header("Location: index.php"); die;}
if(mysql_query("delete from bannlist where klu4='".$nk."'")){
echo $fsize1;
echo "IP+SOFT успешно разбаннены!<br/>";
echo $divide;
echo "<a href=\"apanel.php?$ses&go=clbanip$takep\">Разбанить ещё</a><br/>";
echo $fsize2;
}
}
break;
case 'clroomtime':
echo $fsize1;
echo "Комнаты будут автоматически очищены через 3 минуты!<br/>\n";
echo $fsize2;
if(isset($rm)) echo "<a href=\"chat.php?$ses$takep\">В чат</a><br/>";
$fp=fopen("log/clear.dat", "w");
fclose($fp);
$f=fopen("log/clear.dat","a+");
flock($f,LOCK_EX);
$cleardata = time() + 180;
fwrite($f,$cleardata);
fflush($f);
flock($f,LOCK_UN);
fclose($f);
$rnd = rand(0,99999999);
$mes = "<b>Внимание! Через 3 минуты будет очистка комнат. И не говорите потом, что вас не предупреждали =)</b>";
$today=date("H:i");
$time = getmicrotime();
for ($num = 0; $num <= 23; $num++){
$ranec = "room".$num;
mysql_query ("Insert into $ranec set klu4= '".$rnd."', time='".$today."', who='".$row["user"]."', message='".$mes."', id='".$time."', towhom='', hid='".$row["id"]."', usid='".$row["id"]."', komu=''");
mysql_query("ANALYZE TABLE $ranec");
}
break;
case 'clroom':
echo $fsize1;
echo "Таблицы комнат очищены!<br/>\n";
echo $fsize2;
if(isset($rm)){
echo $fsize1;
echo "<a href=\"chat.php?$ses$takep\">в чат</a><br/>";
echo $fsize2;
}
for ($num = 0; $num <= 23; $num++){
$room = "room".$num;
$res = @mysql_query ("Select id from $room order by id desc");
$kol = mysql_affected_rows();
for ($k = 0; $k <= $kol; $k++){
$lines = mysql_fetch_array ($res);
$kl = $lines["id"];
@mysql_query ("Delete from $room where id = '".$kl."'");
}
}
break;
case 'clrm':
$room = "room".$rm;
$res = @mysql_query ("Select id from $room order by id desc");
$lines = mysql_fetch_array ($res);
$kl = $lines["id"];
if (@mysql_query ("Delete from $room where id = '".$kl."'")){
echo $fsize1;
echo "Таблица комнаты очищена!<br/>\n";
echo $fsize2;
}else{
echo $fsize1;
echo "Ошибка очистки комнаты!<br/>\n";
echo $fsize2;
}
if(isset($rm)){
echo $fsize1;
echo "<a href=\"chat.php?$ses$takep\">в чат</a><br/>";
echo $fsize2;
}
break;
case 'fullignmake':
if (!ctype_digit($nk)) {header("Location: index.php"); die;}
$select = @mysql_query ("Select * from users where id='".$nk."'");
$inf = mysql_fetch_array ($select);
$level = $inf["level"];
$fignik = $inf["user"];
$figid = $inf["id"];
if (($level == 7)||($level == 8)){
echo $fsize1;
echo "Админа нельзя добавить в ПИ!!!<br/>\n";
echo $fsize2;
break;
}
if (!ctype_digit($figid)) {header("Location: index.php"); die;}
mysql_query ("UPDATE users SET inv = '2' WHERE id = '".$figid."'");
$rnd = rand(0,99999999);
$today=date ("H:i");
$time = time();
$room = "room".$rm;
$txt = "".$us." Наказал юзера <b>".$fignik."</b> за серьёзные нарушения Устава чата поместив его в Полный игнор.";
mysql_query ("Insert into $room set klu4= '".$rnd."', time='".$today."', who='".$administration."', message='".$txt."', id='".$time."', towhom='', hid='0', usid='1', komu=''");
echo $fsize1;
echo "$fignik в игноре для всех!!!<br/>\n";
echo $fsize2;
break;
case 'clbanniks':
$fp=fopen("log/bannlist.dat", "w");
fclose($fp);
@mysql_query ("update users set banned = '0' where banned = '1' ");
echo $fsize1;
echo "Все ники разбанены!<br/>\n";
echo $fsize2;
break;
case 'clpinniks':
$fp=fopen("log/pinlist.dat", "w");
fclose($fp);
@mysql_query ("UPDATE users SET kik = '0', whokik = '', whykik = '' where kik!='0'");
echo $fsize1;
echo "Все ники успешно освобождены!<br/>\n";
echo $fsize2;
break;
case 'clearlogs':
$fp=fopen("log/intim.dat", "w");
fclose($fp);
$fp=fopen("log/admroom.dat", "w");
fclose($fp);
$fp=fopen("log/admlog.dat", "w");
fclose($fp);
$fp=fopen("log/stlog.dat", "w");
fclose($fp);
$fp=fopen("log/bannlist.dat", "w");
fclose($fp);
$fp=fopen("log/banniplist.dat", "w");
fclose($fp);
$fp=fopen("log/pinlist.dat", "w");
fclose($fp);
echo $fsize1;
echo "Все лог-файлы очищены!<br/>\n";
echo $fsize2;
break;
case 'unban':
$q = mysql_query("select id,user from users where banned='1' order by id desc;");
if(empty($act)) {
while($arr=mysql_fetch_array($q)) {
echo $fsize1;
echo "<a href=\"apanel.php?act=unbann&$ses&go=unban&nk=".$arr['id']."$takep\">".$arr['user']."</a><br/>";
echo $fsize2;
}
if (mysql_affected_rows() != 0){
echo $fsize1;
echo $divide;
echo "<a href=\"apanel.php?$ses&go=clbanniks$takep\">Разбанить все ники</a><br/>";
echo $fsize2;
} else {
echo $fsize1;
echo "Нет забаненых ников!<br/>";
echo $fsize2;
}
} else {
if (!ctype_digit($nk)) {header("Location: index.php"); die;}
if(mysql_query("update users set banned = '0' where id='".$nk."'")){
echo $fsize1;
echo "Ник разбанен!<br/>";
echo $divide;
echo "<a href=\"apanel.php?$ses&go=unban$takep\">Разбанить ещё?</a><br/>";
echo $fsize2;
}
}
break;
case 'unpin':
$q = mysql_query("select id,user from users where kik!='0' order by id desc;");
if(empty($act)) {
while($arr=mysql_fetch_array($q)) {
echo $fsize1;
echo "<a href=\"apanel.php?act=unbann&$ses&go=unpin&nk=".$arr['id']."$takep\">".$arr['user']."</a><br/>";
echo $fsize2;
}
if (mysql_affected_rows() == 0){
echo $fsize1;
echo "Нет выпнутых ников!<br/>";
echo $fsize2;
}else{
echo $fsize1;
echo $divide;
echo "<a href=\"apanel.php?$ses&go=clpinniks$takep\">Освободить все ники</a><br/>";
echo $fsize2;
}
} else {
if (!ctype_digit($nk)) {header("Location: index.php"); die;}
if(mysql_query("UPDATE users SET kik = '0', whokik = '', whykik = '' where id='".$nk."'")){
print $fsize1;
echo "Ник освобождён!<br/>";
echo $divide;
echo "<a href=\"apanel.php?$ses&go=unpin$takep\">Освободить ещё?</a><br/>";
echo $fsize2;
}
}
break;
case 'clbanip':
$q = mysql_query("select klu4,ip,soft from bannlist order by klu4 desc;");
if(empty($act)) {
while($arr=mysql_fetch_array($q)) {
echo $fsize1;
print "<a href=\"apanel.php?act=cl&$ses&go=clbanip&nk=".$arr['klu4']."$takep\">".$arr['ip']." ".$arr['soft']."</a><br/>";
echo $divide;
echo $fsize2;
}
if (mysql_affected_rows() != 0){
echo $fsize1;
echo "<a href=\"apanel.php?$ses&go=clbanip&act=unbannall$takep\">Разбанить всех по IP+SOFT</a><br/>";
echo $fsize2;
} else {
echo $fsize1;
echo "Нет забаненых по IP+SOFT!<br/>";
echo $fsize2;
}
} else if ($act=="unbannall") {
mysql_query ("DELETE from bannlist");
echo $fsize1;
echo "Таблица банов по ip+soft очищена<br/>\n";
echo $fsize2;
} else {
if (!ctype_digit($nk)) {header("Location: index.php"); die;}
if(mysql_query("delete from bannlist where klu4='".$nk."'")){
echo $fsize1;
echo "IP+SOFT успешно разбаннены!<br/>";
echo $divide;
echo " <a href=\"apanel.php?$ses&go=clbanip$takep\">Разбанить ещё?</a><br/>";
echo $fsize2;
}
}
break;
case 'editrooms':
$q = mysql_query("select rm,name from rooms");
if(empty($act)) {
while($arr=mysql_fetch_array($q)) {
echo $fsize1;
echo "<a href=\"apanel.php?act=rnm&$ses&go=editrooms&rms=".$arr['rm']."$takep\">".$arr['rm'].". ".$arr['name']."</a><br/>";
echo $fsize2;
}
} elseif ($act=="dornm") {
if (!ctype_digit($rms)) {header("Location: index.php"); die;}
$roomname = mysql_escape_string(check($roomname));
mysql_query ("update rooms set name='".$roomname."' where rm='".$rms."'");
echo $fsize1;
echo "Комната успешно переименованна!<br/>\n";
echo "<a href=\"apanel.php?$ses&go=editrooms$takep\">Редактировать комнаты</a><br/>";
echo $fsize2;
} else {
if (!ctype_digit($rms)) {header("Location: index.php"); die;}
$q = mysql_query("select name from rooms where rm='".$rms."'");
$arr=mysql_fetch_array($q);
$name=$arr["name"];
echo $fsize1;
echo "Название комнаты:<br/>\n";
echo $fsize2;
if ($ver=="xhtml") echo "<form method=\"POST\" action=\"apanel.php?act=dornm&$ses&go=editrooms&rms=$rms$takep\" name=\"auth\">\n";
echo "<input name=\"roomname\" maxlength=\"200\" value=\"$name\" title=\"roomname\"/><br/>\n";
if ($ver=="wml"){
echo $fsize1;
echo "<anchor title=\"go\">Ok<go href=\"apanel.php?act=dornm&$ses&go=editrooms&rms=$rms$takep\" method=\"post\">\n";
echo "<postfield name=\"roomname\" value=\"$(roomname)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}else{
echo "<input type=\"submit\" value=\"Ok\" name=\"enter\"><br/>\n";
}
echo $fsize1;
echo $divide;
echo "<a href=\"apanel.php?$ses&go=editrooms$takep\">Редактировать комнаты</a><br/>";
echo $fsize2;
}
break;
case 'editposroom':
if(empty($act)) {
echo $fsize1;
echo "Позиция:<br/>";
echo $fsize2;
if ($ver=="xhtml") echo "<form method=\"POST\" action=\"apanel.php?act=update&$ses&go=editposroom$takep\" name=\"auth\">\n";
echo "<input size=\"2\" name=\"pos\" format=\"*N\"/><br/>";
echo $fsize1;
echo "Комната:<br/>";
echo $fsize2;
echo "<select name=\"name\">";
$q = @mysql_query("select * from rooms;");
while ($dbdata = @mysql_fetch_array($q)) {
$rm=$dbdata["rm"];
$val1=$dbdata["name"];
echo "<option value=\"".$rm."\">".$val1."</option>";
}
echo "</select><br/>";
if ($ver=="wml"){
echo $fsize1;
echo "<anchor>Изменить<go href=\"apanel.php?act=update&$ses&go=editposroom$takep\" method=\"post\">";
echo "<postfield name=\"name\" value=\"$(name)\"/>";
echo "<postfield name=\"pos\" value=\"$(pos)\"/>";
echo "</go></anchor>";
echo $fsize2;
echo "<br/>";
}else{
echo "<input type=\"submit\" value=\"Изменить\" name=\"enter\"><br/>\n";
}
} else {
if (!ctype_digit($pos)) {header("Location: index.php"); die;}
if (!ctype_digit($name)) {header("Location: index.php"); die;}
if(@mysql_query("update rooms set pos='".$pos."' where rm='".$name."';")){
echo $fsize1;
echo "<b>Позиция комнаты изменена</b><br/>";
$fsize2;
}
}
break;
case 'bots':
$setting = @mysql_query ("Select * from setting where klu4=1");
$set = mysql_fetch_array ($setting);
if ($ver=="xhtml") echo "<form method=\"POST\" action=\"apanel.php?$ses&go=updbots$takep\" name=\"auth\">\n";
echo $fsize1;
echo "<b>Настройка Ботов</b><br/>\n";
echo $divide;
echo "Регистрация в чате:<br/>\n";
echo $fsize2;
echo "<select name=\"reg\">\n";
if($set["reg"] == 0){
echo "<option value=\"0\">Запрещена</option>\n";
echo "<option value=\"1\">Разрешена</option>\n";
} else {
echo "<option value=\"1\">Разрешена</option>\n";
echo "<option value=\"0\">Запрещена</option>\n";
}
echo "</select><br/>\n";
echo $fsize1;
echo $divide;
echo "Регистрация на русском:<br/>\n";
echo $fsize2;
echo "<select name=\"rus\">\n";
if($set["rus"] == 0){
echo "<option value=\"0\">Запретить</option>\n";
echo "<option value=\"1\">Разрешить</option>\n";
} else {
echo "<option value=\"1\">Разрешить</option>\n";
echo "<option value=\"0\">Запретить</option>\n";
}
echo "</select><br/>\n";
echo $fsize1;
echo "Принимать ответы с компа (викт):<br/>\n";
echo $fsize2;
echo "<select name=\"vict\">\n";
if($set["vict"] == 0){
echo "<option value=\"0\">Нет</option>\n";
echo "<option value=\"1\">Да</option>\n";
} else {
echo "<option value=\"1\">Да</option>\n";
echo "<option value=\"0\">Нет</option>\n";
}
echo "</select><br/>\n";
echo $fsize1;
echo "Интервал Умника (сек.):<br/>\n";
echo $fsize2;
echo "<select name=\"victint\">\n";
if($set["victint"] === "10"){
echo "<option value=\"10\">10</option>\n";
}
elseif($set["victint"] === "30"){
echo "<option value=\"30\">30</option>\n";
}
elseif($set["victint"] === "60"){
echo "<option value=\"60\">60</option>\n";
}
elseif($set["victint"] === "120"){
echo "<option value=\"120\">120</option>\n";
}
echo "<option value=\"10\">10</option>\n";
echo "<option value=\"30\">30</option>\n";
echo "<option value=\"60\">60</option>\n";
echo "<option value=\"120\">120</option>\n";
echo "</select><br/>\n";
echo $fsize1;
echo "Шутник:<br/>\n";
echo $fsize2;
echo "<select name=\"shut\">\n";
if($set["shut"] == 0){
echo "<option value=\"0\">Включен</option>\n";
echo "<option value=\"1\">Отключен</option>\n";
} else {
echo "<option value=\"1\">Отключен</option>\n";
echo "<option value=\"0\">Включен</option>\n";
}
echo "</select><br/>\n";
echo $fsize1;
echo "Интервал шутника (мин.):<br/>\n";
echo $fsize2;
echo "<select name=\"shutint\">\n";
if($set["shutint"] === "600"){
echo "<option value=\"600\">10</option>\n";
}
elseif($set["shutint"] === "1800"){
echo "<option value=\"1800\">30</option>\n";
}
elseif($set["shutint"] === "3600"){
echo "<option value=\"3600\">60</option>\n";
}
elseif($set["shutint"] === "7200"){
echo "<option value=\"7200\">120</option>\n";
}
echo "<option value=\"600\">10</option>\n";
echo "<option value=\"1800\">30</option>\n";
echo "<option value=\"3600\">60</option>\n";
echo "<option value=\"7200\">120</option>\n";
echo "</select><br/>\n";
echo $fsize1;
echo "Комнаты для шутника:<br/>\n";
echo "С\n";
echo $fsize2;
echo "<input size=\"2\" name=\"roomon\" maxlength=\"2\" value=\"$set[roomon]\" title=\"rmstart\"/>\n";
echo $fsize1;
echo "до:\n";
echo $fsize2;
echo "<input size=\"2\" name=\"roomoff\" maxlength=\"2\" value=\"$set[roomoff]\" title=\"rmfinish\"/><br/>\n";
echo $fsize1;
echo "Продавец:<br/>\n";
echo $fsize2;
echo "<select name=\"prod\">\n";
if($set["prod"] == 0){
echo "<option value=\"0\">Включен</option>\n";
echo "<option value=\"1\">Отключен</option>\n";
} else {
echo "<option value=\"1\">Отключен</option>\n";
echo "<option value=\"0\">Включен</option>\n";
}
echo "</select><br/>\n";
echo $fsize1;
echo $divide;
echo "<b>Имена ботов</b><br/>\n";
echo $divide;
echo $fsize2;
$system = @mysql_fetch_array(@mysql_query ("Select user from users where id='1' LIMIT 1;"));
echo $fsize1;
echo "ID-1:\n";
echo $fsize2;
echo "<input name=\"system\" maxlength=\"13\" value=\"$system[0]\" title=\"System\"/><br/>\n";
$umnik = @mysql_fetch_array(@mysql_query ("Select user from users where id='2' LIMIT 1;"));
echo $fsize1;
echo "ID-2:\n";
echo $fsize2;
echo "<input name=\"umnik\" maxlength=\"13\" value=\"$umnik[0]\" title=\"Umnik\"/><br/>\n";
$shutnik = @mysql_fetch_array(@mysql_query ("Select user from users where id='3' LIMIT 1;"));
echo $fsize1;
echo "ID-3:\n";
echo $fsize2;
echo "<input name=\"shutnik\" maxlength=\"13\" value=\"$shutnik[0]\" title=\"Shutnik\"/><br/>\n";
$prodavec = @mysql_fetch_array(@mysql_query ("Select user from users where id='4' LIMIT 1;"));
echo $fsize1;
echo "ID-4:\n";
echo $fsize2;
echo "<input name=\"prodavec\" maxlength=\"13\" value=\"$prodavec[0]\" title=\"Prodavec\"/><br/>\n";
$mafia = @mysql_fetch_array(@mysql_query ("Select user from users where id='5' LIMIT 1;"));
echo $fsize1;
echo "ID-5:\n";
echo $fsize2;
echo "<input name=\"mafia\" maxlength=\"13\" value=\"$mafia[0]\" title=\"Mafia\"/><br/>\n";
$trahtenberg = @mysql_fetch_array(@mysql_query ("Select user from users where id='6' LIMIT 1;"));
echo $fsize1;
echo "ID-6:\n";
echo $fsize2;
echo "<input name=\"trahtenberg\" maxlength=\"13\" value=\"$trahtenberg[0]\" title=\"Trahtenberg\"/><br/>\n";
$robokop = @mysql_fetch_array(@mysql_query ("Select user from users where id='7' LIMIT 1;"));
echo $fsize1;
echo "ID-7:\n";
echo $fsize2;
echo "<input name=\"robokop\" maxlength=\"13\" value=\"$robokop[0]\" title=\"Robokop\"/><br/>\n";
$mat = @mysql_fetch_array(@mysql_query ("Select user from users where id='8' LIMIT 1;"));
echo $fsize1;
echo "ID-8:\n";
echo $fsize2;
echo "<input name=\"mat\" maxlength=\"13\" value=\"$mat[0]\" title=\"Mat\"/><br/>\n";
echo $fsize1;
echo $divide;
echo $fsize2;
if ($ver=="wml"){
echo $fsize1;
echo "<anchor title=\"go\">Обновить<go href=\"apanel.php?$ses&go=updbots$takep\" method=\"post\">\n";
echo "<postfield name=\"reg\" value=\"$(reg)\"/>\n";
echo "<postfield name=\"rus\" value=\"$(rus)\"/>\n";
echo "<postfield name=\"vict\" value=\"$(vict)\"/>\n";
echo "<postfield name=\"shut\" value=\"$(shut)\"/>\n";
echo "<postfield name=\"prod\" value=\"$(prod)\"/>\n";
echo "<postfield name=\"victint\" value=\"$(victint)\"/>\n";
echo "<postfield name=\"shutint\" value=\"$(shutint)\"/>\n";
echo "<postfield name=\"roomon\" value=\"$(roomon)\"/>\n";
echo "<postfield name=\"roomoff\" value=\"$(roomoff)\"/>\n";
echo "<postfield name=\"system\" value=\"$(system)\"/>\n";
echo "<postfield name=\"umnik\" value=\"$(umnik)\"/>\n";
echo "<postfield name=\"shutnik\" value=\"$(shutnik)\"/>\n";
echo "<postfield name=\"prodavec\" value=\"$(prodavec)\"/>\n";
echo "<postfield name=\"mafia\" value=\"$(mafia)\"/>\n";
echo "<postfield name=\"trahtenberg\" value=\"$(trahtenberg)\"/>\n";
echo "<postfield name=\"robokop\" value=\"$(robokop)\"/>\n";
echo "<postfield name=\"mat\" value=\"$(mat)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}else{
echo "<input type=\"submit\" value=\"Обновить\" name=\"enter\"><br/>\n";
}
break;
case 'updbots':
if (!ctype_digit($reg)) {header("Location: index.php"); die;}
if (!ctype_digit($rus)) {header("Location: index.php"); die;}
if (!ctype_digit($vict)) {header("Location: index.php"); die;}
if (!ctype_digit($shut)) {header("Location: index.php"); die;}
if (!ctype_digit($prod)) {header("Location: index.php"); die;}
if (!ctype_digit($victint)) {header("Location: index.php"); die;}
if (!ctype_digit($shutint)) {header("Location: index.php"); die;}
if (!ctype_digit($roomon)) {header("Location: index.php"); die;}
if (!ctype_digit($roomoff)) {header("Location: index.php"); die;}
$system = mysql_escape_string(check($system));
$umnik = mysql_escape_string(check($umnik));
$shutnik = mysql_escape_string(check($shutnik));
$prodavec = mysql_escape_string(check($prodavec));
$mafia = mysql_escape_string(check($mafia));
$trahtenberg = mysql_escape_string(check($trahtenberg));
$robokop = mysql_escape_string(check($robokop));
$mat = mysql_escape_string(check($mat));
$system = mysql_escape_string(check($system));
$umnik = mysql_escape_string(check($umnik));
$shutnik = mysql_escape_string(check($shutnik));
$prodavec = mysql_escape_string(check($prodavec));
$mafia = mysql_escape_string(check($mafia));
$trahtenberg = mysql_escape_string(check($trahtenberg));
$roboko = mysql_escape_string(check($mat));
if (!isset($error)) {
$result = mysql_query ("Select * setting where klu4 = '1'");
if (mysql_affected_rows() == 0) {
$error = "database error...";
} else {
if (mysql_query ("Update setting set reg='".$reg."', rus='".$rus."', vict='".$vict."', shut='".$shut."', prod='".$prod."', victint='".$victint."', shutint='".$shutint."', roomon='".$roomon."', roomoff='".$roomoff."' where klu4 ='1'")&&
mysql_query ("Update users set user='".$system."' where id = '1'")&&
mysql_query ("Update users set user='".$umnik."' where id = '2'")&&
mysql_query ("Update users set user='".$shutnik."' where id = '3'")&&
mysql_query ("Update users set user='".$prodavec."' where id = '4'")&&
mysql_query ("Update users set user='".$mafia."' where id = '5'")&&
mysql_query ("Update users set user='".$trahtenberg."' where id = '6'")&&
mysql_query ("Update users set user='".$robokop."' where id = '7'")&&
mysql_query ("Update users set user='".$mat."' where id = '8'")){
$msg = "Настройки ботов изменены";
} else {
$msg = "Ошибка изменения";
}
}
} else {
$error = " ".mysql_error()." ";
}
if (isset($error)) {
echo $fsize1;
echo "$error\n";
echo $fsize2;
}
echo $fsize1;
echo "<b>$msg</b><br/>\n";
echo $fsize2;
break;
case 'setting':
if ($ver=="xhtml") echo "<form method=\"POST\" action=\"apanel.php?$ses$takep&go=updsetting$takep\" name=\"auth\">\n";
echo $fsize1;
echo "<b>Основные настройки</b><br/>\n";
echo $divide;
echo $fsize1;
echo "Кол-во постов для создания клана:<br/>\n";
echo $fsize2;
echo "<input name=\"postclan1\" value=\"$set[postclan]\" title=\"postclan1\"/><br/>\n";
echo $fsize2;
if ($ver=="wml"){
echo $fsize1;
echo "<anchor title=\"go\">Обновить<go href=\"apanel.php?$ses$takep&go=updsetting$takep\" method=\"post\">\n";
echo "<postfield name=\"postclan1\" value=\"$(postclan1)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}else{
echo "<input type=\"submit\" class=\"ibutton\" value=\"Обновить\" name=\"enter\"><br/>\n";
}
break;
case 'updsetting':
if (!isset($error)) {
$result = mysql_query ("Select * setting where klu4 = '1'");
if (mysql_affected_rows() == 0) {
$error = "database error...";
} else {
if (mysql_query ("Update setting set postclan='".$postclan1."' where klu4 ='1'")){
$msg = "Настройки изменены!";
} else {
$msg = "Ошибка изменения";
}
}
} else {
$error = " ".mysql_error()." ";
}
if (isset($error)) {
echo $fsize1;
echo "$error\n";
echo $fsize2;
}
echo $fsize1;
echo "<b>$msg</b><br/>\n";
echo $fsize2;
break;
case 'link':
$setting = @mysql_query ("Select * from setting where klu4=1");
$set = mysql_fetch_array ($setting);
if ($ver=="xhtml") echo "<form method=\"POST\" action=\"apanel.php?$ses&go=updlink$takep\" name=\"auth\">\n";
echo $fsize1;
echo "<b>Ссылки на главную</b><br/>";
echo $divide;
echo "<b>Ссылка 1</b><br/>http://";
echo $fsize2;
echo "<input name=\"link1\" maxlength=\"120\" value=\"".$set["link1"]."\" title=\"link1\"/><br/>\n";
echo $fsize1;
echo "<b>Название ссылки 1</b><br/>";
echo $fsize2;
echo "<input name=\"link1_name\" maxlength=\"40\" value=\"".$set["link1_name"]."\" title=\"link1_name\"/><br/>\n";
echo $fsize1;
echo "<b>Ссылка 2</b><br/>http://";
echo $fsize2;
echo "<input name=\"link2\" maxlength=\"120\" value=\"".$set["link2"]."\" title=\"link2\"/><br/>\n";
echo $fsize1;
echo "<b>Название ссылки 2</b><br/>";
echo $fsize2;
echo "<input name=\"link2_name\" maxlength=\"40\" value=\"".$set["link2_name"]."\" title=\"link2_name\"/><br/>\n";
echo $fsize1;
echo "<b>Ссылка 3</b><br/>http://";
echo $fsize2;
echo "<input name=\"link3\" maxlength=\"120\" value=\"".$set["link3"]."\" title=\"link3\"/><br/>\n";
echo $fsize1;
echo "<b>Название ссылки 3</b><br/>";
echo $fsize2;
echo "<input name=\"link3_name\" maxlength=\"40\" value=\"".$set["link3_name"]."\" title=\"link3_name\"/><br/>\n";
if ($ver=="wml"){
echo $fsize1;
echo "<anchor title=\"go\">Изменить<go href=\"apanel.php?$ses&go=updlink$takep\" method=\"post\">\n";
echo "<postfield name=\"link1\" value=\"$(link)\"/>\n";
echo "<postfield name=\"link1_name\" value=\"$(link1_name)\"/>\n";
echo "<postfield name=\"link2\" value=\"$(link2)\"/>\n";
echo "<postfield name=\"link2_name\" value=\"$(link2_name)\"/>\n";
echo "<postfield name=\"link3\" value=\"$(link3)\"/>\n";
echo "<postfield name=\"link3_name\" value=\"$(link3_name)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}else{
echo "<input type=\"submit\" value=\"Изменить\" name=\"enter\"><br/>\n";
}
break;
case 'updlink':
if(!eregi("^((([a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z;]{2,3}))|(([0-9]{1,3}\.){3}([0-9]{1,3})))((/|\?)[a-z0-9~#%&'_\+=:;\?\.-]*)*)\$", $link1))$link1="";
if(!eregi("^((([a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z;]{2,3}))|(([0-9]{1,3}\.){3}([0-9]{1,3})))((/|\?)[a-z0-9~#%&'_\+=:;\?\.-]*)*)\$", $link2))$link2="";
if(!eregi("^((([a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z;]{2,3}))|(([0-9]{1,3}\.){3}([0-9]{1,3})))((/|\?)[a-z0-9~#%&'_\+=:;\?\.-]*)*)\$", $link3))$link3="";
$link1_name = check($link1_name);
$link2_name = check($link2_name);
$link3_name = check($link3_name);
$link1_name = mysql_escape_string($link1_name);
$link2_name = mysql_escape_string($link2_name);
$link3_name = mysql_escape_string($link3_name);
if (!isset($error)) {
$result = mysql_query ("Select * setting where klu4 = '1'");
if (mysql_affected_rows() == 0) {
$error = "database error...";
} else {
mysql_query ("Update setting set link1='".$link1."', link2='".$link2."', link3='".$link3."', link1_name='".$link1_name."', link2_name='".$link2_name."', link3_name='".$link3_name."' where klu4 = '1'");
$msg = "Настройки Линков сохранены";
}
} else {
$error = " ".mysql_error()." ";
}
if (isset($error)) {
echo $fsize1;
echo "$error\n";
echo $fsize2;
}
echo $fsize1;
echo "<b>$msg</b><br/>\n";
echo $fsize2;
break;
case 'editlevels':
$lev = mysql_query("select level,name from levels");
if(empty($act)) {
while($arr=mysql_fetch_array($lev)) {
echo $fsize1;
echo "<a href=\"apanel.php?act=rnm&$ses&go=editlevels&level=".$arr['level']."$takep\">".$arr['level'].". ".$arr['name']."</a><br/>";
echo $fsize2;
}
} elseif ($act=="dornm") {
if (!ctype_digit($level)) {header("Location: index.php"); die;}
$levelname = check($levelname);
$levelname = mysql_escape_string($levelname);
settype($level, 'integer');
mysql_query ("update levels set name='".$levelname."' where level='".$level."'");
echo $fsize1;
echo "Статус успешно переименован!<br/>\n";
echo "<a href=\"apanel.php?$ses&go=editlevels$takep\">Редактировать статусы</a><br/>";
echo $fsize2;
} else {
$lev = mysql_query("select name from levels where level=$level");
$arr=mysql_fetch_array($lev);
$name=$arr["name"];
if ($ver=="xhtml") echo "<form method=\"POST\" action=\"apanel.php?act=dornm&$ses&go=editlevels&level=$level$takep\" name=\"auth\">\n";
echo $fsize1;
echo "Название статуса:<br/>\n";
echo $fsize2;
echo "<input name=\"levelname\" maxlength=\"200\" value=\"$levels\" title=\"levelname\"/><br/>\n";
if ($ver=="wml"){
echo $fsize1;
echo "<anchor title=\"go\">Ok<go href=\"apanel.php?act=dornm&$ses&go=editlevels&level=$level$takep\" method=\"post\">\n";
echo "<postfield name=\"levelname\" value=\"$(levelname)\"/>\n";
echo "</go></anchor>\n";
echo $fsize2;
echo "<br/>\n";
}else{
echo "<input type=\"submit\" value=\"Ok\" name=\"enter\"><br/>\n";
}
echo $fsize1;
echo $divide;
echo "<a href=\"apanel.php?$ses&go=editlevels$takep\">Редактировать статусы</a><br/>";
echo $fsize2;
}
break;
//чтение записок
case 'zapiski':
$z=mysql_query("Select * from zapiski order by who desc;");
if(mysql_affected_rows()==0) {
echo $fsize1;
if ($ver=="xhtml");
echo "Записок в базе нет!!<br/>\n";
if ($ver=="xhtml");
echo $fsize2;
}else{
echo $fsize1;
$zap = mysql_query ("select count(who) as num from zapiski;");
$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;
if ($ver=="xhtml");
echo "Показывает $n-$do из $num<br/>\n";
if ($ver=="xhtml");
if ($ver=="wml"){echo $divide;}
$r = mysql_query ("select * from zapiski order by date desc limit $o,$do");
for ($i=$ot;$i<=$do;$i++){
$arr = mysql_fetch_array($r);
if ($ver=="xhtml");
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/>";
if ($ver=="xhtml");
}
$next=$s+1;
$prev=$s-1;
if ($num>$do) {
$ot=(($next-1)*10)+1;
$do=$next*10;
if($do>$num)$do=$num;
if ($ver=="xhtml");
echo "<a href=\"apanel.php?$ses&go=zapiski&s=$next&ref=$ref\">>>$ot-$do>></a><br/>\n";
if ($ver=="xhtml");
}
if($s>1) {
$ot=(($prev-1)*10)+1;
$do=$prev*10;
if ($ver=="xhtml");
echo "<a href=\"apanel.php?$ses&go=zapiski&s=$prev&ref=$ref\"><<$ot-$do<<</a><br/>\n";
if ($ver=="xhtml");
}
echo $fsize2;
}
break;
//чтение записок
//магазин
case'kurs':
echo "<form method=\"post\" action=\"apanel.php?$ses$takep&go=kurs_ok$takep\">";
$row =mysql_fetch_array(mysql_query("Select * from kurs where id='1' LIMIT 1;"));
$nik = $row["nik"];
echo "Ник(рублей):<br/><input name=\"nik\" class=\"form\" value=\"$row[nik]\" type=\"text\" /><br/>\n";
echo "Статус(рублей):<br/><input name=\"status\" class=\"form\" value=\"$row[status]\" type=\"text\" /><br/>\n";
echo "Топик(рублей):<br/><input name=\"topic\" class=\"form\" value=\"$row[topic]\" type=\"text\" /><br/>\n";
echo "Обьявление(рублей):<br/><input name=\"obiav\" class=\"form\" value=\"$row[obiav]\" type=\"text\" /><br/>\n";
echo "<input value=\"Изменить\" class=\"ibutton\" type=\"submit\" />\n";
echo "</form>\n";
break;
case'kurs_ok':
$nik=htmlspecialchars(stripslashes(trim($nik)));
$status=htmlspecialchars(stripslashes(trim($status)));
$topic=htmlspecialchars(stripslashes(trim($topic)));
$obiav=htmlspecialchars(stripslashes(trim($obiav)));
if(@mysql_query("Update kurs set nik='".$nik."', status='".$status."', topic='".$topic."', obiav='".$obiav."' where id ='1';"))
{
echo"<b>Изменёно!</b><br/>";
echo "<a href=\"apanel.php?$ses$takep&go=bank$takep\">Назад</a><br/>\n";
}
else
{
echo"<b>Ошибка</b><br/>";
echo "<a href=\"apanel.php?$ses$takep&go=bank$takep\">Назад</a><br/>\n";
}
break;
//магазин
case 'razvod':
if ($ver=="xhtml") echo "<form method=\"POST\" action=\"apanel.php?$ses&go=updrazvod$takep\" method=\"post\">\n";
echo $fsize1;
echo "ID мужа:<br/>";
echo $fsize2;
echo "<input name=\"zhenih\" maxlength=\"12\"/><br/>";
echo $fsize1;
echo "ID жены:<br/>";
echo $fsize2;
echo "<input name=\"nevesta\" maxlength=\"12\"/><br/>";
if ($ver=="wml"){
echo $fsize1;
echo "<anchor>Развести<go href=\"apanel.php?$ses&go=updrazvod$takep\" method=\"post\">";
echo "<postfield name=\"zhenih\" value=\"$(zhenih)\"/>";
echo "<postfield name=\"nevesta\" value=\"$(nevesta)\"/>";
echo "</go></anchor>";
echo $fsize2;
echo "<br/>";
}else{
echo "<input type=\"submit\" value=\"Развести\" name=\"enter\"><br/>\n";
}
break;
case 'updrazvod':
$zhenih=trim(mysql_escape_string(check($zhenih)));
$nevesta=trim(mysql_escape_string(check($nevesta)));
if(empty($zhenih)) $error=$error."<u>Не заполнено поле Жених!</u><br/>";
if(empty($nevesta)) $error=$error."<u>Не заполнено поле Невеста!</u><br/>";
$result = mysql_query ("Select id,user,pass,posts,status,level,credits,gposts,mafcredits,votefoto,byeotv,inv,user_ip,user_soft,para from users where id = '".$zhenih."' and sex='М'");
if (mysql_affected_rows() == 0) {
echo $fsize1;
echo "<u>Парня с ID <b>".$zhenih."</b> не сущетвует.</u><br/>";
echo $fsize2;
break;
}
$raz=mysql_fetch_array($result);
$zhena=$raz['para'];
if ($zhena!=$nevesta){
echo $fsize1;
echo "<b>ID ".$nevesta."</b> не является женой для ID <b>".$zhenih."</b>.<br/>";
echo $fsize2;
break;
}
$result = mysql_query ("Select id,user,pass,posts,status,level,credits,gposts,mafcredits,votefoto,byeotv,inv,user_ip,user_soft,para from users where id = '".$nevesta."' and sex='Ж'");
if (mysql_affected_rows() == 0) {
echo $fsize1;
echo "<u>Девушки с ID <b>".$nevesta."</b> не сущетвует.</u><br/>";
echo $fsize2;
break;
}
$raz=mysql_fetch_array($result);
$muj=$raz['para'];
if ($muj!=$zhenih){
echo $fsize1;
echo "<b>ID ".$zhenih."</b> не является мужем для ID <b>".$nevesta."</b>.<br/>";
echo $fsize2;
break;
}
if(empty($error)) {
if($zhenih!=$last_svadbi['zhenih']) {
if(mysql_query("Update users set para='' where id ='".$zhenih."'")&&mysql_query("Update users set para='' where id ='".$nevesta."'")) {
echo $fsize1;
echo "<b>Развод успешно завершён!</b><br/>";
echo $fsize2;
} else {
echo $fsize1;
echo "<b>Проблемы с разводом! Пара не будет разведена или данные юзеры не расписаны</b><br/>";
echo $fsize2;
}
} else {
echo $fsize1;
echo "<b>Люди уже давно разведены!</b><br/>";
echo $fsize2;
}
} else {
echo $fsize1;
echo $error;
echo $fsize2;
}
break;
case 'msvadbi':
if ($ver=="xhtml") echo "<form method=\"POST\" action=\"apanel.php?$ses&go=updsvadbi$takep\" name=\"auth\">\n";
echo $fsize1;
echo "ID Жениха:<br/>";
echo $fsize2;
echo "<input name=\"zhenih\" maxlength=\"12\"/><br/>";
echo $fsize1;
echo "ID Невесты:<br/>";
echo $fsize2;
echo "<input name=\"nevesta\" maxlength=\"12\"/><br/>";
echo $fsize1;
echo "Свидетель и друзья Жениха:<br/>";
echo $fsize2;
echo "<input name=\"frzhenih\"/><br/>";
echo $fsize1;
echo "Свидетельница и подруги Невесты:<br/>";
echo $fsize2;
echo "<input name=\"frnevesta\"/><br/>";
echo $fsize1;
echo "Организатор:<br/>";
echo $fsize2;
echo "<input name=\"organizatory\"/><br/>";
echo $fsize2;
echo "День Свадьбы:<br/>";
echo $fsize2;
echo "<input size=\"2\" name=\"day\" maxlength=\"2\" format=\"*N\"/>.<input size=\"2\" name=\"month\" maxlength=\"2\" format=\"*N\"/>.<input size=\"4\" name=\"year\" maxlength=\"4\" format=\"*N\"/><br/>";
echo $fsize1;
echo "Время Свадьбы:<br/>";
echo $fsize2;
echo "<input size=\"2\" name=\"chs\" maxlength=\"2\" format=\"*N\"/>:<input size=\"2\" name=\"min\" maxlength=\"2\" format=\"*N\"/><br/>";
if ($ver=="wml"){
echo $fsize1;
echo "<anchor>Добавить<go href=\"apanel.php?$ses&go=updsvadbi$takep\" method=\"post\">";
echo "<postfield name=\"zhenih\" value=\"$(zhenih)\"/>";
echo "<postfield name=\"nevesta\" value=\"$(nevesta)\"/>";
echo "<postfield name=\"frzhenih\" value=\"$(frzhenih)\"/>";
echo "<postfield name=\"frnevesta\" value=\"$(frnevesta)\"/>";
echo "<postfield name=\"day\" value=\"$(day)\"/>";
echo "<postfield name=\"month\" value=\"$(month)\"/>";
echo "<postfield name=\"year\" value=\"$(year)\"/>";
echo "<postfield name=\"chs\" value=\"$(chs)\"/>";
echo "<postfield name=\"min\" value=\"$(min)\"/>";
echo "<postfield name=\"organizatory\" value=\"$(organizatory)\"/>";
echo "</go></anchor>";
echo $fsize2;
echo "<br/>";
}else{
echo "<input type=\"submit\" value=\"Добавить\" name=\"enter\"><br/>\n";
}
break;
case 'updsvadbi':
$zhenih=trim(mysql_escape_string(check($zhenih)));
$nevesta=trim(mysql_escape_string(check($nevesta)));
$frzhenih=trim(mysql_escape_string(check($frzhenih)));
$frnevesta=trim(mysql_escape_string(check($frnevesta)));
$day=trim(mysql_escape_string(check($day)));
$month=trim(mysql_escape_string(check($month)));
$year=trim(mysql_escape_string(check($year)));
$chs=trim(mysql_escape_string(check($chs)));
$min=trim(mysql_escape_string(check($min)));
$organizatory=trim(mysql_escape_string(check($organizatory)));
if(empty($zhenih)) $error=$error."<u>Не заполнено поле Жених!</u><br/>";
if(empty($nevesta)) $error=$error."<u>Не заполнено поле Невеста!</u><br/>";
if(empty($frzhenih)) $error=$error."<u>Не заполнено поле свидетель Жениха!</u><br/>";
if(empty($frnevesta)) $error=$error."<u>Не заполнено поле свидетельница Жевесты!</u><br/>";
if(empty($day)) $error=$error."<u>Не заполнено поле число!</u><br/>";
if(empty($month)) $error=$error."<u>Не заполнено поле месяц!</u><br/>";
if(empty($year)) $error=$error."<u>Не заполнено поле год!</u><br/>";
if(empty($chs)) $error=$error."<u>Не заполнено поле часов!</u><br/>";
if(empty($min)) $error=$error."<u>Не заполнено поле минут!</u><br/>";
if(empty($organizatory)) $error=$error."<u>Не заполнено поле организаторов!</u><br/>";
if (eregi("[^0-9]", $zhenih))
{echo"ЗЫ. ТОЛЬКО ЦИФРЫ В ID ЖЕНИХА!!!";
echo'<br/><br/><a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
exit;}
if (eregi("[^0-9]", $nevesta))
{echo"ЗЫ. ТОЛЬКО ЦИФРЫ В ID НЕВЕСТЫ!!!";
echo'<br/><br/><a href="../enter.php?'.$ses.'&ref='.$ref.'">В прихожую</a><br/>';
exit;}
$userm = mysql_query ("select `id` FROM `users` where `sex` ='М' AND `id` ='".$zhenih."';");
$usm = mysql_fetch_array($userm);
$num = $usm[0];
if (empty($num)) {
echo $fsize1;
echo "<u>Парня с ID <b>".$zhenih."</b> не сущетвует.</u><br/>";
echo $fsize2;
break;
}
$usermx = mysql_query ("select `id` FROM `users` where `sex` ='Ж' AND `id` ='".$nevesta."';");
$usmx = mysql_fetch_array($usermx);
$numx = $usmx[0];
if (empty($numx)) {
echo $fsize1;
echo "<u>Девушки с ID <b>".$nevesta."</b> не сущетвует.</u><br/>";
echo $fsize2;
break;
}
$userm = mysql_query ("select `para` FROM `users` where `para`!='' AND `id`='".$zhenih."';");
$usm = mysql_fetch_array($userm);
$num = $usm[0];
if ($num!='') {
echo $fsize1;
echo "<u>Парень с ИД: <b>".$zhenih."</b> уже женат!!!</u><br/>";
echo $fsize2;
break;
}
$userm = mysql_query ("select `para` FROM `users` where `para`!='' AND `id`='".$nevesta."';");
$usm = mysql_fetch_array($userm);
$num = $usm[0];
if ($num!='') {
echo $fsize1;
echo "<u>Девушка с ИД: <b>".$nevesta."</b> уже замужем!!!</u><br/>";
echo $fsize2;
break;
}
$userm = mysql_query ("select `id` FROM `svadbi` where `nevesta ` ='".$nevesta."' AND `zhenih` ='".$zhenih."';");
$usm = mysql_fetch_array($userm);
$num = $usm[0];
if ($num!='') {
echo $fsize1;
echo "<u>Данная пара уже зарегистрирована в браке!!!</u><br/>";
echo $fsize2;
break;
}
if(empty($error)) {
if($zhenih!=$last_svadbi['zhenih']) {
$days="$day.$month.$year";
$times="$chs:$min";
if(mysql_query("insert into svadbi values(0,'".$zhenih."','".$nevesta."','".$frzhenih."','".$frnevesta."','".$days."','".$times."','".$organizatory."');")&&
mysql_query("Update users set para='".$nevesta."' where `id` ='".$zhenih."'")&&mysql_query("Update users set para='".$zhenih."' where `id` ='".$nevesta."'")) {
$fsize1;
echo "<b>Свадьба успешно добавлена!</b><br/>";
echo $fsize2;
} else {
echo $fsize1;
echo $fsize2;
}
} else {
echo $fsize1;
echo "<b>Такая свадьба уже добавлена!</b><br/>";
echo $fsize2;
}
} else {
echo $fsize1;
echo $error;
echo $fsize2;
}
break;
case 'dsvadbi':
$q = mysql_query("select id,zhenih,nevesta,date from svadbi order by id desc;");
if (mysql_affected_rows() == 0) {
echo $fsize1;
echo "Свадьбы не назначены!!!<br/>\n";
echo $fsize2;
} else {
if(empty($action)) {
while($arr=mysql_fetch_array($q)) {
echo $fsize1;
echo "<a href=\"apanel.php?action=del&$ses&go=dsvadbi&mid=".$arr['id']."$takep\">Свадьба ".$arr['zhenih']." & ".$arr['nevesta'].". (".$arr['date'].")</a><br/>";
echo $fsize2;
}
} else {
settype($mid, 'integer');
if(mysql_query("delete from svadbi where id='".$mid."' limit 1;")){
echo $fsize1;
echo "<b>Свадьба успешно удалена!</b><br/>";
echo $fsize2;
}
}
}
break;
case 'import_fraz':
mysql_query("truncate table `bot_dialog`");
$file=file("import/bot_dialog.txt");
for($i=0;$i<count($file);$i++) {
mysql_query("insert into `bot_dialog` values(0,'".$file[$i]."');");
$count = count($file);
}
echo $fsize1;
echo "В базу залито $count Фраз для Клазнета знатоков!";
echo $fsize2;
break;
case 'import_frazi':
mysql_query("truncate table `frazi`");
$file=file("import/frazi.txt");
for($i=0;$i<count($file);$i++) {
mysql_query("insert into `frazi` values(0,'".$file[$i]."');");
$count = count($file);
}
echo $fsize1;
echo "В базу залито $count Фраз для Клазнета знатоков!";
echo $fsize2;
break;
case 'import_shutki':
mysql_query("truncate table `shutki`");
$file=file("import/shutki.txt");
for($i=0;$i<count($file);$i++) {
mysql_query("insert into `shutki` values(0,'".trim($file[$i])."');");
$count = count($file);
}
echo $fsize1;
echo "В базу залито $count шуток!";
echo $fsize2;
break;
case 'import_vopros':
mysql_query("truncate table `bots`");
$file=file("import/vopros.txt");
for($i=0;$i<count($file);$i++) {
$ex=explode("::",$file[$i]);
$tran=strtr(trim($ex[1]),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='".trim($ex[0])."', answer='".trim($ex[1])."', tran='".$tran."'");
$count = count($file);
}
echo $fsize1;
echo "В базу залито $count вопрос!";
echo $fsize2;
break;
case 'import_anekdot':
mysql_query("truncate table `anekdot`");
$file=file("import/anekdot.txt");
for($i=0;$i<count($file);$i++) {
mysql_query("insert into `anekdot` values(0,'".trim($file[$i])."','6');");
$count = count($file);
}
echo $fsize1;
echo "В базу залито $count анекдотов!";
echo $fsize2;
break;
}
echo $fsize1;
echo $divide;
if($go) echo "<a href=\"apanel.php?$ses$takep\">Админка</a><br/>\n";
if (isset ($rm)) echo "<a href=\"chat.php?$ses&rm=$rm&ref=$ref\">В чат</a><br/>\n";
echo "<a href=\"enter.php?$ses&ref=$ref\">Прихожая</a><br/>\n";
echo $fsize2;
if ($ver=="wml")echo "</p></card></wml>";
else echo "</div></body></html>";
$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();
?>