DataObjects/Core_notify_server.php
authorAlan <alan@roojs.com>
Thu, 5 Oct 2023 08:56:59 +0000 (16:56 +0800)
committerAlan <alan@roojs.com>
Thu, 5 Oct 2023 08:56:59 +0000 (16:56 +0800)
DataObjects/Core_notify_server.php

index f094d86..775d86d 100644 (file)
@@ -42,6 +42,25 @@ class Pman_Core_DataObjects_Core_notify_server extends DB_DataObject
         
         $num_servers = count($ids);
         
+        if ($num_servers == 1) {
+            $p = DB_DataObject::factory($notify->table);
+            $p->query("
+                UPDATE
+                    {$this->table}
+                SET
+                    server_id = {$ids[0]}
+                WHERE
+                    sent < '2000-01-01'
+                    and
+                    event_id = 0
+                    and
+                    act_start < NOW() +  INTERVAL 3 HOUR 
+                    and
+                    server_id < 0
+            ");
+            return;
+        }
+        
         // ((@row_number := CASE WHEN @row_number IS NULL THEN 0 ELSE @row_number END  +1) % {$num_servers})