- Katılım
- 1 Haz 2011
- Mesajlar
- 68
- Tepkime puanı
- 7,307
- Puanları
- 8,202
- Konum
- Kahramanmaraş
- Web sitesi
- sroloji.com
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.
Düzenleme Sonrası FGW' de Oluşan bugu Fixle !
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
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
Son düzenleme:
