ItemSets v2.0.7.000 - now with Tier 8 gear

Keep track of what item/gear sets you have for your characters

Moderators: PoloDude, rouven

ItemSets v2.0.7.000 - now with Tier 8 gear

Postby AnthonyB » Sun Jun 07, 2009 9:16 am

Hi Folks,

A quick update to add in the Tier 8 Ulduar gear and correct the drop locations of some Tier 7 gear.

My god, how boring keying all that data in was! I certainly appreciate the efforts of Calystos to get the last release out!

I've called it a beta due to the following:

1. I've not tested the upgrade scenario much at all... seemed to work OK for me but your milage may vary. If in doubt, uninstall the old version, delete the table, install fresh.
2. The class filter is broken. I can't recall if it was working previously so I don't know if I've broken it in the course of doing this release. Quite likely I have in which case, sorry! If someone could check the MySQL error it throws and fix that would be great as my MySQL query syntax knowledge is extremely limited.
3. I've only updated the enUS locale file. I'll leave it to others to do the others.
Attachments
ItemSets 2.0.7.000 beta.zip
(66.49 KiB) Downloaded 449 times
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: ItemSets v2.0.7.000 - now with Tier 8 gear

Postby AnthonyB » Thu Jun 11, 2009 1:45 am

4 downloads to date - no issues? (fingers crossed) :)
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: ItemSets v2.0.7.000 - now with Tier 8 gear

Postby shadowfox » Mon Jun 29, 2009 1:18 pm

Just the class filter really.

Everything seems to be rolling along nicely :)
User avatar
shadowfox
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Sun Oct 14, 2007 11:47 am
Location: Modesto, California
Realm: Moon Guard (RP) - US

Re: ItemSets v2.0.7.000 - now with Tier 8 gear

Postby hades200082 » Wed Jul 08, 2009 11:24 am

The class filter error can be corrected as follows....

ItemSets/guild/index.php
Find Line 287:
Code: Select all
$class_where = ' AND (class = \''.$class.'\' ';


Replace with:
Code: Select all
$class_where = ' AND class = \''.$class.'\' ';


ItemSets/realm/index.php
Find Line 285:
Code: Select all
$class_where = ' AND (class = \''.$class.'\' ';


Replace with:
Code: Select all
$class_where = ' AND class = \''.$class.'\' ';



Note the removal of the ( before class. ... this is a basic copy/past error from the original author i believe.
hades200082
WR.net Apprentice
WR.net Apprentice
 
Posts: 31
Joined: Tue Oct 16, 2007 8:00 pm

Re: ItemSets v2.0.7.000 - now with Tier 8 gear

Postby shadowfox » Sat Jul 11, 2009 11:42 pm

all cool thanks seems to be working great now :)
User avatar
shadowfox
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Sun Oct 14, 2007 11:47 am
Location: Modesto, California
Realm: Moon Guard (RP) - US

Re: ItemSets v2.0.7.000 - now with Tier 8 gear

Postby AnthonyB » Mon Aug 17, 2009 3:35 am

Brilliant - thanks hades!

Now I guess it's time to get down to the monotonous task of incorporating all the new Tier 8.5/Collesium sets... ergh...

The code in SVN is way old so I'm also going to upload the current working code I have including the filter fix from hades to get things back on track.
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: ItemSets v2.0.7.000 - now with Tier 8 gear

Postby AnthonyB » Wed Aug 19, 2009 3:23 am

Oh God... I've just realised how big a task it is to add Tier 9 gear...

http://www.wowhead.com/?itemsets&filter=ta=27

even for simple classes like Hunters and Mages there are 6 sets!
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: ItemSets v2.0.7.000 - now with Tier 8 gear

Postby shadowfox » Mon Aug 24, 2009 10:36 pm

want some help doing the extra typing involved?

I'd be more then happy to help :)
User avatar
shadowfox
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Sun Oct 14, 2007 11:47 am
Location: Modesto, California
Realm: Moon Guard (RP) - US


Return to ItemSets

Who is online

Users browsing this forum: No registered users and 0 guests

cron