BeBot - An Anarchy Online and Age Of Conan chat automaton

Development => Generic custom modules => Topic started by: Getrix on October 14, 2009, 11:19:25 am

Title: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on October 14, 2009, 11:19:25 am
EQDKP - in game query module

With this module you can query EQDKP database in game. (Tested on EQDKP Plus 0.6.3.3)
Module based on function requested in this topic: http://bebot.link/module-requests/eqdkp/

Feel free to give feedback or build on this module as long you give some creds ;)

[Download latest stable 3.x] (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/v3/EQDKP_Query.phps) Read/Write used on own risk
[Download latest stable 2.x] (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/v2/EQDKP_Query.phps) Read only

Language files: (Stored in BOTFOLDER/extra/language (Create folder if not exist))
[English] v2 (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/v2/lang_eqdkp.en.phps) v3 (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/v3/lang_eqdkp.en.phps)
[German] v2 (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/v2/lang_eqdkp.de.phps) v3 (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/v3/lang_eqdkp.de.phps) - Thanks to Margon aka Puseidr @ Asgard AoC
[Norwegian] v2 (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/v2/lang_eqdkp.no.phps) v3 (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/v3/lang_eqdkp.no.phps) - For whoever wants that :P

NOTE: I don't use EQDKP or EQDKP Plus so i don't have much experience with the system and not much interest on it without just helping out :P
The module have become bigger then expected and i will keep coding as long its fun for me ;)
Title: Re: EQDKP - ingame query module
Post by: Getrix on October 14, 2009, 11:21:49 am
Release History
Quote
2011-04-15 - v3.0.4
 + Add if in same instance, dont show raidinv....   
 + Fixed raid_note with html chars.
 + Added rank on get_list. Changed colorcodes, using gmod_(getrix module) in !color gmod
2009-11-18 - v3.0.3 - Added first writing to EQDKP function, raid signup ingame. !!NOTE: Use on own risk!!

2009-11-13 - v2.0.3 - Fixed bug when there wasnt any signed for a raid.
2009-10-19 - v2.0.2 - Fixed order bug. Minor change in DB function
2009-10-19 - v2.0.1 - Fixed order bug in signup.
2009-10-18 - v2.0.0 - Added multi-language support. !set EQdkp language <en|de> (Note: Restart needed if you change. And the new language files to put in extra/language/ (Create folder if not exist) )
2009-10-18 - v1.9.9 - Cleaned up the code and changed release versioning to "Incrementing sequences (http://en.wikipedia.org/wiki/Software_versioning#Incrementing_sequences)"
2009-10-17 - v1.4.0 - Added "!dkp raid <raid_id> notes <member_id>". This is placed after nick in "!dkp raid <raid_id>" as clickable [Notes] link.
2009-10-16 - v1.3.3 - Changed Raid/Group invite only shows if the player is online. Added German class shortcuts.
2009-10-16 - v1.3.2 - Fixed bug in RaidDetails with Raid/Group invite not showing up. Bad coding by me:(
2009-10-16 - v1.3.1 - Fixed "Distribution" bug in !dkp raid to support "Class/Role/No Distribution". Added Raid/Group invite commands to "LEADER" security group.
2009-10-16 - v1.3.0 - Added time_offset to fix timezone difference (!set eqdkp). Added "!dkp debug" for debugging. Show "Raid ID" in raid list. And some small fixes
2009-10-16 - v1.2.2 - Fixed bug with HoX, PoM ToS not working and added ability to use shortcuts for class. Added "!dkp raid [raidid]" to query Raidplanner.
2009-10-16 - v1.2.1 - Fixed "!dkp online" and color bug. Added "Raid count" in player display
2009-10-15 - v1.2.0 - Added Item History, Raid Attendance and Adjustment History to !dkp nick <nick> display
2009-10-15 - v1.1.0 - Added !dkp online [class] command ([class] is optional)
2009-10-14 - v1.0.2 - Fixed listing classes with spaces "!dkp class <Class with space>"
2009-10-14 - v1.0.1 - Fixed adjustment calculation
2009-10-14 - v1.0.0 - First release

Commands
Quote
!dkp // Returns DKP info for player that runs the command
!dkp nick <nick> // Returns DKP info for <nick>
!dkp class <class> // Returns DKP info for that class ordered by top
!dkp online [class] // Returns DKP info for online players ([class] is optional, and will return class spesific if set)
!dkp raid [raid_id] // Shows upcomming raids and details if [raid_id] as optional is set.
!dkp debug // To give me some info to debug with.

Setup
Quote
!set EQdkp DB_host <host> // Default localhost
!set EQdkp DB_user <username> // Default eqdkp
!set EQdkp DB_pass <password>
!set EQdkp DB_name <databasename> // Default eqdkp_plus
!set EQdkp DB_pref <tableprefix> // Default eqdkp_ (Remember underscore if you have that)
!set EQdkp // To se more settings

Known bugs:
Non atm
Title: Re: EQDKP - ingame query module
Post by: Runemy on October 14, 2009, 12:06:03 pm
Cheers mate, look forward to using it!  :)

And yeah, I'll try to fool around with more additions to this mod as soon as my time available permits it.
Title: Re: EQDKP - ingame query module
Post by: Margon on October 14, 2009, 01:54:34 pm
nice plugin.
but there is a little bug.

!dkp class <a class with space>

doesnt work
like "Tempest of Set"
Title: Re: EQDKP - ingame query module
Post by: Drizzurdeen on October 14, 2009, 02:37:54 pm
hiho ... very nice plugin ... so now my request ;)

there ist a raid-module here where u can sign up for raids or events ... my idea is to have a raid-module with this features

features:
- eqdkp-connection
- dkp info from the eqdkp
- creating eqdkp-accounts automatic by bot-member (only when u set ur status on "raider")
- creating eqdkp-chars automatic by bot-member and alts
- when u sign up for an event by the bot u should automitc sign up by the raid in the eqdkp
- when u sign up for a raid in the eqdkp u should automatic sign up for the bot-event
- created events on the bot should be automtic updatet in the eqdkp
- craeted events on the eqdkp shoud be automati updated on the bot

this would be the most butiful module ... but hardly to create such a module i think ..

for any how would work on it ... u can use my eqdkpplus (latest release) an u would get a test-bot

so long
Drizz
Title: Re: EQDKP - ingame query module
Post by: Getrix on October 14, 2009, 03:24:31 pm
Quote
2009-10-14 - v1.2 - Fixed listing classes with spaces "!dkp class <Class with space>"
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...
Title: Re: EQDKP - ingame query module
Post by: Drizzurdeen on October 14, 2009, 03:31:37 pm
an when u will get a test eqdkp including sql access and a testbot ???
Title: Re: EQDKP - ingame query module
Post by: Runemy on October 14, 2009, 04:04:22 pm
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: [Select]
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 ;
Title: Re: EQDKP - ingame query module
Post by: Getrix on October 14, 2009, 04:21:40 pm
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 ;)
Title: Re: EQDKP - ingame query module
Post by: Runemy on October 14, 2009, 04:41:25 pm
hahaha, here's me hoping you'll stay sick a while ^^
Title: Re: EQDKP - ingame query module
Post by: Getrix on October 14, 2009, 05:06:41 pm
Hehe, you wish :P Good that in Norway you can be away from work for 3days without going to doctor to still get paid for days away;)

Back to EQDKP.
Could you give me some info on how EQDKP works? The Adjustment, isnt that just to adjust players as in give them points that have been forgot put there or just a bonus?
How is a ordinary raid with players getting there DKP being done? (Create raid, signup etc?)
Title: Re: EQDKP - ingame query module
Post by: Runemy on October 14, 2009, 05:24:25 pm
Well, the adjustments are mainly for just that; adjustments. But, depending of ones rules of course, there can be quite a lot of adjustments. I have adjustments for raid leading, resource gathering, turning up late, leaving early, not signing up etc.

Item's which was my initial thought is not handled by adjustments directly, but looking at the contents of the table everything ends up in that table, from normal dkp bonus for joining rids, through buying of items to the individual odd adjustments.

As a how-to on the usage I can run you through a small one here, there are probably different ways to use it as well as it is a rather advanced system:
1. Events are created for the different raid instances
2. Add raids through the Raidplanner by clicking on the date and then choosing the event. Here you can set the value of the raid as well.
3. People sign up for the raid (event)
4. When the raid is done an admin can through the option button in the detailed view of the raid, "Transform  it to a Raid".
5. You will then get a confirmation window with all the confirmed attendees plus the dkp awarded.
6. Next windows brings up the opportunity to "Add Items from this Raid"
7. Doing this gives you the opportunity to choose the player, the item (if earlier been entered in the database and also the opportunity to add a new item), and the value of the item. This item will then be linked to the raid in all instances of eqdkp.

But then, when we have people leaving early, coming late, raid leading or other various things we will need to add this to individual adjustments.

But looking at the database table of adjustments it seems that all things end up in the adjustments table.
Title: Re: EQDKP - ingame query module
Post by: Khalem on October 14, 2009, 07:20:48 pm
Awesome job Getrix.

Thanks for picking up and running with this. (God bedring)
Title: Re: EQDKP - ingame query module
Post by: Getrix on October 14, 2009, 10:18:52 pm
Did dig a bit into EQDKP code and here is what i have found out so far:

Raid create should be on page i think. It will be to much code to get it work ingame.
The stuff i think will be usefull ingame is give DKP to raid and adjustment along with current query.

Adjustment can be tricky, if you need to get a costume Event for every adjustment you will add.
Ex, when you are adding a adjustment it seems that you can:
1: Add a new event for this adjustment
2: Use a old adjustment event.

And after that add adjustment value,reason,user.
The problem here is that in game you cant do "dropedowns" like you do in a webpage. It will then be tricky to make the user to do 1 or 2 because he needs to do that before passing the adjustment_value,reason,user to the bot. And adjustment event is stored in own table with id/ref link to adjustment table.
What we can do is make a "static" adjustment event called "BeBot in game adjustment" and use that event id/ref link when calling ex "!dkp adjust <nick> <amount> <reason>" And later edit it on webpage if needed.

