From 201c99fb2a0d85ded81967902c68138726e3142f Mon Sep 17 00:00:00 2001
From: timriker <timriker@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Fri, 6 May 2005 19:27:33 +0000
Subject: [PATCH] old mysql/sqlite don't do +1
git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@1216 c11ca15a-4712-0410-83d8-924469b57eb5
---
blootbot/src/Factoids/Question.pl | 12 +++++++-----
1 file changed, 7 insertions(+), 5 deletions(-)
diff --git a/blootbot/src/Factoids/Question.pl b/blootbot/src/Factoids/Question.pl
index 0b7ae04..db7da14 100644
--- a/blootbot/src/Factoids/Question.pl
+++ b/blootbot/src/Factoids/Question.pl
@@ -237,11 +237,13 @@ sub factoidArgs {
return;
}
- # update stats.
- &sqlUpdate("factoids", { factoid_key => $q }, {
- requested_by => $nuh,
- requested_time => time(),
- -requested_count => "requested_count+1",
+ # update stats. old mysql/sqlite don't do +1
+ my ($count) = &sqlSelect("factoids", "requested_count", { factoid_key => $factoid });
+ $count++;
+ &sqlSet("factoids", {'factoid_key' => $q}, {
+ requested_by => $nuh,
+ requested_time => time(),
+ requested_count => $count
} );
# end of update stats.
--
2.39.5