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

الموقع العربي الاول للعبة Silkroad Online

صفحة 1 من 2

1

عرض 40 مشاركات من هذا الموضوع لكل صفحة

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)

- قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)

- - مشكلة في mastry skill ملهاش حل (https://silkroad4arab.com/vb/showthread.php?t=598913)

Mohamed ElKersh

20-02-2016 04:07 AM

مشكلة في mastry skill ملهاش حل

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

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

شكرا

Dev.BigBear

20-02-2016 06:18 AM

رد: مشكلة في mastry skill ملهاش حل

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

Mohamed ElKersh

20-02-2016 08:43 AM

رد: مشكلة في mastry skill ملهاش حل

كود PHP:


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

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

HLP	20-02-2016 09:07 AM

رد: مشكلة في mastry skill ملهاش حل

اقتباس:

المشاركة الأصلية كتبت بواسطة Mohamed ElKersh (المشاركة 5254085)

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

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

شكرا

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

Mohamed ElKersh

20-02-2016 09:10 AM

رد: مشكلة في mastry skill ملهاش حل

اقتباس:

المشاركة الأصلية كتبت بواسطة HLP (المشاركة 5254123)

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

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

HLP	20-02-2016 09:16 AM

رد: مشكلة في mastry skill ملهاش حل

this is fix for ur problem

كود PHP:

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

use this procedure and u get fix for ur problem

HLP	20-02-2016 09:23 AM

رد: مشكلة في mastry skill ملهاش حل

اقتباس:

المشاركة الأصلية كتبت بواسطة Mohamed ElKersh (المشاركة 5254124)

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

مشكلة في char id مش موجود في البرسيدور
لازم البرسيدور يبقي كدة في update mastery

كود PHP:

UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '120' WHERE MasteryID = 513 and CharID=@CharID

Mohamed ElKersh

20-02-2016 11:03 AM

رد: مشكلة في mastry skill ملهاش حل

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

Mohamed ElKersh

20-02-2016 11:09 AM

رد: مشكلة في mastry skill ملهاش حل

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

HLP	20-02-2016 11:11 AM

رد: مشكلة في mastry skill ملهاش حل

اقتباس:

المشاركة الأصلية كتبت بواسطة Mohamed ElKersh (المشاركة 5254138)

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

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

HLP	20-02-2016 11:16 AM

رد: مشكلة في mastry skill ملهاش حل

اقتباس:

المشاركة الأصلية كتبت بواسطة Mohamed ElKersh (المشاركة 5254141)

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

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

Mohamed ElKersh

20-02-2016 11:19 AM

رد: مشكلة في mastry skill ملهاش حل

اقتباس:

المشاركة الأصلية كتبت بواسطة HLP (المشاركة 5254143)

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

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

HLP	20-02-2016 11:21 AM

رد: مشكلة في mastry skill ملهاش حل

اتفضل الصيني

كود PHP:

IF (@Operation = 41 ) --BICHEON SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 257 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,298,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,306,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,314,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,322,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,346,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,378,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,418,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,463,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,558,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,569,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,580,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,588,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,596,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,604,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,647,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,655,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,672,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,689,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,699,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3149,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7139,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7159,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7203,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7322,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7385,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7390,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7392,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7404,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7418,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7474,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7484,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7513,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7520,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30578,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30584,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30590,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30596,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30600,1) END END END IF (@Operation = 41 ) --HEUKSAL SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 258 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,708,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,716,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,724,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,735,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,746,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,757,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,765,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,773,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,781,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,789,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,797,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,805,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,813,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,821,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,829,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,853,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,885,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,925,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,933,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,943,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3167,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3176,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3224,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7536,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7554,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7577,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7582,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7584,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7596,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7612,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7637,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7651,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7672,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7675,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7688,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7798,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7805,1) END END END IF (@Operation = 41 ) --PACHEON SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 259 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,952,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,960,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,968,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,976,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,984,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,992,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1003,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1014,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1025,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1033,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1041,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1049,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1053,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1057,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1065,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1073,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1081,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1089,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1099,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3340,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3349,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7829,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7838,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7839,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7853,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7862,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7877,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7881,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7894,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7899,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7907,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7919,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7931,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7938,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7947,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7953,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7959,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7962,1) END END END IF (@Operation = 41 ) --COLD SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 273 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1108,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1116,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1124,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1132,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1140,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1148,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1153,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1158,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1163,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1168,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1173,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1178,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1189,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1200,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1217,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1234,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1244,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3364,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3379,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3391,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7972,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7980,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7995,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7997,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8010,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8024,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8050,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8084,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8097,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8103,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8109,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8115,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8119,1) END END END IF (@Operation = 41 ) --LIGHTNING SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 274 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1253,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1261,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1269,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1271,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1273,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1275,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1286,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1297,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1308,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1316,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1324,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1332,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1337,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1342,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1350,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1358,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1368,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3406,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3409,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3415,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8129,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8133,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8142,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8150,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8164,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8171,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8183,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8195,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8204,1) END END END IF (@Operation = 41 ) --FIRE SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 275 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1377,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1385,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1393,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1398,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1403,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1408,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1410,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1412,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1414,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1422,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1430,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1438,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1443,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1448,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1465,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1482,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1499,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1509,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3430,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3431,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3446,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8214,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8220,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8221,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8238,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8239,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8250,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8253,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8276,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8291,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8304,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8316,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8320,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21215,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21217,1) END END END IF (@Operation = 41 ) --FORCE SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 276 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1518,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1526,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1534,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1539,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1544,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1549,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1557,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1565,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1573,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1578,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1583,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1588,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1593,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1598,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1609,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1617,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1628,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3461,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3467,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3473,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8338,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8347,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8348,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8361,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8370,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8379,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8383,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8390,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8399,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8405,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8410,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8414,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8416,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20494,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20497,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20500,1) END END END

