View file moder.php

<?php

error_reporting(0);
require_once"./includes/functions/gzip.php";
include('start.php');
include("config.php");
include("./includes/".$ver."/banned");

list($msec, $sec) = explode(chr(32), microtime()); 
$headtime = $sec + $msec;

$nocache = rand(10000, 99999);

switch($ver)
{
////////////////////////////////////////////////////////
//WML VERSION
////////////////////////////////////////////////////////
case 'wml':
header("Content-type: text/vnd.wap.wml; charset=utf-8");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-cache, must-revalidate");

//AUTH
$id = intval($_SESSION['id']);
$password = mysql_escape_string($_SESSION['password']);
$q = mysql_query("SELECT `level` FROM `chat_users` WHERE `id` = '".$id."' AND `password` = '".md5($password)."';");
if(mysql_num_rows($q) == 0)
{
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.3//EN\" \"http://www.wapforum.org/DTD/wml13.dtd\"><wml>\n";
echo "<card title=\"ERROR\" ontimer=\"index.php?ver=wml\"><timer value=\"15\"/><p align=\"left\">\n";
echo "<small>Not logged in!<br/>\n";
list($msec, $sec) = explode(chr(32), microtime());
echo "<br/>[".round(($sec+$msec)-$headtime,5)."] sec<br/>\n";
echo "</small>";
require_once "includes/functions/gzip_foot.php";
echo "</p></card></wml>";
ob_end_flush();
exit();
}
//END AUTH

$level = mysql_result($q, 0);

if($level != 2)
{
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.3//EN\" \"http://www.wapforum.org/DTD/wml13.dtd\"><wml>\n";
echo "<card title=\"ERROR\" ontimer=\"menu.php?ver=wml&amp;".SID."\"><timer value=\"15\"/><p align=\"left\">\n";
echo "<small>Access Denied<br/>\n";
list($msec, $sec) = explode(chr(32), microtime());
echo "<br/>[".round(($sec+$msec)-$headtime,5)."] sec<br/>\n";
echo "</small>";
require_once "includes/functions/gzip_foot.php";
echo "</p></card></wml>";
ob_end_flush();
exit();
}

//ONLINE
$online = time() + 60;
$update = mysql_query("UPDATE `chat_users` SET `time` = '".$online."', `place` = 0, `ip` = '".getenv('REMOTE_ADDR')."', `ua` = '".htmlspecialchars(getenv('HTTP_USER_AGENT'))."' WHERE `id` = '".$id."';");
//END ONLINE

echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.3//EN\" \"http://www.wapforum.org/DTD/wml13.dtd\"><wml>\n";
echo "<card title=\"Moderator\"><p align=\"left\">\n";

if(isset($_GET['mod']))
{
$mod = $_GET['mod'];
}
else
{
$mod = "";
}

switch($mod)
{
case 'edit':
$nickname = trim(mysql_escape_string(htmlspecialchars($_POST['nickname'])));
$nickname = str_replace('$', '$$', $nickname);
if(!isset($_POST['action']))
{
$q = mysql_query("SELECT * FROM `chat_users` WHERE `nickname` = '".$nickname."';");

if(mysql_affected_rows() == 0)
{
echo "User Not Found.<br/>\n";
break;
}

$user = mysql_fetch_array($q);
$uid = $user['id'];
$pass = $user['password'];
$posts = $user['posts'];
$lev = $user['level'];
$status = $user['status'];

if($lev > 1 && $uid != $id)
{
echo "Moderators do not have the right to edit profiles of Moderator and other administrators.нистраторов.<br/>\n";
echo "<a href=\"rules/moder_rules.php?".SID."\">Rules Moderator</a><br/>\n";
break;
}

echo "Status:<br/>\n";
echo "<input name=\"status$nocache\" value=\"$status\" maxlength=\"20\"/><br/>\n";
echo "<anchor>[Save]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=edit\" method=\"post\">\n";
echo "<postfield name=\"uid\" value=\"$uid\"/>\n";
echo "<postfield name=\"status\" value=\"$(status$nocache)\"/>\n";
echo "<postfield name=\"action\" value=\"save\"/>\n";
echo "</go></anchor><br/>\n";
}
else
{
$uid = intval($_POST['uid']);
$status = htmlspecialchars(mysql_escape_string(trim($_POST['status'])));
$status = str_replace('$', '$$', $status);
$q = mysql_query("SELECT `level` FROM `chat_users` WHERE `id` = '".$uid."' AND `id` != '".$id."';");
$lev = mysql_result($q, 0);

	if($lev > 1 && $uid != $id)
	{
	echo "Moderators do not have the right to edit profiles of Moderator and other administrators.нистраторов.<br/>\n";
	echo "<a href=\"rules/moder_rules.php?".SID."\">Rules С-Moderator</a><br/>\n";
	break;
	}

$query = mysql_query("UPDATE `chat_users` SET  `status` = '".$status."' WHERE `id` = '".$uid."';");
	if($query)
	{
	echo "Data successfully saved!<br/>\n";
	}
	else
	{
	echo "error!<br/>\n";
	echo mysql_error()."<br/>\n";
	}
}
break;

case 'kick':
$nickname = trim(mysql_escape_string(htmlspecialchars($_POST['nickname'])));
$nickname = str_replace('$', '$$', $nickname);
$reason = trim(mysql_escape_string(htmlspecialchars($_POST['reason'])));
$reason = str_replace('$', '$$', $reason);
$kick = intval($_POST['time']);

if($kick != 60 && $kick != 90 && $kick != 300 && $kick != 43200 && $kick != 86400 && $kick != 172800)
{
echo "Invalid time for kick <br/>\n";
echo "<a href=\"rules/moder_rules.php?".SID."&amp;ver=wml\">Rules Moderator</a><br/>\n";
break;
}

$q = mysql_query("SELECT `level`, `id` FROM `chat_users` WHERE `nickname` = '".$nickname."';");
if(mysql_num_rows($q) == 0)
{
echo "User Not Found.<br/>\n";
break;
}

$uid = mysql_result($q, 0, 'id');
$lev = mysql_result($q, 0, 'level');

if($lev > 1 && $uid != $id)
{
echo "Moderators do not have the right to change the status of other Moderatorsь Statusы других Moderator.<br/>\n";
echo "<a href=\"rules/moder_rules.php?".SID."\">Rules Moderator</a><br/>\n";
break;
}

if($kick == 0)
{
echo "cnt kick for 0 secsнд!<br/>\n";
break;
}

if(empty($reason))
{
echo "Empty Reason!<br/>\n";
break;
}

$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$moder = mysql_result($q, 0);
$q = mysql_query("UPDATE `chat_users` SET `kick` = '".($kick + time())."', `reason` = '".$reason."', `moder` = '".$moder."' WHERE `nickname` = '".$nickname."';");
echo "$nickname successfully kicked(а) for $kick seconds!<br/>\n";

$date = date("d-m-y H:i:s");
$query = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$moder = mysql_result($query, 0);
$q = mysql_query("INSERT INTO `chat_logs` VALUES(0, '".$moder."', 1, '".$nickname."', '".$reason."', '".$date."', ".time().");"); 
break;

case 'search':
if(!isset($_POST['action']))
{
echo "ID:<br/>\n";
echo "<input name=\"uid$nocache\" format=\"*N\" size=\"4\" maxlength=\"6\"/><br/>\n";
echo "<anchor>[Search]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=search\" method=\"post\">\n";
echo "<postfield name=\"uid\" value=\"$(uid$nocache)\"/>\n";
echo "<postfield name=\"action\" value=\"search\"/>\n";
echo "</go></anchor><br/>\n";
}
else
{
$uid = intval($_POST['uid']);
$q = mysql_query("SELECT * FROM `chat_users` WHERE `id` = '".$uid."';");

if(mysql_num_rows($q) == 0)
{
echo "User Not Found.<br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=search\">Search</a><br/><br/>\n";
}
else
{
$user = mysql_fetch_array($q);
$nick = $user['nickname'];
$pass = $user['password'];
$ip = $user['ip'];
$ua = $user['ua'];
$kick = $user['kick'];
$moder = $user['moder'];
$reason = $user['reason'];
$name = $user['name'];
$site = $user['site'];
$sex = $user['sex'];
$city = $user['city'];
$mobile = $user['mobile'];
$email = $user['email'];
$birthday = $user['birthday'];
$about = $user['about'];
$posts = $user['posts'];
$level = $user['level'];
$answers = $user['answers'];
$gbalans = $user['gbalans'];
$status = $user['status'];
$regdate = $user['regdate'];
$place = $user['place'];
$time = $user['time'];

echo "Nickname: ".$nick."<br/>\n";
echo "Name: $name<br/>\n";
if($sex == 0)
{
echo "Sex: Male<br/>\n";
}
else
{
echo "Sex: Female<br/>\n";
}
echo "Date of Birth: $birthday<br/>\n";
echo "Status: $status<br/>\n";
echo "Количество постов: $posts<br/>\n";
echo "Ответов в викторине: $answers<br/>\n";
echo "Игровой баланс: $gbalans<br/>\n";
echo "City: $city<br/>\n";
echo "Модель мобильного телефоfor: $mobile<br/>\n";
echo "Сайт: <a href=\"http://$site\">$site</a><br/>\n";
echo "Email: $email<br/>\n";
echo "About: $about<br/>\n";
echo "Date регистрации: $regdate<br/>\n";
$ltime = time() - ($time - 60);
if($ltime < 60 && $ltime >= 0)
{
$var = "sec.";
}
elseif($ltime < 3600 && $ltime > 60)
{
$new = $ltime;
$ltime = $new/60;
$var = "min.";
}
elseif($ltime < 86400 && $ltime > 3600)
{
$new = $ltime;
$ltime = $new/3600;
$var = "hours";
}
elseif($ltime > 86400)
{
$new = $ltime;
$ltime = $new/86400;
$var = "days";
}
$ltime = round($ltime, 2);
if($ltime != 0)
{
echo "Idle For: $ltime $var<br/>\n";
}
else
{
echo "Online.<br/>\n";
}
echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=search\">Search</a><br/><br/>\n";
}
}
break;

case 'allusers':
$query = @mysql_query("SELECT COUNT(*) FROM `chat_users`;");
$all = @mysql_result($query, 0);

if(isset($_GET['s'])) $s = intval($_GET['s']);
else $s = 0;
if($s < 0) $s = 0;
if($s > $all) $s = 0;
$c = $s + 1;

if ($s > 20)  print "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=allusers&amp;s=0\">&lt;&lt;&lt;&lt;</a><br/>";
if ($s > 0)  print "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=allusers&amp;s=".($s-10)."\">&lt;&lt;&lt;</a><br/>";

$query = @mysql_query("SELECT `id`, `nickname`, `posts` FROM `chat_users` ORDER BY `posts` DESC LIMIT $s, 10;");

while($user = mysql_fetch_array($query))
{
$uid = $user['id'];
$nick = $user['nickname'];
$posts = $user['posts'];
echo "$c. $nick, ID=$uid - $posts<br/>\n";
$c++;
}

if ($all > $s + 10)  print "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=allusers&amp;s=".($s+10)."\">&gt;&gt;&gt;</a><br/>";
if (($all > $s + 10) && ($all - $s > 20))  print "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=allusers&amp;s=".($all-10)."\">&gt;&gt;&gt;&gt;</a><br/>";
break;

case 'kicklist':
$query = @mysql_query("SELECT COUNT(*) FROM `chat_users` WHERE `kick` > ".time().";");
$all = @mysql_result($query, 0);

if(isset($_GET['s'])) $s = intval($_GET['s']);
else $s = 0;
if($s < 0) $s = 0;
if($s > $all) $s = 0;
$c = $s + 1;

if ($s > 20)  print "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=kicklist&amp;s=0\">&lt;&lt;&lt;&lt;</a><br/>";
if ($s > 0)  print "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=kicklist&amp;s=".($s-10)."\">&lt;&lt;&lt;</a><br/>";

$query = @mysql_query("SELECT `id`, `nickname`, `kick`, `moder`, `reason` FROM `chat_users` WHERE `kick` > ".time().";");

if(mysql_num_rows($query) == 0)
{
echo "Ban list is empty.<br/>\n";
}

while($kick = mysql_fetch_array($query))
{
$nickname = $kick['nickname'];
$uid = $kick['id'];
$time = $kick['kick'] - time();
$moder = $kick['moder'];
$reason = $kick['reason'];
echo "$c. $nickname, ID=$uid.<br/>\n";
echo "РазBan через <u>$time</u> seconds., kicked модератором <u>$moder</u>, Reason:<br/>\n";
echo "<u>$reason</u><br/>\n";
$c++;
}

if ($all > $s + 10)  print "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=kicklist&amp;s=".($s+10)."\">&gt;&gt;&gt;</a><br/>";
if (($all > $s + 10) && ($all - $s > 20))  print "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=kicklist&amp;s=".($all-10)."\">&gt;&gt;&gt;&gt;</a><br/>";
break;

case 'editroom':
if(!isset($_POST['action']))
{
$q = mysql_query("SELECT `id`, `name` FROM `chat_rooms`;");
	if(mysql_num_rows($q) == 0)
	{
	echo "No rooms.<br/>\n";
	}
	else
	{
	echo "<select multiple=\"false\" name=\"room$nocache\">\n";
		while($room = mysql_fetch_array($q))
		{
		$name = $room['name'];
		$rid = $room['id'];
		echo "<option value=\"$rid\">$name</option>\n";
		}
	echo "</select><br/>\n";
	echo "<anchor>[Edit]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=editroom\" method=\"post\">\n";
	echo "<postfield name=\"room\" value=\"$(room$nocache)\"/>\n";
	echo "<postfield name=\"action\" value=\"remove\"/>\n";
	echo "</go></anchor><br/>\n";
	}
}
else
{
$room = intval($_POST['room']);
$q = mysql_query("SELECT `topic` FROM `chat_rooms` WHERE `id` = '".$room."';");

if(mysql_num_rows($q) == 0)
{
echo "Room  does not exist.<br/>\n";
break;
}

$topic = mysql_result($q, 0);

echo "Title:<br/>\n";
echo "<input name=\"topic$nocache\" maxlength=\"20\" value=\"$topic\" title=\"topic\"/><br/>\n";
//echo "Транслитировать:<br/>\n";
echo "<anchor>[Save]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=uproom\" method=\"post\">\n";
echo "<postfield name=\"room\" value=\"$room\"/>\n";
echo "<postfield name=\"topic\" value=\"$(topic$nocache)\"/>\n";
"/>\n";
echo "</go></anchor><br/>\n";
}
break;

case 'uproom':
$room = intval($_POST['room']);
$q = mysql_query("SELECT `id` FROM `chat_rooms` WHERE `id` = '".$room."';");
if(mysql_num_rows($q) == 0)
{
echo "Room  does not exist.<br/>\n";
break;
}
$topic = trim(mysql_escape_string(htmlspecialchars($_POST['topic'])));
$topic = str_replace('$', '$$', $topic);


$q = mysql_query("UPDATE `chat_rooms` SET `topic` = '".$topic."' WHERE `id` = '".$room."';");
echo "Header Changed!<br/>\n";
break;

case 'clear':
$q = mysql_query("TRUNCATE TABLE `chat`;");
echo "successfully cleaned!<br/>\n";
break;

case 'addnews':
if(!isset($_POST['action']))
{
echo "Title:<br/>\n";
echo "<input name=\"title$nocache\" maxlength=\"20\" value=\"\" title=\"title\"/><br/>\n";
echo "Text:<br/>\n";
echo "<input name=\"text$nocache\" maxlength=\"300\" value=\"\" title=\"text\"/><br/>\n";
//echo "Транслитировать:<br/>\n";
//echo "<select multiple=\"true\" name=\"translit$nocache\">\n";
echo "<option value=\"title\">Title</option>\n";
echo "<option value=\"text\">Text</option></select><br/>\n";
echo "<anchor>[Add]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=addnews\" method=\"post\">\n";
echo "<postfield name=\"title\" value=\"$(title$nocache)\"/>\n";
echo "<postfield name=\"text\" value=\"$(text$nocache)\"/>\n";
"/>\n";
echo "<postfield name=\"action\" value=\"add\"/>\n";
echo "</go></anchor><br/>\n";
}
else
{
$title = htmlspecialchars(mysql_escape_string(trim($_POST['title'])));
$title = str_replace('$', '$$', $title);
$text = htmlspecialchars(mysql_escape_string(trim($_POST['text'])));
$text = str_replace('$', '$$', $text);


if(empty($title))
{
echo "title empty!<br/>\n";
break;
}

if(empty($text))
{
echo "text empty!<br/>\n";
break;
}

$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `name` = '".$title."' AND `text` = '".$text."';");
$nickname = mysql_result($q, 0);

if(mysql_affected_rows($q) != 0)
{
echo "News had already been exist.<br/>\n";
break;
}

$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$nickname = mysql_result($q, 0);
$date = date("d-m-Y");

$sql = mysql_query("INSERT INTO `chat_news` VALUES(0, '".$title."', '".$nickname."', '".$text."', '".$date."', ".time().");");

if($sql)
{
echo "News successfully added!<br/>\n";
}
else
{
echo "News not added, Error!<br/>\n";
echo mysql_error()."<br/>\n";
}
}
break;

case 'delnews':
if(!isset($_POST['action']))
{
$q = mysql_query("SELECT `id`, `name` FROM `chat_news`;");
	if(mysql_num_rows($q) == 0)
	{
	echo "No News.<br/>\n";
	}
	else
	{
	echo "<select multiple=\"false\" name=\"nid$nocache\">\n";
		while($news = mysql_fetch_array($q))
		{
		$name = $news['name'];
		$nid = $news['id'];
		echo "<option value=\"$nid\">$name</option>\n";
		}
	echo "</select><br/>\n";
	echo "<anchor>[Remove]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=delnews\" method=\"post\">\n";
	echo "<postfield name=\"nid\" value=\"$(nid$nocache)\"/>\n";
	echo "<postfield name=\"action\" value=\"remove\"/>\n";
	echo "</go></anchor><br/>\n";
	}
}
else
{
$nid = intval($_POST['nid']);
$q = mysql_query("DELETE FROM `chat_news` WHERE `id` = '".$nid."';");
	if(mysql_affected_rows() != 0)
	{
	echo "News successfully removed!<br/>\n";
	}
	else
	{
	echo "not removed.<br/>\n";
	}
}
break;

case 'addmeet':
if(!isset($_POST['action']))
{
echo "Title:<br/>\n";
echo "<input name=\"title$nocache\" maxlength=\"20\" value=\"\" title=\"title\"/><br/>\n";
echo "Text Meetings:<br/>\n";
echo "<input name=\"text$nocache\" maxlength=\"300\" value=\"\" title=\"text\"/><br/>\n";
//echo "Транслитировать:<br/>\n";
//echo "<select multiple=\"true\" name=\"translit$nocache\">\n";
echo "<option value=\"title\">Title</option>\n";
echo "<option value=\"text\">Text Meetings</option></select><br/>\n";
echo "<anchor>[Add]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=addmeet\" method=\"post\">\n";
echo "<postfield name=\"title\" value=\"$(title$nocache)\"/>\n";
echo "<postfield name=\"text\" value=\"$(text$nocache)\"/>\n";
"/>\n";
echo "<postfield name=\"action\" value=\"add\"/>\n";
echo "</go></anchor><br/>\n";
}
else
{

$title = htmlspecialchars(mysql_escape_string(trim($_POST['title'])));
$title = str_replace('$', '$$', $title);
$text = htmlspecialchars(mysql_escape_string(trim($_POST['text'])));
$text = str_replace('$', '$$', $text);


if(empty($title))
{
echo "You do not have Title Meetings!<br/>\n";
break;
}

if(empty($text))
{
echo "You do not have Text Meetings!<br/>\n";
break;
}

$sql = mysql_query("SELECT `id` FROM `chat_meets` WHERE `title` = '".$title."' AND `body` = '".$text."';");

if(mysql_num_rows($sql) != 0)
{
echo "meeting has already exist.<br/>\n";
break;
}

$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$nickname = mysql_result($q, 0);
$date = date("d-m-Y");

$sql = mysql_query("INSERT INTO `chat_meets` VALUES(0, '".$nickname."', '".$title."', '".$text."', '".$date."', ".time().");");

if($sql)
{
echo "Meeting successfully added!<br/>\n";
}
else
{
echo "Mysql Error!<br/>\n";
echo mysql_error()."<br/>\n";
}
}
break;

case 'delmeet':
if(!isset($_POST['action']))
{
$q = mysql_query("SELECT `id`, `title` FROM `chat_meets`;");
	if(mysql_num_rows($q) == 0)
	{
	echo "Empty <br/>\n";
	}
	else
	{
	echo "<select multiple=\"false\" name=\"mid$nocache\">\n";
		while($meets = mysql_fetch_array($q))
		{
		$name = $meets['title'];
		$mid = $meets['id'];
		echo "<option value=\"$mid\">$name</option>\n";
		}
	echo "</select><br/>\n";
	echo "<anchor>[Remove]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=delmeet\" method=\"post\">\n";
	echo "<postfield name=\"mid\" value=\"$(mid$nocache)\"/>\n";
	echo "<postfield name=\"action\" value=\"remove\"/>\n";
	echo "</go></anchor><br/>\n";
	}
}
else
{
$mid = intval($_POST['mid']);
$q = mysql_query("DELETE FROM `chat_meets` WHERE `id` = '".$mid."';");
	if(mysql_affected_rows() != 0)
	{
	echo "successfully removed!<br/>\n";
	}
	else
	{
	echo "error in remove.<br/>\n";
	}
}
break;

default:
echo "[User]<br/>\n";
echo "Nickname:<br/>\n";
echo "<input name=\"nickname$nocache\" maxlength=\"20\" title=\"nickname\"/><br/>\n";
echo "<anchor>[Change Status]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=edit\" method=\"post\">\n";
echo "<postfield name=\"nickname\" value=\"$(nickname$nocache)\"/>\n";
"/>\n";
echo "</go></anchor><br/>\n";
echo "Time:<br/>\n";
echo "<select name=\"time$nocache\" value=\"60\">\n";
echo "<option value=\"60\">60</option>\n";
echo "<option value=\"90\">90</option>\n";
echo "<option value=\"300\">300</option>\n";
echo "<option value=\"43200\">43200</option>\n";
echo "<option value=\"86400\">86400</option>\n";
echo "<option value=\"172800\">172800</option>\n";
echo "</select><br/>\n";
echo "Reason:<br/>\n";
echo "<input name=\"reason$nocache\" maxlength=\"200\" title=\"reason\"/><br/>\n";
echo "<anchor>[Kick]<go href=\"moder.php?nocache=$nocache&amp;ver=wml&amp;".SID."&amp;mod=kick\" method=\"post\">\n";
echo "<postfield name=\"nickname\" value=\"$(nickname$nocache)\"/>\n";
"/>\n";
echo "<postfield name=\"reason\" value=\"$(reason$nocache)\"/>\n";
echo "<postfield name=\"time\" value=\"$(time$nocache)\"/>\n";
echo "</go></anchor><br/>\n";
//echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=search&amp;nocache=$nocache\">Search по ID</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=allusers\">Users List</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=kicklist\">Kick List</a><br/>\n";
echo "---<br/>\n";
echo "[Rooms]<br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=editroom&amp;nocache=$nocache\">Edit Room</a><br/>\n";
//echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=clear\">Clear Rooms</a><br/>\n";
echo "---<br/>\n";
echo "[Other]<br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=addnews&amp;nocache=$nocache\">Add News</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=delnews&amp;nocache=$nocache\">Remove News</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=addmeet&amp;nocache=$nocache\">Add meetings</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=wml&amp;mod=delmeet&amp;nocache=$nocache\">Remove meetings</a><br/>\n";
break;
}

if(!empty($mod)) echo "<a href=\"moder.php?".SID."&amp;ver=wml\">Moderator</a><br/>\n";
echo "<br/><a href=\"menu.php?".SID."&amp;ver=wml\">Hall</a><br/>\n";
list($msec, $sec) = explode(chr(32), microtime());
echo "<br/><small>[".round(($sec+$msec)-$headtime,5)."] sec</small><br/>\n";
require_once "includes/functions/gzip_foot.php";
echo "</p></card></wml>";
ob_end_flush();
break;

////////////////////////////////////////////////////////
//HTML VERSION
////////////////////////////////////////////////////////
case 'html':
$my_title = "Модер";
if(!isset($_COOKIE['theme'])) $_COOKIE['theme'] = 1;
include_once "themes/".intval($_COOKIE['theme'])."/index.php";

//AUTH
$id = intval($_SESSION['id']);
$password = mysql_escape_string($_SESSION['password']);
$q = mysql_query("SELECT `level` FROM `chat_users` WHERE `id` = '".$id."' AND `password` = '".md5($password)."';");
if(mysql_num_rows($q) == 0)
{
echo "Not logged in!<br/>\n";
include_once "themes/".intval($_COOKIE['theme'])."/foot.php";
exit();
}
//END AUTH

//ONLINE
$online = time() + 60;
$update = mysql_query("UPDATE `chat_users` SET `time` = '".$online."', `place` = 0 WHERE `id` = '".$id."';");
//END ONLINE


$level = mysql_result($q, 0);

if($level != 2)
{
echo "Access Denied<br/>\n";
include_once "themes/".intval($_COOKIE['theme'])."/foot.php";
exit();
}

if(isset($_GET['mod']))
{
$mod = $_GET['mod'];
}
else
{
$mod = "";
}

if(isset($_GET['handler']))
{
$action = intval($_POST['mod']);

	switch($action)
	{
	case 0:
	$mod = "edit";
	break;

	case 1:
	$mod = "kick";
	break;

	case 2:
	$mod = "ban";
	break;

	case 3:
	$mod = "ipua";
	break;
	}
}

switch($mod)
{
case 'edit':
$nickname = trim(mysql_escape_string(htmlspecialchars($_POST['nickname'])));

if(!isset($_POST['action']))
{
$q = mysql_query("SELECT * FROM `chat_users` WHERE `nickname` = '".$nickname."';");

if(mysql_affected_rows() == 0)
{
echo "User Not Found.<br/>\n";
break;
}

$user = mysql_fetch_array($q);
$uid = $user['id'];
//$posts = $user['posts'];
$status = $user['status'];
$lev = $user['level'];
if($lev > 1)
{
echo "Moderators do not have the right to change the status of other Moderatorsь Statusы других Moderator.<br/>\n";
echo "<a href=\"rules/moder_rules.php?".SID."&amp;ver=html\">Rules Moderator</a><br/>\n";
break;
}

echo "<div class=\"form\">\n";
echo "<form method=\"post\" action=\"moder.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;mod=edit\">\n";
echo "Status:<br/>\n";
echo "<input name=\"status\" value=\"$status\" maxlength=\"20\"/><br/>\n";
echo "<input type=\"hidden\" name=\"uid\" value=\"$uid\"/>";
echo "<input type=\"hidden\" name=\"action\" value=\"save\"/>";
echo "<input type=\"submit\" value=\"Save\"/></form></div><br/>\n";
}
else
{
$uid = intval($_POST['uid']);
$status = htmlspecialchars(mysql_escape_string(trim($_POST['status'])));
$status = str_replace('$', '$$', $status);
$q = mysql_query("SELECT `level` FROM `chat_users` WHERE `nickname` = '".$nickname."' AND `id` != '".$uid."';");
	if(mysql_num_rows($q) != 0)
	{
	echo "A user with such Nickname already exist.<br/>\n";
	break;
	}
	else
	{
	$lev = mysql_result($q, 0);
	}
	if($lev > 1)
	{
	echo "Moderators do not have the right to change the status of other Moderatorsь Statusы других Moderator.<br/>\n";
	echo "<a href=\"rules/moder_rules.php?".SID."\">Rules Moderator</a><br/>\n";
	break;
	}
$query = mysql_query("UPDATE `chat_users` SET `status` = '".$status."' WHERE `id` = '".$uid."';");
	if($query)
	{
	echo "Data successfully saved!<br/>\n";
	}
	else
	{
	echo "error!<br/>\n";
	echo mysql_error()."<br/>\n";
	}
}
break;

case 'kick':
$nickname = trim(mysql_escape_string(htmlspecialchars($_POST['nickname'])));
$nickname = str_replace('$', '$$', $nickname);
$reason = trim(mysql_escape_string(htmlspecialchars($_POST['reason'])));
$reason = str_replace('$', '$$', $reason);
$kick = intval($_POST['time']);

if($kick != 60 && $kick != 90 && $kick != 300 && $kick != 43200 && $kick != 86400 && $kick != 172800)
{
echo "Invalid time for kick <br/>\n";
echo "<a href=\"rules/moder_rules.php?".SID."&amp;ver=wml\">Rules Moderator</a><br/>\n";
break;
}

$q = mysql_query("SELECT * FROM `chat_users` WHERE `nickname` = '".$nickname."';");

if(mysql_affected_rows() == 0)
{
echo "User Not Found.<br/>\n";
break;
}
else
{
$lev = mysql_result($q, 0, 'level');
}

if($lev > 1)
{
echo "Moderators do not have the right to change the status of other Moderatorsь пиforть других Moderator.<br/>\n";
echo "<a href=\"rules/moder_rules.php?".SID."&amp;ver=html\">Rules Moderator</a><br/>\n";
break;
}

if($kick == 0)
{
echo "cnt kick for 0 secs!<br/>\n";
break;
}

if(empty($reason))
{
echo "Empty Reason!<br/>\n";
break;
}

$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$moder = mysql_result($q, 0);
$q = mysql_query("UPDATE `chat_users` SET `kick` = '".($kick + time())."', `reason` = '".$reason."', `moder` = '".$moder."' WHERE `nickname` = '".$nickname."';");
echo "$nickname successfully kicked(а) for $kick seconds!<br/>\n";

$date = date("d-m-y H:i:s");
$query = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$moder = mysql_result($query, 0);
$q = mysql_query("INSERT INTO `chat_logs` VALUES(0, '".$moder."', 1, '".$nickname."', '".$reason."', '".$date."', ".time().");"); 
break;

case 'ban':
$nickname = trim(mysql_escape_string(htmlspecialchars($_POST['nickname'])));
$nickname = str_replace('$', '$$', $nickname);

$q = mysql_query("SELECT * FROM `chat_users` WHERE `nickname` = '".$nickname."';");
if(mysql_affected_rows() == 0)
{
echo "User Not Found.<br/>\n";
break;
}
$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$moder = mysql_result($q, 0);
$q = mysql_query("UPDATE `chat_users` SET `ban` = 1 WHERE `nickname` = '".$nickname."';");
echo "$nickname banned!<br/>\n";

$date = date("d-m-y H:i:s");
$query = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$moder = mysql_result($query, 0);
mysql_query("INSERT INTO `chat_logs` VALUES(0, '".$moder."', 2, '".$nickname."', '', '".$date."', ".time().");"); 
break;

case 'search':
if(!isset($_POST['action']))
{
echo "<div class=\"form\">\n";
echo "<form method=\"post\" action=\"moder.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;mod=search\">\n";
echo "ID:<br/>\n";
echo "<input name=\"uid\" size=\"4\" maxlength=\"6\"/><br/>\n";
echo "<input type=\"hidden\" name=\"action\" value=\"search\"/>";
echo "<input type=\"submit\" value=\"Search\"/></form></div><br/>\n";
}
else
{
$uid = intval($_POST['uid']);
$q = mysql_query("SELECT * FROM `chat_users` WHERE `id` = '".$uid."';");

if(mysql_num_rows($q) == 0)
{
echo "User Not Found.<br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=search\">Search</a><br/><br/>\n";
}
else
{
$user = mysql_fetch_array($q);
$nick = $user['nickname'];
$pass = $user['password'];
$ip = $user['ip'];
$ua = $user['ua'];
$kick = $user['kick'];
$moder = $user['moder'];
$reason = $user['reason'];
$name = $user['name'];
$site = $user['site'];
$sex = $user['sex'];
$city = $user['city'];
$mobile = $user['mobile'];
$email = $user['email'];
$birthday = $user['birthday'];
$about = $user['about'];
$posts = $user['posts'];
$level = $user['level'];
$answers = $user['answers'];
$gbalans = $user['gbalans'];
$status = $user['status'];
$regdate = $user['regdate'];
$place = $user['place'];
$time = $user['time'];

echo "Nickname: ".$nick."<br/>\n";
if($level == 4) echo "Password: ".$pass."<br/>\n";
	if($level > 2)
	{
	echo "IP: <u>".$ip."</u><br/>\n";
	echo "UserAgent: <u>".$ua."</u><br/>\n";
	}
	if($level == 4)
	{
		if(time() < $kick)
		{
		$tkick = $kick - time();
		if($tkick < 60 && $tkick > 0)
		{
		$var = "sec.";
		}
		elseif($tkick < 3600 && $tkick > 60)
		{
		$new = $tkick;
		$tkick = $new/60;
		$var = "min.";
		}
		elseif($tkick < 86400 && $tkick > 3600)
		{
		$new = $tkick;
		$tkick = $new/3600;
		$var = "hours";
		}
		elseif($tkick > 86400)
		{
		$new = $tkick;
		$tkick = $new/86400;
		$var = "days";
		}
		$tkick = round($tkick, 2);
		echo "kicked модератором <u>".$moder."</u>.<br/>\n";
		echo "РазBan через <u>".$tkick." $var</u><br/>\n";
		echo "Reason: <u>".$reason."</u><br/>\n";
		}
	}
echo "Name: $name<br/>\n";
if($sex == 0)
{
echo "Sex: Male<br/>\n";
}
else
{
echo "Sex: Female<br/>\n";
}
echo "Date of Birth: $birthday<br/>\n";
echo "Status: $status<br/>\n";
echo "Posts: $posts<br/>\n";
echo "Quiz Points: $answers<br/>\n";
echo "Points: $gbalans<br/>\n";
echo "Location: $city<br/>\n";
echo "Mobile: $mobile<br/>\n";
//echo "Сайт: <a href=\"http://$site\">$site</a><br/>\n";
echo "Email: $email<br/>\n";
echo "About me: $about<br/>\n";
echo "Member since: $regdate<br/>\n";
$ltime = time() - ($time - 60);
if($ltime < 60 && $ltime >= 0)
{
$var = "sec.";
}
elseif($ltime < 3600 && $ltime > 60)
{
$new = $ltime;
$ltime = $new/60;
$var = "min.";
}
elseif($ltime < 86400 && $ltime > 3600)
{
$new = $ltime;
$ltime = $new/3600;
$var = "hours";
}
elseif($ltime > 86400)
{
$new = $ltime;
$ltime = $new/86400;
$var = "days";
}
$ltime = round($ltime, 2);
if($ltime != 0)
{
echo "Idle For: $ltime $var<br/>\n";
}
else
{
echo "Online.<br/>\n";
}
echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=search\">Search</a><br/><br/>\n";
}
}
break;

case 'allusers':
$query = @mysql_query("SELECT COUNT(*) FROM `chat_users`;");
$all = @mysql_result($query, 0);

if(isset($_GET['s'])) $s = intval($_GET['s']);
else $s = 0;
if($s < 0) $s = 0;
if($s > $all) $s = 0;
$c = $s + 1;

if ($s > 20)  print "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=allusers&amp;s=0\">&lt;&lt;&lt;&lt;</a><br/>";
if ($s > 0)  print "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=allusers&amp;s=".($s-10)."\">&lt;&lt;&lt;</a><br/>";

$query = @mysql_query("SELECT `id`, `nickname`, `posts` FROM `chat_users` ORDER BY `posts` DESC LIMIT $s, 10;");

while($user = mysql_fetch_array($query))
{
$uid = $user['id'];
$nick = $user['nickname'];
$posts = $user['posts'];
echo "$c. $nick, ID=$uid - $posts<br/>\n";
$c++;
}

if ($all > $s + 10)  print "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=allusers&amp;s=".($s+10)."\">&gt;&gt;&gt;</a><br/>";
if (($all > $s + 10) && ($all - $s > 20))  print "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=allusers&amp;s=".($all-10)."\">&gt;&gt;&gt;&gt;</a><br/>";
break;

case 'kicklist':
$query = @mysql_query("SELECT COUNT(*) FROM `chat_users` WHERE `kick` > ".time().";");
$all = @mysql_result($query, 0);

if(isset($_GET['s'])) $s = intval($_GET['s']);
else $s = 0;
if($s < 0) $s = 0;
if($s > $all) $s = 0;
$c = $s + 1;

if ($s > 20)  print "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=kicklist&amp;s=0\">&lt;&lt;&lt;&lt;</a><br/>";
if ($s > 0)  print "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=kicklist&amp;s=".($s-10)."\">&lt;&lt;&lt;</a><br/>";

$query = @mysql_query("SELECT `id`, `nickname`, `kick`, `moder`, `reason` FROM `chat_users` WHERE `kick` > ".time().";");

if(mysql_num_rows($query) == 0)
{
echo "Ban list is empty.<br/>\n";
}

while($kick = mysql_fetch_array($query))
{
$nickname = $kick['nickname'];
$uid = $kick['id'];
$time = $kick['kick'] - time();
$moder = $kick['moder'];
$reason = $kick['reason'];
echo "$c. $nickname, ID=$uid.<br/>\n";
echo "Restore in <u>$time</u> seconds., kicked by <u>$moder</u>, Reason:<br/>\n";
echo "<u>$reason</u><br/>\n";
$c++;
}

if ($all > $s + 10)  print "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=kicklist&amp;s=".($s+10)."\">&gt;&gt;&gt;</a><br/>";
if (($all > $s + 10) && ($all - $s > 20))  print "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=kicklist&amp;s=".($all-10)."\">&gt;&gt;&gt;&gt;</a><br/>";
break;

case 'editroom':
if(!isset($_POST['action']))
{
$q = mysql_query("SELECT `id`, `name` FROM `chat_rooms`;");
	if(mysql_num_rows($q) == 0)
	{
	echo "No rooms.<br/>\n";
	}
	else
	{
	echo "<div class=\"form\">\n";
	echo "<form method=\"post\" action=\"moder.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;mod=editroom\">\n";
	echo "<select name=\"room\">\n";
		while($room = mysql_fetch_array($q))
		{
		$name = $room['name'];
		$rid = $room['id'];
		echo "<option value=\"$rid\">$name</option>\n";
		}
	echo "</select><br/>\n";
	echo "<input type=\"hidden\" name=\"action\" value=\"edit\"/>\n";
	echo "<input type=\"submit\" value=\"Edit\"/></form></div><br/>\n";
	}
}
else
{
$room = intval($_POST['room']);
$q = mysql_query("SELECT `topic` FROM `chat_rooms` WHERE `id` = '".$room."';");

if(mysql_num_rows($q) == 0)
{
echo "Room  does not exist.<br/>\n";
break;
}

$topic = mysql_result($q, 0);

echo "<form method=\"post\" action=\"moder.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;mod=uproom\">\n";
echo "Title:<br/>\n";
echo "<input name=\"topic\" maxlength=\"20\" value=\"$topic\" title=\"topic\"/><br/>\n";
echo "Транслитировать: <input type=\"checkbox\" name=\"translit\" value=\"true\"/><br/>\n";
echo "<input type=\"hidden\" name=\"room\" value=\"".$_POST['room']."\"/>\n";
echo "<input type=\"submit\" value=\"Save\"/></form><br/>\n";
}
break;

case 'uproom':
$room = intval($_POST['room']);
$q = mysql_query("SELECT `id` FROM `chat_rooms` WHERE `id` = '".$room."';");
if(mysql_num_rows($q) == 0)
{
echo "Room  does not exist.<br/>\n";
break;
}
$topic = trim(mysql_escape_string(htmlspecialchars($_POST['topic'])));
$topic = str_replace('$', '$$', $topic);


if(empty($topic))
{
echo "You do not have topic!<br/>\n";
break;
}

$q = mysql_query("UPDATE `chat_rooms` SET `topic` = '".$topic."' WHERE `id` = '".$room."';");
echo "header changed!<br/>\n";
break;

case 'clear':
$q = mysql_query("TRUNCATE TABLE `chat`;");
echo "successfully cleaned!<br/>\n";
break;

case 'addnews':
if(!isset($_POST['action']))
{
echo "<form method=\"post\" action=\"moder.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;mod=addnews\">\n";
echo "Title:<br/>\n";
echo "<input name=\"title\" maxlength=\"20\" value=\"\" title=\"title\"/><br/>\n";
echo "Text:<br/>\n";
echo "<input name=\"text\" maxlength=\"300\" value=\"\" title=\"text\"/><br/>\n";
echo "<input type=\"hidden\" name=\"action\" value=\"add\"/>";
echo "<input type=\"submit\" value=\"Add\"/></form><br/>\n";
}
else
{

$title = htmlspecialchars(mysql_escape_string(trim($_POST['title'])));
$title = str_replace('$', '$$', $title);
$text = htmlspecialchars(mysql_escape_string(trim($_POST['text'])));
$text = str_replace('$', '$$', $text);


if(empty($title))
{
echo "title empty!<br/>\n";
break;
}

if(empty($text))
{
echo "text empty!<br/>\n";
break;
}

$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `name` = '".$title."' AND `text` = '".$text."';");
$nickname = mysql_result($q, 0);

if(mysql_affected_rows($q) != 0)
{
echo "News had already been exist.<br/>\n";
break;
}

$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$nickname = mysql_result($q, 0);
$date = date("d-m-Y");

$sql = mysql_query("INSERT INTO `chat_news` VALUES(0, '".$title."', '".$nickname."', '".$text."', '".$date."', ".time().");");

if($sql)
{
echo "News successfully added!<br/>\n";
}
else
{
echo "News not added, Error!<br/>\n";
echo mysql_error()."<br/>\n";
}
}
break;

case 'delnews':
if(!isset($_POST['action']))
{
	$q = mysql_query("SELECT `id`, `name` FROM `chat_news`;");
	if(mysql_num_rows($q) == 0)
	{
	echo "No News.<br/>\n";
	}
	else
	{
		echo "<form method=\"post\" action=\"moder.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;mod=delnews\">\n";
		echo "<select multiple=\"false\" name=\"nid\">\n";
		while($news = mysql_fetch_array($q))
		{
			$name = $news['name'];
			$nid = $news['id'];
			echo "<option value=\"$nid\">$name</option>\n";
		}
		echo "</select><br/>\n";
		echo "<input type=\"hidden\" name=\"action\" value=\"delete\"/>";
		echo "<input type=\"submit\" value=\"Remove\"/></form><br/>\n";
	}
}
else
    {
	 $nid = intval($_POST['nid']);
	 $q = mysql_query("DELETE FROM `chat_news` WHERE `id` = '".$nid."';");
	 if(mysql_affected_rows() != 0)
	 {
	 echo "News successfully removed!<br/>\n";
	 }
	 else
	 {
	 echo "not removed.<br/>\n";
	 }
    }
break;

case 'addmeet':
if(!isset($_POST['action']))
{
echo "<form method=\"post\" action=\"moder.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;mod=addmeet\">\n";
echo "Title:<br/>\n";
echo "<input name=\"title\" maxlength=\"20\" value=\"\" title=\"title\"/><br/>\n";
echo "Text Meetings:<br/>\n";
echo "<input name=\"text\" maxlength=\"300\" value=\"\" title=\"text\"/><br/>\n";
echo "<input type=\"hidden\" name=\"action\" value=\"add\"/>";
echo "<input type=\"submit\" value=\"Add\"/></form><br/>\n";
}
else
{

$title = htmlspecialchars(mysql_escape_string(trim($_POST['title'])));
$title = str_replace('$', '$$', $title);
$text = htmlspecialchars(mysql_escape_string(trim($_POST['text'])));
$text = str_replace('$', '$$', $text);


if($tt == "true")
{
$title = str_replace($lat, $rus, $title);
}

if($ta == "true")
{
$text = str_replace($lat, $rus, $text);
}

if(empty($title))
{
echo "You do not have Title Meetings!<br/>\n";
break;
}

if(empty($text))
{
echo "You do not have Text Meetings!<br/>\n";
break;
}

$sql = mysql_query("SELECT `id` FROM `chat_meets` WHERE `title` = '".$title."' AND `body` = '".$text."';");

if(mysql_num_rows($sql) != 0)
{
echo "meeting has already exist.<br/>\n";
break;
}

$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `id` = '".$id."';");
$nickname = mysql_result($q, 0);
$date = date("d-m-Y");

$sql = mysql_query("INSERT INTO `chat_meets` VALUES(0, '".$nickname."', '".$title."', '".$text."', '".$date."', ".time().");");

if($sql)
{
echo "Meeting successfully added!<br/>\n";
}
else
{
echo "Mysql Error!<br/>\n";
echo mysql_error()."<br/>\n";
}
}
break;

case 'delmeet':
if(!isset($_POST['action']))
{
$q = mysql_query("SELECT `id`, `title` FROM `chat_meets`;");
	if(mysql_num_rows($q) == 0)
	{
	echo "Empty <br/>\n";
	}
	else
	{
	echo "<form method=\"post\" action=\"moder.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;mod=delmeet\">\n";
	echo "<select multiple=\"false\" name=\"mid\">\n";
		while($meets = mysql_fetch_array($q))
		{
		$name = $meets['title'];
		$mid = $meets['id'];
		echo "<option value=\"$mid\">$name</option>\n";
		}
	echo "</select><br/>\n";
	echo "<input type=\"hidden\" name=\"action\" value=\"delete\"/>";
	echo "<input type=\"submit\" value=\"Remove\"/></form><br/>\n";
	}
}
else
{
$mid = intval($_POST['mid']);
$q = mysql_query("DELETE FROM `chat_meets` WHERE `id` = '".$mid."';");
	if(mysql_affected_rows() != 0)
	{
	echo "successfully removed!<br/>\n";
	}
	else
	{
	echo "error in remove.<br/>\n";
	}
}
break;

default:
echo "<form method=\"post\" action=\"moder.php?nocache=$nocache&amp;ver=html&amp;".SID."&amp;handler\">\n";
echo "[User]<br/>\n";
echo "Nickname:<br/>\n";
echo "<input name=\"nickname\" maxlength=\"20\" title=\"nickname\"/><br/>\n";
//echo "Транслитировать:<br/>\n";
echo "Time:<br/>\n";
echo "<select name=\"time\">\n";
echo "<option value=\"60\" selected=\"selected\">60</option>\n";
echo "<option value=\"90\">90</option>\n";
echo "<option value=\"300\">300</option>\n";
echo "<option value=\"43200\">43200</option>\n";
echo "<option value=\"86400\">86400</option>\n";
echo "<option value=\"172800\">172800</option>\n";
echo "</select><br/>\n";
echo "Reason:<br/>\n";
echo "<input name=\"reason\" maxlength=\"200\" title=\"reason\"/><br/>\n";
echo "Change:<br/>\n";
echo "<select name=\"mod\">\n";
echo "<option value=\"0\" selected=\"selected\">Change Status</option>\n";
echo "<option value=\"1\">Kick</option>\n";
echo "</select><br/>\n";
echo "<input type=\"submit\" value=\"OK\"/></form></div><br/>\n";
//echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=search\">Search по ID</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=allusers\">Users List</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=kicklist\">Kick List</a><br/>\n";
echo "---<br/>\n";
echo "[Rooms]<br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=editroom\">Edit Room</a><br/>\n";
//echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=clear\">Clear Rooms</a><br/>\n";
echo "---<br/>\n";
echo "[Other]<br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=addnews\">Add News</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=delnews\">Remove News</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=addmeet\">Add meetings</a><br/>\n";
echo "<a href=\"moder.php?".SID."&amp;ver=html&amp;mod=delmeet\">Remove meetings</a><br/>\n";
break;
}
if(!empty($mod)) echo "<a href=\"moder.php?".SID."&amp;ver=html\">Moderator</a><br/>\n";
echo "<br/><a href=\"menu.php?".SID."&amp;ver=html\">Hall</a><br/>";
include_once "themes/".intval($_COOKIE['theme'])."/foot.php";
break;
}
?>