safe_market_processing.php

Download you own three BR

<?php
if ($_GET['action']=='purchasing') {
    //购买物品查询;
	$query_buy=$db->query("select * from player_safe where id='".$_GET['id']."';");
	$list_buy=$db->fetch_array($query_buy);
	$list_buy_num=$db->num_rows($query_buy);
	//########//
	if ($list_buy_num==0) {
		echomsg("此商品被别人抢购了!","?ac_type=".$_GET['ac_type']);
	}
	//########//
	if ($_COOKIE['UserId']==$list_buy['u_id']) {
		echomsg("不能购买自己出售的商品!","?ac_type=".$_GET['ac_type']);
	}
	//########//
	if ($list_buy['golds_style']==1) {
		//玩家钱数
   		$query_lin=$db->query("select golds from resource where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
   		$list_lin=$db->fetch_array($query_lin);
   		$golds=$list_lin['golds'];//黄金
		if ($golds<$list_buy['s_golds']) {
			echomsg("黄金不够,不能购买!","?ac_type=".$_GET['ac_type']);
		}
	}elseif ($list_buy['golds_style']==2) {
		$query_lin=$db->query("select cashmoney from player_info where u_id='".$_COOKIE['UserId']."';");	
	    $list_lin=$db->fetch_array($query_lin);
   		$cashmoney=$list_lin['cashmoney'];
		if ($cashmoney<$list_buy['s_golds']) {
			echomsg("元宝不够,不能购买!","?ac_type=".$_GET['ac_type']);
		}
	}
	//########//
	if ($list_buy['s_style']==1) {//士兵
		
		$current_city_soldier_num=0;
		//判断目标城池是否建造了军营
  		$query = $db->query("select b_barracks from building where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
  		$barracks_grade = $db->fetch_array($query);
  		if(!$barracks_grade['b_barracks']) echomsg("城池还没有建造军营！","?ac_type=".$_GET['ac_type']);
  		
  		
		//当前城池士兵数/////////
		$query=$db->query("select * from soldier where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
		$current_city_soldier = $db->fetch_array($query);
		if($soldier_type_name_en) foreach ($soldier_type_name_en as $si=>$sm){
		    if(!$current_city_soldier[$sm]) continue; 
			$current_city_soldier_num += $current_city_soldier[$sm];
		}
		//当前城市拍卖等待上架士兵数统计
		$query_safe_ls_soldier=$db->query("select sum(s_num) as soldier_num from player_lin where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."' and s_style='1';");
		$list_safe_ls_soldier=$db->fetch_array($query_safe_ls_soldier);
		$current_city_soldier_num+=$list_safe_ls_soldier['soldier_num'];
		
		//当前城市拍卖巳上架士兵数统计
		$query_safe_soldier=$db->query("select sum(s_num) as soldier_num from player_safe where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."' and s_style='1';");
		$list_safe_soldier=$db->fetch_array($query_safe_soldier);
		$current_city_soldier_num+=$list_safe_soldier['soldier_num'];
		
		//当前出征士兵数
		$query_war_soldier=$db->query("select * from war_task where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
		while ($list_war_soldier=$db->fetch_array($query_war_soldier)){
			$soldier_n_a=explode("|",$list_war_soldier['w_soldier_num']);
			$count_n=count($soldier_n_a);
			for ($i=0;$i<$count_n;$i++){
				$current_city_soldier_num+=$count_n[$i];
			}
		}
		
		//当前要运到目标城池的士兵数
		$query_war_soldier=$db->query("select * from war_task where w_type='2' and to_u_id='".$_COOKIE['UserId']."' and to_c_id='".$_COOKIE['CityId']."';");
		while ($list_war_soldier=$db->fetch_array($query_war_soldier)){
			$soldier_n_a=explode("|",$list_war_soldier['w_soldier_num']);
			$count_n=count($soldier_n_a);
			for ($i=0;$i<$count_n;$i++){
				$current_city_soldier_num+=$count_n[$i];
			}
		}
		
		//当前目标城池训练士兵数
		$query_soldier_task=$db->query("select sum(s_num) as soall from soldier_task where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
		$list_soldier_task=$db->fetch_array($query_soldier_task);
		$current_city_soldier_num+=$list_soldier_task['soall'];
		
		$current_city_soldier_num+=$list_buy['s_num'];
		
		$aim_city_soldier_all=$barracks_grade['b_barracks']*500;
		if ($current_city_soldier_num>$aim_city_soldier_all) echomsg("士兵数超过城池兵营上限！","?ac_type=".$_GET['ac_type']);
  		
				
		//人口
		$query=$db->query("select total_house  from resource where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
		$init_data = $db->fetch_array($query);
		//己占用人口
		$query=$db->query("select sum(true_workers) as true_workers from resource_grow where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
		$produce_result = $db->fetch_array($query);
		//士兵每5个算一个人口
		$person_soldier=ceil($current_city_soldier_num/5);
		//总人口
		$current_workers = $init_data['total_house']-$person_soldier-$produce_result['true_workers'];
		if ($current_workers<1) echomsg("超过人口上限！","?ac_type=".$_GET['ac_type']);
		
		//判断是否训练过兵
		$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[$list_buy['s_type']]."=(".$soldier_type_name_en[$list_buy['s_type']]."+'".$list_buy['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[$list_buy['s_type']]."=(".$soldier_type_name_en[$list_buy['s_type']]."+'".$list_buy['s_num']."') where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
  		}
  		
		//扣钱;
		if ($list_buy['golds_style']==1) {
			$db->query("update resource set golds=(golds-'".$list_buy['s_golds']."') where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
		    $db->query("update resource set golds=(golds+'".$list_buy['s_golds']."') where u_id='".$list_buy['u_id']."' and c_id='".$list_buy['c_id']."';");
		}elseif ($list_buy['golds_style']==2) {
			$db->query("update player_info set cashmoney=(cashmoney-'".$list_buy['s_golds']."') where u_id='".$_COOKIE['UserId']."' ;");
			$db->query("update player_info set cashmoney=(cashmoney+'".$list_buy['s_golds']."') where u_id='".$list_buy['u_id']."' ;");
		}
		
		refresh();		
		//删除拍卖表记录
		$db->query("delete from player_safe where id='".$list_buy['id']."';");
		echomsg("购买成功!","?ac_type=".$_GET['ac_type']);
  		
	
	}elseif ($list_buy['s_style']==2  ) {//装备
		//查找对应物品基础表的信息;
		$query_m_goods=$db->query("select b.* from player_safe a left join m_goods b on (a.mg_id=b.id) where a.id='".$_GET['id']."';");
		$m_goods_list=$db->fetch_array($query_m_goods);	
		if ($m_goods_list['s_sort']=='兵书'||$m_goods_list['s_sort']=='经书') {
				$m_goods_list['s_sort']='书藉';//把兵书，经书，医书，奇书，统一定为书藉类型；
		}
		//写入内政物品表;
		$db->query("insert into interior_goods (id, i_uid, s_id, i_style, i_style_num, i_goodsname, i_effect, i_state, i_level, s_type,num) values (null, '".$_COOKIE['UserId']."', '".$list_buy['mg_id']."', '".$m_goods_list['s_sort']."', '".$list_buy['s_type']."', '".$list_buy['s_name']."', '".$m_goods_list['s_effect']."', '2', '".$list_buy['s_level']."', '".$m_goods_list['s_type']."','1');");
		//扣钱;
		if ($list_buy['golds_style']==1) {
			$db->query("update resource set golds=(golds-'".$list_buy['s_golds']."') where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
		    $db->query("update resource set golds=(golds+'".$list_buy['s_golds']."') where u_id='".$list_buy['u_id']."' and c_id='".$list_buy['c_id']."';");
		}elseif ($list_buy['golds_style']==2) {
			$db->query("update player_info set cashmoney=(cashmoney-'".$list_buy['s_golds']."') where u_id='".$_COOKIE['UserId']."' ;");
			$db->query("update player_info set cashmoney=(cashmoney+'".$list_buy['s_golds']."') where u_id='".$list_buy['u_id']."' ;");
		}
		
	}elseif($list_buy['s_style']==3){ //道具物品
        //查找对应物品基础表的信息;
		$query_m_goods=$db->query("select b.* from player_safe a left join m_goods b on (a.mg_id=b.id) where a.id='".$_GET['id']."';");
		$m_goods_list=$db->fetch_array($query_m_goods);	
                
		//写入内政物品表;
        $query_ty3=$db->query("select * from interior_goods where i_uid='".$_COOKIE['UserId']."' and s_id='".$list_buy['mg_id']."' ");
        $list_ty3=$db->fetch_array($query_ty3);
        $id_ty3=$list_ty3['id'];
        $num_have=$db->num_rows($query_ty3);
        if($num_have){
            $db->query("update interior_goods set num=(num+'1') where i_uid='".$_COOKIE['UserId']."' and s_id='".$list_buy['mg_id']."';"); 
        }else{
			$db->query("insert into interior_goods (id, i_uid, s_id, i_style, i_style_num, i_goodsname, i_effect, i_state, i_level, s_type,num) values (null, '".$_COOKIE['UserId']."', '".$list_buy['mg_id']."', '".$m_goods_list['s_sort']."', '".$list_buy['s_type']."', '".$list_buy['s_name']."', '".$m_goods_list['s_effect']."', '2', '".$list_buy['s_level']."', '".$m_goods_list['s_type']."','1');");
		}
		//扣钱;
		if ($list_buy['golds_style']==1) {
			$db->query("update resource set golds=(golds-'".$list_buy['s_golds']."') where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
		    $db->query("update resource set golds=(golds+'".$list_buy['s_golds']."') where u_id='".$list_buy['u_id']."' and c_id='".$list_buy['c_id']."';");
		}elseif ($list_buy['golds_style']==2) {
			$db->query("update player_info set cashmoney=(cashmoney-'".$list_buy['s_golds']."') where u_id='".$_COOKIE['UserId']."' ;");
			$db->query("update player_info set cashmoney=(cashmoney+'".$list_buy['s_golds']."') where u_id='".$list_buy['u_id']."' ;");
		}
		
	}
	refresh();
	//删除拍卖列表记录;
	$db->query("delete from player_safe where id='".$_GET['id']."';");
	echomsg("购买成功!","?ac_type=".$_GET['ac_type']);
}
?>