safe_goods_processing.php

Download you own three BR

<?php
///////////////////////
//取消自己物品出售;
///////////////////////
if ($_POST['form_ac']=='cancer') {
	if (isset($_POST['lin_ac'])) {
	 $all_cancer_num=count($_POST['box']);
	 for ($i=0;$i<$all_cancer_num;$i++)
	{
		//根据id查询玩家拍卖表记录;
		$query_player_safe=$db->query("select * from player_lin where id='".$_POST['box'][$i]."';");
		$player_safe_list=$db->fetch_array($query_player_safe);
		$player_safe_num=$db->num_rows($query_player_safe);		
		if ($player_safe_num<1) {
			echomsg("该商品己被购买！","?");
		}
		//查找对应物品基础表的信息;
		$query_m_goods=$db->query("select b.* from player_lin a left join m_goods b on (a.mg_id=b.id) where a.id='".$_POST['box'][$i]."';");
		$m_goods_list=$db->fetch_array($query_m_goods);
		//写入内政物品表;
			$query_nzh=$db->query("select id ,num from interior_goods where i_goodsname='".$player_safe_list['s_name']."' 
			 and i_uid='".$_COOKIE['UserId']."'   ");
            $list_bao=$db->fetch_array($query_nzh);
            $i_bao=$list_bao['id'];
            $n_bao=$list_bao['num'];
           if ($i_bao!=''&&$_GET['goods_type_num']==3) {
     	  	$n_bao=$n_bao+1;
            $db->query("update interior_goods set num='".$n_bao."' where id='".$i_bao."' ");}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)
		   values (null, '".$_COOKIE['UserId']."', '".$player_safe_list['mg_id']."', '".$m_goods_list['s_sort']."', '".$player_safe_list['s_type']."', '".$player_safe_list['s_name']."', '".$player_safe_list['s_effect']."', '2', '".$player_safe_list['s_level']."', '".$m_goods_list['s_type']."');");
            }
		//删除拍卖列表记录;
		$db->query("delete from player_lin where id='".$_POST['box'][$i]."';");	
	}
	echomsg("操作成功!","?type=will");
	}else{
	$all_cancer_num=count($_POST['box']);
	for ($i=0;$i<$all_cancer_num;$i++)
	{
		//根据id查询玩家拍卖表记录;
		$query_player_safe=$db->query("select * from player_safe where id='".$_POST['box'][$i]."';");
		$player_safe_list=$db->fetch_array($query_player_safe);
		$player_safe_num=$db->num_rows($query_player_safe);		
		if ($player_safe_num<1) {
			echomsg("该商品己被购买！","?");
		}
		//查找对应物品基础表的信息;
		$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='".$_POST['box'][$i]."';");
		$m_goods_list=$db->fetch_array($query_m_goods);
		//写入内政物品表;
			$query_nzh=$db->query("select id ,num from interior_goods where i_goodsname='".$player_safe_list['s_name']."' 
			 and i_uid='".$_COOKIE['UserId']."'   ");
            $list_bao=$db->fetch_array($query_nzh);
            $i_bao=$list_bao['id'];
            $n_bao=$list_bao['num'];
           if ($i_bao!=''&&$_GET['goods_type_num']==3) {
     	  	$n_bao=$n_bao+1;
            $db->query("update interior_goods set num='".$n_bao."' where id='".$i_bao."' ");}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)
		   values (null, '".$_COOKIE['UserId']."', '".$player_safe_list['mg_id']."', '".$m_goods_list['s_sort']."', '".$player_safe_list['s_type']."', '".$player_safe_list['s_name']."', '".$player_safe_list['s_effect']."', '2', '".$player_safe_list['s_level']."', '".$m_goods_list['s_type']."');");
            }
		//删除拍卖列表记录;
		$db->query("delete from player_safe where id='".$_POST['box'][$i]."';");
		echomsg("操作成功!","?");
	}
	}
	
}


