View file chat/inc/umnik.php

<?php

$umnik_last = dbassoc(dbquery("SELECT * FROM `chat_post` WHERE `room` = '$room[id]' AND `umnik_st` <> '0' ORDER BY id DESC"));

if ($umnik_last != NULL && $umnik_last['umnik_st'] != 4 && $umnik_last['umnik_st'] != 0) {
    $umnik_vopros = dbassoc(dbquery("SELECT * FROM `chat_vopros` WHERE `id` = '$umnik_last[vopros]' LIMIT 1"));
    $umnik_post = dbassoc(dbquery("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"));

    if ($umnik_post != NULL) {
        $ank = dbassoc(dbquery("SELECT * FROM `user` WHERE `id` = '$umnik_post[id_user]' LIMIT 1"));
        $add_balls = 0;

        if ($umnik_last['umnik_st'] == 1) {
            $add_balls = 25;
            $pods = 'не используя подсказок';
        }

        if ($umnik_last['umnik_st'] == 2) {
            $add_balls = 10;
            $pods = 'используя одну подсказку';
        }

        if ($umnik_last['umnik_st'] == 3) {
            $add_balls = 5;
            $pods = 'используя обе посказки';
        }

        $msg = "Молодец, [b]$ank[nick][/b].\nТы первым дал верный ответ: [b]$umnik_vopros[otvet][/b] $pods.\n[b]$ank[nick][/b] получает $add_balls баллов.\nСледующий вопрос через $set[umnik_new] сек.";

        dbquery("INSERT INTO `chat_post` (`umnik_st`, `time`, `msg`, `room`, `vopros`, `privat`) values('4', '$time', '$msg', '$room[id]', '$umnik_vopros[id]', '0')");
        dbquery("UPDATE `user` SET `balls` = '" . ($ank['balls'] + $add_balls) . "' WHERE `id` = '$ank[id]' LIMIT 1");
    }
}

$umnik_last1 = dbassoc(dbquery("SELECT * FROM `chat_post` WHERE `room` = '$room[id]' AND `umnik_st` = '1' ORDER BY id DESC"));

if ($umnik_last1 != NULL && $umnik_last['umnik_st'] != 4 && $umnik_last1['time'] < time() - $set['umnik_time']) {
    $umnik_vopros = dbassoc(dbquery("SELECT * FROM `chat_vopros` WHERE `id` = '$umnik_last1[vopros]' LIMIT 1"));
    $msg = "На вопрос никто не ответил.\nПравильный ответ: $umnik_vopros[otvet].\nСледующий вопрос через $set[umnik_new] сек.";

    dbquery("INSERT INTO `chat_post` (`umnik_st`, `time`, `msg`, `room`, `vopros`, `privat`) values('4', '$time', '$msg', '$room[id]', '$umnik_vopros[id]', '0')");
}

$umnik_last = dbassoc(dbquery("SELECT * FROM `chat_post` WHERE `room` = '$room[id]' AND `umnik_st` <> '0' ORDER BY id DESC"));

if ($umnik_last == NULL || $umnik_last['umnik_st'] == 4 && $umnik_last['time'] < time() - $set['umnik_new']) {
// задается вопрос
    $k_vopr = dbresult(dbquery("SELECT COUNT(*) FROM `chat_vopros`"), 0);
    $umnik_vopros = dbassoc(dbquery("SELECT * FROM `chat_vopros` LIMIT " . rand(0, $k_vopr) . ", 1"));
    $msg = "[b]Вопрос:[/b] \"$umnik_vopros[vopros]\"\n[b]Ответ:[/b] слово из " . strlen2($umnik_vopros['otvet']) . " букв";

    dbquery("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 = dbassoc(dbquery("SELECT * FROM `chat_vopros` WHERE `id` = '$umnik_last[vopros]' LIMIT 1"));

    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']) . " букв)";

    dbquery("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 = dbassoc(dbquery("SELECT * FROM `chat_vopros` WHERE `id` = '$umnik_last[vopros]' LIMIT 1"));

    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']) . " букв)";

    dbquery("INSERT INTO `chat_post` (`umnik_st`, `time`, `msg`, `room`, `vopros`, `privat`) values('3', '$time', '$msg', '$room[id]', '$umnik_vopros[id]', '0')");
}
?>