X-Git-Url: http://git.datanom.net/qtadmin.git/blobdiff_plain/6b3d5ba966ffd150d635a618593295958233baef..91da83b50276678ae60a1f6016d25f88072b7abb:/lib/db_mysqli.inc.php

diff --git a/lib/db_mysqli.inc.php b/lib/db_mysqli.inc.php
index 584e843..9203f6d 100644
--- a/lib/db_mysqli.inc.php
+++ b/lib/db_mysqli.inc.php
@@ -146,6 +146,26 @@ class DBMysqli extends DBImpl {
         return $row;
     }
 
+    public function getRecipient($id) {
+        $recipient = false;
+
+        $query = "SELECT recipient.email as recipient FROM quarantine q LEFT JOIN msgrcpt ";
+        $query .= "ON msgrcpt.mail_id = q.mail_id LEFT JOIN msgs ON ";
+        $query .= "msgs.mail_id = q.mail_id LEFT JOIN maddr AS recipient ";
+        $query .= "ON msgrcpt.rid = recipient.id LEFT JOIN maddr AS sender ON ";
+        $query .= "msgs.sid = sender.id WHERE q.mail_id = '$id'";
+
+        if ($result = $this->con->query($query, MYSQLI_USE_RESULT)) {
+            $obj = $result->fetch_object();
+            if ($obj) {
+                $recipient = $obj->recipient;
+            }
+            $result->free();
+        }
+
+        return $recipient;
+    }
+
 }
 
 ?>