Çok eski bir web tarayıcısı kullanıyorsunuz. Bu veya diğer siteleri görüntülemekte sorunlar yaşayabilirsiniz..
Tarayıcınızı güncellemeli veya alternatif bir tarayıcı kullanmalısınız.
Tarayıcınızı güncellemeli veya alternatif bir tarayıcı kullanmalısınız.
vSRO Çözüldü merhaba mastery scroll limit hatası
- Konuyu Başlatan byferoo
- Başlangıç tarihi
Çözüm
Aşağıdaki örneği @CharID, @MasteryID ile çağırman halinde kılçıksız çalışması gerekiyor diye düşünüyorum.
DECLARE @LevelCap INT = 100
DECLARE @MasteryID INT = ?
-- Delete Corrupt Skills ~
DELETE [_CharSkill] FROM [SRO_VT_SHARD].[dbo].[_CharSkill] WITH(NOLOCK) JOIN [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) ON [_CharSkill].[SkillID] = [_RefSkill].[ID] WHERE [_CharSkill].[CharID] = @CharID AND [_RefSkill].[ReqCommon_Mastery1] IN (SELECT [MasteryID] FROM [SRO_VT_SHARD].[dbo].[_CharSkillMastery] WITH(NOLOCK) WHERE [CharID] = @CharID AND [Level] < @LevelCap) AND [_CharSkill].[SkillID] NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625)
-- Delete Corrupt Mastery ~
UPDATE [SRO_VT_SHARD].[dbo].[_CharSkillMastery] SET [Level] = 0 WHERE [CharID] = @CharID AND [Level] < @LevelCap
-- Add Mastery Skills ~
INSERT [SRO_VT_SHARD].[dbo].[_CharSkill] SELECT @CharID, [ID], 1 FROM [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) WHERE [ID] IN...
DECLARE @LevelCap INT = 100
DECLARE @MasteryID INT = ?
-- Delete Corrupt Skills ~
DELETE [_CharSkill] FROM [SRO_VT_SHARD].[dbo].[_CharSkill] WITH(NOLOCK) JOIN [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) ON [_CharSkill].[SkillID] = [_RefSkill].[ID] WHERE [_CharSkill].[CharID] = @CharID AND [_RefSkill].[ReqCommon_Mastery1] IN (SELECT [MasteryID] FROM [SRO_VT_SHARD].[dbo].[_CharSkillMastery] WITH(NOLOCK) WHERE [CharID] = @CharID AND [Level] < @LevelCap) AND [_CharSkill].[SkillID] NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625)
-- Delete Corrupt Mastery ~
UPDATE [SRO_VT_SHARD].[dbo].[_CharSkillMastery] SET [Level] = 0 WHERE [CharID] = @CharID AND [Level] < @LevelCap
-- Add Mastery Skills ~
INSERT [SRO_VT_SHARD].[dbo].[_CharSkill] SELECT @CharID, [ID], 1 FROM [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) WHERE [ID] IN...
Aşağıdaki örneği @CharID, @MasteryID ile çağırman halinde kılçıksız çalışması gerekiyor diye düşünüyorum.
DECLARE @LevelCap INT = 100
DECLARE @MasteryID INT = ?
-- Delete Corrupt Skills ~
DELETE [_CharSkill] FROM [SRO_VT_SHARD].[dbo].[_CharSkill] WITH(NOLOCK) JOIN [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) ON [_CharSkill].[SkillID] = [_RefSkill].[ID] WHERE [_CharSkill].[CharID] = @CharID AND [_RefSkill].[ReqCommon_Mastery1] IN (SELECT [MasteryID] FROM [SRO_VT_SHARD].[dbo].[_CharSkillMastery] WITH(NOLOCK) WHERE [CharID] = @CharID AND [Level] < @LevelCap) AND [_CharSkill].[SkillID] NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625)
-- Delete Corrupt Mastery ~
UPDATE [SRO_VT_SHARD].[dbo].[_CharSkillMastery] SET [Level] = 0 WHERE [CharID] = @CharID AND [Level] < @LevelCap
-- Add Mastery Skills ~
INSERT [SRO_VT_SHARD].[dbo].[_CharSkill] SELECT @CharID, [ID], 1 FROM [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) WHERE [ID] IN (SELECT MAX([_RefSkill].[ID]) FROM [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) JOIN [SRO_VT_SHARD].[dbo].[_RefSkillMastery] WITH(NOLOCK) ON [_RefSkill].[ReqCommon_Mastery1] = [_RefSkillMastery].[ID] AND [_RefSkill].[Service] = 1 AND [_RefSkillMastery].[ID] = @MasteryID AND [_RefSkill].[ReqLearn_SP] != 0 GROUP BY [_RefSkill].[GroupID]) AND [ID] NOT IN (SELECT [SkillID] FROM [SRO_VT_SHARD].[dbo].[_CharSkill] WITH(NOLOCK) WHERE [CharID] = @CharID)
-- Open Mastery ~
UPDATE [SRO_VT_SHARD].[dbo].[_CharSkillMastery] SET [Level] = @LevelCap WHERE [MasteryID] = @MasteryID
DECLARE @LevelCap INT = 100
DECLARE @MasteryID INT = ?
-- Delete Corrupt Skills ~
DELETE [_CharSkill] FROM [SRO_VT_SHARD].[dbo].[_CharSkill] WITH(NOLOCK) JOIN [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) ON [_CharSkill].[SkillID] = [_RefSkill].[ID] WHERE [_CharSkill].[CharID] = @CharID AND [_RefSkill].[ReqCommon_Mastery1] IN (SELECT [MasteryID] FROM [SRO_VT_SHARD].[dbo].[_CharSkillMastery] WITH(NOLOCK) WHERE [CharID] = @CharID AND [Level] < @LevelCap) AND [_CharSkill].[SkillID] NOT IN (1, 70, 40, 2, 8421, 9354, 9355, 11162, 9944, 8419, 8420, 11526, 10625)
-- Delete Corrupt Mastery ~
UPDATE [SRO_VT_SHARD].[dbo].[_CharSkillMastery] SET [Level] = 0 WHERE [CharID] = @CharID AND [Level] < @LevelCap
-- Add Mastery Skills ~
INSERT [SRO_VT_SHARD].[dbo].[_CharSkill] SELECT @CharID, [ID], 1 FROM [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) WHERE [ID] IN (SELECT MAX([_RefSkill].[ID]) FROM [SRO_VT_SHARD].[dbo].[_RefSkill] WITH(NOLOCK) JOIN [SRO_VT_SHARD].[dbo].[_RefSkillMastery] WITH(NOLOCK) ON [_RefSkill].[ReqCommon_Mastery1] = [_RefSkillMastery].[ID] AND [_RefSkill].[Service] = 1 AND [_RefSkillMastery].[ID] = @MasteryID AND [_RefSkill].[ReqLearn_SP] != 0 GROUP BY [_RefSkill].[GroupID]) AND [ID] NOT IN (SELECT [SkillID] FROM [SRO_VT_SHARD].[dbo].[_CharSkill] WITH(NOLOCK) WHERE [CharID] = @CharID)
-- Open Mastery ~
UPDATE [SRO_VT_SHARD].[dbo].[_CharSkillMastery] SET [Level] = @LevelCap WHERE [MasteryID] = @MasteryID
Oyla
0
Çözüm
Bu konuyu görüntüleyen kullanıcılar
Toplam: 1 (Kullanıcı: 0, ziyaretçi: 1)
Benzer konular
- Cevaplar
- 3
- Görüntüleme
- 120
- Soru
- Cevaplar
- 3
- Görüntüleme
- 98
- Cevaplar
- 8
- Görüntüleme
- 226
- Cevaplar
- 4
- Görüntüleme
- 220
- Cevaplar
- 24
- Görüntüleme
- 1K
