i figure this is the correct thread as its help i am looking for. i have been trying for the last half hour or so, with many server crashes, to fix create the delete_skill smp. it seems i can not get it right as the server keeps giving me the same error every time.
the error is asking for @IN_OWNER_ID
ALTER PROCEDURE [dbo].[smp_delete_skill]
@IN_SID INT,
@IN_OWNER_ID INT,
@IN_JP_DEC INT,
@IN_SUMMON_ID INT,
@IN_SKILL_ID INT,
@IN_SKILL_LEVEL INT,
@IN_COOL_TIME INT
AS
SET NOCOUNT ON
delete Skill where 'owner_id' = @IN_OWNER_ID AND 'sid' = @IN_SID
update Character WITH (UPDLOCK) set jp = jp + @IN_JP_DEC where sid=@IN_SID;