Mohamed ElKersh

20-02-2016 01:36 PM

رد: مشكلة في mastry skill ملهاش حل

اقتباس:

المشاركة الأصلية كتبت بواسطة HLP (المشاركة 5254146)

اتفضل الصيني

كود PHP:

IF (@Operation = 41 ) --BICHEON SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 257 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,298,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,306,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,314,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,322,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,346,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,378,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,418,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,463,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,558,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,569,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,580,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,588,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,596,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,604,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,647,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,655,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,672,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,689,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,699,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3149,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7139,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7159,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7203,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7322,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7385,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7390,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7392,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7404,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7418,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7474,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7484,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7513,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7520,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30578,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30584,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30590,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30596,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30600,1) END END END IF (@Operation = 41 ) --HEUKSAL SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 258 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,708,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,716,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,724,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,735,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,746,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,757,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,765,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,773,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,781,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,789,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,797,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,805,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,813,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,821,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,829,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,853,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,885,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,925,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,933,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,943,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3167,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3176,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3224,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7536,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7554,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7577,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7582,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7584,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7596,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7612,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7637,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7651,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7672,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7675,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7688,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7798,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7805,1) END END END IF (@Operation = 41 ) --PACHEON SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 259 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,952,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,960,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,968,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,976,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,984,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,992,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1003,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1014,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1025,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1033,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1041,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1049,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1053,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1057,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1065,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1073,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1081,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1089,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1099,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3340,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3349,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7829,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7838,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7839,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7853,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7862,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7877,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7881,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7894,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7899,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7907,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7919,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7931,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7938,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7947,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7953,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7959,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7962,1) END END END IF (@Operation = 41 ) --COLD SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 273 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1108,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1116,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1124,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1132,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1140,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1148,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1153,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1158,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1163,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1168,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1173,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1178,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1189,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1200,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1217,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1234,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1244,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3364,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3379,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3391,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7972,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7980,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7995,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7997,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8010,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8024,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8050,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8084,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8097,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8103,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8109,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8115,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8119,1) END END END IF (@Operation = 41 ) --LIGHTNING SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 274 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1253,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1261,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1269,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1271,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1273,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1275,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1286,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1297,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1308,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1316,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1324,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1332,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1337,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1342,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1350,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1358,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1368,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3406,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3409,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3415,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8129,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8133,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8142,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8150,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8164,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8171,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8183,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8195,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8204,1) END END END IF (@Operation = 41 ) --FIRE SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 275 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1377,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1385,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1393,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1398,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1403,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1408,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1410,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1412,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1414,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1422,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1430,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1438,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1443,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1448,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1465,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1482,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1499,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1509,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3430,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3431,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3446,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8214,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8220,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8221,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8238,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8239,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8250,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8253,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8276,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8291,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8304,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8316,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8320,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21215,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21217,1) END END END IF (@Operation = 41 ) --FORCE SKILLS LVL UP SET @CHARLEVEL = ( SELECT CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID =@CharID) SELECT @TotalMasteryLEVEL = SUM(SRO_VT_SHARD.dbo._CharSkillMastery.Level) FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE SRO_VT_SHARD.dbo._CharSkillMastery.MasteryID in (257,258,259,273,274,275,276)AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID IF EXISTS ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =330) IF @CHARLEVEL = 110 BEGIN IF @ItemRefID = 'YOUR SCROLL ID' BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' WHERE MasteryID = 276 and CharID =@CharID INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1518,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1526,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1534,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1539,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1544,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1549,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1557,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1565,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1573,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1578,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1583,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1588,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1593,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1598,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1609,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1617,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1628,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3461,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3467,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3473,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8338,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8347,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8348,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8361,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8370,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8379,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8383,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8390,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8399,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8405,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8410,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8414,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8416,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20494,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20497,1) INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20500,1) END END END

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

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

HLP	20-02-2016 05:57 PM

رد: مشكلة في mastry skill ملهاش حل

اقتباس:

المشاركة الأصلية كتبت بواسطة Mohamed ElKersh (المشاركة 5254153)

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

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

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

الساعة الآن 01:40 PM.

صفحة 1 من 2

1

عرض 40 مشاركات من هذا الموضوع لكل صفحة

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.