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






