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 - ingame query module (v3.0.3)  (Read 42349 times)

0 Members and 1 Guest are viewing this topic.

Offline Margon

  • BeBot Apprentice
  • ***
  • Posts: 80
  • Karma: +0/-0
Re: EQDKP - ingame query module
« Reply #15 on: October 15, 2009, 02:57:39 pm »
yes raidplaner is a plugin.


a nice feature would be: a command that show the dkp of all ONLINE-members categorized by there class

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module
« Reply #16 on: October 15, 2009, 05:04:59 pm »
Quote
2009-10-15 - v1.3 - Added !dkp online [class] command ([class] is optional)
« Last Edit: October 15, 2009, 11:04:06 pm by Getrix »
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 - ingame query module
« Reply #17 on: October 15, 2009, 08:53:06 pm »
Yay! A nice addition!

Is it possible to include the item history of a character in a !dkp nick as well?

eqdkp_items.item_buyer = eqdkp_members.member_name

A listed table inside the users window which holds:
item_date - item_name - item_value
Sorted by item date

Code: [Select]
CREATE TABLE IF NOT EXISTS `eqdkp_items` (
  `item_id` mediumint(8) unsigned NOT NULL auto_increment,
  `item_name` varchar(255) default NULL,
  `item_buyer` varchar(50) default NULL,
  `raid_id` int(10) unsigned NOT NULL default '0',
  `item_value` float(6,2) default NULL,
  `item_date` int(11) NOT NULL default '0',
  `item_added_by` varchar(30) NOT NULL,
  `item_updated_by` varchar(30) default NULL,
  `item_group_key` varchar(32) default NULL,
  `game_itemid` int(10) unsigned default NULL,
  PRIMARY KEY  (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=615 ;

:)
(Still sick I hope?? ^^)
Wood of Exalted
Age of Conan
Aquilonia - EU

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module
« Reply #18 on: October 15, 2009, 11:00:42 pm »
Quote
2009-10-15 - v1.4 - Added Item History, Raid Attendance and Adjustment History to !dkp nick <nick> display

Script is growing fast with functionality :P
Im interested in a mysql_dump of a well grown database if anyone could give me that. Its abit boring to query my own testing DB that i need to put stuff into to see if its work :s
« Last Edit: October 15, 2009, 11:04:15 pm by Getrix »
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 Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module
« Reply #19 on: October 16, 2009, 01:07:27 am »
Quote
2009-10-16 - v1.5 - Fixed "!dkp online" and color bug. Added "Raid count" in player display

Thanks to Runemy that gave me a mysql_dump with alot of data so i have something to work against
« Last Edit: October 16, 2009, 01:10:03 am by Getrix »
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 Margon

  • BeBot Apprentice
  • ***
  • Posts: 80
  • Karma: +0/-0
Re: EQDKP - ingame query module
« Reply #20 on: October 16, 2009, 11:06:35 am »
yeah the !dkp online is great!

a nice new feature would be an overview of the next or actually raid declared members on the raidplaner-plugin with the following status:
- Confirmed
- Signed
- Unsigned
- Not Sure

Offline Runemy

  • BeBot Apprentice
  • ***
  • Posts: 97
  • Karma: +0/-0
    • Exalted [Age of Conan guild - Aquilonia EU]
Re: EQDKP - ingame query module
« Reply #21 on: October 16, 2009, 12:04:37 pm »
Hehe, he's already working on it I think :)
Wood of Exalted
Age of Conan
Aquilonia - EU

Offline Drizzurdeen

  • BeBot Apprentice
  • ***
  • Posts: 193
  • Karma: +0/-0
    • Obsidian-Cult
Re: EQDKP - ingame query module
« Reply #22 on: October 16, 2009, 01:07:26 pm »
can't wait any longer for it ;) go getrix go ;)

Offline Margon

  • BeBot Apprentice
  • ***
  • Posts: 80
  • Karma: +0/-0
Re: EQDKP - ingame query module
« Reply #23 on: October 16, 2009, 02:26:37 pm »
found an other small bug

!dkp online

dont show herold of xolti, because ucfirst make "Herold Of Xotli" and the class dont exist

Priest of Mitra <- the same

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module
« Reply #24 on: October 16, 2009, 03:44:20 pm »
Quote
2009-10-16 - v1.6 - Fixed bug with HoX, PoM ToS not working and added ability to use shortcuts for class. Added "!dkp raid [raidid]" to query Raidplanner.
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 Drizzurdeen

  • BeBot Apprentice
  • ***
  • Posts: 193
  • Karma: +0/-0
    • Obsidian-Cult
Re: EQDKP - ingame query module
« Reply #25 on: October 16, 2009, 05:13:11 pm »
how i get the raid-id ???

do i have a look at the db ?

edit: kk !dkp raid ... works
« Last Edit: October 16, 2009, 05:20:55 pm by Drizzurdeen »

Offline Margon

  • BeBot Apprentice
  • ***
  • Posts: 80
  • Karma: +0/-0
Re: EQDKP - ingame query module
« Reply #26 on: October 16, 2009, 05:14:45 pm »
Code: [Select]
!dkp raid 375
[BeBot]: EQDKP ERROR: problem with code

looks like a problem

Offline Drizzurdeen

  • BeBot Apprentice
  • ***
  • Posts: 193
  • Karma: +0/-0
    • Obsidian-Cult
Re: EQDKP - ingame query module
« Reply #27 on: October 16, 2009, 05:26:17 pm »
have the same prob ...

only the first raid would be shown correct

here screens




here only the first raid works ... the other raids dont work ... an is it right that u only see your own sign and no more ?

Offline Runemy

  • BeBot Apprentice
  • ***
  • Posts: 97
  • Karma: +0/-0
    • Exalted [Age of Conan guild - Aquilonia EU]
Re: EQDKP - ingame query module
« Reply #28 on: October 16, 2009, 05:59:25 pm »
Works 100% on my end, we can view all raids and all signs show.
Wood of Exalted
Age of Conan
Aquilonia - EU

Offline Drizzurdeen

  • BeBot Apprentice
  • ***
  • Posts: 193
  • Karma: +0/-0
    • Obsidian-Cult
Re: EQDKP - ingame query module
« Reply #29 on: October 16, 2009, 06:52:24 pm »
here same prob

Systalia [TELL]   [INC]   Necdrizz: !dkp raid 49
Systalia [TELL]   [OUT]   -> Necdrizz: EQDKP ERROR: problem with code

 

* 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: 469
  • 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