next time pls use the search engine. here is a little fix i found but pls read till the end of the thread..
but i prefear another way.
just let them dupe and run everyday this quiery.
Code:
USE PS_GameData
SELECT ItemUID, CharID, Craftname, Count
FROM dbo.CharItems
WHERE Exists (
SELECT ItemUID FROM dbo.Charitems dub WHERE dbo.Charitems.ItemUID = dub.ItemUID and dbo.Charitems.CharID <> dub.CharID )
ORDER BY CharId;
----Warenlager--Items--Überprüfen----
USE PS_GameData
SELECT ItemUID, UserUID, Craftname, Count
FROM dbo.UserStoredItems
WHERE Exists (
SELECT ItemUID FROM dbo.UserStoredItems dub WHERE dbo.UserStoredItems.ItemUID = dub.ItemUID and dbo.UserStoredItems.UserUID <> dub.UserUID )
ORDER BY UserUID;
----Auctionshaus--überprüfen----
USE PS_GameData
SELECT ItemUID, MarketID, Craftname, Count
FROM dbo.MarketItems
WHERE Exists (
SELECT ItemUID FROM dbo.MarketItems dub WHERE dbo.MarketItems.ItemUID = dub.ItemUID and dbo.MarketItems.MarketID <> dub.MarketID )
ORDER BY MarketID;
----Gildenlager--überprüfen----
USE PS_GameData
SELECT ItemUID, GuildID, Craftname, Count
FROM dbo.GuildStoredItems
WHERE Exists (
SELECT ItemUID FROM dbo.GuildStoredItems dub WHERE dbo.GuildStoredItems.ItemUID = dub.ItemUID and dbo.GuildStoredItems.GuildID <> dub.GuildID )
ORDER BY GuildID;
it deleates the duped items and the items that was used to dupe so the ones that duped will be fcked over because they lost both items. thats teaches them more a lesson as using an dupe fix because there is always still a way to dupe without gameguard ( what aeria is using
)
credits to sondo81 for the amazing script.
