$accountUrl=JRoute::_('index.php?option=com_community&view=profile&userid=' . $user->id . '&Itemid=' . AwdwallHelperUser::getJsItemId(), false); } else { $friendJsUrl = JRoute::_('index.php?option=com_awdwall&task=friends&Itemid=' . $Itemid, false); $accountUrl=JRoute::_('index.php?option=com_awdwall&task=uploadavatar&Itemid=' . $Itemid, false); } //$config = &JComponentHelper::getParams('com_awdwall'); $app = JFactory::getApplication('site'); $config = & $app->getParams('com_awdwall'); $template = $config->get('temp', 'default'); $width = $config->get('width', 725); $displayName = $config->get('display_name', 1); $fields = $config->get('fieldids', ''); $display_gallery = $config->get('display_gallery', 1); $basicInfo = JsLib::getUserBasicInfo($user->id, $fields); $cbfields=explode(",",$row->cbfields); //echo '<pre>'; //print_r($basicInfo); //echo '</pre>'; //$query = "SELECT params FROM #__components WHERE `name`='Colors' AND `admin_menu_link`='option=com_awdwall&controller=colors'"; $link='index.php?option=com_awdwall&controller=colors'; $db->setQuery("SELECT params FROM #__menu WHERE `link`='".$link."'"); $params = json_decode( $db->loadResult(), true ); for($i=1; $i<=14; $i++) { $str_color = 'color'.$i; $color[$i]= $params[$str_color]; } $albumlink=JRoute::_("index.php?option=com_awdjomalbum&view=awdalbumlist&wuid=".$user->id."&Itemid=".AwdwallHelperUser::getComItemId(),false);
function getHightlightbox($userid) { $db = &JFactory::getDBO(); $itemId = AwdwallHelperUser::getComItemId(); $user =& JFactory::getUser(); $config = &JComponentHelper::getParams('com_awdwall'); $himages = $config->get('himages', 3); $fields = $config->get('fieldids', ''); $basicInfo = JsLib::getUserBasicInfo($user->id, $fields); $app =& JFactory::getApplication(); $dbprefix=$app->getCfg('dbprefix'); $tablename=$dbprefix.'awd_jomalbum_userinfo'; $query = 'show tables like "'.$tablename.'"'; $db->setQuery($query); $results = $db->loadObjectList(); if(count($results)>0) { $query="Select * from #__awd_jomalbum_userinfo where userid=".$userid; $db->setQuery($query); $userinfo=$db->loadObjectList(); $userinfo=$userinfo[0]; } $userhighlightfields=explode(",",$userinfo->userhighlightfields); $counter=0; $query="SELECT p.id,p.path,a.wall_date FROM #__awd_wall_images AS p INNER JOIN #__awd_wall AS a inner join #__awd_wall_privacy as pv on pv.wall_id=a.id WHERE a.commenter_id =".$userid." and pv.privacy=0 and p.wall_id=a.id and a.wall_date IS NOT NULL ORDER BY a.id DESC LIMIT ".$himages; $db->setQuery($query); $wallimages=$db->loadObjectList(); foreach($wallimages as $wallimage) { $imagearray[$i]['path']=JURI::base().'images/'.$userid.'/original/'.$wallimage->path; $link =JRoute::_("index.php?option=com_awdjomalbum&view=awdwallimagelist&wuid=".$userid."&pid=".$wallimage->id."&Itemid=".$itemId); } //print_r($userhighlightfields); ?> <div class="hightlightboxMain"> <div class="hightlightboxInner"> <div class="hightlightboxleft"> <ul class="hightlightul"> <?php if(is_array($basicInfo)){ foreach($basicInfo as $arr){ $cbff='display_'.str_replace(' ','',$arr[1]); //print_r($arr); if((in_array($arr[1],$userhighlightfields))&&(!empty($arr[0])) && ($counter<=4)){ ?> <li class="workat"><span class="hightlightlevel"><?php echo $arr[1];?></span> <?php echo $arr[0];?></li> <?php $counter=$counter+1; } } } ?> <?php if((in_array('currentcity',$userhighlightfields))&&(!empty($userinfo->currentcity)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Current City');?></span> <?php if(strlen($userinfo->currentcity)>30){echo substr($userinfo->currentcity,0,30).'...';}else{ echo $userinfo->currentcity;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('hometown',$userhighlightfields))&&(!empty($userinfo->hometown)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Hometown');?></span> <?php if(strlen($userinfo->hometown)>30){echo substr($userinfo->hometown,0,30).'...';}else{ echo $userinfo->hometown;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('currentcity',$userhighlightfields))&&(!empty($userinfo->languages)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Languages');?></span> <?php if(strlen($userinfo->languages)>30){echo substr($userinfo->languages,0,30).'...';}else{ echo $userinfo->languages;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('birthday',$userhighlightfields))&&(!empty($userinfo->birthday)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Birthday');?></span> <?php if($userinfo->hide_birthyear==1){echo date('jS F ', strtotime($userinfo->birthday));}else{echo date('jS F Y', strtotime($userinfo->birthday));}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('skype_user',$userhighlightfields))&&(!empty($userinfo->skype_user)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Skype Userid');?></span> <?php if(strlen($userinfo->skype_user)>30){echo substr($userinfo->skype_user,0,30).'...';}else{ echo $userinfo->skype_user;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('facebook_user',$userhighlightfields))&&(!empty($userinfo->facebook_user)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Facebook Userid');?></span> <?php if(strlen($userinfo->facebook_user)>30){echo substr($userinfo->facebook_user,0,30).'...';}else{ echo $userinfo->facebook_user;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('twitter_user',$userhighlightfields))&&(!empty($userinfo->twitter_user)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Twitter Userid');?></span> <?php if(strlen($userinfo->twitter_user)>30){echo substr($userinfo->twitter_user,0,30).'...';}else{ echo $userinfo->twitter_user;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('youtube_user',$userhighlightfields))&&(!empty($userinfo->youtube_user)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Youtube Userid');?></span> <?php if(strlen($userinfo->youtube_user)>30){echo substr($userinfo->youtube_user,0,30).'...';}else{ echo $userinfo->youtube_user;}?></li> <?php } ?> <?php if((in_array('workingat',$userhighlightfields))&&(!empty($userinfo->workingat)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Working At');?></span> <?php if(strlen($userinfo->workingat)>30){echo substr($userinfo->workingat,0,30).'...';}else{ echo $userinfo->workingat;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('studied',$userhighlightfields))&&(!empty($userinfo->studied)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Studied');?></span> <?php if(strlen($userinfo->studied)>30){echo substr($userinfo->studied,0,30).'...';}else{ echo $userinfo->studied;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('livein',$userhighlightfields))&&(!empty($userinfo->livein)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Live in');?></span> <?php if(strlen($userinfo->livein)>30){echo substr($userinfo->livein,0,30).'...';}else{ echo $userinfo->livein;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('phone',$userhighlightfields))&&(!empty($userinfo->phone)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Phone');?></span> <?php if(strlen($userinfo->phone)>30){echo substr($userinfo->phone,0,30).'...';}else{ echo $userinfo->phone;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('cell',$userhighlightfields))&&(!empty($userinfo->cell)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Cell');?></span> <?php if(strlen($userinfo->cell)>30){echo substr($userinfo->cell,0,30).'...';}else{ echo $userinfo->cell;}?></li> <?php $counter=$counter+1;} ?> <?php if((in_array('maritalstatus',$userhighlightfields))&&(!empty($userinfo->maritalstatus)) && ($counter<=4)){?> <li class="workat"><span class="hightlightlevel"><?php echo JText::_('Marital status');?></span> <?php if($userinfo->maritalstatus=='married'){echo JText::_('Married');}?> <?php if($userinfo->maritalstatus=='single'){echo JText::_('Single');}?> <?php if($userinfo->maritalstatus=='divorced'){echo JText::_('Divorced');}?> </li> <?php $counter=$counter+1;} ?> </ul> </div> <?php if(count($wallimages)){ ?> <div class="hightlightboxright"> <?php foreach($wallimages as $wallimage) { $imagepath=JURI::base().'images/'.$userid.'/thumb/tn'.$wallimage->path; //$imagearray[$i]['pdate']=$wallimage->wall_date; $link =JRoute::_("index.php?option=com_awdjomalbum&view=awdwallimagelist&wuid=".$userid."&pid=".$wallimage->id."&Itemid=".$itemId); //echo $imagearray[$k]['path']; ?> <a href="<?php echo $link;?>" class="awdiframe"> <img src="<?php echo $imagepath;?>" alt="" title="" style="float:left;margin-left:2px;"/> </a> <?php } ?> </div> <?php } ?> </div> </div> <?php if($counter==0 and count($wallimages)==0 ){?> <script type="text/javascript"> jQuery(".hightlightboxMain").hide(); </script> <?php } ?> <?php if($counter==0 and count($wallimages)>0 ){?> <script type="text/javascript"> jQuery(".hightlightboxleft").hide(); </script> <?php } ?> <?php }
function saveinfo() { require_once (JPATH_SITE. DS .'components'.DS.'com_awdwall'.DS. 'models' . DS . 'wall.php'); $mainframe= JFactory::getApplication(); $option = JRequest::getCmd('option'); $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $app = JFactory::getApplication('site'); $config = & $app->getParams('com_awdwall'); $fields = $config->get('fieldids', ''); $basicInfo = JsLib::getUserBasicInfo($user->id, $fields); if(is_array($basicInfo)){ foreach($basicInfo as $arr){ $requetfield='display_'.str_replace(' ','',$arr[1]); if($_REQUEST[$requetfield]) { if($fieldname=='') { $fieldname=$_REQUEST[$requetfield]; } else { $fieldname=$fieldname.','.$_REQUEST[$requetfield]; } } } } //print_r($user); $id=$_REQUEST['id']; $highlightfields=$_REQUEST['highlightfields']; $userhighlightfields=implode(",",$highlightfields); $row = new TableAwd_jomalbum_userinfo($db); $post = JRequest::get( 'post' ); $row->id=$id; if (!$row->bind( $post )) { return JError::raiseError( 500, $db->stderr() ); } $row->userhighlightfields=''; $row->userhighlightfields= $userhighlightfields; $row->cbfields=''; $row->cbfields= $fieldname; if (!$row->store()) { return JError::raiseError( 500, $db->stderr() ); } $wall =& JTable::getInstance('Wall', 'Table'); $wall->user_id = $user->id; $wall->type = 'text'; $wall->commenter_id = $user->id; $wall->user_name = ''; $wall->avatar = ''; $wall->message = JText::_('UPDATED PROFILE'); $wall->reply = 0; $wall->is_read = 0; $wall->is_pm = 0; $wall->is_reply = 0; $wall->posted_id = NULL; $wall->wall_date = time(); $wall->store(); // AUP POINTS $api_AUP = JPATH_SITE.DS.'components'.DS.'com_alphauserpoints'.DS.'helper.php'; if ( file_exists($api_AUP)) { require_once ($api_AUP); $keyreference = AlphaUserPointsHelper::buildKeyreference('plgaup_points4jomwallinfosave', $user->id ); AlphaUserPointsHelper::newpoints('plgaup_points4jomwallinfosave','', $keyreference); } $this->setMessage(JText::_('Information saved') ); $this->setRedirect(JRoute::_('index.php?option=com_awdjomalbum&view=userinfo&wuid='.$user->id.'&Itemid='.AwdwallHelperUser::getComItemId(),false)); }
public function viewFriends($tpl = null) { $mainframe =& JFactory::getApplication(); $itemId = AwdwallHelperUser::getComItemId(); $task = JRequest::getCmd('task', ''); $page = JRequest::getCmd('awd_page', 0); // get configuration from database //$config = &JComponentHelper::getParams('com_awdwall'); $app = JFactory::getApplication('site'); $config = & $app->getParams('com_awdwall'); $displayName = $config->get('display_name', 1); $postLimit = $config->get('nof_post', 15); $fields = $config->get('fieldids', ''); $privacy = $config->get('privacy', 0); $displayPm = $config->get('display_pm', 1); $display_group = $config->get('display_group', 1); $display_group_for_moderators = $config->get('display_group_for_moderators', 1); $moderator_users = $config->get('moderator_users', ''); $moderator_users=explode(',',$moderator_users); $user = &JFactory::getUser(); // get all msg from databases $wallModel = & $this->getModel('wall'); $this->assignRef('wallModel', $wallModel); // build where clause $where = array(); $where[] = 'connect_from = ' . (int)$user->id; $where = count($where) ? ' WHERE ' . implode( ' AND ', $where ) : ''; $offset = $page*$postLimit; //color $db =& JFactory::getDBO(); // $query = "SELECT params FROM #__components WHERE `name`='Colors' AND `admin_menu_link`='option=com_awdwall&controller=colors'"; $link='index.php?option=com_awdwall&controller=colors'; $db->setQuery("SELECT params FROM #__menu WHERE `link`='".$link."'"); $params = json_decode( $db->loadResult(), true ); for($i=1; $i<=14; $i++) { $str_color = 'color'.$i; $color[$i]= $params[$str_color]; } $this->assignRef('color', $color); //$friends = $wallModel->getAllFriends($postLimit, $where, $offset); $query = 'SELECT * FROM #__awd_connection inner join #__users ON #__awd_connection.connect_to=#__users.id ' .$where . ' ' .'ORDER BY connection_id DESC '; // echo $query ; $db->setQuery($query); $friends =$db->loadObjectList(); $nofFriends = $wallModel->countFriends($where); require_once (JPATH_COMPONENT . DS . 'libraries' . DS . 'jslib.php'); $basicInfo = JsLib::getUserBasicInfo($user->id, $fields); $totalFriends = JsLib::countFriends($user->id); $friendLimit = (int)$config->get('nof_friends', 4); if($friendLimit > 6) $friendLimit = 6; $leftFriends = JsLib::getAllFriends($user->id, $friendLimit); // get 4 first groups to display require_once (JPATH_COMPONENT . DS . 'models' . DS . 'group.php'); $whr = array(); $whr[] = 'ag.creator = ' . $user->id . ' OR agm.user_id =' . $user->id; $whr[] =' status="1"'; $whr = count($whr) ? ' WHERE ' . implode( ' AND ', $whr ) : ''; $groups = AwdwallModelGroup::getAllGrps($whr, 4, 0); //Total pending friend requests $pendingFriends = JsLib::getPendingFriends($user->id); //Userinfo of login user $userinfo = AwdwallHelperUser::getUserInfo($user->id); $this->assignRef('userinfo', $userinfo); //Total private message of user require_once (JPATH_COMPONENT . DS . 'models' . DS . 'wall.php'); $modelWall = new AwdwallModelWall(); //print_r($modelWall); $totalpm = $modelWall->countpm($user->id); $pendingGroups = JsLib::getPendingGroups($user->id); $this->assignRef('pendingGroups', $pendingGroups); $this->assignRef('totalpm', $totalpm); $this->assignRef('totalmygroup', $totalmygroup); $this->assignRef('groups', $groups); $this->assignRef('totalFriends', $totalFriends); $this->assignRef('leftFriends', $leftFriends); $this->assignRef('basicInfo', $basicInfo); $this->assignRef('nofFriends', $nofFriends); $this->assignRef('friends', $friends); $this->assignRef('page', $page); $this->assignRef('postLimit', $postLimit); $this->assignRef('privacy', $privacy); $this->assignRef('displayName', $displayName); $this->assignRef('displayPm', $displayPm); $this->assignRef('display_group', $display_group); $this->assignRef('display_group_for_moderators', $display_group_for_moderators); $this->assignRef('moderator_users', $moderator_users); $this->assignRef('pendingFriends', $pendingFriends); $display_profile_link = $config->get('display_profile_link', 1); $this->assignRef('display_profile_link', $display_profile_link); $wallalbumfile = JPATH_SITE . '/components/com_awdjomalbum/awdjomalbum.php'; if (file_exists($wallalbumfile)) // if com_awdjomalbum install then only { $query="Select * from #__awd_jomalbum_userinfo where userid=".$user->id; $db->setQuery($query); $rows=$db->loadObjectList(); $this->assignRef('albumuserinfo', $rows[0]); } parent::display($tpl); }