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.