old mysql/sqlite don't do +1

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@1216 c11ca15a-4712-0410-83d8-924469b57eb5

diff --git a/src/Factoids/Question.pl b/src/Factoids/Question.pl
index 0b7ae04c658755ccb7cce13c0d30136bff23d941..db7da14e438ee26c7a9d50c07f697166c55dcbc3 100644 (file)
--- a/src/Factoids/Question.pl
+++ b/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.