I have a vision of a module that would give guild officers and raid leaders an overview of the guild/raid members equipment.
The idea behind this is that when you know who has what gear you can:
 - make better decision on raid roles (eg. conq with full t2 might be a better tank then guard in partial t1)
 - make better decision on loot distribution with master looter setup (eg. if someone is missing single part of the set you may want him to loot a tokens; you want to decide which of the 3 demos should take t2 helmet).


First there is a need for creating a characters' equipment database.
Each member should be allowed to add information on his current raid gear for each item slot: head, chest, legs, boots, wrist, hands, belt.
The same for weapons: main hand 1, off hand 1, main hand 2, off hand 2. 
For statistical purposes it might be good to add slots with non-raid equipment: back, left finger, right finger, neck.

I was not able to decide in my head what type of entries it should be: exact item (itemref) or just a type of item (green - enchanted, blue - rare, violet - epic, t1, t2, t3, t4, khitai). I fell more inclined to type of item since the vision is to make and overview rather than exact equipment database (for which you can use yg integration).

Obviously there is also a need to allow raid leaders and admins make corrections in the data of any character.



Second part is to make use of the data.
The longer I was thinking the bigger the feature list was. I try to describe a lot but feel free to skip or modify some of it as it may be too complicated to implement.

In raid situation raid leader should be able to see:
 - a list of characters in a raid with brief description of what they have on, eg:
Overview list:
Char1 - Armour: 3 x rare, 4 x t1; Weapon: 1 x epic, 1 x t1, 1 x rare.
Char2 - Armour: 2 x rare, 1 x t1, 4 x t2; Weapon: 3 x epic, 1 x t1,
Char3 - Armour: 4 x t1, 3 x t2; Weapon: 4 x t2,
etc.

(notice that only raid-lotable armour is listed here; weapons may need a better way to illustrate 2-handed - one item that takes two slots)

 - a list of specific class characters in a raid with brief description of what they have on, eg:
[same as above but for selected class]

 - a list of specific class characters with a description of specific item, eg:
List demo's head:
demo1: rare
demo2: t1
demo3: t3

 - an ability to see specific character equipment:
Demo1 equipment:
head - rare
chest - rare 
legs - epic
boots - t1
wrist - t1
hands - rare
belt - t1
back - epic
left finger - rare
right finger - epic
neck - khitai

main hand 1 - t1
off hand 1 - epic
main hand 2 - epic
off hand 2 - none


And here are my concerns form brain storm session:

Conversion of item type to some sort of points / weight system.
Generally good idea (bot could suggest a decision based on calculations of points), but the rules of what item type is worth how many points may differ from guild to guild. Plus if you start talking about raid and points people see it as crypto-DKP, which is not the point (and there is a dkp system already, so why making another?).
If there would be a way to code point conversion that would be configurable - I'm all for it. But since seams very complicated (separate commands for point scale setup and management plus all the calculations that would use the points) I do not think this is needed. Not at this stage.

It would be good if item types retain their colours (eg. wherever you see "rare" it ought to be in  blue).

It would be good if the characters on all lists would be a links to show details of that person. 

It would be good if on the general list there would be a links to call list for certain class.

It would be good if on the certain class list there would be a links to call list for certain item type.

It all sounds good for raids (max 24 chars). If you think about guild wide usage there is a need to limit the list. Perhaps make it for main characters only? This needs more brain storming.


/discuss

I noticed that YG profile is very often not up to date, so I would not relay on it too much.

Unless there is a method to force update of YG profile for all guild members?


And still I think that it would be good to have sort of an overview insted of manually check and note each person.

I think i got kinda same idea, but never had time to make it.

What you want is to be able to run "!command Nick" and get a list like YG.com gives, but also contain what rarity level the item is (T1-2-3-4) without needing to remember what item it is or check the price to verify it.

If someone could provide med with a list over Class/ItemName/ItemID/RarityLevel(T1-T2) i may get some time to make this one day.

[Second post dut to post lenght limitation]

