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)