soldier_processing_task.php

Download you own three BR

<?php
$query=$db->query("select * from soldier_task where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' order by id limit 1");
$repair_soldier=$db->fetch_array($query);	
 if($repair_soldier['s_num']=='0'){
    $query=$db->query("select * from soldier_task where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' order by id limit 1,1");
					$second_result=$db->fetch_array($query);
					$query=$db->query("update soldier_task set `s_start_time`='".time()."',`s_end_time`='".(time()+$second_result['s_time'])."' where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' and `id`= '".$second_result['id']."' ");
				$db->query("delete from soldier_task where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' and `id`='".$repair_soldier['id']."'");
    }
	/////////////////////////////////////////玩家触发自动处理士兵训练队列////////////////////////////////////////
	$query=$db->query("select * from soldier_task where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' and `s_end_time`<='".time()."' and `s_end_time`<>'' and `s_end_time`<>'0'");
	$task_result=$db->num_rows($query);
	while($row=$db->fetch_array($query)){
		
		//读取任务队列表中的第一个任务
		$query=$db->query("select * from soldier_task where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' order by id limit 1");
		$row=$db->fetch_array($query);
        //echo $row['id'];exit;
		//先判断士兵训练任务是否完成
		if($row['s_end_time']<=time() and $row['s_end_time'] and $row['s_sort']==0){//完成
			///////////////////////////////////////z////////////////////////
           $db->query("update soldier_task set `s_sort`='1' where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' and id='".$row['id']."'");
			
			//判断是否训练过兵
			$query=$db->query("select s_id from soldier where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
			$soldier_result=$db->num_rows($query);
			
			//更新士兵训练的数量
			if($soldier_result){
			   $db->query("update soldier set `".$soldier_type_name_en[$row['s_type']]."`=(`".$soldier_type_name_en[$row['s_type']]."`+'".$row['s_num']."') where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' ");
			}else{
			   $insert_info=$db->query("insert into soldier(`s_id`,`u_id`,`c_id`) values('','".$_COOKIE['UserId']."','".$_COOKIE['CityId']."')");
			   if($insert_info) $db->query("update soldier set `".$soldier_type_name_en[$row['s_type']]."`=(`".$soldier_type_name_en[$row['s_type']]."`+'".$row['s_num']."') where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' ");
			}
			//增加经验
			$score = $row['s_num'] * $soldier_score[$row['s_type']];
			$db->query("update player_info set `p_score`=(`p_score`+'".(int)$score."') where `u_id`='".$_COOKIE['UserId']."' ");
	        
			//取消武将工作状态
			if($row['gen_id']) $db->query("update gen set `g_status` = '0' where `g_uid`='".$_COOKIE['UserId']."' and `g_cid`='".$_COOKIE['CityId']."' and `g_gid`= '".$row['gen_id']."';");

			$s_end_time_temp=$row['s_end_time'];
				if($task_result>1){
					//更新第二个任务的结束时间
					$query=$db->query("select * from soldier_task where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' order by id limit 1,1");
					$second_result=$db->fetch_array($query);
					$query=$db->query("update soldier_task set `s_start_time`='".$s_end_time_temp."',`s_end_time`='".($s_end_time_temp+$second_result['s_time'])."' where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' and `id`= '".$second_result['id']."' ");
				}
			
			
				//删除已完成的任务
				$db->query("delete from soldier_task where `id`='".$row['id']."'");
				//update_resource();
				refresh();
				///////////////////////////////////////////////////////////////////////////////////////////////		
		}
	}