vSRO Paylaşım vSRO | Mob Slot Ayarlama ( Anlık ) & Sonrasında Oluşan FGW Fixlemesi

Admin1

silkroadpvp.com.tr
Yönetici
Katılım
26 Ocak 2022
Mesajlar
511
Tepkime puanı
0
Puanları
0
Konum
KRAL
[HIDE]
Herkese merhaba arkadaşlar Mob slot arttırdıktan sonra veya anlık dogacak şekilde toplu olarak Query kullandıktan sonra biliyorsunuz ki FGW buga giriyor bunları kullanınca fixlenecektir.
SQL:
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
Query Kullandıktan Sonra FGW Fixlemesi
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 , 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'
[/HIDE]
 
teşekkürler
 

Konu görüntüleyen kullanıcılar

Geri
Üst