From 6ed90e647a0a513def828ec66f17df2b724c518e Mon Sep 17 00:00:00 2001
From: Mark Pemberton <mpemberton5@gmail.com>
Date: Sat, 14 May 2011 21:46:35 -0400
Subject: Fixed sql commands where resources were not freed

---
 src/SemanticScuttle/Service/Bookmark.php | 1 +
 src/SemanticScuttle/Service/User.php     | 9 +++++----
 2 files changed, 6 insertions(+), 4 deletions(-)

(limited to 'src')

diff --git a/src/SemanticScuttle/Service/Bookmark.php b/src/SemanticScuttle/Service/Bookmark.php
index e836cd8..57d0b2e 100644
--- a/src/SemanticScuttle/Service/Bookmark.php
+++ b/src/SemanticScuttle/Service/Bookmark.php
@@ -427,6 +427,7 @@ class SemanticScuttle_Service_Bookmark extends SemanticScuttle_DbService
             $existence[$hashes[$row['bHash']]] = $row['count'] > 0;
         }
 
+        $this->db->sql_freeresult($dbresult);
         return $existence;
     }
 
diff --git a/src/SemanticScuttle/Service/User.php b/src/SemanticScuttle/Service/User.php
index c3633de..01945ca 100644
--- a/src/SemanticScuttle/Service/User.php
+++ b/src/SemanticScuttle/Service/User.php
@@ -674,11 +674,12 @@ class SemanticScuttle_Service_User extends SemanticScuttle_DbService
             return false;
         }
 
-        $arrWatch = array();
+        $retval = true;
         if ($this->db->sql_numrows($dbresult) == 0)
-        return false;
-        else
-        return true;
+        $retval = false;
+
+        $this->db->sql_freeresult($dbresult);
+        return $retval;
     }
 
     function setWatchStatus($subjectUserID) {
-- 
cgit v1.2.3