eat_rices_processing.php

Download you own three BR

<?php

require_once("configs/Configs.php");//加载配置文件
//require_once("functions/login_flag.php");//是否已经登录
require_once("functions/func_common.php");//加载函数文件
require_once("functions/class_mysql.php");//加载数据库类文件


///////////////////////
//士兵消耗粮食
/////////////////////
//根据城市
$query_city_eat=$db->query("select * from city order by c_id asc;");
while ($m_city_eat=$db->fetch_array($query_city_eat)){
	//查询u_id是否存在;
	$u_id_if=$db->query("select u_id from users where u_id='".$m_city_eat['u_id']."';");
	$if_have_user=$db->num_rows($u_id_if);
	if ($if_have_user){
		//查询时间上次消时间
		$query_last_times=$db->query("select * from eat_rices where u_id='".$m_city_eat['u_id']."' and c_id='".$m_city_eat['c_id']."';");
		$list_last_times=$db->fetch_array($query_last_times);
		$eat_ls_num=$db->num_rows($query_last_times);	
		//当前城市是否有士兵
		$query_city_all_soldier=$db->query("select * from soldier where u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."';");
		$list_city_all_soldier=$db->fetch_array($query_city_all_soldier);
		if ($soldier_type_name_en)
		{
			$all_city_soldier_num=0;
			foreach ($soldier_type_name_en as $si=>$smi)
			{
				$city_ls_all_soldier[$si]=$list_city_all_soldier[$smi];//当前城市士兵对应兵种的兵数，临时；
				if ($list_city_all_soldier[$smi]) 
				{
					$all_city_soldier_num+=$list_city_all_soldier[$smi];//当前城市兵数；
				}	
			}
		}	
			
		//是否有拍卖的士兵;
		$query_p_so=$db->query("select s_num from player_safe where u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."' and s_style='1' ;");
		$m_p_so=$db->fetch_array($query_p_so);
		
		//是否有拍卖等待上架的
		$query_p_li_so=$db->query("select s_num from player_lin where u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."' and s_style='1' ;");
		$m_p_li_so=$db->fetch_array($query_p_li_so);
			
			
		//所有士兵;	
		$all_soldier=$all_city_soldier_num+$m_p_so['s_num']+$m_p_li_so['s_sum'];
			
			if (!$eat_ls_num) {			
			$db->query("INSERT INTO `eat_rices` ( `u_id` , `c_id` , `soldier` , `dates` ) 
		   	   VALUES ('".$m_city_eat['u_id']."', '".$m_city_eat['c_id']."', '".$all_soldier."', '".time()."')");
			}
			//查询该城的粮食
			$query_city_rices=$db->query("select rices from resource where u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."';");
			$list_rices=$db->fetch_array($query_city_rices);
			$rices_all=$list_rices['rices'];
			////////////////////////////
			//耗粮开始;
			////////////////////////////
			$nowtimes=time();
			if ($nowtimes>=($list_last_times['dates']+24*60*60)) {
				//统计有几条报表
				$query_report=$db->query("select id from report where u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."' order by id asc;");
				$sum_report_num=$db->num_rows($query_report);
				if ($sum_report_num>2){
					$del_i=0;
					while ($m_report=$db->fetch_array($query_report)) {
						if ($del_i>=($sum_report_num-2)) break;
						//删除以前所有报表;
						$db->query("delete from report where u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."' and id='".$m_report['id']."';");
						$del_i++;
					}					
				}
				//判断过了几天;
				$last_days=(int)(($nowtimes-$list_last_times['dates'])/(24*60*60));
				if ($last_days<1) $last_days=1;
				//echo $last_days;
				for ($i=1;$i<=$last_days;$i++)
				{
					//判断是否有粮食；
					if ($rices_all<($all_soldier*$soldier_eat_rice)) {
						//计算一天死多少士兵；
						$dear_soldier_num=(int)($rices_all/$soldier_eat_rice);
						$dear_ls_soldier_num=$dear_soldier_num;//死亡总兵数;临时；
						foreach ($soldier_type_name_en as $si=>$smi)
						{
							//死亡总兵数是否为0
							if ($dear_ls_soldier_num) {	
								//当前城市此兵种是否有兵;$city_ls_all_soldier临时兵种兵数存储;
								if ($city_ls_all_soldier[$si]>0) {
									if ($city_ls_all_soldier[$si]<$dear_ls_soldier_num) {
										$dear_last_soldier[$si]=0;
										$dear_ls_soldier_num-=$city_ls_all_soldier[$si];
									}else {
										$dear_last_soldier[$si]=$city_ls_all_soldier[$si]-$dear_ls_soldier_num;
										$dear_ls_soldier_num=0;
									}
								}else {
									$dear_last_soldier[$si]=0;
								}
							}else {
								$dear_last_soldier[$si]=0;
							}
							//更新士兵
							$db->query("update soldier set ".$soldier_type_name_en[$si]."='".$dear_last_soldier[$si]."' where u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."';");
						}
						//统计死亡后死兵数；
						$dear_end_soldier=0;
						foreach ($soldier_type_name_en as $si=>$smi)
						{
							$dear_end_city_soldier+=$dear_last_soldier[$si];//当前城市兵数;
						}
						$dear_end_soldier=$all_city_soldier_num-$dear_end_soldier;//死亡士兵数；
					}	
					if ($i==$last_days) {
						$ls_eat_rices=$all_soldier*$soldier_eat_rice;		
					}		
					if ($rices_all<($all_soldier*$soldier_eat_rice)) {
						//扣除粮食；
						$db->query("update resource set rices=0 where u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."';");
					}else {				
						//扣除粮食；
						$db->query("update resource set rices=(rices-'".$ls_eat_rices."') where  u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."';");
					}
				}		
				//echo date("Y-m-d H:i:s",$nowtimes);
				//写入报表
			   $db->query("insert into report(`id`,`u_id`,`c_id`,`type`,`r_date`,`r_beizhu`) values('','".$list_last_times['u_id']."','".$list_last_times['c_id']."','10','".$nowtimes."','".($ls_eat_rices."|".$dear_end_soldier)."')");
			   //更新粮食消耗表
			   $newtimes=$list_last_times['dates']+24*60*60*$last_days;
			   $db->query("update eat_rices set dates='".$newtimes."' where u_id='".$list_last_times['u_id']."' and c_id='".$list_last_times['c_id']."';");
			   if ($list_last_times['u_id']==$_COOKIE['UserId'] && $list_last_times['c_id']==$_COOKIE['CityId'])   refresh();
			}
	}
}
//	echo $i."|".$last_days.'|'.$ls_eat_rices."|".date("Y-m-d H:i:s",$nowtimes)."|".date("Y-m-d H:i:s",$list_last_times['dates']);

?>