H1st0r1ans Promise

Page 1 of 2 1 2
09/11/2009 04:00 Killjoe2009#1
Does anyone think that all the du**p*ed items will be removed? Is ther a way to help avoid this?
09/11/2009 04:09 ~Twister~#2
nope, but you know acclaim...lol. However someday they will clean the market from duped shit.
09/11/2009 18:10 MyLADYmagican#3
twister thank oy ufor banning me i am ViciSummi i give you thanks
09/11/2009 19:39 ~Twister~#4
Quote:
Originally Posted by MyLADYmagican View Post
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.
09/11/2009 19:41 Vaidas B#5
Quote:
Originally Posted by MyLADYmagican View Post
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..... :facepalm:
09/11/2009 23:53 DontLieToMe#6
Quote:
Originally Posted by Killjoe2009 View Post
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.
09/12/2009 01:46 ItsNobody#7
No each item doesnt...every 130 wand +9 has the same index and code as the next +9 130 wand. Hist is bluffing
09/12/2009 02:05 ~Twister~#8
Quote:
Originally Posted by ItsNobody View Post
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 ;)
09/17/2009 01:42 Killjoe2009#9
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?
09/17/2009 01:57 Gentleman Jack#10
Quote:
Originally Posted by ItsNobody View Post
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 View Post
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 -.-
09/17/2009 02:05 monster10888#11
if you know 100% they are duped then i would sell em :)
09/17/2009 06:30 DontLieToMe#12
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.

[Only registered and activated users can see links. Click Here To Register...]
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?
09/18/2009 09:12 Killjoe2009#13
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
09/18/2009 11:47 gabriel.gray#14
"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)
09/18/2009 15:03 Zombe#15
Quote:
Originally Posted by ItsNobody View Post
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:

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 crap, DontLieToMe explained it before me. Put ur img into a [spoiler] tag!
Uh... Acclaim uses MSSQL2008 -.-''
Page 1 of 2 1 2