09-10-2011, 03:55 PM
I will be showing you how to add in higher skill levels for skills. For this example we will be adding in Dash level 6.
t_skill
Open t_skill search for Dash
SELECT * FROM t_skill WHERE a_name_mal_eng LIKE %Dash%
Ok, so your a_index for Dash is 401. Now we need to up its maximum skill level allowance to 6.
UPDATE t_skill SET a_maxLevel = 6 WHERE a_index = 401
t_skilllevel
Select a_index 401 from t_skilllevel
SELECT * FROM t_skilllevel WHERE a_index = 401
You will get 5 rows for levels 1-5 you will need to duplicate the last row (level 5) and paste it on a new line. Then go through and edit a_needMP, a_durtime, a_learnlevel, etc etc based on the skill info (ingame or a website). Your new row will look something like this.
401 6 0 200 130 0 -1 0 -1 0 98 1000 -1 0 -1 0 -1 0 19 2500000 -1 0 -1 0 -1 0 -1 0 -1 0 436 6 -1 0 -1 0 100 0 0 0 0
Note! Find and write down the magic_index from this table for your skill. We will need this index later. For dash it happens to be 436.
t_magic
Open t_magic search for a_index with the magic index value we got from the previous table (ie 436), and change a_maxlevel to 6
UPDATE t_magic SET a_maxlevel = 6 WHERE a_index = 436
t_magiclevel
Now you will need to duplicate again and add a new row in t_magiclevel. We are still using the same magic index that we got from t_skilllevel (ie 436).
SELECT * FROM t_magiclevel WHERE a_index = 436
Your new row will look something like this.
436 6 0 9000
a_hitrate works in 100 = 1% hitrate increments. Example 10000 = 100% hitrate. You can get the hitrate for skills off any 2.
All Creditz going to Warmonger