///////////////////////
//是否提交出售自己物品;
///////////////////////
if ($_POST['action']=='my_goods_safe') {
	//查询用户所有拍卖数
	$query_all_safe_num=$db->query("select id  from player_safe where u_id='".$_COOKIE['UserId']."';");	
	$num_safe_all=$db->num_rows($query_all_safe_num);
	$query_all_safe_num2=$db->query("select id  from player_lin where u_id='".$_COOKIE['UserId']."';");	
	$num_safe_all2=$db->num_rows($query_all_safe_num2);
	$num_safe_all=$num_safe_all+$num_safe_all2;
	if ($num_safe_all>20) echomsg("你的拍卖达到上限,最大上限为20!");
	
	if (!ereg("^[0-9]*$",$_POST['golds'])) {
		echomsg("请输入数字！","?");
	}
	$_POST['golds']=(int)($_POST['golds']);
	if ($_POST['golds']<1) {
		echomsg("价格最少为1!");
	}
	if ($_POST['id']<1) {
			echomsg("请选择物品！");
		}	
		
		if ($_POST['safe_num']==1) {//黄金
		//查询玩家的黄金个数；
		$query_golds_num=$db->query("select golds from resource where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
		$golds_num_list=$db->fetch_array($query_golds_num);
		//扣10%的税;
		$ko_golds=(int)($_POST['golds']*0.1);
		if ($golds_num_list['golds']<$ko_golds) {
			echomsg("没有足够的黄金来付保管费,您所需的保管费为".$ko_golds."黄金");
		}
		//扣除黄金;
		$db->query("update resource set golds=(golds-'".$ko_golds."') where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
	}else {
		//元宝
		//查询玩家的黄金个数；
		$query_golds_num=$db->query("select cashmoney from player_info where u_id='".$_COOKIE['UserId']."';");
		$golds_num_list=$db->fetch_array($query_golds_num);
		if ($_POST['golds']<10) {
			if ($golds_num_list['cashmoney']<1) {
				echomsg("没有足够的元宝来付保管费,您所需的保管费为1个元宝");
			}
		}else {
			//扣10%的元宝;
			$ko_cashmoney=(int)($_POST['golds']*0.1);
			if ($golds_num_list['cashmoney']<$ko_cashmoney) {
				echomsg("没有足够的元宝来付保管费,您所需的保管费为".$ko_cashmoney."个元宝");
			}
		}
		//扣除元宝;
		$db->query("update player_info set cashmoney=(cashmoney-'".$ko_cashmoney."') where u_id='".$_COOKIE['UserId']."' ;");
	}
	refresh();
	//根据提交的id查找内政表的数据;
	$query_in=$db->query("select * from interior_goods where id='".$_POST['id']."';");
	$i_id=$_POST['id'];
	$m=$db->fetch_array($query_in);
	$i_s_id=$m['s_id'];
	$m_query=$db->query("select s_price from m_goods where id='".$i_s_id."' ");
    $m_list=$db->fetch_array($m_query);		
    $g_jiben_value=$m_list['s_price'];
    $g_jiben_max_value=$g_jiben_value*5;	
    	
	if($g_jiben_value> $_POST['golds']||$g_jiben_max_value<$_POST['golds']){	            	
		echomsg("价格范围在".$g_jiben_value."-".$g_jiben_max_value);
	}	
	
	if ($m['i_style_num']==9) echomsg("宝物不可出售!","?");
	if ($m['i_level']>1) echomsg("此级别物品不能出售!","?");
//	if ($m['i_style_num']==8) echomsg("道具类不可出售!","?");
	
	if ($m['i_style_num']<>8) {
		$s_style=2;        //拍卖种类为装备；
	}else{ 
		$s_style=3;
	}
	
	if( $m['s_type']=='3' ){
		echomsg('此装备不能参与买卖','?');	
	}else{	
	
	//写入player_safe玩家拍卖表；
	$end_times=time()+60*60;   //最后时间；
$db->query("insert into player_lin ( u_id, c_id, mg_id, s_style, s_type, golds_style, s_name, s_golds, s_effect, s_num, s_level, l_start_times) values 
('".$_COOKIE['UserId']."', '".$_COOKIE['CityId']."','".$m['s_id']."', '".$s_style."', '".$m['i_style_num']."', '".$_POST['safe_num']."' ,'".$m['i_goodsname']."', '".$_POST['golds']."', '".$m['i_effect']."','1', '".$m['i_level']."', '".$end_times."');");
	//删除原内政物品表的记录；
$query_nzh=$db->query("select id ,num from interior_goods where id='".$_POST['id']."'  ");
            $list_bao=$db->fetch_array($query_nzh);
             $n_bao=$list_bao['num'];
           if($n_bao==0||$n_bao==1){
	$db->query("delete from interior_goods where id='".$_POST['id']."';");	}else {
		$db->query("update interior_goods set num=(num-1)  where id='".$_POST['id']."' ");
	}
	echomsg('拍卖成功,物品将在一个小时后上架！','?');}

}
?>