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

BoA-Gert · « **Reply #135 on:** September 23, 2011, 01:03:06 pm »

Quote from: dillinger on September 23, 2011, 12:04:57 am

Hi folks

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

I get this error msg at the bot console:

Code: [Select]
Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10060) in C:\xampp\php\custom\modules\EQDKP_Query.php on line 578 DKP Error: Cant connect to database DKP Error: Cant select database Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in C:\xampp\php\custom\modules\EQDKP_Query.php on line 116
I think the problem is 'localhost' since I'm running the EQDKP sytem on a different webserver.

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

Thanks for your feedback guys!

dill

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

dillinger · « **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

Drizzurden · « **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

dillinger · « **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

dillinger · « **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

dillinger · « **Reply #140 on:** October 12, 2011, 02:17:59 pm »

*push*

dillinger · « **Reply #141 on:** October 16, 2011, 09:10:52 pm »

*push*

dillinger · « **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.

Getrix · « **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"...