From c0e46287e41ac5be4c4832c915c8e2ba78b9a1d5 Mon Sep 17 00:00:00 2001
From: mensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>
Date: Tue, 3 Feb 2009 15:32:23 +0000
Subject: Refactoring: free few sql results

git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@247 b3834d28-1941-0410-a4f8-b48e95affb8f
---
 services/userservice.php | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'services/userservice.php')

diff --git a/services/userservice.php b/services/userservice.php
index 21b9136..7f0382d 100644
--- a/services/userservice.php
+++ b/services/userservice.php
@@ -73,6 +73,7 @@ class UserService {
 		while ($row = & $this->db->sql_fetchrow($dbresult)) {
 			$users[] = $row;
 		}
+		$this->db->sql_freeresult($dbresult);
 		return $users;
 	}
 
@@ -89,6 +90,7 @@ class UserService {
 		while ($row = & $this->db->sql_fetchrow($dbresult)) {
 			$users[] = new User($row[$this->getFieldName('primary')], $row[$this->getFieldName('username')]);
 		}
+		$this->db->sql_freeresult($dbresult);
 		return $users;
 	}
 
@@ -238,6 +240,7 @@ class UserService {
 
 			if ($row = $this->db->sql_fetchrow($dbresult)) {
 				$_SESSION[$this->getSessionKey()] = $row[$this->getFieldName('primary')];
+				$this->db->sql_freeresult($dbresult);
 				return $_SESSION[$this->getSessionKey()];
 			}
 		}
@@ -259,6 +262,7 @@ class UserService {
 				$cookie = $id .':'. md5($username.$password);
 				setcookie($this->cookiekey, $cookie, time() + $this->cookietime, '/');
 			}
+			$this->db->sql_freeresult($dbresult);
 			return true;
 		} else {
 			return false;
@@ -314,6 +318,7 @@ class UserService {
 		while ($row =& $this->db->sql_fetchrow($dbresult)) {
 			$arrWatch[] = $row[$this->getFieldName('username')];
 		}
+		$this->db->sql_freeresult($dbresult);
 		return $arrWatch;
 	}
 
@@ -422,7 +427,7 @@ class UserService {
 		while ( $row = $this->db->sql_fetchrow($dbresult) ) {
 			$rows[] = $row;
 		}
-
+		$this->db->sql_freeresult($dbresult);
 		return $rows;
 	}
 
-- 
cgit v1.2.3