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 12430 times)

0 Members and 1 Guest are viewing this topic.

Offline almas

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
eqdkp
« on: August 27, 2009, 06:58:46 pm »
Hi!
I would realy like to have module that gets info from eqdkp.
Would like to get this info:
- Display DKP per member ingame
- Display DKP per class ingame
Hope that someone can help me. I am a noob with php

Offline Runemy

  • BeBot Apprentice
  • ***
  • Posts: 97
  • Karma: +0/-0
    • Exalted [Age of Conan guild - Aquilonia EU]
Re: eqdkp
« Reply #1 on: August 28, 2009, 11:51:35 pm »
Yeah, it would require a new connection of course, but that should be very doable for the wizzards in here.

I'd like to see this as well! :)

Wood of Exalted
Age of Conan
Aquilonia - EU

Offline GBH

  • BeBot Hero
  • ******
  • Posts: 69
  • Karma: +0/-0
Re: eqdkp
« Reply #2 on: August 29, 2009, 09:03:27 pm »
EQDKP or EQDKP-Plus?

GBH

Offline Poonjab

  • BeBot User
  • **
  • Posts: 59
  • Karma: +0/-0
Re: eqdkp
« Reply #3 on: August 29, 2009, 10:03:37 pm »
My personal preference would be PLUS, but I'm sure there will be people that want regular also.

Offline Runemy

  • BeBot Apprentice
  • ***
  • Posts: 97
  • Karma: +0/-0
    • Exalted [Age of Conan guild - Aquilonia EU]
Re: eqdkp
« Reply #4 on: August 30, 2009, 12:05:51 am »
Plus please :)

Wishlist
First of all:
- Characters able to !dkp in-game to get a tell with their dkp.

Down the road suggestions:
Leaders able to
-"!dkp sub character item dkp" to substract dkp for an item bought during a raid.
- "!dkp sub character reason" to substract dkp for a named reason.
- "!dkp add character reason" to add dkp for a named reason
- "!dkp list all" to get a complete list sorted by character name
- "!dkp list class" to get a list sorted by class
« Last Edit: August 30, 2009, 12:12:00 am by Runemy »
Wood of Exalted
Age of Conan
Aquilonia - EU

Offline almas

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
Re: eqdkp
« Reply #5 on: August 30, 2009, 12:10:44 am »
yes plus please

Offline GBH

  • BeBot Hero
  • ******
  • Posts: 69
  • Karma: +0/-0
Re: eqdkp
« Reply #6 on: August 30, 2009, 11:48:50 am »
Plus please :)

Wishlist
First of all:
- Characters able to !dkp in-game to get a tell with their dkp.

Down the road suggestions:
Leaders able to
-"!dkp sub character item dkp" to substract dkp for an item bought during a raid.
- "!dkp sub character reason" to substract dkp for a named reason.
- "!dkp add character reason" to add dkp for a named reason
- "!dkp list all" to get a complete list sorted by character name
- "!dkp list class" to get a list sorted by class

You do know theres already an extensive "points" (how the bot refers to DKP) system built into the bot which interfaces with !points, !raid and !bid don't you? This offers everything you want and a lot more besides already.

I've modified the raid module in my own guild to offer a few other commands like !raid killed champ to auto allocate points on a boss kill. The modification pretty much automate everything to do with allocating points.

Ultimately what I'm saying is I'll attempt to write the module to read and display individual DKP totals from EQDKP+ but theres little point in duplicating the functionality already in raid/points/bid to write back to EQDKP+. Perhaps if I'm feeling energetic I could integrate the existing points system with EQDKP+ but as my PHP skills are weak and I'm slow I'm not making any promises on anything ;)

G

Offline Runemy

  • BeBot Apprentice
  • ***
  • Posts: 97
  • Karma: +0/-0
    • Exalted [Age of Conan guild - Aquilonia EU]
Re: eqdkp
« Reply #7 on: August 30, 2009, 02:13:25 pm »
Plus please :)

Wishlist
First of all:
- Characters able to....

You do know theres already an extensive "points" (how the bot refers to DKP) system built into the bot which interfaces with !points, !raid and !bid don't you? This offers everything you want and a lot more besides already.