From rweapon.php:

      function get_weapons()
    {
         $weaponslist = array( // Class [0], Tier[1], Item Type[2], Name [3], ID [4]
array("Guardian", "T1", "One-Handed Edged", "Broadsword of Okeanos", "3770675"),
array("Guardian", "T1", "Polearm", "Trident of Okeanos", "3770712"),
array("Guardian", "T1", "Shield", "Aegis of the Warlord", "3770703"),
array("Guardian", "T2", "One-Handed Edged", "Edge of the Golden Age", "3770701"),
array("Guardian", "T2", "Polearm", "Teeth of the Drowned", "3770713"),
array("Guardian", "T2", "Shield", "Aegis of the Jackal", "3770704"),
array("Dark Templar", "T1", "One-Handed Edged", "The Baleful Blade", "3770801"),
array("Dark Templar", "T1", "Shield", "Gorulga's Shield", "3770817"),
array("Dark Templar", "T1", "Talisman", "Gorulga's Mark", "3771955"),
array("Dark Templar", "T2", "One-Handed Edged", "Blade of the Fallen King", "3770812"),
array("Dark Templar", "T2", "Shield", "The Shield of Alkmeenon", "3770828"),
array("Dark Templar", "T2", "Talisman", "The Mark of Gwahlur", "3771968"),
array("Dark Templar", "T3", "Talisman", "The Eye of the Bretheren", "3771969"),
array("Conqueror", "T1", "One-Handed Edged", "Bloodseeker Blade", "3770717"),
array("Conqueror", "T1", "Two-Handed Edged", "Bloodseeker Claymore", "3770774"),
array("Conqueror", "T2", "One-Handed Edged", "Sovereign Battleblade", "3770719"),
array("Conqueror", "T2", "Two-Handed Edged", "Bloodregent Claymore", "3770775"),  
array("Priest of Mitra", "T1", "One-Handed Blunt", "Vise of the Anointed", "3773832"),
array("Priest of Mitra", "T1", "Shield", "Pavis of Fealty", "3773873"),
array("Priest of Mitra", "T1", "Staff", "Staff of Devout Piety", "3773907"),
array("Priest of Mitra", "T1", "Talisman", "Tome of Holy Obeisance", "3773913"),
array("Priest of Mitra", "T2", "One-Handed Blunt", "Hammer of Solemn Vows", "3773842"),
array("Priest of Mitra", "T2", "Shield", "The Haven of War", "3773874"),
array("Priest of Mitra", "T2", "Staff", "Staff of Eternal Confluence", "3773909"),
array("Priest of Mitra", "T2", "Talisman", "Tome of Deific Reverence", "3773914"),
array("Priest of Mitra", "T3", "Shield", "Feretrum of Mitra", "3773897"),
array("Tempest of Set", "T1", "One-Handed Blunt", "Mace of the Cloudseer", "3774386"),
array("Tempest of Set", "T1", "Polearm", "The Cloudscar", "3774384"),
array("Tempest of Set", "T1", "Shield", "The Storm Harbor", "3774406"),
array("Tempest of Set", "T1", "Talisman", "The Tome of Storms", "3774410"),
array("Tempest of Set", "T2", "One-Handed Blunt", "Heaven's Torment", "3774392"),
array("Tempest of Set", "T2", "Polearm", "Spear of Ishti", "3774387"),
array("Tempest of Set", "T2", "Shield", "Shedu of Arcing Skies", "3774408"),
array("Tempest of Set", "T2", "Talisman", "Scripture of Coronal Skies", "3774411"),
array("Tempest of Set", "T3", "One-Handed Blunt", "Maahes' Crackling Spite", ""),
array("Tempest of Set", "T3", "Talisman", "Tome of the Black Gale", "3774412"),
array("Bear Shaman", "T1", "Two-Handed Blunt", "Hammer of Primal Wrath", "3773797"),
array("Bear Shaman", "T2", "Two-Handed Blunt", "Arm of the Great Bear", "3773813"),
array("Bear Shaman", "T3", "Two-Handed Blunt", "Hammer of the Void", "4281141"),
array("Barbarian", "T1", "One-Handed Edged", "The Crescent of Blood", "3772397"),
array("Barbarian", "T1", "Two-Handed Edged", "The Twinned Moons", "3772413"),
array("Barbarian", "T2", "One-Handed Edged", "Axe of Red Ruin", "3772403"),
array("Barbarian", "T2", "Two-Handed Edged", "Greataxe of the Crimson Sea", "3772414"),
array("Assassin", "T1", "Dagger", "Song of Demise", "3772330"),
array("Assassin", "T2", "Dagger", "The Silent Knell", "3772333"),
array("Assassin", "T3", "Dagger", "Fury of the Void", "4281142"),
array("Ranger", "T1", "Ammunition", "Bolts of Black Sorrow", "3772260"),
array("Ranger", "T1", "Ammunition", "Quiver of Barbed Tongues", "3772301"),
array("Ranger", "T1", "Bow", "The Fleeted Wing", "3772217"),
array("Ranger", "T1", "Crossbow", "Draw of Fangs", "3772172"),
array("Ranger", "T1", "Dagger", "The Gilded Grave", "3772166"),
array("Ranger", "T1", "One-Handed Edged", "The Scimitar of Dunes", "3771998"),
array("Ranger", "T1", "Shield", "Sepulcher's Ward", "3772163"),
array("Ranger", "T2", "Ammunition", "Spines of Repose", "3772282"),
array("Ranger", "T2", "Ammunition", "Quiver of Black Asps", "3772320"),
array("Ranger", "T2", "Bow", "Brace of Kuthchemes", "3772220"),
array("Ranger", "T2", "Crossbow", "The Serpent's Pull", "3772173"),
array("Ranger", "T2", "Dagger", "The Agony of Ages", "3772168"),
array("Ranger", "T2", "One-Handed Edged", "Sirocco's Lament", "3771999"),
array("Ranger", "T2", "Shield", "The Shield of Entropy", "3772164"),
array("Ranger", "T3", "Ammunition", "Bolts of Raked Flesh", "3772288"),
array("Ranger", "T3", "Ammunition", "Quiver of Raked Flesh", "3772321"),
array("Ranger", "T3", "One-Handed Edged", "Blade of the Void", "3772000"),
array("Demonologist", "T1", "Dagger", "Blade of Marred Spirits", "3772420"),
array("Demonologist", "T1", "Staff", "Stave of Malefic Rites", "3773762"),
array("Demonologist", "T1", "Talisman", "Fetish of Caged Fiends", "3772416"),
array("Demonologist", "T2", "Dagger", "Zukala's Rites", "3773744"),
array("Demonologist", "T2", "Staff", "Clutch of Black Terrors", "3773763"),
array("Demonologist", "T2", "Talisman", "Zukala's Reliquary", "3772417"),  
array("Demonologist", "T3", "Dagger", "The Death of Innocents", ""),
array("Demonologist", "T3", "Staff", "The Helot of Sacrilege", ""),
array("Herald of Xotli", "T1", "Dagger", "The Lost Soul", "3770878"),
array("Herald of Xotli", "T1", "Talisman", "Blood Scripture of Xotli", "3771989"),
array("Herald of Xotli", "T1", "Two-Handed Edged", "Rage of Xotli", "3771971"),
array("Herald of Xotli", "T2", "Dagger", "Pain of the Damned", "3771941"),
array("Herald of Xotli", "T2", "Talisman", "Elder Scripture of Xotli", "3772002"),
array("Herald of Xotli", "T2", "Two-Handed Edged", "Fury of Xotli", "3771975"),
array("Necromancer", "T1", "Dagger", "Edge of Tartarus", "3772283"),
array("Necromancer", "T1", "Staff", "Axis of Tartarus", "3772404"),
array("Necromancer", "T1", "Talisman", "Opus of Ash and Blood", "3772246"),
array("Necromancer", "T2", "Dagger", "Knife of Dessication", "3772286"),
array("Necromancer", "T2", "Staff", "The Narthex of Hell", "3772406"),
array("Necromancer", "T2", "Talisman", "Tome of the Undying", "3772248"),
array("Necromancer", "T3", "Staff", "The Necros of Dagon", ""),
array("Necromancer", "T3", "Talisman", "Epithet of Skelos", "3772250")
                );

         return $weaponslist;
      }