REPLACE INTO should only be used if the data deletion is wanted.

[platal.git] / include / reminder.inc.php

diff --git a/include/reminder.inc.php b/include/reminder.inc.php
index 715d2d5..5201c8d 100644 (file)
--- a/include/reminder.inc.php
+++ b/include/reminder.inc.php
@@ -71,9 +71,9 @@ abstract class Reminder
     // and the next ask (if any).
     private static function UpdateStatus($uid, $type_id, $status, $next_ask)
     {
-        XDB::execute('REPLACE INTO  reminder
-                               SET  uid = {?}, type_id = {?}, status = {?},
-                                    remind_last = NOW(), remind_next = FROM_UNIXTIME({?})',
+        XDB::execute('INSERT INTO  reminder (uid, type_id, status, remind_last, remind_next)
+                           VALUES  ({?}, {?}, {?}, {?}, {?})
+          ON DUPLICATE KEY UPDATE  status = VALUES(status), remind_last = NOW(), remind_next = VALUES(remind_next)',
                      $uid, $type_id, $status,
                      ($next_ask > 0 ? time() + $next_ask * 24 * 60 * 60 : null));
     }