collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: eqdkp  (Read 12439 times)

0 Members and 1 Guest are viewing this topic.

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: eqdkp
« Reply #15 on: October 14, 2009, 08:03:44 am »
May i ask whats the difference between EQdkp and EQdkp-Plus?
Never used EQdkp- systems, but your request doesnt seem to be so hard if i just took a look on EQ. But if its two different systems there probly needs to be two different modules..?
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline Runemy

  • BeBot Apprentice
  • ***
  • Posts: 97
  • Karma: +0/-0
    • Exalted [Age of Conan guild - Aquilonia EU]
Re: eqdkp
« Reply #16 on: October 14, 2009, 10:54:49 am »
I think the plus holds a few extra tables in it's database, but else I think it's the same.

The tables in the plus version is also named only eqdkp, as in "eqdkp_members", which is the table you'll need to fetch the requested info.

Here's the sql dump of the structure of the table:
Code: [Select]
-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny1
-- http://www.phpmyadmin.net
--
-- Vert: xxxxxxxxxxxx
-- Generert den: 14. Okt, 2009 klokka 10:50 AM
-- Tjenerversjon: 5.0.41
-- PHP-Versjon: 5.2.6-1+lenny3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `xxxxxxxxxxxxx`
--

-- --------------------------------------------------------

--
-- Tabellstruktur for tabell `eqdkp_members`
--

CREATE TABLE IF NOT EXISTS `eqdkp_members` (
  `member_id` smallint(5) unsigned NOT NULL auto_increment,
  `member_name` varchar(30) NOT NULL,
  `member_earned` float(11,2) NOT NULL default '0.00',
  `member_spent` float(11,2) NOT NULL default '0.00',
  `member_adjustment` float(11,2) NOT NULL default '0.00',
  `member_status` enum('0','1') NOT NULL,
  `member_firstraid` int(11) NOT NULL default '0',
  `member_lastraid` int(11) NOT NULL default '0',
  `member_raidcount` int(11) NOT NULL default '0',
  `member_level` tinyint(2) default NULL,
  `member_race_id` smallint(3) unsigned NOT NULL default '0',
  `member_class_id` smallint(3) unsigned NOT NULL default '0',
  `member_rank_id` smallint(3) NOT NULL default '0',
  `member_xml` blob,
  PRIMARY KEY  (`member_id`),
  UNIQUE KEY `member_name` (`member_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=190 ;

To figure out current dkp we will need this calculation: (member_earned - member_spent + member_adjustment) as the table doesn't automaticly hold the current dkp. At least as far as I could tell.

Cheers for looking into this mate!
Wood of Exalted
Age of Conan
Aquilonia - EU

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: eqdkp
« Reply #17 on: October 14, 2009, 11:21:10 am »
Ok, i made the first release of a module here: http://bebot.link/generic-custom-modules/eqdkp-ingame-query-module/

Didnt read your feedback before after posted, so i know there is one bug at least. Didnt know how to handle the Adjustments, going to check that out.

Anyway, pls put feedbacks regarding the module into that topic.
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 679
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal