city_out.php

Download you own three BR

<?php
//查询此分城是否建设
$query_if_ea=$db->query("select c_id from city where ea_if='1' and u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
$list_if_ea=$db->num_rows($query_if_ea);
if ($_GET['city_action']=='city_out'){	
	if ($list_if_ea) {
		echomsg("此城进行过操做,不能放弃!");
	}
	//查询主城CityId;
	$query_city_id=$db->query("select * from city where u_id='".$_COOKIE['UserId']."' and c_type='1';");
	$list_city_id=$db->fetch_array($query_city_id);
	//临时记录主城cityid
	$ls_city_mail_id=$list_city_id['c_id'];
	//删除城市开始
	$db->query("delete from city_area where area='".$list_city_id['c_area']."' and area_x='".$list_city_id['c_area_x']."';");
	$db->query("delete from building where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
	$db->query("delete from gen where g_uid='".$_COOKIE['UserId']."' and g_cid='".$_COOKIE['CityId']."';");
	$db->query("update player_info set p_citys=(p_citys-'1') where u_id='".$_COOKIE['UserId']."';");
	$db->query("delete from soldier where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
	$db->query("delete from resource where u_id='".$_COOKIE['UserId']."' and c_id='".$_COOKIE['CityId']."';");
	
	$db->query("delete from city where c_id='".$_COOKIE['CityId']."' and u_id='".$_COOKIE['UserId']."';");
	
	$_COOKIE['CityId']=$ls_city_mail_id;
//	echo '<script>';
//	echo 'top.window.location.href="index.php?SessionId='.md5($login_md5_chars).'&action=city_jump&city_id='.$ls_city_mail_id;
//	echo '</script>';	
	echomsg("删除成功!","index.php?SessionId=".md5($login_md5_chars)."&action=city_jump&city_id=".$ls_city_mail_id);
}
?>