Release History

2011-04-15 - v3.0.4
 + Add if in same instance, dont show raidinv....   
 + Fixed raid_note with html chars.
 + Added rank on get_list. Changed colorcodes, using gmod_(getrix module) in !color gmod
2009-11-18 - v3.0.3 - Added first writing to EQDKP function, raid signup ingame. !!NOTE: Use on own risk!!

2009-11-13 - v2.0.3 - Fixed bug when there wasnt any signed for a raid.
2009-10-19 - v2.0.2 - Fixed order bug. Minor change in DB function
2009-10-19 - v2.0.1 - Fixed order bug in signup.
2009-10-18 - v2.0.0 - Added multi-language support. !set EQdkp language <en|de> (Note: Restart needed if you change. And the new language files to put in extra/language/ (Create folder if not exist) )
2009-10-18 - v1.9.9 - Cleaned up the code and changed release versioning to "Incrementing sequences"
2009-10-17 - v1.4.0 - Added "!dkp raid <raid_id> notes <member_id>". This is placed after nick in "!dkp raid <raid_id>" as clickable [Notes] link.
2009-10-16 - v1.3.3 - Changed Raid/Group invite only shows if the player is online. Added German class shortcuts.
2009-10-16 - v1.3.2 - Fixed bug in RaidDetails with Raid/Group invite not showing up. Bad coding by me:(
2009-10-16 - v1.3.1 - Fixed "Distribution" bug in !dkp raid to support "Class/Role/No Distribution". Added Raid/Group invite commands to "LEADER" security group.
2009-10-16 - v1.3.0 - Added time_offset to fix timezone difference (!set eqdkp). Added "!dkp debug" for debugging. Show "Raid ID" in raid list. And some small fixes
2009-10-16 - v1.2.2 - Fixed bug with HoX, PoM ToS not working and added ability to use shortcuts for class. Added "!dkp raid [raidid]" to query Raidplanner.
2009-10-16 - v1.2.1 - Fixed "!dkp online" and color bug. Added "Raid count" in player display
2009-10-15 - v1.2.0 - Added Item History, Raid Attendance and Adjustment History to !dkp nick <nick> display
2009-10-15 - v1.1.0 - Added !dkp online [class] command ([class] is optional)
2009-10-14 - v1.0.2 - Fixed listing classes with spaces "!dkp class <Class with space>"
2009-10-14 - v1.0.1 - Fixed adjustment calculation
2009-10-14 - v1.0.0 - First release

Commands

!dkp // Returns DKP info for player that runs the command
!dkp nick <nick> // Returns DKP info for <nick>
!dkp class <class> // Returns DKP info for that class ordered by top
!dkp online [class] // Returns DKP info for online players ([class] is optional, and will return class spesific if set)
!dkp raid [raid_id] // Shows upcomming raids and details if [raid_id] as optional is set.
!dkp debug // To give me some info to debug with.

Setup

!set EQdkp DB_host <host> // Default localhost
!set EQdkp DB_user <username> // Default eqdkp
!set EQdkp DB_pass <password>
!set EQdkp DB_name <databasename> // Default eqdkp_plus
!set EQdkp DB_pref <tableprefix> // Default eqdkp_ (Remember underscore if you have that)
!set EQdkp // To se more settings

Known bugs:
Non atm

nice plugin.
but there is a little bug.

!dkp class <a class with space>

doesnt work
like "Tempest of Set"

2009-10-14 - v1.2 - Fixed listing classes with spaces "!dkp class <Class with space>"

Thanks for headsup Margon.

@Drizzurdeen
This module is built as basic eqdkp-connection. Everything queried is real data from EQDKP.
Making a GUI to administrate is possible, but would take some time to find out how stuff is working in the system. And as im not using EQDKP myself, im not sure if its worth it for me if theres only few ppl that need more functions...

I think it's quite a lot of guilds using eqdkp and I know I would really appreciate every single functionality you put into this, but I think most understand it if you won't go too deep into this since you're not using it yourself.

Just a quick question, there's nothing stopping me from writing to the db as well, is there? Upon loot, it would be excellent to incorporate a !dkp adjust functionality as well. !dkp adjust <unique charname> <+/- dkp points> <item/reason>

Edit: hmm.. just came to mind that eqdkp handle Items in a own table with an itemid to every item. Might cause problems..

Edit 2: Then again, the adjustment table doesn't require an itemID.
CREATE TABLE IF NOT EXISTS `eqdkp_adjustments` (
  `adjustment_id` mediumint(8) unsigned NOT NULL auto_increment,
  `adjustment_value` float(11,2) default NULL,
  `adjustment_date` int(11) NOT NULL default '0',
  `member_name` varchar(30) default NULL,
  `adjustment_reason` varchar(255) default NULL,
  `adjustment_added_by` varchar(30) NOT NULL,
  `adjustment_updated_by` varchar(30) default NULL,
  `adjustment_group_key` varchar(32) default NULL,
  `raid_name` varchar(255) NOT NULL,
  PRIMARY KEY  (`adjustment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2397 ;


hahaha, here's me hoping you'll stay sick a while ^^

Well, the adjustments are mainly for just that; adjustments. But, depending of ones rules of course, there can be quite a lot of adjustments. I have adjustments for raid leading, resource gathering, turning up late, leaving early, not signing up etc.

Item's which was my initial thought is not handled by adjustments directly, but looking at the contents of the table everything ends up in that table, from normal dkp bonus for joining rids, through buying of items to the individual odd adjustments.

As a how-to on the usage I can run you through a small one here, there are probably different ways to use it as well as it is a rather advanced system:
1. Events are created for the different raid instances
2. Add raids through the Raidplanner by clicking on the date and then choosing the event. Here you can set the value of the raid as well.
3. People sign up for the raid (event)
4. When the raid is done an admin can through the option button in the detailed view of the raid, "Transform  it to a Raid".
5. You will then get a confirmation window with all the confirmed attendees plus the dkp awarded.
6. Next windows brings up the opportunity to "Add Items from this Raid"
7. Doing this gives you the opportunity to choose the player, the item (if earlier been entered in the database and also the opportunity to add a new item), and the value of the item. This item will then be linked to the raid in all instances of eqdkp.

But then, when we have people leaving early, coming late, raid leading or other various things we will need to add this to individual adjustments.

But looking at the database table of adjustments it seems that all things end up in the adjustments table.

Did dig a bit into EQDKP code and here is what i have found out so far:

Raid create should be on page i think. It will be to much code to get it work ingame.
The stuff i think will be usefull ingame is give DKP to raid and adjustment along with current query.

Adjustment can be tricky, if you need to get a costume Event for every adjustment you will add.
Ex, when you are adding a adjustment it seems that you can:
1: Add a new event for this adjustment
2: Use a old adjustment event.

And after that add adjustment value,reason,user.
The problem here is that in game you cant do "dropedowns" like you do in a webpage. It will then be tricky to make the user to do 1 or 2 because he needs to do that before passing the adjustment_value,reason,user to the bot. And adjustment event is stored in own table with id/ref link to adjustment table.
What we can do is make a "static" adjustment event called "BeBot in game adjustment" and use that event id/ref link when calling ex "!dkp adjust <nick> <amount> <reason>" And later edit it on webpage if needed.

It can also be done with some session saving (Wizard that following you thrue command by command), but its gonna be much clicks etc for the administrator in game...

EDIT: uh yeah was abit tired when writing so maybe it doesnt make any sense