SKILL MASTERY - Request Server Development Help [L2OFF] - MaxCheaters.com | Lineage 2 Development Marketplace Bots and Cheats
Jump to content
  • 0

SKILL MASTERY


Question

Posted

Hi everyone. I have a serverinterlude main class + 3 substack and I have a problem with that.

When I stack a sub It acumulates the skilles right? but It duplicates the heavy and light armor mastery as well.

How can I do to keep only the las mastery?.

I took this proseadure but It`s for Java. Any idea por SQL SERVER?

 

UPDATE skill_trees SET skill_id`='227' WHERE (name`='Light Armor Mastery');
UPDATE skill_trees SET skill_id`='231' WHERE (name`='Heavy Armor Mastery');

 

1 answer to this question

Recommended Posts

  • 0
Posted

Use [lin2world]

update user_skill set skill_id = 'wished skill id' where skill_id = 'unwanted skill_id'

 

that may carry other problems but if you think a little and work in the query you can have a solution.

 

Think on LEFT JOIN user_data subjob0_class, subjob1_class, subjob2_class, subjob3_class with the user_skill table 

 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...