Sp scroll

03/01/2022 17:02 Beba Army#1

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

03/01/2022 17:59 Judgelemental#2

Quote:

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)

03/01/2022 19:47 Beba Army#3

Quote:

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