Announcement

#1 2009-07-20 20:00:25

duffry
Founder
From: Macclesfield, UK
Registered: 2005-08-20
Website

Add new items to items sheet

Placeholder action.

T8 hardmode items missing as well as 3.2 stuff.
Am looking at building an extractor for this kinda thing but if anyone has an easy way of doing it up their sleave then please don't keep it to yourself.


http://dmz-gaming.com/images/junk/sigs/lockuserbar.pnghttp://dmz-gaming.com/images/junk/sigs/beimba.pnghttp://dmz-gaming.com/images/junk/sigs/wowhead.pnghttp://dmz-gaming.com/images/junk/sigs/blizz.png
Science adjusts its views based on what's observed. Faith is the denial of observation so that belief can be preserved. If you show me that, say, homoeopathy works, I'll change my mind. I'll spin on a fucking dime. I'll be embarrassed as hell but I will run through the streets yelling Its a miracle! Take physics and bin it. Water has memory. And while its memory of a long lost drop of onion juice is infinite, it somehow forgets about all the poo it's had in it. You show me that it works and how it works, and when I've recovered from the shock, I will take a compass and carve 'fancy that' on the side of my cock.

Offline

   Duffinci

 

#2 2009-08-01 18:19:38

Immortus
Forum member
Registered: 2009-08-01

Re: Add new items to items sheet

Thank you for all your hard work on the speadsheet.

I was thinking you could pull the data out of wowhead. Not sure how happy they would be with this.
One might be able to send a url like
http://www.wowhead.com/?items=4.1&f … ub=9#0-2+1
to get the list of items, parse the data for the item names. Then use url's like
http://www.wowhead.com/?item=Conqueror\ … be&xml
to get the item info and populate the spreadsheet.

Let me know if you think this would work or need a hand with it.

Offline

 

#3 2009-08-01 18:38:42

duffry
Founder
From: Macclesfield, UK
Registered: 2005-08-20
Website

Re: Add new items to items sheet

Yeah, I have a wowhead xml extraction tool for this site, I need to play with it a bit to get the data I want the way I need it, hoping to have it in the next release but certainly for 3.2.


http://dmz-gaming.com/images/junk/sigs/lockuserbar.pnghttp://dmz-gaming.com/images/junk/sigs/beimba.pnghttp://dmz-gaming.com/images/junk/sigs/wowhead.pnghttp://dmz-gaming.com/images/junk/sigs/blizz.png
Science adjusts its views based on what's observed. Faith is the denial of observation so that belief can be preserved. If you show me that, say, homoeopathy works, I'll change my mind. I'll spin on a fucking dime. I'll be embarrassed as hell but I will run through the streets yelling Its a miracle! Take physics and bin it. Water has memory. And while its memory of a long lost drop of onion juice is infinite, it somehow forgets about all the poo it's had in it. You show me that it works and how it works, and when I've recovered from the shock, I will take a compass and carve 'fancy that' on the side of my cock.

Offline

   Duffinci

 

#4 2009-08-07 13:46:00

duffry
Founder
From: Macclesfield, UK
Registered: 2005-08-20
Website

Re: Add new items to items sheet

I've run a quick extract of Items to add to the sheet. This is not exhaustive as I'm using wowhead and they are missing most (all) T9 raid drops while wowhead looter does it's thing.

Would appreciate anyone sparing a little time to sanity check them to make sure nothing stupid is in there or anything obvious is missing (other than T9 raid drops, ofc).

Missing Ulduar loot:
http://www.wowhead.com/?item=45537 , http://www.wowhead.com/?item=45946 , http://www.wowhead.com/?item=46034

Back
http://www.wowhead.com/?item=47095 , http://www.wowhead.com/?item=47452 , http://www.wowhead.com/?item=47089 , http://www.wowhead.com/?item=47291 , http://www.wowhead.com/?item=42077 , http://www.wowhead.com/?item=47225 , http://www.wowhead.com/?item=42076 , http://www.wowhead.com/?item=42080 , http://www.wowhead.com/?item=42079 , http://www.wowhead.com/?item=42078 , http://www.wowhead.com/?item=47501

Chest
http://www.wowhead.com/?item=47603 , http://www.wowhead.com/?item=47604 , http://www.wowhead.com/?item=47605 , http://www.wowhead.com/?item=47606 , http://www.wowhead.com/?item=47126 , http://www.wowhead.com/?item=47301 , http://www.wowhead.com/?item=47794 , http://www.wowhead.com/?item=47791 , http://www.wowhead.com/?item=47806 , http://www.wowhead.com/?item=47779 , http://www.wowhead.com/?item=47527 , http://www.wowhead.com/?item=47838 , http://www.wowhead.com/?item=47799 , http://www.wowhead.com/?item=47786

Feet
http://www.wowhead.com/?item=47097 , http://www.wowhead.com/?item=47092 , http://www.wowhead.com/?item=47293 , http://www.wowhead.com/?item=49232 , http://www.wowhead.com/?item=47321 , http://www.wowhead.com/?item=47194 , http://www.wowhead.com/?item=41904 , http://www.wowhead.com/?item=47721 , http://www.wowhead.com/?item=47873 , http://www.wowhead.com/?item=41886 , http://www.wowhead.com/?item=47560 ,