It can also be done with some session saving (Wizard that following you thrue command by command), but its gonna be much clicks etc for the administrator in game...

EDIT: uh yeah was abit tired when writing so maybe it doesnt make any sense :P
Title: Re: EQDKP - ingame query module
Post by: Getrix on October 15, 2009, 11:28:41 am
Starting to understand the EQDKP Plus backend code now. But still have some problem with how stuff should be made.

1: When you are going to adjust a member, how important is it to "bind" that adjustment to a event? Is it ok to just set the Event as "BeBot" to show it was added ingame and then use reason to explain why this adjustment happen? Ingame adjustment is for individual anyway, so if you gonna adjust multiply players do that via webinterface i think...

2: Is raidplanner a plugin? I only find "Add Raid" in "Administration" and there i can add ppl that joined the raid and select event. No signup page...
Title: Re: EQDKP - ingame query module
Post by: Margon 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
Title: Re: EQDKP - ingame query module
Post by: Getrix on October 15, 2009, 05:04:59 pm
Quote
2009-10-15 - v1.3 - Added !dkp online [class] command ([class] is optional)
Title: Re: EQDKP - ingame query module
Post by: Runemy 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?? ^^)
Title: Re: EQDKP - ingame query module
Post by: Getrix 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
Title: Re: EQDKP - ingame query module
Post by: Getrix 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
Title: Re: EQDKP - ingame query module
Post by: Margon 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
Title: Re: EQDKP - ingame query module
Post by: Runemy on October 16, 2009, 12:04:37 pm
Hehe, he's already working on it I think :)
Title: Re: EQDKP - ingame query module
Post by: Drizzurdeen on October 16, 2009, 01:07:26 pm
can't wait any longer for it ;) go getrix go ;)
Title: Re: EQDKP - ingame query module
Post by: Margon 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
Title: Re: EQDKP - ingame query module
Post by: Getrix 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.
Title: Re: EQDKP - ingame query module
Post by: Drizzurdeen 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
Title: Re: EQDKP - ingame query module
Post by: Margon on October 16, 2009, 05:14:45 pm
Code: [Select]
!dkp raid 375
[BeBot]: EQDKP ERROR: problem with code

looks like a problem
Title: Re: EQDKP - ingame query module
Post by: Drizzurdeen on October 16, 2009, 05:26:17 pm
have the same prob ...

only the first raid would be shown correct

here screens

(http://obsidian-cult.de/Media/Necdrizz_picture002.png)
(http://obsidian-cult.de/Media/Necdrizz_picture003.png)

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 ?
Title: Re: EQDKP - ingame query module
Post by: Runemy on October 16, 2009, 05:59:25 pm
Works 100% on my end, we can view all raids and all signs show.
Title: Re: EQDKP - ingame query module
Post by: Drizzurdeen 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
Title: Re: EQDKP - ingame query module
Post by: Margon on October 16, 2009, 07:50:51 pm
Works 100% on my end, we can view all raids and all signs show.

what eqdkp version do you use?
Title: Re: EQDKP - ingame query module
Post by: Drizzurdeen on October 16, 2009, 07:54:46 pm
EQDKP Plus 0.6.3.0

an it don't work ... only the first raid is shown correct ... but is it correct that only my own sign up is shown ???
Title: Re: EQDKP - ingame query module
Post by: Getrix on October 16, 2009, 08:04:45 pm
Quote
2009-10-16 - v1.7 - Added time_offset to fix timezone difference (!set eqdkp). Added "!dkp debug" for debugging. Show "Raid ID" in raid list. And some small fixes

Could you download v1.7 and run "!dkp debug" and post it.

It seems that the two person that cant make it work is German users. Is the database different?

EDIT: Oops, forgot to upload the file
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Margon on October 16, 2009, 09:13:10 pm
Config DB
default_lang = german
game_language = de
game_version = 1.0
plus_version = 0.6.3.0

Module version: v1.7 - 2009-10-15

but the databasebuild should be the same (only the class-names are translated)
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Getrix on October 16, 2009, 09:15:01 pm
And you are also using "Roles" for signups?
The error you are getting is close to where the roles are grouped and getting ready to be printed. And it tells me that there is no "Roles" set...
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Drizzurdeen on October 16, 2009, 09:18:15 pm
Quote
Config DB
default_lang = german
game_language = de
game_version = 1.0
plus_version = 0.6.3.0

Module version: v1.7 - 2009-10-15
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Drizzurdeen on October 16, 2009, 09:22:08 pm
another question ... why i can only see one sign up ???

but there are 8 sign ups ... hmmmmm crazy

(http://obsidian-cult.de/Media/Necdrizz_picture003.png)
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Margon on October 16, 2009, 09:23:21 pm
our raids are set to "no distribution"

when i use "role distribution" it works

can you fix it please?



Getrix 4 president ! :)
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Drizzurdeen on October 16, 2009, 09:28:14 pm
narf ... so i have to define roles ??? like tank dd heal and so on ???
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Drizzurdeen on October 16, 2009, 09:33:53 pm
ah kk i have to change the raids to rolle-distribution ;) .... here runs the rabit ^^

btw. the group and raid-invite is perfekt ;)

signed Getrix for president ;)
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Getrix on October 16, 2009, 09:35:17 pm
Didnt know there was a option to not have Roles.
Could you tell me where i find that option and i will try to make a workaround for it.
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Drizzurdeen on October 16, 2009, 09:36:43 pm
when u create a raid u can decide if it should be with class- , roll- or non-distribution
Title: Re: EQDKP - ingame query module (v1.7)
Post by: Margon on October 16, 2009, 09:47:38 pm
Administration Panel -> Raidplaner Settings -> Layout/Style
(http://www.illuminati-aoc.com/1.jpg)

and when you add a new raid you can chance the distribution here
(http://www.illuminati-aoc.com/2.jpg)
Title: Re: EQDKP - ingame query module (v1.8)
Post by: Getrix on October 16, 2009, 10:06:11 pm
Thanks for good debugging ;)

Quote
2009-10-16 - v1.8 - Fixed "Distribution" bug in !dkp raid to support "Class/Role/No Distribution". Added Raid/Group invite commands to "LEADER" security group.

Problem here was that i didnt know about this options.
Title: Re: EQDKP - ingame query module (v1.8)
Post by: Drizzurdeen on October 16, 2009, 10:21:18 pm
kk now it works perfekt ... buuuuuuuuuuuuuuut ...

in the view of the raid ... only signed chars could be get invited ... the confirmd chard could not ...

(http://obsidian-cult.de/Media/Drizzurden_picture015.png)
(http://obsidian-cult.de/Media/Drizzurden_picture016.png)
Title: Re: EQDKP - ingame query module (v1.9)
Post by: Getrix on October 16, 2009, 10:31:56 pm
Quote
2009-10-16 - v1.9 - Fixed bug in RaidDetails with Raid/Group invite not showing up. Bad coding by me:(
Title: Re: EQDKP - ingame query module (v1.9)
Post by: Drizzurdeen on October 16, 2009, 10:50:48 pm
added the german short-names ... some of them are quite funny couse sometimes the englisch and german short-names are same ... but it works ;)

Quote
// Copyright (C) 2009 Daniel Holmen for get_class_name()
    function get_class_name($name) {
         $aliases = array(
            "sin" => "Assassin",
            "barb" => "Barbarian",
            "bs" => "Bear Shaman",
            "shammy" => "Bear Shaman",
            "conq" => "Conqueror",
            "dt" => "Dark Templar",
            "demo" => "Demonologist",
            "guard" => "Guardian",
            "hox" => "Herald of Xotli",
            "necro" => "Necromancer",
            "pom" => "Priest of Mitra",
            "ranger" => "Ranger",
            "tos" => "Tempest of Set",
            "assa" => "Assassin",
            "bar" => "Barbar",
            "schami" => "Bärenschamane",
            "ero" => "Eroberer",
            "templer" => "Dunkler Templer",
            "dämo" => "Dämonologe",
            "wä" => "Wächter",
            "herold" => "Herold des Xotli",
            "nek" => "Nekromant",
            "pomi" => "Mitrapriester",
            "waldi" => "Waldläufer",
            "tosi" => "Vollstrecker Sets"
         );
Title: Re: EQDKP - ingame query module (v1.9)
Post by: Drizzurdeen on October 16, 2009, 10:58:03 pm
getrix u are my hero ... soooooooooooo perfekt work ... best modul ever ... ;) *PARTY*

Title: Re: EQDKP - ingame query module (v1.9)
Post by: Getrix on October 16, 2009, 11:04:16 pm
Thanks Drizzurdeen. Added that to the code and will be in next update.
Title: Re: EQDKP - ingame query module (v1.9)
Post by: Drizzurdeen on October 16, 2009, 11:07:48 pm
ok last idea :)

would it possible to get a online-info in the raidoverview ... so the readleader could see if the char who should be invited is online or not ???

i know i#m nerfing ... but this litle ad-on would make the work of a raidleader more comfortable ;)

greez da Drizz
Title: Re: EQDKP - ingame query module (v1.9)
Post by: Margon on October 16, 2009, 11:12:54 pm
here is an german version of your script v1.11
http://www.illuminati-aoc.com/eqdkp_ger.php
Title: Re: EQDKP - ingame query module (v1.9)
Post by: Drizzurdeen on October 16, 2009, 11:20:06 pm
lol kk 2 guys one idea ;) ... *pew* so i don't have to do this ;) thanks

is it allowed to change a bit the short-names ??? cause in german conq = ero ;)
Title: Re: EQDKP - ingame query module (v1.10)
Post by: Getrix on October 16, 2009, 11:35:38 pm
Quote
2009-10-16 - v1.10 - Changed Raid/Group invite only shows if the player is online. Added German class shortcuts.

