Файл: www/chat/umnik.php
Строк: 104
<?php
$umnik_last=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_post` WHERE `id_rm`='".$rm."' AND `umnik_st`<>'0' ORDER BY id DESC"));
if($umnik_last!=NULL && $umnik_last['umnik_st']!=4 && $umnik_last['umnik_st']!=0){
$umnik_vopros=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_vopros` WHERE `id`='".$umnik_last['vopros']."' LIMIT 1"));
$umnik_post=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_post` WHERE `id_rm`='".$rm."' AND `msg` like '%$umnik_vopros[otvet]%' AND `umnik_st`='0' AND `time`>='".(time()-30)."' ORDER BY `id` DESC LIMIT 1"));
if($umnik_post!=NULL){
$ank=mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `id`='".$umnik_post['id_user']."' LIMIT 1"));
$add_balls=0;
if($umnik_last['umnik_st']==1){
$add_balls=0.30; $pods='Подсказки не были использованы';}
if($umnik_last['umnik_st']==2){
$add_balls=0.20; $pods='Была использована одна подсказка';}
if($umnik_last['umnik_st']==3){
$add_balls=0.10; $pods='Были использованы две подсказки';}
$count_otv=$ank['count_otv']+1;
mysql_query("UPDATE `users` SET `kr`=`kr`+'$add_balls', `count_otv`=`count_otv`+1 WHERE `id`='".$ank['id']."'");
$old_day=mktime(0, 0, 0, date('m'), date('d')+7, date('Y'));
$isset=mysql_num_rows(mysql_query("SELECT * FROM `chat_top` WHERE `id_user`='".$ank['id']."' AND `time`<'".$old_day."'"));
if(!$isset){
mysql_query("INSERT INTO `chat_top` SET `time`='".time()."', `id_user`='".$ank['id']."', `count`='1'");
}else{
mysql_query("UPDATE `chat_top` SET `count`=`count`+1, `time`='".time()."' WHERE `id_user`='".$ank['id']."'");}
$msg='Поздравляем![br] Правильно ответил на вопрос: [url=/info.php?id='.$ank['id'].'][b]'.$ank['login'].'[/b][/url] ['.$count_otv.' отв][br] '.$pods.'[br] Ответ: [b]'.$umnik_vopros['otvet'].'[/b][br] Выигрыш: '.$add_balls.'кр[br] Следующий вопрос через пару секунд';
mysql_query("INSERT INTO `chat_post` SET `umnik_st`='4', `time`='".time()."', `msg`='".$msg."', `id_rm`='".$rm."', `vopros`='".$umnik_vopros[id]."', `id_to`='0', `id_user`='".$set['umn']."'");}}
if($umnik_last!=NULL && $umnik_last['umnik_st']==3 && $umnik_last['time']<time()-30){
$umnik_vopros=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_vopros` WHERE `id`='".$umnik_last['vopros']."' LIMIT 1"));
$msg=''.$umnik_vopros['vopros'].' ('.strlen2($umnik_vopros['otvet']).' букв)[br] Ответ на вопрос был: [b]'.$umnik_vopros['otvet'].'[/b][br] Следующий вопрос через пару секунд';
mysql_query("INSERT INTO `chat_post` SET `umnik_st`='4', `time`='".time()."', `msg`='".$msg."', `id_rm`='".$rm."', `vopros`='".$umnik_vopros['id']."', `id_to`='0', `id_user`='".$set['umn']."'");}
$umnik_last=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_post` WHERE `id_rm`='".$rm."' AND `umnik_st`<>'0' ORDER BY id DESC"));
if($umnik_last==NULL || $umnik_last['umnik_st']==4 && $umnik_last['time']<time()-10){
// задается вопрос
$k_vopr=mysql_num_rows(mysql_query("SELECT `id` FROM `chat_vopros`"));
$umnik_vopros=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_vopros` LIMIT ".rand(0,$k_vopr).", 1"));
$msg='Внимание! Новый вопрос[br] [b]'.$umnik_vopros['vopros'].' ('.strlen2($umnik_vopros['otvet']).' букв)[/b]';
mysql_query("INSERT INTO `chat_post` SET `umnik_st`='1', `time`='".time()."', `msg`='".$msg."', `vopros`='".$umnik_vopros['id']."', `id_rm`='".$rm."', `id_to`='0', `id_user`='".$set['umn']."'");}
if($umnik_last!=NULL && $umnik_last['umnik_st']==1 && $umnik_last['time']<time()-20){
$umnik_vopros=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_vopros` WHERE `id`='".$umnik_last['vopros']."' LIMIT 1"));
$help=iconv_substr($umnik_vopros['otvet'], 0, 1, 'utf-8');
for($i=0;$i<strlen2($umnik_vopros['otvet'])-1;$i++){
$help.='.';}
$msg=''.$umnik_vopros['vopros'].' ('.strlen2($umnik_vopros['otvet']).' букв)[br] Подсказка: [b]'.$help.'[/b]';
mysql_query("INSERT INTO `chat_post` SET `umnik_st`='2', `time`='".time()."', `msg`='".$msg."', `id_rm`='".$rm."', `vopros`='".$umnik_vopros['id']."', `id_to`='0', `id_user`='".$set['umn']."'");}
if($umnik_last!=NULL && $umnik_last['umnik_st']==2 && $umnik_last['time']<time()-20){
$umnik_vopros=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_vopros` WHERE `id`='".$umnik_last['vopros']."' LIMIT 1"));
$help=iconv_substr($umnik_vopros['otvet'], 0, 2, 'utf-8');
for($i=0;$i<strlen2($umnik_vopros['otvet'])-2;$i++){
$help.='.';}
$msg=''.$umnik_vopros['vopros'].' ('.strlen2($umnik_vopros['otvet']).' букв)[br] Подскажу больше: [b]'.$help.'[/b]';
mysql_query("INSERT INTO `chat_post` SET `umnik_st`='3', `time`='".time()."', `msg`='".$msg."', `id_rm`='".$rm."', `vopros`='".$umnik_vopros['id']."', `id_to`='0', `id_user`='".$set['umn']."'");}
?>