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* View Post
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 View Post
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 View Post
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 View Post
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 View Post
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 View Post
Okay you have 2 options.....
RefSkill for AddTimedJob @Shard
RefID for ItemLog @Log
thanks for explaining this to me <3