قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة[ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]
_AddLogItem
FINELY I MAKE PROCEDURE LEVEL UP SKILLS AND MASTERY WITH MASTERY LIMIT
and if player want use other scroll and he get max mastery level he will get pm to him say
كود PHP:
'your mastery level is max'
كود 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
1 SN_ITEM_WARRIOR_SKILLS_LVL_UP Scroll Level up all warrior skills 1 SN_ITEM_WIZZARD_SKILLS_LVL_UP Scroll Level up all Wizzard skills 1 SN_ITEM_ROGUE_SKILLS_LVL_UP Scroll Level up all Rouge skills 1 SN_ITEM_WARLOCK_SKILLS_LVL_UP Scroll Level up all Warlock skills 1 SN_ITEM_BARD_SKILLS_LVL_UP Scroll Level up all Bard skills 1 SN_ITEM_CLERIC_SKILLS_LVL_UP Scroll Level up all Clieric skills 1 SN_ITEM_GM_ALL_EUR_SKILLS Scroll Level up all Europ skills for GM 1 SN_ITEM_WARRIOR_SKILLS_LVL_UP_TT_DESC TO use this scroll u have to be level 120 1 SN_ITEM_WIZZARD_SKILLS_LVL_UP_TT_DESC TO use this scroll u have to be level 120 1 SN_ITEM_ROGUE_SKILLS_LVL_UP_TT_DESC TO use this scroll u have to be level 120 1 SN_ITEM_WARLOCK_SKILLS_LVL_UP_TT_DESC TO use this scroll u have to be level 120 1 SN_ITEM_BARD_SKILLS_LVL_UP_TT_DESC TO use this scroll u have to be level 120 1 SN_ITEM_CLERIC_SKILLS_LVL_UP_TT_DESC TO use this scroll u have to be level 120 1 SN_ITEM_GM_ALL_EUR_SKILLS_TT_DESC TO use this scroll u have to be level 120
GM Skill Review
[YOUTUBE]_pt4nKiWez0[/YOUTUBE]
التعديل الأخير تم بواسطة HLP ; 20-02-2016 الساعة 09:20 AM
السبب: FINELY I MAKE PROCEDURE LEVEL UP SKILLS AND MASTERY WITH MASTERY LIMIT
المشاركة الأصلية كتبت بواسطة Hamza FiGo
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تمت الموفقه
تم تعديل اسم الموضوع والاضافة لتجميعة اسكرولات 2015
تسلم ايدك ^^. ياريت ترفع الايكونات علشان يكون موضوعك كامل
شكرا
و بكره حرفع الايكونات و جاري عمل فيديو
اقتباس:
المشاركة الأصلية كتبت بواسطة Dangers SrO
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تمام تسلم
كلمني دروري علي الفيس
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
وقولي اسمك ايه
^^
شكرا
انا رامي و حعملك ادد نهارده
اقتباس:
المشاركة الأصلية كتبت بواسطة Xan
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
مش شرط ال Mastery ١٢٠
انت ممكن تغيرو في البروسدر عشان في ناس هتتكلم
بس الله ينور مجهود رائع
شكرا
ده لفل 120 علشان البروسدر بيعمل max skills لحد لفل 120 مش 110 زي سكرول الصيني
بنسبة mastery ده سهل كل اللي عايز يغير لفل mastery
كل اللي حيعمله انه حيغير رقم 120 اللي موجود في
set @masteryid =120
لاي لفل 110 او 130
التعديل الأخير تم بواسطة Hamza FiGo ; 22-12-2015 الساعة 05:16 PM
السبب: تم دمج المشاركات
لو اتحطت في الان بي سي كدا السيرفر كله هيفتح كل الاسلحة وهتبقي (مليطة) ^^
اقتباس:
المشاركة الأصلية كتبت بواسطة Xan
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
انا هحاول أظبطها و احددها
مع احترامي ليكم بس انا محدد في بروسيدر mastery id بتاع كل سلاح ولازم علشان سكرول يشتغل لازم لاعب يرفع mastery يدوي علشان سكرول يشتغل يعني لو mastery كان اقل من 120 كدة سكرول ملوش لازمة تاني حاجة سكرول اللي بيفتح كل mastery و skills سكرول جي ام بس
كود PHP:
SET @MASTREYID = (SELECT Level FROM SRO_VT_SHARD.._CharSkillMastery WHERE CharID = @CharID AND MasteryID = 513)
IF @MASTREYID = (120)
كدة Mastery limit
التعديل الأخير تم بواسطة HLP ; 22-12-2015 الساعة 07:22 PM
المشاركة الأصلية كتبت بواسطة HLP
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
مع احترامي ليكم بس انا محدد في بروسيدر mastery id بتاع كل سلاح ولازم علشان سكرول يشتغل لازم لاعب يرفع mastery يدوي علشان سكرول يشتغل يعني لو mastery كان اقل من 120 كدة سكرول ملوش لازمة تاني حاجة سكرول اللي بيفتح كل mastery و skills سكرول جي ام بس
كود PHP:
SET @MASTREYID = (SELECT Level FROM SRO_VT_SHARD.._CharSkillMastery WHERE CharID = @CharID AND MasteryID = 513)
IF @MASTREYID = (120)
كدة Mastery limit
ياباشا مش دا القصد. القصد ان لو واحد اشتري كل الاسكرولات هيفتح كل الاسلحة والبفات
فية بروسيدر بقا لما حد بيجي يفتح كمان سلاح زيادة غير اللي مسموحله بيديلة رسالة يقوله لا مثلا
المشاركة الأصلية كتبت بواسطة Hamza FiGo
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
ياباشا مش دا القصد. القصد ان لو واحد اشتري كل الاسكرولات هيفتح كل الاسلحة والبفات
فية بروسيدر بقا لما حد بيجي يفتح كمان سلاح زيادة غير اللي مسموحله بيديلة رسالة يقوله لا مثلا
يا استاذ حمزة انت شوفت انا عمل بروسيدر ازاي انا عمله مش بيرفع mastery ده بيرفع skills بس و كمان برسيدور مش حيشتغل غير لما يكون mastery لفل 120 يعني انا حستعمل سكرول wizard لازم علشان سكرول يشتغل ان يكون لاعب رافع mastery بتاع wizard لحد لفل 120 و انت عارف ان mastery اوربي 240 يعني لو لاعب اشتري كل سكرول و هو مش رافع mastery مثلا wizard و bard و حاله دي مش حيشتغل معه غير سكرول wizard و سكرول bard ياريت تبوص علي برسيدور كويس و انا حرفع فيديو بيشرح ازاي سكرول بيشتغل