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

مشاهدة النسخة كاملة : مشكلة كبيرة في الmastry

Mohamed ElKersh

21-02-2016, 10:40 AM

HLP

21-02-2016, 11:53 AM

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

ان المستري بتاعي 330 المفرود يعمل 3 اسكروللات و يقولك خلاص لا ده بيعمل 4 و 5 ]: يعني كل الاسكلات بتتفتح انا عندي بيبقا 550/330 لما اضربهم :]

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

Chinese skills level up Procedure with mastery limit

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

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

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

Mohamed ElKersh

21-02-2016, 12:41 PM

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

Chinese skills level up Procedure with mastery limit

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

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

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

مش شغاال نهائي يا باشا

HLP

21-02-2016, 12:44 PM

مش شغاال نهائي يا باشا

يعني ايه مش شغال ممكن توضح كلامك

Mohamed ElKersh

21-02-2016, 12:48 PM

HLP

21-02-2016, 12:59 PM

ايه ده ؟

Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 173
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 174
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 175
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 176
Must declare the scalar variable "@charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 178
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 179
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 227
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 228
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 229
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 230
Must declare the scalar variable "@charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 232
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 233
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 279
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 280
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 281
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 282
Must declare the scalar variable "@charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 284
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 285
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 332
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 333
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 334
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 335
Must declare the scalar variable "@charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 337
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 338
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 381
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 382
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 383
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 384
Must declare the scalar variable "@charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 386
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 387
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 425
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 426
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 427
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 428
Must declare the scalar variable "@charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 430
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 431
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 475
Must declare the scalar variable "@CHARLEVEL".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 476
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 477
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 478
Must declare the scalar variable "@charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 480
Must declare the scalar variable "@TotalMasteryLEVEL".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 481
Must declare the scalar variable "@CHARLEVEL".

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

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

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

لو حطط الاوربي و الصيني مع بعض استعمل اللي فوق

Mohamed ElKersh

21-02-2016, 01:09 PM

مش بترفع حاجة لما بحط بتااع حمزة بتشتغل عادي بس مفيش limt

Mohamed ElKersh

21-02-2016, 01:16 PM

الصيني تمام لاكن الاوروبي مفهوش ليميت

HLP

21-02-2016, 01:51 PM

تم الحل بطريقتي بس في مشكلة انا حليت الليمت في الصيني تمام لاكن في الاوروبي مفيش ليميت
انت حليت limit في الصيني لوحدك للتوضيح بس limit mastery ده انا اللي عمله و مفيش حد عمله قبل كده
و ممكن بكرا او بعده تقول انا اللي عامل system كمان
>بطريقتك خلاص يبقي انت مش عايز مساعدة<
##

Mohamed ElKersh

21-02-2016, 02:00 PM

انت حليت limit في الصيني لوحدك للتوضيح بس limit mastery ده انا اللي عمله و مفيش حد عمله قبل كده
و ممكن بكرا او بعده تقول انا اللي عامل system كمان
>بطريقتك خلاص يبقي انت مش عايز مساعدة<
##

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

بص بص مدام ده هيزعلك اقفل الموضوع كله

##

HLP

21-02-2016, 02:08 PM

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

انا دلواقتي الليميت بتااع الصيني تمام لاكن الاوروبي مش عاوز يظبط

مش مشكلة عادي

سيرفر عندك 110 صح

اوربي 110 شغال 100%
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 =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42092
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' 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 =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42093
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' 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 =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42094
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' 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 =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
IF @ItemRefID = 42095
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' 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 =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42096
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' 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 =220)
Insert Into iLegend_Tool.._SendPrivateChat Values (1,@charname,'Your Mastery Level Is Max',Getdate())
Begin
IF NOT exists ( SELECT @TotalMasteryLEVEL WHERE @TotalMasteryLEVEL =220)
IF @CHARLEVEL = 110
BEGIN
IF @ItemRefID = 42097
BEGIN
UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '110' 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 = '110' 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

Mohamed ElKersh

21-02-2016, 02:35 PM

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

HLP

21-02-2016, 02:41 PM

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

حبيبي انا مش زعلان

HLP

21-02-2016, 03:21 PM

جرب اخر برسيدور في الموضوع و حيشتغل معك انا عدلت علي limit علشان يكون لفل 110

Mohamed ElKersh

22-02-2016, 10:12 AM

جرب اخر برسيدور في الموضوع و حيشتغل معك انا عدلت علي limit علشان يكون لفل 110

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

يغلق

HLP

22-02-2016, 10:40 AM

زي ما انت عايز بس علي عموم اخر برسيدور هو حل المشكلة
##