Greetings,

I've put together a module that helps your guild keep track of what items the guild currently owns.  It will show a list of every item in stock so your members can see what the guild currently has.  If an item is currently out of stock it will not be shown on the list.  If an item is out of stock but is loaned to someone, it will show it on the list but tell the person looking that it's currently loaned out. I will be adding screen shots as soon as my guild gets all our items propagated into the database.

This is my very first module so if some of you guru's out there want to give me some pointers, drop me a PM or reply to this post .  Also if anyone would like a feature tweaked or added, let me know.

When I mention <itemlink> it means to drag an item to the chat and drop it in.

Working On
-[ Done ] Sprucing up the code
-[ Done ] Adding colors to each item listed (i.e. grey, green, blue, purple)
-[ Done ] Add a function to show all items that have been 'Given' and 'Loaned' because you are not always going to have the item in your inventory to do !gitems history item <itemlink> and you're not always going to remember who has what using the !gitems history member <Name> command.

Screen Shots
List of Items (Page 1 of 4) - Note: The [ Delete ] button will not be there when someone lower than Admin uses the !gitems command.


List of Items (Page 2 of 4) - Note: The [ Delete ] button will not be there when someone lower than Admin uses the !gitems command.


History of a Member (Durroch)


History of an Item (Clan Gaud Chestguard)


Below is quoted from the bots help command:

::::: HELP ON GITEMS :::::

Keeps track of what items the Guild currently owns and also what the guild has loaned out or given to its members

 !gitems - Shows a list of all the items the Guild owns.
 !gitems add <qty> <category1> <category2> <itemlink> - Adds an item to the list.
 !gitems give <member> <qty> <itemlink> - Permanently gives an item to a Guild Member and records it in the transaction history of said Member.
 !gitems loan <member> <qty> <itemlink> - Loans an item to a Guild Member and records it in the transaction history of said Member.
 !gitems update add <qty> <itemlink> - Adds <qty> to the current stock of the specified item.
 !gitems update rem <qty> <itemlink> - Subtracts <qty> from the current stock of the specified item.
 !gitems history member <member> - Gives you a transaction history of all items given or loaned to <member>, as well as items checked back in.
 !gitems history item <itemlink> - Gives you a transaction history of loans and who's been given the specified item.
 !gitems history all - Gives you a transaction history every item every loaned or given.

NOTES:
Created by Durroch - Invictrum Guild Leader - US-Derketo
When using the Add sub-command to add an item (i.e. !gitems add 1 Armor Heavy <itemlink>) to the Guild Items list please use the following categories:
Armor Cloth
Armor Silk
Armor Light
Armor Medium
Armor Heavy
Armor Plate
Armor Shields
Armor Back
Weapons 1HE
Weapons 2HE
Weapons 1HB
Weapons 2HB
Weapons Daggers
Weapons Polearms
Weapons Staves
Weapons Bows
Weapons Arrows
Weapons Crossbows
Weapons Bolts
Weapons Thrown
Misc Necklaces
Misc Rings
Misc Talismans
Potions Mana
Potions Stamina
Potions Health
Gems Rhombic
Gems Trillion
Gems Oval
Gems Teardrop
Gems Oblique
Gems Cabochon

what about tradeskill resources? would be nice to be able to add, for example resources for the guildcity, alchemy or similar

He left that out on purpose as we have mods like the !city guild management module to take care of such a resource list...

Thank you, I appreciate that .
I believe there's already a raffle function in the bot so I'm not too keen to reinvent the wheel. 
Yes, I used the code from Items.php that already figured out how to extract the QL, Name, ItemID, and Color .  This weekend, my guild will be propagating this module so I will take screen shots after it's done .

Ya, I'm not sure how to use the chatcmd() tool and make the items different colors.

$itemlink = $this -> bot -> core("tools") -> chatcmd("item $items[item_id]", "##gitems_color##$items[item_name]##end##");&
$itemlink = $this -> bot -> core("tools") -> chatcmd("item $items[item_id]", "<font color='COLOR'>$items[item_name]</font>");
Both do not work.  It still produces an orange link.  I'm guessing I'll have to forgo using the chatcmd() tool and build the links myself.  Anyone got any hints or a standard way of doing it besides chatcmd()?

And ya, I'd like to take a look at your code once you've done your thing .  Not sure how using the raffle command will work.  That seems to me that it will make this module more of a "real-time" application when it's not.  Meaning your guild is on a raid and an item comes up that you need to raffle off.  It would be redundent to put into the Guild Items system just so people can click on a link that raffles off the item.  Just skip using this module and raffle it off regularly.  This module is just more for keeping track of what the guild owns and who's got what loaned out to them as well as all the items been given out.

Updated the code to v1.2.  This fixed some bugs and also added the colors to the items.  I also cut out a lot of unnecessary code as well.  I've updated the first post with screenshots too.  Let me know if there's anything else you'd like to see in this module.

hmm....is there a way you could show me what's happening in the console window of the bot when you add an item?  I'm guessing there's an error somewhere and it's not being added but saying it is anyways.

hmm, weird.  Do you know how to alter a table in phpmyadmin or whatever program you are using to manage your MySQL database?  If so, go into the guild_items table and change the item_loaned field to have a default value of 0 and I think that should fix your problem.  I'm not sure why you are having problems as I never did and I'm pretty sure the other people who have used this aren't as well since no one has said anything.  It might be the way your mysql is installed *shrugs*. 

Ya, we do the same thing, only one of my resource officers is in-charge of collecting all the items and she has them all on one character.  Although that is a good feature to have.  It will just have to be one more thing you'll have to type in when adding an item.  like
!gitems add 1 Armor Heavy Name <itemlink>

I'll try to have this implemented after the weekend. I'm busy busy busy with freelance work heh.