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

0 Members and 2 Guests are viewing this topic.

Offline BoA-Gert

  • BeBot User
  • **
  • Posts: 45
  • Karma: +0/-0
Re: EQDKP - ingame query module (v3.0.3)
« Reply #135 on: September 23, 2011, 01:03:06 pm »
Hi folks

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

I get this error msg at the bot console:

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

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

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

Thanks for your feedback guys!

dill

Yes it is - I have my bot on a local PC accessing the EQDKP on a remote server.  You need to make sure the remote server allows remote connections (if the host allows for them)...this will depend on how your remote server is hosted/setup; I also setup a unique login for the bot so it has reduced access...

Offline dillinger

  • BeBot Apprentice
  • ***
  • Posts: 91
  • Karma: +0/-0
Q
« Reply #136 on: September 23, 2011, 02:37:15 pm »
Thanx for your reply BoA-Gert!

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

You created a unique mySQL login on the remote host?

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

Regards, dill

Offline Drizzurden

  • BeBot Rookie
  • *
  • Posts: 12
  • Karma: +0/-0
Re: EQDKP - ingame query module (v3.0.3)
« Reply #137 on: September 23, 2011, 09:27:11 pm »
jebb it's possible but a very bad way ;) ... there is a reason why u should have all aplications which the mysql db are using on the same mashine where the mysql server is ;) .... it's a security question ... u have to open ur server on the sql port so the bot is able to communicate with the eqdkp db

cheers

Offline dillinger

  • BeBot Apprentice
  • ***
  • Posts: 91
  • Karma: +0/-0
Re: EQDKP - ingame query module (v3.0.3)
« Reply #138 on: October 06, 2011, 12:05:48 pm »
Guys I get a funny WARNING Message:

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

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

Any ideas?

Greets, dill
« Last Edit: October 06, 2011, 05:06:15 pm by dillinger »

Offline dillinger

  • BeBot Apprentice
  • ***
  • Posts: 91
  • Karma: +0/-0
Re: EQDKP - ingame query module (v3.0.3)
« Reply #139 on: October 06, 2011, 02:45:52 pm »
Another question:

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

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

It should look like this:

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

That would be AWESOME!

dill
« Last Edit: October 06, 2011, 03:25:45 pm by dillinger »

Offline dillinger

  • BeBot Apprentice
  • ***
  • Posts: 91
  • Karma: +0/-0
Re: EQDKP - ingame query module (v3.0.3)
« Reply #140 on: October 12, 2011, 02:17:59 pm »
*push*

Offline dillinger

  • BeBot Apprentice
  • ***
  • Posts: 91
  • Karma: +0/-0
Re: EQDKP - ingame query module (v3.0.3)
« Reply #141 on: October 16, 2011, 09:10:52 pm »
*push*

Offline dillinger

  • BeBot Apprentice
  • ***
  • Posts: 91
  • Karma: +0/-0
Re: EQDKP - ingame query module (v3.0.3)
« Reply #142 on: November 02, 2011, 12:16:22 pm »
*push*

I'll drop a donation on the one who provide me some details or updated code.

Offline Getrix

  • Contributor
  • *******
  • Posts: 509
  • Karma: +0/-0
Re: EQDKP - ingame query module (v3.0.3)
« Reply #143 on: November 22, 2011, 12:13:46 pm »
Sorry, my freetime isnt for sale:P
And allready got a well paid job;)

PS: Reason i dont reply in PM is that there is other ppl that also can reply if you make a topic. Also questions are asked several times over and over again..
You asked if there was someone other that could do it too. My lack of reply was a silent "no"...
« Last Edit: November 22, 2011, 12:16:59 pm by Getrix »
Success is not final, failure is not fatal: it is the courage to continue that counts.
- Sorry, i dont have time to reply question on PM. Make a topic.

Offline dillinger

  • BeBot Apprentice
  • ***
  • Posts: 91
  • Karma: +0/-0
Re: EQDKP - ingame query module (v3.0.3)
« Reply #144 on: November 23, 2011, 10:37:15 am »
Now THIS is an answer :) Thanx Getrix.

 

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