stats reset scroll Procedures ERROR SQL

01/19/2015 22:44 MissinGDeaTh#1

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

[Only registered and activated users can see links. Click Here To Register...]

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

01/20/2015 09:39 Crue*#2

did you add it _Addtimedjob procedure ?

01/20/2015 22:16 MissinGDeaTh#3

Quote:

Originally Posted by Crue*

did you add it _Addtimedjob procedure ?

do i have to execute it in _Addtimedjob + AddLogitem ?

01/20/2015 22:47 Aaron*#4

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

01/20/2015 22:52 MissinGDeaTh#5

Quote:

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 ?

01/20/2015 22:59 Aaron*#6

Quote:

Originally Posted by MissinGDeaTh

so, i will only add the procuder to _AddtimedJob ?

simply add this line to your _AddTimedJob procedure..

Quote:

Declare @JobID int

01/21/2015 23:29 Bocc1337#7

use this code and tie it to the refskill scroll

Code:

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

01/22/2015 00:26 MissinGDeaTh#8

Quote:

Originally Posted by sonsof2004

use this code and tie it to the refskill scroll

Code:

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 ?

01/22/2015 00:43 Exo#9

Quote:

Originally Posted by MissinGDeaTh

refskill ? not refobjcommon ?

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

01/22/2015 01:13 MissinGDeaTh#10

Quote:

Originally Posted by xExorcist

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

thanks for explaining this to me <3