public function deleteBlog($blogid)
{
if (isset($this->authIdentity)) {
$userid = $this->authIdentity->userid;
$affected_rows = $this->delete("blogid='{$blogid}' and userid='{$userid}'");
if ($affected_rows == 1) {
$activityModel = new Application_Model_Activity($this->_db);
$activityModel->delete("userid='{$userid}' and contentid='{$blogid}' and contenttype='blog' and title='write blog'");
return array("status" => "Admire removed");
} else {
return array("status" => "you dont have permission to delete this Admire");
}
} else {
return array("status", "please give the valid information");
}
}
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 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 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 deleteVideoComment($commentid)
{
if (isset($this->authIdentity)) {
$sql = $this->_db->select()->from('video_comments')->joinLeft($this->_name, 'video_comments.videoid=video.videoid', 'ruserid as video_userid')->where('commentid=?', $commentid);
$result = $this->_db->fetchRow($sql);
$userid = $this->authIdentity->userid;
if ($result['userid'] == $userid || $result['video_userid'] == $userid) {
$this->_db->delete('video_comments', "commentid='{$commentid}'");
$userid = $this->authIdentity->userid;
$videoid = $result['videoid'];
$activityModel = new Application_Model_Activity($this->_db);
$activityModel->delete("userid='{$userid}' and contentid='{$videoid}' and contenttype='video' and title='commented on'");
$update_data = array('commentcount' => new Zend_Db_Expr('commentcount-1'));
$this->update($update_data, array('videoid=?' => $videoid));
}
}
}
