egghelp/eggheads community Discussion of eggdrop bots, shell accounts and tcl scripts. 2009-11-23T00:05:25-04:00 https://forum.eggheads.org/app.php/feed/topic/17317 2009-11-23T00:05:25-04:00 2009-11-23T00:05:25-04:00 https://forum.eggheads.org/viewtopic.php?p=91012#p91012 <![CDATA[mysql connect]]>
I'm using this in my script.

Code: 

proc name { all arguments } {   mysqlconnect   conditions   &   commands   mysqlclose}
I'm sure to have a "fresh" connection to the mysql server.

Note: I put "mysqlclose" at each location that the script ends.

Statistics: Posted by DarkRaptor — Mon Nov 23, 2009 12:05 am

]]> 2009-11-16T05:04:15-04:00 2009-11-16T05:04:15-04:00 https://forum.eggheads.org/viewtopic.php?p=90934#p90934 <![CDATA[mysql connect]]>
How do i get the bot to keep connection to the mysql database, without replying "The connection to the mysql server has been lost." almost all the time?

Code: 

##################### Mysql path #####################if {![info exists db_handle] } {set db_handle [mysqlconnect -host xxxx.xxxx.xxxxx -port xxxx -user xxx -password xxxxx -db xxxxxx]}

Code: 

     if {[mysqlping $db_handle] != 1} {          putserv "PRIVMSG $channel :The connection to the mysql server has been lost."         return 0     }

Statistics: Posted by Fire-Fox — Mon Nov 16, 2009 5:04 am

]]>