Fix Antidup

01/27/2015 17:55 _SCoRp_#1

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.:handsdown:

01/27/2015 19:17 Cansas59#2

i seaching too

01/27/2015 21:44 andr3y_you96#3

[Only registered and activated users can see links. Click Here To Register...]
Also the databese gamelog posted by nubness has some checks too if im not wrong.

01/28/2015 08:56 Boul27#4

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

Code:

----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;

01/28/2015 16:16 andr3y_you96#5

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

01/28/2015 19:25 Boul27#6

Like I said :

Quote:

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 ;)