H1st0r1ans Promise

Killjoe2009 · 09/11/2009, 04:00

Does anyone think that all the du**p*ed items will be removed? Is ther a way to help avoid this?

~~~Twister~~~ · 09/11/2009, 04:09

nope, but you know acclaim...lol. However someday they will clean the market from duped ****.

MyLADYmagican · 09/11/2009, 18:10

twister thank oy ufor banning me i am ViciSummi i give you thanks

~~~Twister~~~ · 09/11/2009, 19:39

Quote:

Originally Posted by MyLADYmagican

twister thank oy ufor banning me i am ViciSummi i give you thanks

well you asked for it lol....I didn't ban you, i reported you. You got banned by MODs.

Vaidas B · 09/11/2009, 19:41

Quote:

Originally Posted by MyLADYmagican

twister thank oy ufor banning me i am ViciSummi i give you thanks

twister didint ban u, u got banned couse u were stupid, in other words, u gave people an infected trainer telling them its urs even if we ALL know its not and told u that its against EVERY rule in the forum.....

DontLieToMe · 09/11/2009, 23:53

Quote:

Originally Posted by Killjoe2009

Is ther a way to help avoid this?

Each items has a "code" associated with it that is supposed to uniquely identify it.

Unless you can hack the database and change that code.. you are going to lose your duplicated items. Easy as an SQL query.

ItsNobody · 09/12/2009, 01:46

No each item doesnt...every 130 wand +9 has the same index and code as the next +9 130 wand. Hist is bluffing

~~~Twister~~~ · 09/12/2009, 02:05

Quote:

Originally Posted by ItsNobody

No each item doesnt...every 130 wand +9 has the same index and code as the next +9 130 wand. Hist is bluffing

he doesn't lol. Each item that drops has assigned code. Same index but not the same code. they already did it once, will do it again

Killjoe2009 · 09/17/2009, 01:42

I sure hope he is bluffing, not that I ever dup- ed anything before, but just because I have bought so much stuff.

He sure seems adamant though that all dup- ed stuff is going to go.

But I do remember late 2007 something happening, It didnt affect me at all. But did anyone ever lose any items that they thought may have been dup- ed to acclaim taking them away?

Gentleman Jack · 09/17/2009, 01:57

Quote:

Originally Posted by ItsNobody

No each item doesnt...every 130 wand +9 has the same index and code as the next +9 130 wand. Hist is bluffing

nope wrong all +9 items get registered with a special code.
The codes include a chiffred char name of owner maker time and date etc.+amth like a serial

Quote:

Originally Posted by Killjoe2009

I sure hope he is bluffing, not that I ever dup- ed anything before, but just because I have bought so much stuff.

He sure seems adamant though that all dup- ed stuff is going to go.

But I do remember late 2007 something happening, It didnt affect me at all. But did anyone ever lose any items that they thought may have been dup- ed to acclaim taking them away?

2 chars got banned 2 secs after i duped 8 +8parts ^^16+8 gone -.-

monster10888 · 09/17/2009, 02:05

if you know 100% they are duped then i would sell em

DontLieToMe · 09/17/2009, 06:30

Let me give you a prime example. Look at the item serials.

In this example not only was the item duplicated, but they tried to upgrade the +8 again after it was already made +9 and traded to another player.

the image is from 2moons support site

Duplicated, upgraded and soon to be gone forever.

For those of you running private servers.. try this little bit of sql in your analyzer to find all of the duplicates on the characters.

Code:

use [character]
go

select wIndex,dwSerialNumber, count(*) as cnt from user_bag with(nolock) where dwSerialNumber != 0x00000000000000000000000000000000
group by wIndex,dwSerialNumber
having count(*) > 1

Do you think I know what I'm talking about?

Killjoe2009 · 09/18/2009, 09:12

Ok so this post is saying even if the copy of the duped item is deleted or at least "blown up" then there still is a record of it, and confirms each item has a unique number. So that means if anyone has a duped item, you need to sell both copies ( all copies) even if the others got blown up, because neither may be around shortly. Also stop buying items and start hording cash. I think legit items after the merge will go for top dollar and dil prices (ok goods) will likey go back up. Argate also will be good to hold onto as they wont be as easy to farm.

I asssume the area in red was witheld buy the author to preserve his annonminity. But it means they can still get your name and maybe even ban you if they wanted to.

My only thought is that serial number us huge. And all the items in game must be astronomical. To check each item agaisnt each other would take a good amount of cpu power. Maybe even a full days worth of scanning and so forth. Perhaps they could dl the game stats to another cpu and then run it offline. Would be intersting to find out what their strategy is to pull this off.

thx for the input

gabriel.gray · 09/18/2009, 11:47

"My only thought is that serial number us huge. And all the items in game must be astronomical."

Actually no. There is most likely an index on that column so the SQL query that find dupes is executing very fast. It is not days but minute(s)

Zombe · 09/18/2009, 15:03

Quote:

Originally Posted by ItsNobody

No each item doesnt...every 130 wand +9 has the same index and code as the next +9 130 wand. Hist is bluffing

No, dude, in this case you are wrong.

See the pictures below:

Spoiler

dwSerialNumber is the serial number. Duping dupes the dwSerialNumber, and every item has a unique one.
So basicly, a simple query can delete all rows that have the same dwSerialNumber = all duped items AND the items you duped from will be gone.
He has done it before, he will do it again. I am just surprised acclaim doesn't do it like every 1 week...

Oh ****, DontLieToMe explained it before me. Put ur img into a [spoiler] tag!
Uh... Acclaim uses MSSQL2008 -.-''