public function myStreams($ruserid) { if (isset($this->authIdentity)) { $sql = $this->_db->select()->from('activity', array('activityid', 'userid', 'ruserid', 'contentid', 'title', 'contenttype', 'contenturl', 'alternate_contentid', 'date'))->joinLeft('freniz', 'freniz.userid=activity.ruserid', array('ruserid' => 'userid', 'rusername' => 'username', 'ruserurl' => 'url'))->joinLeft('image', 'image.imageid=freniz.propic', 'image.url as ruserimageurl')->where('ruserid=?', $ruserid)->where('(contenttype=\'post\' and activity.title=\'posted on\') or (contenttype=\'video\' and activity.title=\'post a video on\') or (contenttype=\'image\' and activity.title=\'post image\' and activity.userid!=?) or (contenttype in (\'propic\',\'basicinfo\',\'personalinfo\',\'mood\',\'city\'))', $ruserid); $results = $this->_db->fetchAssoc($sql); $myStreamsMapper = array(); foreach ($results as $id => $values) { switch ($values['contenttype']) { case 'post': $myStreamsMapper['posts'][$id] = $values['contentid']; break; case 'image': $myStreamsMapper['images'][$id] = $values['contentid']; break; case 'video': $myStreamsMapper['videos'][$id] = $values['contentid']; break; } } if (!empty($myStreamsMapper['posts'])) { $posts = new Application_Model_Post($this->_db); $myStream_results['post'] = $posts->getPosts($myStreamsMapper['posts']); } if (!empty($myStreamsMapper['images'])) { $images = new Application_Model_Images($this->_db); $myStream_results['image'] = $images->getArrayOfImages($myStreamsMapper['images']); } if (!empty($myStreamsMapper['videos'])) { $videos = new Application_Model_Videos($this->_db); $myStream_results['video'] = $videos->getVideos($myStreamsMapper['videos']); } $final_results['mystream'] = $results; $final_results['results'] = $myStream_results; $sql = $this->_db->select()->from('commentactivity', 'max(id) as maxcomment'); $result = $this->_db->fetchRow($sql); $final_results['maxcomment'] = $result['maxcomment']; return $final_results; } }