Anti Dupe (Serial Checking)

Hello, I don't write here was for a long time.

Anyway, I like to know what you guys are using on your server to check dupe, items with the same serial.

I'm just doing a little research, to see what tools are available ;)

I don't wanna you send me the tool, maybe you have developed it yourself or you sell it.

Thanks, any information on this subject is helpful.

PEACE :ott1:

What server files season/version you need?

@Lineager,
To be honest, none.
Do you know any?

As far I know there are 3 DbVersion.
I'm a little outdated, so, maybe its a 4th now?

DbVersion 1 and 2 are 10 bytes per item.
DbVersion 3 are 16 bytes per item.

Are you use anything?
Do you have a item serial checking or you just ignore it?

As I said early, it's a research, maybe more like a market research.

Tell me what your need ;)

Thanks.

But a normal Antihack cant protect this either.
It's main.exe anti-hack that kind of thing. It protects from proxy. I only heard of coders doing such or premium files like igcn and z-team has it.
It cost a bomb for sure.
But here's a solution... ask KarLi. He he next best you can ask help.

- - - Updated - - -

The extremist coder are like 4funner , Z-team, Karli offer such service tho..
And IGCN.

I dont know if this is any good but i have tool for anti dupe try it out :) i found it in my old tool folder.
http://www.sendspace.com/file/vpg47o

@navossoc Don't listen to anything Linager he is a troll he was know as Big G-Ultrasonicex-Ph3x and etc.
And hes other account Big G got ban don't reply to him its a waste of time :)

Quote:

---

Originally Posted by dragonseth

I dont know if this is any good but i have tool for anti dupe try it out :) i found it in my old tool folder.
http://www.sendspace.com/file/vpg47o

@navossoc Don't listen to anything Linager he is a troll he was know as Big G-Ultrasonicex-Ph3x and etc.
And hes other account Big G got ban don't reply to him its a waste of time :)

---

My anti virus didn't liked that files too much.

Ramnit.p

O my bad dude i don't use virus protector cause it blocks programs cause it says it has viruses but it usually don't just the way it was coded.

-Dupe-Check Scan 3 minute Server and delete automatic any dupe-

<----- PRO
NOOB
...|
...|
...V

-[Dont Forget to Say Thanks]-

-[Download]-

http://www.girlshare.ro/33618504.7

- - - Updated - - -

Quote:

---

Originally Posted by dragonseth

I dont know if this is any good but i have tool for anti dupe try it out :) i found it in my old tool folder.
http://www.sendspace.com/file/vpg47o

@navossoc Don't listen to anything Linager he is a troll he was know as Big G-Ultrasonicex-Ph3x and etc.
And hes other account Big G got ban don't reply to him its a waste of time :)

---

-full with virus-

Quote:

---

Originally Posted by dragonseth

O my bad dude i don't use virus protector cause it blocks programs cause it says it has viruses but it usually don't just the way it was coded.

---

I don't think so, not in this case :P

Quote:

---

Originally Posted by Masteru

-Dupe-Check Scan 3 minute Server and delete automatic any dupe-

<----- PRO
NOOB
...|
...|
...V

-[Dont Forget to Say Thanks]-

-[Download]-

http://www.girlshare.ro/33618504.7

- - - Updated - - -



-full with virus-

---

I will give a try later and I come back to post the results, let's see ;)

[]'s

@Masteru

Thanks for all your help and information.
I made some tests.

The first file you provide is for DbVersion 1 or 2.
I don't have a database with sample data from 97d, so I can't test it...

I asked for a friend a copy of his database with some data for test, but I'm still waiting for it...

So, right now, I can't test it...

The second file you provide on PM is for DbVersion 3. (link below)

Quote:

---

-works for any version-

-but if not works try this version-

http://www.girlshare.ro/33618560.8

---

That file I could test and did some testing.

424436 inventories and 102296 warehouses.
(no extra warehouse, the program don't know how to check it)

It just crashes! it can't allocate so much memory on a 32 bits process.

It's OK, so I start to drop some inventories and warehouses by her first account letter.

When I reached at approximately:
99508 inventories and 24392 warehouses.

It worked! Took about 3 seconds to run and allocate a lot of memory...
But it's really fast, as expected.

My conclusion is:
The second program works, but it's limited to a number of items and don't check extra warehouses.
You can't use that on large servers, that's a problem...

Considering the number of replies to this topic, I believe that many people don't check the serial items on their servers.
As I said on the second post, this was more like a market research.

A few notes:
I have developed my own dupefinder a long time ago, it works on DbVersions (1,2,3) and check extra warehouses.

x86 release

Quote:

---

Execution Time: 12.391 ms
Dupe Items: 0
Serial0 Items: 0
Parsed Items: 12.765.416

---

x64 release

Quote:

---

Execution Time: 12.062 ms
Dupe Items: 0
Serial0 Items: 0
Parsed Items: 12.765.416

---

In 12 seconds I have checked 424436 inventories, 102296 warehouses and 78245 extwarehouses.
So, it took 4x more time, but I checked 4x more inventories and 7x more warehouses.

I tested it on my home PC, a Intel i7 930 with 6gb with SQL Server Express edition.
So in a dedicated server, the performance can be a lot better because of the hardware and the sql version. (sql express has some limitations)

It need a few changes to became a product, but, I don't think there is interest.
So don't worth the time.

Thanks @Masteru for your time and all the help.

[]'s

try with other anti dupe scripts