Файл: chat/anagram11.php
Строк: 76
<?php
$b = mysql_fetch_array(mysql_query("SELECT * FROM `vopros_anagram2` WHERE `ids2` = '1'"));
$nom = $b['number2'];
$vr = $b['time'];
$answ = $b['answer2'];
if (time() >= $vr) {
if ($nom == 5) {
$st = time();
$st = $st + 240;
mysql_query("UPDATE `vopros_anagram2` SET `time` = '$st' WHERE `ids2` = '1' LIMIT 1");
$a = mysql_result(mysql_query("SELECT COUNT(*) FROM `bota2`"), 0);
$rnd = mt_rand(1, $a);
$re = mysql_fetch_array(mysql_query("SELECT * FROM `bota2` WHERE `number2` = '$rnd' LIMIT 1"));
$answ = $re['answer2'];
$tran = $re['tran2'];
$nom = 0;
$vr = $st;
$arr = preg_split("//u", $re['answer2'], -1, PREG_SPLIT_NO_EMPTY);
shuffle($arr);
$vprs = join('', $arr);
$vp = 'Miniet vārdu: <b>' . $vprs . '</b>';
mysql_query("UPDATE `vopros_anagram2` SET `number2` = '$nom', `question2` = '$vp', `answer2` = '$answ', `tran2` = '$tran' WHERE `ids2` = '1' LIMIT 1");
$ids = mt_rand(100000, 999999);
mysql_query("INSERT INTO `message` SET
`id` = '$ids',
`user` = 'AnAgRaMmA',
`who` = '0',
`time` = '" . time() . "',
`msg` = '$vp',
`room` = '$rm'");
} else {
$st = time();
$st = $st + 20;
mysql_query("UPDATE `vopros_anagram2` SET `time` = '$st' WHERE `ids2` = '1' LIMIT 1");
$a = mysql_result(mysql_query("SELECT COUNT(*) AS num FROM `bota2`"), 0);
$rnd = mt_rand(1, $a);
$re = mysql_fetch_array(mysql_query("SELECT * FROM `bota2` WHERE `number2` = '$rnd' LIMIT 1"));
$answ = $re['answer2'];
$tran = $re['tran2'];
$nom = 5;
$vr = $st;
$b1 = mysql_fetch_array(mysql_query("SELECT `answer2` FROM `vopros_anagram2` WHERE `ids2` = '1' LIMIT 1"));
$otvet = $b1['answer2'];
$vp = 'Atbilde uz anagrammu bija: <b>' . $otvet . '</b>! Nākamā anagramma pēc 20 sekundēm.';
$ids = mt_rand(100000, 999999);
mysql_query("INSERT INTO `message` SET
`id` = '$ids',
`user` = 'AnAgRaMmA',
`who` = '0',
`time` = '" . time() . "',
`msg` = '$vp',
`room` = '$rm'");
mysql_query("UPDATE `vopros_anagram2` SET `number2` = '$nom', `answer2` = '$answ', `tran2` = '$tran' WHERE `ids2` = '1' LIMIT 1");
$vp = 'Laiks iztecējis! Nākamā anagramma pēc 20 sekundēm.';
$ids = mt_rand(100000, 999999);
mysql_query("INSERT INTO SET `message`
`id` = '$ids',
`user` = 'AnAgRaMmA',
`who` = '0',
`time` = '" . time() . "',
`msg` = '$vp',
`room` = '$rm'");
}
} elseif ((($vr - time()) < 150) && ($nom == 0)) {
$nom = 1;
mysql_query("UPDATE `vopros_anagram2` SET `number2` = '$nom' WHERE `ids2` = '1' LIMIT 1");
$first_l = mb_substr($answ, 0, 1, 'UTF8');
$vp = '<b>Pirmais burts:</b> ' . $first_l . '...';
$ids = mt_rand(100000, 9999999);
mysql_query("INSERT INTO `message` SET
`id` = '$ids',
`user` = 'AnAgRaMmA',
`who` = '0',
`time` = '" . time() . "',
`msg` = '$vp',
`room` = '$rm'");
} elseif ((($vr - time()) < 75) && ($nom < 2)) {
$nom = 2;
mysql_query("UPDATE `vopros_anagram2` SET `number2` = '$nom' WHERE `ids2` = '1' LIMIT 1");
$last_l = mb_substr($answ, -1, 1, 'UTF8');
$vp = '<b>Pēdējais burts:</b> ' . $last_l . '...';
$ids = mt_rand(100000, 9999999);
mysql_query("INSERT INTO `message` SET
`id` = '$ids',
`user` = 'AnAgRaMmA',
`who` = '0',
`time` = '" . time() . "',
`msg` = '$vp',
`room` = '$rm'");
}
?>