[SQL]Check dupe items

[cok28rus]

-- 1 Check 'CharItems'
DECLARE @Dupe_Items bigint
SET @Dupe_Items = (SELECT ItemUID FROM PS_GameData.dbo.CharItems where del=0 GROUP BY ItemUID HAVING (COUNT(ItemUID)>1))
SELECT c.ItemUID ,c.CharID,c.ItemID,c.Maketime,u.CharName,u.UserUID,d.ItemName,b.Status,b.UserIP,b.Leave,c.Count,b.JoinDate,b.LeaveDate 
FROM PS_GameData.dbo.CharItems AS c
INNER JOIN PS_GameData.dbo.Chars AS u ON c.CharID=u.CharID 
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_UserData.dbo.Users_Master AS b ON u.UserUID=b.UserUID
where  c.del=0 and c.ItemUID=@Dupe_Items


-- 2 Check 'UserStoredItems'
DECLARE @Dupe_Items3 bigint
SET @Dupe_Items3 = (SELECT ItemUID FROM PS_GameData.dbo.UserStoredItems where del=0 GROUP BY ItemUID HAVING ( COUNT(ItemUID)>1 ))
SELECT c.ServerID,c.ItemUID ,c.ItemID,d.ItemName,c.Maketime,b.UserUID,b.UserID,b.Pw,b.Status,b.UserIP,b.Leave,c.Count,b.JoinDate,b.LeaveDate 
FROM PS_GameData.dbo.UserStoredItems AS c
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_UserData.dbo.Users_Master AS b ON c.UserUID=b.UserUID
where  c.del=0  and c.ItemUID = @Dupe_Items3


-- 3 Check 'MarketItems'
DECLARE @Dupe_Items8 bigint
SET @Dupe_Items8 = (SELECT c.ItemUID FROM PS_GameData.dbo.MarketItems as c INNER JOIN PS_GameData.dbo.Market AS y ON c.MarketID=y.MarketID where y.del=0 GROUP BY c.ItemUID HAVING ( COUNT(c.ItemUID)>1 ) )
SELECT c.MarketID,c.ItemID,c.ItemUID,d.ItemName,c.Maketime,u.CharID,u.CharName,b.UserUID,b.Status,b.UserIP,b.Leave,c.Count,b.JoinDate,b.LeaveDate 
FROM PS_GameData.dbo.MarketItems as c
INNER JOIN PS_GameData.dbo.Market AS y ON c.MarketID=y.MarketID
INNER JOIN PS_GameData.dbo.Chars AS u ON y.CharID=u.CharID 
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_UserData.dbo.Users_Master AS b ON u.UserUID=b.UserUID
where  y.del=0 and c.ItemUID = @Dupe_Items8


-- 4 Check 'GuildStoredItems'
DECLARE @Dupe_Items9 bigint
SET @Dupe_Items9 = (SELECT ItemUID FROM PS_GameData.dbo.GuildStoredItems where del=0 GROUP BY ItemUID HAVING ( COUNT(ItemUID)>1 ))
SELECT c.GuildID,u.GuildName,u.MasterName,c.ItemUID,c.ItemID,d.ItemName,c.Count,c.MakeTime
FROM PS_GameData.dbo.GuildStoredItems as c
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_GameData.dbo.Guilds AS u ON c.GuildID=u.GuildID
where  c.del=0 and c.ItemUID = @Dupe_Items9


--///////////////// Cross Base \\\\\\\\\\\\\\\\\\\\\----
--5  Check 'CharItems - UserStoredItems'
SELECT c.ItemUID ,c.CharID,c.ItemID,c.Maketime,u.CharName,u.UserUID,d.ItemName,b.Status,b.UserIP,b.Leave,c.Count,b.JoinDate,b.LeaveDate,w.UserUID,b.UserID,b.Pw
FROM PS_GameData.dbo.CharItems AS c
INNER JOIN PS_GameData.dbo.Chars AS u ON c.CharID=u.CharID 
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_UserData.dbo.Users_Master AS b ON u.UserUID=b.UserUID
INNER JOIN PS_GameData.dbo.UserStoredItems AS w  ON c.ItemUID=w.ItemUID
where  c.del=0 and c.ItemUID IN (SELECT  ItemUID FROM PS_GameData.dbo.UserStoredItems where del=0 and  ServerID=1 )

