How to create add new skill for scroll

[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.

[Judgelemental]

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 :

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
For some reason that's the mention command.

257 = Bicheon
Here are the masteries:


(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.

[Beba Army]

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
For some reason that's the mention command.

257 = Bicheon
Here are the masteries:


(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.

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

[Judgelemental]

Originally Posted by Beba Army

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

Like this ?









It's manual work,

[Beba Army]

Originally Posted by Judgelemental

Like this ?









It's manual work,

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.

[Judgelemental]

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.

[Beba Army]

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?

[Judgelemental]

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.

[Beba Army]

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 "?" ?

[Judgelemental]

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

[Beba Army]

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?

[Judgelemental]

Originally Posted by Beba Army

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

Yellow box are the requirements

Leave the Req columns to 0 for no requirements

[Beba Army]

Originally Posted by Judgelemental

Yellow box are the requirements

Leave the Req columns to 0 for no requirements

Ty