collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

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

0 Members and 2 Guests are viewing this topic.

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #75 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..
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline Poonjab

  • BeBot User
  • **
  • Posts: 59
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #76 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.

Offline Azraille

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #77 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?

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #78 on: October 29, 2009, 11:45:21 am »
Yes, there are alot of plans :P
But i also need the time..
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline Drizzurdeen

  • BeBot Apprentice
  • ***
  • Posts: 193
  • Karma: +0/-0
    • Obsidian-Cult
Re: EQDKP - ingame query module (v2.0.1)
« Reply #79 on: October 29, 2009, 12:47:08 pm »
u have to get ill again ;) @ getrix ...

Offline almas

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #80 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.

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #81 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.
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline almas

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #82 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);
?>
« Last Edit: November 12, 2009, 10:24:10 am by almas »

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #83 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 "<?"
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline almas

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #84 on: November 13, 2009, 08:30:18 pm »
That worked fine. Thanks alot. My guild love this module

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.1)
« Reply #85 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.
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.3)
« Reply #86 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
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline almas

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.3)
« Reply #87 on: November 14, 2009, 12:34:34 am »
downloading the txt file solved my problem

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.3)
« Reply #88 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
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline almas

  • BeBot Rookie
  • *
  • Posts: 11
  • Karma: +0/-0
Re: EQDKP - ingame query module (v2.0.3)
« Reply #89 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?

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 712
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal