Email: xren@aionchs.com
Welcome to 永恒之塔私服|永恒之塔怀旧服|希望OL私服|aion私服  

数据库_修复_天魔种族限制_人数显示


ALTER proc [dbo].[TblWorldInfoDA_SrchGameWorlds]

as

set nocount on

set transaction isolation level read uncommitted

set ansi_warnings off

select T1.WORLD_ID, T1.WORLD_NM, T1.WORLD_DESC, T1.WORLD_STATUS,

T2.npc_count AS TOTAL_CON_USERS, T2.[LIGHT_USERS] AS LIGHT_CHAR_COUNT, T2.[DARK_USERS] AS DARK_CHAR_COUNT

from tbl_world_info t1(nolock), TBL_GAME_WORLD_INFO t2(nolock)

where t1.world_id=t2.world_id

and t2.zone_id=0

and t1.world_status='Y'

order by t1.world_id asc

set nocount off

return


文章出处:数据库_修复_天魔种族限制_人数显示_永恒之塔私服|永恒之塔怀旧服|希望OL私服|aion私服 官方网址:http://www.aionchs.com/