Mastery lvl up scrolls procedure

12/25/2014 15:31 Hamza FiGo#1
I made the procedure for all skills up,but cann`t make it right !

Code:
if(@JobID= '59705')
	BEGIN 
        DECLARE @CharName varchar(255) 
	Select @CharName16=CharName16 from _Char where CharID = @CharID 
	BEGIN 
	UPDATE _CharSkillMastery SET Level = '130' WHERE CharID=@CharID 

INSERT INTO _CharSkill VALUES (@CharID,1,1)  
INSERT INTO _CharSkill VALUES (@CharID,2,1)  
INSERT INTO _CharSkill VALUES (@CharID,40,1)  
INSERT INTO _CharSkill VALUES (@CharID,70,1)  
INSERT INTO _CharSkill VALUES (@CharID,298,1)  
INSERT INTO _CharSkill VALUES (@CharID,306,1)  
INSERT INTO _CharSkill VALUES (@CharID,314,1)  
INSERT INTO _CharSkill VALUES (@CharID,322,1)  
INSERT INTO _CharSkill VALUES (@CharID,346,1)  
INSERT INTO _CharSkill VALUES (@CharID,378,1)  
INSERT INTO _CharSkill VALUES (@CharID,418,1)  
INSERT INTO _CharSkill VALUES (@CharID,463,1)  
INSERT INTO _CharSkill VALUES (@CharID,558,1)  
INSERT INTO _CharSkill VALUES (@CharID,569,1)  
INSERT INTO _CharSkill VALUES (@CharID,580,1)  
INSERT INTO _CharSkill VALUES (@CharID,588,1)  
INSERT INTO _CharSkill VALUES (@CharID,596,1)  
INSERT INTO _CharSkill VALUES (@CharID,604,1)  
INSERT INTO _CharSkill VALUES (@CharID,647,1)  
INSERT INTO _CharSkill VALUES (@CharID,655,1)  
INSERT INTO _CharSkill VALUES (@CharID,672,1)  
INSERT INTO _CharSkill VALUES (@CharID,689,1)  
INSERT INTO _CharSkill VALUES (@CharID,699,1)  
INSERT INTO _CharSkill VALUES (@CharID,708,1)  
INSERT INTO _CharSkill VALUES (@CharID,716,1)  
INSERT INTO _CharSkill VALUES (@CharID,724,1)  
INSERT INTO _CharSkill VALUES (@CharID,735,1)  
INSERT INTO _CharSkill VALUES (@CharID,746,1)  
INSERT INTO _CharSkill VALUES (@CharID,757,1)  
INSERT INTO _CharSkill VALUES (@CharID,765,1)  
INSERT INTO _CharSkill VALUES (@CharID,773,1)  
INSERT INTO _CharSkill VALUES (@CharID,781,1)  
INSERT INTO _CharSkill VALUES (@CharID,789,1)  
INSERT INTO _CharSkill VALUES (@CharID,797,1)  
INSERT INTO _CharSkill VALUES (@CharID,805,1)  
INSERT INTO _CharSkill VALUES (@CharID,813,1)  
INSERT INTO _CharSkill VALUES (@CharID,821,1)  
INSERT INTO _CharSkill VALUES (@CharID,829,1)  
INSERT INTO _CharSkill VALUES (@CharID,853,1)  
INSERT INTO _CharSkill VALUES (@CharID,885,1)  
INSERT INTO _CharSkill VALUES (@CharID,925,1)  
INSERT INTO _CharSkill VALUES (@CharID,933,1)  
INSERT INTO _CharSkill VALUES (@CharID,943,1)  
INSERT INTO _CharSkill VALUES (@CharID,952,1)  
INSERT INTO _CharSkill VALUES (@CharID,960,1)  
INSERT INTO _CharSkill VALUES (@CharID,968,1)  
INSERT INTO _CharSkill VALUES (@CharID,976,1)  
INSERT INTO _CharSkill VALUES (@CharID,984,1)  
INSERT INTO _CharSkill VALUES (@CharID,992,1)  
INSERT INTO _CharSkill VALUES (@CharID,1003,1)  
INSERT INTO _CharSkill VALUES (@CharID,1014,1)  
INSERT INTO _CharSkill VALUES (@CharID,1025,1)  
INSERT INTO _CharSkill VALUES (@CharID,1033,1)  
INSERT INTO _CharSkill VALUES (@CharID,1041,1)  
INSERT INTO _CharSkill VALUES (@CharID,1049,1)  
INSERT INTO _CharSkill VALUES (@CharID,1053,1)  
INSERT INTO _CharSkill VALUES (@CharID,1057,1)  
INSERT INTO _CharSkill VALUES (@CharID,1065,1)  
INSERT INTO _CharSkill VALUES (@CharID,1073,1)  
INSERT INTO _CharSkill VALUES (@CharID,1081,1)  
INSERT INTO _CharSkill VALUES (@CharID,1089,1)  
INSERT INTO _CharSkill VALUES (@CharID,1099,1)  
INSERT INTO _CharSkill VALUES (@CharID,1108,1)  
INSERT INTO _CharSkill VALUES (@CharID,1116,1)  
INSERT INTO _CharSkill VALUES (@CharID,1124,1)  
INSERT INTO _CharSkill VALUES (@CharID,1132,1)  
INSERT INTO _CharSkill VALUES (@CharID,1140,1)  
INSERT INTO _CharSkill VALUES (@CharID,1148,1)  
INSERT INTO _CharSkill VALUES (@CharID,1153,1)  
INSERT INTO _CharSkill VALUES (@CharID,1158,1)  
INSERT INTO _CharSkill VALUES (@CharID,1163,1)  
INSERT INTO _CharSkill VALUES (@CharID,1168,1)  
INSERT INTO _CharSkill VALUES (@CharID,1173,1)  
INSERT INTO _CharSkill VALUES (@CharID,1178,1)  
INSERT INTO _CharSkill VALUES (@CharID,1189,1)  
INSERT INTO _CharSkill VALUES (@CharID,1200,1)  
INSERT INTO _CharSkill VALUES (@CharID,1217,1)  
INSERT INTO _CharSkill VALUES (@CharID,1234,1)  
INSERT INTO _CharSkill VALUES (@CharID,1244,1)  
INSERT INTO _CharSkill VALUES (@CharID,1253,1)  
INSERT INTO _CharSkill VALUES (@CharID,1261,1)  
INSERT INTO _CharSkill VALUES (@CharID,1269,1)  
INSERT INTO _CharSkill VALUES (@CharID,1271,1)  
INSERT INTO _CharSkill VALUES (@CharID,1273,1)  
INSERT INTO _CharSkill VALUES (@CharID,1275,1)  
INSERT INTO _CharSkill VALUES (@CharID,1286,1)  
INSERT INTO _CharSkill VALUES (@CharID,1297,1)  
INSERT INTO _CharSkill VALUES (@CharID,1308,1)  
INSERT INTO _CharSkill VALUES (@CharID,1316,1)  
INSERT INTO _CharSkill VALUES (@CharID,1324,1)  
INSERT INTO _CharSkill VALUES (@CharID,1332,1)  
INSERT INTO _CharSkill VALUES (@CharID,1337,1)  
INSERT INTO _CharSkill VALUES (@CharID,1342,1)  
INSERT INTO _CharSkill VALUES (@CharID,1350,1)  
INSERT INTO _CharSkill VALUES (@CharID,1358,1)  
INSERT INTO _CharSkill VALUES (@CharID,1368,1)  
INSERT INTO _CharSkill VALUES (@CharID,1377,1)  
INSERT INTO _CharSkill VALUES (@CharID,1385,1)  
INSERT INTO _CharSkill VALUES (@CharID,1393,1)  
INSERT INTO _CharSkill VALUES (@CharID,1398,1)  
INSERT INTO _CharSkill VALUES (@CharID,1403,1)  
INSERT INTO _CharSkill VALUES (@CharID,1408,1)  
INSERT INTO _CharSkill VALUES (@CharID,1410,1)  
INSERT INTO _CharSkill VALUES (@CharID,1412,1)  
INSERT INTO _CharSkill VALUES (@CharID,1414,1)  
INSERT INTO _CharSkill VALUES (@CharID,1422,1)  
INSERT INTO _CharSkill VALUES (@CharID,1430,1)  
INSERT INTO _CharSkill VALUES (@CharID,1438,1)  
INSERT INTO _CharSkill VALUES (@CharID,1443,1)  
INSERT INTO _CharSkill VALUES (@CharID,1448,1)  
INSERT INTO _CharSkill VALUES (@CharID,1465,1)  
INSERT INTO _CharSkill VALUES (@CharID,1482,1)  
INSERT INTO _CharSkill VALUES (@CharID,1499,1)  
INSERT INTO _CharSkill VALUES (@CharID,1509,1)  
INSERT INTO _CharSkill VALUES (@CharID,1518,1)  
INSERT INTO _CharSkill VALUES (@CharID,1526,1)  
INSERT INTO _CharSkill VALUES (@CharID,1534,1)  
INSERT INTO _CharSkill VALUES (@CharID,1539,1)  
INSERT INTO _CharSkill VALUES (@CharID,1544,1)  
INSERT INTO _CharSkill VALUES (@CharID,1549,1)  
INSERT INTO _CharSkill VALUES (@CharID,1557,1)  
INSERT INTO _CharSkill VALUES (@CharID,1565,1)  
INSERT INTO _CharSkill VALUES (@CharID,1573,1)  
INSERT INTO _CharSkill VALUES (@CharID,1578,1)  
INSERT INTO _CharSkill VALUES (@CharID,1583,1)  
INSERT INTO _CharSkill VALUES (@CharID,1588,1)  
INSERT INTO _CharSkill VALUES (@CharID,1593,1)  
INSERT INTO _CharSkill VALUES (@CharID,1598,1)  
INSERT INTO _CharSkill VALUES (@CharID,1609,1)  
INSERT INTO _CharSkill VALUES (@CharID,1617,1)  
INSERT INTO _CharSkill VALUES (@CharID,1628,1)  
INSERT INTO _CharSkill VALUES (@CharID,3149,1)  
INSERT INTO _CharSkill VALUES (@CharID,3167,1)  
INSERT INTO _CharSkill VALUES (@CharID,3176,1)  
INSERT INTO _CharSkill VALUES (@CharID,3224,1)  
INSERT INTO _CharSkill VALUES (@CharID,3340,1)  
INSERT INTO _CharSkill VALUES (@CharID,3349,1)  
INSERT INTO _CharSkill VALUES (@CharID,3364,1)  
INSERT INTO _CharSkill VALUES (@CharID,3379,1)  
INSERT INTO _CharSkill VALUES (@CharID,3391,1)  
INSERT INTO _CharSkill VALUES (@CharID,3406,1)  
INSERT INTO _CharSkill VALUES (@CharID,3409,1)  
INSERT INTO _CharSkill VALUES (@CharID,3415,1)  
INSERT INTO _CharSkill VALUES (@CharID,3430,1)  
INSERT INTO _CharSkill VALUES (@CharID,3431,1)  
INSERT INTO _CharSkill VALUES (@CharID,3446,1)  
INSERT INTO _CharSkill VALUES (@CharID,3461,1)  
INSERT INTO _CharSkill VALUES (@CharID,3467,1)  
INSERT INTO _CharSkill VALUES (@CharID,3473,1)  
INSERT INTO _CharSkill VALUES (@CharID,7139,1)  
INSERT INTO _CharSkill VALUES (@CharID,7159,1)  
INSERT INTO _CharSkill VALUES (@CharID,7203,1)  
INSERT INTO _CharSkill VALUES (@CharID,7322,1)  
INSERT INTO _CharSkill VALUES (@CharID,7385,1)  
INSERT INTO _CharSkill VALUES (@CharID,7390,1)  
INSERT INTO _CharSkill VALUES (@CharID,7392,1)  
INSERT INTO _CharSkill VALUES (@CharID,7404,1)  
INSERT INTO _CharSkill VALUES (@CharID,7418,1)  
INSERT INTO _CharSkill VALUES (@CharID,7474,1)  
INSERT INTO _CharSkill VALUES (@CharID,7484,1)  
INSERT INTO _CharSkill VALUES (@CharID,7513,1)  
INSERT INTO _CharSkill VALUES (@CharID,7520,1)  
INSERT INTO _CharSkill VALUES (@CharID,7536,1)  
INSERT INTO _CharSkill VALUES (@CharID,7554,1)  
INSERT INTO _CharSkill VALUES (@CharID,7577,1)  
INSERT INTO _CharSkill VALUES (@CharID,7582,1)  
INSERT INTO _CharSkill VALUES (@CharID,7584,1)  
INSERT INTO _CharSkill VALUES (@CharID,7596,1)  
INSERT INTO _CharSkill VALUES (@CharID,7612,1)  
INSERT INTO _CharSkill VALUES (@CharID,7637,1)  
INSERT INTO _CharSkill VALUES (@CharID,7651,1)  
INSERT INTO _CharSkill VALUES (@CharID,7672,1)  
INSERT INTO _CharSkill VALUES (@CharID,7675,1)  
INSERT INTO _CharSkill VALUES (@CharID,7688,1)  
INSERT INTO _CharSkill VALUES (@CharID,7798,1)  
INSERT INTO _CharSkill VALUES (@CharID,7805,1)  
INSERT INTO _CharSkill VALUES (@CharID,7829,1)  
INSERT INTO _CharSkill VALUES (@CharID,7838,1)  
INSERT INTO _CharSkill VALUES (@CharID,7839,1)  
INSERT INTO _CharSkill VALUES (@CharID,7853,1)  
INSERT INTO _CharSkill VALUES (@CharID,7862,1)  
INSERT INTO _CharSkill VALUES (@CharID,7877,1)  
INSERT INTO _CharSkill VALUES (@CharID,7881,1)  
INSERT INTO _CharSkill VALUES (@CharID,7894,1)  
INSERT INTO _CharSkill VALUES (@CharID,7899,1)  
INSERT INTO _CharSkill VALUES (@CharID,7907,1)  
INSERT INTO _CharSkill VALUES (@CharID,7919,1)  
INSERT INTO _CharSkill VALUES (@CharID,7931,1)  
INSERT INTO _CharSkill VALUES (@CharID,7938,1)  
INSERT INTO _CharSkill VALUES (@CharID,7947,1)  
INSERT INTO _CharSkill VALUES (@CharID,7953,1)  
INSERT INTO _CharSkill VALUES (@CharID,7959,1)  
INSERT INTO _CharSkill VALUES (@CharID,7962,1)  
INSERT INTO _CharSkill VALUES (@CharID,7972,1)  
INSERT INTO _CharSkill VALUES (@CharID,7980,1)  
INSERT INTO _CharSkill VALUES (@CharID,7995,1)  
INSERT INTO _CharSkill VALUES (@CharID,7997,1)  
INSERT INTO _CharSkill VALUES (@CharID,8010,1)  
INSERT INTO _CharSkill VALUES (@CharID,8024,1)  
INSERT INTO _CharSkill VALUES (@CharID,8050,1)  
INSERT INTO _CharSkill VALUES (@CharID,8084,1)  
INSERT INTO _CharSkill VALUES (@CharID,8097,1)  
INSERT INTO _CharSkill VALUES (@CharID,8103,1)  
INSERT INTO _CharSkill VALUES (@CharID,8109,1)  
INSERT INTO _CharSkill VALUES (@CharID,8115,1)  
INSERT INTO _CharSkill VALUES (@CharID,8119,1)  
INSERT INTO _CharSkill VALUES (@CharID,8129,1)  
INSERT INTO _CharSkill VALUES (@CharID,8133,1)  
INSERT INTO _CharSkill VALUES (@CharID,8142,1)  
INSERT INTO _CharSkill VALUES (@CharID,8150,1)  
INSERT INTO _CharSkill VALUES (@CharID,8164,1)  
INSERT INTO _CharSkill VALUES (@CharID,8171,1)  
INSERT INTO _CharSkill VALUES (@CharID,8183,1)  
INSERT INTO _CharSkill VALUES (@CharID,8195,1)  
INSERT INTO _CharSkill VALUES (@CharID,8204,1)  
INSERT INTO _CharSkill VALUES (@CharID,8214,1)  
INSERT INTO _CharSkill VALUES (@CharID,8220,1)  
INSERT INTO _CharSkill VALUES (@CharID,8221,1)  
INSERT INTO _CharSkill VALUES (@CharID,8238,1)  
INSERT INTO _CharSkill VALUES (@CharID,8239,1)  
INSERT INTO _CharSkill VALUES (@CharID,8250,1)  
INSERT INTO _CharSkill VALUES (@CharID,8253,1)  
INSERT INTO _CharSkill VALUES (@CharID,8276,1)  
INSERT INTO _CharSkill VALUES (@CharID,8291,1)  
INSERT INTO _CharSkill VALUES (@CharID,8304,1)  
INSERT INTO _CharSkill VALUES (@CharID,8316,1)  
INSERT INTO _CharSkill VALUES (@CharID,8320,1)  
INSERT INTO _CharSkill VALUES (@CharID,8338,1)  
INSERT INTO _CharSkill VALUES (@CharID,8347,1)  
INSERT INTO _CharSkill VALUES (@CharID,8348,1)  
INSERT INTO _CharSkill VALUES (@CharID,8361,1)  
INSERT INTO _CharSkill VALUES (@CharID,8370,1)  
INSERT INTO _CharSkill VALUES (@CharID,8379,1)  
INSERT INTO _CharSkill VALUES (@CharID,8383,1)  
INSERT INTO _CharSkill VALUES (@CharID,8390,1)  
INSERT INTO _CharSkill VALUES (@CharID,8399,1)  
INSERT INTO _CharSkill VALUES (@CharID,8405,1)  
INSERT INTO _CharSkill VALUES (@CharID,8410,1)  
INSERT INTO _CharSkill VALUES (@CharID,8414,1)  
INSERT INTO _CharSkill VALUES (@CharID,8416,1)  
INSERT INTO _CharSkill VALUES (@CharID,20494,1)  
INSERT INTO _CharSkill VALUES (@CharID,20497,1)  
INSERT INTO _CharSkill VALUES (@CharID,20500,1)  
INSERT INTO _CharSkill VALUES (@CharID,21215,1)  
INSERT INTO _CharSkill VALUES (@CharID,21217,1)  
INSERT INTO _CharSkill VALUES (@CharID,30578,1)  
INSERT INTO _CharSkill VALUES (@CharID,30584,1)  
INSERT INTO _CharSkill VALUES (@CharID,30590,1)  
INSERT INTO _CharSkill VALUES (@CharID,30596,1)  
INSERT INTO _CharSkill VALUES (@CharID,30600,1)  
	end
	end
12/27/2014 18:59 Hamza FiGo#2
This is the procedure to up all skills. But i cann`t make it right. idk why !!

