<?php
if ( $room['umnik'] == 1 ) {
$umnik_last = db::fetch("SELECT * FROM `chat_post` WHERE `room` = '$room[id]' AND `umnik_st` <> '0' ORDER BY id DESC", ARRAY_A);
if ( $umnik_last != NULL && $umnik_last['umnik_st'] != 4 && $umnik_last['umnik_st'] != 0 ) {
$umnik_vopros = db::fetch("SELECT * FROM `chat_vopros` WHERE `id` = '$umnik_last[vopros]' LIMIT 1", ARRAY_A);
$umnik_post = db::fetch("SELECT * FROM `chat_post` WHERE `room` = '$room[id]' AND `msg` like '%$umnik_vopros[otvet]%' AND `umnik_st` = '0' AND `time` >= '" . ( $time - $umnik_last['time'] ) . "' ORDER BY `id` ASC LIMIT 1", ARRAY_A);
if ( $umnik_post != NULL ) {
$add_balls = 0;
if ( $umnik_last['umnik_st'] == 1 ) {
$add_balls = 25;
$pods = 'не используя подсказок';
} elseif ( $umnik_last['umnik_st'] == 2 ) {
$add_balls = 10;
$pods = 'используя одну подсказку';
} elseif ( $umnik_last['umnik_st'] == 3 ) {
$add_balls = 5;
$pods = 'используя обе посказки';
}
$msg = "Молодец, [b]" . user::nick( $umnik_post['id_user'], 0 ) . "[/b].\n
Ты первым дал верный ответ: [b]$umnik_vopros[otvet][/b] $pods.\n
[b]" . user::nick( $umnik_post['id_user'], 0 ) . "[/b] получает [blue]$add_balls баллов[/blue].\n
Следующий вопрос через $set[umnik_new] сек.
";
db::query("INSERT INTO `chat_post` (`umnik_st`, `time`, `msg`, `room`, `vopros`, `privat`) values('4', '$time', '$msg', '$room[id]', '$umnik_vopros[id]', '0')");
db::query("UPDATE `user` SET `balls` = `balls` + '" . $add_balls . "' WHERE `id` = '$umnik_post[id_user]' LIMIT 1");
db::query("UPDATE `chat_who` SET `count_umnik` = `count_umnik` + '1' WHERE `id_user` = '$user[id]' LIMIT 1");
db::query("UPDATE `chat_post` SET `umnik_st` = '4' WHERE `id` = '$umnik_post[id]' LIMIT 1");
header( 'Location: ?func=room&id=' . $ID . '&sid=' . $_SESSION['sid'] );
exit;
}
}
$umnik_last1 = db::fetch("SELECT * FROM `chat_post` WHERE `room` = '$room[id]' AND `umnik_st` = '1' ORDER BY id DESC", ARRAY_A);
if ( $umnik_last1 != NULL && $umnik_last['umnik_st'] != 4 && $umnik_last1['time'] < time() - $set['umnik_time'] ) {
$umnik_vopros = db::fetch("SELECT * FROM `chat_vopros` WHERE `id` = '$umnik_last1[vopros]' LIMIT 1", ARRAY_A);
$msg = "На вопрос никто не ответил.\n
Правильный ответ: [red]$umnik_vopros[otvet][/red].\n
Следующий вопрос через $set[umnik_new] сек.
";
db::query("INSERT INTO `chat_post` (`umnik_st`, `time`, `msg`, `room`, `vopros`, `privat`) values('4', '$time', '$msg', '$room[id]', '$umnik_vopros[id]', '0')");
db::query("UPDATE `chat_post` SET `umnik_st` = '4' WHERE `id` = '$umnik_last1[id]' LIMIT 1");
header( 'Location: ?func=room&id=' . $ID . '&sid=' . $_SESSION['sid'] );
exit;
}
$umnik_last = db::fetch("SELECT * FROM `chat_post` WHERE `room` = '$room[id]' AND `umnik_st` <> '0' ORDER BY id DESC", ARRAY_A);
if ( $umnik_last == NULL || $umnik_last['umnik_st'] == 4 && $umnik_last['time'] < time() - $set['umnik_new'] ) {
$k_vopr = db::count("SELECT COUNT(*) FROM `chat_vopros`");
$umnik_vopros = db::fetch("SELECT * FROM `chat_vopros` LIMIT " . rand( 0, $k_vopr ) . ", 1", ARRAY_A);
$msg = "[b]Вопрос:[/b] \"$umnik_vopros[vopros]\"\n
[b]Ответ:[/b] слово из " . strlen2( $umnik_vopros['otvet'] ) . " букв.
";
db::query("INSERT INTO `chat_post` (`umnik_st`, `time`, `msg`, `room`, `vopros`, `privat`) values('1', '$time', '$msg', '$room[id]', '$umnik_vopros[id]', '0')");
}
if ( $umnik_last != NULL && $umnik_last['umnik_st'] == 1 && $umnik_last['time'] < time() - $set['umnik_help'] ) {
$umnik_vopros = db::fetch("SELECT * FROM `chat_vopros` WHERE `id` = '$umnik_last[vopros]' LIMIT 1", ARRAY_A);
if ( function_exists( 'iconv_substr' ) ) {
$help = iconv_substr( $umnik_vopros['otvet'], 0, 1, 'utf-8' );
} else {
$help = substr( $umnik_vopros['otvet'], 0, 2 );
}
for ( $i = 0; $i < strlen2( $umnik_vopros['otvet'] ) - 1; $i++ ) {
$help .= '*';
}
$msg = "[b]Вопрос:[/b] \"$umnik_vopros[vopros]\"\n
[b]Первая подсказка:[/b] $help (" . strlen2( $umnik_vopros['otvet'] ) . " букв)
";
db::query("INSERT INTO `chat_post` (`umnik_st`, `time`, `msg`, `room`, `vopros`, `privat`) values('2', '$time', '$msg', '$room[id]', '$umnik_vopros[id]', '0')");
}
if ( $umnik_last != NULL && $umnik_last['umnik_st'] == 2 && $umnik_last['time'] < time() - $set['umnik_help'] ) {
$umnik_vopros = db::fetch("SELECT * FROM `chat_vopros` WHERE `id` = '$umnik_last[vopros]' LIMIT 1", ARRAY_A);
if ( function_exists( 'iconv_substr' ) ) {
$help = iconv_substr( $umnik_vopros['otvet'], 0, 2, 'utf-8' );
} else {
$help = substr( $umnik_vopros['otvet'], 0, 4 );
}
for ( $i = 0; $i < strlen2( $umnik_vopros['otvet'] ) - 2; $i++ ) {
$help .= '*';
}
$msg = "[b]Вопрос:[/b] \"$umnik_vopros[vopros]\"\n
[b]Вторая подсказка:[/b] $help (" . strlen2( $umnik_vopros['otvet'] ) . " букв)
";
db::query("INSERT INTO `chat_post` (`umnik_st`, `time`, `msg`, `room`, `vopros`, `privat`) values('3', '$time', '$msg', '$room[id]', '$umnik_vopros[id]', '0')");
}
}
?>