Stat Scroll Dosent work help!

02/25/2017 16:49 DevilArrow#1

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

Spoiler

02/25/2017 21:32 blapanda#2

Why did you add them to your _AddTimedJob proc? That one is totally wrong for this kind of processing.
Usually, you are using up a scroll, which has to be registered via "_AddLogItem" on a starting parameter:

Code:

IF (@Operation = 41) -- item usage
	BEGIN
		IF (@ItemRefID = 47374) -- item ID
... -- code goes on

You can then either directly execute your "reset stats" lines within that query line, or make it more clean and exec a different procedure located inside your shard database (which is more likely for the case of sorting stuff as they used to be).

Sum:
Scroll Usage ingame > hooks up with "_AddLogItem (LOG database)" and NOT with "_AddTimedJob (SHARD database)" > executes query if conditions are met (operation type (behavior: scroll usage) and item ID) and executes the custom reset query right away or in another procedure.

02/26/2017 16:35 DevilArrow#3

Quote:
Originally Posted by blapanda
Why did you add them to your _AddTimedJob proc? That one is totally wrong for this kind of processing.
Usually, you are using up a scroll, which has to be registered via "_AddLogItem" on a starting parameter:
Code:
IF  [MENTION=1059401]operation[/MENTION] = 41) -- item usage
	BEGIN
		IF (@ItemRefID = 47374) -- item ID
... -- code goes on
You can then either directly execute your "reset stats" lines within that query line, or make it more clean and exec a different procedure located inside your shard database (which is more likely for the case of sorting stuff as they used to be).

Sum:
Scroll Usage ingame > hooks up with "_AddLogItem (LOG database)" and NOT with "_AddTimedJob (SHARD database)" > executes query if conditions are met (operation type (behavior: scroll usage) and item ID) and executes the custom reset query right away or in another procedure.

ok
i change it to additemlog

Spoiler

but i have this error
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

02/26/2017 18:55 Bokyyy#4

Quote:

but i have this error
[Only registered and activated users can see links. Click Here To Register...]

You are missing bracket and comma at those red error lines.

02/27/2017 17:19 DevilArrow#5

i fix it ! thx all!

02/27/2017 21:38 leo2111#6

Quote:
Originally Posted by blapanda
Why did you add them to your _AddTimedJob proc? That one is totally wrong for this kind of processing.
Usually, you are using up a scroll, which has to be registered via "_AddLogItem" on a starting parameter:
Code:
IF (@Operation = 41) -- item usage
	BEGIN
		IF (@ItemRefID = 47374) -- item ID
... -- code goes on
You can then either directly execute your "reset stats" lines within that query line, or make it more clean and exec a different procedure located inside your shard database (which is more likely for the case of sorting stuff as they used to be).

Sum:
Scroll Usage ingame > hooks up with "c (LOG database)" and NOT with "_AddTimedJob (SHARD database)" > executes query if conditions are met (operation type (behavior: scroll usage) and item ID) and executes the custom reset query right away or in another procedure.

because _AddLogItem is exploitable, _AddTimedJob is safe :D

Spoiler

03/08/2017 00:16 White Ros3#7

USE This

PHP Code:


			
 IF (@Operation = 41) -- remove stats 

    BEGIN

    IF (@ItemRefID = 93002) --- RefObjCommon ID-----

    BEGIN

      declare  [MENTION=314361]strength[/MENTION] int

            declare  [MENTION=5100626]Intellect[/MENTION] int

            declare  [MENTION=1017443]maxlevel[/MENTION] int

            declare  [MENTION=3093238]remains[/MENTION]tatPoint int

            select  [MENTION=1017443]maxlevel[/MENTION] = MaxLevel from SRO_VT_SHARD.DBO._Char where CharID =  [MENTION=395373]Chari[/MENTION]D

            set  [MENTION=3093238]remains[/MENTION]tatPoint =   [MENTION=1017443]maxlevel[/MENTION]*3)-3

            set  [MENTION=1017443]maxlevel[/MENTION] =  [MENTION=1017443]maxlevel[/MENTION]+19

            UPDATE SRO_VT_SHARD.DBO._Char SET Strength  [MENTION=1017443]maxlevel[/MENTION], Intellect  [MENTION=1017443]maxlevel[/MENTION], RemainStatPoint  [MENTION=3093238]remains[/MENTION]tatPoint WHERE CharID  [MENTION=395373]Chari[/MENTION]D

            END

            END

Code:

 IF (@Operation = 41) -- remove stats 
	BEGIN
	IF (@ItemRefID = 93002)
	BEGIN
	  declare [MENTION=314361]strength[/MENTION] int
            declare [MENTION=5100626]Intellect[/MENTION] int
            declare [MENTION=1017443]maxlevel[/MENTION] int
            declare [MENTION=3093238]remains[/MENTION]tatPoint int
            select [MENTION=1017443]maxlevel[/MENTION] = MaxLevel from SRO_VT_SHARD.DBO._Char where CharID = [MENTION=395373]Chari[/MENTION]D
            set [MENTION=3093238]remains[/MENTION]tatPoint =  [MENTION=1017443]maxlevel[/MENTION]*3)-3
            set [MENTION=1017443]maxlevel[/MENTION] = [MENTION=1017443]maxlevel[/MENTION]+19
            UPDATE SRO_VT_SHARD.DBO._Char SET Strength [MENTION=1017443]maxlevel[/MENTION], Intellect [MENTION=1017443]maxlevel[/MENTION], RemainStatPoint [MENTION=3093238]remains[/MENTION]tatPoint WHERE CharID [MENTION=395373]Chari[/MENTION]D
			END
			END