foo+1 does not work on sqlReplace for sqlite.

[infobot.git] / src / Process.pl

diff --git a/src/Process.pl b/src/Process.pl
index be05fdf19e21c6c99ce1e31a1b864ad0f0be3dd2..3563866c101790061fd01d4750c9124dab7e2e09 100644 (file)
--- a/src/Process.pl
+++ b/src/Process.pl
@@ -314,19 +314,20 @@ sub process {
            return;
        }
 
-       my $karma = &dbGet("stats", "counter",
-               "nick=".&dbQuote($term)." AND type='karma'") || 0;
+       my $karma = &sqlSelect("stats", "counter",
+               { nick => $term, type => "karma" }) || 0;
        if ($inc eq '++') {
            $karma++;
        } else {
            $karma--;
        }
 
-       &dbSet("stats", 
-               { nick => $term, type => "karma" },     # WHERE
-#              { counter => $karma }                   # WHAT
-               { -counter => "counter+1" }
-       );
+       &sqlReplace("stats", {
+           nick        => $term,
+           type        => "karma",
+           'time'      => time(),
+           counter     => $karma,
+       } );
 
        return;
     }