collapse collapse
Menu
  • Home
  • Archives
    • * User Info
     
     
    Welcome, Guest. Please login or register.
    * Search

    * Board Stats
    • stats Total Members: 989
    • stats Total Posts: 18365
    • stats Total Topics: 2500
    • stats Total Categories: 7
    • stats Total Boards: 35
    • stats Most Online: 1144
    « previous next »
    Pages: 1 [2] 3 4 ... 10   Go Down

    Author Topic: EQDKP - ingame query module (v3.0.3)  (Read 89820 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
    Logged

    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 »
    Logged
    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?? ^^)
    Logged
    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 »
    Logged
    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 »
    Logged
    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
    Logged

    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 :)
    Logged
    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 ;)
    Logged

    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
    Logged

    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.
    Logged
    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 »
    Logged

    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
    Logged

    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 ?
    Logged

    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.
    Logged
    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
    Logged
    Pages: 1 [2] 3 4 ... 10   Go Up
    « previous next »
     
    * Recent Posts
    0.8.x updates for AO by bitnykk
    [June 23, 2024, 03:19:47 pm ]
    0.8.x updates for AoC by bitnykk
    [June 23, 2024, 03:19:44 pm ]
    [AoC] special char for items module by bitnykk
    [February 09, 2024, 09:41:18 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: 84
    • 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