NOT:SQL AÇIP NEW QUERY DİYİP OKUTUNUZ.
[HIDE]
[/HIDE]
[HIDE]
Kod:
USE SRO_VT_SHARD
SELECT D.dwNestID, D.dwHiveID, D.dwTacticsID, D.nRegionDBID, D.fLocalPosX, D.fLocalPosY, D.fLocalPosZ, D.wInitialDir, D.nRadius, D.nGenerateRadius, D.nChampionGenPercentage, D.dwDelayTimeMin, D.dwDelayTimeMax, D.dwMaxTotalCount, D.btFlag, D.btRespawn, D.btType
FROM _RefObjCommon as A inner join _RefObjChar as B on A.Link = B.ID and A.CodeName128 like 'MOB_CH_YEOHA%'
inner join Tab_RefTactics as C on C.dwObjID = A.ID
inner join Tab_RefNest as D on D.dwTacticsID = C.dwTacticsID and D.dwMaxTotalCount > 0 and D.dwDelayTimeMin > 0
