This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.


For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

Interfacing with mysql

Old posts that have not been replied to for several years.
Locked
d
d3k

Interfacing with mysql

Post by d3k »

Hello,

I am new to eggdrop and just have my first bot up and running, I want to be able to run queries in the channel by doing !search <term> which runs a mysql query and the results are msg'd to the user.

I'd also like when an INSERT is done on the db from a php script on webpage then the bot will announce to the channel. I've read some docs on mysql tcl packages but i'm using a commercial shell and I think i would need root access to do this?

httpd,mysql and egg are on same server. Im just looking to know if this is a possible and a point in the general direction.

Thanks
m
mortician
Voice
Posts: 37
Joined: Sun Sep 22, 2002 6:35 pm
Location: Tsjakamaka
Contact:

Post by mortician »

you don't need root access to install a mysq tcl interface

when you ./configure a mysql api use the --prefix=/path/ option ...
(./configure --help to see all option)
but perhaps it would be better to ask your admin :wink:

mysql interface I use: http://www.xdobry.de/mysqltcl/

greetings
It is a mistake to think you can solve any major problems just with potatoes.
d
d3k

Post by d3k »

Hi,

Thanks for the link, im studying the docs now. In simplest terms I also want to for example have a html text box, when the form is submitted the contents of the box are announced in the channel. I am familiar with php but dont know how/if I could connect to the bot with it, maybe thru telnet?

Thanks
Locked