Sp scroll

[Beba Army]

Im looking for sp scroll that gives to player certain amount of sp, can someone share query for customizable amount of sp thank you.

[Judgelemental]

Originally Posted by Beba Army

Im looking for sp scroll that gives to player certain amount of sp, can someone share query for customizable amount of sp thank you.

PHP Code:

IF (@Operation = 41) and (@ItemRefID = RefObjCommonScrollID) -- Skill Point Scroll
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Char] Set RemainSkillPoint = RemainSkillPoint + 1000000
  WHERE    CharID = @ CharID
   End 


Remove the space between @ and CharID
Copy-paste a return scroll in RefObjCommon and RefObjItem.
Don't forget to make the Link (in RefObjCommon) unique and the Link in RefObjCommon should match the ID in RefObjitem.

Lastly, don't forget the media side (itemdata_xxxx.txt and textdata_object.txt)

[Beba Army]

Originally Posted by Judgelemental

PHP Code:

IF (@Operation = 41) and (@ItemRefID = RefObjCommonScrollID) -- Skill Point Scroll
   Begin
    Update [SRO_VT_SHARD].[dbo].[_Char] Set RemainSkillPoint = RemainSkillPoint + 1000000
   End 


Copy-paste a return scroll in RefObjCommon and RefObjItem.
Don't forget to make the Link (in RefObjCommon) unique and the Link in RefObjCommon should match the ID in RefObjitem.

Lastly, don't forget the media side (itemdata_xxxx.txt and textdata_object.txt)

Thankyou