load_player_info.php

Download you own three BR

<?php
    require_once("online.php");
    //获取玩家角色基本信息数据//////////////////////
	$player_query=$db->query("select p.*,c.*,r.*,b.b_citywall_status,b.b_city_wall from building as b,player_info as p,city as c,resource as r where p.`u_id`=c.`u_id` and r.`u_id`=p.`u_id` and p.`u_id`=b.`u_id` and r.`c_id`=b.`c_id` and b.`c_id`=c.`c_id` and p.`u_id`='".$_COOKIE['UserId']."' and c.`c_id`='".$_COOKIE['CityId']."'");
	$init_data=$db->fetch_array($player_query);
    //总共注册用户数
    $query=$db->query("select * from `player_info`");
    $total_users = $db->num_rows($query);
    
	$query=$db->query("select * from study where `u_id`='".$_COOKIE['UserId']."' ");
	$study_result=$db->fetch_array($query);

    //产量
    for($i1=1;$i1<=4;$i1++){
	   	$query=$db->query("select * from resource_grow where `b_type`='".$i1."' and `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
	    $produceresult=$db->fetch_array($query);
	    $produce2[$i1] = $produceresult['total_grow'];
	    //土地属性加成
	    switch($init_data['c_land_type']){
		     	case 1:{
		     		$produce2[$i1] += round($produce2[$i1] * 0.02,0);
		     		break;
		     	}
		     	case 2:{
		     		if($i1=="4"){
		     			$produce2[$i1] += round($produce2[$i1] * 0.06,0);
		     			break;
		     		}
		     		break;
		     	}
		     	case 3:{
		     		if($i1=="1"){
		     			$produce2[$i1] += round($produce2[$i1] * 0.06,0);break;
		     		}
		     		break;
		     	}
		     	case 4:{
		     		if($i1=="2"){
		     			$produce2[$i1] += round($produce2[$i1] * 0.06,0);break;
		     		}
		     		break;
		     	}
		     	case 5:{
		     		if($i1=="3"){
		     			$produce2[$i1] += round($produce2[$i1] * 0.06,0);break;
		     		}
		     		break;
		     	}
		     	
		     }
		     
		 switch ($i1){
		                	case 1:{
		                		if(!$study_result['s_cutting']) $study_result['s_cutting']=0;
		                		$produce2[$i1] += round($produce2[$i1] * 0.01 * $study_result['s_cutting'],0);
		                		break;
		                	}
		                	case 2:{
		                		if(!$study_result['s_mining']) $study_result['s_mining']=0;
		                		$produce2[$i1] += round($produce2[$i1] * 0.01 * $study_result['s_mining'],0);
		                		break;
		                	}
		                	case 3:{
		                		if(!$study_result['s_golds']) $study_result['s_golds']=0;
		                		$produce2[$i1] += round($produce2[$i1] * 0.01 * $study_result['s_golds'],0);
		                		break;
		                	}
		                	case 4:{
		                		if(!$study_result['s_flooding']) $study_result['s_flooding']=0;
		                		$produce2[$i1] += round($produce2[$i1] * 0.01 * $study_result['s_flooding'],0);
		                		break;
		                	}
		 }
    }
    
	//总武将数////////////////////
	$query=$db->query("select id from gen where `g_uid`='".$_COOKIE['UserId']."'");
	$total_officers=$db->num_rows($query);
	
	//总城池数////////////////////
	$query=$db->query("select c_id from city where `u_id`='".$_COOKIE['UserId']."'");
	$total_citys=$db->num_rows($query);
	
	//当前城池武将数///////////////
	$query=$db->query("select id from gen where `g_uid`='".$_COOKIE['UserId']."' and `g_cid`='".$_COOKIE['CityId']."'");
	$city_officers=$db->num_rows($query);
	
	/*
	//总城池士兵数
	$query=$db->query("select * from soldier where `u_id`='".$_COOKIE['UserId']."'");
	while($row2=$db->fetch_array($query)) $total_soldier[] = $row2;
	if($soldier_type_name_en) foreach ($soldier_type_name_en as $si=>$sm){
		if($total_soldier) foreach ($total_soldier as $si2=>$sm2){
			$total_soldier_num += $sm2[$sm];
		}
	}
	*/
	//当前城池士兵数/////////
	$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+=$soldier_n_a[$i];
		}
	}
	
	
	$current_city_soldier_num = ($current_city_soldier_num>0) ? $current_city_soldier_num : 0;
	/*
	//已占仓库空间
	$init_data['free_stores'] = $init_data['rices'] + $init_data['ores'] + $init_data['woods'] + $init_data['golds'];
	$house_data['total_barracks'] = ($house_data['total_barracks']) ? $house_data['total_barracks'] : 0;
	*/
	//生产比例
	$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);
	//获取当前建筑物等级
	$query=$db->query("select * from building where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
	$grade_result=$db->fetch_array($query);
	
	for($i=1;$i<=4;$i++){
		//获取生产百分比
	   	$query=$db->query("select * from resource_grow where `b_type`='".$i."' and `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."'");
	    $produce_result2=$db->fetch_array($query);
	    $query=$db->query("select * from building_attribute where `b_type`='".$i."'");
		$base_result=$db->fetch_array($query);
		$workers = add_workers($base_result['b_workers'],$grade_result[$b_type_name_en[$i]]);
		$current_need_person[$i] =  $workers * ($produce_result2['worker_percent']/100);
		$current_need_person2 += (int)$current_need_person[$i];
		$total_need_workers += $workers;
		$add_resource[$i] = $produce_result2['total_grow'];
	}
	if($produce_result['true_workers']>0) $percnet1 = $init_data['total_house'] / $current_need_person2;
	$percent2 = round($percnet1,2);
	$percent2 = ($percent2>=1) ? 1 : $percent2;
//	$produce_percent =  $percent2 * 100;
    $produce_percent = $init_data['grow_percent'] * 100;
	
	//人口
	$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);
	//剩作人口
	$remain_person = $init_data['total_house'] - $produce_result['true_workers']-$person_soldier;
	//总人口
	$current_workers = $init_data['total_house'];
	
	
	//在线人数
	$online = $counter_num;
	//当前排名
	$query = $db->query("select u_id from player_info order by p_grade desc ,p_score desc");
	while($row=$db->fetch_array($query)) $rank[]=$row;
	if($rank) foreach ($rank as $i=>$m) {
		$i++;
		if($m['u_id']==$_COOKIE['UserId']){
			$rank_num = $i;break;
		}
	}
	//读取当前正在建设的建筑物名称
	$query=$db->query("select * from building_task where `u_id`='".$_COOKIE['UserId']."' and `c_id`='".$_COOKIE['CityId']."' and (`b_end_time`<>'' or `b_end_time`<>'0') limit 1");
	$current_task=$db->fetch_array($query);
    
?>