]> git.donarmstrong.com Git - infobot.git/commitdiff
- converted 3 instances of setFactInfo to 1 sqlUpdate.
authordms <dms@c11ca15a-4712-0410-83d8-924469b57eb5>
Sun, 24 Nov 2002 16:49:39 +0000 (16:49 +0000)
committerdms <dms@c11ca15a-4712-0410-83d8-924469b57eb5>
Sun, 24 Nov 2002 16:49:39 +0000 (16:49 +0000)
- requesting (updating stats) factoids works.

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

src/Factoids/Question.pl

index 8cadc924bab0bc0a633f39c2ce8aec670c669725..2338e4454cd58533d1e227a92915ff79c05d52df 100644 (file)
@@ -231,11 +231,20 @@ sub factoidArgs {
        }
 
        # update stats.
-       my $count = &getFactInfo($q, "requested_count") || 0;
-       $count++;
-       &setFactInfo($q, "requested_by", $nuh);
-       &setFactInfo($q, "requested_time", time());
-       &setFactInfo($q, "requested_count", $count);
+       if (0) {        # old.
+           my $count = &getFactInfo($q, "requested_count") || 0;
+           $count++;
+           &setFactInfo($q, "requested_by", $nuh);
+           &setFactInfo($q, "requested_time", time());
+           &setFactInfo($q, "requested_count", $count);
+       } else {
+           &sqlUpdate("factoids", { factoid_key => $q }, {
+               requested_by            => $nuh,
+               requested_time          => time(),
+               -requested_count        => "requested_count+1",
+           } );
+       }
+
        # end of update stats.
 
        $result = $r;