|
IF (@Operation = 41 ) --WARRIOR SKILLS LVL UP
DECLARE @charname varchar ( 60 )
Set @charname =( select CharName16 from SRO_VT_SHARD.._Char WHERE CharID = @CharID )
DECLARE @CHARLEVEL INT
DECLARE @TotalMasteryLEVEL INT
DECLARE @RecordDate smalldatetime
set @RecordDate = GetDate()
SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID)
SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (513,514,515,516,517,518)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42092
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 513 and CharID = @CharID
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8440,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8451,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8468,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8478,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8501,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8515,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8526,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8531,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8546,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8560,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8574,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8584,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8599,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8629,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8649,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8660,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8670,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8710,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8725,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8752,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8777,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8812,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8832,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8884,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8895,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8905,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8935,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8974,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8999,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9034,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9045,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9075,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9105,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9116,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9126,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9145,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9175,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9187,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9214,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9250,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9262,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9287,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9322,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9342,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,21227,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30169,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30170,1)
END
END
IF (@Operation = 41 ) --WIZZARD SKILLS LVL UP
BEGIN
SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID)
SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (513,514,515,516,517,518)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42093
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 514 and CharID = @CharID
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9952,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9957,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9965,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9974,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10004,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10017,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10032,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10043,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10048,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10062,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10073,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10076,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10079,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10109,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10122,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10137,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10163,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10168,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10182,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10192,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10202,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10207,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10237,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10267,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10282,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10296,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10309,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10323,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10418,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10489,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10494,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10524,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10537,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10552,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10563,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10568,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10582,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10607,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10621,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10624,1)
END
END
END
IF (@Operation = 41 ) --ROGUE SKILLS LVL UP
SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID)
SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (513,514,515,516,517,518)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42094
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 515 and CharID = @CharID
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9365,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9370,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9373,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9378,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9383,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9388,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9393,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9397,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9401,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9407,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9412,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9417,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9422,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9428,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9431,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9437,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9439,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9444,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9450,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9453,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9454,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9484,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9489,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9500,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9517,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9528,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9545,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9574,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9589,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9601,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9614,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9623,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9634,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9675,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9687,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9704,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9715,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9722,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9738,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9743,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9773,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9785,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9801,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9845,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9871,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9880,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9900,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9943,1)
END
END
END
IF (@Operation = 41 ) --WARLOCK SKILLS LVL UP
BEGIN
SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID)
SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (513,514,515,516,517,518)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
IF @ItemRefID = 42095
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 516 and CharID = @CharID
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10655,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10660,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10689,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10707,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10735,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10751,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10776,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10789,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10810,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10821,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10832,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10838,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10848,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10853,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10862,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10866,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10874,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10877,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10907,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10917,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10947,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10965,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10973,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10977,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10988,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10993,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11003,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11007,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11011,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11015,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11045,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11074,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11086,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11099,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11109,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11118,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11129,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11134,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11144,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11148,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11154,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11161,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30189,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30194,1)
END
END
END
IF (@Operation = 41 ) --BARD SKILLS LVL UP
SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID)
SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (513,514,515,516,517,518)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42096
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 517 and CharID = @CharID
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11192,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11200,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11211,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11218,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11248,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11264,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11284,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11295,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11301,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11312,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11322,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11337,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11341,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11352,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11357,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11363,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11367,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11377,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11381,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11387,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11390,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11400,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11432,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11448,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11465,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11474,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11481,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11487,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11492,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11498,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11503,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11508,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11513,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11517,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11522,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11525,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30197,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30218,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30226,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30245,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30251,1)
END
END
END
IF (@Operation = 41 ) --CLERIC SKILLS LVL UP
SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID)
SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (513,514,515,516,517,518)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42097
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 518 and CharID = @CharID
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11556,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11586,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11602,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11611,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11622,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11627,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11632,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11643,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11649,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11668,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11685,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11702,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11711,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11719,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11728,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11744,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11751,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11768,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11776,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11783,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11791,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11797,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11805,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11811,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11816,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11818,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11823,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11830,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11851,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11868,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11884,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11893,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11904,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11914,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11919,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11930,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11935,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11943,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11953,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11961,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11970,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11978,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11985,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11993,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11999,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,33078,1)
END
END
END
IF (@Operation = 41 and @ItemRefID = 42098) --GM ALL EUR SKILLS
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE CharID=@CharID
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8440,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8451,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8468,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8478,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8501,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8515,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8526,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8531,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8546,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8560,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8574,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8584,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8599,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8629,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8649,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8660,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8670,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8710,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8725,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8752,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8777,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8812,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8832,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8884,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8895,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8905,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8935,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8974,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,8999,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9034,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9045,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9075,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9105,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9116,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9126,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9145,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9175,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9187,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9214,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9250,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9262,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9287,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9322,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9342,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9365,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9370,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9373,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9378,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9383,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9388,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9393,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9397,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9401,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9407,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9412,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9417,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9422,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9428,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9431,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9437,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9439,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9444,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9450,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9453,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9454,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9484,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9489,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9500,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9517,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9528,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9545,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9574,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9589,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9601,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9614,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9623,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9634,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9675,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9687,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9704,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9715,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9722,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9738,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9743,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9773,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9785,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9801,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9845,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9871,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9880,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9900,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9943,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9952,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9957,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9965,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,9974,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10004,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10017,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10032,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10043,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10048,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10062,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10073,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10076,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10079,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10109,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10122,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10137,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10163,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10168,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10182,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10192,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10202,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10207,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10237,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10267,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10282,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10296,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10309,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10323,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10418,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10489,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10494,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10524,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10537,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10552,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10563,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10568,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10582,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10607,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10621,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10624,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10655,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10660,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10689,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10707,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10735,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10751,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10776,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10789,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10810,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10821,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10832,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10838,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10848,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10853,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10862,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10866,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10874,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10877,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10907,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10917,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10947,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10965,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10973,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10977,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10988,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,10993,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11003,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11007,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11011,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11015,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11045,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11074,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11086,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11099,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11109,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11118,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11129,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11134,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11144,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11148,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11154,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11161,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11192,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11200,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11211,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11218,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11248,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11264,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11284,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11295,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11301,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11312,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11322,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11337,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11341,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11352,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11357,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11363,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11367,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11377,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11381,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11387,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11390,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11400,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11432,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11448,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11465,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11474,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11481,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11487,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11492,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11498,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11503,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11508,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11513,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11517,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11522,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11525,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11556,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11586,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11602,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11611,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11622,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11627,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11632,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11643,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11649,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11668,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11685,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11702,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11711,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11719,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11728,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11744,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11751,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11768,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11776,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11783,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11791,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11797,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11805,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11811,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11816,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11818,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11823,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11830,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11851,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11868,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11884,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11893,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11904,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11914,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11919,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11930,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11935,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11943,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11953,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11961,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11970,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11978,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11985,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11993,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,11999,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,21227,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30169,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30170,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30189,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30194,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30197,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30218,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30226,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30245,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,30251,1)
INSERT INTO SRO_VT_SHARD.._Charskill VALUES (@CharID,33078,1)
END
END
END
|