Файл: gamele.ru/cron/clans.php
Строк: 62
<?php
$droot = str_replace("cron/".basename(__FILE__), "",__FILE__);
include($droot."/includes/config.inc.php");
include($droot."/includes/functions.php");
$clan = mysql_query("SELECT * FROM `clans` WHERE `vote`<'".time()."' AND `vote`>'0';");
while($row = mysql_fetch_assoc($clan)){
$query = mysql_query("SELECT `user`.`id` FROM `user` WHERE `clan_id`='".$row['clan_id']."';");
$win=0;$last=0;
while($urow = mysql_fetch_array($query)){
$ucnt=count_vote($urow['id']);
if($win==0 and $last==0){if($ucnt>0){$win=$urow['id'];$last=$ucnt;}}
elseif($ucnt>0 and $ucnt>$last){$win=$urow['id'];$last=$ucnt;}
mysql_query("DELETE * FROM `clans_vote` WHERE `upoll`='".$urow['id']."'");
}
if($last>0 and $win>0){
if(mysql_num_rows(mysql_query("SELECT `user`.`id` FROM `user` WHERE `clan_id`='".$row['clan_id']."' AND `clan_status`='9'"))>0){
mysql_query("UPDATE `user` SET `clan_status`='0',`clan_accesses`='0|0|0|0',`clan_d`='Бывший Глава' WHERE `clan_id`='".$row['clan_id']."' AND `clan_status`='9';");
}
mysql_query("UPDATE `user` SET clan_status='9',`clan_accesses`='1|2|4|8',`clan_d`='Глава Клана' WHERE `clan_id`='".$row['clan_id']."' AND `id`='".$win."' LIMIT 1;");
mysql_query("DELETE * FROM `clans_vote` WHERE `clan_id`='".$row['clan_id']."';");
mysql_query("UPDATE `clans` SET `vote`='0' WHERE `clan_id`='".$row['clan_id']."';");
}
}
function count_vote($uid){
$count = mysql_num_rows(mysql_query("SELECT * FROM `clans_vote` WHERE `upoll`='".$uid."'"));
return $count;
}
?>