ItemSets released for Roster 2

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

Moderators: PoloDude, rouven

ItemSets released for Roster 2

Postby rouven » Tue Mar 04, 2008 6:33 pm

This addon shows the official set items owned by guild members.

This Addon is based on the the original work from Gorgar and later PoloDude, they wrote the former 1.7.3 'ItemSets' Addon.

Current version:2.0.3.380

v2.0.x is only compatible with Roster 2.0 (Beta 2)

Current Documentation (english only)
WIKI NOT UPDATED FOR v2.0.x – but most of it is still valid.

Look here for future updates, changes, bug fixes, etc...


CHANGE LOG: Initial release 2008/03/05
Latest release 2008/04/04


  • Important Changes
    • 2008/04/04 - v2.0.3.380
      • added Dragonfly support (thx Anaxent)
      • fixed issues with german translation of PvP Epic Set
      • added support for new female class names (german/french)
    • 2008/03/06 - v2.0.3.376
      • added french translation (thx foxbad)
      • compatibility with Joomla component com_wowroster
      • replaced submit button by javascript
    • 2008/03/05 - v2.0.2
      • added an admin setting to set the level minimum to display
      • added additional sets: Arena Season 3, Tier 6 Raid, PvP Level 70 Set
      • added honor/arenapoints requirements for all PvP Sets
      • updated german translation
      • fixes several php errors
      • renamed all sets to the original names
      • removed the so called Onyxia Set, because it never was a set
  • Languages present
    • English Present
    • French Present
    • German Present
    • Spanish not present
  • ToDo
    • Code Optimization
      • Reduce SQL Queries
      • Use item id's instead of item names to parse the items
    • Bugfixing
      • Support for multiple guilds (reported by cwpc)
      • Some S3 items are grouped with S1 and S2 items

See it here in action:


Please post any errors with the english or german version. If you want to help translating this addon into spanish, please let me know.
Attachments
itemsets_2.0.3-380.zip
(56.93 KiB) Downloaded 224 times
Last edited by rouven on Fri Apr 04, 2008 7:15 pm, edited 4 times in total.
User avatar
rouven
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 93
Joined: Fri Jan 12, 2007 4:39 am
Location: Hamburg, Germany

ItemSets released for Roster 2

Postby foxbad » Tue Mar 04, 2008 8:35 pm

Ok I work on the french translation
Last edited by foxbad on Tue Mar 04, 2008 8:55 pm, edited 1 time in total.
Image
Image
User avatar
foxbad
WR.net Apprentice
WR.net Apprentice
 
Posts: 22
Joined: Sun Aug 27, 2006 12:14 pm

Re: ItemSets released for Roster 2

Postby rouven » Tue Mar 04, 2008 9:43 pm

foxbad wrote:Ok I work on the french translation


Hey nice, thank you. I would recommend using the english version and translate the items one by one, because the french version does not have all the pvp informations and not all sets included.
User avatar
rouven
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 93
Joined: Fri Jan 12, 2007 4:39 am
Location: Hamburg, Germany

ItemSets released for Roster 2

Postby Subxero » Wed Mar 05, 2008 12:02 am

Its not better use itemid to search set items ?

SELECT * FROM `roster_items` WHERE item_name = 'Rift Stalker Helm' AND member_id = '255';

Its the same search 30141 item_id

SELECT * FROM `roster_items` WHERE item_id LIKE '30141:%' AND member_id = '255';

Next one ... because search every item on every char/class and not fill a array with data with less sql querys ?

SELECT member_id FROM `roster_items` WHERE item_id LIKE '30141:%';

In one sql you have all member_id with the hunter helm... and not query all individually, and its multilingual! you don't need translate every piece of set.. only the set name.

More complex parse can be do it with 1 query all hunter set tier4.

set tier4 hunter 30139-30143

SELECT * FROM `roster_items` WHERE `item_id` LIKE '30139:%' OR `item_id` LIKE '30140:%' OR `item_id` LIKE '30141:%' OR `item_id` LIKE '30142:%' OR `item_id` LIKE '30143:%';
Last edited by Subxero on Wed Mar 05, 2008 12:03 am, edited 1 time in total.
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US

ItemSets released for Roster 2

Postby rouven » Wed Mar 05, 2008 12:59 am

hey subxero,

thanks alot for the ideas. That's what i thought of, too. But i just wanted to have full functionality in the first step without any errors. after that i wanted to optimize the code. your recommendations are good, i will start optimizing soon :)
User avatar
rouven
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 93
Joined: Fri Jan 12, 2007 4:39 am
Location: Hamburg, Germany

