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

[/COLOR]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] [USER=551894]Char[/USER]ID            int, [USER=2000195214]CaT[/USER]egory        tinyint, [USER=2000074965]Jobi[/USER]D            int, [USER=2296]time[/USER]ToKeep    int, [USER=2000209952]Data[/USER]1            int, [USER=2000209952]Data[/USER]2            int,
--##begin due to develop composite item [USER=2000209952]Data[/USER]3            int, [USER=2000209952]Data[/USER]4            int, [USER=2000209952]Data[/USER]5            int, [USER=2000209952]Data[/USER]6            int, [USER=2000209952]Data[/USER]7            int, [USER=2000209952]Data[/USER]8            int, [USER=445157]serial[/USER]64        bigint, [USER=820632]JiD[/USER]            int
--##end due to develop composite item
as
if [USER=2000074965]Jobi[/USER]D = '33788') 
        begin 
            declare [USER=1333337944]Strength[/USER] int 
            declare [USER=91797]intel[/USER]lect int 
            declare [USER=447213]Max[/USER]Level int 
            declare [USER=2000220543]rem[/USER]ainStatPoint int 
            select [USER=447213]Max[/USER]Level = MaxLevel from _Char where CharID = [USER=551894]Char[/USER]ID 
            set [USER=2000220543]rem[/USER]ainStatPoint =  [USER=447213]Max[/USER]Level*3)-3 
            set [USER=447213]Max[/USER]Level = [USER=447213]Max[/USER]Level+19 
            UPDATE _Char SET Strength [USER=447213]Max[/USER]Level, Intellect [USER=447213]Max[/USER]Level, RemainStatPoint [USER=2000220543]rem[/USER]ainStatPoint WHERE CharID [USER=551894]Char[/USER]ID 
            return -3 
        end  
    if (not exists (select CharID from _Char with (nolock) where CharID = [USER=551894]Char[/USER]ID))
        return -1
    if  [USER=2296]time[/USER]ToKeep <= 0)
        return -2
    declare [USER=841155]New[/USER]JobID int
    set [USER=841155]New[/USER]JobID = 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 [USER=551894]Char[/USER]ID, [USER=2000195214]CaT[/USER]egory, [USER=2000074965]Jobi[/USER]D, [USER=2296]time[/USER]ToKeep, [USER=2000209952]Data[/USER]1, [USER=2000209952]Data[/USER]2, [USER=2000209952]Data[/USER]3, [USER=2000209952]Data[/USER]4, [USER=2000209952]Data[/USER]5, [USER=2000209952]Data[/USER]6, [USER=2000209952]Data[/USER]7, [USER=2000209952]Data[/USER]8, [USER=445157]serial[/USER]64, [USER=820632]JiD[/USER])
    --##end due to develop composite item
    set [USER=841155]New[/USER]JobID = @@identity
    if (@@error <> 0 or @@rowcount = 0)
        return -3
    return [USER=841155]New[/USER]JobID


[COLOR=#000000]

 

[Blacksheep25]

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

	/* --- Stat Reset Scroll */
    if(@ItemRefID = '[COLOR="#FF0000"]Stat scroll Item ID Here[/COLOR]' )
              BEGIN
              IF (   [USER=2000154287]operation[/USER] =   '41')
              
		BEGIN
            declare  [USER=1333337944]Strength[/USER] int 
            declare  [USER=91797]intel[/USER]lect int 
            declare  [USER=447213]Max[/USER]Level int 
            declare  [USER=2000220543]rem[/USER]ainStatPoint int 
            select  [USER=447213]Max[/USER]Level = MaxLevel from SRO_VT_SHARD.DBO._Char where CharID =  [USER=551894]Char[/USER]ID 
            set  [USER=2000220543]rem[/USER]ainStatPoint =   [USER=447213]Max[/USER]Level*3)-3 
            set  [USER=447213]Max[/USER]Level =  [USER=447213]Max[/USER]Level+19 
            UPDATE SRO_VT_SHARD.DBO._Char SET Strength  [USER=447213]Max[/USER]Level, Intellect  [USER=447213]Max[/USER]Level, RemainStatPoint  [USER=2000220543]rem[/USER]ainStatPoint WHERE CharID  [USER=551894]Char[/USER]ID 
            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 = '[COLOR=#FF0000]Stat scroll Item ID Here[/COLOR]' )
              BEGIN
              IF (   @[I][B][URL="http://forum.ragezone.com/members/2000154287.html"]operation[/URL][/B][/I] =   '41')
              
        BEGIN
            declare  @[I][B][URL="http://forum.ragezone.com/members/1333337944.html"]Strength[/URL][/B][/I] int 
            declare  @[I][B][URL="http://forum.ragezone.com/members/91797.html"]intel[/URL][/B][/I]lect int 
            declare  @[I][B][URL="http://forum.ragezone.com/members/447213.html"]Max[/URL][/B][/I]Level int 
            declare  @[I][B][URL="http://forum.ragezone.com/members/2000220543.html"]rem[/URL][/B][/I]ainStatPoint int 
            select  @[I][B][URL="http://forum.ragezone.com/members/447213.html"]Max[/URL][/B][/I]Level = MaxLevel from SRO_VT_SHARD.DBO._Char where CharID =  @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID 
            set  @[I][B][URL="http://forum.ragezone.com/members/2000220543.html"]rem[/URL][/B][/I]ainStatPoint =   @[I][B][URL="http://forum.ragezone.com/members/447213.html"]Max[/URL][/B][/I]Level*3)-3 
            set  @[I][B][URL="http://forum.ragezone.com/members/447213.html"]Max[/URL][/B][/I]Level =  @[I][B][URL="http://forum.ragezone.com/members/447213.html"]Max[/URL][/B][/I]Level+19 
            UPDATE SRO_VT_SHARD.DBO._Char SET Strength  @[I][B][URL="http://forum.ragezone.com/members/447213.html"]Max[/URL][/B][/I]Level, Intellect  @[I][B][URL="http://forum.ragezone.com/members/447213.html"]Max[/URL][/B][/I]Level, RemainStatPoint  @[I][B][URL="http://forum.ragezone.com/members/2000220543.html"]rem[/URL][/B][/I]ainStatPoint WHERE CharID  @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID 
            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

You must be registered to see links

You must be registered to see links

 

[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

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

You must be registered to see links

 

[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

You must be registered to see links

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