Trade out the game with 1 second.

[tylep789]

It's a bug when a user use a 3rd party tool to make a trader (with pet and bought goods) can logout (disconnect) in one second. Calling: Trade Bug.

Some of them are delete the goods if their trader logout in battle field

I do not know how. Help Me.


Thank You very much.

[Dracula Untold]

more info please i do not understand !

[Xutan*]

explain ?

[chipno0p]

its a bug when a user use a 3rd party tool to make a trader (with pet and bought goods) can logout (disconnect) in one second. Calling: Trade Bug
There are a lot of fixing way that you can find by your own

Some of them are delete the goods if their trader logout in battle field

Hope its helping you

[tylep789]

Originally Posted by chipno0p

its a bug when a user use a 3rd party tool to make a trader (with pet and bought goods) can logout (disconnect) in one second. Calling: Trade Bug
There are a lot of fixing way that you can find by your own

Some of them are delete the goods if their trader logout in battle field

Hope its helping you

I do not know how. Help

help me please

Help ME...

[clapikal]

I understand him. But i can not help. any server fixed it by drop the goods when disconecting.

[tylep789]

Originally Posted by clapikal

I understand him. But i can not help. any server fixed it by drop the goods when disconecting.

Who can help me?

[Eslam Galull]

use ur brain

use char log .. check if the char have a trade pet and the trade pet inventory have a trade items or no ..

if yes and the spawn area was in battle field delete the items & the pet to ..
or do ur own idea

[tylep789]

Who can write a code that auto-delete Some of them are delete the goods if their trader logout in battle field.

HELP

[tylep789]

please help

[vnkzo01]

Hope it help you :-)

Declare @CosID int = (select ID from SRO_VT_SHARD.dbo._CharCOS where OwnerCharID = @CharID and RefCharID in (select ID from SRO_VT_SHARD.._Refobjcommon WHERE (CodeName128 LIKE 'COS_T_%120' or CodeName128 LIKE 'COS_T_%105') AND (Service = 1)))
Declare @isbattle int = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID = (Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID = @charID))
IF (@EventID = 6) and @CosID > 0
begin
IF @isbattle = 1
BEGIN
Update SRO_VT_SHARD.._CharCOS set OwnerCharID = 0 where OwnerCharID = @CharID and ID = @CosID
END
END

[tylep789]

Originally Posted by vnkzo01

Hope it help you :-)

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@CharID".
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ')'.
Msg 137, Level 15, State 2, Line 2
Must declare the scalar variable "@charID".
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@EventID".
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@isbattle".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@CharID".

[tylep789]

Please help me

nobody helped me

[vnkzo01]

Add this to _AddLogChar

Declare @CosID int = (select ID from SRO_VT_SHARD.dbo._CharCOS where OwnerCharID = @CharID and RefCharID in (select ID from SRO_VT_SHARD.._Refobjcommon WHERE (CodeName128 LIKE 'COS_T_%120' or CodeName128 LIKE 'COS_T_%105') AND (Service = 1)))
Declare @isbattle int = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID = (Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID = @charID))
IF (@EventID = 6) and @CosID > 0
begin
IF @isbattle = 1
BEGIN
Update SRO_VT_SHARD.._CharCOS set OwnerCharID = 0 where OwnerCharID = @CharID and ID = @CosID
END
END

[Xenethus1337]

check this out :
Add this Part to _AddLogChar On LogDB

PHP Code:

/*Trade Bug fix By Xenethus */
/*config lines */
DECLARE @CosID int =  (      SELECT coss.ID FROM SRO_VT_SHARD.dbo._CharCOS COSS 
                            INNER JOIN SRO_VT_SHARD.dbo._RefObjCommon OBJC
                            ON COSS.RefCharID = OBJC.ID 
                            WHERE OBJC.CodeName128 LIKE '%COS_T%'
                            AND COSS.OwnerCharID = @CharID)
DECLARE @IsBattleF int = (SELECT IsBattleField FROM SRO_VT_SHARD.dbo._RefRegion reg 
                                       INNER JOIN SRO_VT_SHARD.dbo._Char CH
                                       ON reg.wRegionID = CH.LatestRegion
                                       WHERE CH.CharID = @CharID)
                                                                             
DECLARE @RefCharID int = (SELECT ID FROM SRO_VT_SHARD.._RefObjCommon WHERE CodeName128 LIKE '%COS_T%')                            
/* checking */
If @EventID = 6 AND @CosID > 0 AND @IsBattleF = '1'
                            BEGIN                           
/* Begin Remove items from pet */                          
UPDATE SRO_VT_SHARD.dbo._InvCOS 
SET ItemID = '0' 
WHERE COSID = @CosID
/* Begin Remove pet from char it self */
UPDATE SRO_VT_SHARD.dbo._CharCOS 
SET OwnerCharID = '0' 
WHERE OwnerCharID = @CharID AND RefCharID = @RefCharID

END