Re: ItemSets released for Roster 2

Postby foxbad » Wed Mar 05, 2008 3:46 pm

Hi,
I use the English version will my translation, and here's the result.
Attachments
frfr.zip
Version 2.0.2 in french

Version 2.0.2 en français
(15.84 KiB) Downloaded 93 times
Last edited by foxbad on Wed Mar 05, 2008 3:50 pm, edited 2 times in total.
Image
Image
User avatar
foxbad
WR.net Apprentice
WR.net Apprentice
 
Posts: 22
Joined: Sun Aug 27, 2006 12:14 pm

ItemSets released for Roster 2

Postby Nefuh » Wed Mar 05, 2008 7:34 pm

Hey rouven,

nice addon but this addon won´t work in com_wowroster :(

A user of this component for Joomla reported this to me and i looked at your addon.

On first click to load the addon it display ok, but when i change the itemset it loads the main url.

I think this is because you leave the action attribute in the form section empty. I looked at the addon questlist (there´s a form that´s works) and there i found this:

Code: Select all
<form method="get" action="' . getFormAction() . '"


Is it possible that you add this to your addon? I think even for porting to other cms like DragonFly this is needed.

Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

ItemSets released for Roster 2

Postby cwpc » Wed Mar 05, 2008 10:33 pm

I noticed that it only worked for the Main guild. I have 3 guilds in my roster and my 2nd and 3rd(not an issue with 3rd - no one is over 50 yet) cant see the sets, it always goes back to the main guild
Image
Image
Image
User avatar
cwpc
WR.net Expert
WR.net Expert
 
Posts: 151
Joined: Wed Jun 13, 2007 9:07 pm
Location: The Edge of Insanity

ItemSets released for Roster 2

Postby rouven » Thu Mar 06, 2008 10:28 pm

upgraded.
User avatar
rouven
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 93
Joined: Fri Jan 12, 2007 4:39 am
Location: Hamburg, Germany

ItemSets released for Roster 2

Postby cwpc » Sat Mar 08, 2008 2:15 am

Just to let you know i updated and it now works

Thanks
Image
Image
Image
User avatar
cwpc
WR.net Expert
WR.net Expert
 
Posts: 151
Joined: Wed Jun 13, 2007 9:07 pm
Location: The Edge of Insanity

ItemSets released for Roster 2

Postby Anaxent » Sat Mar 08, 2008 3:37 am

I was just starting to test this addon with Dragonfly and I noticed that the makelink functions that you are using are not properlly formated.

Is now
Code: Select all
'<a href="'makelink('char-info') .'&amp;a=c:'$row['member_id'] .'">' 

Should be
Code: Select all
'<a href="'makelink('char-info&amp;a=c:'$row['member_id']) .'">' 


By making these changes we can make sure the links get created correctly every time including with the seo option being enabled.
Last edited by Anaxent on Sun Mar 09, 2008 9:13 am, edited 3 times in total.
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

ItemSets released for Roster 2

Postby Anaxent » Sun Mar 09, 2008 9:10 am

and also make your form options like this

Code: Select all

$form 
.= '<option value="'.makelink('guild-ItemSets&amp;tierselect='.$tiertrue).'" '.$is_selected.'>'$roster->locale->act['All_Classes'] .'</option>';
 
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

ItemSets released for Roster 2

Postby rouven » Mon Mar 17, 2008 6:31 pm

you will find the dragonfly changes in the current svn version.
User avatar
rouven
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 93
Joined: Fri Jan 12, 2007 4:39 am
Location: Hamburg, Germany

ItemSets released for Roster 2

Postby PoloDude » Tue Apr 01, 2008 5:16 am

Nice work on the addon! Cool to see some1 taking over ItemSets for 2.0!
As i said in raidtracker forum, i would do nothing rather then continuing myself but time and other factors keep me from doing that :(
But i'm always prepared to help, no doubt about that :)
[url=http://eu.wowarmory.com/character-sheet.xml?r=Emerald+Dream&n=Calaglin]Calaglin @ Emerald Dream [EU]
User avatar
PoloDude
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 134
Joined: Tue Jul 04, 2006 3:17 pm
Location: Belgium - Gent

ItemSets released for Roster 2

Postby rouven » Fri Apr 04, 2008 7:16 pm

upgraded.
User avatar
rouven
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 93
Joined: Fri Jan 12, 2007 4:39 am
Location: Hamburg, Germany

Next

Return to ItemSets

Who is online

Users browsing this forum: No registered users and 0 guests

cron