الموقع العربي الاول للعبة Silkroad Online - مشكلة في Scroll mastery

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

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

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

- - مشكلة في Scroll mastery (https://silkroad4arab.com/vb/showthread.php?t=601547)

BashA_Mn_Youme

06-05-2016 05:12 PM

مشكلة في Scroll mastery

انا ضفت الScroll بتاعت الاستاذ حمزة الي في الموضوع ده
http://www.silkroad4arab.com/vb/showthread.php?t=574838
هيا اشتغلت تمام المشكلة ان ان مفيهاش max mastery يعني يمكن اضربها لكول الاسكلات لكن انا عايز اخرها 520 mastery skill و كمان انا لما ضربتها اضربت للسيرفر كولو مش عارف ازاي :no::no::no::no::no::no::no::no::no:

Dev.Ri3o

07-05-2016 03:12 PM

رد: مشكلة في Scroll mastery

ال Max mastery ده انت تعدلو من ال SroClient و ال SR_GameServer عشان يعنى عدل على ال Masteries فى ال Server File و لما تيجى تضرب ال كذا Scroll هيقولك ان ال Max Masteries Full

Hamza FiGo

08-05-2016 02:14 AM

رد: مشكلة في Scroll mastery

هتزود علي البروسيدر حاجة زي كدة في كل اسكرول

where CharID=@CharID

BashA_Mn_Youme

08-05-2016 09:16 PM

رد: مشكلة في Scroll mastery

العيب مش من Sr_GameServer عشان انا ظابطو على 520 وهوا مبيقدرش يزود عن 520 فعلا مظبوطه المشكله انى لما بضربها على اى اكونت بتقراء على باقى الاكونتات
اكيد المشكله من البروسيدور

كود:

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 =520)  

Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())  

Begin 

IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) 

IF @CHARLEVEL = 130 

BEGIN 

IF @ItemRefID = '60147' 

BEGIN 

UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' WHERE MasteryID = 257   

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 =520)  

Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())  

Begin 

IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) 

IF @CHARLEVEL = 130 

BEGIN 

IF @ItemRefID = '60148' 

BEGIN 

UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' WHERE MasteryID = 258   

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 =520)  

Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())  

Begin 

IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) 

IF @CHARLEVEL = 130 

BEGIN 

IF @ItemRefID = '60149' 

BEGIN 

UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' WHERE MasteryID = 259   

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 =520)  

Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())  

Begin 

IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) 

IF @CHARLEVEL = 130 

BEGIN 

IF @ItemRefID = '60150' 

BEGIN 

UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' WHERE MasteryID = 273   

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 =520)  

Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())  

Begin 

IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) 

IF @CHARLEVEL = 130 

BEGIN 

IF @ItemRefID = '60151' 

BEGIN 

UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' WHERE MasteryID = 274   

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 =520)  

Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())  

Begin 

IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) 

IF @CHARLEVEL = 130 

BEGIN 

IF @ItemRefID = '60152' 

BEGIN 

UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' WHERE MasteryID = 275   

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 =520)  

Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())  

Begin 

IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) 

IF @CHARLEVEL = 130 

BEGIN 

IF @ItemRefID = '60153' 

BEGIN 

UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' WHERE MasteryID = 276   

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

انا شغال بالبروسيدور فى اليورب سليم المشكله فى الChina

HLP	08-05-2016 11:12 PM

رد: مشكلة في Scroll mastery

اتفضل

كود PHP:

IF (@Operation = 41 and @ItemRefID = '60147' ) --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 =520) and @ItemRefID = '60147' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 IF (@Operation = 41 and @ItemRefID = '60148' ) --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 =520) and @ItemRefID = '60148' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 IF (@Operation = 41 and @ItemRefID = '60149' ) --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 =520) and @ItemRefID = '60149' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 IF (@Operation = 41 and @ItemRefID = '60150' ) --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 =520) and @ItemRefID = '60150' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 IF (@Operation = 41 and @ItemRefID = '60151' ) --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 =520) and @ItemRefID = '60151' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 IF (@Operation = 41 and @ItemRefID = '60152' ) --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 =520) and @ItemRefID = '60152' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 IF (@Operation = 41 and @ItemRefID = '60153' ) --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 =520) and @ItemRefID = '60153' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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

BashA_Mn_Youme

09-05-2016 01:12 PM

رد: مشكلة في Scroll mastery

جاتلي المشكلة دي

كود:

Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 1203

Incorrect syntax near 'END'.

BashA_Mn_Youme

09-05-2016 02:33 PM

رد: مشكلة في Scroll mastery

انا ضفته يا باشا بس المشكلة ان انا لما بضرب اي scroll بينزل لوحدو Blade and bow and glaive and Cold ???

HLP	10-05-2016 10:55 AM

رد: مشكلة في Scroll mastery

اتفضل و انا مجربه

كود 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 =520) and @ItemRefID = '60147' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN IF @ItemRefID = '60147' begin UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 =520) and @ItemRefID = '60148' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN IF @ItemRefID = '60148' begin UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 =520) and @ItemRefID = '60149' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN IF @ItemRefID = '60149' begin UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 =520) and @ItemRefID = '60150' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN IF @ItemRefID = '60150' begin UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 =520) and @ItemRefID = '60151' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN IF @ItemRefID = '60151' begin UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 =520) and @ItemRefID = '60152' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN IF @ItemRefID = '60152' begin UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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 =520) and @ItemRefID = '60153' Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate()) Begin IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =520) IF @CHARLEVEL = 130 BEGIN IF @ItemRefID = '60153' begin UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '130' 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

BashA_Mn_Youme

10-05-2016 09:55 PM

رد: مشكلة في Scroll mastery

الف شكر يا معلم اشتغل

Dev.BigBear

13-05-2016 01:48 AM

رد: مشكلة في Scroll mastery

##

الساعة الآن 09:14 AM.

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