Thanks for the translation.
Maybe I take a look into easier translation of text being printed out as it seems I have a few German fans here ;)
Title: Re: EQDKP - ingame query module (v1.11)
Post by: Getrix on October 17, 2009, 12:31:19 am
Quote
2009-10-17 - v1.11 - Added "!dkp raid <raid_id> notes <member_id>". This is placed after nick in "!dkp raid <raid_id>" as clickable [Notes] link.

*over and out for today* :P
Title: Re: EQDKP - ingame query module (v1.11)
Post by: Khalem on October 17, 2009, 01:31:11 am
Getting multi language support is seeming more and more like something we need to think about as a core functionality for the bot.

It would be a labourious task (requires essentially rewriting every text string in the bot) and creating and then maintaining translations.

*goes away to ponder*
Title: Re: EQDKP - ingame query module (v1.11)
Post by: Drizzurdeen on October 17, 2009, 02:31:48 pm
@ khalem ...

i try to start a multilangual wiki for the bot ... based on our mmo-wiki ... maybe we can start to fill this wiki

here is the link: http://wiki.obsidian-cult.de/index.php/BeBot-WIKI_de

would be nice if we can go this way

greez da Drizz
Title: Re: EQDKP - ingame query module (v1.11)
Post by: Getrix on October 17, 2009, 05:15:06 pm
Have been looking into multilanguage support.
But to do some testing i would like some translation. Know atleast there is German users here, so if someone could provide me with a translated file it would be greate=)

