Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
Mastery lvl up scrolls procedure Mastery lvl up scrolls procedure
You last visited: Today at 18:53

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Mastery lvl up scrolls procedure

Discussion on Mastery lvl up scrolls procedure within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
Hamza FiGo's Avatar
 
elite*gold: 150
The Black Market: 2/0/0
Join Date: Sep 2009
Posts: 987
Received Thanks: 258
Mastery lvl up scrolls procedure

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
Hamza FiGo is offline  
Old 12/27/2014, 18:59   #2
 
Hamza FiGo's Avatar
 
elite*gold: 150
The Black Market: 2/0/0
Join Date: Sep 2009
Posts: 987
Received Thanks: 258
Exclamation

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
Hamza FiGo is offline  
Old 12/27/2014, 20:42   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2014
Posts: 28
Received Thanks: 16
Add this to _Addlogitem at sro_vt_shardlog

It should work 100% press thanks if i helped
Aurora Online is offline  
Thanks
1 User
Old 12/27/2014, 21:48   #4
 
Hamza FiGo's Avatar
 
elite*gold: 150
The Black Market: 2/0/0
Join Date: Sep 2009
Posts: 987
Received Thanks: 258
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

PFF tried to make for sword only. see what i got
Hamza FiGo is offline  
Old 12/27/2014, 22:32   #5


 
​Exo's Avatar
 
elite*gold: 28
The Black Market: 33/0/0
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
Check LastThief's query it should help you!
​Exo is offline  
Old 12/27/2014, 22:43   #6
 
Hamza FiGo's Avatar
 
elite*gold: 150
The Black Market: 2/0/0
Join Date: Sep 2009
Posts: 987
Received Thanks: 258
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 )
Hamza FiGo is offline  
Reply

« i delete 1 Tablet from DB how i can get it back ? | Mbot proxy »

Similar Threads Similar Threads
Procedure
12/08/2014 - SRO Private Server - 2 Replies
resert skills > status > remove premium ? any one got right Procedure? ?
Dshop SQL procedure?
07/25/2009 - Dekaron Private Server - 6 Replies
Ok i want to use the Dshop but it asks for a password and then gives an error because i need to make a procedure in the DB. I have some knowledge of SQL but i need a help in hand if anyone could help?
Please giv me the right procedure of 10x dmg launcher..
05/19/2008 - RF Online - 5 Replies
Please:Help me to have a 10xdmg launcher pls i dont know or give me the exact procedure to do it.. Thanks to all Help me:D



All times are GMT +1. The time now is 18:53.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.