Code:
if(@JobID= '59705')
	BEGIN 
        DECLARE @CharName varchar(255) 
	Select @CharName16=CharName16 from _Char where CharID = @CharID 
	BEGIN 
	UPDATE _CharSkillMastery SET Level = '130' WHERE CharID=@CharID 

INSERT INTO _CharSkill VALUES (@CharID,1,1)  
INSERT INTO _CharSkill VALUES (@CharID,2,1)  
INSERT INTO _CharSkill VALUES (@CharID,40,1)  
INSERT INTO _CharSkill VALUES (@CharID,70,1)  
INSERT INTO _CharSkill VALUES (@CharID,298,1)  
INSERT INTO _CharSkill VALUES (@CharID,306,1)  
INSERT INTO _CharSkill VALUES (@CharID,314,1)  
INSERT INTO _CharSkill VALUES (@CharID,322,1)  
INSERT INTO _CharSkill VALUES (@CharID,346,1)  
INSERT INTO _CharSkill VALUES (@CharID,378,1)  
INSERT INTO _CharSkill VALUES (@CharID,418,1)  
INSERT INTO _CharSkill VALUES (@CharID,463,1)  
INSERT INTO _CharSkill VALUES (@CharID,558,1)  
INSERT INTO _CharSkill VALUES (@CharID,569,1)  
INSERT INTO _CharSkill VALUES (@CharID,580,1)  
INSERT INTO _CharSkill VALUES (@CharID,588,1)  
INSERT INTO _CharSkill VALUES (@CharID,596,1)  
INSERT INTO _CharSkill VALUES (@CharID,604,1)  
INSERT INTO _CharSkill VALUES (@CharID,647,1)  
INSERT INTO _CharSkill VALUES (@CharID,655,1)  
INSERT INTO _CharSkill VALUES (@CharID,672,1)  
INSERT INTO _CharSkill VALUES (@CharID,689,1)  
INSERT INTO _CharSkill VALUES (@CharID,699,1)  
INSERT INTO _CharSkill VALUES (@CharID,708,1)  
INSERT INTO _CharSkill VALUES (@CharID,716,1)  
INSERT INTO _CharSkill VALUES (@CharID,724,1)  
INSERT INTO _CharSkill VALUES (@CharID,735,1)  
INSERT INTO _CharSkill VALUES (@CharID,746,1)  
INSERT INTO _CharSkill VALUES (@CharID,757,1)  
INSERT INTO _CharSkill VALUES (@CharID,765,1)  
INSERT INTO _CharSkill VALUES (@CharID,773,1)  
INSERT INTO _CharSkill VALUES (@CharID,781,1)  
INSERT INTO _CharSkill VALUES (@CharID,789,1)  
INSERT INTO _CharSkill VALUES (@CharID,797,1)  
INSERT INTO _CharSkill VALUES (@CharID,805,1)  
INSERT INTO _CharSkill VALUES (@CharID,813,1)  
INSERT INTO _CharSkill VALUES (@CharID,821,1)  
INSERT INTO _CharSkill VALUES (@CharID,829,1)  
INSERT INTO _CharSkill VALUES (@CharID,853,1)  
INSERT INTO _CharSkill VALUES (@CharID,885,1)  
INSERT INTO _CharSkill VALUES (@CharID,925,1)  
INSERT INTO _CharSkill VALUES (@CharID,933,1)  
INSERT INTO _CharSkill VALUES (@CharID,943,1)  
INSERT INTO _CharSkill VALUES (@CharID,952,1)  
INSERT INTO _CharSkill VALUES (@CharID,960,1)  
INSERT INTO _CharSkill VALUES (@CharID,968,1)  
INSERT INTO _CharSkill VALUES (@CharID,976,1)  
INSERT INTO _CharSkill VALUES (@CharID,984,1)  
INSERT INTO _CharSkill VALUES (@CharID,992,1)  
INSERT INTO _CharSkill VALUES (@CharID,1003,1)  
INSERT INTO _CharSkill VALUES (@CharID,1014,1)  
INSERT INTO _CharSkill VALUES (@CharID,1025,1)  
INSERT INTO _CharSkill VALUES (@CharID,1033,1)  
INSERT INTO _CharSkill VALUES (@CharID,1041,1)  
INSERT INTO _CharSkill VALUES (@CharID,1049,1)  
INSERT INTO _CharSkill VALUES (@CharID,1053,1)  
INSERT INTO _CharSkill VALUES (@CharID,1057,1)  
INSERT INTO _CharSkill VALUES (@CharID,1065,1)  
INSERT INTO _CharSkill VALUES (@CharID,1073,1)  
INSERT INTO _CharSkill VALUES (@CharID,1081,1)  
INSERT INTO _CharSkill VALUES (@CharID,1089,1)  
INSERT INTO _CharSkill VALUES (@CharID,1099,1)  
INSERT INTO _CharSkill VALUES (@CharID,1108,1)  
INSERT INTO _CharSkill VALUES (@CharID,1116,1)  
INSERT INTO _CharSkill VALUES (@CharID,1124,1)  
INSERT INTO _CharSkill VALUES (@CharID,1132,1)  
INSERT INTO _CharSkill VALUES (@CharID,1140,1)  
INSERT INTO _CharSkill VALUES (@CharID,1148,1)  
INSERT INTO _CharSkill VALUES (@CharID,1153,1)  
INSERT INTO _CharSkill VALUES (@CharID,1158,1)  
INSERT INTO _CharSkill VALUES (@CharID,1163,1)  
INSERT INTO _CharSkill VALUES (@CharID,1168,1)  
INSERT INTO _CharSkill VALUES (@CharID,1173,1)  
INSERT INTO _CharSkill VALUES (@CharID,1178,1)  
INSERT INTO _CharSkill VALUES (@CharID,1189,1)  
INSERT INTO _CharSkill VALUES (@CharID,1200,1)  
INSERT INTO _CharSkill VALUES (@CharID,1217,1)  
INSERT INTO _CharSkill VALUES (@CharID,1234,1)  
INSERT INTO _CharSkill VALUES (@CharID,1244,1)  
INSERT INTO _CharSkill VALUES (@CharID,1253,1)  
INSERT INTO _CharSkill VALUES (@CharID,1261,1)  
INSERT INTO _CharSkill VALUES (@CharID,1269,1)  
INSERT INTO _CharSkill VALUES (@CharID,1271,1)  
INSERT INTO _CharSkill VALUES (@CharID,1273,1)  
INSERT INTO _CharSkill VALUES (@CharID,1275,1)  
INSERT INTO _CharSkill VALUES (@CharID,1286,1)  
INSERT INTO _CharSkill VALUES (@CharID,1297,1)  
INSERT INTO _CharSkill VALUES (@CharID,1308,1)  
INSERT INTO _CharSkill VALUES (@CharID,1316,1)  
INSERT INTO _CharSkill VALUES (@CharID,1324,1)  
INSERT INTO _CharSkill VALUES (@CharID,1332,1)  
INSERT INTO _CharSkill VALUES (@CharID,1337,1)  
INSERT INTO _CharSkill VALUES (@CharID,1342,1)  
INSERT INTO _CharSkill VALUES (@CharID,1350,1)  
INSERT INTO _CharSkill VALUES (@CharID,1358,1)  
INSERT INTO _CharSkill VALUES (@CharID,1368,1)  
INSERT INTO _CharSkill VALUES (@CharID,1377,1)  
INSERT INTO _CharSkill VALUES (@CharID,1385,1)  
INSERT INTO _CharSkill VALUES (@CharID,1393,1)  
INSERT INTO _CharSkill VALUES (@CharID,1398,1)  
INSERT INTO _CharSkill VALUES (@CharID,1403,1)  
INSERT INTO _CharSkill VALUES (@CharID,1408,1)  
INSERT INTO _CharSkill VALUES (@CharID,1410,1)  
INSERT INTO _CharSkill VALUES (@CharID,1412,1)  
INSERT INTO _CharSkill VALUES (@CharID,1414,1)  
INSERT INTO _CharSkill VALUES (@CharID,1422,1)  
INSERT INTO _CharSkill VALUES (@CharID,1430,1)  
INSERT INTO _CharSkill VALUES (@CharID,1438,1)  
INSERT INTO _CharSkill VALUES (@CharID,1443,1)  
INSERT INTO _CharSkill VALUES (@CharID,1448,1)  
INSERT INTO _CharSkill VALUES (@CharID,1465,1)  
INSERT INTO _CharSkill VALUES (@CharID,1482,1)  
INSERT INTO _CharSkill VALUES (@CharID,1499,1)  
INSERT INTO _CharSkill VALUES (@CharID,1509,1)  
INSERT INTO _CharSkill VALUES (@CharID,1518,1)  
INSERT INTO _CharSkill VALUES (@CharID,1526,1)  
INSERT INTO _CharSkill VALUES (@CharID,1534,1)  
INSERT INTO _CharSkill VALUES (@CharID,1539,1)  
INSERT INTO _CharSkill VALUES (@CharID,1544,1)  
INSERT INTO _CharSkill VALUES (@CharID,1549,1)  
INSERT INTO _CharSkill VALUES (@CharID,1557,1)  
INSERT INTO _CharSkill VALUES (@CharID,1565,1)  
INSERT INTO _CharSkill VALUES (@CharID,1573,1)  
INSERT INTO _CharSkill VALUES (@CharID,1578,1)  
INSERT INTO _CharSkill VALUES (@CharID,1583,1)  
INSERT INTO _CharSkill VALUES (@CharID,1588,1)  
INSERT INTO _CharSkill VALUES (@CharID,1593,1)  
INSERT INTO _CharSkill VALUES (@CharID,1598,1)  
INSERT INTO _CharSkill VALUES (@CharID,1609,1)  
INSERT INTO _CharSkill VALUES (@CharID,1617,1)  
INSERT INTO _CharSkill VALUES (@CharID,1628,1)  
INSERT INTO _CharSkill VALUES (@CharID,3149,1)  
INSERT INTO _CharSkill VALUES (@CharID,3167,1)  
INSERT INTO _CharSkill VALUES (@CharID,3176,1)  
INSERT INTO _CharSkill VALUES (@CharID,3224,1)  
INSERT INTO _CharSkill VALUES (@CharID,3340,1)  
INSERT INTO _CharSkill VALUES (@CharID,3349,1)  
INSERT INTO _CharSkill VALUES (@CharID,3364,1)  
INSERT INTO _CharSkill VALUES (@CharID,3379,1)  
INSERT INTO _CharSkill VALUES (@CharID,3391,1)  
INSERT INTO _CharSkill VALUES (@CharID,3406,1)  
INSERT INTO _CharSkill VALUES (@CharID,3409,1)  
INSERT INTO _CharSkill VALUES (@CharID,3415,1)  
INSERT INTO _CharSkill VALUES (@CharID,3430,1)  
INSERT INTO _CharSkill VALUES (@CharID,3431,1)  
INSERT INTO _CharSkill VALUES (@CharID,3446,1)  
INSERT INTO _CharSkill VALUES (@CharID,3461,1)  
INSERT INTO _CharSkill VALUES (@CharID,3467,1)  
INSERT INTO _CharSkill VALUES (@CharID,3473,1)  
INSERT INTO _CharSkill VALUES (@CharID,7139,1)  
INSERT INTO _CharSkill VALUES (@CharID,7159,1)  
INSERT INTO _CharSkill VALUES (@CharID,7203,1)  
INSERT INTO _CharSkill VALUES (@CharID,7322,1)  
INSERT INTO _CharSkill VALUES (@CharID,7385,1)  
INSERT INTO _CharSkill VALUES (@CharID,7390,1)  
INSERT INTO _CharSkill VALUES (@CharID,7392,1)  
INSERT INTO _CharSkill VALUES (@CharID,7404,1)  
INSERT INTO _CharSkill VALUES (@CharID,7418,1)  
INSERT INTO _CharSkill VALUES (@CharID,7474,1)  
INSERT INTO _CharSkill VALUES (@CharID,7484,1)  
INSERT INTO _CharSkill VALUES (@CharID,7513,1)  
INSERT INTO _CharSkill VALUES (@CharID,7520,1)  
INSERT INTO _CharSkill VALUES (@CharID,7536,1)  
INSERT INTO _CharSkill VALUES (@CharID,7554,1)  
INSERT INTO _CharSkill VALUES (@CharID,7577,1)  
INSERT INTO _CharSkill VALUES (@CharID,7582,1)  
INSERT INTO _CharSkill VALUES (@CharID,7584,1)  
INSERT INTO _CharSkill VALUES (@CharID,7596,1)  
INSERT INTO _CharSkill VALUES (@CharID,7612,1)  
INSERT INTO _CharSkill VALUES (@CharID,7637,1)  
INSERT INTO _CharSkill VALUES (@CharID,7651,1)  
INSERT INTO _CharSkill VALUES (@CharID,7672,1)  
INSERT INTO _CharSkill VALUES (@CharID,7675,1)  
INSERT INTO _CharSkill VALUES (@CharID,7688,1)  
INSERT INTO _CharSkill VALUES (@CharID,7798,1)  
INSERT INTO _CharSkill VALUES (@CharID,7805,1)  
INSERT INTO _CharSkill VALUES (@CharID,7829,1)  
INSERT INTO _CharSkill VALUES (@CharID,7838,1)  
INSERT INTO _CharSkill VALUES (@CharID,7839,1)  
INSERT INTO _CharSkill VALUES (@CharID,7853,1)  
INSERT INTO _CharSkill VALUES (@CharID,7862,1)  
INSERT INTO _CharSkill VALUES (@CharID,7877,1)  
INSERT INTO _CharSkill VALUES (@CharID,7881,1)  
INSERT INTO _CharSkill VALUES (@CharID,7894,1)  
INSERT INTO _CharSkill VALUES (@CharID,7899,1)  
INSERT INTO _CharSkill VALUES (@CharID,7907,1)  
INSERT INTO _CharSkill VALUES (@CharID,7919,1)  
INSERT INTO _CharSkill VALUES (@CharID,7931,1)  
INSERT INTO _CharSkill VALUES (@CharID,7938,1)  
INSERT INTO _CharSkill VALUES (@CharID,7947,1)  
INSERT INTO _CharSkill VALUES (@CharID,7953,1)  
INSERT INTO _CharSkill VALUES (@CharID,7959,1)  
INSERT INTO _CharSkill VALUES (@CharID,7962,1)  
INSERT INTO _CharSkill VALUES (@CharID,7972,1)  
INSERT INTO _CharSkill VALUES (@CharID,7980,1)  
INSERT INTO _CharSkill VALUES (@CharID,7995,1)  
INSERT INTO _CharSkill VALUES (@CharID,7997,1)  
INSERT INTO _CharSkill VALUES (@CharID,8010,1)  
INSERT INTO _CharSkill VALUES (@CharID,8024,1)  
INSERT INTO _CharSkill VALUES (@CharID,8050,1)  
INSERT INTO _CharSkill VALUES (@CharID,8084,1)  
INSERT INTO _CharSkill VALUES (@CharID,8097,1)  
INSERT INTO _CharSkill VALUES (@CharID,8103,1)  
INSERT INTO _CharSkill VALUES (@CharID,8109,1)  
INSERT INTO _CharSkill VALUES (@CharID,8115,1)  
INSERT INTO _CharSkill VALUES (@CharID,8119,1)  
INSERT INTO _CharSkill VALUES (@CharID,8129,1)  
INSERT INTO _CharSkill VALUES (@CharID,8133,1)  
INSERT INTO _CharSkill VALUES (@CharID,8142,1)  
INSERT INTO _CharSkill VALUES (@CharID,8150,1)  
INSERT INTO _CharSkill VALUES (@CharID,8164,1)  
INSERT INTO _CharSkill VALUES (@CharID,8171,1)  
INSERT INTO _CharSkill VALUES (@CharID,8183,1)  
INSERT INTO _CharSkill VALUES (@CharID,8195,1)  
INSERT INTO _CharSkill VALUES (@CharID,8204,1)  
INSERT INTO _CharSkill VALUES (@CharID,8214,1)  
INSERT INTO _CharSkill VALUES (@CharID,8220,1)  
INSERT INTO _CharSkill VALUES (@CharID,8221,1)  
INSERT INTO _CharSkill VALUES (@CharID,8238,1)  
INSERT INTO _CharSkill VALUES (@CharID,8239,1)  
INSERT INTO _CharSkill VALUES (@CharID,8250,1)  
INSERT INTO _CharSkill VALUES (@CharID,8253,1)  
INSERT INTO _CharSkill VALUES (@CharID,8276,1)  
INSERT INTO _CharSkill VALUES (@CharID,8291,1)  
INSERT INTO _CharSkill VALUES (@CharID,8304,1)  
INSERT INTO _CharSkill VALUES (@CharID,8316,1)  
INSERT INTO _CharSkill VALUES (@CharID,8320,1)  
INSERT INTO _CharSkill VALUES (@CharID,8338,1)  
INSERT INTO _CharSkill VALUES (@CharID,8347,1)  
INSERT INTO _CharSkill VALUES (@CharID,8348,1)  
INSERT INTO _CharSkill VALUES (@CharID,8361,1)  
INSERT INTO _CharSkill VALUES (@CharID,8370,1)  
INSERT INTO _CharSkill VALUES (@CharID,8379,1)  
INSERT INTO _CharSkill VALUES (@CharID,8383,1)  
INSERT INTO _CharSkill VALUES (@CharID,8390,1)  
INSERT INTO _CharSkill VALUES (@CharID,8399,1)  
INSERT INTO _CharSkill VALUES (@CharID,8405,1)  
INSERT INTO _CharSkill VALUES (@CharID,8410,1)  
INSERT INTO _CharSkill VALUES (@CharID,8414,1)  
INSERT INTO _CharSkill VALUES (@CharID,8416,1)  
INSERT INTO _CharSkill VALUES (@CharID,20494,1)  
INSERT INTO _CharSkill VALUES (@CharID,20497,1)  
INSERT INTO _CharSkill VALUES (@CharID,20500,1)  
INSERT INTO _CharSkill VALUES (@CharID,21215,1)  
INSERT INTO _CharSkill VALUES (@CharID,21217,1)  
INSERT INTO _CharSkill VALUES (@CharID,30578,1)  
INSERT INTO _CharSkill VALUES (@CharID,30584,1)  
INSERT INTO _CharSkill VALUES (@CharID,30590,1)  
INSERT INTO _CharSkill VALUES (@CharID,30596,1)  
INSERT INTO _CharSkill VALUES (@CharID,30600,1)  
	end
	end
12/27/2014 20:42 Aurora Online#3
Add this to _Addlogitem at sro_vt_shardlog :)

It should work 100% :) press thanks if i helped
12/27/2014 21:48 Hamza FiGo#4
Quote:
Originally Posted by Aurora Online View Post
Add this to _Addlogitem at sro_vt_shardlog :)

It should work 100% :) press thanks if i helped
Thanks for replaying Aurora. I gonna try it. Sec

Edit: Worked 100% for ALL skills. Now i gonna make it for each build cus i cann`t ask u for something like that. :)

Ty [Only registered and activated users can see links. Click Here To Register...]

PFF tried to make for sword only. see what i got

[Only registered and activated users can see links. Click Here To Register...]
12/27/2014 22:32 ​Exo#5
Check LastThief's query it should help you!
12/27/2014 22:43 Hamza FiGo#6
Quote:
Originally Posted by xExorcist View Post
Check LastThief's query it should help you!
Sry, where it is ?

Edit. Thnx nearly done.

***********
Last Question
***********

I made the scrolls and worked 100%. But i can up all skills in 1 char. All skills (cold-fire-light-force-sword-spear-bow)

How can i make a limit? I mean for CHN 3 builds only ( Sword-Cold-Fire )