Fixes #12: Active variable on entities table. Update db schema.

git-svn-id: https://code.elgg.org/elgg/trunk@980 36083f99-b078-4883-b0ff-0f9b5a30f544

1 files changed, 6 insertions, 3 deletions

diff --git a/engine/lib/access.php b/engine/lib/access.php
index 5e08f2f9c..e696f89d8 100644
--- a/engine/lib/access.php
+++ b/engine/lib/access.php
@@ -101,17 +101,20 @@
 		{
 			$sql = "";
 			
+			if ($table_prefix)
+					$table_prefix = sanitise_string($table_prefix) . ".";
+			
 			if (!is_privileged())
 			{
 				$access = get_access_list();
 				
-				if ($table_prefix)
-					$table_prefix = sanitise_string($table_prefix) . ".";
-					
 				$sql = " ({$table_prefix}access_id in {$access} or ({$table_prefix}access_id = 0 and {$table_prefix}owner_guid = {$_SESSION['id']}))";
 			}
 			else
 				$sql = " 1 ";
+				
+			// Only return 'active' objects
+			$sql .= " and {$table_prefix}enabled='yes'";
 			
 			return $sql;
 		}