Finger
http://www.wowhead.com/?item=47732 , http://www.wowhead.com/?item=47054 , http://www.wowhead.com/?item=47327 , http://www.wowhead.com/?item=47278 , http://www.wowhead.com/?item=48957 , http://www.wowhead.com/?item=47733 , http://www.wowhead.com/?item=48999 , http://www.wowhead.com/?item=48955 , http://www.wowhead.com/?item=47200 , http://www.wowhead.com/?item=42118 , http://www.wowhead.com/?item=47512

Hands
http://www.wowhead.com/?item=47235 , http://www.wowhead.com/?item=47326 , http://www.wowhead.com/?item=47797 , http://www.wowhead.com/?item=47788 , http://www.wowhead.com/?item=47803 , http://www.wowhead.com/?item=47782 , http://www.wowhead.com/?item=47889 , http://www.wowhead.com/?item=47802 , http://www.wowhead.com/?item=47783 , http://www.wowhead.com/?item=47230 ,

Head
http://www.wowhead.com/?item=47796 , http://www.wowhead.com/?item=47789 , http://www.wowhead.com/?item=47804 , http://www.wowhead.com/?item=47778 , http://www.wowhead.com/?item=47694 , http://www.wowhead.com/?item=47695 , http://www.wowhead.com/?item=47693 , http://www.wowhead.com/?item=47692 , http://www.wowhead.com/?item=47801 , http://www.wowhead.com/?item=47784 , http://www.wowhead.com/?item=47564 ,

Held In Off-hand
http://www.wowhead.com/?item=47138 , http://www.wowhead.com/?item=47309 , http://www.wowhead.com/?item=47742 , http://www.wowhead.com/?item=47913 ,

Legs
http://www.wowhead.com/?item=47795 , http://www.wowhead.com/?item=47790 , http://www.wowhead.com/?item=47805 , http://www.wowhead.com/?item=47780 , http://www.wowhead.com/?item=47800 , http://www.wowhead.com/?item=47785 , http://www.wowhead.com/?item=47317 , http://www.wowhead.com/?item=47187 , http://www.wowhead.com/?item=48991 , http://www.wowhead.com/?item=48997 , http://www.wowhead.com/?item=47185 ,

Main Hand
http://www.wowhead.com/?item=48408 , http://www.wowhead.com/?item=48013 , http://www.wowhead.com/?item=47724 , http://www.wowhead.com/?item=47874 , http://www.wowhead.com/?item=47569 ,

Neck
http://www.wowhead.com/?item=47307 , http://www.wowhead.com/?item=47139 , http://www.wowhead.com/?item=42045 , http://www.wowhead.com/?item=42043 , http://www.wowhead.com/?item=42046 , http://www.wowhead.com/?item=47890 , http://www.wowhead.com/?item=47747 , http://www.wowhead.com/?item=42047 , http://www.wowhead.com/?item=47562 , http://www.wowhead.com/?item=47219 , http://www.wowhead.com/?item=42041 , http://www.wowhead.com/?item=47105 , http://www.wowhead.com/?item=47297 , http://www.wowhead.com/?item=47849 , http://www.wowhead.com/?item=47494 ,

One-Hand
http://www.wowhead.com/?item=47300 , http://www.wowhead.com/?item=47104 , http://www.wowhead.com/?item=47736 , http://www.wowhead.com/?item=47886 , http://www.wowhead.com/?item=48513 , http://www.wowhead.com/?item=48509 ,

Ranged
http://www.wowhead.com/?item=47856 , http://www.wowhead.com/?item=47658 ,

Shoulder
http://www.wowhead.com/?item=47793 , http://www.wowhead.com/?item=47792 , http://www.wowhead.com/?item=47716 , http://www.wowhead.com/?item=47715 , http://www.wowhead.com/?item=47807 , http://www.wowhead.com/?item=47781 , http://www.wowhead.com/?item=47798 , http://www.wowhead.com/?item=47787 , http://www.wowhead.com/?item=47714 , http://www.wowhead.com/?item=47713 , http://www.wowhead.com/?item=47226 ,

Trinket
http://www.wowhead.com/?item=42137 , http://www.wowhead.com/?item=47316 , http://www.wowhead.com/?item=47182 , http://www.wowhead.com/?item=42135 , http://www.wowhead.com/?item=42133 , http://www.wowhead.com/?item=48018 , http://www.wowhead.com/?item=47946 , http://www.wowhead.com/?item=47879 , http://www.wowhead.com/?item=47726 , http://www.wowhead.com/?item=47213 , http://www.wowhead.com/?item=48724 , http://www.wowhead.com/?item=47215 , http://www.wowhead.com/?item=47947 , http://www.wowhead.com/?item=47728 , http://www.wowhead.com/?item=47880 ,

Two-Hand
http://www.wowhead.com/?item=48414 , http://www.wowhead.com/?item=48410 , http://www.wowhead.com/?item=48521 , http://www.wowhead.com/?item=47743 , http://www.wowhead.com/?item=47892 , http://www.wowhead.com/?item=48412 , http://www.wowhead.com/?item=47815 , http://www.wowhead.com/?item=47900

