From cc76d0a9ecb840d071bfbba1cd66f503f9dc2142 Mon Sep 17 00:00:00 2001
From: marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Thu, 16 Oct 2008 12:35:43 +0000
Subject: Closes #442: Requires schema upgrade. Side effect - friends activity
 rivers will be blanked.

git-svn-id: https://code.elgg.org/elgg/trunk@2267 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/lib/river.php      | 10 +++++++---
 engine/lib/system_log.php | 11 ++++++++++-
 2 files changed, 17 insertions(+), 4 deletions(-)

(limited to 'engine/lib')

diff --git a/engine/lib/river.php b/engine/lib/river.php
index 0952ad965..4db00d18c 100644
--- a/engine/lib/river.php
+++ b/engine/lib/river.php
@@ -158,7 +158,7 @@
 	function __get_river_from_log($by_user = "", $relationship = "", $limit = 10, $offset = 0)
 	{
 		global $CONFIG;
-		
+	
 		// Get all potential river events from available view
 		$river_events = array(); 
 		$river_views = elgg_view_tree('river');
@@ -200,7 +200,11 @@
 			if (($details['type']) && ($details['event'])) {
 				if ($n>0) $obj_query .= " or ";
 				
-				$obj_query .= "( sl.object_type='{$details['type']}' and sl.object_subtype='{$details['subtype']}' and sl.event='{$details['event']}' )";
+				$access = "";
+				if ($details['type']!='relationship')
+					$access = " and " . get_access_sql_suffix('sl');
+				 
+				$obj_query .= "( sl.object_type='{$details['type']}' and sl.object_subtype='{$details['subtype']}' and sl.event='{$details['event']}' $access )";
 				
 				$n++;
 			}
@@ -220,7 +224,7 @@
 		}
 		
 		$query = "SELECT sl.* from {$CONFIG->dbprefix}system_log sl $relationship_join where $user and $relationship_query ($obj_query) order by sl.time_created desc  limit $offset, $limit";
-
+echo $query;
 		// fetch data from system log (needs optimisation)
 		return get_data($query);
 	}
diff --git a/engine/lib/system_log.php b/engine/lib/system_log.php
index d315d453f..1bbde9231 100644
--- a/engine/lib/system_log.php
+++ b/engine/lib/system_log.php
@@ -204,9 +204,18 @@
 			$time = time();
 			$performed_by = (int)$_SESSION['guid'];
 			
+			if (isset($object->access_id))
+				$access_id = $object->access_id;
+			else
+				$access_id = 2;
+			if (isset($object->enabled))
+				$enabled = $object->enabled;
+			else
+				$enabled = 'yes';
+			
 			// Create log if we haven't already created it
 			if (!isset($logcache[$time][$object_id][$event])) {
-				if (insert_data("INSERT DELAYED into {$CONFIG->dbprefix}system_log (object_id, object_class, object_type, object_subtype, event, performed_by_guid, time_created) VALUES ('$object_id','$object_class','$object_type', '$object_subtype', '$event',$performed_by, '$time')")) {
+				if (insert_data("INSERT DELAYED into {$CONFIG->dbprefix}system_log (object_id, object_class, object_type, object_subtype, event, performed_by_guid, access_id, enabled, time_created) VALUES ('$object_id','$object_class','$object_type', '$object_subtype', '$event',$performed_by, $access_id, '$enabled', '$time')")) {
 					$logcache[$time][$object_id][$event] = true;
 					return true;
 				}
-- 
cgit v1.2.3