resource_goods_over.php

Download you own three BR

<?php
//使用资源增加道具到时间的处理
$query_resour_over=$db->query("select * from add_goods_info where type='1' and stop_times<='".time()."' order by id asc;");
while ($m_resour_over=$db->fetch_array($query_resour_over)) {
	if ($m_resour_over['stop_times']<=time()) {
		//获取玩家每项建筑物的生产时间：resource_grow
		$query=$db->query("select * from resource_grow where `u_id`='".$m_resour_over['u_id']."' and `c_id`='".$m_resour_over['c_id']."'");
		while($row=$db->fetch_array($query)) $resource_grow_list[]=$row;
		//开始按照生产安排进行资源增长
		$nowtime  =time();
		if($resource_grow_list) foreach ($resource_grow_list as $i=>$grow){//循环执行资源计算//////////////////////////////
					 
		     if(!$grow['total_grow']) continue;
			  	  //echo "ok";
			  	  //生产建筑物等级
				  $query=$db->query("select * from building where `u_id`='".$m_resour_over['u_id']."' and `c_id`='".$m_resour_over['c_id']."'");
			      $b_num=$db->fetch_array($query);
			      //基础数据
			      $query=$db->query("select * from building_attribute where `b_type`='".$grow['b_type']."'");
			      $b_base_result=$db->fetch_array($query);
			      //城池信息
				  $query=$db->query("select * from resource where `u_id`='".$m_resour_over['u_id']."' and `c_id`='".$m_resour_over['c_id']."'");
				  $building_result=$db->fetch_array($query);
				  //读取研究技术等级表
			      $query=$db->query("select s_cutting,s_mining,s_golds,s_flooding from study where `u_id`='".$m_resour_over['u_id']."' ");
				  $study_result=$db->fetch_array($query);
				  //城市类型
				  $query = $db->query("select `c_land_type` from `city` where `u_id`='".$m_resour_over['u_id']."' and `c_id`='".$m_resour_over['c_id']."'");
				  $land_type =$db->fetch_array($query);
			  	
			  	  //生产时间>=1小时
			  	  //$growtime = (time()-$grow['last_grow_time'])/$produce_time;
			  	  $grow_time = (time()-$grow['last_grow_time']);
			  	  $grow_num  =  $b_num[$b_type_name_en[$grow['b_type']]];
			  	  $grade  = $grow_num;//建筑物的等级
			  	  $grow_time = ($grade>0) ? $grow_time : 0;
			  	  $b_base  = $grow['total_grow'];
			  	  $b_base = ($b_base) ? $b_base :1;
			  	  if($grow['total_grow']) $produce_temp = 3600 / $grow['total_grow'];		  	  
			  	  //条件满足
			  	  if($grow['last_grow_time'] and $grow['total_grow'] and $grow['worker_percent'] and $produce_temp){
			  	  	  $report_time=time();
				  	  $update_resource[$grow['b_type']]=  $grow_time/$produce_temp;
					  switch($land_type['c_land_type']){
						case 1:{
							     	$update_resource[$grow['b_type']] += $update_resource[$grow['b_type']] * 0.02;
							     	break;
							    }
						case 2:{
							     	if($grow['b_type']=="4"){
							     	 	$update_resource[$grow['b_type']] += $update_resource[$grow['b_type']] * 0.06;
							     	}
							     	break;
							    }
						case 3:{
							     	if($grow['b_type']=="1"){
							     	  	$update_resource[$grow['b_type']] += $update_resource[$grow['b_type']] * 0.06;
							    	 }
							     	 break;
							    }
						 case 4:{
							      	if($grow['b_type']=="2"){
							     		 $update_resource[$grow['b_type']] += $update_resource[$grow['b_type']] * 0.06;
							     	 }
							     	 break;
							     }
						 case 5:{
							     	 if($grow['b_type']=="3"){
							     		 $update_resource[$grow['b_type']] += $update_resource[$grow['b_type']] * 0.06;
							     	 }
							     	 break;
							     }
							     	
						 }
						 $update_resource[$grow['b_type']] = round($update_resource[$grow['b_type']] * $resource_percent,0);
				  	  	     
						//结束计算产量/////////////////////////////
						//更新资源最后结算时间、总生产时间
						//$last_grow_time=$nowtime;
						//$total_grow_time=$grow_time;
						//$update_resource[$grow['b_type']] = ceil($update_resource[$grow['b_type']]);
							   
		                if($update_resource[$grow['b_type']]){
							$db->query("update resource_grow set `last_grow_time`='".$nowtime."' where `u_id`='".$m_resour_over['u_id']."' and `c_id`='".$m_resour_over['c_id']."' and `b_type`='".$grow['b_type']."'");
		                }
				  	}
		    }
		    $update_resource1 = $update_resource[1];
			$update_resource2 = $update_resource[2];
			$update_resource3 = $update_resource[3];
			$update_resource4 = $update_resource[4];
			 //---仓库不足，记录到报表日志中
			 if($update_resource1 + $building_result['woods'] > $building_result['woods_uplimit']){
				$update_resource1 = ($building_result['woods_uplimit'] > $building_result['woods']) ? $update_resource1 - ($building_result['woods_uplimit'] - $building_result['woods']) : $update_resource1;
			 }else $update_resource1=0;
			 if($update_resource2 + $building_result['ores'] > $building_result['ores_uplimit']){
				 $update_resource2 = ($building_result['ores_uplimit'] > $building_result['ores']) ? $update_resource2 - ($building_result['ores_uplimit'] - $building_result['ores']) : $update_resource2;
			 }else $update_resource2=0;
			 if($update_resource3 + $building_result['golds'] > $building_result['golds_uplimit']){
				 $update_resource3 = ($building_result['golds_uplimit'] > $building_result['golds']) ? $update_resource3 - ($building_result['golds_uplimit'] - $building_result['golds']) : $update_resource3;
			 }else $update_resource3=0;
			 if($update_resource4 + $building_result['rices'] > $building_result['irces_uplimit'] ){//木材
				 $update_resource4 = ($building_result['rices_uplimit'] > $building_result['rices']) ? $update_resource4 - ($building_result['rices_uplimit'] - $building_result['rices']) : $update_resource4;
			 }else $update_resource4=0;
			$update_resource1 = ($update_resource1>0) ? $update_resource1 :0;
			$update_resource2 =($update_resource2>0) ? $update_resource2 :0;
			$update_resource3 =($update_resource3>0) ? $update_resource3 :0;
			$update_resource4 =($update_resource4>0) ? $update_resource4 :0;
			     		
			$update_resource[4] = ($building_result['rices_uplimit'] - $building_result['rices'] > $update_resource[4]) ?  $update_resource[4] : $building_result['irces_uplimit'] - $building_result['rices'];
			$update_resource[1] = ($building_result['woods_uplimit'] - $building_result['woods'] > $update_resource[1]) ?  $update_resource[1] : $building_result['woods_uplimit'] - $building_result['woods'];
			$update_resource[2] = ($building_result['ores_uplimit'] - $building_result['ores'] > $update_resource[2]) ?  $update_resource[2] : $building_result['ores_uplimit'] - $building_result['ores'];
			$update_resource[3] = ($building_result['golds_uplimit'] - $building_result['golds'] > $update_resource[3]) ?  $update_resource[3] : $building_result['golds_uplimit'] - $building_result['golds'];
			     		
			$update_resource[1] = ($update_resource[1]>0) ? $update_resource[1] : 0;
			$update_resource[2] = ($update_resource[2]>0) ? $update_resource[2] : 0;
			$update_resource[3] = ($update_resource[3]>0) ? $update_resource[3] : 0;
			$update_resource[4] = ($update_resource[4]>0) ? $update_resource[4] : 0;
			//更新资源
			$db->query("update resource set `woods`=`woods`+'".(int)$update_resource[1]."',`rices`=`rices`+'".(int)$update_resource[4]."',`ores`=`ores`+'".(int)$update_resource[2]."',`golds`=`golds`+'".(int)$update_resource[3]."' where `u_id`='".$m_resour_over['u_id']."' and `c_id`='".$m_resour_over['c_id']."'");				
			$update_resource[1]=$update_resource[2]=$update_resource[3]=$update_resource[4]=0;
			$update_resource1 = $update_resource[1];
			$update_resource2 = $update_resource[2];
			$update_resource3 = $update_resource[3];
			$update_resource4 = $update_resource[4];
	}
	//扣除使用物口的记录
	$over_golds_add=$m_resour_over['golds_add'];
	$over_rices_add=$m_resour_over['rices_add'];
	$over_woods_add=$m_resour_over['woods_add'];
	$over_ores_add=$m_resour_over['ores_add'];
	$db->query("delete from add_goods_info where id='".$m_resour_over['id']."';");
	$db->query("update resource_grow set total_grow=(total_grow-'".$over_woods_add."') where b_type='1' and u_id='".$m_resour_over['u_id']."' and c_id='".$m_resour_over['c_id']."';");
	$db->query("update resource_grow set total_grow=(total_grow-'".$over_ores_add."') where b_type='2' and u_id='".$m_resour_over['u_id']."' and c_id='".$m_resour_over['c_id']."';");
	$db->query("update resource_grow set total_grow=(total_grow-'".$over_golds_add."') where b_type='3' and u_id='".$m_resour_over['u_id']."' and c_id='".$m_resour_over['c_id']."';");
	$db->query("update resource_grow set total_grow=(total_grow-'".$over_rices_add."') where b_type='4' and u_id='".$m_resour_over['u_id']."' and c_id='".$m_resour_over['c_id']."';");
	$over_golds_add=$over_rices_add=$over_woods_add=$over_ores_add=0;
	if ($m_resour_over['u_id']==$_COOKIE['UserId'] && $m_resour_over['c_id']==$_COOKIE['CityId']) refresh();
}
?>