Quote:
Originally Posted by Anonymous.dude
Hey since rare are who know how to fix this , admins check duped items always and so they can see the UID and then they delete them so the only thing u can dupe without getting caught by some admins is what ever is stackable like lapis or gold ench items ect , hope this helps you
|
This can be tracked by a simple query that tracks the transactions of "high valued items" or "large stacking items".
Select * From PS_GameLog.dbo.Actionlog Where ActionType IN (115, 116) AND Value2 = 'One*' AND Value4 > 'Two*'
One - The UID of the Item you are looking for.
Two - The base size of the stack you wish to look for anything over.
115 - Transaction from player.
116 - Transaction to player.
Hope this helps any devs watching this thread to help protect against the Dupe *** tool/Packet duping as well as unprotected servers from basic transaction timed dupes.
This query also will give you a rough idea of what duplicate UID numbers are still in the game.
select ItemUID INTO #CharTemp119 from PS_GameData.dbo.CharItems group by ItemUID having count(*) > 1
SELECT c.CharID,c.CharName,um.UserID,um.UserIp,ci.ItemID, ci.ItemUID,ci.Slot,ci.Bag, ci.Maketime FROM PS_GameData.dbo.CharItems as ci WITH (NOLOCK)
inner join PS_GameData.dbo.Chars as c on c.CharID = ci.CharID
inner join PS_UserData.dbo.Users_Master as um on um.UserUID = c.UserUID
WHERE ItemUID in (select ItemUID from #CharTemp119 ) order by ItemUID DESC
DROP TABLE #CharTemp119
Unaware of where this came from but credits to the creator of the query. I did not write the second one.