Quote:
Originally Posted by RyoriSan :3
|
Dayum ;d If I was a server owner I'd now use something like..
Code:
SELECT c.CharID, CharName16, COUNT(1) iC
FROM dbo._Items t with(NOLOCK)
JOIN dbo._Inventory i with(NOLOCK) on t.ID64 = i.ItemID
JOIN dbo._Char c with(NOLOCK) on i.CharID = c.CharID
WHERE t.RefItemID = 24408
GROUP BY CharName16, c.CharID
ORDER BY iC desc
Pick the one that was active the most in the last few days with a decent amount of duped items. Build something to observe the item movements through procedures of that character and hope for something to find to avoid the further duping ;d
[Only registered and activated users can see links. Click Here To Register...]