use_bao.php

Download you own three BR

<?php
//根据物品表查基础表
$query_m_god=$db->query("select * from interior_goods where id='".$id."' and i_uid='".$_COOKIE['UserId']."';");
$list_m_god=$db->fetch_array($query_m_god);
$if_list_num=$db->num_rows($query_m_god);
if ($if_list_num) {
	
	
	//熔炼石
	if ($list_m_god['s_id']=='112') {
		$db->query("update resource set golds=(golds+'300') where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");	
	}
	
	//熔炼石2级
	if ($list_m_god['s_id']=='131') {
		$db->query("update resource set golds=(golds+'3000') where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");	
	}
	
	//扩土神卷
	if ($list_m_god['s_id']=='128') {
		//查询当前城市总面积
		$query_c_size=$db->query("select c_total_size,c_size from city where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
		$list_c_size=$db->fetch_array($query_c_size);
		if ($list_c_size['c_total_size']<200) {
			$city_add_size=rand(200,220);	
			if ($city_add_size>=$list_c_size['c_total_size']) {
					$add_size=$city_add_size-$list_c_size['c_total_size'];
				}else{
					$add_size=0;
				}	
				$db->query("update city set c_total_size='".$city_add_size."',c_size=(c_size+'".$add_size."') where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");	
		}else {
			echomsg("城池总面积小于200的才可以使用！","goods.php?action_type=".$_GET['type_num']);
		}		
	}
	
	//神奇粽子
	if ($list_m_god['s_id']=='149') {
		$ne_god_id=rand(1,100);
		if ($ne_god_id<=15){ 
			$query_mg_ls=$db->query("select * from m_goods where id='150';");
			$m_mg_ls=$db->fetch_array($query_mg_ls);
			
			$query_my_mg=$db->query("select id from interior_goods where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			$sum_my_mg=$db->num_rows($query_my_mg);
			if ($sum_my_mg) {
				$db->query("update interior_goods set num=(num+1) where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			}else {
				$db->query("insert into interior_goods (i_uid,s_id,i_style,i_style_num,i_goodsname,i_effect,i_state,i_level,s_type,num) values ('".$_COOKIE['UserId']."','".$m_mg_ls['id']."','".$m_mg_ls['s_sort']."','".$m_mg_ls['s_stylenum']."','".$m_mg_ls['s_name']."','".$m_mg_ls['s_effect']."','2','".$m_mg_ls['s_level']."','".$m_mg_ls['s_type']."','1');");
			}
		}
		if ($ne_god_id>15 && $ne_god_id<=40){ 
			$query_mg_ls=$db->query("select * from m_goods where id='151';");
			$m_mg_ls=$db->fetch_array($query_mg_ls);
			
			
			$query_my_mg=$db->query("select id from interior_goods where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			$sum_my_mg=$db->num_rows($query_my_mg);
			if ($sum_my_mg) {
				$db->query("update interior_goods set num=(num+1) where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			}else {
				$db->query("insert into interior_goods (i_uid,s_id,i_style,i_style_num,i_goodsname,i_effect,i_state,i_level,s_type,num) values ('".$_COOKIE['UserId']."','".$m_mg_ls['id']."','".$m_mg_ls['s_sort']."','".$m_mg_ls['s_stylenum']."','".$m_mg_ls['s_name']."','".$m_mg_ls['s_effect']."','2','".$m_mg_ls['s_level']."','".$m_mg_ls['s_type']."','1');");
			}
		}
		if ($ne_god_id>40 && $ne_god_id<=70){ 
			$query_mg_ls=$db->query("select * from m_goods where id='152';");
			$m_mg_ls=$db->fetch_array($query_mg_ls);
			
			$query_my_mg=$db->query("select id from interior_goods where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			$sum_my_mg=$db->num_rows($query_my_mg);
			if ($sum_my_mg) {
				$db->query("update interior_goods set num=(num+1) where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			}else {
				$db->query("insert into interior_goods (i_uid,s_id,i_style,i_style_num,i_goodsname,i_effect,i_state,i_level,s_type,num) values ('".$_COOKIE['UserId']."','".$m_mg_ls['id']."','".$m_mg_ls['s_sort']."','".$m_mg_ls['s_stylenum']."','".$m_mg_ls['s_name']."','".$m_mg_ls['s_effect']."','2','".$m_mg_ls['s_level']."','".$m_mg_ls['s_type']."','1');");
			}
		}
		if ($ne_god_id>70 && $ne_god_id<=100){ 
			$query_mg_ls=$db->query("select * from m_goods where id='153';");
			$m_mg_ls=$db->fetch_array($query_mg_ls);
			
			$query_my_mg=$db->query("select id from interior_goods where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			$sum_my_mg=$db->num_rows($query_my_mg);
			if ($sum_my_mg) {
				$db->query("update interior_goods set num=(num+1) where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			}else {
				$db->query("insert into interior_goods (i_uid,s_id,i_style,i_style_num,i_goodsname,i_effect,i_state,i_level,s_type,num) values ('".$_COOKIE['UserId']."','".$m_mg_ls['id']."','".$m_mg_ls['s_sort']."','".$m_mg_ls['s_stylenum']."','".$m_mg_ls['s_name']."','".$m_mg_ls['s_effect']."','2','".$m_mg_ls['s_level']."','".$m_mg_ls['s_type']."','1');");
			}
		}
	}
	
	
	//神奇蛋蛋
	if ($list_m_god['s_id']=='154') {
		$ne_god_id=rand(1,100);
		if ($ne_god_id<=30){ 
			$query_mg_ls=$db->query("select * from m_goods where id='155';");
			$m_mg_ls=$db->fetch_array($query_mg_ls);
			
			$query_my_mg=$db->query("select id from interior_goods where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			$sum_my_mg=$db->num_rows($query_my_mg);
			if ($sum_my_mg) {
				$db->query("update interior_goods set num=(num+1) where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			}else {
				$db->query("insert into interior_goods (i_uid,s_id,i_style,i_style_num,i_goodsname,i_effect,i_state,i_level,s_type,num) values ('".$_COOKIE['UserId']."','".$m_mg_ls['id']."','".$m_mg_ls['s_sort']."','".$m_mg_ls['s_stylenum']."','".$m_mg_ls['s_name']."','".$m_mg_ls['s_effect']."','2','".$m_mg_ls['s_level']."','".$m_mg_ls['s_type']."','1');");
			}
		}
		if ($ne_god_id>30 && $ne_god_id<=55){ 
			$query_mg_ls=$db->query("select * from m_goods where id='156';");
			$m_mg_ls=$db->fetch_array($query_mg_ls);
			
			$query_my_mg=$db->query("select id from interior_goods where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			$sum_my_mg=$db->num_rows($query_my_mg);
			if ($sum_my_mg) {
				$db->query("update interior_goods set num=(num+1) where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			}else {
				$db->query("insert into interior_goods (i_uid,s_id,i_style,i_style_num,i_goodsname,i_effect,i_state,i_level,s_type,num) values ('".$_COOKIE['UserId']."','".$m_mg_ls['id']."','".$m_mg_ls['s_sort']."','".$m_mg_ls['s_stylenum']."','".$m_mg_ls['s_name']."','".$m_mg_ls['s_effect']."','2','".$m_mg_ls['s_level']."','".$m_mg_ls['s_type']."','1');");
			}
		}
		if ($ne_god_id>55 && $ne_god_id<=85){ 
			$query_mg_ls=$db->query("select * from m_goods where id='157';");
			$m_mg_ls=$db->fetch_array($query_mg_ls);
			
			$query_my_mg=$db->query("select id from interior_goods where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			$sum_my_mg=$db->num_rows($query_my_mg);
			if ($sum_my_mg) {
				$db->query("update interior_goods set num=(num+1) where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			}else {
				$db->query("insert into interior_goods (i_uid,s_id,i_style,i_style_num,i_goodsname,i_effect,i_state,i_level,s_type,num) values ('".$_COOKIE['UserId']."','".$m_mg_ls['id']."','".$m_mg_ls['s_sort']."','".$m_mg_ls['s_stylenum']."','".$m_mg_ls['s_name']."','".$m_mg_ls['s_effect']."','2','".$m_mg_ls['s_level']."','".$m_mg_ls['s_type']."','1');");
			}
		}
		if ($ne_god_id>85 && $ne_god_id<=100){ 
			$query_mg_ls=$db->query("select * from m_goods where id='158';");
			$m_mg_ls=$db->fetch_array($query_mg_ls);
			
			$query_my_mg=$db->query("select id from interior_goods where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			$sum_my_mg=$db->num_rows($query_my_mg);
			if ($sum_my_mg) {
				$db->query("update interior_goods set num=(num+1) where s_id='".$m_mg_ls['id']."' and i_uid='".$_COOKIE['UserId']."';");
			}else {
				$db->query("insert into interior_goods (i_uid,s_id,i_style,i_style_num,i_goodsname,i_effect,i_state,i_level,s_type,num) values ('".$_COOKIE['UserId']."','".$m_mg_ls['id']."','".$m_mg_ls['s_sort']."','".$m_mg_ls['s_stylenum']."','".$m_mg_ls['s_name']."','".$m_mg_ls['s_effect']."','2','".$m_mg_ls['s_level']."','".$m_mg_ls['s_type']."','1');");
			}
		}
	}
	
	
	//////////////
	//使用粽子                 150黄金,151粮食,152铁矿,153木材
	//使用其它增资源的物品     129黄金,126粮食,121铁矿,123木材
	
	if ($list_m_god['s_id']=='150' or $list_m_god['s_id']=='151' or $list_m_god['s_id']=='152' or $list_m_god['s_id']=='153'  or $list_m_god['s_id']=='121' or $list_m_god['s_id']=='123' or $list_m_god['s_id']=='126' or $list_m_god['s_id']=='129') {
		//查询是否己有相同类型的功能在使用;
		$query_fun=$db->query("select id from add_goods_info  where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."' and type='1';");
		$have_goods_num=$db->num_rows($query_fun);
		if ($have_goods_num) echomsg("现在己有此类型的功能正在起作用！","goods.php?action_type=".$_GET['type_num']);
		
		$add_goods_woods=$add_goods_ores=$add_goods_golds=$add_goods_rices=0;
		//获取玩家每项建筑物的生产时间：resource_grow
		$query=$db->query("select * from resource_grow where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
		while($row=$db->fetch_array($query)) $resource_grow_list[]=$row;
		//开始按照生产安排进行资源增长
		$nowtime  =time();
		if($resource_grow_list) foreach ($resource_grow_list as $i=>$grow){//循环执行资源计算//////////////////////////////
			///////////
			//粽子哦
			 //记录木材每小时产量;
			 if ($list_m_god['s_id']=='153') if ($grow['b_type']==1) $add_goods_woods=intval($grow['total_grow']*0.15);			 
			 //记录矿石每小时产量;
			 if ($list_m_god['s_id']=='152') if ($grow['b_type']==2) $add_goods_ores=intval($grow['total_grow']*0.15);			 
			 //记录黄金每小时产量;
			 if ($list_m_god['s_id']=='150') if ($grow['b_type']==3) $add_goods_golds=intval($grow['total_grow']*0.15);
			 //记录粮食每小时产量;
			 if ($list_m_god['s_id']=='151') if ($grow['b_type']==4) $add_goods_rices=intval($grow['total_grow']*0.15);
			 //////////
			 //其它哦
			 //记录木材每小时产量;