public function mystreamsAction()
{
$activity = new Application_Model_Activity($this->registry['DB']);
$userid = $this->getRequest()->getParam('userid');
$this->view->results = $activity->myStreams($userid);
$this->view->mydetails = $this->authIdentity;
//$this->_helper->viewRenderer->setNoRender();
}
public function showAction()
{
$id = $this->getRequest()->getParam('id');
if (!$id) {
throw new Api_Model_Exception('', Api_Model_Exception::E_PARAM_REQUIRED);
}
$ids = explode(',', $id);
$mActivity = new Application_Model_Activity();
$rs = $mActivity->getByIds($ids);
echo json_encode($rs);
}
public function displayAction()
{
if (isset($this->authIdentity)) {
$id = $this->getRequest()->getParam('name');
if (!empty($this->authIdentity->intrestedlists[$id])) {
$userids = explode(',', $this->authIdentity->interestedlists[$id]);
$activityModel = new Application_Model_Activity($this->registry->DB);
$this->view->results = $activityModel->getStreams($userids);
$userModel = new Application_Model_Users($this->registry->DB);
$this->view->users = $userModel->getminiprofile($userids);
}
}
}
public function unVotestature($statureid)
{
if (isset($this->authIdentity)) {
$result = $this->find($statureid);
$result = $result[0];
$vote = unserialize($result['vote']);
$vote = array_diff($vote, array($this->authIdentity->userid));
$vote = array_unique($vote);
$update_data = array('vote' => serialize($vote));
$this->update($update_data, "statureid='{$statureid}'");
$activityModel = new Application_Model_Activity($this->_db);
$activityModel->delete(array('userid=?' => $this->authIdentity->userid, 'contenttype=?' => 'stature', 'title=?' => 'voted on', 'contentid=?' => $statureid));
}
}
public function voteBlog($blogid)
{
if (isset($this->authIdentity)) {
$result = $this->find($blogid)->toArray();
$result = $result[0];
$vote = unserialize($result['vote']);
array_push($vote, $this->authIdentity->userid);
$vote = array_unique($vote);
$update_data = array('vote' => serialize($vote));
$this->update($update_data, "blogid='{$blogid}'");
$activity = array('userid' => $this->authIdentity->userid, 'ruserid' => $result['userid'], 'contentid' => $blogid, 'title' => 'voted on', 'contenttype' => 'blog', 'contenturl' => 'blog.php?blogid=' . $blogid, 'date' => new Zend_Db_Expr('now()'), 'alternate_contentid' => 'blog_' . $blogid);
$activityModel = new Application_Model_Activity($this->_db);
$activityModel->insert($activity);
return true;
}
}
public function deleteScribbles($postid)
{
if (isset($this->authIdentity)) {
$result = $this->find($postid);
if ($result->count() > 0) {
$result = $result[0];
if ($this->authIdentity->userid == $result['suserid'] || $this->authIdentity->userid == $result['ruserid']) {
$this->delete(array('statusid=?' => $postid));
$activityModel = new Application_Model_Activity($this->_db);
$activityModel->delete(array('contenttype=?' => 'post', 'contentid=?' => $postid));
}
}
}
}
public function voteimage($imageid)
{
if (isset($this->authIdentity)) {
$sql = $this->_db->select()->from('image', array('imageid', 'albumid', 'notifyusers', 'pinnedpeople', 'dontnotify', 'userid', 'vote'))->joinLeft('album', 'album.albumid=image.albumid', 'userid as ruserid')->joinLeft('freniz', 'freniz.userid=album.userid', 'username as rusername')->where('imageid=?', $imageid);
$result = $this->_db->fetchRow($sql);
if (!empty($result)) {
$vote = unserialize($result['vote']);
if (!in_array($this->authIdentity->userid, $vote)) {
array_push($vote, $this->authIdentity->userid);
$vote = array_unique($vote);
$update_data = array('vote' => serialize($vote));
$this->update($update_data, "imageid='{$imageid}'");
$activity = array('userid' => $this->authIdentity->userid, 'ruserid' => $result['ruserid'], 'contentid' => $imageid, 'title' => 'voted on', 'contenttype' => 'image', 'contenturl' => 'image.php?imageid=' . $imageid, 'date' => new Zend_Db_Expr('now()'), 'alternate_contentid' => 'image_' . $imageid);
$activityModel = new Application_Model_Activity($this->_db);
$activityModel->insert($activity);
$notifyusers = unserialize($result['notifyusers']);
$pinnedpeople = unserialize($result['pinnedpeople']);
if (!empty($notifyusers)) {
$sql = $this->_db->select()->from('freniz', 'userid')->joinLeft('pinreq', 'pinreq.userid=freniz.userid and pinreq.imageid=' . $this->_db->quote($imageid) . ' and pinme.userid in (' . $this->_db->quote($pinnedpeople) . ')', '')->where('pinreq.userid is NULL and freniz.userid in (?)', $pinnedpeople);
$result1 = $this->_db->fetchAssoc($sql);
if (!empty($notifyusers)) {
$notifyusers = array_merge($notifyusers, array_keys($result1));
}
}
$vote1 = array_diff($vote, array($this->authIdentity->userid));
$dontnotify = unserialize($result['dontnotify']);
$notifyusers = array_unique(array_diff(array_merge($notifyusers, array($result['userid'], $result['ruserid']), $vote1), $dontnotify, array($this->authIdentity->userid)));
if (!empty($notifyusers)) {
$query = 'insert into notifications(userid,contenturl,notification,userpic) values ';
$userpic = $this->authIdentity->propic;
foreach ($notifyusers as $user) {
if (sizeof($vote1) > 1) {
$notificationtext = "<a href='" . $this->authIdentity->userid . "'>" . $this->authIdentity->username . "</a> and " . (sizeof($vote1) - 1) . " other voted on";
} else {
$notificationtext = "<a href='" . $this->authIdentity->userid . "'>" . $this->authIdentity->username . "</a> voted on";
}
if ($user == $result['ruserid']) {
$notificationtext .= " your image";
} else {
$notificationtext .= " <a href='" . $result['userid'] . "'>" . $result['username'] . "</a>'s image";
}
$query .= ' (' . $this->_db->quote(array($user, 'image/' . $imageid, $notificationtext, $userpic)) . '),';
}
$query = substr($query, 0, -1);
$query .= ' on duplicate key update notification=' . $this->_db->quote($notificationtext) . ', read1=0, time=now()';
$this->_db->query($query);
}
}
}
}
}
public function voteadmire($testyid)
{
if (isset($this->authIdentity)) {
$sql = $this->_db->select()->from('testimonial', array('suserid', 'ruserid', 'vote', 'dontnotify'))->joinLeft('freniz', 'testimonial.ruserid=freniz.userid', array('rusername' => 'username'))->where('testyid=?', $testyid);
$result = $this->_db->fetchRow($sql);
if (!empty($result)) {
//$result=$result[0];
$vote = unserialize($result['vote']);
if (!in_array($this->authIdentity->userid, $vote)) {
array_push($vote, $this->authIdentity->userid);
$vote = array_unique($vote);
$update_data = array('vote' => serialize($vote));
$this->update($update_data, "testyid='{$testyid}'");
$activity = array('userid' => $this->authIdentity->userid, 'ruserid' => $result['ruserid'], 'contentid' => $testyid, 'title' => 'voted on', 'contenttype' => 'admire', 'contenturl' => 'admire.php?admireid=' . $testyid, 'date' => new Zend_Db_Expr('now()'), 'alternate_contentid' => 'admire_' . $testyid);
$activityModel = new Application_Model_Activity($this->_db);
$activityModel->insert($activity);
$dontnotify = unserialize($result['dontnotify']);
$votes1 = array_diff($vote, array($this->authIdentity->userid));
$notifyusers = array_diff(array_merge($votes1, array($result['suserid'], $result['ruserid'])), $dontnotify, array($this->authIdentity->userid));
$query = 'insert into notifications(userid,contenturl,notification,userpic) values ';
$userpic = $this->authIdentity->propic;
if (!empty($notifyusers)) {
foreach ($notifyusers as $user) {
if (sizeof($votes1) > 1) {
$notificationtext = "<a href='" . $this->authIdentity->userid . "'>" . $this->authIdentity->username . "</a> and " . (sizeof($votes1) - 1) . " other voted on";
} else {
$notificationtext = "<a href='" . $this->authIdentity->userid . "'>" . $this->authIdentity->username . "</a> voted on";
}
if ($user == $result['ruserid']) {
$notificationtext .= " your admire";
} else {
$notificationtext .= " <a href='" . $result['ruserid'] . "'>" . $result['rusername'] . "</a>'s admire";
}
$query .= ' (' . $this->_db->quote(array($user, 'admire/' . $testyid, $notificationtext, $userpic)) . '),';
}
$query = substr($query, 0, -1);
$query .= ' on duplicate key update notification=' . $this->_db->quote($notificationtext) . ', read1=0,time=now()';
$this->_db->query($query);
}
/*
if(!empty($notifyusers1)){
$select_notifyusers=$this->_db->select()->from('notification')->where('userid in(?)',$notifyusers1);
$result_notifyusers=$this->_db->fetchAssoc($select_notifyusers);
$update_notification=array();
foreach($result_notifyusers as $user => $notifications)
{
$notifications=unserialize($notifications['notifications']);
$notifications["admire.php?admireid=".$testyid]=array("notification"=> htmlspecialchars($notificationtext,ENT_QUOTES),"read"=>"0","time"=> time());
$update_notification[$user]=$notifications;
//mysql_query("update notification set notifications='".mysql_real_escape_string(serialize($notifications))."' where userid='".$user."'");
}
$notification_case=' case userid ';
foreach($update_notification as $user=>$notification){
$notification_case.=" when '$user' then '".mysql_real_escape_string(serialize($notification))."'";
}
$notification_case.=' end';
$this->_db->update('notification',array('notifications'=>new Zend_Db_Expr($notification_case)),array(' userid in (?)'=>array_keys($update_notification)));
}*/
}
}
}
}
public function userUnvote($userid)
{
if (isset($this->authIdentity)) {
$sql = $this->_db->select()->from('friends_vote')->where('userid=?', $userid);
$result = $this->_db->fetchRow($sql);
$votes = unserialize($result['vote']);
if (in_array($this->authIdentity->userid, $votes)) {
$votes = array_diff($votes, array($this->authIdentity->userid));
$svote = array_diff($this->authIdentity->vote, array($userid));
$suserid = $this->authIdentity->userid;
$this->_db->update('friends_vote', array('vote' => serialize($votes)), array('userid=?' => $userid));
$this->_db->update('friends_vote', array('voted' => serialize($svote)), array('userid=?' => $suserid));
$activityModel = new Application_Model_Activity($this->_db);
$suserid = $this->authIdentity->userid;
$activityModel->delete(array('userid=?' => $suserid, 'contentid=?' => $userid, 'contenttype=?' => 'user', 'title=?' => 'voted on'));
}
}
}
public function votevideo($videoid)
{
if (isset($this->authIdentity)) {
$sql = $this->_db->select()->from('video', array('suserid', 'ruserid', 'vote', 'notifyusers', 'dontnotify'))->joinLeft('freniz', 'video.ruserid=freniz.userid', array('rusername' => 'username'))->where('videoid=?', $videoid);
$result = $this->_db->fetchRow($sql);
//$result=$result[0];
if (!empty($result)) {
$vote = unserialize($result['vote']);
if (!in_array($this->authIdentity->userid, $vote)) {
array_push($vote, $this->authIdentity->userid);
$vote = array_unique($vote);
$update_data = array('vote' => serialize($vote));
$this->update($update_data, "videoid='{$videoid}'");
$activity = array('userid' => $this->authIdentity->userid, 'ruserid' => $result['ruserid'], 'contentid' => $videoid, 'title' => 'voted on', 'contenttype' => 'video', 'contenturl' => 'video.php?videoid=' . $videoid, 'date' => new Zend_Db_Expr('now()'), 'alternate_contentid' => 'video_' . $videoid);
$activityModel = new Application_Model_Activity($this->_db);
$activityModel->insert($activity);
$notifyusers = unserialize($result['notifyusers']);
$vote1 = array_diff($vote, array($this->authIdentity->userid));
$dontnotify = unserialize($result['dontnotify']);
$notifyusers = array_unique(array_diff(array_merge($notifyusers, array($result['suserid'], $result['ruserid']), $vote1), $dontnotify, array($this->authIdentity->userid)));
if (!empty($notifyusers)) {
$query = 'insert into notifications(userid,contenturl,notification,userpic) values ';
$userpic = $this->authIdentity->propic;
foreach ($notifyusers as $user) {
if (sizeof($vote1) > 1) {
$notificationtext = "<a href='" . $this->authIdentity->userid . "'>" . $this->authIdentity->username . "</a> and " . (sizeof($vote1) - 1) . " other voted on";
} else {
$notificationtext = "<a href='" . $this->authIdentity->userid . "'>" . $this->authIdentity->username . "</a> voted on";
}
if ($user == $result['ruserid']) {
$notificationtext .= " your video";
} else {
$notificationtext .= " <a href='" . $result['userid'] . "'>" . $result['username'] . "</a>'s video";
}
$query .= ' (' . $this->_db->quote(array($user, 'video/' . $videoid, $notificationtext, $userpic)) . '),';
}
$query = substr($query, 0, -1);
$query .= ' on duplicate key update notification=' . $this->_db->quote($notificationtext) . ', read1=0, time=now()';
$this->_db->query($query);
}
}
}
}
}