English language file (http://dump.sjef.biz/aoc/bebot/lang_eqdkp.en.phps)

*Wee, going to party now*
Title: Re: EQDKP - ingame query module (v1.11)
Post by: Drizzurdeen on October 17, 2009, 06:09:38 pm
here the translation ...

the first code ist the english ... than the german ... hope i helps

Code: [Select]
<?php
/**
 * Language     :   English
 * Translater   :   Getrix
 * Date         :   2009-10-17
 * Base Version :   1.0
*/

    
define('LANG_HELP_DESCRIPTION''With this module you can query EQDKP Plus ingame.');
    
define('LANG_HELP_COMMAND_NICK''Request DKP for <nick>');
    
define('LANG_HELP_COMMAND_CLASS''Request DKP for <class>');
    
define('LANG_HELP_COMMAND_ONLINE''Request DKP for online players ([class] is optional)');
    
define('LANG_HELP_COMMAND_RAID''Shows upcomming raids and details if [raid_id] as optional is set');
    
define('LANG_HELP_COMMAND_DEBUG''Show info to be used in debugging.');
    
    
define('LANG_SETTINGS_DBHOST''Database host');
    
define('LANG_SETTINGS_DBUSER''Database username');
    
define('LANG_SETTINGS_DBNAME''Database name');
    
define('LANG_SETTINGS_DBPASS''Database password');
    
define('LANG_SETTINGS_DBPREF''Database table prefix');
    
define('LANG_SETTINGS_TIMEOFFSET''Time offset sync between bot and mysql clock.');
    
    
define('LANG_ERROR_UKNOWN''EQDKP recieved unknown command');
    
define('LANG_ERROR_NO_RESULT''No result');
    
define('LANG_ERROR_FIND_RAID''Cant find the raid with that ID');
    
define('LANG_ERROR_NO_UP_RAID''No upcomming raids');
    
define('LANG_ERROR_NOTE''Did not find any notes.');
    
    
define('LANG_NICK''Nick');
    
define('LANG_RANK''Rank');
    
define('LANG_POINTS''Points');
    
define('LANG_LAST_RAID''Last raid');
    
define('LANG_RAIDCOUNT''Raidcount');
    
define('LANG_CLASS''Class');
    
define('LANG_EARNED''Earned');
    
define('LANG_SPENT''Spent');
    
define('LANG_ADJUSTMENT''Adjustment');
    
define('LANG_CURRENT''Current');
    
define('LANG_LAST''Last');
    
define('LANG_RAID_INFO''Raid info');
    
    
define('LANG_HEAD_OVERVIEW''DKP overview for');
    
define('LANG_HEAD_RAIDINFO''Raidinfo for');
    
define('LANG_HEAD_SIGNUP_LIST''Signup list');
    
    
define('LANG_HISTORY_ITEM_BUY''Item Purchase History');
    
define('LANG_HISTORY_RAID_ATT''Raid Attendence History');
    
define('LANG_HISTORY_INDIV_ADJ''Individual Adjustment History');
    
    
define('LANG_RESULT_ON_CLASS''Result for online class');
    
define('LANG_RESULT_ON_PLAYERS''Result for online players');
    
define('LANG_RESULT_PLAYER''Overview for');
    
define('LANG_RESULT_OVERVIEW_FOR''Result overview for');
    
    
define('LANG_INVITE_TIME''Invite time');
    
define('LANG_START_TIME''Start time');
    
define('LANG_SIGNUP_TIME''Signup time');
    
define('LANG_FINISH_TIME''Finish time');
    
define('LANG_CONFIRMED''Confirmed');
    
define('LANG_SIGNED''Signed');
    
define('LANG_UNSIGNED''Unsigned');
    
define('LANG_NOT_SURE''Not sure');
    
define('LANG_TOTAL''Total');
    
define('LANG_RAIDLEADER''Raid Leader');
    
define('LANG_NOTE''Note');
    
define('LANG_VALUE''Value');
    
define('LANG_RAID''Raid');
    
define('LANG_GROUP''Group');
    
define('LANG_INVITE''Invite');
    
define('LANG_RAID_ID''Raid ID');
    
define('LANG_MORE_INFO''More Info');
    
define('LANG_UPCOMMING_RAIDS''Upcomming raids');
?>


<?php
/**
 * Language     :   German
 * Translater   :   Drizzurden
 * Date         :   2009-10-17
 * Base Version :   1.0
*/

    
define('LANG_HELP_DESCRIPTION''Dieses Modul ist eine Schnittstelle IG mit einem EQDKP PLUS.');
    
define('LANG_HELP_COMMAND_NICK''DKP-Anfrage für <Charakter>');
    
define('LANG_HELP_COMMAND_CLASS''DKP-Anfrage für <Klasse>');
    
define('LANG_HELP_COMMAND_ONLINE''DKP-Anfrage für Charaktere die online sind ([Klasse] optional)');
    
define('LANG_HELP_COMMAND_RAID''Ziegt anstehende Raids und die dazugehörigen Informationen');
    
define('LANG_HELP_COMMAND_DEBUG''Zeigt die Debug-Informationen.');
    
    
define('LANG_SETTINGS_DBHOST''Datenbank host');
    
define('LANG_SETTINGS_DBUSER''Datenbank Benutzername');
    
define('LANG_SETTINGS_DBNAME''Name der Datenbank');
    
define('LANG_SETTINGS_DBPASS''Passwirt der Datebank');
    
define('LANG_SETTINGS_DBPREF''Prefix der Installation');
    
define('LANG_SETTINGS_TIMEOFFSET''Zeitzonensynchronisation zwischen der Bot- und der mysql-Uhr.');
    
    
define('LANG_ERROR_UKNOWN''EQDKP bekam einen unbekannten Befehl');
    
define('LANG_ERROR_NO_RESULT''Kein Ergebnis');
    
define('LANG_ERROR_FIND_RAID''Ich kann den Riad mit dieser ID nicht finden');
    
define('LANG_ERROR_NO_UP_RAID''Es gibt derzeit keine anstehnden Raids');
    
define('LANG_ERROR_NOTE''Ich konnete keine Notizen finden.');
    
    
define('LANG_NICK''Charakter');
    
define('LANG_RANK''Rang');
    
define('LANG_POINTS''Punkte');
    
define('LANG_LAST_RAID''letzter Raid');
    
define('LANG_RAIDCOUNT''Anzahl der Raids');
    
define('LANG_CLASS''Klasse');
    
define('LANG_EARNED''Bekommen');
    
define('LANG_SPENT''Ausgegeben');
    
define('LANG_ADJUSTMENT''Korrektur');
    
define('LANG_CURRENT''Aktuell');
    
define('LANG_LAST''Letzte');
    
define('LANG_RAID_INFO''Raidinformationen');
    
    
define('LANG_HEAD_OVERVIEW''DKP-Überblick für');
    
define('LANG_HEAD_RAIDINFO''Raidinformationen für');
    
define('LANG_HEAD_SIGNUP_LIST''Anmeldeliste');
    
    
define('LANG_HISTORY_ITEM_BUY''Item-Kauf-Historie');
    
define('LANG_HISTORY_RAID_ATT''Raid-Anwesenheits-Historie');
    
define('LANG_HISTORY_INDIV_ADJ''individuelle Korrektur-Historie');
    
    
define('LANG_RESULT_ON_CLASS''Ergebnis aller Klassen die gerade online sind');
    
define('LANG_RESULT_ON_PLAYERS''Ergenbis aller Spieler die gerade online sind');
    
define('LANG_RESULT_PLAYER''Überblick für');
    
define('LANG_RESULT_OVERVIEW_FOR''Ergebnisübersicht für');
    
    
define('LANG_INVITE_TIME''Einladezeitpunkt');
    
define('LANG_START_TIME''Startzeitpunkt');
    
define('LANG_SIGNUP_TIME''Anmeldefrist');
    
define('LANG_FINISH_TIME''vor. Endzeitpunkt');
    
define('LANG_CONFIRMED''bestätigt');
    
define('LANG_SIGNED''angemeldet');
    
define('LANG_UNSIGNED''noch nicht angemeldet');
    
define('LANG_NOT_SURE''Ersatzbank');
    
define('LANG_TOTAL''Total');
    
define('LANG_RAIDLEADER''Raidleiter');
    
define('LANG_NOTE''Notiz');
    
define('LANG_VALUE''Wert');
    
define('LANG_RAID''Raid');
    
define('LANG_GROUP''Gruppe');
    
define('LANG_INVITE''Einladung');
    
define('LANG_RAID_ID''Raid ID');
    
define('LANG_MORE_INFO''Raidinformation');
    
define('LANG_UPCOMMING_RAIDS''anstehende Raids');
?>
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Getrix on October 18, 2009, 03:27:34 pm
Topic Start (http://bebot.link/generic-custom-modules/eqdkp-ingame-query-module/)

Quote
2009-10-18 - v2.0.0 - Added multi-language support. !set EQdkp language <en|de> (Note: Restart needed if you change. And the new language files to put in extra/language/ (Create folder if not exist) )

[Download latest stable] (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/EQDKP_Query.phps)

Language files: (Stored in BOTFOLDER/extra/language (Create folder if not exist))
[English] (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/lang_eqdkp.en.phps)
[German] (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/lang_eqdkp.de.phps) - Thanks to Margon aka Puseidr @ Asgard AoC

Need German translation on:
define('LANG_SETTINGS_LANGUAGE', 'Language on text. Restart required to take effect.');
define('LANG_CREDITS_LANGUAGE', 'Language');
define('LANG_CREDITS_TRANSLATER', 'Translater');
define('LANG_CREDITS_DATE', 'Date');
define('LANG_CREDITS_BASE_VERSION', 'Base Version');

Also feel free to correct the English text if you find some ugly grammar errors (English isnt my native language)
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Drizzurdeen on October 18, 2009, 04:53:12 pm
define('LANG_SETTINGS_LANGUAGE', 'Language on text. Restart required to take effect.');
define('LANG_CREDITS_LANGUAGE', 'Language');
define('LANG_CREDITS_TRANSLATER', 'Translater');
define('LANG_CREDITS_DATE', 'Date');
define('LANG_CREDITS_BASE_VERSION', 'Base Version');

translation:

define('LANG_SETTINGS_LANGUAGE', 'Textsprache. Neustart erforderlich um Änderungen zu übernehmen..');
define('LANG_CREDITS_LANGUAGE', 'Sprache');
define('LANG_CREDITS_TRANSLATER', 'Übersetzer');
define('LANG_CREDITS_DATE', 'Datum');
define('LANG_CREDITS_BASE_VERSION', 'Basisversion');
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Getrix on October 18, 2009, 05:01:09 pm
Thanks, added to lang_eqdkp.de.php (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/lang_eqdkp.de.phps)
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Drizzurdeen on October 18, 2009, 05:11:45 pm
kk have now the latest release ... multilangual ... changed in setting on de but now this -.-

(http://www.obsidian-cult.de/Media/Drizzurden_picture018.png)

i've created the folde i should .../extra/language
i've restartet the bot ... but someting is wrong ;)
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Drizzurdeen on October 18, 2009, 05:27:32 pm
aaaaaaaaaaaaaaah kk works perfekt ... forgot to add the lang_eqdkp.de.php in the folder language ;)

nasty drizz ;)
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Drizzurdeen on October 18, 2009, 05:39:18 pm
changed some small bugs ...

Code: [Select]
<?php
/* Credits START */
 
$credits = array();
 
$credits['language']       =   "German";
 
$credits['translater']     =   "Drizzurden";
 
$credits['date']           =   "2009-10-18";
 
$credits['base_version']   =   "2";
/* Credits END*/

    
define('LANG_HELP_DESCRIPTION''Dieses Modul ist eine Schnittstelle IG mit einem EQDKP PLUS.');
    
define('LANG_HELP_COMMAND_NICK''DKP-Anfrage für <Chrakter>');
    
define('LANG_HELP_COMMAND_CLASS''DKP-Anfrage für <Klasse>');
    
define('LANG_HELP_COMMAND_ONLINE''DKP-Anfrage für Charaktere die online sind ([class] optional)');
    
define('LANG_HELP_COMMAND_RAID''Ziegt anstehende Raids und die dazugehörigen Informationen');
    
define('LANG_HELP_COMMAND_DEBUG''Zeigt die Debug-Informationen.');
    
    
define('LANG_SETTINGS_DBHOST''Datenbank host');
    
define('LANG_SETTINGS_DBUSER''Datenbank Benutzername');
    
define('LANG_SETTINGS_DBNAME''Name der Datenbank');
    
define('LANG_SETTINGS_DBPASS''Passwort der Datebank');
    
define('LANG_SETTINGS_DBPREF''Prefix der Installation');
    
define('LANG_SETTINGS_TIMEOFFSET''Zeitzonensynchronisation zwischen der Bot- und der mysql-Uhr.');
    
define('LANG_SETTINGS_LANGUAGE''Textsprache. Neustart erforderlich um Änderungen zu übernehmen..');
    
    
define('LANG_ERROR_UKNOWN''EQDKP bekam einen unbekannten Befehl');
    
define('LANG_ERROR_NO_RESULT''Kein Ergebnis');
    
define('LANG_ERROR_FIND_RAID''Ich kann den Raid mit dieser ID nicht finden');
    
define('LANG_ERROR_NO_UP_RAID''Es gibt derzeit keine anstehnden Raids');
    
define('LANG_ERROR_NOTE''Ich konnte keine Notizen finden.');
    
    
define('LANG_NICK''Charakter');
    
define('LANG_RANK''Rang');
    
define('LANG_POINTS''Punkte');
    
define('LANG_LAST_RAID''letzter Raid');
    
define('LANG_RAIDCOUNT''Anzahl der Raids');
    
define('LANG_CLASS''Klasse');
    
define('LANG_EARNED''Bekommen');
    
define('LANG_SPENT''Ausgegeben');
    
define('LANG_ADJUSTMENT''Korrektur');
    
define('LANG_CURRENT''Aktuell');
    
define('LANG_LAST''Letzte');
    
define('LANG_RAID_INFO''Raidinformationen');
    
    
define('LANG_HEAD_OVERVIEW''DKP-Überblick für');
    
define('LANG_HEAD_RAIDINFO''Raidinformationen für');
    
define('LANG_HEAD_SIGNUP_LIST''Anmeldeliste');
    
    
define('LANG_HISTORY_ITEM_BUY''Item-Kauf-Historie');
    
define('LANG_HISTORY_RAID_ATT''Raid-Anwesenheits-Historie');
    
define('LANG_HISTORY_INDIV_ADJ''individuelle Korrektur-Historie');
    
    
define('LANG_RESULT_ON_CLASS''Ergebnis aller Klassen die gerade online sind');
    
define('LANG_RESULT_ON_PLAYERS''Ergebnis aller Spieler die gerade online sind');
    
define('LANG_RESULT_PLAYER''Überblick für');
    
define('LANG_RESULT_OVERVIEW_FOR''Ergebnisübersicht für');
    
    
define('LANG_INVITE_TIME''Einladezeitpunkt');
    
define('LANG_START_TIME''Startzeitpunkt');
    
define('LANG_SIGNUP_TIME''Anmeldefrist');
    
define('LANG_FINISH_TIME''vor. Endzeitpunkt');
    
define('LANG_CONFIRMED''bestätigt');
    
define('LANG_SIGNED''angemeldet');
    
define('LANG_UNSIGNED''abgemeldet');
    
define('LANG_NOT_SURE''Ersatzbank');
    
define('LANG_TOTAL''Total');
    
define('LANG_RAIDLEADER''Raidleiter');
    
define('LANG_NOTE''Notiz');
    
define('LANG_VALUE''Wert');
    
define('LANG_RAID''Raid');
    
define('LANG_GROUP''Gruppe');
    
define('LANG_INVITE''Einladung');
    
define('LANG_RAID_ID''Raid ID');
    
define('LANG_MORE_INFO''Raidinformation');
    
define('LANG_UPCOMMING_RAIDS''anstehende Raids');
    
    
define('LANG_CREDITS_LANGUAGE''Sprache');
    
define('LANG_CREDITS_LANGUAGE_VAR'$credits['language']);
    
define('LANG_CREDITS_TRANSLATER''Übersetzer');
    
define('LANG_CREDITS_TRANSLATER_VAR'$credits['translater']);
    
define('LANG_CREDITS_DATE''Datum');
    
define('LANG_CREDITS_DATE_VAR'$credits['date']);
    
define('LANG_CREDITS_BASE_VERSION''Basisversion');
    
define('LANG_CREDITS_BASE_VERSION_VAR'$credits['base_version']);
    unset(
$credits);
?>
Title: Re: EQDKP - ingame query module (v1.8)
Post by: xlDanek on October 18, 2009, 08:29:21 pm
First of all: Really great module!! Thanks for all the work!

I have only one question to Drizzurdeen's posted picture (i have the same problem):

(http://obsidian-cult.de/Media/Drizzurden_picture016.png)

Under the "Signup List" in the "Detailed Raid View", there are the raid members splitted into their classes. But as you can see in the picture, we have in the first "Assassin" category also a bear shaman and two conquerers. Somehow the ordering / sorting is messed up.
The second category "Ranger" has the same problem, because there are a demonologist and two tempest of set listed.
Finally we have two "Ranger" (= Waldläufer in german) categories in this picture.

Is this working as intended (and i don't understand it :D ) or is there something buggy?

Edit: Corrected the following spelling mistakes in Drizzurdeen's translation (only little ones):

Code: [Select]
define('LANG_HELP_COMMAND_NICK', 'DKP-Anfrage für <Charakter>');
define('LANG_HELP_COMMAND_RAID', 'Zeigt anstehende Raids und die dazugehörigen Informationen');

define('LANG_SETTINGS_DBHOST', 'Datenbank Host');
define('LANG_SETTINGS_DBPASS', 'Passwort der Datenbank');
define('LANG_SETTINGS_TIMEOFFSET', 'Zeitzonensynchronisation zwischen der Bot- und der MySQL-Uhr.');
define('LANG_SETTINGS_LANGUAGE', 'Textsprache. Neustart erforderlich um Änderungen zu übernehmen.');

define('LANG_ERROR_NO_UP_RAID', 'Es gibt derzeit keine anstehenden Raids');


Complete translation file with changes:

Code: [Select]
<?php
/* Credits START */
 
$credits = array();
 
$credits['language']       =   "German";
 
$credits['translater']     =   "Drizzurden";
 
$credits['date']           =   "2009-10-18";
 
$credits['base_version']   =   "2";
/* Credits END*/

    
define('LANG_HELP_DESCRIPTION''Dieses Modul ist eine Schnittstelle IG mit einem EQDKP PLUS.');
    
define('LANG_HELP_COMMAND_NICK''DKP-Anfrage für <Charakter>');
    
define('LANG_HELP_COMMAND_CLASS''DKP-Anfrage für <Klasse>');
    
define('LANG_HELP_COMMAND_ONLINE''DKP-Anfrage für Charaktere die online sind ([class] optional)');
    
define('LANG_HELP_COMMAND_RAID''Zeigt anstehende Raids und die dazugehörigen Informationen');
    
define('LANG_HELP_COMMAND_DEBUG''Zeigt die Debug-Informationen.');
    
    
define('LANG_SETTINGS_DBHOST''Datenbank Host');
    
define('LANG_SETTINGS_DBUSER''Datenbank Benutzername');
    
define('LANG_SETTINGS_DBNAME''Name der Datenbank');
    
define('LANG_SETTINGS_DBPASS''Passwort der Datenbank');
    
define('LANG_SETTINGS_DBPREF''Prefix der Installation');
    
define('LANG_SETTINGS_TIMEOFFSET''Zeitzonensynchronisation zwischen der Bot- und der MySQL-Uhr.');
    
define('LANG_SETTINGS_LANGUAGE''Textsprache. Neustart erforderlich um Änderungen zu übernehmen.');
    
    
define('LANG_ERROR_UKNOWN''EQDKP bekam einen unbekannten Befehl');
    
define('LANG_ERROR_NO_RESULT''Kein Ergebnis');
    
define('LANG_ERROR_FIND_RAID''Ich kann den Raid mit dieser ID nicht finden');
    
define('LANG_ERROR_NO_UP_RAID''Es gibt derzeit keine anstehenden Raids');
    
define('LANG_ERROR_NOTE''Ich konnte keine Notizen finden.');
    
    
define('LANG_NICK''Charakter');
    
define('LANG_RANK''Rang');
    
define('LANG_POINTS''Punkte');
    
define('LANG_LAST_RAID''letzter Raid');
    
define('LANG_RAIDCOUNT''Anzahl der Raids');
    
define('LANG_CLASS''Klasse');
    
define('LANG_EARNED''Bekommen');
    
define('LANG_SPENT''Ausgegeben');
    
define('LANG_ADJUSTMENT''Korrektur');
    
define('LANG_CURRENT''Aktuell');
    
define('LANG_LAST''Letzte');
    
define('LANG_RAID_INFO''Raidinformationen');
    
    
define('LANG_HEAD_OVERVIEW''DKP-Überblick für');
    
define('LANG_HEAD_RAIDINFO''Raidinformationen für');
    
define('LANG_HEAD_SIGNUP_LIST''Anmeldeliste');
    
    
define('LANG_HISTORY_ITEM_BUY''Item-Kauf-Historie');
    
define('LANG_HISTORY_RAID_ATT''Raid-Anwesenheits-Historie');
    
define('LANG_HISTORY_INDIV_ADJ''individuelle Korrektur-Historie');
    
    
define('LANG_RESULT_ON_CLASS''Ergebnis aller Klassen die gerade online sind');
    
define('LANG_RESULT_ON_PLAYERS''Ergebnis aller Spieler die gerade online sind');
    
define('LANG_RESULT_PLAYER''Überblick für');
    
define('LANG_RESULT_OVERVIEW_FOR''Ergebnisübersicht für');
    
    
define('LANG_INVITE_TIME''Einladezeitpunkt');
    
define('LANG_START_TIME''Startzeitpunkt');
    
define('LANG_SIGNUP_TIME''Anmeldefrist');
    
define('LANG_FINISH_TIME''vor. Endzeitpunkt');
    
define('LANG_CONFIRMED''bestätigt');
    
define('LANG_SIGNED''angemeldet');
    
define('LANG_UNSIGNED''abgemeldet');
    
define('LANG_NOT_SURE''Ersatzbank');
    
define('LANG_TOTAL''Total');
    
define('LANG_RAIDLEADER''Raidleiter');
    
define('LANG_NOTE''Notiz');
    
define('LANG_VALUE''Wert');
    
define('LANG_RAID''Raid');
    
define('LANG_GROUP''Gruppe');
    
define('LANG_INVITE''Einladung');
    
define('LANG_RAID_ID''Raid ID');
    
define('LANG_MORE_INFO''Raidinformation');
    
define('LANG_UPCOMMING_RAIDS''anstehende Raids');
    
    
define('LANG_CREDITS_LANGUAGE''Sprache');
    
define('LANG_CREDITS_LANGUAGE_VAR'$credits['language']);
    
define('LANG_CREDITS_TRANSLATER''Übersetzer');
    
define('LANG_CREDITS_TRANSLATER_VAR'$credits['translater']);
    
define('LANG_CREDITS_DATE''Datum');
    
define('LANG_CREDITS_DATE_VAR'$credits['date']);
    
define('LANG_CREDITS_BASE_VERSION''Basisversion');
    
define('LANG_CREDITS_BASE_VERSION_VAR'$credits['base_version']);
    unset(
$credits);
?>


@Drizzurdeen: I hope you are fine with these changes.
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Getrix on October 18, 2009, 10:23:41 pm
Thanks for the translation. Added "file_version" to every lang_eqdkp.*.php so ppl know if they have newest release. Going to count up everytime new file is uploaded. "base_version" is just to sync lang_eqdkp.en.php (default) with translations. This version changes everytime a new string is added.

About the order stuff, will check what could cause that asap.

Im no more sick, so going back to normal life with work tomorrow. Will still make this module more rocking in the future, but not in same speed as latly :P
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Drizzurdeen on October 18, 2009, 11:00:11 pm
Quote
Im no more sick, so going back to normal life with work tomorrow.
NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO rl sucks ;) ... u have to code ;) ...

back to topic ;)
the sort porbs i only have on the raids where i have changed the dristibution between non and class ... this was only by the first 2 raids ... every other raid would be shown correctly ...

