Hello, I have been trying to implement a gift scroll on my test server, the idea basically is to get this scroll, right click on it and get some items. So far, I was able to create a "test scroll", but my problem start with the procedure for the scroll.
This is the procedure that I'm trying to use:
PHP Code:
--- Test Scroll
if (@ Operation = 41 and @ ItemRefID = 41799)
begin
declare @ CharName varchar(64)
set @ CharName = (select CharName16 from [SRO_VT_SHARD].[dbo].[_Char] where CharID = @ charID);
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @ CharName, 'ITEM_MALL_DAMAGE_INC_20P_SCROLL', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @ CharName, 'ITEM_MALL_DAMAGE_ABS_20P_SCROLL', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @ CharName, 'ITEM_MALL_AVATAR_M_ANGEL_WING_DRESS', 1, 0
end
I'm locating this procedure at the bottom of AddLogItem, I click execute and no errors shows up, when I use the scroll on my server, I teleport but I don't get the items on my inventory. What am I doing wrong?. If someone could guide me, I would appreciate it.
EDIT: I found the solution, I was using the procedure stored on SRO_VT_SHARD instead of SRO_VT_SHARDLOG, everything works as intended. If a mod wants to close this thread, you're more than welcome to do it.
