Trade out the game with 1 second.

Page 1 of 2 1 2
05/21/2015 16:27 tylep789#1

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.
05/21/2015 19:34 Dracula Untold#2
more info please i do not understand !
05/22/2015 05:31 Xutan*#3
explain ?
05/22/2015 06:39 chipno0p#4
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
05/22/2015 07:24 tylep789#5
Quote:
Originally Posted by chipno0p View Post
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...
05/22/2015 18:26 clapikal#6
I understand him. But i can not help. any server fixed it by drop the goods when disconecting.
05/22/2015 18:40 tylep789#7
Quote:
Originally Posted by clapikal View Post
I understand him. But i can not help. any server fixed it by drop the goods when disconecting.
Who can help me?
05/22/2015 23:00 Eslam Galull#8
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
05/23/2015 05:02 tylep789#9
Who can write a code that auto-delete Some of them are delete the goods if their trader logout in battle field.

HELP
05/24/2015 03:01 tylep789#10
please help
05/24/2015 23:57 vnkzo01#11
Hope it help you :-)
Quote:
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
05/25/2015 12:55 tylep789#12
Quote:
Originally Posted by vnkzo01 View Post
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".
:(:(:(:(
05/27/2015 17:15 tylep789#13
Please help me

nobody helped me
05/28/2015 23:44 vnkzo01#14
Add this to _AddLogChar

Quote:
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
05/29/2015 01:17 Xenethus1337#15
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 
Page 1 of 2 1 2