German:
ich habe das prob lediglich bei den ersten beiden raids wo ich in der nachträglichen änderungen der raids von keiner einteilung auf klassenverteilung gegangen bin um das modul zu testen ... also ich habe die grund-raideinstellungen auf "keine-verteilung" gestellt und danach wieder auf "klassenverteilung" daher kam es warscheinlich in der datenbank zu wirrwar und daher zeigt das modul die kalssenverteilung noch falsch an ...

alle anderen raids die in der raideinstellung des raids auf klassenverteilung und auch in der raidplanereinstellung auf klassenverteilung stehen werden korrekt angezeigt ..

back to englisch ;)
yes i'm fine withe the changes
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: xlDanek on October 18, 2009, 11:48:16 pm
Ah ok, this is the problem you guys discussed already some pages earlier ;)

All of my created raids are marked as "no distribution", so that is the problem.

But before I change the raids, I will wait if Getrix finds a way to fix this :D
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Drizzurdeen on October 19, 2009, 08:50:48 am
Quote
But before I change the raids, I will wait if Getrix finds a way to fix this

u don't have to wait ;) it works fine ... u just don't have to change the distribution while den module is running ;) this would make the ui crazy ;)
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Getrix on October 19, 2009, 09:16:01 am
Yeah, looks like the problem is if you choice "Role Distribution" and then change to "No/Class Distrubition".
Looks like EQDKP still leaves some dirt in DB when doing that so have to rewrite the order function abit.

Changing raids just because script have a bug isnt a good way to do it :P
Just report bugs if you found any ;)
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Drizzurdeen on October 19, 2009, 10:24:10 am
the easiest way is to change all distributions on class-distribution ;) this would give u a nice view in the ui of the module
Title: Re: EQDKP - ingame query module (v2.0.0)
Post by: Getrix on October 19, 2009, 11:40:33 am
It shouldnt be easy to code :P
There is so many different ways of doing stuff, and ppl will always find their way better then others.

That said, i will try to keep most ppl happy. Im looking into a fix, but not as much spare time this week as last one ;)
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Getrix on October 19, 2009, 02:52:33 pm
Quote
2009-10-19 - v2.0.1 - Fixed order bug in signup.

There it should work better. Give me feedback if not.

To later, everything is stored in a DB. So if the output doesnt look like it should, its probly a bug in the module and no point to workaround it with avoiding using settings in EQDKP webinterface. Just post a reply on where the problem is and add how you can produce it if you can.
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: xlDanek on October 19, 2009, 10:01:14 pm
Didn't work for me so far.

I get a

Code: [Select]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /custom/modules/EQDKP_Query.php on line 307

Warning and as result a

Code: [Select]
EQDKP ERROR: problem with code

after looking at the Detailed Raid View (after executing the "!dkp raid 55" command for example).

Edit:

Ok, i fixed it. It wasn't an error in your code. Now it works like hell! :D

The problem was the collations of the eqdkp tables. I catched the SQL statement which you create from line 295 until 304 and execute it in phpMyAdmin.

Code: [Select]
SELECT ra.attendees_subscribed, ra.member_id, ra.role, ra.attendees_note, m.member_name, m.member_id, m.member_class_id, c.class_name, ro.role_id, ro.role_name
FROM eqdkp_raidplan_raid_attendees AS ra
LEFT JOIN eqdkp_members AS m ON ra.member_id = m.member_id
LEFT JOIN eqdkp_classes AS c ON m.member_class_id = c.class_id
LEFT JOIN eqdkp_roles AS ro ON ra.role = ro.role_image
WHERE ra.raid_id = '55'
ORDER BY ra.attendees_signup_time

I got the following error:

Code: [Select]
#1267 - Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

Under Administration Panel -> Raidplaner Settings -> Expert Settings it is possible to "check" the collation of the raidplaner plugin tables. These had the collation "latin1_german1_ci" and all the other EQDKP db tables had the collation "latin1_swedish_ci".

