mysql connect

[Fire-Fox]

Hey

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: Select all

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

Code: Select all

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

[DarkRaptor]

Hi Fire-Fox,

I'm using this in my script.

Code: Select all

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.