Stat Scroll Dosent work help!

[Changoleon1]

Hi Guys ! i have a problem i add the Stat Scroll, in DB+media
the problem is when i use i dosent get the Statpoints my Hp and mp are the same, who can help me ?
here is my

_addtimedjob

USE [SRO_VT_SHARD]GO
/****** Object:  StoredProcedure [dbo].[_AddTimedJob]    Script Date: 02/25/2017 08:51:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO








ALTER   procedure [dbo].[_AddTimedJob] @CharID            int, @CaTegory        tinyint, @JobiD            int, @timeToKeep    int, @Data1            int, @Data2            int,
--##begin due to develop composite item @Data3            int, @Data4            int, @Data5            int, @Data6            int, @Data7            int, @Data8            int, @serial64        bigint, @JiD            int
--##end due to develop composite item
as
if @JobiD = '33788') 
        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  
    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
        return -1
    if  @timeToKeep <= 0)
        return -2
    declare @NewJobID int
    set @NewJobID = 0
    --##begin due to develop composite item
    insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
    values @CharID, @CaTegory, @JobiD, @timeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @serial64, @JiD)
    --##end due to develop composite item
    set @NewJobID = @@identity
    if (@@error <> 0 or @@rowcount = 0)
        return -3
    return @NewJobID

[MentaL]

[Blacksheep25]

Try this one, also why are you using it via "_AddTimedJob"? Use "_AddLogItem" in "SRO_VT_SHARDLOG"

	/* --- Stat Reset Scroll */
    if(@ItemRefID = 'Stat scroll Item ID Here' )
              BEGIN
              IF (   @operation =   '41')
              
		BEGIN
            declare  @Strength int 
            declare  @intellect int 
            declare  @MaxLevel int 
            declare  @remainStatPoint int 
            select  @MaxLevel = MaxLevel from SRO_VT_SHARD.DBO._Char where CharID =  @CharID 
            set  @remainStatPoint =   @MaxLevel*3)-3 
            set  @MaxLevel =  @MaxLevel+19 
            UPDATE SRO_VT_SHARD.DBO._Char SET Strength  @MaxLevel, Intellect  @MaxLevel, RemainStatPoint  @remainStatPoint WHERE CharID  @CharID 
            return -3 
        END
    END

[Changoleon1]

Try this one, also why are you using it via "_AddTimedJob"? Use "_AddLogItem" in "SRO_VT_SHARDLOG"

    /* --- Stat Reset Scroll */
    if(@ItemRefID = 'Stat scroll Item ID Here' )
              BEGIN
              IF (   @operation =   '41')
              
        BEGIN
            declare  @Strength int 
            declare  @intellect int 
            declare  @MaxLevel int 
            declare  @remainStatPoint int 
            select  @MaxLevel = MaxLevel from SRO_VT_SHARD.DBO._Char where CharID =  @CharID 
            set  @remainStatPoint =   @MaxLevel*3)-3 
            set  @MaxLevel =  @MaxLevel+19 
            UPDATE SRO_VT_SHARD.DBO._Char SET Strength  @MaxLevel, Intellect  @MaxLevel, RemainStatPoint  @remainStatPoint WHERE CharID  @CharID 
            return -3 
        END
    END

i put it in addtimedjob be cause i read post and they say that.

ok i change it to addlogitem and i have error look

http://imgur.com/a/dLmaS
http://imgur.com/a/dLmaS

[Blacksheep25]

i put it in addtimedjob be cause i read post and they say that.

ok i change it to addlogitem and i have error look

Imgur: The most awesome images on the Internet
Imgur: The most awesome images on the Internet

Yeah it didn't format correctly and is missing stuff due to ragezone trying to mention members, try copying it from this one instead

http://pastebin.com/raw/T7YXQU1F

[Changoleon1]

Yeah it didn't format correctly and is missing stuff due to ragezone trying to mention members, try copying it from this one instead

http://pastebin.com/raw/T7YXQU1F

i have a problem with the site

Can not access this siteThe DNS address of the pastebin.com server was not found.DNS_PROBE_FINISHED_NXDOMAIN