-----------------Mastery Scroll Start--------------------
IF (@Operation=41 AND @ItemRefID BETWEEN 67507 AND 67512) ---------------- European Mastery Scrolls -------------------
BEGIN
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='513')
BEGIN
DECLARE @Wizard INT,@Warrior INT,@Rouge INT,@Warlock INT,@Bard INT,@Cleric INT
SELECT @Wizard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='514'
SELECT @Warrior=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='513'
SELECT @Rouge=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='515'
SELECT @Warlock=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='516'
SELECT @Bard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='517'
SELECT @Cleric=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='518'
IF (@Wizard+@Warrior+@Rouge+@Warlock+@Bard+@Cleric<='120')
BEGIN
DECLARE @EuropeanMasteryType INT;
SET @EuropeanMasteryType = CASE
WHEN @ItemRefID=67507 --------------- Wizard
THEN 514
WHEN @ItemRefID=67508 --------------- Warrior
THEN 513
WHEN @ItemRefID=67509 --------------- Rouge
THEN 515
WHEN @ItemRefID=67510 --------------- Cleric
THEN 518
WHEN @ItemRefID=67511 --------------- Bard
THEN 517
WHEN @ItemRefID=67512 --------------- Warlock
THEN 516
END
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='120' WHERE CharID=@CharID AND MasteryID=@EuropeanMasteryType
INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_LOG.dbo._CharacterSkills WHERE MasteryID=@EuropeanMasteryType
END
END
END
IF (@Operation=41 AND @ItemRefID BETWEEN 67500 AND 67506) ---------------- Chinese Mastery Scrolls -------------------
BEGIN
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='257')
BEGIN
DECLARE @Bicheon INT,@Heuksal INT,@Pacheon INT,@Cold INT,@Lightning INT,@Fire INT,@Force INT
SELECT @Bicheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='257'
SELECT @Heuksal=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='258'
SELECT @Pacheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='259'
SELECT @Cold=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='273'
SELECT @Lightning=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='274'
SELECT @Fire=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='275'
SELECT @Force=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='276'
IF (@Bicheon+@Heuksal+@Pacheon+@Cold+@Lightning+@Fire+@Force <='280')
BEGIN
DECLARE @ChineseMasteryType INT;
SET @ChineseMasteryType = Case
WHEN @ItemRefID=67502 --------------- Bacheon
THEN 257
WHEN @ItemRefID=67501 --------------- Heuksal
THEN 258
WHEN @ItemRefID=67500 --------------- Pacheon
THEN 259
WHEN @ItemRefID=67505 --------------- Cold
THEN 273
WHEN @ItemRefID=67504 --------------- Lightning
THEN 274
WHEN @ItemRefID=67503 --------------- Fire
THEN 275
WHEN @ItemRefID=67506 --------------- Force
THEN 276
END
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@ChineseMasteryType
INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_LOG.dbo._CharacterSkills WHERE MasteryID=@ChineseMasteryType
END
END
END
-----------------Mastery Scroll End--------------------
