Author Topic: EQDKP - ingame query module (v3.0.3) (Read 42899 times)

Getrix · « **Reply #60 on:** October 18, 2009, 05:01:09 pm »

Thanks, added to lang_eqdkp.de.php

Drizzurdeen · « **Reply #61 on:** October 18, 2009, 05:11:45 pm »

kk have now the latest release ... multilangual ... changed in setting on de but now this -.-

i've created the folde i should .../extra/language
i've restartet the bot ... but someting is wrong

Drizzurdeen · « **Reply #62 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

Drizzurdeen · « **Reply #63 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);
?>

xlDanek · « **Reply #64 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):

Quote from: Drizzurdeen on October 16, 2009, 10:21:18 pm

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

) 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.

Getrix · « **Reply #65 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

Drizzurdeen · « **Reply #66 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

xlDanek · « **Reply #67 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

Drizzurdeen · « **Reply #68 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

Getrix · « **Reply #69 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

Just report bugs if you found any

Drizzurdeen · « **Reply #70 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

Getrix · « **Reply #71 on:** October 19, 2009, 11:40:33 am »

It shouldnt be easy to code

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

Getrix · « **Reply #72 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.

xlDanek · « **Reply #73 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!

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!

Azraille · « **Reply #74 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?

Author Topic: EQDKP - ingame query module (v3.0.3) (Read 42899 times)

Getrix

Re: EQDKP - ingame query module (v2.0.0)

Drizzurdeen

Re: EQDKP - ingame query module (v2.0.0)

Drizzurdeen

Re: EQDKP - ingame query module (v2.0.0)

Drizzurdeen

Re: EQDKP - ingame query module (v2.0.0)

xlDanek

Re: EQDKP - ingame query module (v1.8)

Getrix

Re: EQDKP - ingame query module (v2.0.0)

Drizzurdeen

Re: EQDKP - ingame query module (v2.0.0)

xlDanek

Re: EQDKP - ingame query module (v2.0.0)

Drizzurdeen

Re: EQDKP - ingame query module (v2.0.0)

Getrix

Re: EQDKP - ingame query module (v2.0.0)

Drizzurdeen

Re: EQDKP - ingame query module (v2.0.0)

Getrix

Re: EQDKP - ingame query module (v2.0.0)

Getrix

Re: EQDKP - ingame query module (v2.0.1)

xlDanek

Re: EQDKP - ingame query module (v2.0.1)

Azraille

Re: EQDKP - ingame query module (v2.0.1)