VSRO Mob Spawn Rate (Anlık Yeniden Doğma)

VSRO Mob Spawn Rate (Anlık Yeniden Doğma)

VSRO Mob Spawn Rate (Anlık Yeniden Doğma)

BLOG
Vsro Sunucu 23 Oca 2025

Herkese iyi akşamlar değerli dostlar !
Konu daha önceden paylaşılmış mevcut olan Query'e
"nRadius" ve "nGenerateRadius" un eklenmesiyle oluşturulmuştur.

Konu Detayı: Aşağıda vermiş olduğ Query, herhangi bir slottaki bir mobun kesildiği an yeniden doğmasını sağlayacaktır.

 

SQL:

USE SRO_VT_SHARD

declare @minLv int = 99
declare @MaxLv int = 100
declare @MaxSpawn int = 5 -- 7 üstünde yapmayın
declare @respawnTimeMin int = 0 --  Saniye
declare @respawnTimeMax int = 1 -- Saniye
declare @nMRadius int = 15    --Mobun Spawn olağı yarı çap
declare @nMGenerateRadius int = 30   -- Mob spawn olduktan sonra gezeceği yarı çap

begin
       --select D.*
       update D set dwDelayTimeMin = @respawnTimeMin, dwDelayTimeMax = @respawnTimeMax, dwMaxTotalCount = @MaxSpawn, nRadius = @nMRadius, nGenerateRadius = @nMGenerateRadius
       from _RefObjCommon as A
       inner join _RefObjChar as B on A.Link = B.ID and A.CodeName128 like 'MOB%' and A.Rarity = 0 and B.Lvl between @minLv and @MaxLv
       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 and D.nRadius > 0 and D.nGenerateRadius > 0
end

Düzenleme Sonrası FGW' de Oluşan bugu Fixle !
 

SQL:

USE SRO_VT_SHARD
GO

UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 30 , nGenerateRadius = 29 WHERE dwTacticsID LIKE '41540' AND dwNestID LIKE '30121'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41540' AND dwNestID LIKE '30177'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41540' AND dwNestID LIKE '30192'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41550' AND dwNestID LIKE '30307'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41550' AND dwNestID LIKE '30319'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 30 , nGenerateRadius = 29 WHERE dwTacticsID LIKE '41550' AND dwNestID LIKE '30415'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 30 , nGenerateRadius = 29 WHERE dwTacticsID LIKE '41560' AND dwNestID LIKE '30598'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41560' AND dwNestID LIKE '30610'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41560' AND dwNestID LIKE '30622'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 30 , nGenerateRadius = 29 WHERE dwTacticsID LIKE '41570' AND dwNestID LIKE '30781'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41570' AND dwNestID LIKE '30793'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41570' AND dwNestID LIKE '307805'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 30 , nGenerateRadius = 29 WHERE dwTacticsID LIKE '41580' AND dwNestID LIKE '31425'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41580' AND dwNestID LIKE '31437'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41580' AND dwNestID LIKE '31449'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 30 , nGenerateRadius = 29 WHERE dwTacticsID LIKE '41590' AND dwNestID LIKE '31784'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41590' AND dwNestID LIKE '31796'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '41590' AND dwNestID LIKE '31808'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42460' AND dwNestID LIKE '30895'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42460' AND dwNestID LIKE '30901'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42460' AND dwNestID LIKE '30906'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42460' AND dwNestID LIKE '30912'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42470' AND dwNestID LIKE '31203'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42470' AND dwNestID LIKE '31208'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42470' AND dwNestID LIKE '31213'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42470' AND dwNestID LIKE '31218'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42480' AND dwNestID LIKE '32179'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42480' AND dwNestID LIKE '32184'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42480' AND dwNestID LIKE '32189'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42480' AND dwNestID LIKE '32194'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42490' AND dwNestID LIKE '32414'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42490' AND dwNestID LIKE '32419'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42490' AND dwNestID LIKE '32424'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42490' AND dwNestID LIKE '32429'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42500' AND dwNestID LIKE '32505'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42500' AND dwNestID LIKE '32510'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42500' AND dwNestID LIKE '32515'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42500' AND dwNestID LIKE '32520'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42510' AND dwNestID LIKE '32593'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42510' AND dwNestID LIKE '32598'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42510' AND dwNestID LIKE '32603'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42510' AND dwNestID LIKE '32608'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42520' AND dwNestID LIKE '32681'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42520' AND dwNestID LIKE '32686'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42520' AND dwNestID LIKE '32691'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42520' AND dwNestID LIKE '32696'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42530' AND dwNestID LIKE '32769'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42530' AND dwNestID LIKE '32774'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42530' AND dwNestID LIKE '32779'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '42530' AND dwNestID LIKE '32784'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43420' AND dwNestID LIKE '31268'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43420' AND dwNestID LIKE '31307'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43420' AND dwNestID LIKE '31822'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43430' AND dwNestID LIKE '31982'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43430' AND dwNestID LIKE '31987'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43430' AND dwNestID LIKE '31992'
UPDATE Tab_RefNest SET dwDelayTimeMin = 8 , dwDelayTimeMax = 12 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43440' AND dwNestID LIKE '31889'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 250 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43440' AND dwNestID LIKE '31905'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 30 WHERE dwTacticsID LIKE '43440' AND dwNestID LIKE '33145'
UPDATE Tab_RefNest SET dwDelayTimeMin = 8 , dwDelayTimeMax = 12 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43450' AND dwNestID LIKE '32847'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 250 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43450' AND dwNestID LIKE '32854'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 30 WHERE dwTacticsID LIKE '43450' AND dwNestID LIKE '33146'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43460' AND dwNestID LIKE '32058'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43460' AND dwNestID LIKE '32063'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43460' AND dwNestID LIKE '32068'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43470' AND dwNestID LIKE '32096'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43470' AND dwNestID LIKE '32113'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43470' AND dwNestID LIKE '32125'
UPDATE Tab_RefNest SET dwDelayTimeMin = 8 , dwDelayTimeMax = 12 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43480' AND dwNestID LIKE '32906'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 250 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43480' AND dwNestID LIKE '32913'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadius = 30 WHERE dwTacticsID LIKE '43480' AND dwNestID LIKE '33147'
UPDATE Tab_RefNest SET dwDelayTimeMin = 8 , dwDelayTimeMax = 12 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43490' AND dwNestID LIKE '33071'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 250 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43490' AND dwNestID LIKE '33078'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 300 , nGenerateRadiLS

En son

Websitesi deneyiminizi iyileştirmek için yasal düzenlemelere uygun çerezler (cookies) kullanıyoruz. Detaylı bilgi için; ...