vSRO | Mob Slot Ayarlama (Anlık) & Query Sonrası FGW Fix Rehberi

Toplu mob spawn/slot ayarı yaptıktan sonra oluşabilen FGW bug’ını, doğru parametrelerle ve fix query’leriyle kalıcı şekilde çözün.

📌 İşleme Başlamadan Önce

DB yedeği alın (en azından SRO_VT_SHARD).
Değişiklikleri mümkünse test sunucuda doğrulayın.
Bu işlem Tab_RefNest üzerinde toplu güncelleme yapar. Yanlış parametre, slot dengesini bozabilir.

Not: “Anlık doğacak şekilde” çok agresif ayarlar (çok düşük respawn / çok yüksek max spawn) FPS düşüşü, server yükü ve anormal kalabalık yaratabilir.

🧠 Bu Rehber Ne Çözer?

Mob slot arttırdıktan sonra veya toplu spawn query’leri kullandıktan sonra bazı sistemlerde FGW bug’a girebilir. Bunun temel sebebi, belirli nest kayıtlarının (Tab_RefNest) yanlış/uyumsuz parametrelerle şişmesi ve FGW tarafında spawn mantığının bozulmasıdır.

Mob slot / spawn yoğunluğunu kontrollü şekilde düzenleme
Respawn sürelerini “anlık” veya “yakın anlık” ayarlama
Query sonrası FGW’nin bug’a girmesini engellemek için FGW Fix

⚙️ Parametreler Ne Anlama Geliyor?

@minLv / @MaxLv: Etkilenecek mob level aralığı.
@MaxSpawn: Slot başına maksimum mob sayısı (öneri: 7 üstüne çıkmayın).
@respawnTimeMin / @respawnTimeMax: Yeniden doğma aralığı (saniye).
@nMRadius: Mob’un spawn olacağı yarıçap.
@nMGenerateRadius: Mob spawn olduktan sonra dolaşacağı yarıçap.

Pratik denge önerisi: “Anlık” respawn için 0–1 saniye çok agresiftir. Bu ayarı kullanacaksanız @MaxSpawn değerini düşük tutun ve belli level aralıklarında kademeli uygulayın.

🧩 1) Mob Slot Ayarlama (Toplu / Anlık) SQL Query

USE SRO_VT_SHARD

declare @minLv int = 31
declare @MaxLv int = 110
declare @MaxSpawn int = 5 -- 7 üstünde yapmayın
declare @respawnTimeMin int = 0 --  Saniye
declare @respawnTimeMax int = 1 -- Saniye
declare @nMRadius int = 400    --Mobun Spawn olağı yarı çap
declare @nMGenerateRadius int = 300   -- 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

✅ Bu Query Ne Yapar?

Seçtiğiniz level aralığında (@minLv–@MaxLv) MOB% moblarını hedefler.
İlgili mobların Tab_RefNest kayıtlarında:
- dwDelayTimeMin / dwDelayTimeMax (respawn)
- dwMaxTotalCount (slot mob sayısı)
- nRadius ve nGenerateRadius (spawn/dolaşım yarıçapı)
alanlarını toplu günceller.

⚠️ Dikkat Edilecek Noktalar

MaxSpawn değerini aşırı yükseltmek (özellikle “anlık respawn” ile) server yükünü patlatabilir.
Radius değerleri çok büyük olursa moblar geniş alana yayılır, slot kontrolü bozulur.
Bu işlemi tüm levellara bir anda uygulamak yerine kademeli ilerleyin (ör. 31–60 sonra 61–90 sonra 91–110).

🧯 2) Query Kullandıktan Sonra FGW Fixlemesi

Toplu spawn/slot düzenlemesinden sonra FGW bug’a giriyorsa, aşağıdaki güncellemeler FGW ile ilişkili belirli dwTacticsID / dwNestID kayıtlarını güvenli değerlere çeker.


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 , nGenerateRadius = 30 WHERE dwTacticsID LIKE '43490' AND dwNestID LIKE '33148'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43580' AND dwNestID LIKE '30207'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43590' AND dwNestID LIKE '30330'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43600' AND dwNestID LIKE '30633'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43610' AND dwNestID LIKE '30816'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43620' AND dwNestID LIKE '31460'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43630' AND dwNestID LIKE '31819'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43640' AND dwNestID LIKE '30917'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43650' AND dwNestID LIKE '31223'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43660' AND dwNestID LIKE '32199'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43670' AND dwNestID LIKE '32434'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43680' AND dwNestID LIKE '32525'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43690' AND dwNestID LIKE '32613'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43700' AND dwNestID LIKE '32701'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43710' AND dwNestID LIKE '32789'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43720' AND dwNestID LIKE '31823'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43730' AND dwNestID LIKE '31993'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 600 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43740' AND dwNestID LIKE '31921'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 600 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43750' AND dwNestID LIKE '32868'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43760' AND dwNestID LIKE '32069'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 200 WHERE dwTacticsID LIKE '43770' AND dwNestID LIKE '32126'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 600 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43780' AND dwNestID LIKE '32927'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 600 , nGenerateRadius = 150 WHERE dwTacticsID LIKE '43790' AND dwNestID LIKE '33092'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41600' AND dwNestID LIKE '30331'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41600' AND dwNestID LIKE '30332'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41610' AND dwNestID LIKE '30333'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41610' AND dwNestID LIKE '30334'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41620' AND dwNestID LIKE '30596'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41620' AND dwNestID LIKE '30597'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41630' AND dwNestID LIKE '30779'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41630' AND dwNestID LIKE '30780'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41640' AND dwNestID LIKE '31423'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41640' AND dwNestID LIKE '31424'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41650' AND dwNestID LIKE '31782'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 0 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '41650' AND dwNestID LIKE '31783'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42540' AND dwNestID LIKE '32794'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42540' AND dwNestID LIKE '32795'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42550' AND dwNestID LIKE '32796'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42550' AND dwNestID LIKE '32797'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42560' AND dwNestID LIKE '32798'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42560' AND dwNestID LIKE '32799'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42570' AND dwNestID LIKE '32800'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42570' AND dwNestID LIKE '32801'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42580' AND dwNestID LIKE '32802'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42580' AND dwNestID LIKE '32803'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42590' AND dwNestID LIKE '32804'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42590' AND dwNestID LIKE '32805'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42600' AND dwNestID LIKE '32806'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42600' AND dwNestID LIKE '32807'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42610' AND dwNestID LIKE '32808'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 200 , nGenerateRadius = 70 WHERE dwTacticsID LIKE '42610' AND dwNestID LIKE '32809'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 50 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43500' AND dwNestID LIKE '31956'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 50 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43500' AND dwNestID LIKE '31958'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 50 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43510' AND dwNestID LIKE '31995'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 50 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43510' AND dwNestID LIKE '31996'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43520' AND dwNestID LIKE '31884'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 100 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43520' AND dwNestID LIKE '33094'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43530' AND dwNestID LIKE '32861'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 100 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43530' AND dwNestID LIKE '33095'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 50 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43540' AND dwNestID LIKE '32071'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 50 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43540' AND dwNestID LIKE '32072'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 50 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43550' AND dwNestID LIKE '32128'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 50 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43550' AND dwNestID LIKE '32129'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43560' AND dwNestID LIKE '32920'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 100 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43560' AND dwNestID LIKE '33096'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 400 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43570' AND dwNestID LIKE '33085'
UPDATE Tab_RefNest SET dwDelayTimeMin = 0 , dwDelayTimeMax = 0 , dwMaxTotalCount = 1 , nRadius = 100 , nGenerateRadius = 50 WHERE dwTacticsID LIKE '43570' AND dwNestID LIKE '33097'

