]> git.donarmstrong.com Git - infobot.git/blobdiff - src/Factoids/Update.pl
massive add-in for postgres support, contributed by troubled
[infobot.git] / src / Factoids / Update.pl
index 400012e52387e126765c803dba173bf3966c8f82..fcb6ca2c7607d5d096ae411132fae50db495c56d 100644 (file)
@@ -96,7 +96,7 @@ sub update {
 
        &performAddressedReply("okay");
 
-       &sqlReplace("factoids", {
+       &sqlInsert("factoids", {
                created_by      => $nuh,
                created_time    => time(),      # modified time.
                factoid_key     => $lhs,
@@ -178,8 +178,7 @@ sub update {
 
        $count{'Update'}++;
        &status("update: <$who> \'$lhs\' =$mhs=> \'$rhs\'; was \'$exists\'");
-       &sqlReplace("factoids", {
-               factoid_key     => $lhs,
+       &sqlSet("factoids", {'factoid_key' => $lhs}, {
                modified_by     => $nuh,
                modified_time   => time(),
                factoid_value   => $rhs,
@@ -212,8 +211,7 @@ sub update {
        $count{'Update'}++;
        &status("update: <$who> \'$lhs\' =$mhs=> \'$rhs\'; was \'$exists\'");
 
-       &sqlReplace("factoids", {
-               factoid_key     => $lhs,
+       &sqlSet("factoids", {'factoid_key' => $lhs}, {
                modified_by     => $nuh,
                modified_time   => time(),
                factoid_value   => $rhs,