قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة[ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]
المشاركة الأصلية كتبت بواسطة Xan
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
وعدل برضو الـ Werrior يبقي معاهم
انا ممكن اعمل سكرول و برسيدور جديد ل special build زي warrior/rouge & rouge/warlock سكرول كدة اول لاعب يستعمله حرفع special build و اكيد حكون فيه limit mastery level ايه ريك
المشاركة الأصلية كتبت بواسطة HLP
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
انا ممكن اعمل سكرول و برسيدور جديد ل special build زي warrior/rouge & rouge/warlock سكرول كدة اول لاعب يستعمله حرفع special build و اكيد حكون فيه limit mastery level ايه ريك
هههههههههههههههههههههههههههههههههههههههههههههههههه
اخيرا عملت برسيدور LIMIT MASTERY
كود PHP:
IF (@Operation = 41 ) --WARRIOR SKILLS LVL UP DECLARE @CHARLEVEL INT DECLARE @TotalMasteryLEVEL INT 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 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
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 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 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 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 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 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 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 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 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 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 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
المشاركة الأصلية كتبت بواسطة HLP
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
هههههههههههههههههههههههههههههههههههههههههههههههههه
اخيرا عملت برسيدور LIMIT MASTERY
كود PHP:
IF (@Operation = 41 ) --WARRIOR SKILLS LVL UP
DECLARE @CHARLEVEL INT
DECLARE @TotalMasteryLEVEL INT
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 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
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 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
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 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
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 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
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 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
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 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
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
المشاركة الأصلية كتبت بواسطة HLP
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
هههههههههههههههههههههههههههههههههههههههههههههههههه
اخيرا عملت برسيدور LIMIT MASTERY
كود PHP:
IF (@Operation = 41 ) --WARRIOR SKILLS LVL UP DECLARE @CHARLEVEL INT DECLARE @TotalMasteryLEVEL INT 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 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
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 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 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 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 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 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 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 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 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 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 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
بصراحة لو شغاله تمام يبقي شغل عالي جدا ودماغك متكلفة ^^
شكرا مقدما ولازم ان شاء الله اجربها انهاردة. نشوف الزملا هيجربو وطالما واثق من نفسك تبقي شغاله وانا قريت البروسيدر شكلها بيقول شغاله
والصيني بعد مااجرب بتاعتك هعدل علي الموضوع التاني واكتب طبعا فكرة مين ^^
المشاركة الأصلية كتبت بواسطة Hamza FiGo
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
طيب سؤال فني ^^. انت مثلا دلوقتي عليت بايدك في الاوروبي 2 builds كدة 240/240 مثلا
لو جيت تضرب الاسكرول اية اللي بيتم ؟ المفروض علي البروسيدر انها متشتغلش. او المفروض يجي رسالة نوتيك تحت علي اليمين ان ليميت الاسكيلات جاب اخرة
اول حاجة لو برسيدور شاف ان total mastery =240 كدة سكرول مش حتشتغل معك لو رافع يدوي او بسكرول
تاني حاجة موضوع الرسالة لو جيت ترفع اكتر من 2 build يجلك رسالة نقولك ان انت كدة max mastery انا بعمل فيها اول ما اخلص حنزل البرسيدور
بس برسيدور شغال معك تمام صح
التعديل الأخير تم بواسطة HLP ; 25-12-2015 الساعة 12:52 PM
المشاركة الأصلية كتبت بواسطة HLP
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
اول حاجة لو برسيدور شاف ان total mastery =240 كدة سكرول مش حتشتغل معك لو رافع يدوي او بسكرول
تاني حاجة موضوع الرسالة لو جيت ترفع اكتر من 2 build يجلك رسالة نقولك ان انت كدة max mastery انا بعمل فيها اول ما اخلص حنزل البرسيدور
بس برسيدور شغال معك تمام صح
لسة مجربتهاش . هجربها انهاردة ان شاء الله. بس دا سؤال جه في بالي كدا
المشاركة الأصلية كتبت بواسطة Hamza FiGo
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
لسة مجربتهاش . هجربها انهاردة ان شاء الله. بس دا سؤال جه في بالي كدا
ان عملت ان لو mastery 240 وحد حاول يضرب سكرول تاني يجليه pm و يقوله ان انت كدة max mastery عن طريق برنامج بتاع ilegend vSro Multi Tool حرفع النهاردة و قول الطريقة ازاي
المشاركة الأصلية كتبت بواسطة HLP
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
ان عملت ان لو mastery 240 وحد حاول يضرب سكرول تاني يجليه pm و يقوله ان انت كدة max mastery عن طريق برنامج بتاع ilegend vSro Multi Tool حرفع النهاردة و قول الطريقة ازاي
23-12-2015, 07:28 PM
المواضيع المتشابهه
.gif){kind=icon}
العرض العادي
