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
-
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 ;)
-
Release History
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
!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
!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
-
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.
-
nice plugin.
but there is a little bug.
!dkp class <a class with space>
doesnt work
like "Tempest of Set"
-
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
-
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...
-
an when u will get a test eqdkp including sql access and a testbot ???
-
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.
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 ;
-
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 ;)
-
hahaha, here's me hoping you'll stay sick a while ^^
-
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?)
-
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.
-
Awesome job Getrix.
Thanks for picking up and running with this. (God bedring)
-
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
-
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...
-
yes raidplaner is a plugin.
a nice feature would be: a command that show the dkp of all ONLINE-members categorized by there class
-
2009-10-15 - v1.3 - Added !dkp online [class] command ([class] is optional)
-
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
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?? ^^)
-
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
-
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
-
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
-
Hehe, he's already working on it I think :)
-
can't wait any longer for it ;) go getrix go ;)
-
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
-
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.
-
how i get the raid-id ???
do i have a look at the db ?
edit: kk !dkp raid ... works
-
!dkp raid 375
[BeBot]: EQDKP ERROR: problem with code
looks like a problem
-
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 ?
-
Works 100% on my end, we can view all raids and all signs show.
-
here same prob
Systalia [TELL] [INC] Necdrizz: !dkp raid 49
Systalia [TELL] [OUT] -> Necdrizz: EQDKP ERROR: problem with code
-
Works 100% on my end, we can view all raids and all signs show.
what eqdkp version do you use?
-
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 ???
-
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
-
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)
-
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...
-
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
-
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)
-
our raids are set to "no distribution"
when i use "role distribution" it works
can you fix it please?
Getrix 4 president ! :)
-
narf ... so i have to define roles ??? like tank dd heal and so on ???
-
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 ;)
-
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.
-
when u create a raid u can decide if it should be with class- , roll- or non-distribution
-
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)
-
Thanks for good debugging ;)
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.
-
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)
-
2009-10-16 - v1.9 - Fixed bug in RaidDetails with Raid/Group invite not showing up. Bad coding by me:(
-
added the german short-names ... some of them are quite funny couse sometimes the englisch and german short-names are same ... but it works ;)
// 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"
);
-
getrix u are my hero ... soooooooooooo perfekt work ... best modul ever ... ;) *PARTY*
-
Thanks Drizzurdeen. Added that to the code and will be in next update.
-
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
-
here is an german version of your script v1.11
http://www.illuminati-aoc.com/eqdkp_ger.php
-
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 ;)
-
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 ;)
-
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
-
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*
-
@ 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
-
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*
-
here the translation ...
the first code ist the english ... than the german ... hope i helps
<?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');
?>
-
Topic Start (http://bebot.link/generic-custom-modules/eqdkp-ingame-query-module/)
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)
-
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');
-
Thanks, added to lang_eqdkp.de.php (http://dump.sjef.biz/aoc/bebot/EQDKP_Query/lang_eqdkp.de.phps)
-
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 ;)
-
aaaaaaaaaaaaaaah kk works perfekt ... forgot to add the lang_eqdkp.de.php in the folder language ;)
nasty drizz ;)
-
changed some small bugs ...
<?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);
?>
-
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):
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:
<?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.
-
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
-
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
-
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
-
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 ;)
-
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 ;)
-
the easiest way is to change all distributions on class-distribution ;) this would give u a nice view in the ui of the module
-
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 ;)
-
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.
-
Didn't work for me so far.
I get a
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
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.
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:
#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!
-
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?
-
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..
-
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.
-
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?
-
Yes, there are alot of plans :P
But i also need the time..
-
u have to get ill again ;) @ getrix ...
-
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.
-
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.
-
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);
?>
-
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 "<?"
-
That worked fine. Thanks alot. My guild love this module
-
What solved your problem?
Downloading the .txt and rename or the changing of "<?php" to "<?"
Good to know for later debugging.
-
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
-
downloading the txt file solved my problem
-
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
-
Is it posible to change the time_offset between the bot and sql server with more than -12 hours?
-
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! :)
-
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.
-
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:
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');
-
Thanks xlDanek.
Also need translation for:
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:');
-
Oh sorry, didn't see that :D
Here it is:
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:');
-
getrix my hero ... v3 works more than perfekt ;)
another sugestion ;) ... would it be possible to undo signup by raid ... etc. just change the status ?
-
multi-dkp support would be fine!
-
hmmmm jo ... this would be fine ;)
*bump* :-X
-
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..
-
hmmm kk than we have to wait ... so getrix merry X-Mas ;) ;D
-
Nice module :)
Made a little tweak - change line 378 to:
$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...
-
!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
-
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
-
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
-
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
-
@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.
-
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.
-
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 ;)
-
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.
-
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.
-
You are right, crank the blob size down and restart the bot. I have mine set to 6k.
-
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.
-
Make sure you have changed the blob size for AoC, not AO.
-
How do you "change the blob size"?
-
Open this file in your text editor:
\BeBot\conf\Bot.conf
Scroll down to this:
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:$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.
-
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.
-
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
-
!dkp raid
result answer: no upcoming raids, and have the raid planner module
never mind I don't eqdkp on a site or whatever....
-
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)
-
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 ^^
-
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.
-
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 :)
-
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
-
Forgot i have made some small changes ages ago but didnt release it.
* 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
-
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. -)
-
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..
-
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.
-
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?..
-
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:
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?
$name = ucfirst(strtolower($name));
$eqdkp = LANG_RESULT_PLAYER.": $name";
-
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?..
-
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. :'(
-
Tbh i dont understand your setup...
-
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.
-
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:
$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'")
}
-
Hi folks
I was trying to get this module to work on our guild bot.
I get this error msg at the bot console:
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
-
Hi folks
I was trying to get this module to work on our guild bot.
I get this error msg at the bot console:
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...
-
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
-
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
-
Guys I get a funny WARNING Message:
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
-
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:
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
-
*push*
-
*push*
-
*push*
I'll drop a donation on the one who provide me some details or updated code.
-
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"...
-
Now THIS is an answer :) Thanx Getrix.