stats reset scroll Procedures ERROR SQL

[MissinGDeaTh]

why i'm getting this error, when i'm trying to add stats reset scroll.



and some one can give me guide for stats reset scroll + skill reset scroll + premium remove scrolls ?

[Crue*]

did you add it _Addtimedjob procedure ?

[MissinGDeaTh]

Originally Posted by Crue*

did you add it _Addtimedjob procedure ?

do i have to execute it in _Addtimedjob + AddLogitem ?

[Aaron*]

add this to your _AddtimedJob
Declare @JobID int
then press thanks and it will work xD

[MissinGDeaTh]

Originally Posted by Jocs

add this to your _AddtimedJob
Declare @JobID int
then press thanks and it will work xD

so, i will only add the procuder to _AddtimedJob ?

[Aaron*]

Originally Posted by MissinGDeaTh

so, i will only add the procuder to _AddtimedJob ?

simply add this line to your _AddTimedJob procedure..

Declare @JobID int

[Bocc1337]

use this code and tie it to the refskill scroll

if(@JobID = '34137') 
        begin 
            declare @Strength int 
            declare @Intellect int 
            declare @MaxLevel int 
            declare @RemainStatPoint int 
            select @MaxLevel = MaxLevel from _Char where CharID = @CharID 
            set @RemainStatPoint = (@MaxLevel*3)-3 
            set @MaxLevel = @MaxLevel+19 
            UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID 
            return -3 
        end

[MissinGDeaTh]

Originally Posted by sonsof2004

use this code and tie it to the refskill scroll

if(@JobID = '34137') 
        begin 
            declare @Strength int 
            declare @Intellect int 
            declare @MaxLevel int 
            declare @RemainStatPoint int 
            select @MaxLevel = MaxLevel from _Char where CharID = @CharID 
            set @RemainStatPoint = (@MaxLevel*3)-3 
            set @MaxLevel = @MaxLevel+19 
            UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID 
            return -3 
        end

refskill ? not refobjcommon ?

[​Exo]

Originally Posted by MissinGDeaTh

refskill ? not refobjcommon ?

Okay you have 2 options.....
RefSkill for AddTimedJob @Shard
RefID for ItemLog @Log

[MissinGDeaTh]

Originally Posted by xExorcist

Okay you have 2 options.....
RefSkill for AddTimedJob @Shard
RefID for ItemLog @Log

thanks for explaining this to me <3