Fix Antidup

[_SCoRp_]

Hi I could you please tell me where I can find the Fix antidup
for my server?

From already thank you very much for the reply.

[Cansas59]

i seaching too

[andr3y_you96]

Also the databese gamelog posted by nubness has some checks too if im not wrong.

[Boul27]

I found this, not complette, but i good way to fix it

----Item on char----
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;

----Item stored by user----
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;

----Market stored items----
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;
			
----Guild item stored----			
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;

[andr3y_you96]

Thats not a way to fix it... its just a query to check if there are duped items alredy in game.

[Boul27]

Like I said :

I found this, not complette, but i good way to fix it

I know that it don't fix dup.
But if you put that in a trigger when char leave, and add "delete" at the good place, it will erease duped item.

It's an another way of fixing this by deleting duped item.

If I don't know how to do something, i search a way to do the same with the knowledge i have, or with things i found and understand.

That why i post the requests to find duped item ingame


But if someone try how to "hard fix" this, it will be very much better, i agree