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:

• Standalone Demonstration
• Joomla Component Demonstration

Please post any errors with the english or german version. If you want to help translating this addon into spanish, please let me know.

Ok I work on the french translation

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.

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:%';

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

Hi,
I use the English version will my translation, and here's the result.

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

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

upgraded.

Just to let you know i updated and it now works

Thanks

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.

and also make your form options like this

Code: Select all


$form .= '<option value="'.makelink('guild-ItemSets&amp;tierselect='.$tier, true).'" '.$is_selected.'>'. $roster->locale->act['All_Classes'] .'</option>';
 

you will find the dragonfly changes in the current svn version.

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

upgraded.