I have been working on this for the past couple of days; a way to solve the infamous dupe problems plaguing RF servers. Now, I think I have found a… “way” more than a solution.
I am not going to go into any detail but here are the basics on what you should know, should you decide to use this!
  1. This has not been widely tested, so if things go wrong they can also go very wrong
  2. The fix has the “capacity” to cause a significant increase in server load
  3. I haven’t actually tested it for all dupes except the most common ones (reward, ah) as I do not know how to perform all the dupes. But, the assumption I am making is; all dupes require the usage of tbl_inven. Therefore, this fixes all the dupes
  4. Please take note. Data in the “ItemLogs” table does not contain “people duping”. No, it is simply data of all the players items! This script does not “catch” or “log” dupers, it PREVENTS dupes! The ItemLogs table is required to PREVENT (not log!) dupes

    This script is untested. Use at your own risk!

So the biggest message of them all is: Use at your own risk! But I will help and would gladly accept any feedback from servers that do use this!
How to start?
First create the required tables:
view plainprint?
01CREATE TABLE [dbo].[ItemLogs](
02[id] [int] IDENTITY(1,1) NOT NULL,
03[serial] [int] NOT NULL,
04[k_value] [int] NOT NULL,
05[s_value] [bigint] NOT NULL,
06[s_column] [varchar](10) NOT NULL,
07CONSTRAINT [PK_ItemLogs] PRIMARY KEY CLUSTERED
08(
09[id] ASC
10)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
11) ON [PRIMARY]
12 
13GO
14 
15CREATE NONCLUSTERED INDEX [IX_ItemLogs_k] ON [dbo].[ItemLogs]
16(
17[k_value] ASC
18)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
19GO
20 
21CREATE NONCLUSTERED INDEX [IX_ItemLogs_s] ON [dbo].[ItemLogs]
22(
23[s_value] ASC
24)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
25GO
26 
27CREATE NONCLUSTERED INDEX [IX_ItemLogs_serial] ON [dbo].[ItemLogs]
28(
29[serial] ASC
30)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
31GO

Ini Hanya membeli lengkap full script .. anti dupe semuanya .. kalo mau beli silahkan hubungi saya di facebook