WoWEquip/Item Database

• alcaras · 02/20/07, 8:20 AM

WoWEquip is sadly out of date... does anyone know of a replacement?

Alternatively, is there somewhere I could down a CSV with a complete item database? I'd like to, at a minimum, weigh stats and then look through all the items quickly to see which items weigh highest for each slot. As a stretch goal, being able to dump it into Excel and use Solver would be amazing.

How do people search for the best gear combinations now a days? Going through Wowhead or thottbot item by item seems really painful to me.

sp00n · 02/21/07, 6:37 AM

Wow, if there was a page with a complete item database, that is downloadable, I'd be *very* interested in it as well.
Because entering every single item manually is very tedious, time consuming and error prone (which is why I didn't even start on warrior gear yet).

cladhaire · 02/21/07, 6:46 AM

You can do an advanced item search on wow.allakhazam.com, and give each stat a "weight" the helps you calculate your own "score" for an item. Its really neat.

Here's a druid example (post 89)

http://forums.worldofwarcraft.com/th...sid=1&pageNo=5

• alcaras · 02/21/07, 11:27 AM

Originally Posted by cladhaire

You can do an advanced item search on wow.allakhazam.com, and give each stat a "weight" the helps you calculate your own "score" for an item. Its really neat.

Here's a druid example (post 89)

http://forums.worldofwarcraft.com/th...sid=1&pageNo=5

http://wow.allakhazam.com/db/itemadvsearch.html?x

That unfortunately only allows 3 stats to be weighed, and I'd like to weigh by more than that (str, sta, hitr, critr, agi, armor, attack power, resilience). There is, stat-sorting, but as I understand it, it'll just sort ties in weights in order of the stat-sort, which isn't quite what I'm looking for.

cladhaire · 02/21/07, 12:45 PM

aye... i wish wowhead would add a feature like that.

Ultramax · 02/21/07, 12:50 PM

The wowequip author has stated on his forums that he's working on a new version for BC. You can still import items from Alla if you want to.
Unfortunately I know of nothing that works with sockets which makes playing dress up kind of hard. Unless you're just going to assume +12 sta in every socket.

Gyshall · 02/21/07, 1:07 PM

Originally Posted by Ultramax

The wowequip author has stated on his forums that he's working on a new version for BC. You can still import items from Alla if you want to.
Unfortunately I know of nothing that works with sockets which makes playing dress up kind of hard. Unless you're just going to assume +12 sta in every socket.

The current WoWEquip has an item editor, you can edit in sockets as "Bonuses" as a placeholder for Sockets.

The raw XML of an imported Warbringer Greathelm:

<?xml version="1.0"?>
<!--Item XML created by Danya's WoW Template Designer-->
<Item Slot="Head">
	<Name>Warbringer Battle-Helm</Name>
	<URL>http://wow.allakhazam.com/db/item.html?witem=29021</URL>
	<Icon>INV_Helmet_58.tga</Icon>
	<Rarity>Epic</Rarity>
	<BOP>true</BOP>
	<Type>Plate</Type>
	<Armor>1080</Armor>
	<ClassFlags>256</ClassFlags>
	<RaceFlags>254</RaceFlags>
	<RequiredLevel>70</RequiredLevel>
	<Set>Warbringer Battlegear</Set>
	<Stats>
		<Stat Value="40">Strength</Stat>
		<Stat Value="39">Stamina</Stat>
	</Stats>
	<Bonuses>
		<Bonus Type="Equip" Value="10">Increases your hit rating by #.</Bonus>
		<Bonus Type="Equip" Value="20">Increases your critical strike rating by #.</Bonus>
	</Bonuses>
</Item>

The raw XML of my "socketed" Warbringer Greathelm:

<?xml version="1.0"?>
<!--Item XML created by Danya's WoW Template Designer-->
<Item Slot="Head">
	<Name>Warbringer Greathelm [Socketed]</Name>
	<URL>http://wow.allakhazam.com/db/item.html?witem=29011</URL>
	<Icon>INV_Helmet_58.tga</Icon>
	<Rarity>Epic</Rarity>
	<BOP>true</BOP>
	<Type>Plate</Type>
	<Armor>1080</Armor>
	<ClassFlags>256</ClassFlags>
	<RaceFlags>254</RaceFlags>
	<RequiredLevel>70</RequiredLevel>
	<ItemLevel>100</ItemLevel>
	<Set>Warbringer Armor</Set>
	<Stats>
		<Stat Value="13">Strength</Stat>
		<Stat Value="14">Agility</Stat>
		<Stat Value="77">Stamina</Stat>
	</Stats>
	<Bonuses>
		<Bonus Type="Equip" Value="21">Increases defense rating by #.</Bonus>
		<Bonus Type="Equip" Value="15">Increases your block rating by #.</Bonus>
		<Bonus Type="Equip" Value="33">Increases the block value of your shield by #.</Bonus>
		<Bonus Type="Equip" Value="1">[Solid Star of Elune]x# - +12 Stamina per socket.</Bonus>
		<Bonus Type="Equip" Value="1">[Powerful Earthstorm Diamond]x# - +18 Stamina per socket.</Bonus>
	</Bonuses>
</Item>

A crude work-around at best, but you can still see the total number of gems needed for a certain setup. There are also other minor details - such as socket bonuses - that can't really be "hacked" like this. I ended up just adding the +Stamina and +Defense ratings to the base stats/item totals.

Humbaba · 02/21/07, 4:18 PM

You could always download http://wow.allakhazam.com/itemlist.xml and parse out the names, pulling the pages individually and converting to the item id. This is what itemstats does.

Here's the Warbringer Greathelm http://wow.allakhazam.com/dev/wow/it...pl?witem=29011

It has socket information in the xml.

Gyshall · 02/21/07, 4:25 PM

Originally Posted by Humbaba

You could always download http://wow.allakhazam.com/itemlist.xml and parse out the names, pulling the pages individually and converting to the item id. This is what itemstats does.

Here's the Warbringer Greathelm http://wow.allakhazam.com/dev/wow/it...pl?witem=29011

It has socket information in the xml.

This is true, but the problem at hand is that WoWEquip doesn't currently recognize Sockets on gear.

Humbaba · 02/21/07, 5:24 PM

Originally Posted by Gyshall

This is true, but the problem at hand is that WoWEquip doesn't currently recognize Sockets on gear.

I didn't phrase my response properly. I don't use WoWEquip. I was just offering alcaras a way to get a database populated with items.

• alcaras · 02/22/07, 1:47 AM

Originally Posted by Humbaba

You could always download http://wow.allakhazam.com/itemlist.xml and parse out the names, pulling the pages individually and converting to the item id. This is what itemstats does.

Here's the Warbringer Greathelm http://wow.allakhazam.com/dev/wow/it...pl?witem=29011

It has socket information in the xml.

Ah, that's very nice -- I didn't know about itemlist.xml and had scripts for parsing individual allakahzam items, but there was the bottleneck of having to get itemIDs...

Thanks!

Hrm, hitting it right now gives me a:
XML Parsing Error: unclosed token
Location: http://wow.allakhazam.com/itemlist.xml
Line Number 18382, Column 3

Humbaba · 02/23/07, 10:14 AM

I was just able to load the itemlist in IE, but not Firefox. I had the same problem when I originally posted it, but it did eventually load in Firefox. The file is somewhere between "huge" and "frickin huge" so take proper precautions in your code when you try to retrieve it.

Rule · 02/23/07, 8:09 PM

I used to use wowequip all the time, but it's seriously taking whoever made it way too long to update it to work with sockets. Same with ctprofiles. Doing it manually with wowequip's create item and edit item features are pretty tedious and crude as mentioned.

I'm really close to the point of sitting down and figuring out how to code an excel spreadsheet or coding an access dbase app for personal use, because going without it really sucks.

Hopefully someone will beat me to it, because i'm thinking the best way would be an access dbase app, but that's a lot of work to start it from scratch

sp00n · 02/28/07, 3:58 AM

Well I have a list with warrior and rogue equipment (link).
The problem is, while I have somewhat updated the list for rogues, my warrior is currently still sitting at level 61 and I did not found enough time to enter items for warriors.

Moreover, since patch 2.0 hit with the introduction of the rating system, I have not updated all values of the old items. Additionally the armor values did increase a bit with the patch, they are as well on their old values so far.

The problem is I have to enter each item manually as I currently have no real idea on how to do this via XML parsing or similar.

Therefore if anybody wants to help expand the list, I would be grateful, as you know this is a hell of a work to manage.

You can find the database structure in the excel spreadsheet I posted below, there are some examples in it.
If somebody is bored and wants to do some stupid copy&paste, feel free to do so.

http://sp00n.pytalhost.com/wow/example.xls

Danya · 03/06/07, 7:58 PM

Ho hum, I know it's taking a while, but sockets are coming to WowEquip. Basic support is in, but I've introduced a really horrible bug in the item loading code so I can't release anything at present. I'll try to get it all sorted out this week.

• alcaras · 03/08/07, 9:23 AM

Originally Posted by Danya

Ho hum, I know it's taking a while, but sockets are coming to WowEquip. Basic support is in, but I've introduced a really horrible bug in the item loading code so I can't release anything at present. I'll try to get it all sorted out this week.

Great news! Thanks so much for your work on it and good luck fixing that bug!

Looking forward to seeing the release.

• alcaras · 03/08/07, 8:47 PM

I've been experimenting with itemlist.xml and itemstats, and before I embark on writing a complete parser for the item_html (the tooltip, basically), has anyone already written one I can borrow?

I know there's xml information available for each item from allakhazam, but its format seems rather 'heavy' -- e.g. crit rating links to a different spell for each amount of crit rating, which then would need to be parsed to see how much crit rating it gives... it seems a lot simpler to just parse the tooltip.

BugRoger · 03/09/07, 8:44 AM

Have you tried to pull the data directly from the armory? The format seems to be rather elegant. Do "View Source" to see the xml. And you don't need to go start parsing html.

http://armory.wow-europe.com/item-tooltip.xml?i=28963

• alcaras · 03/09/07, 1:24 PM

Originally Posted by BugRoger

Have you tried to pull the data directly from the armory? The format seems to be rather elegant. Do "View Source" to see the xml. And you don't need to go start parsing html.

http://armory.wow-europe.com/item-tooltip.xml?i=28963

I have not!

That data is very clean, compared to allakhazam's database structure.

Thanks for sharing

• alcaras · 03/11/07, 4:11 PM

Hmm, allakhazam apparently doesn't know about block rating...
compare:
http://wow.allakhazam.com/db/item.ht...ve;witem=29011
to
http://www.wowhead.com/?item=29011

Anyone else seeing this?

--

In any case, using some creative scripting, I put together a sample spreadsheet of plate chestpieces and their relevant warrior stats.

This version just has chestpieces, but I'd like to share it with others in hopes of getting feedback in terms of what folks like, what folks don't like and what people would like to see:
http://spreadsheets.google.com/pub?k...YH7vcvhA_j4pLQ

Known Shortcomings
- No Socket Bonus
- Block Rating isn't showing up (this is a bug with allakhazam)

Copernicus · 04/06/07, 3:13 PM

Did you ever make a simple item database or item database creator? I want to work on one for various projects, but my knowledge of how to parse webpages is nonexistent.

• Disquette · 04/06/07, 3:48 PM

yah, it is conceptually very easy to get everything in the armory that way Copernicus. I'm not sure if I want to commit to spending the time to do so (easy doesnt mean quick :p ). I'll think about it.

• Disquette · 04/07/07, 2:00 PM

I have posted a new thread in the "class mechanics" forum, due to the fact that I think the people there will have an over all greater use for this than the small subset of us who write mods and the like. I hope i dont make gurg or kaubel angry by doing so, but it makes more sense in my mind to have it there.

Danya · 06/09/07, 9:36 PM

Dunno if anyone is still interested in this, but I've just uploaded a new version of WowEquip with full jewelcrafting support.

It also has a "DKP calc" which allows you to assign weights to each stat and will then rank items by their weighting. It can do this for up to 50 different stats on a per class basis.