From 785278c86a23874d5c05d99276c4ca265d299340 Mon Sep 17 00:00:00 2001 From: dms Date: Sun, 24 Nov 2002 12:55:15 +0000 Subject: [PATCH] - new sql functions changeover. git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@701 c11ca15a-4712-0410-83d8-924469b57eb5 --- blootbot/src/Factoids/Reply.pl | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/blootbot/src/Factoids/Reply.pl b/blootbot/src/Factoids/Reply.pl index 176a62b..55d02a0 100644 --- a/blootbot/src/Factoids/Reply.pl +++ b/blootbot/src/Factoids/Reply.pl @@ -28,8 +28,11 @@ sub getReply { $message =~ tr/A-Z/a-z/; - my ($count, $fauthor, $result) = &dbGet("factoids", - "requested_count,created_by,factoid_value", "factoid_key=".&dbQuote($message) ); + my ($count, $fauthor, $result) = &sqlSelect("factoids", + "requested_count,created_by,factoid_value", + { factoid_key => $message } + ); + if ($result) { $lhs = $message; $mhs = "is"; @@ -61,7 +64,7 @@ sub getReply { ### FIXME: old mysql doesn't support ### "requested_count=requested_count+1". $count++; - &dbSet("factoids", {'factoid_key' => $lhs}, { + &sqlSet("factoids", {'factoid_key' => $lhs}, { requested_by => $nuh, requested_time => time(), requested_count => $count -- 2.39.5