How to create add new skill for scroll

I want make player can buy scroll of certain skill and when activate the scroll, the new skill will add to his mastery. Or any hint.

Quote:

Originally Posted by Beba Army I want make player can buy scroll of certain skill and when activate the scroll, the new skill will add to his mastery. Or any hint.

SRO_VT_LOG -> Programmability -> Stored Procedures -> _AddLogItem

1.This will only add one skill :
ItemID = _RefObjCommonID
SkillID= _RefSkill ID

2.This will unlock ONE Chinese mastery and level it up to 90.

Delete the space between @ and the name of the tab [Only registered and activated users can see links. Click Here To Register...]
For some reason that's the mention command.

257 = Bicheon
Here are the masteries:
[Only registered and activated users can see links. Click Here To Register...]

(You can add the scroll yourself, just copy the return scroll from RefObjCommon and RefObjItem, make sure the Link is not the same)
Teleport after using the scroll and make sure the MaxStack of the scroll from RefObjItem is 1.

It many not be the perfect query, but I hope it will give you an idea about how they work.


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

Quote:

Originally Posted by Judgelemental SRO_VT_LOG -> Programmability -> Stored Procedures -> _AddLogItem 1.This will only add one skill : PHP Code:  IF ( @ Operation = '41' and  @ ItemRefID = 'ItemID')       BEGIN   INSERT SRO_VT_SHARD.dbo._CharSkill VALUES (@ CharID,SkillID,1)   end  ItemID = _RefObjCommonID SkillID= _RefSkill ID 2.This will unlock ONE Chinese mastery and level it up to 90. PHP Code: IF @ operation = '41' and @ ItemRefID = 'ItemID') declare @ MasteryiID int       BEGIN       UPDATE SRO_VT_SHARD.._CharskillMastery SET Level = '90'        WHERE MasteryID = 257 and CharID=@ CharID           end  Delete the space between @ and the name of the tab [Only registered and activated users can see links. Click Here To Register...] For some reason that's the mention command. 257 = Bicheon Here are the masteries: [Only registered and activated users can see links. Click Here To Register...] (You can add the scroll yourself, just copy the return scroll from RefObjCommon and RefObjItem, make sure the Link is not the same) Teleport after using the scroll and make sure the MaxStack of the scroll from RefObjItem is 1. It many not be the perfect query, but I hope it will give you an idea about how they work. [Only registered and activated users can see links. Click Here To Register...]

Thank you bro, but this misses the part in refskill where expand mastery slots, ty anyway.

Quote:

Originally Posted by Beba Army Thank you bro, but this misses the part in refskill where expand mastery slots, ty anyway.

Like this ?

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





It's manual work, [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by Judgelemental Like this ? [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] It's manual work, [Only registered and activated users can see links. Click Here To Register...]

Yes, when player activate scroll the new skill will have to appear in his mastery so it seems need the scroll when activate consifure the refskill too, or idk if have to be manual. Ty i will use this tool.

Mmm i have all these tools already, i will figure it out by myself thank you for help.

Quote:

Originally Posted by Beba Army Yes, when player activate scroll the new skill will have to appear in his mastery so it seems need the scroll when activate consifure the refskill too, or idk if have to be manual. Ty i will use this tool. Mmm i have all these tools already, i will figure it out by myself thank you for help.

The scroll/player will have to access the server database, run the query to add the skill in _RefSkill, then the server needs to be restarted so impossible.

All you can do is add them and the player will unlock them only.

You're welcome.

Quote:

Originally Posted by Judgelemental The scroll/player will have to access the server database, run the query to add the skill in _RefSkill, then the server needs to be restarted so impossible. All you can do is add them and the player will unlock them only. You're welcome.

So per example, the limit of line of some mastery slots is 9, and i put 10, so when player use scroll there will get the 10th skill?

Quote:

Originally Posted by Beba Army So per example, the limit of line of some mastery slots is 9, and i put 10, so when player use scroll there will get the 10th skill?

If the skill is already there (inside the database/client) but hasn't been learned by the player yet and you use the query to unlock the 10th skill with the scroll when the player uses it, then yes.

Quote:

Originally Posted by Judgelemental If the skill is already there (inside the database/client) but hasn't been learned by the player yet and you use the query to unlock the 10th skill with the scroll when the player uses it, then yes.

U mean the player will see his mastery with per example 9 lines ready to learn with sp/lv but the 10th+ are blocked (with those black rows without the "?") and then use the scroll and that 10th unlocked and appear the "?" ?

Quote:

Originally Posted by Beba Army U mean the player will see his mastery with per example 9 lines ready to learn with sp/lv but the 10th+ are blocked (with those black rows without the "?") and then use the scroll and that 10th unlocked and appear the "?" ?

The player will see everything BUT the 10th skill or skill row will have a book with "?" on it. Once the scroll is used they unlock the skill

Quote:

Originally Posted by Judgelemental The player will see everything BUT the 10th skill or skill row will have a book with "?" on it. Once the scroll is used they unlock the skill

What will shows in requeriments? nothing? so in refskill i have to put 0 in req skill point?

Quote:

Originally Posted by Beba Army What will shows in requeriments? nothing? so in refskill i have to put 0 in req skill point?

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

Yellow box are the requirements

Leave the Req columns to 0 for no requirements

Quote:

Originally Posted by Judgelemental [Only registered and activated users can see links. Click Here To Register...] Yellow box are the requirements Leave the Req columns to 0 for no requirements

Ty