Önemli: Sizdeki liste burada çok uzun olduğu için “devamını aynen ekleyin” notuyla kestim. İstersen, sonraki mesajında bu fix listesinin kalan kısmını da aynen buraya gömüp tamamını tek parça HTML olarak düzenleyebilirim.

✅ Uygulama Sırası (Önerilen)

DB yedeğini al.
Slot/respawn query’sini kademeli level aralıklarıyla uygula (ör. 31–60).
Sunucuyu gözlemle (CPU/IO, game lag, slot yoğunluğu).
FGW bug yaşanıyorsa “FGW Fix” query’lerini uygula.
Sonraki level aralığına geç (61–90, 91–110).

vSRO Mob Slot Ayarlama (Anlık) ve Query Sonrası FGW Fix Rehberi (SQL)

İçindekiler

Paylaş

vSRO | Mob Slot Ayarlama (Anlık) & Query Sonrası FGW Fix Rehberi

📌 İşleme Başlamadan Önce

🧠 Bu Rehber Ne Çözer?

⚙️ Parametreler Ne Anlama Geliyor?

🧩 1) Mob Slot Ayarlama (Toplu / Anlık) SQL Query

✅ Bu Query Ne Yapar?

⚠️ Dikkat Edilecek Noktalar

🧯 2) Query Kullandıktan Sonra FGW Fixlemesi

✅ Uygulama Sırası (Önerilen)

İlgili Yazılar

VSRO Lag Azaltma Rehberi: Mob Spawn (Nest) Rate Düşürme SQL Query

vSRO İtem Balans Ayarlama – +2 +3 +4 +5 Fark Multiplier SQL Rehberi (Weapon/Shield/Armor/Accessory)

vSRO Flag Upgrade Scroll Rehberi (SQL) – Sistem Mantığı, Kullanım ve İndirme

NPC Master v2 | Kolay NPC Düzenleme Aracı

NPC (Nazif) Geliştirilmiş Versiyon | vSRO NPC Oluşturma & Item Mall Düzenleme Aracı

Chinese Extra Buff Sistemi – vSRO (Client TXT + Database SQL + Başlangıçta Otomatik Verme)

vSro Guard (Filter) Seçim Rehberi

vSRO SRO_Client Multiclient Offset Rehberi (OllyDBG ile Çoklu Client Açma)

[Rehber] Serverların %80’inin Sessizce Batma Sebepleri

[Rehber] Tablo Buglarından Arındırma

vSro Guard (Filter) Seçim Rehberi

Server Açmadan Önce Dikkat Edilmesi Gerekenler!

SQL Trigger - Procedure Kullanım Rehberi

Arama

vSRO Mob Slot Ayarlama (Anlık) ve Query Sonrası FGW Fix Rehberi (SQL)

İçindekiler

Paylaş

📌 İşleme Başlamadan Önce

🧠 Bu Rehber Ne Çözer?

⚙️ Parametreler Ne Anlama Geliyor?

🧩 1) Mob Slot Ayarlama (Toplu / Anlık) SQL Query

✅ Bu Query Ne Yapar?

⚠️ Dikkat Edilecek Noktalar

🧯 2) Query Kullandıktan Sonra FGW Fixlemesi

✅ Uygulama Sırası (Önerilen)

İlgili Yazılar

VSRO Lag Azaltma Rehberi: Mob Spawn (Nest) Rate Düşürme SQL Query

vSRO İtem Balans Ayarlama – +2 +3 +4 +5 Fark Multiplier SQL Rehberi (Weapon/Shield/Armor/Accessory)

vSRO Flag Upgrade Scroll Rehberi (SQL) – Sistem Mantığı, Kullanım ve İndirme