View file bots/answer.php

<?php
$msg = preg_replace("/\[(.*)\] /", "", $msg);
$msg = str_replace($bots[0].", ", "", $msg);
$bots = file("bots/bots.dat");
$system = 'QuizMaster';

if($msg == "!question" or $msg == "!вопрос")
{
	if($buff_action != 0)
	{
	$fd = fopen("bots/question.dat", "r");
	$question = fgets($fd);
	fclose($fd);
	$message = "$nickname, $question";
	$system = 'QuizMaster';
       mysql_query("INSERT INTO `chat".$rid."` VALUES(0, '2', '".$system."', '".$message."', '0', '".date("H:i")."', ".time().",0);");
	mysql_query("UPDATE `chat_users` SET `posts` = `posts` + 1 WHERE `id` = 3;");
	}
	else
	{
	$message = "$nickname, time out, wait for the next question.";
	mysql_query("INSERT INTO `chat".$rid."` VALUES(0, '2', '".$system."', '".$message."', '0', '".date("H:i")."', ".time().",0);");
	}
}

$result = substr($msg, 0, 5);
if($result == "stats" && strlen($msg) > 6)
{
$nick = mysql_escape_string(substr($msg, 6));
$sql = mysql_query("SELECT `answers` FROM `chat_users` WHERE `nickname` = '".$nick."';");
	if(mysql_num_rows($sql) == 0)
	{
	$message = "User with the nickname $nick is not in the database!";
	mysql_query("INSERT INTO `chat".$rid."` VALUES(0, '2', '".$system."', '".$message."', '0', '".date("H:i")."', ".time().",0);");
	mysql_query("UPDATE `chat_users` SET `posts` = `posts` + 1 WHERE `id` = 2;");
	}
	else
	{
	$answers = mysql_result($sql, 0);
	$sql = mysql_query("SELECT `nickname` FROM `chat_users` ORDER BY `answers` DESC LIMIT 31;");

		$c = 0;

		while($users = mysql_fetch_array($sql))
		{
		$c++;
		if($users['nickname'] == $nick) break;
		}
		
		if($c != 31) $rating = "В рейтинге он занимает $c место!";
		if($c == 31) $rating = "В рейтинге он занимает место за пределами первых трех десятков умников.";

	$message = "$nick верно ответил(а) на <u>$answers</u> вопросов. $rating";
	mysql_query("INSERT INTO `chat".$rid."` VALUES(0, '2', '".$system."', '".$message."', '0', '".date("H:i:s")."', ".time().",0);");
	}
}

//ANSWER
$fd = fopen("bots/answer.dat", "r");
$answer = fgets($fd);
fclose($fd);

if(($msg == $answer) && $buff_action != 0)
{
$sql = mysql_query("SELECT `answers` FROM `chat_users` WHERE `id` = '".$id."';");
$answers = mysql_result($sql, 0);
$message = "Excellent, $nickname! The correct answer was: <b> $answer </b>. $nickname answers ". (+ + $answers)." question. The next question after ".$intervals[0]." seconds. ";
mysql_query("INSERT INTO `chat".$rid."` VALUES(0, '2', '".$system."', '".$message."', '0', '".date("J:i:s")."', ".time().",0);");
mysql_query("UPDATE `chat_users` SET `answers` = `answers` + 1 WHERE `id` = '".$id."';");
mysql_query("UPDATE `chat_users` SET `posts` = `posts` + 1 WHERE `id` = 3;");

$fd = fopen("bots/time.dat", "w");
flock($fd, LOCK_EX);
$puts = fputs($fd, (time() + $intervals[0])); //NEXT QUESTION
flock($fd, LOCK_UN);
fclose($fd);

$fd = fopen("bots/action.dat", "w");
flock($fd, LOCK_EX);
$puts = fputs($fd, "0");
flock($fd, LOCK_UN);
fclose($fd);
}
?>