Файл: vfermu.ru/sess_cron_ua/turnir.php
Строк: 94
<?php
require_once '../sys/db/conect.php';
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_turnir` WHERE `active` = '1' AND (`time`<'".(time())."' OR `time`='".(time())."')"),0)>0)
{
$turnir=mysql_fetch_array(mysql_query("SELECT * FROM `farm_turnir` WHERE `active` = '1' ORDER by `id` DESC"));
$q=mysql_query("SELECT `id` FROM `farm_user` WHERE `active_turnir` = '1' AND `turnir_count`>'0' ORDER BY `turnir_count` DESC, `rating` DESC");
$num=1;
while($post=mysql_fetch_array($q))
{
$post=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `id` = '$post[id]' "));
if($num==1){$money=$turnir['money']; $rubies=$turnir['rubies']; $rat=$turnir['rating'];}
else if($num==2){$money=round($turnir['money']/2); $rubies=round($turnir['rubies']/2); $rat=round($turnir['rating']/2);}
else if($num==3){$money=round($turnir['money']/4); $rubies=round($turnir['rubies']/4); $rat=round($turnir['rating']/4);}
else {$money=0; $rubies=0; $rat=round($post['level']*$turnir['cena']*$post['turnir_count']*1000);}
if($num<4){mysql_query("UPDATE `farm_user` SET `money` = '".($post['money']+$money)."',`rubies` = '".($post['rubies']+$rubies)."',`rating`='".($post['rating']+$rat)."' WHERE `id` = '$post[id]'")or die (mysql_error());
$msg='Турнир "'.$turnir['name'].'" окончен. Поздравляем вас, вы заняли '.$num.' место и выиграли [img]/images/icons/experience.png[/img] '.$rat.' [img]/images/icons/money.png[/img] '.$money.' [img]/images/icons/ruby.png[/img] '.$rubies.' [img]/images/icons/pkey.png[/img] '.$timekey.'. Посмотреть [url=turnir/st-'.$turnir['id'].']Результаты турнира[/url]';
mysql_query("INSERT INTO `farm_mail` SET `id_user` = '$post[id]', `id_kont` = '1', `msg` = '$msg', `time` = '".time()."', `type` = 'to'") or die (mysql_error());
$gift=serialize(array(''.$rat.'',''.$money.'',''.$rubies.'',''.$timekey.''));
}
else {mysql_query("UPDATE `farm_user` SET `rating` = '".($post['rating']+$rat)."' WHERE `id` = '$post[id]'");
$msg='Турнир "'.$turnir['name'].'" окончен. Поздравляем вас, вы заняли '.$num.' место и получили утешительный приз [img]/images/icons/experience.png[/img] '.$rat.'. Посмотреть [url=turnir/st-'.$turnir['id'].']Результаты турнира[/url]';
mysql_query("INSERT INTO `farm_mail` SET `id_user` = '$post[id]', `id_kont` = '0', `msg` = '$msg', `time` = '".time()."', `type` = 'to'") or die (mysql_error());
$gift=$rat;
}
mysql_query("INSERT INTO `farm_turnir_st` SET `id_user` = '$post[id]', `id_turnir` = '$turnir[id]', `mesto` = '$num', `count` = '$post[turnir_count]', `gift` = '$gift'") or die (mysql_error());
$num++;
}
mysql_query("UPDATE `farm_user` SET `turnir_count` = '0' ,`active_turnir`='0'");
mysql_query("UPDATE `farm_turnir` SET `active` = '0' WHERE `id`='$turnir[id]'");
}
?>