Development > Generic custom modules

EQDKP - ingame query module (v3.0.3)

<< < (2/29) > >>

Getrix:

--- Quote ---2009-10-14 - v1.2 - Fixed listing classes with spaces "!dkp class <Class with space>"
--- End quote ---
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...

Drizzurdeen:
an when u will get a test eqdkp including sql access and a testbot ???

Runemy:
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.

--- Code: ---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 ;

--- End code ---

Getrix:
The problem as i see it is that EQDKP doesnt store info just in one Table. Stuff is linked to another table etc.
So when you are going to write a new entrie you need to make sure you update every table that are linked to that row. And thats the only big problem that takes time to find out of.

I got a plain EQDKP Plus up and running, but im not expert on using it :P And the reason i made the basic today is because im sick and dont have much todo. But hey, maybe i will take a deeper look. Cant promise anything ;)

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

Navigation

[0] Message Index

[#] Next page

[*] Previous page