Because you compare in two of your LEFT JOINs (LEFT JOIN eqdkp_members AS m ON ra.member_id = m.member_id and LEFT JOIN eqdkp_roles AS ro ON ra.role = ro.role_image) the raidplaners' and the EQDKPs' tables, MySQL throws an error.

But as a summery, I fixed it as described above and your module works great!! Thanks again for your work!
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Azraille on October 28, 2009, 01:22:58 pm
Code: [Select]
Warning: mysql_connect(): Can't connect to MySQL server on 'xx.xxx.xx.xxx' (4) in /home/xxxxxx/xxxxxx/custom/modules/DKP.php on line 566
DKP Error: Cant connect to database<br>DKP Error: Cant select database<br>
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/xxxxxx/custom/modules/DKP.php on line 116

Can't get it to work. The Eqdkp-plus installation is located in another webserver than the bot, so I'm trying to connect to the servers IP address with username and password.

What am I doing wrong?
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Getrix on October 28, 2009, 01:32:20 pm
As the error messages says, you cant connect to your remote MySQL server.

Could be the host is blocking for for remote MySQL access in firewall or not allowing it on MySQL server.
Check with your host..
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Poonjab on October 28, 2009, 10:44:18 pm
As the error messages says, you cant connect to your remote MySQL server.

Could be the host is blocking for for remote MySQL access in firewall or not allowing it on MySQL server.
Check with your host..

Also, if my knowledge of MySQL is not too outdated, the particular DB you are connecting to remotely has to allow for a connection from a remote host.
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Azraille on October 29, 2009, 10:39:54 am
Fixed it, turned out to be some mixups on MySQL users!

Works like a charm now!  ;D

Are you planning to add more commands/functions? Like an in-game signing feature and direct adjustments from game?
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Getrix on October 29, 2009, 11:45:21 am
Yes, there are alot of plans :P
But i also need the time..
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Drizzurdeen on October 29, 2009, 12:47:08 pm
u have to get ill again ;) @ getrix ...
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: almas on November 12, 2009, 02:03:16 am
I have a problem with the language file. everytime I try to start the bot I get this message:

Warning: Unexpected character in input: ´\´ (ASCII=92) state=1 in C:\BeBot\extra\language\lang_eqdkp.en.php on line 2

Parse error: syntax error, unexpected T_STRING in C:\BeBot\extra\language\lang_eqdkp.en.php on line 2

I have just downloaded the english language file. Hope that someone can help me.
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Getrix on November 12, 2009, 06:59:33 am
You downloaded the file? There is non option to download the .phps file i have linked to. You need to copy paste all text into a new file. This because if you download there will be alot more text following the file thats used to colorize the code for viewing.
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: almas on November 12, 2009, 10:19:01 am
I did copy paste all text.  so I cant understand why it dont work. Made a file in C:\BeBot\extra\language named it lang_eqdkp.en.php
If I dont use the language file. I get the dkp plugin to work, but then all the text is wrong.
This is what I have:

<?php
 $credits = array();
 $credits['language']       =   "English";
 $credits['translater']     =   "Getrix";
 $credits['date']           =   "2009-10-18";
 $credits['file_version']   =   "3";
 $credits['base_version']   =   "3";

    define('LANG_HELP_DESCRIPTION', 'With this module you can query EQDKP Plus ingame.');
    define('LANG_HELP_COMMAND_NICK', 'Request DKP for <nick>');
    define('LANG_HELP_COMMAND_CLASS', 'Request DKP for <class>');
    define('LANG_HELP_COMMAND_ONLINE', 'Request DKP for online players ([class] is optional)');
    define('LANG_HELP_COMMAND_RAID', 'Shows upcomming raids and details if [raid_id] as optional is set');
    define('LANG_HELP_COMMAND_DEBUG', 'Show info to be used in debugging.');
   
    define('LANG_SETTINGS_DBHOST', 'Database host');
    define('LANG_SETTINGS_DBUSER', 'Database username');
    define('LANG_SETTINGS_DBNAME', 'Database name');
    define('LANG_SETTINGS_DBPASS', 'Database password');
    define('LANG_SETTINGS_DBPREF', 'Database table prefix');
    define('LANG_SETTINGS_TIMEOFFSET', 'Time offset sync between bot and mysql clock.');
    define('LANG_SETTINGS_LANGUAGE', 'Language on text. Restart required to take effect.');
   
    define('LANG_ERROR_UKNOWN', 'EQDKP recieved unknown command');
    define('LANG_ERROR_NO_RESULT', 'No result');
    define('LANG_ERROR_FIND_RAID', 'Cant find the raid with that ID');
    define('LANG_ERROR_NO_UP_RAID', 'No upcomming raids');
    define('LANG_ERROR_NOTE', 'Did not find any notes.');
   
    define('LANG_NICK', 'Nick');
    define('LANG_RANK', 'Rank');
    define('LANG_POINTS', 'Points');
    define('LANG_LAST_RAID', 'Last raid');
    define('LANG_RAIDCOUNT', 'Raidcount');
    define('LANG_CLASS', 'Class');
    define('LANG_EARNED', 'Earned');
    define('LANG_SPENT', 'Spent');
    define('LANG_ADJUSTMENT', 'Adjustment');
    define('LANG_CURRENT', 'Current');
    define('LANG_LAST', 'Last');
    define('LANG_RAID_INFO', 'Raid info');
   
    define('LANG_HEAD_OVERVIEW', 'DKP overview for');
    define('LANG_HEAD_RAIDINFO', 'Raidinfo for');
    define('LANG_HEAD_SIGNUP_LIST', 'Signup list');
   
    define('LANG_HISTORY_ITEM_BUY', 'Item Purchase History');
    define('LANG_HISTORY_RAID_ATT', 'Raid Attendence History');
    define('LANG_HISTORY_INDIV_ADJ', 'Individual Adjustment History');
   
    define('LANG_RESULT_ON_CLASS', 'Result for online class');
    define('LANG_RESULT_ON_PLAYERS', 'Result for online players');
    define('LANG_RESULT_PLAYER', 'Overview for');
    define('LANG_RESULT_OVERVIEW_FOR', 'Result overview for');
   
    define('LANG_INVITE_TIME', 'Invite time');
    define('LANG_START_TIME', 'Start time');
    define('LANG_SIGNUP_TIME', 'Signup time');
    define('LANG_FINISH_TIME', 'Finish time');
    define('LANG_CONFIRMED', 'Confirmed');
    define('LANG_SIGNED', 'Signed');
    define('LANG_UNSIGNED', 'Unsigned');
    define('LANG_NOT_SURE', 'Not sure');
    define('LANG_TOTAL', 'Total');
    define('LANG_RAIDLEADER', 'Raid Leader');
    define('LANG_NOTE', 'Note');
    define('LANG_VALUE', 'Value');
    define('LANG_RAID', 'Raid');
    define('LANG_GROUP', 'Group');
    define('LANG_INVITE', 'Invite');
    define('LANG_RAID_ID', 'Raid ID');
    define('LANG_MORE_INFO', 'More Info');
    define('LANG_UPCOMMING_RAIDS', 'Upcomming raids');
   
    define('LANG_CREDITS_LANGUAGE', 'Language');
    define('LANG_CREDITS_LANGUAGE_VAR', $credits['language']);
    define('LANG_CREDITS_TRANSLATER', 'Translater');
    define('LANG_CREDITS_TRANSLATER_VAR', $credits['translater']);
    define('LANG_CREDITS_DATE', 'Date');
    define('LANG_CREDITS_DATE_VAR', $credits['date']);
    define('LANG_CREDITS_BASE_VERSION', 'Base Version');
    define('LANG_CREDITS_BASE_VERSION_VAR', $credits['base_version']);
    unset($credits);
?>
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Getrix on November 12, 2009, 10:33:24 pm
Try downloading this file (Right click, safe file)

http://dump.sjef.biz/aoc/bebot/EQDKP_Query/lang_eqdkp.en.phps.txt

And then change the name to lang_eqdkp.en.php

If that doesnt solve, change first line from "<?php" to "<?"
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: almas on November 13, 2009, 08:30:18 pm
That worked fine. Thanks alot. My guild love this module
Title: Re: EQDKP - ingame query module (v2.0.1)
Post by: Getrix on November 13, 2009, 09:21:29 pm
What solved your problem?

Downloading the .txt and rename or the changing of "<?php" to "<?"

Good to know for later debugging.
Title: Re: EQDKP - ingame query module (v2.0.3)
Post by: Getrix on November 13, 2009, 09:55:31 pm
Quote
2009-11-13 - v2.0.3 - Fixed bug when there wasnt any signed for a raid.
2009-10-19 - v2.0.2 - Fixed order bug. Minor change in DB function
Title: Re: EQDKP - ingame query module (v2.0.3)
Post by: almas on November 14, 2009, 12:34:34 am
downloading the txt file solved my problem
Title: Re: EQDKP - ingame query module (v2.0.3)
Post by: Getrix on November 14, 2009, 01:04:09 am
So, i have been in touch with the man behind RaidPlanner (and some in EQDKP dev) and he tells me he is working on a new version (v5) that will change alot.
And EQDKP will also get alot of changes in v7, so before this is released i dont see point in wasting too much more time on it ... :S
Title: Re: EQDKP - ingame query module (v2.0.3)
Post by: almas on November 17, 2009, 09:16:27 pm
Is it posible to change the time_offset between the bot and sql server with more than -12 hours?
Title: Re: EQDKP - ingame query module (v2.0.3)
Post by: Runemy on November 17, 2009, 09:45:37 pm
Just throwing in a big thanks for the work done here Getrix. This has quickly become one of the most used features of the bot in our guild and the guys are loving it! :)
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on November 18, 2009, 04:22:10 pm
Quote
2009-11-18 - v3.0.3 - Added first writing to EQDKP function, raid signup ingame. !!NOTE: Use on own risk!!

If you dont want to risk anything, keep to 2.x releases as it will not write to your DB, only reads from it. Links in first post.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: xlDanek on November 18, 2009, 04:34:16 pm
Found a copy & paste failure ;)

