public function initUserSession($id)
{
$sql = $this->_db->select()->from('freniz', array('freniz_userid' => 'userid', 'freniz_url' => 'url', 'freniz_adminpages' => 'adminpages', 'username', 'type'))->joinLeft($this->_name, 'freniz.userid=user_info.userid')->joinLeft('image as propic', 'propic.imageid=user_info.propic', array('propic_url' => 'url'))->joinLeft('friends_vote', 'freniz.userid=friends_vote.userid')->joinLeft('places', 'places.id=user_info.hometown', array('name as ht_name', 'id as ht_id', 'vote as ht_vote', 'placepic as ht_pic', 'infoid as ht_info'))->joinLeft('image as htpic', 'htpic.imageid=places.placepic', 'url as htpic_url')->joinLeft('apps', 'freniz.userid=apps.userid', 'apps.diary')->joinLeft('places as ccplaces', 'ccplaces.id=user_info.currentcity', array('name as cc_name', 'id as cc_id', 'vote as cc_vote', 'placepic as cc_pic', 'infoid as cc_info'))->joinLeft('image as ccpic', 'ccpic.imageid=ccplaces.placepic', 'url as ccpic_url')->where('freniz.userid=?', $id);
$results = $this->_db->fetchRow($sql, null, Zend_Db::FETCH_ASSOC);
$results['userid'] = $results['freniz_userid'];
unset($results['freniz_userid']);
$results['url'] = $results['freniz_url'];
unset($results['freniz_url']);
$results['adminpages'] = unserialize($results['freniz_adminpages']);
unset($results['freniz_adminpages']);
if ($results['type'] == 'user') {
$results['school'] = unserialize($results['school']);
$results['college'] = unserialize($results['college']);
$results['language'] = unserialize($results['language']);
$results['employer'] = unserialize($results['employer']);
$results['musics'] = unserialize($results['musics']);
$results['books'] = unserialize($results['books']);
$results['celebrities'] = unserialize($results['celebrities']);
$results['movies'] = unserialize($results['movies']);
$results['games'] = unserialize($results['games']);
$results['other'] = unserialize($results['other']);
$results['pinnedpic'] = unserialize($results['pinnedpic']);
$results['sports'] = unserialize($results['sports']);
$results['playlist'] = unserialize($results['playlist']);
$results['blocklist'] = unserialize($results['blocklist']);
$results['blockedby'] = unserialize($results['blockedby']);
$results['blocklistmerged'] = array_merge($results['blocklist'], $results['blockedby']);
$results['reviews'] = unserialize($results['reviews']);
$results['reqfrmme'] = unserialize($results['reqfrmme']);
$results['personalinfo'] = unserialize($results['personalinfo']);
$results['friends'] = unserialize($results['friendlist']);
unset($results['friendlist']);
$results['incomingrequest'] = unserialize($results['incomingrequest']);
$results['sentrequest'] = unserialize($results['sentrequest']);
$results['vote'] = unserialize($results['vote']);
$results['voted'] = unserialize($results['voted']);
$results['diary'] = unserialize($results['diary']);
$privacyModel = new Application_Model_Privacy($this->_db);
$privacy = $privacyModel->getUserPrivacy($id);
$results['privacy'] = $privacy;
}
$adminpages = array_merge(array($id), $results['adminpages']);
$sql1 = $this->_db->select()->from('freniz', array('userid', 'username', 'url'))->joinLeft('image', 'freniz.propic=image.imageid', 'url as propic_url')->where('freniz.userid in (?)', $adminpages);
$results['adminpages_details'] = $this->_db->fetchAssoc($sql1);
$results['latime'] = time();
$this->_db->update('user_info', array('latime' => new Zend_Db_Expr('now()')), array('userid=?' => $id));
return (object) $results;
}
public function privacysettingsAction()
{
if (isset($this->authidentity)) {
$privacy = new Application_Model_Privacy($this->registry->DB);
$this->view->privacy = $privacy->getUserPrivacy($this->authidentity->userid, true);
$this->view->myDetails = $this->authidentity;
}
}
