Changeset 6 for QuoteEngine

Timestamp:

04/30/06 16:45:44 (6 years ago)

Author:

james

Message:

use ping to make sure we're connected

File:

• QuoteEngine/QuoteEngine.tcl (modified) (7 diffs)

QuoteEngine/QuoteEngine.tcl

@@ -60 +60 @@
 
 ################################################################################
+# quote_ping
+# Check we're still connected to mysql
+################################################################################
+proc quote_ping { } {
+        global db_handle
+
+        if [::mysql::ping $dbhandle] {
+                return 0
+        } else {
+                return 1
+        }
+}
+
+################################################################################
 # quote_add
 # !addquote <text>
@@ -76 +90 @@
     set handle $nick
   }
+
+        if {![quote_ping]} {
+                putquick "PRIVMSG $channel :Sorry, lost database connection :("
+                return 0
+        }
 
   set sql "INSERT INTO quotes VALUES(null, "
@@ -114 +133 @@
   if [matchattr $handle $quote_noflags] { return 0 }
 
+        if {![quote_ping]} {
+                putquick "PRIVMSG $channel :Sorry, lost database connection :("
+                return 0
+        }
+
   set where_clause "WHERE channel='$channel'"
   if [regexp -- "--?all" $text] {
@@ -160 +184 @@
     return 0
   }
+
+        if {![quote_ping]} {
+                putquick "PRIVMSG $channel :Sorry, lost database connection :("
+                return 0
+        }
 
         set text [mysqlescape $text]
@@ -215 +244 @@
     return 0
   }
+
+        if {![quote_ping]} {
+                putquick "PRIVMSG $channel :Sorry, lost database connection :("
+                return 0
+        }
 
   set where_clause "AND channel='[mysqlescape $channel]'"
@@ -320 +354 @@
   if [matchattr $handle $quote_noflags] { return 0 }
 
+        if {![quote_ping]} {
+                putquick "PRIVMSG $channel :Sorry, lost database connection :("
+                return 0
+        }
+
   set sql "SELECT COUNT(*) AS total FROM quotes WHERE channel='$channel'"
   putloglev d * "QuoteEngine: executing $sql"
@@ -373 +412 @@
 
   if [matchattr $handle $quote_noflags] { return 0 }
+
+        if {![quote_ping]} {
+                putquick "PRIVMSG $channel :Sorry, lost database connection :("
+                return 0
+        }
 
   set text [mysqlescape $text]