+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep2 Guides (https://lckb.dev/forum/forumdisplay.php?fid=165)
+----- Thread: Free Skills (/showthread.php?tid=2356)
- GuXz - 08-31-2013
Hi all,
In my first guide I help you to have free skills in Learn NPC (in database and game in Learn NPC).
Im not well in english so sry for faults
I have put screens in all step 
MYSQL :
For start, execute that query in newproject_data.
UPDATE t_skillLevel SET a_needItemIndex1 = "-1";
UPDATE t_skillLevel SET a_needItemCount1 = "0";
UPDATE t_skillLevel SET a_needItemIndex2 = "-1";
UPDATE t_skillLevel SET a_needItemCount2 = "0";
UPDATE t_skillLevel SET a_learnSP = "0";
UPDATE t_skillLevel SET a_learnItemIndex1 = "-1";
UPDATE t_skillLevel SET a_learnItemCount1 = "0";
UPDATE t_skillLevel SET a_learnItemIndex2 = "-1";
UPDATE t_skillLevel SET a_learnItemCount2 = "0";
UPDATE t_skillLevel SET a_learnItemIndex3 = "-1";
UPDATE t_skillLevel SET a_learnItemCount3 = "0";
With navicat :
After restart your gameserver, all skills are free to learn in database and when you learn BUT for client its not same (in visual and in requied items to learn).
You see again items needed in NPC Learn like (858 SP - 1 Book Offence posture - 500 000 000 gold)
And you need to have all items needed by skill with client files for learn but you have always item after have learn (book, sp, gold are same before and after but without you cant learn the skill)
So for set this you need to edit skill_usa.bin with Skill Editor 3 from Wizatek.
Step 1 :
Configure Skill Editor 3 (if you are configure before you can jump this step)
Step 2 :
Open skills_usa.bin in yourclient/data/
Step 3 :
Select skill to edit to be free and go to Skill Level
In Skill Levels you have 2 choice : Edit skill to be free for learn or edit skill to be free for learn AND free for use.
For Learn requied items its in RED and for Use requied items its in Orange
In blue you see different levels of the skill, you can have 1, 2, 3, 10, 100 or 1000 level its same to edit. You press up (left of 1/4) for go to next level.
Step 4 :
When you are decide how you want remove (in learn and cast need) you can remove item per item from skill.
Press the small magnifying glass for edit item and press None, after that Item ID past to -1 (you cant write directly -1 you need to open glass, put none. So borring after 300 skill edited)
Amount stay same, put to 0.
[The GuX Trick : Maybe you want add new item or just allow one item of original but for that you need to change the query of item needed for remove item from inventory of the player when he learn the skill, if you dont change the player need item for learn but item is not remove, so lol yes its same if item is not tradable/salable]
Step 5 :
After have edit the level you see "Save this level", press that for save and edit other level or just save the unique level.
When you are finish to edit all or unique level, press Database Update All Levels.
Step 6 :
For finish, back to "Basic" and press "Save record".
You have Edit and made your skills totaly free to learn and if you want totaly free to use (skill like 132 buff with wise stone).
Its very VERY VERY booring for edit all skills (70 per characther). Maybe when I have finish I give you my edited original usa file but for that I need to finish before xd.
And of course, please dont forget to save !
Last GuX trick for win time with mass-edit.
When you are skill with many level, open "Edit fast levels" and you can directly modify SP of all level (you put 0 press down arrow put 0 press down arrow put 0 ....)
With skill like Concentration (14 lvl) its time win in Skill Level because you dont need to put 0 in SP case and you are more concentred in other item.
So its the end of my first guide, Thanks to 2 for the query and Wizatek for Skill Editor 3. (I dont know if I can put link of skill editor so google is your freind)
- Wizatek - 08-31-2013
Very nice tutorial!
just be aware that with this, u also remove the requirements for pet skills, and specially the passive skills.
So a level 1 horse can already learn all the passive skills, so these need to be put back manually
- Paramount - 08-31-2013
Approved! Very useful guide, thanks!
- dethunter12 - 08-31-2013
already knew all this but thanks and pretty much you still have to go through every skill to get the visual client side requirements off even thought there not in the db.
- GuXz - 09-01-2013
Thanks
I have put query for database and skilleditor for client.But I can put link for skill editor or its a private tool
I want maybe make new guide later : Create and Edit skills
With tricks for have "private" skill and put only to select character or with item like weapon 180
And sure skills to learn in NPC or too add a level correctly in database and game with iconbtn, class, animation ....
I have make Shinra tensei with 200 range + 100 mobs kill in one shot. Like pain in naruto :ignat_02: All ppl know who is the boss when admin is connect on server :ph34r: All killed in one skill, the dream when you play in simple player