Both [Download latest stable]-Links are pointing at the v2 of your really great module :)

Workaround until Getrix has fixed it: Turn the "/v2/" in the link into "/v3/"

Edit:

For the german language file:

Code: [Select]
    define('LANG_SIGN_SUCCESS', 'Erfolgreich für den Raid angemeldet');
    define('LANG_SIGN_CHECK_CONFIRM', 'Bitte schau später nochmal nach ob du bestätigt worden bist');
    define('LANG_SIGN_ALLREADY_SIGNED', 'Schon für den Raid angemeldet');
    define('LANG_SIGN_RAID_NOTFOUND', 'Raid nicht gefunden');
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on November 18, 2009, 04:49:35 pm
Thanks xlDanek.

Also need translation for:

Quote
define('LANG_ERROR_ROLE_NOT_EXIST', 'ERROR: The role doesnt exist');
    define('LANG_ERROR_RAID_NOT_FOUND', 'Raid not found');
    define('LANG_ERROR_CHAR_NOT_FOUND', 'Did not find any character by name:');
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: xlDanek on November 18, 2009, 06:41:15 pm
Oh sorry, didn't see that  :D

Here it is:

Code: [Select]
define('LANG_ERROR_ROLE_NOT_EXIST', 'FEHLER: Diese Rolle existiert nicht');
define('LANG_ERROR_RAID_NOT_FOUND', 'Raid nicht gefunden');
define('LANG_ERROR_CHAR_NOT_FOUND', 'Es wurde kein Charakter mit diesem Namen gefunden:');
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Drizzurdeen on December 18, 2009, 10:52:05 pm
getrix my hero ... v3 works more than perfekt ;)

another sugestion ;) ... would it be possible to undo signup by raid ... etc. just change the status ?
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Margon on December 24, 2009, 03:55:25 pm
multi-dkp support would be fine!

Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Drizzurdeen on December 24, 2009, 04:18:08 pm
hmmmm jo ... this would be fine ;)

*bump*  :-X
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on December 24, 2009, 04:23:32 pm
Adding to much more functions towards EQDKP-Plus 0.6.x.x is waste of time as 0.7 should be out in few months.
Im been told that 0.7 will be alot easier to code against, but is also total rewritten from 0.6 so everything writtin against 0.6 will be broken..
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Drizzurdeen on December 24, 2009, 04:29:08 pm
hmmm kk than we have to wait ... so getrix merry X-Mas ;)  ;D
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: BoA-Gert on December 30, 2009, 08:55:54 pm
Nice module :)

Made a little tweak - change line 378 to:

Code: [Select]
          $member_html                  = "<font color=".$color.">".$ar['class_name']." - [<a href='chatcmd:///tell ".$this -> bot -> botname." !yg ".$member_name."'>".$member_name."</a>] </font>";
and it'll make the names of those listed YG profile links (as long as you have the !yg module and access ;)) - find it handy esp when having multi-guild raids...
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Krica on March 22, 2010, 09:18:25 pm
!set EQdkp DB_host <host> // Default localhost
!set EQdkp DB_user <username> // Default eqdkp
!set EQdkp DB_pass <password>
!set EQdkp DB_name <databasename> // Default eqdkp_plus
!set EQdkp DB_pref <tableprefix> // Default eqdkp_ (Remember underscore if you have that)
!set EQdkp // To se more settings

guys where can i get that data?
i am admin of our dkp,but cant find that informations
thanks
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Drizzurdeen on March 23, 2010, 05:56:53 pm
log on ur host via ftp ... go into the dkp directory ... have a look on the configuration.php or config.php there must be alle the informations u need

hope i could help u
greez da drizz
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Drizzurdeen on March 27, 2010, 11:47:20 am
here just an answer

would it be possible to make funktion where the member, how have leader-access to the bot, are able to confirm the announced memeber in the raid just with one klick and mybee add the notes like "pleas with conq"
would it bee either possible to geht the "invite to group/invite to raid" link by all the confirmed member an not only by the members of the bot ... i ask because we have a raid-community with 4 guilds ... an i only kan invite the members of my own guild cause thei are member of my bot ... the members of the other guild i could not invite over th eqdkp interface ... would be charming if this could work ;)

greez da drizz
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Krica on March 27, 2010, 06:45:10 pm
Quote
log on ur host via ftp ... go into the dkp directory ... have a look on the configuration.php or config.php there must be alle the informations u need

hope i could help u
greez da drizz

our guild using EQDKP version 1.3.2 on dkp4guilds.com host
i am not owner of that sites,but i have admin rights,its any chance to get it works for me?
thank u all guys
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on March 27, 2010, 08:09:37 pm
@Krica: No, i dont think that would be possible as dkp4guilds.com probly use their own DB and do not accept ppl to login directly to it.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Cuval on March 28, 2010, 08:38:09 am
He should ask them and in that question ask specificly if he can get a 'remote login for his eqdkp database'. If you recieve the MySQL database login settings, and are allowed to login remotely, you'll be fine.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Drizzurdeen on March 28, 2010, 11:49:32 am
Quote
our guild using EQDKP version 1.3.2 on dkp4guilds.com host

uuuuuuuuuuuuuuuh why u've done this ;)
if u would our guild could host for u the eqdkpplus incl. the bot ... then u have the informations u ned ;) ... or u contact ur hoster ... maybe he'll give u the informations u need ;)
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: freakyfreak on June 03, 2010, 06:52:53 pm
Hi Community,

Sinc the Update my Bot disconnect and restart after following command !dkp raid

here is the failure protocol. Maybe you can help me.
izuki [SETTINGS]      [LOAD]  Loaded settings from database.
Shizuki [ROSTER]        [UPDATE]        Roster update ran less than 6 hours ago, skipping!
Shizuki [VERSION]       [UPDATE]        Version check ran less than 23 hours ago, skipping!
Shizuki [GROUP] [MSG]   [Mistral] Yuomii: !dkp raid
Read error: EOF

Warning: unpack(): Type N: not enough input, need 4, have 0 in /home/aocbot/Sources/AOChat.php on line 1843

Warning: array_pop(): The argument should be an array in /home/aocbot/Sources/AOChat.php on line 1844

Warning: unpack(): Type n: not enough input, need 2, have 0 in /home/aocbot/Sources/AOChat.php on line 1855

Warning: array_pop(): The argument should be an array in /home/aocbot/Sources/AOChat.php on line 1856

Warning: unpack(): Type n: not enough input, need 2, have 0 in /home/aocbot/Sources/AOChat.php on line 1855

Warning: array_pop(): The argument should be an array in /home/aocbot/Sources/AOChat.php on line 1856
Read error: EOF
Shizuki [SETTINGS]      [SAVED] connected for module irc set to FALSE as datatype bool
Shizuki [CONN]  [ERROR] Bot has disconnected. Reconnecting in 60 seconds.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Runemy on June 11, 2010, 03:24:12 pm
I'm running into a new problem here as my guild grows in numbers. When we have more than 30 (Something) online and do a !dkp online or if I do a !dkp class of a class that has many players so that it requires two pages to be loaded only the second page gets loaded for view.

Any known workarounds for this? I take it it's in regard to the blob size, but still.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Kyr on June 11, 2010, 08:18:05 pm
You are right, crank the blob size down and restart the bot.  I have mine set to 6k.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Runemy on June 14, 2010, 11:43:34 pm
hmm.. changing the blob size to 6k didn't make any difference at all. I'm still having only (page 2 of 2) as a result when having more than 30ish members online.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Khalem on June 15, 2010, 04:00:35 pm
Make sure you have changed the blob size for AoC, not AO.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: rmb on June 15, 2010, 06:27:58 pm
How do you "change the blob size"?
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Kyr on June 16, 2010, 01:39:01 pm
Open this file in your text editor:
Code: [Select]
\BeBot\conf\Bot.conf
Scroll down to this:
Code: [Select]
  if(is_numeric($dimension))
$max_blobsize = 12000;            // Maximum size of text blobs in byte. For AO
  else
$max_blobsize = 8000;            // Maximum size of text blobs in byte. For AoC

Change the line after else to read:
Code: [Select]
$max_blobsize = 6000;
I recently had to decrease mine to 5500, seems that once you get over 50 people online in the guild channel 6000 is too high.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Khalem on June 17, 2010, 01:41:14 pm
It seems AoC has some form of dynamic limits to the number of bytes it allows messages to be.

I'll decrease the default in the next release in any case.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Kyr on June 18, 2010, 04:27:02 am
Does the bot have knowledge of how many people are in the channel?  If so, can it use a dynamic blob size based on the number of people online?

From my observation:
Under 40 the default of 8000 worked fine
around 40-42 the limit of 6000 worked
Over 50 I had to put it down to 5500

~Kyr
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Huesos on January 27, 2011, 11:40:34 pm
!dkp raid

result answer: no upcoming raids, and have the raid planner module

never mind I don't eqdkp on a site or whatever....
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Cuval on March 22, 2011, 11:13:33 am
EQdkp Plus just entered the 2nd alpha test phase for their new version. However they think it will take a while to go live. Let's hope they hurry, because it looks like an awesome upgrade.

http://www.eqdkp-plus.com/news.php (http://www.eqdkp-plus.com/news.php)
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Runemy on March 22, 2011, 01:01:57 pm
As long as the current one works I don't care as I don't think Getrix will do a new version of this mod based on the new one (crossing fingers though), and I'm dead dependant on this mod in my guild  ^^
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on March 22, 2011, 02:36:54 pm
As im been told, new version will be totaly rewritten with new core code.
It will be easier to start from scratch and make new module against it i believe.
They said it would be easier to make such modules as they are adding a API to connect to EQDKP.
Not sure if i have time or will do a upgrade, atleast i want do it before its stable released.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Nwardezir on April 15, 2011, 03:31:25 pm
Hello,

First, thanks for this nice module :)
However, I run into a problem and I think we could be several to have this issue.

