مشكلة في mastry skill ملهاش حل [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

Mohamed ElKersh

20-02-2016, 04:07 AM

انا ضيفت الاسكرولات تمام و كل حاجة بتاعت الصيني و الاوروبي في قسم الشروحات ضيفتهم تمام و اشتغلوا و كله تمام بس اجي افتح اكونت الاقي اسكلاته مفتوحة انزل الاسكلات كلها و اضرب الاسكرولة افتح اكونت تاني الاقي برده نفس الكلام

بمعني اني لو ضربت اسكرولة انك ترفع الوريرور 110 هلاقي السيرفر مفتوحله ويريور 110

شكرا

Dev.BigBear

20-02-2016, 06:18 AM

هات البروسيدجر الى انت حطو

Mohamed ElKersh

20-02-2016, 08:43 AM

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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42092
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' WHERE MasteryID = 513
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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42093
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' WHERE MasteryID = 514
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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42094
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' WHERE MasteryID = 515
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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
IF @ItemRefID = 42095
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' WHERE MasteryID = 516
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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42096
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' WHERE MasteryID = 517
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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42097
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' WHERE MasteryID = 518
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 = '120' 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

نفس المشكلة في بتااع الصيني بتااع حمزة و في الكويري اللي فوق ده انا بحط الاي دي بتاعي و بخلي المستري 110 بس و بيفتح عادي و شغال زي الفل لاكن بيدي السيرفر كله

HLP

20-02-2016, 09:07 AM

انا ضيفت الاسكرولات تمام و كل حاجة بتاعت الصيني و الاوروبي في قسم الشروحات ضيفتهم تمام و اشتغلوا و كله تمام بس اجي افتح اكونت الاقي اسكلاته مفتوحة انزل الاسكلات كلها و اضرب الاسكرولة افتح اكونت تاني الاقي برده نفس الكلام

بمعني اني لو ضربت اسكرولة انك ترفع الوريرور 110 هلاقي السيرفر مفتوحله ويريور 110

شكرا

يا باشا انت في حاجة عندك علي علشان سكرول ده شغال علي charID ازاي السيرفر كله و سكرول شغال من غير اي مشكلة

Mohamed ElKersh

20-02-2016, 09:10 AM

يا باشا انت في حاجة عندك علي علشان سكرول ده شغال علي charID ازاي السيرفر كله و سكرول شغال من غير اي مشكلة

طب ترجملي ده من ايه ]:

HLP

20-02-2016, 09:16 AM

this is fix for ur problem

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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42092
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' 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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42093
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' 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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42094
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' 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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
IF @ItemRefID = 42095
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' 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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42096
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' 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 =240)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =240)
IF @CHARLEVEL = 120
BEGIN
IF @ItemRefID = 42097
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' 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 = '120' 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

use this procedure and u get fix for ur problem

HLP

20-02-2016, 09:23 AM

طب ترجملي ده من ايه ]:

مشكلة في char id مش موجود في البرسيدور
لازم البرسيدور يبقي كدة في update mastery
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' WHERE MasteryID = 513 and CharID=@CharID

Mohamed ElKersh

20-02-2016, 11:03 AM

هو لازم انزل برنامج vsro multi tool

Mohamed ElKersh

20-02-2016, 11:09 AM

معكش بروسيدور صيني ؟

HLP

20-02-2016, 11:11 AM

هو لازم انزل برنامج vsro multi tool
لا مش لازم
البرنامج علشان الرسالة بس
يعني system حيشتغل عادي لو مش موجود

HLP

20-02-2016, 11:16 AM

معكش بروسيدور صيني ؟

اوربي اشتغل معك كويس

Mohamed ElKersh

20-02-2016, 11:19 AM

اوربي اشتغل معك كويس

لسا هجرب اهوه بس قولي بس معااك الصيني زي ده

HLP

20-02-2016, 11:21 AM

اتفضل الصيني

