Файл: bloodlands.pw/include/coolwarik.php
Строк: 72
<?php
define('cms', 1);
require_once 'db.php';
$column = mysql_result(mysql_query("SELECT count(*) FROM `orden`"), 0);
if($column > 0){
$top = mysql_query("SELECT * FROM `orden` LIMIT ".$column."");
while($res = mysql_fetch_array($top)){
$exp = mysql_result(mysql_query("SELECT SUM(`exp`) FROM `users` WHERE `orden` = '".$res['id']."'"), 0);
$kol = mysql_num_rows(mysql_query("SELECT `id` FROM `users` WHERE `orden` = '".$res['id']."'"));
$act_kol = mysql_num_rows(mysql_query("SELECT `id` FROM `users` WHERE `orden` = '".$res['id']."' AND `online` > '".(time()-86400)."'"));
$win = mysql_result(mysql_query("SELECT SUM(`win`) FROM `users` WHERE `orden` = '".$res['id']."'"), 0);
$repute = mysql_result(mysql_query("SELECT SUM(`repute`) FROM `users` WHERE `orden` = '".$res['id']."'"), 0);
$artefakts = mysql_result(mysql_query("SELECT count(*) FROM `clan_things` WHERE `orden` = '".$res['id']."'"), 0);
$sr_exp = round($exp/$kol);
$sr_exp_win = round($exp/$win);
$point = round(($sr_exp_win/0.5)+($artefakts/0.5)+($act_kol/0.5)+($repute/10)-(($kol-$act_kol)*10));
if(!empty($res['cite'])) $point = round($point+20);
mysql_query("UPDATE `orden` SET `exp` = '".$exp."', `kol` = '".$kol."', `act_kol` = '".$act_kol."', `sr_exp` = '".$sr_exp."', `sr_exp_win` = '".$sr_exp_win."', `repute` = '".$repute."', `artefakts` = '".$artefakts."', `point` = '".$point."', `minus` = '0' WHERE `id` = '".$res['id']."'");
}}
$data = date("G", time());
if($data >= 0 && $data < 1){
mysql_query("UPDATE `settings` SET `time_bonus` = '0'");
mysql_query("DELETE FROM `zags`");
}
$column = mysql_result(mysql_query("SELECT count(*) FROM `block` WHERE `end` = '0'"), 0);
if($column > 0){
$top = mysql_query("SELECT * FROM `block` WHERE `end` = '0' LIMIT ".$column."");
while($res = mysql_fetch_array($top)){
$users = mysql_fetch_array(mysql_query("SELECT `orden` FROM `users` WHERE `id` = '".$res['user']."'"));
if($users['orden'] > 0){
$clan = mysql_fetch_array(mysql_query("SELECT * FROM `orden` WHERE `id` = '".$users['orden']."'"));
if($res['type'] == 1) $minus = 10; elseif($res['type'] == 2) $minus = 20;
$itog = round($clan['minus']+$minus);
$kol = round($clan['point']-$itog);
if($kol < 1) $kol = 1;
mysql_query("UPDATE `orden` SET `minus` = '".$itog."', `point` = '".$kol."' WHERE `id` = '".$users['orden']."'");
}}}
$column = mysql_result(mysql_query("SELECT count(*) FROM `fight` WHERE `end` = '1'"), 0);
if($column > 0){
$top = mysql_query("SELECT * FROM `fight` WHERE `end` = '1' LIMIT ".$column."");
while($res = mysql_fetch_array($top)){
mysql_query("DELETE FROM `fight_user` WHERE `fight` = '".$res['id']."'");
mysql_query("DELETE FROM `fight_udar` WHERE `fight` = '".$res['id']."'");
mysql_query("DELETE FROM `fight` WHERE `id` = '".$res['id']."'");
}}
?>