New exploit, dupe any item vsro

08/14/2017 14:09 bissag#1
Hello,

Recently I had noticed an exploit being used to transfer for example 1 arena to 10k arena or whatever the maximum amount in your server, could be any coins type not just arena coins. Maybe it also work on other items, but I can confirm it works on arena coins, iron coins and gold coins.
This exploit is not public yet.
08/14/2017 14:45 ​Exo#2
Do you give these coins as some sort of reward? Job or something else?
08/14/2017 16:16 bissag#3
Quote:
Originally Posted by ​Exo View Post
Do you give these coins as some sort of reward? Job or something else?
Yes, you get these coins as reward from Job, but logging the char who makes the exploit, the char is not using a job suit while doing the exploit.
08/14/2017 16:25 ​Exo#4
Quote:
Originally Posted by bissag View Post
Yes, you get these coins as reward from Job, but logging the char who makes the exploit, the char is not using a job suit while doing the exploit.
Would you please show me the query for the rewards?
08/14/2017 16:28 bissag#5
Quote:
Originally Posted by ​Exo View Post
Do you give these coins as some sort of reward? Job or something else?
Quote:
Originally Posted by ​Exo View Post
Would you please show me the query for the rewards?
The job reward is set to be sent when the char logs out (EventID = 6)
/*Job Reward */
IF @[Only registered and activated users can see links. Click Here To Register...]D = 6
BEGIN
EXEC _JobSystem @[Only registered and activated users can see links. Click Here To Register...]D
END

_JobSystem
EXEC SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @[Only registered and activated users can see links. Click Here To Register...]harName, @[Only registered and activated users can see links. Click Here To Register...]ewardCodeName, @[Only registered and activated users can see links. Click Here To Register...]wardAmount, 0
EXEC SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @[Only registered and activated users can see links. Click Here To Register...]harName, @[Only registered and activated users can see links. Click Here To Register...]ewardCodeName2, @[Only registered and activated users can see links. Click Here To Register...]wardAmount2, 0
08/14/2017 16:36 ​Exo#6
Quote:
Originally Posted by bissag View Post
The job reward is set to be sent when the char logs out (EventID = 6)
/*Job Reward */
IF @[Only registered and activated users can see links. Click Here To Register...]D = 6
BEGIN
EXEC _JobSystem @[Only registered and activated users can see links. Click Here To Register...]D
END

_JobSystem
EXEC SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @[Only registered and activated users can see links. Click Here To Register...]harName, @[Only registered and activated users can see links. Click Here To Register...]ewardCodeName, @[Only registered and activated users can see links. Click Here To Register...]wardAmount, 0
EXEC SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @[Only registered and activated users can see links. Click Here To Register...]harName, @[Only registered and activated users can see links. Click Here To Register...]ewardCodeName2, @[Only registered and activated users can see links. Click Here To Register...]wardAmount2, 0
I need to see how this IntrewardAmount is calculated.
08/14/2017 16:51 bissag#7
Quote:
Originally Posted by ​Exo View Post
I need to see how this IntrewardAmount is calculated.
SELECT @[Only registered and activated users can see links. Click Here To Register...]wardAmount = Value
FROM _JobSystemConfiguration
WHERE CodeName = @[Only registered and activated users can see links. Click Here To Register...]ewardAmountString


JobSystemConfiguration has data for the arena amount you get, the minimum contribution allowed to receive the reward and the item code name and the reward limit

1 TRADER_REQ_CONTRIBUTION xxxxx
2 TRADER_REWARD_ITEM_CODENAME xxx
3 TRADER_REWARD_ITEM_AMOUNT xxx
4 JOB_REWARD_LIMIT xxx

When the char makes the required contribution amount, he logs out to receive the reward and the contribution resets to 0.

Quote:
SELECT @[Only registered and activated users can see links. Click Here To Register...]JobCount = Amount
FROM _JobLimit WITH (NOLOCK)
WHERE JID = @[Only registered and activated users can see links. Click Here To Register...]UserJID

IF @[Only registered and activated users can see links. Click Here To Register...]JobCount >= (SELECT Value FROM _JobSystemConfiguration WITH (NOLOCK) WHERE CodeName = 'JOB_REWARD_LIMIT')
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...]turnValue = 5
GOTO ErrorHandler
END

UPDATE SRO_VT_SHARD.dbo._CharTrijob
SET Contribution = 0
WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]CharID

IF @[Only registered and activated users can see links. Click Here To Register...]JobCount IS NULL
BEGIN
INSERT INTO _JobLimit
VALUES @[Only registered and activated users can see links. Click Here To Register...]UserJID, 1)
END
ELSE
BEGIN
UPDATE _JobLimit
SET Amount += 1
WHERE JID = @[Only registered and activated users can see links. Click Here To Register...]UserJID
END
08/14/2017 19:47 WickedNite.#8
I knew about this for a very long time already, hence why, since like forever, I am not using physical items(coins) as reward from jobbing.
08/14/2017 20:45 links2007#9
The problem comes when @[Only registered and activated users can see links. Click Here To Register...]wardAmount = 0, because stored procedure _ADD_ITEM_EXTERN will take maxstack instead 0
08/15/2017 01:35 ​Exo#10
Quote:
Originally Posted by bissag View Post
SELECT @[Only registered and activated users can see links. Click Here To Register...]wardAmount = Value
FROM _JobSystemConfiguration
WHERE CodeName = @[Only registered and activated users can see links. Click Here To Register...]ewardAmountString


JobSystemConfiguration has data for the arena amount you get, the minimum contribution allowed to receive the reward and the item code name and the reward limit

1 TRADER_REQ_CONTRIBUTION xxxxx
2 TRADER_REWARD_ITEM_CODENAME xxx
3 TRADER_REWARD_ITEM_AMOUNT xxx
4 JOB_REWARD_LIMIT xxx

When the char makes the required contribution amount, he logs out to receive the reward and the contribution resets to 0.
Post the complete thing dude. I can't get spot where it goes wrong unless you do so.
08/15/2017 18:51 bissag#11
I can confirm it is not job related, it is something related to stall and magic stone of sockets.
08/16/2017 19:08 InZiDeR#12
Quote:
Originally Posted by bissag View Post
I can confirm it is not job related, it is something related to stall and magic stone of sockets.
Read this article. New dupe works in a similar way :P
08/16/2017 19:31 bissag#13
Quote:
Originally Posted by InZiDeR View Post
Read this article. New dupe works in a similar way :P
I can confirm the item dupe is working using the alchemy/stall exploit but I wonder what would be the fix?
08/16/2017 19:53 InZiDeR#14
Quote:
Originally Posted by bissag View Post
I can confirm the item dupe is working using the alchemy/stall exploit but I wonder what would be the fix?
You can fix this by filter software. You need to define character status. Like filter knows the char is in Stall or in "Wearing an Item" or "Fusing" cannot do anything else while in this status. That's like I fix most of the stuff.
08/19/2017 13:37 geheimerbauer#15
Quote:
We were using the new alchemy items which the packet to apply the alchemy unto items weren't blocked during stall opened.
Which new alchemy items?