system_task_processing.php

Download you own three BR

<?php
//把基础任务所需完成的等级条件写入数组；
$query=$db->query("select user_grade from m_system_task;");
$i=1;
while ($lish=$db->fetch_array($query)) {
	$end_grade[$i]=$lish['user_grade'];
	$i++;
}
//设定完成任务的条件；
$taskend=array(1=>1,           //“民居”等级达到1级；
               2=>1,           //“伐木场”金矿”“农田”“采矿场”等级达到1级;
               3=>1,           //"督造司"等级达到1级；
               4=>100,         //训练士兵100人;
               5=>1,           //武将有1人;
               6=>1,           //任意研究达到1级;
               7=>1,           //“城墙”达到1级; 
               8=>1,           //“仓库”等级达到1级;   
               9=>1,           //获得敌方军情，侦察战要胜利
               10=>1,          //掠夺战，掠夺战要胜利
               11=>50,         //扑刀手50人；
               12=>2,          //城市两座
               13=>1,          //加入联盟或是创建联盟
               14=>1           //参于或发起一次联合进攻，并胜利                        
         	   );
//查询当前玩家相关信息,写和数组;
$query=$db->query("select  sum(c_officers) as c_officers , sum(c_soldiers) as c_soldiers , sum(city_wall) as city_wall from city where u_id='".$_COOKIE['UserId']."';");
$city_list=$db->fetch_array($query);
$gen_num=$city_list['c_officers'];   									//武将数量;

//查询城市
$soldiers=0;
$city_i=1;
$pd_shou=0;
$query_city=$db->query("select * from city where u_id='".$_COOKIE['UserId']."';");
$city_i=$db->num_rows($query_city);
while ($list_city=$db->fetch_array($query_city)) {
	//查询当前玩家当前城市有多少数兵；
	$query=$db->query("select * from soldier where u_id='".$_COOKIE['UserId']."' and c_id='".$list_city['c_id']."';");
	$soldier_result=$db->fetch_array($query);
	for($li=0;$li<count($soldier_type_name);$li++){
		$soldiers += $soldier_result[$soldier_type_name_en[$li]];
	}
	
	//查询有多少扑刀手
	$query=$db->query("select pd_shou from soldier where u_id='".$_COOKIE['UserId']."' and c_id='".$list_city['c_id']."';");
	$list=$db->fetch_array($query);
	$pd_shou+=$list['pd_shou'];
	
}

							


$query=$db->query("select sum(b_house) as house , sum(b_cutting) as cutting , sum(b_gold_ore) as gold , sum(b_farm) as farm , sum(b_iron_ore) as iron , sum(b_store) as store , sum(b_city_wall) as city_wall, sum(officer_house) as officer_house from building where u_id='".$_COOKIE['UserId']."';");
$build_list=$db->fetch_array($query);
$house=$build_list['house'];          //民居数量;
$cutting=$build_list['cutting'];      //伐木场数量;
$gold=$build_list['gold'];            //金矿数量;
$farm=$build_list['farm'];            //农田数量;
$iron=$build_list['iron'];            //采矿场数量;
$store=$build_list['store'];          //仓库等级;
$city_wall=$build_list['city_wall'];  //城墙等级;
$officer_house=$build_list['officer_house'];//督造司等级
if ($gold>=1 && $farm>=1 && $iron>=1 && $cutting>=1) {
	$reso=1;
}

$query=$db->query("select * from study where u_id = '".$_COOKIE['UserId']."';");
$study_list=$db->fetch_array($query);
$study=$study_list['s_smelt'];        //治炼煅造技术等级

//侦察战报
$query=$db->query("select count(w_id) as num  from war_result where u_id='".$_COOKIE['UserId']."' and w_type='3' and w_flag='1'");
$list=$db->fetch_array($query);
$aram_type2=$list['num'];           //侦察战是否胜利

//掠夺战报
$query=$db->query("select count(w_id) as num  from war_result where u_id='".$_COOKIE['UserId']."' and w_type='0' and w_flag='1'");
$list=$db->fetch_array($query);
$aram_type=$list['num'];           //掠夺战是否胜利

//查寻玩家是否加入或是创建联盟
$query=$db->query("select union_id from player_info where u_id='".$_COOKIE['UserId']."';");
$list=$db->fetch_array($query);
$union_it=$list['union_id'];

