activity_enable == 'no') { return true; } $group = $vars['entity']; $all_link = elgg_view('output/url', array( 'href' => "pg/groups/activity/$group->guid", 'text' => elgg_echo('link:view:all'), )); $header = "$all_link"; $header .= '

' . elgg_echo('groups:activity') . '

'; elgg_push_context('widgets'); $content = elgg_list_river(array( 'limit' => 4, 'pagination' => false, 'joins' => array("join {$CONFIG->dbprefix}entities e1 on e1.guid = rv.object_guid"), 'wheres' => array("(e1.container_guid = $group->guid)"), )); elgg_pop_context(); if (!$content) { $content = '

' . elgg_echo('groups:activity:none') . '

'; } $params = array( 'header' => $header, 'body' => $content, 'class' => 'elgg-module-info', ); echo elgg_view('layout/objects/module', $params); return true; ?> ">

guid; $limit = 5; $offset = (int) get_input('offset', 0); // Sanitise variables -- future proof in case they get sourced elsewhere $limit = (int) $limit; $offset = (int) $offset; $group_guid = (int) $group_guid; $sql = "SELECT {$CONFIG->dbprefix}river.id, {$CONFIG->dbprefix}river.type, {$CONFIG->dbprefix}river.subtype, {$CONFIG->dbprefix}river.action_type, {$CONFIG->dbprefix}river.access_id, {$CONFIG->dbprefix}river.view, {$CONFIG->dbprefix}river.subject_guid, {$CONFIG->dbprefix}river.object_guid, {$CONFIG->dbprefix}river.posted FROM {$CONFIG->dbprefix}river INNER JOIN {$CONFIG->dbprefix}entities AS entities1 ON {$CONFIG->dbprefix}river.object_guid = entities1.guid INNER JOIN {$CONFIG->dbprefix}entities AS entities2 ON entities1.container_guid = entities2.guid WHERE entities2.guid = $group_guid OR {$CONFIG->dbprefix}river.object_guid = $group_guid ORDER BY posted DESC limit {$offset},{$limit}"; $items = get_data($sql); if (count($items) > 0) { $river_items = elgg_view('river/item/list',array( 'limit' => $limit, 'offset' => $offset, 'items' => $items )); } echo $river_items; ?>