Waist
http://www.wowhead.com/?item=47084 , http://www.wowhead.com/?item=47909 , http://www.wowhead.com/?item=47286 , http://www.wowhead.com/?item=47081 , http://www.wowhead.com/?item=47855 , http://www.wowhead.com/?item=41899 , http://www.wowhead.com/?item=41882 , http://www.wowhead.com/?item=47218 , http://www.wowhead.com/?item=47181 ,

Wrist
http://www.wowhead.com/?item=47203 , http://www.wowhead.com/?item=47324 , http://www.wowhead.com/?item=47585 , http://www.wowhead.com/?item=47586 , http://www.wowhead.com/?item=47587 , http://www.wowhead.com/?item=47588 , http://www.wowhead.com/?item=47306 , http://www.wowhead.com/?item=41910 , http://www.wowhead.com/?item=41894 , http://www.wowhead.com/?item=48979 , http://www.wowhead.com/?item=47173 ,

[edit] Most of the Ulduar ones I extracted were melee junk. I was running from a wowhead item search with a filter of dropping in Ulduar, guessing it might be a problem with item cashes.


http://dmz-gaming.com/images/junk/sigs/lockuserbar.pnghttp://dmz-gaming.com/images/junk/sigs/beimba.pnghttp://dmz-gaming.com/images/junk/sigs/wowhead.pnghttp://dmz-gaming.com/images/junk/sigs/blizz.png
Science adjusts its views based on what's observed. Faith is the denial of observation so that belief can be preserved. If you show me that, say, homoeopathy works, I'll change my mind. I'll spin on a fucking dime. I'll be embarrassed as hell but I will run through the streets yelling Its a miracle! Take physics and bin it. Water has memory. And while its memory of a long lost drop of onion juice is infinite, it somehow forgets about all the poo it's had in it. You show me that it works and how it works, and when I've recovered from the shock, I will take a compass and carve 'fancy that' on the side of my cock.

Offline

   Duffinci

 

#5 2009-08-12 10:31:43

Deathcondor
Forum member
Registered: 2009-08-12

Re: Add new items to items sheet

duffry wrote:

I've run a quick extract of Items to add to the sheet. This is not exhaustive as I'm using wowhead and they are missing most (all) T9 raid drops while wowhead looter does it's thing.

Would appreciate anyone sparing a little time to sanity check them to make sure nothing stupid is in there or anything obvious is missing (other than T9 raid drops, ofc).

[edit] Most of the Ulduar ones I extracted were melee junk. I was running from a wowhead item search with a filter of dropping in Ulduar, guessing it might be a problem with item cashes.

Sorry I haven't had time to check the ones above but I did manually-ish type in all the items a few days ago that I could find from wowhead. My list may not be extensive (I hope it is), but could be used as a check against what you have found. (Note I used the f version of the spreadsheet but I have modified it somewhat for my own use). Items have a 3.2 note against them on the item page.

http://www.digivirtu.net/wow/IM/warlock_dps_v313f.rar

Hope you find it helpful
cheers
Deathcondor

Offline

 

#6 2009-08-17 13:15:43

duffry
Founder
From: Macclesfield, UK
Registered: 2005-08-20
Website

Re: Add new items to items sheet

Items added.
If there's something you think is missing please post here.

Unstickied as implemented


http://dmz-gaming.com/images/junk/sigs/lockuserbar.pnghttp://dmz-gaming.com/images/junk/sigs/beimba.pnghttp://dmz-gaming.com/images/junk/sigs/wowhead.pnghttp://dmz-gaming.com/images/junk/sigs/blizz.png
Science adjusts its views based on what's observed. Faith is the denial of observation so that belief can be preserved. If you show me that, say, homoeopathy works, I'll change my mind. I'll spin on a fucking dime. I'll be embarrassed as hell but I will run through the streets yelling Its a miracle! Take physics and bin it. Water has memory. And while its memory of a long lost drop of onion juice is infinite, it somehow forgets about all the poo it's had in it. You show me that it works and how it works, and when I've recovered from the shock, I will take a compass and carve 'fancy that' on the side of my cock.

Offline

   Duffinci

 

#7 2009-08-26 17:28:08

Tayanita
Forum member
Registered: 2009-08-26

Re: Add new items to items sheet

Thanks for all the hard work and keeping the sheet alive.

The only thing I see missing from new gear is the sockets for new offhands like the Chalice of Benedictus

Offline

 

#8 2009-08-28 12:33:26

Peregrinus
Forum member
Registered: 2009-08-22

Re: Add new items to items sheet

Hi.
Thanks for a great job.
I have new loot from Ulduar that is not in the 320a: http://www.wowhead.com/?item=45423
And new loot from 25 TocT: http://www.wowhead.com/?item=47053

Last edited by Peregrinus (2009-08-28 12:33:56)

Offline

 

Board footer

Powered by PunBB, hosted by DMZ-Gaming
© 2002–2005 Rickard Andersson, 2005–Today duffry