IF (@Operation = 41 ) --BICHEON 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 257 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,298,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,306,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,314,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,322,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,346,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,378,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,418,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,463,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,558,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,569,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,580,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,588,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,596,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,604,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,647,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,655,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,672,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,689,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,699,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3149,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7139,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7159,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7203,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7322,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7385,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7390,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7392,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7404,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7418,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7474,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7484,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7513,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7520,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30578,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30584,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30590,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30596,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30600,1)
END
END
END

IF (@Operation = 41 ) --HEUKSAL 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 258 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,708,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,716,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,724,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,735,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,746,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,757,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,765,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,773,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,781,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,789,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,797,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,805,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,813,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,821,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,829,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,853,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,885,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,925,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,933,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,943,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3167,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3176,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3224,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7536,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7554,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7577,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7582,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7584,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7596,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7612,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7637,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7651,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7672,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7675,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7688,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7798,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7805,1)
END
END
END
IF (@Operation = 41 ) --PACHEON 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 259 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,952,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,960,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,968,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,976,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,984,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,992,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1003,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1014,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1025,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1033,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1041,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1049,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1053,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1057,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1065,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1073,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1081,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1089,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1099,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3340,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3349,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7829,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7838,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7839,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7853,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7862,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7877,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7881,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7894,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7899,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7907,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7919,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7931,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7938,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7947,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7953,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7959,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7962,1)
END
END
END
IF (@Operation = 41 ) --COLD 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 273 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1108,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1116,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1124,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1132,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1140,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1148,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1153,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1158,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1163,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1168,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1173,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1178,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1189,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1200,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1217,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1234,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1244,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3364,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3379,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3391,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7972,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7980,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7995,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7997,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8010,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8024,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8050,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8084,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8097,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8103,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8109,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8115,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8119,1)
END
END
END

IF (@Operation = 41 ) --LIGHTNING 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 274 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1253,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1261,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1269,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1271,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1273,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1275,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1286,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1297,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1308,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1316,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1324,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1332,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1337,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1342,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1350,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1358,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1368,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3406,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3409,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3415,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8129,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8133,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8142,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8150,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8164,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8171,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8183,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8195,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8204,1)
END
END
END
IF (@Operation = 41 ) --FIRE 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 275 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1377,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1385,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1393,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1398,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1403,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1408,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1410,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1412,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1414,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1422,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1430,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1438,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1443,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1448,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1465,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1482,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1499,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1509,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3430,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3431,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3446,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8214,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8220,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8221,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8238,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8239,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8250,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8253,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8276,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8291,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8304,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8316,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8320,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21215,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21217,1)
END
END
END
IF (@Operation = 41 ) --FORCE 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 276 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1518,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1526,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1534,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1539,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1544,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1549,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1557,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1565,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1573,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1578,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1583,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1588,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1593,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1598,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1609,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1617,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1628,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3461,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3467,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3473,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8338,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8347,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8348,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8361,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8370,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8379,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8383,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8390,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8399,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8405,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8410,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8414,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8416,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20494,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20497,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20500,1)
END
END
END

Mohamed ElKersh

20-02-2016, 01:36 PM

اتفضل الصيني

IF (@Operation = 41 ) --BICHEON 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 257 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,298,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,306,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,314,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,322,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,346,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,378,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,418,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,463,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,558,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,569,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,580,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,588,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,596,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,604,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,647,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,655,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,672,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,689,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,699,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3149,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7139,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7159,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7203,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7322,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7385,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7390,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7392,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7404,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7418,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7474,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7484,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7513,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7520,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30578,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30584,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30590,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30596,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30600,1)
END
END
END

