1 files changed, 13 insertions, 13 deletions

diff --git a/modules/notification/helpers/notification.php b/modules/notification/helpers/notification.php
index 9a40b0b9..e9fc3f33 100644
--- a/modules/notification/helpers/notification.php
+++ b/modules/notification/helpers/notification.php
@@ -24,8 +24,8 @@ class notification {
     }
 
     return ORM::factory("subscription")
-      ->where("item_id", $item_id)
-      ->where("user_id", $user->id)
+      ->where("item_id", "=", $item_id)
+      ->where("user_id", "=", $user->id)
       ->find();
   }
 
@@ -35,10 +35,10 @@ class notification {
     }
 
     return ORM::factory("subscription")
-      ->where("item_id", $item->id)
-      ->where("user_id", $user->id)
+      ->where("item_id", "=", $item->id)
+      ->where("user_id", "=", $user->id)
       ->find()
-      ->loaded;
+      ->loaded();
   }
 
   static function add_watch($item, $user=null) {
@@ -60,8 +60,8 @@ class notification {
       }
 
       $subscription = ORM::factory("subscription")
-        ->where("item_id", $item->id)
-        ->where("user_id", $user->id)
+        ->where("item_id", "=", $item->id)
+        ->where("user_id", "=", $user->id)
         ->find()->delete();
     }
   }
@@ -71,8 +71,8 @@ class notification {
     foreach (ORM::factory("subscription")
              ->select("user_id")
              ->join("items", "subscriptions.item_id", "items.id")
-             ->where("items.left_ptr <=", $item->left_ptr)
-             ->where("items.right_ptr >", $item->right_ptr)
+             ->where("items.left_ptr", "<=", $item->left_ptr)
+             ->where("items.right_ptr", ">", $item->right_ptr)
              ->find_all()
              ->as_array() as $subscriber) {
       $subscriber_ids[] = $subscriber->user_id;
@@ -170,13 +170,13 @@ class notification {
   }
 
   static function send_pending_notifications() {
-    foreach (Database::instance()
-             ->select("DISTINCT email")
+    foreach (db::build()
+             ->select(new Database_Expression("DISTINCT `email`"))
              ->from("pending_notifications")
-             ->get() as $row) {
+             ->execute() as $row) {
       $email = $row->email;
       $result = ORM::factory("pending_notification")
-        ->where("email", $email)
+        ->where("email", "=", $email)
         ->find_all();
       if ($result->count() == 1) {
         $pending = $result->current();