My EQDKP is hosted on a server where I don't have total control, I'm just paying for hosting, but several features are locked.
For instance, it's pretty common you can't access, connect and send requests to a database from anywhere else than your server.

I was thinking ... would it be possible, easily, to make some sort of php gateway/proxy that you copy on the same server than your DB and that will manage communication ?
Thus, module will call on this php, gateway will execute stuff, get response, and transfer it back to bebot module.

Dunno if I'm clear explaining this, but I think we could be plenty, stuck in the same situation.

Thanks :)
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on April 15, 2011, 06:31:53 pm
Yes it would be possible. But you need to rewrite alot for it to work... I dont have time or intereste of doing it :P
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on April 15, 2011, 10:55:11 pm
Forgot i have made some small changes ages ago but didnt release it.

Quote
* v3.0.4 - 2011-04-15:
*    + Add if in same instance, dont show raidinv. Player are then in raid.   
*    + Fixed raid_note with html chars.
*    + Added rank on get_list. Changed colorcodes, using gmod_(getrix module) in !color gmod
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: MysterF on May 20, 2011, 01:29:27 am
HI

I recently added to EQDKP system, the MAIN CHAR name, for every guild member, I have done that by adding in brackets the name of the main. Example Bebot (EQDKP).

After I have done that the ingame EQDKP query does not return any result which contains "()" in name.

It was a rather pain process of editing 250 names, I hope  there is a workaround to it. -)

Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on May 20, 2011, 02:48:03 pm
You need to edit the query for nick then. To be: $nick." (EQDKP)" before quering to SQL..
I will not make any official workaround for this, you will need to do it on your own..
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: MysterF on May 20, 2011, 03:51:18 pm
ty, for the hint, will look into it, anything beats the  250 ppl editing :p

so it is the $nick and not $name that I need to edit.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on May 20, 2011, 05:57:59 pm
Dont remember the correct $string for it. But you would also need a "if" state as some names in your EQDKP are just name without your mod?..
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: MysterF on May 20, 2011, 07:25:04 pm
yes, you are correct, the main chars wont have anything in () next to their name.

I assume  this is the bit where I need to alter:

 
Code: [Select]
     function command_handler($name, $msg, $origin)
    {
        /*
            Unified message handler
            $source: The originating player
            $msg: The actual message, including command prefix and all
            $type: The channel the message arrived from. This can be either "tell", "pgmsg" or "gc"
        */
        $com = $this->parse_com($msg);
        switch($com['com'])
        {
            case 'dkp':
                return($this -> sub_handler($name, $com, 1));
            break;
            default:
                $this->error->set(LANG_ERROR_UKNOWN." '{$com['com']}'.");
                return($this->error);
            break;
        }
    }
   
    function sub_handler($name, $com, $type)
    {
        switch($com['sub'])
        {
            case 'nick':
                return($this -> nick($com['args']));
            break;
            case 'class':
                return($this -> get_list($com['args']));
            break;
            case 'raid':
                return($this -> raid($com['args'], $name));
            break;
            case 'online':
                return($this -> get_list($com['args'], TRUE));
            break;
            case 'debug':
                return($this -> debug());
            break;
            default:
                return($this -> nick($name));
            break;
        }
    }
   
    function nick($name) {
        $name = ucfirst(strtolower($name));
        $eqdkp  = LANG_RESULT_PLAYER.": $name";


Mainly this bit?

Code: [Select]
   $name = ucfirst(strtolower($name));
        $eqdkp  = LANG_RESULT_PLAYER.": $name";
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on May 21, 2011, 10:25:21 am
No, thats only display it back.

$select   .= "WHERE m.member_name = '$name' "; etc..

But it will be more then that you need to modify.. There isnt a better way for you to tag ppl in EQDKP then this?..
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: MysterF on May 21, 2011, 04:28:52 pm
No, thats only display it back.

$select   .= "WHERE m.member_name = '$name' "; etc..

But it will be more then that you need to modify.. There isnt a better way for you to tag ppl in EQDKP then this?..

The DKP  system is independent from our website for security reasons and we don't allow players to register there, if we would, we could have used the char manager module that EQDKP has build-in.

I tried a different set of brackets, {} [] same result. I i will keep playing  until I find a set of chars that wont interfere with the DKP bebot query module.

I  just wish I had the  inspiration of testing the compatibility with the bebot module,  after the 1st  name edit and not after 250.  :'(
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on May 21, 2011, 05:33:52 pm
Tbh i dont understand your setup...
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: MysterF on May 21, 2011, 07:30:00 pm
Tbh i dont understand your setup...

Fortunately I do -)

The issue is not with the parsing but with the  attribution of name,  if I edit the nick to say  Bebot ( EQDKP) in stead of a player called bebot, ofc the ingame query wont associate the char name with the DKP.

On a quick test of the theory I queried the bot  to !dkp nick Bebot (EQDKP) in stead of !DKP or ! dkp online, and it did return a result, so it was not a parse issue caused by invalid characters.

Entirely  my fault and I need to find a better alias method,  without changing the EQDKP member name.

Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on May 22, 2011, 03:13:11 pm
If you find another way of giving EQDKP user/chars alias you can easly remove "(EQDKP)" from the name with just couple php lines..

Quick out of my head now:

Code: [Select]
$sql = mysql_query("SELECT name,id FROM eqdkp_users WHERE names LIKE '%(EQDKP)%'")
while ($ar = mysql_fetch_array($sql)) {
  $name = str_replace(" (EQDKP)", "", $ar['names']);
  $id = $ar['id'];
  mysql_query("UPDATE eqdkp_users SET name='$name' WHERE id='$id'")
}
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: dillinger on September 23, 2011, 12:04:57 am
Hi folks

I was trying to get this module to work on our guild bot.

I get this error msg at the bot console:

Code: [Select]
Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10060) in C:\xampp\php\custom\modules\EQDKP_Query.php on line 578
DKP Error: Cant connect to database DKP Error: Cant select database
Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in C:\xampp\php\custom\modules\EQDKP_Query.php on line 116

I think the problem is 'localhost' since I'm running the EQDKP sytem on a different webserver.

Is it possible to connect the Bot Module to a different server through the web?

Thanks for your feedback guys!

dill
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: BoA-Gert on September 23, 2011, 01:03:06 pm
Hi folks

I was trying to get this module to work on our guild bot.

I get this error msg at the bot console:

Code: [Select]
Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10060) in C:\xampp\php\custom\modules\EQDKP_Query.php on line 578
DKP Error: Cant connect to database DKP Error: Cant select database
Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in C:\xampp\php\custom\modules\EQDKP_Query.php on line 116

I think the problem is 'localhost' since I'm running the EQDKP sytem on a different webserver.

Is it possible to connect the Bot Module to a different server through the web?

Thanks for your feedback guys!

dill

Yes it is - I have my bot on a local PC accessing the EQDKP on a remote server.  You need to make sure the remote server allows remote connections (if the host allows for them)...this will depend on how your remote server is hosted/setup; I also setup a unique login for the bot so it has reduced access...
Title: Q
Post by: dillinger on September 23, 2011, 02:37:15 pm
Thanx for your reply BoA-Gert!

So then I have to figure out the remote hosts configuration first, right? Once I've got these informations I can enter the IP address of the remote host?

You created a unique mySQL login on the remote host?

And last question, do I have to modify the EQDKP Module Code to get this thing to work?

Regards, dill
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Drizzurden on September 23, 2011, 09:27:11 pm
jebb it's possible but a very bad way ;) ... there is a reason why u should have all aplications which the mysql db are using on the same mashine where the mysql server is ;) .... it's a security question ... u have to open ur server on the sql port so the bot is able to communicate with the eqdkp db

cheers
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: dillinger on October 06, 2011, 12:05:48 pm
Guys I get a funny WARNING Message:

Quote
Bot [TELL]    [INC]   Cubixx: !dkp class dt
Warning: mysql_connect(): Host 'vhost012' is not allowed to connect to this MySQL server in C:\xampp\php\custom\modules\EQDKP_Query.php on line 578
DKP Error: Cant connect to database<br>Bot [TELL]     [OUT]   -> Cubixx: [link]Ergebnisübersicht für Dark Templar[/link]

As you can see the bot will drop a correct output ^^ But what is going on with this strange Warning message? I'm a bit confused.

Any ideas?

Greets, dill
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: dillinger on October 06, 2011, 02:45:52 pm
Another question:

In our EQdkp planer we're using "multidkp" (eqdkp1a/listmembers.php?s=&filter=none&multifilter=2 & eqdkp1a/listmembers.php?s=&filter=none&multifilter=4) fist one is T3.5 roster and second one is T4 roster - all in the same planer. Is there an option to select the output between these two filters?

For example in !dkp overview script you can see how many DKP you got in multidkp list 1 and also in multidkp list 2.

It should look like this:

Code: [Select]
Points:
Earned (Multidkp List 1): 1910.00
Earned (Multidkp List 2): 3420.00
Spent (Multidkp List 1): 375.00
Spent (Multidkp List 2): 550.00
Adjustment (Multidkp List 1): 2575.00
Adjustment (Multidkp List 2): 3456.00
Current (Multidkp List 1): 2340
Current (Multidkp List 2): 3980

That would be AWESOME!

dill
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: dillinger on October 12, 2011, 02:17:59 pm
*push*
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: dillinger on October 16, 2011, 09:10:52 pm
*push*
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: dillinger on November 02, 2011, 12:16:22 pm
*push*

I'll drop a donation on the one who provide me some details or updated code.
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: Getrix on November 22, 2011, 12:13:46 pm
Sorry, my freetime isnt for sale:P
And allready got a well paid job;)

PS: Reason i dont reply in PM is that there is other ppl that also can reply if you make a topic. Also questions are asked several times over and over again..
You asked if there was someone other that could do it too. My lack of reply was a silent "no"...
Title: Re: EQDKP - ingame query module (v3.0.3)
Post by: dillinger on November 23, 2011, 10:37:15 am
Now THIS is an answer :) Thanx Getrix.
SimplePortal 2.3.7 © 2008-2024, SimplePortal