//参于或是发起联合进攻
$query=$db->query("select count(w_id) as num  from war_result where u_id='".$_COOKIE['UserId']."' and w_type='6' and w_flag='1'");
$list=$db->fetch_array($query);
$aram_type6=$list['num'];           //联合进攻


//把基础数据写入数组;
$base=array(1=>$house,              //“民居”等级达到1级；                       
            2=>$reso,               //“伐木场”金矿”“农田”“采矿场”等级达到1级;
            3=>$officer_house,      //"督造司"等级达到1级；                       
            4=>$soldiers,           //训练士兵100人;                             
            5=>$gen_num,            //武将有1人;                                 
            6=>$study,              //任意研究达到1级;                           
            7=>$city_wall,          //“城墙”达到1级;                           
            8=>$store,              //“仓库”等级达到1级; 
            9=>$aram_type2,         //获得敌方军情，侦察战要胜利
            10=>$aram_type,         //掠夺战胜利
            11=>$pd_shou,           //扑刀手50人
            12=>$city_i,            //城市两座
            13=>$union_it,          //创建或是加入联盟
            14=>$aram_type6         //参于或是加入联合进攻并胜利                        
         	);

//////////////////////////////////////////////////////////////////判断用户是否满足条件////////////////////////////////////////
if ($_GET['act']=='task_end')
{
	//判断是否完成了;
	if ($taskend[$_GET['id']]<=$base[$_GET['id']] && $user_grade>=$end_grade[$_GET['id']]) {
		//查询玩家是否己完成了此项任务;
		$query=$db->query("select * from task_end where u_id='".$_COOKIE['UserId']."' and p_in='0' and m_task_id ='".$_GET['id']."';");
		$num=$db->num_rows($query);
		
		if (!$num) {
			//查询将励物品;
			$query=$db->query("select * from m_system_task where id='".$_GET['id']."';");
			$tasks_list=$db->fetch_array($query);
//			echo $tasks_list['task_result'];

			//查询用户主城CID;
			$query_city_ma=$db->query("select c_id from city where u_id='".$_COOKIE['UserId']."' and c_type='1';");
			$list_city_ma=$db->fetch_array($query_city_ma);
			$ma_city=$list_city_ma['c_id'];
			//更新用户数据
			$db->query("update resource set woods=(woods+'".$tasks_list['task_woods']."') , rices=(rices+'".$tasks_list['task_rice']."') , ores=(ores+'".$tasks_list['task_ores']."') , golds=(golds+'".$tasks_list['task_golds']."') , free_stores=(free_stores+'".$tasks_list['task_woods']."'+'".$tasks_list['task_rice']."'+'".$tasks_list['task_ores']."'+'".$tasks_list['task_golds']."') where u_id='".$_COOKIE['UserId']."' and c_id='".$ma_city."';");
			$db->query("update player_info set p_score=(p_score+'".$tasks_list['task_score']."') where u_id='".$_COOKIE['UserId']."';");
			//写入奖励信息;
			$db->query("insert into e_mail (id,e_name,e_username,e_title,e_text,e_times,e_read,e_type) values (null,'系统信息','".$_COOKIE['NickName']."','完成任务奖励','".'完成:'.$tasks_list['task_result'].'<br>奖励：'.$tasks_list['task_ech']."','".time()."','0','1')");
			//更新任务完成信息;
			$db->query("update task_end set p_in='0' where u_id='".$_COOKIE['UserId']."' and m_task_id='".$_GET['id']."';");
			refresh();
			echomsg("完成".$tasks_list['task_name']."任务！","system_task.php?action=untask");
		}else {
			echomsg("完成任务！","system_task.php?action=untask");
		}
	}else {
		echomsg("任务条件未达到，请继续努力！","system_task.php?action=untask");
	}
}

////////////////////
//接受任务
////////////////////
if ($_GET['action']=='task_up') {
	$db->query("insert into task_end (id,u_id,m_task_id,date,p_in) values (null,'".$_COOKIE['UserId']."','".$_GET['id']."','".time()."','1')");
	$qu=$db->query("select task_name from m_system_task where id='".$_GET['id']."';");
	$li=$db->fetch_array($qu);
	echomsg("己接受".$li['task_name']."任务","system_task.php?action=untask");
}
?>