[HIDE]
USE SRO_VT_SHARD
declare @nMRadius int = 5 -- Yarıçap (Mob öldükten sonra dirileceği bölge.)
declare @nMGenerateRadius int = 30 -- Gezilecek yarıçap. (Mob canlıyken gezebileceği max. range.)
declare @dwMaxTotalCount int = 3 -- Tek nokta da çıkacak mob sayısı. (Tek GS için 3, bölünmüş mapler için 5 fevkale de bir değerdir.)
UPDATE Tab_RefNest
SET dwMaxTotalCount= @dwMaxTotalCount,
dwDelayTimeMin=0,
dwDelayTimeMax=1,
nRadius = @nMRadius,
nGenerateRadius = @nMGenerateRadius
WHERE dwTacticsID IN
(SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID IN
(SELECT ID FROM _RefObjCommon WHERE Link IN
(SELECT ID FROM _RefObjChar WHERE LVL BETWEEN 1 AND 120 AND ID IN
(SELECT LINK FROM _RefObjCommon))
AND CodeName128 LIKE'MOB_CH%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- JANGAN
OR CodeName128 LIKE 'MOB_WC%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- DOWNHANG
OR CodeName128 LIKE 'MOB_OA%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- OASIS
OR CodeName128 LIKE 'MOB_KT%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- HOTAN
OR CodeName128 LIKE 'MOB_KK%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- KARAKORAM
OR CodeName128 LIKE 'MOB_TK%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- TAKLAMAKAN
OR CodeName128 LIKE 'MOB_RM%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- ROC MT.
OR CodeName128 LIKE 'MOB_EU%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- CONSTANTINOPLE
OR CodeName128 LIKE 'MOB_AM%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- SAMARKAND (ASIA MINOR)
OR CodeName128 LIKE 'MOB_CA%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- SAMARKAND (CENTRAL ASIA)
OR CodeName128 LIKE 'MOB_SD%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- ALEXANDRIA
OR CodeName128 LIKE 'MOB_JUP%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3)) -- JUPITER
[/HIDE]
USE SRO_VT_SHARD
declare @nMRadius int = 5 -- Yarıçap (Mob öldükten sonra dirileceği bölge.)
declare @nMGenerateRadius int = 30 -- Gezilecek yarıçap. (Mob canlıyken gezebileceği max. range.)
declare @dwMaxTotalCount int = 3 -- Tek nokta da çıkacak mob sayısı. (Tek GS için 3, bölünmüş mapler için 5 fevkale de bir değerdir.)
UPDATE Tab_RefNest
SET dwMaxTotalCount= @dwMaxTotalCount,
dwDelayTimeMin=0,
dwDelayTimeMax=1,
nRadius = @nMRadius,
nGenerateRadius = @nMGenerateRadius
WHERE dwTacticsID IN
(SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID IN
(SELECT ID FROM _RefObjCommon WHERE Link IN
(SELECT ID FROM _RefObjChar WHERE LVL BETWEEN 1 AND 120 AND ID IN
(SELECT LINK FROM _RefObjCommon))
AND CodeName128 LIKE'MOB_CH%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- JANGAN
OR CodeName128 LIKE 'MOB_WC%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- DOWNHANG
OR CodeName128 LIKE 'MOB_OA%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- OASIS
OR CodeName128 LIKE 'MOB_KT%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- HOTAN
OR CodeName128 LIKE 'MOB_KK%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- KARAKORAM
OR CodeName128 LIKE 'MOB_TK%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- TAKLAMAKAN
OR CodeName128 LIKE 'MOB_RM%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- ROC MT.
OR CodeName128 LIKE 'MOB_EU%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- CONSTANTINOPLE
OR CodeName128 LIKE 'MOB_AM%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- SAMARKAND (ASIA MINOR)
OR CodeName128 LIKE 'MOB_CA%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- SAMARKAND (CENTRAL ASIA)
OR CodeName128 LIKE 'MOB_SD%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3 -- ALEXANDRIA
OR CodeName128 LIKE 'MOB_JUP%' AND CodeName128 NOT LIKE '%NPC%' AND Rarity NOT LIKE 3)) -- JUPITER
[/HIDE]
