Elitist Jerks
Register
Blogs
Chat
Forums
New Posts


Go Back   Elitist Jerks > Public Discussion > User Interface and AddOns

Reply
 
LinkBack (2) Thread Tools
Old 02/20/07, 8:20 AM   2 links from elsewhere to this Post. Click to view. #1 (permalink)
Ceci n'est pas un titre
 
alcaras's Avatar
 
Blood Elf Paladin
 
Mal'Ganis
WoWEquip/Item Database

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.
 
User is offline.
Reply With Quote
Old 02/21/07, 6:37 AM   #2 (permalink)
Bald Bull
 
Night Elf Rogue
 
Wrathbringer (EU)
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).

Item Ranking Rogue [horribly outdated]
 
User is offline.
Reply With Quote
Old 02/21/07, 6:46 AM   #3 (permalink)
Von Kaiser
 
Night Elf Priest
 
Stormrage
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
 
User is offline.
Reply With Quote
Old 02/21/07, 11:27 AM   #4 (permalink)
Ceci n'est pas un titre
 
alcaras's Avatar
 
Blood Elf Paladin
 
Mal'Ganis
Originally Posted by cladhaire View Post
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.
 
User is offline.
Reply With Quote
Old 02/21/07, 12:45 PM   #5 (permalink)
Von Kaiser
 
Night Elf Priest
 
Stormrage
aye... i wish wowhead would add a feature like that.
 
User is offline.
Reply With Quote
Old 02/21/07, 12:50 PM   #6 (permalink)
Soda Popinski
 
Ultramax's Avatar
 
Troll Warrior
 
Mal'Ganis
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.
 
User is offline.
Reply With Quote
Old 02/21/07, 1:07 PM   #7 (permalink)
Piston Honda
 
Gyshall's Avatar
 
Tauren Warrior
 
Darkspear
Originally Posted by Ultramax View Post
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.
 
User is offline.
Reply With Quote
Old 02/21/07, 4:18 PM   #8 (permalink)
John Galt
 
Humbaba's Avatar
 
Tauren Druid
 
Mal'Ganis
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.
 
User is offline.
Reply With Quote
Old 02/21/07, 4:25 PM   #9 (permalink)
Piston Honda
 
Gyshall's Avatar
 
Tauren Warrior
 
Darkspear
Originally Posted by Humbaba View Post
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.
 
User is offline.
Reply With Quote
Old 02/21/07, 5:24 PM   #10 (permalink)
John Galt
 
Humbaba's Avatar
 
Tauren Druid
 
Mal'Ganis
Originally Posted by Gyshall View Post
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.
 
User is offline.
Reply With Quote
Old 02/22/07, 1:47 AM   #11 (permalink)
Ceci n'est pas un titre
 
alcaras's Avatar
 
Blood Elf Paladin
 
Mal'Ganis
Originally Posted by Humbaba View Post
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
 
User is offline.
Reply With Quote
Old 02/23/07, 10:14 AM   #12 (permalink)
John Galt
 
Humbaba's Avatar
 
Tauren Druid
 
Mal'Ganis
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.
 
User is offline.
Reply With Quote
Old 02/23/07, 8:09 PM   #13 (permalink)
Von Kaiser
 
Dwarf Warrior
 
Ner'zhul
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
 
User is offline.
Reply With Quote
Old 02/28/07, 3:58 AM   #14 (permalink)
Bald Bull
 
Night Elf Rogue
 
Wrathbringer (EU)
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

Item Ranking Rogue [horribly outdated]
 
User is offline.
Reply With Quote
Old 03/06/07, 7:58 PM   #15 (permalink)
Glass Joe
 
Human Mage
 
Turalyon (EU)
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.
 
User is offline.
Reply With Quote
Old 03/08/07, 9:23 AM   #16 (permalink)
Ceci n'est pas un titre
 
alcaras's Avatar
 
Blood Elf Paladin
 
Mal'Ganis
Originally Posted by Danya View Post
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.
 
User is offline.
Reply With Quote
Old 03/08/07, 8:47 PM   #17 (permalink)
Ceci n'est pas un titre
 
alcaras's Avatar
 
Blood Elf Paladin
 
Mal'Ganis
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.
 
User is offline.
Reply With Quote
Old 03/09/07, 8:44 AM   #18 (permalink)
Glass Joe
 
BugRoger's Avatar
 
Human Warlock
 
Shadowmoon (EU)
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
 
User is offline.
Reply With Quote
Old 03/09/07, 1:24 PM   #19 (permalink)
Ceci n'est pas un titre
 
alcaras's Avatar
 
Blood Elf Paladin
 
Mal'Ganis
Originally Posted by BugRoger View Post
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
 
User is offline.
Reply With Quote
Old 03/11/07, 4:11 PM   #20 (permalink)
Ceci n'est pas un titre
 
alcaras's Avatar
 
Blood Elf Paladin
 
Mal'Ganis
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)

Last edited by alcaras : 03/11/07 at 4:33 PM.
 
User is offline.
Reply With Quote
Old 04/06/07, 3:13 PM   #21 (permalink)
Bald Bull
 
Copernicus's Avatar
 
Gnome Mage
 
Tichondrius
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.
 
User is online.
Reply With Quote
Old 04/06/07, 3:48 PM   #22 (permalink)
Nerodin's Elitist
 
Disquette's Avatar
 
Disquette
Draenei Shaman
 
No WoW Account
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.

----- sig ---------------
Discoepfeand - rogue / Disquette - shaman
A stormstrike / shocks /watershield timer-bar addon: http://www.curse.com/downloads/details/9729/
"Moogle has mentioned this in passing a few times but never elaborated on it. Perhaps we can entice him to respond." - Malan
 
User is offline.
Reply With Quote
Old 04/07/07, 2:00 PM   #23 (permalink)
Nerodin's Elitist
 
Disquette's Avatar
 
Disquette
Draenei Shaman
 
No WoW Account
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.

----- sig ---------------
Discoepfeand - rogue / Disquette - shaman
A stormstrike / shocks /watershield timer-bar addon: http://www.curse.com/downloads/details/9729/
"Moogle has mentioned this in passing a few times but never elaborated on it. Perhaps we can entice him to respond." - Malan
 
User is offline.
Reply With Quote
Old 06/09/07, 9:36 PM   #24 (permalink)
Glass Joe
 
Human Mage
 
Turalyon (EU)
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.
 
User is offline.
Reply With Quote
Reply