--///////////////// Cross Base \\\\\\\\\\\\\\\\\\\\\----
--6 Check 'CharItems - MarketItems'
SELECT c.ItemUID ,c.CharID,c.ItemID,c.Maketime,u.CharName,u.UserUID,d.ItemName,b.Status,b.UserIP,b.Leave,c.Count FROM PS_GameData.dbo.CharItems AS c
INNER JOIN PS_GameData.dbo.Chars AS u ON c.CharID=u.CharID 
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_UserData.dbo.Users_Master AS b ON u.UserUID=b.UserUID
where c.del=0 and  c.ItemUID IN (SELECT  x.ItemUID FROM PS_GameData.dbo.MarketItems AS x INNER JOIN PS_GameData.dbo.Market AS y ON x.MarketID=y.MarketID where y.del=0 )

--///////////////// Cross Base \\\\\\\\\\\\\\\\\\\\\----
--7 Check 'CharItems - GuildStoredItems'
SELECT c.ItemUID ,c.CharID,c.ItemID,c.Maketime,u.CharName,u.UserUID,d.ItemName,b.Status,b.UserIP,b.Leave,c.Count FROM PS_GameData.dbo.CharItems AS c
INNER JOIN PS_GameData.dbo.Chars AS u ON c.CharID=u.CharID 
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_UserData.dbo.Users_Master AS b ON u.UserUID=b.UserUID
where c.del=0 and c.ItemUID IN (SELECT  ItemUID FROM PS_GameData.dbo.GuildStoredItems where del=0 )

--///////////////// Cross Base \\\\\\\\\\\\\\\\\\\\\----
--8 Check 'UserStoredItems - GuildStoredItems'
DECLARE @Dupe_Items5 bigint
SET @Dupe_Items5 =
(SELECT ItemUID FROM PS_GameData.dbo.UserStoredItems
where del='False'and ServerID=1 and 
ItemUID IN (SELECT  ItemUID FROM PS_GameData.dbo.GuildStoredItems where del=0))
SELECT c.ServerID,c.ItemUID ,c.ItemID,d.ItemName,c.Maketime,b.UserUID,b.UserID,b.Pw,b.Status,b.UserIP,b.Leave,c.Count,b.JoinDate,b.LeaveDate 
FROM PS_GameData.dbo.UserStoredItems AS c
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_UserData.dbo.Users_Master AS b ON c.UserUID=b.UserUID
where  c.del=0  and c.ItemUID = @Dupe_Items5


--///////////////// Cross Base \\\\\\\\\\\\\\\\\\\\\----
--9 Check 'UserStoredItems - MarketItems'
DECLARE @Dupe_Items6 bigint
SET @Dupe_Items6 =
(SELECT ItemUID FROM PS_GameData.dbo.UserStoredItems
where del='False'and ServerID=1 and  
ItemUID IN (SELECT  x.ItemUID FROM PS_GameData.dbo.MarketItems AS x INNER JOIN PS_GameData.dbo.Market AS y ON x.MarketID=y.MarketID where y.del=0 ))
SELECT c.MarketID,c.ItemID,c.ItemUID,d.ItemName,c.Maketime,u.CharID,u.CharName,b.UserUID,b.Status,b.UserIP,b.Leave,c.Count,b.JoinDate,b.LeaveDate 
FROM PS_GameData.dbo.MarketItems as c
INNER JOIN PS_GameData.dbo.Market AS y ON c.MarketID=y.MarketID
INNER JOIN PS_GameData.dbo.Chars AS u ON y.CharID=u.CharID 
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_UserData.dbo.Users_Master AS b ON u.UserUID=b.UserUID
where  y.del=0 and c.ItemUID = @Dupe_Items6



--///////////////// Cross Base \\\\\\\\\\\\\\\\\\\\\----
--10 Check 'GuildStoredItems - MarketItems'
DECLARE @Dupe_Items7 bigint
SET @Dupe_Items7 =
(SELECT ItemUID FROM PS_GameData.dbo.GuildStoredItems
where  del=0 and ItemUID IN (SELECT  x.ItemUID FROM PS_GameData.dbo.MarketItems AS x INNER JOIN PS_GameData.dbo.Market AS y ON x.MarketID=y.MarketID where y.del=0 ))
SELECT c.MarketID,c.ItemID,c.ItemUID,d.ItemName,c.Maketime,u.CharID,u.CharName,b.UserUID,b.Status,b.UserIP,b.Leave,c.Count,b.JoinDate,b.LeaveDate 
FROM PS_GameData.dbo.MarketItems as c
INNER JOIN PS_GameData.dbo.Market AS y ON c.MarketID=y.MarketID
INNER JOIN PS_GameData.dbo.Chars AS u ON y.CharID=u.CharID 
INNER JOIN PS_GameDefs.dbo.Items AS d ON c.ItemID=d.ItemID
INNER JOIN PS_UserData.dbo.Users_Master AS b ON u.UserUID=b.UserUID
where  y.del=0 and c.ItemUID = @Dupe_Items7

[nubness]

Here's how you check for duped items like a boss.