Fix Molten Core loot.

[Armilus]

The item ID's are an auto incrementing field in the database. As they added items during development each item added is automatically given the next available ID number.

Since instances like dire maul or BWL have a much longer development time than say adding items to existing instances, the ID's aren't going to match up perfectly. For example, while patch 1.3 was live, they could have been working on BWL already and creating items for it but BWL was not released until 1.6. Later on, when 1.4 is live, they add items to existing bosses in MC and these items go live in patch 1.5. As a result the items added to MC in 1.5 could potentially have higher ID's than items added with BWL in patch 1.6.

This means you can't just look at 2 items ID's and say "this was patch 1.5 and that was patch 1.6"; however, you can look at all of the item ID's from a particular boss, say Magmadar (set pieces ignored to keep the list shorter):
http://db.vanillagaming.org/?item=17065
http://db.vanillagaming.org/?item=17069
http://db.vanillagaming.org/?item=17073
http://db.vanillagaming.org/?item=18203
http://db.vanillagaming.org/?item=18820
http://db.vanillagaming.org/?item=18821
http://db.vanillagaming.org/?item=18822
http://db.vanillagaming.org/?item=18823
http://db.vanillagaming.org/?item=18824
http://db.vanillagaming.org/?item=18829
http://db.vanillagaming.org/?item=18861
http://db.vanillagaming.org/?item=19136
http://db.vanillagaming.org/?item=19142
http://db.vanillagaming.org/?item=19143
http://db.vanillagaming.org/?item=19144

Does anyone else see a pattern forming here?

The items starting with 17xxx were likely on the loot table at release.

From the official patch notes, we know that items were added to MC bosses in 1.4:
"Onyxia, Azuregos, Lord Kazzak, and all Molten Core boss creatures have all received some new items on their loot tables."

We also know that additional items were added in patch 1.5:
"Additional new raid items have been added to the treasure lists for Azuregos, Lord Kazzak, and bosses in Molten Core."

So, we have 3 distinct groupings of item ID's (which means that these items were developed around the same time), items were added to MC bosses twice, once in patch 1.4 and once in patch 1.5. The truth is pretty obvious at this point but just to make sure we can check a few sites like thottbot and allakhazam on web archive to see if we see anything that disproves the theory. Note that if an item first appears later than we would expect that isn't conclusive, it's possible that the item page wasn't cataloged by web archive until later and no comments were posted.

As I'm sure most of you remember, back in vanilla the game client updates were usually available a few days before the patch went live on the server. Sites like thottbot and allakhazam mined the data files that came with the client to generate lists of items BEFORE the patch went live. This is why many items have comments on them 2-3 days before the patch date.

[Cataclysm]

As I stated. There were a lot of items added to Molten Core in 1.4 and later. The pattern you can see is that items such as Striker's Mark, Medallion of Steadfast Might and Earthshaker all have item ID's in the early 17000s.

Since it's pretty much confirmed at this point that the server database is in fact just a straight out copy of whatever items were on alakhazam for the pre-1.4 dates, I wanted to clear something up.

Looking at items and trying to figure out what was added when is not hard. Wowwiki aka the pinnacle of accuracy lists Head of Nefarian as "Added in 1.6" even though logically with an itemID of 19002 it should be in the game starting patch 1.5. This makes more sense when you look at the patch release dates, and realize that with 1 month to BWL most work was probably done including adding items.

I tried to list the items that I believe with as much evidence as I so far could provide should be in the game.

[Clank]

Ragnaros is dropping loot, you may have encounter a bug, we will investigate the issue and keep you inform.
We may need information about Ragnaros death circumstances.
Majordomo is not suppose to give a chest before 1.4.

[Armilus]

As I stated. There were a lot of items added to Molten Core in 1.4 and later. The pattern you can see is that items such as Striker's Mark, Medallion of Steadfast Might and Earthshaker all have item ID's in the early 17000s.

Since it's pretty much confirmed at this point that the server database is in fact just a straight out copy of whatever items were on alakhazam for the pre-1.4 dates, I wanted to clear something up.

Looking at items and trying to figure out what was added when is not hard. Wowwiki aka the pinnacle of accuracy lists Head of Nefarian as "Added in 1.6" even though logically with an itemID of 19002 it should be in the game starting patch 1.5. This makes more sense when you look at the patch release dates, and realize that with 1 month to BWL most work was probably done including adding items.

I tried to list the items that I believe with as much evidence as I so far could provide should be in the game.

I wasn't disagreeing with you, was just expanding upon what you started with. Anyway, the dev's are well aware of the item ID's method because I told them about it months ago and I'm pretty sure it was used in figuring out the MC loot tables.

[Zach]

I wasn't disagreeing with you, was just expanding upon what you started with. Anyway, the dev's are well aware of the item ID's method because I told them about it months ago and I'm pretty sure it was used in figuring out the MC loot tables.

It clearly wasn't because they're fucked...

[Imbaslap]

great find though cataclysm, we had months worth of discussions about this pre 1.4 item list during the entire beta when it was initially announced with lots of data and sources of what should and shouldn't be accurate.

there was a big stink about testing Thunderfury as well and making sure it matched the 1.12.1 version 100%.

I don't know how much the devs took from those discussions or data, but so far there are still things that are missed.
I mean, look at the r12/13 hunter chest and legs in atlas. (255 all stats and 100 all res).
that alone will tell you some things were clearly missed. (reported 5 times already, same with the stats on viskag being incorrect)

but hey, I'm no dev or GM. just a dedicated tester and veteran of the game. we can only do so much as players.

[Armilus]

I wasn't disagreeing with you, was just expanding upon what you started with. Anyway, the dev's are well aware of the item ID's method because I told them about it months ago and I'm pretty sure it was used in figuring out the MC loot tables.

It clearly wasn't because they're fucked...

Still waiting to see some examples (other than ragnaros dropping no loot, that is obviously wrong).

Why don't you post the loot that you guys got off each boss?

[Imbaslap]

I wasn't disagreeing with you, was just expanding upon what you started with. Anyway, the dev's are well aware of the item ID's method because I told them about it months ago and I'm pretty sure it was used in figuring out the MC loot tables.

It clearly wasn't because they're fucked...

Still waiting to see some examples (other than ragnaros dropping no loot, that is obviously wrong).

Why don't you post the loot that you guys got off each boss?

I believe the grizzly officers submitted that info already to the devs and GM's. as I am sure they want rag loot next week.

we'll see though, just keep providing the info and keep it up to date and clear as possible.

[Zach]

I wasn't disagreeing with you, was just expanding upon what you started with. Anyway, the dev's are well aware of the item ID's method because I told them about it months ago and I'm pretty sure it was used in figuring out the MC loot tables.

It clearly wasn't because they're fucked...

Still waiting to see some examples (other than ragnaros dropping no loot, that is obviously wrong).

Why don't you post the loot that you guys got off each boss?

If the items existed you'd be able to link them ingame. Go look at atlasloot and look at which items you can actually see. Salamander scale pants, Finkle's, Eye of Divinity, Band of Accuria, Malistar's Defender, etc do not exist.

[Armilus]

If the items existed you'd be able to link them ingame. Go look at atlasloot and look at which items you can actually see. Salamander scale pants, Finkle's, Eye of Divinity, Band of Accuria, Malistar's Defender, etc do not exist.

So... what's the problem? Those items were all added in 1.4

Edit: I was wrong, Band of Accuria should be pre-1.4.