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

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