IF (@Operation = 41 ) --HEUKSAL 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 258 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,708,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,716,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,724,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,735,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,746,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,757,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,765,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,773,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,781,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,789,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,797,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,805,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,813,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,821,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,829,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,853,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,885,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,925,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,933,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,943,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3167,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3176,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3224,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7536,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7554,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7577,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7582,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7584,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7596,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7612,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7637,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7651,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7672,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7675,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7688,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7798,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7805,1)
END
END
END
IF (@Operation = 41 ) --PACHEON 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 259 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,952,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,960,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,968,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,976,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,984,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,992,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1003,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1014,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1025,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1033,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1041,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1049,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1053,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1057,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1065,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1073,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1081,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1089,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1099,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3340,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3349,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7829,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7838,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7839,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7853,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7862,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7877,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7881,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7894,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7899,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7907,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7919,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7931,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7938,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7947,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7953,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7959,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7962,1)
END
END
END
IF (@Operation = 41 ) --COLD 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 273 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1108,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1116,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1124,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1132,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1140,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1148,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1153,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1158,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1163,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1168,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1173,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1178,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1189,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1200,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1217,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1234,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1244,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3364,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3379,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3391,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7972,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7980,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7995,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7997,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8010,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8024,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8050,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8084,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8097,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8103,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8109,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8115,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8119,1)
END
END
END

IF (@Operation = 41 ) --LIGHTNING 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 274 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1253,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1261,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1269,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1271,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1273,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1275,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1286,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1297,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1308,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1316,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1324,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1332,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1337,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1342,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1350,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1358,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1368,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3406,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3409,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3415,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8129,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8133,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8142,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8150,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8164,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8171,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8183,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8195,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8204,1)
END
END
END
IF (@Operation = 41 ) --FIRE 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 275 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1377,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1385,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1393,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1398,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1403,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1408,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1410,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1412,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1414,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1422,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1430,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1438,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1443,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1448,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1465,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1482,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1499,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1509,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3430,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3431,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3446,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8214,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8220,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8221,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8238,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8239,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8250,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8253,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8276,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8291,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8304,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8316,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8320,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21215,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21217,1)
END
END
END
IF (@Operation = 41 ) --FORCE 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 (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID
IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 'YOUR SCROLL ID'
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 276 and CharID =@CharID
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1518,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1526,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1534,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1539,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1544,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1549,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1557,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1565,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1573,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1578,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1583,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1588,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1593,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1598,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1609,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1617,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1628,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3461,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3467,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3473,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8338,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8347,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8348,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8361,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8370,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8379,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8383,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8390,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8399,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8405,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8410,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8414,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8416,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20494,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20497,1)
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20500,1)
END
END
END
اول حاجة ده مجرب ؟ مش شغالة يا باشا

تاني حاجىة انا في الاوروبي ضربت ال اسكرولين تمام اشتغلت اجي بقا اعمل تست هيعمل التالتة ولا لا جابلي كراش و الاكونت مش عاوز يدخل تاني كل مدخل كراش لازم اشيل charmastry كله انت بامانة بوظتلي الدنيا كلها بس انا محتاج الاسكرولة ديه ده

HLP

20-02-2016, 05:57 PM

اول حاجة ده مجرب ؟ مش شغالة يا باشا

تاني حاجىة انا في الاوروبي ضربت ال اسكرولين تمام اشتغلت اجي بقا اعمل تست هيعمل التالتة ولا لا جابلي كراش و الاكونت مش عاوز يدخل تاني كل مدخل كراش لازم اشيل charmastry كله انت بامانة بوظتلي الدنيا كلها بس انا محتاج الاسكرولة ديه ده

ههههههههههههههههههه والله انا مش عارف اقولك ايه انا اللي عامل system ده و انت اول واحد يقول كده
ارجع و اقولك system ده مفيش اي مشكلة فيه

Mohamed ElKersh

20-02-2016, 07:41 PM

طب قولي حل :]

Dangers SrO

21-02-2016, 02:16 AM

بصراحه انا مش شايف اي مشكله في الموضوع.........
وكمان ال system ده شغال على 100% وصاحبو متابع معاك
اتاكد انتا من العملو
##