I've modified the raid module in my own guild to offer a few other commands like !raid killed champ to auto allocate points on a boss kill. The modification pretty much automate everything to do with allocating points.

Yeah, I know it's there mate, but we're already "deep" into eqdkp, with 165 raiding chars, so I'd really hate to do the conversion to the in-game one. The in-game one is also missing online functionality so there would be work to do there as well, though it's relatively easy to pull data from the database.

But well, if you could look into this it would be superb indeed :)
Wood of Exalted
Age of Conan
Aquilonia - EU

Offline almas

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
Re: eqdkp
« Reply #8 on: August 30, 2009, 03:21:05 pm »
The way I see it its not very important to be able to write to eqdkp plus. But it would be great if we could be able to see how much dkp everyone have

Offline almas

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
Re: eqdkp
« Reply #9 on: September 19, 2009, 12:57:41 am »
any update on this? Would be great if someone could make this module

Offline Hughie

  • BeBot Rookie
  • *
  • Posts: 3
  • Karma: +0/-0
Re: eqdkp
« Reply #10 on: September 22, 2009, 09:13:05 am »
Shouldn't be too difficult if you got access to the eqdkp database: just write a function which syncs the dkp from eqdkp to the raid_points table or a new one. Should be two or three sql statements and a check if the user exists. You can even sync both ways, to update the eqdkp from within the game.

I wanted to do something similar, but i don't have access to the eqdkp database, so i fetched the summary site from the web, extracted names and dkp from it and wrote them to the points table (after checking the user exists in the bebot). But for quick results i did it in perl with an external script. I don't even know if my guild will use the points system at all, so i don't know if i try to port it to php and bebot.

Offline Runemy

  • BeBot Apprentice
  • ***
  • Posts: 97
  • Karma: +0/-0
    • Exalted [Age of Conan guild - Aquilonia EU]
Re: eqdkp
« Reply #11 on: October 06, 2009, 06:32:24 pm »
Trying a little bump on this one. Anybody has the opportunity to look into it?

I tried, but failed terribly as I even don't know how to make bebot connect to another database.

Ah, well, I'll still be looking into it, but don't hold your breath waiting for a release from my end :)
Wood of Exalted
Age of Conan
Aquilonia - EU

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: eqdkp
« Reply #12 on: October 06, 2009, 08:14:41 pm »
AFAIK bebot doesn't handle connection to two databases..

I have never used EQDKP so i dont know how stuff is saved there..
But what you can do is make a webpage where you either give XML feed or the output as you want it in game and then use get_site() to retrieve it in game.

Ex:
http://yourdomain.tld/eqdkp_bebot.php?list : Outputs entire list
http://yourdomain.tld/eqdkp_bebot.php?player=member : Outputs list of player
http://yourdomain.tld/eqdkp_bebot.php?class=classname : Outputs list of classname

Then you use get_site() in a script, something like this:
$url = "http://yourdomain.tld/eqdkp_bebot.php?list";
return $this -> bot -> core("tools") -> get_site($url, 1);

If you choice to output XML feed you ofc need to make a parser before outputting..

This isn't the entire recipe to make it, but a pointer in how to you can do it without connecting to the DB.
« Last Edit: October 06, 2009, 08:18:02 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 Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: eqdkp
« Reply #13 on: October 06, 2009, 11:32:38 pm »
If a php script can connect to two db servers at once then it's pretty straight-forward to do this in bebot. You have to code the second connection using the mysql_*() or whatever db you want to use api directly, and not by $bot->db->command().

Like you do in any new basic php script too.

Offline Runemy

  • BeBot Apprentice
  • ***
  • Posts: 97
  • Karma: +0/-0
    • Exalted [Age of Conan guild - Aquilonia EU]
Re: eqdkp
« Reply #14 on: October 14, 2009, 12:54:08 am »
Thanks for the tips guys, but I still really just don't know in which end to start this, nor does my free hours allow me to dig too deep into it either, so in hopes of leeching off others expertise I do the bump again.  :)

Three nights a week I miss this feature.

!dkp ingame to get a tell with ones dkp
!dkp Name as a Leader to get a tell with the dkp of Name

I'd be happy to help out in any ways I can with getting this up and running. I have admin access to both db's.
Wood of Exalted
Age of Conan
Aquilonia - EU

 

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