<?php }?> </a> </span> <span class="profileStatus" id="awd_profile_status"> <?php if(isset($this->latestPost->message)) echo AwdwallHelperUser::showSmileyicons($this->latestPost->message); ?> </span> <?php if($user->id!=$this->wuid){ if(!JsLib::isFriend($user->id, $this->wuid) && !JsLib::getFriendStatus($user->id, $this->wuid)){?> <span id="add_as_friend" class="add_as_friend"><a href="javascript:void(0);" onclick="openAddFriendBox('<?php echo JURI::base().'index.php?option=com_awdwall&task=addfriend&user_to=' . $this->wuid;?>');" title="<?php echo JText::_('Add as Friend');?>"><?php echo JText::_('Add as Friend');?></a></span> <?php } if(JsLib::getFriendStatus($user->id, $this->wuid)){ ?> <span id="add_as_friend" class="add_as_friend"><a href="javascript:void(0);" ><?php echo JText::_('Waiting for authorization');?></a></span> <?php } } ?> <!-- hightlightbox start here --> <?php if($this->display_hightlightbox) { AwdwallHelperUser::getHightlightbox($this->wuid); } ?> <!-- hightlightbox end here --> <?php if($showFunc){?>
function display($tpl = null) { $mainframe =& JFactory::getApplication(); $itemId = AwdwallHelperUser::getComItemId(); $task = JRequest::getCmd('task', ''); $page = JRequest::getCmd('awd_page', 0); $wid = JRequest::getInt('wid', 0); $layout = JRequest::getCmd('layout', ''); $wallalbumfile = JPATH_SITE . '/components/com_awdjomalbum/awdjomalbum.php'; //echo $wallalbumfile; $jomalbumexist=''; if (file_exists($wallalbumfile)) // if com_awdjomalbum install then only { $jomalbumexist=1; } $this->assignRef('jomalbumexist', $jomalbumexist); $hwdvideosharefile = JPATH_SITE . '/components/com_hwdvideoshare/hwdvideoshare.php'; $hwdvideoshare=''; if (file_exists($hwdvideosharefile)) // if com_awdjomalbum install then only { $hwdvideoshare=1; } $this->assignRef('hwdvideoshare', $hwdvideoshare); //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 #__extensions WHERE element = "com_awdwall" and type="component"'); $params = json_decode( $db->loadResult(), true ); if(empty($params)) { $params['temp'] = 'default'; $params['width'] = '725'; $params['email_auto'] = '0'; $params['video_lightbox'] = '0'; $params['image_lightbox'] = '1'; $params['display_name'] = '1'; $params['nof_post'] = '15'; $params['nof_comment'] = '3'; $params['bg_color'] = '#FFFFFF'; $params['image_ext'] = 'gif,png,jpg,jpge'; $params['file_ext'] = 'doc,docx,pdf,xls,txt'; $params['privacy'] = '0'; $params['nof_friends'] = '4'; $params['timestamp_format'] = '1'; $params['access_level'] = '1'; $params['display_online'] = '0'; $params['seo_format'] = '0'; $params['display_video'] = '1'; $params['display_image'] = '1'; $params['display_music'] = '1'; $params['display_link'] = '1'; $params['display_file'] = '1'; $params['display_trail'] = '0'; $params['dt_format'] = 'g:i A l, j-M-y'; $params['nof_groups'] = '4'; $params['nof_invite_members'] = '10'; $params['display_hightlightbox'] = '0'; // store the combined result $paramsString = json_encode( $params ); $db->setQuery('UPDATE #__extensions SET params = ' .$db->quote( $paramsString ) .' WHERE element = "com_awdwall" and type="component" ' ); if (!$db->query()) { return JError::raiseWarning( 500, $db->getError() ); } } $db->setQuery("SELECT params FROM #__menu WHERE `link`='".$link."'"); $awdparams = json_decode( $db->loadResult(), true ); if(empty($awdparams)) { $awdparams['color1'] = 'FFFFFF'; $awdparams['color2'] = '111111'; $awdparams['color3'] = '333333'; $awdparams['color4'] = '8C8C8C'; $awdparams['color5'] = 'EAE7E0'; $awdparams['color6'] = '111111'; $awdparams['color7'] = 'FFFFFF'; $awdparams['color8'] = '111111'; $awdparams['color9'] = 'EAE7E0'; $awdparams['color10'] = 'FFFFFF'; $awdparams['color11'] = '475875'; $awdparams['color12'] = 'FFFFFF'; $awdparams['color13'] = 'B0C3C5'; $awdparams['color14'] = 'E1DFD9'; // store the combined result $paramsString = json_encode( $awdparams ); $db->setQuery('UPDATE #__menu SET params = ' .$db->quote( $paramsString ) .' WHERE link = "'.$link.'"' ); // echo 'UPDATE #__menu SET params = ' .$db->quote( $paramsString ) .' WHERE link = "'.$link.'"'; if (!$db->query()) { return JError::raiseWarning( 500, $db->getError() ); } } $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]; } //usertype of login user... $user = &JFactory::getUser(); $query="SELECT group_id FROM #__user_usergroup_map where user_id=".$user->id; $db->setQuery($query); $user_groupidList= $db->loadObjectList(); //usertype access $groupList=array(5,6,7,8); $user_groupid=''; foreach ($user_groupidList as $ugroupid) { if(in_array($ugroupid->group_id,$groupList)){ $user_groupid='Can add article'; } } $admin_groupid=array(7,8); $can_delete=''; foreach ($user_groupidList as $ugroupid) { if(in_array($ugroupid->group_id,$admin_groupid)){ $can_delete=1; } } if($owner) $can_delete=1; $this->assignRef('can_delete', $can_delete); // get configuration from database //$config = &JComponentHelper::getParams('com_awdwall'); $app = JFactory::getApplication('site'); $config = & $app->getParams('com_awdwall'); $postLimit = $config->get('nof_post', 15); $commentLimit = $config->get('nof_comment', 3); $displayName = $config->get('display_name', 1); $videoLightbox = $config->get('video_lightbox', 0); $width = $config->get('width', 725); $imageLightbox = $config->get('image_lightbox', 1); $privacy = $config->get('privacy', 0); $displayVideo = $config->get('display_video', 1); $displayImage = $config->get('display_image', 1); $displayMusic = $config->get('display_music', 1); $displayLink = $config->get('display_link', 1); $displayFile = $config->get('display_file', 1); $displayTrail = $config->get('display_trail', 0); $displayJing = $config->get('display_jing', 1); $displayEvent = $config->get('display_event', 1); $displayArticle = $config->get('display_article', 0); $displayCommentLike=$config->get('displayCommentLike', 1); $display_filterwall = $config->get('display_filterwall', 1); $display_filtervideo = $config->get('display_filtervideo', 1); $display_filterimage = $config->get('display_filterimage', 1); $display_filtermusic = $config->get('display_filtermusic', 1); $display_filterlink = $config->get('display_filterlink', 1); $display_filterfile = $config->get('display_filterfile', 1); $display_filterjing = $config->get('display_filterjing', 1); $display_filtertrail = $config->get('display_filtertrail', 0); $display_filterevent = $config->get('display_filterevent', 1); $display_filterarticle = $config->get('display_filterarticle', 0); $display_hightlightbox = $config->get('display_hightlightbox', 0); $display_filterpm = $config->get('display_filterpm', 0); $displayPm = $config->get('display_pm', 1); $displayShare = $config->get('display_share', 1); $displayLike = $config->get('display_like', 1); $moderator_users = $config->get('moderator_users', ''); $display_group = $config->get('display_group', 1); $display_group_for_moderators = $config->get('display_group_for_moderators', 1); $moderator_users=explode(',',$moderator_users); $display_profile_link = $config->get('display_profile_link', 1); $this->assignRef('display_profile_link', $display_profile_link); $fields = $config->get('fieldids', ''); $arrTask = array(); $arrTask[] = 'videos'; $arrTask[] = 'images'; $arrTask[] = 'trails'; $arrTask[] = 'music'; $arrTask[] = 'links'; $arrTask[] = 'files'; $arrTask[] = 'jing'; $arrTask[] = 'events'; $arrTask[] = 'article'; $user = &JFactory::getUser(); // get userid from url $wuid = JRequest::getInt('wuid', 0); // get all msg from databases $wallModel = & $this->getModel('wall'); // build where clause $where = array(); if($task == 'videos') $where[] = 'type = "video"'; elseif($task == 'images') $where[] = 'type = "image"'; elseif($task == 'trails') $where[] = 'type = "trail"'; elseif($task == 'pm') $where[] = 'is_pm = 1'; elseif($task == 'music') $where[] = 'type = "mp3"'; elseif($task == 'links') $where[] = 'type = "link"'; elseif($task == 'files') $where[] = 'type = "file"'; elseif($task == 'jing') $where[] = 'type = "jing"'; elseif($task == 'events') $where[] = 'type = "event"'; elseif($task == 'article') $where[] = 'type = "article"'; if($task == 'friends') $where[] = 'aw.reply = 0'; else $where[] = 'reply = 0'; if($wuid){ if($task == 'friends') $where[] = '(aw.user_id = ' . (int)$wuid .' OR aw.commenter_id = ' . (int)$wuid . ' )'; else $where[] = '(user_id = ' . (int)$wuid .' OR commenter_id = ' . (int)$wuid . ' )'; if($wuid != $user->id){ if($task == 'friends') $where[] = '(IF(aw.is_pm=1, aw.commenter_id = ' . $user->id . ', 1))'; else $where[] = '(IF(is_pm=1, commenter_id = ' . $user->id . ', 1))'; } }else{ if($task == 'friends') $where[] = 'aw.is_pm = 0'; else $where[] = 'is_pm = 0'; } if($wid){ if($task == 'friends') $where[] = 'aw.id = '. $wid; else $where[] = 'id = '. $wid; } //Private group id $sql='select id from #__awd_groups where privacy="2"'; $db->setQuery($sql); $private_group=$db->loadObjectList(); for($i=0;$i<count($private_group);$i++) { $grouplist[$i]=$private_group[$i]->id; } if($grouplist) $grpid=implode(",",$grouplist); // if($layout == 'mywall') // { // if($user->id!=$wuid && $grpid) // { // $where[] = '(IF(group_id !=" null", group_id NOT IN ('.$grpid.'), id))'; // } // } if($layout == 'mywall') { //$where[] = 'group_id IS NULL or group_id=0'; $where[] = 'group_id IS NULL '; } $where[] = 'wall_date IS NOT NULL'; //get total event attend list of user $sql= 'select wall_id FROM #__awd_wall_event_attend where user_id = ' . $user->id . ' AND status = 1'; $db->setQuery($sql); $walleventlist=$db->loadObjectList(); for($i=0;$i<count($walleventlist);$i++) { $eventlist[$i]=$walleventlist[$i]->wall_id; } if($eventlist) $wallid=implode(",",$eventlist); //get friend list $sql= 'select connect_from FROM #__awd_connection where connect_to = ' . $user->id . ' AND status = 1 AND pending=0'; $db->setQuery($sql); $friendlist=$db->loadObjectList(); for($i=0;$i<count($friendlist);$i++) { $friend=$friendlist[$i]; $list1[$i]=$friend->connect_to; $list1[$i]=$friend->connect_from; } $friends=implode(",",$list1); //friend of friend list of user if($friends) $sql= 'select connect_from FROM #__awd_connection where connect_to in (' . $friends . ') AND status = 1 AND pending=0'; //echo $sql; $db->setQuery($sql); $friendoffriendlist=$db->loadObjectList(); for($i=0;$i<count($friendoffriendlist);$i++) { $friendoffriend=$friendoffriendlist[$i]; //$list2[$i]=$friendoffriend->connect_to; $list2[$i]=$friendoffriend->connect_from; } $friendoffriends=implode(",",$list2); if($friends != '') { $friendsuser = $friends.','.$user->id; } else $friendsuser = $user->id; if($friendoffriends != '') $friendoffriendsuser = $friendoffriends.','.$user->id; else $friendoffriendsuser = $user->id; //Wall posts by friends $sql='select id from #__awd_wall where commenter_id IN (' . $friendsuser . ')'; $db->setQuery($sql); $friendsPost=$db->loadObjectList(); for($i=0;$i<count($friendsPost);$i++) { $friendPost=$friendsPost[$i]; $fPostslist[$i]=$friendPost->id; } $fPosts=implode(",",$fPostslist); //Wall posts by friends of friends $sql='select a.id as wallid from #__awd_wall as a left join #__awd_wall_privacy as b on a.id=b.wall_id where a.commenter_id IN (' . $friendoffriendsuser . ') AND b.privacy="2"' ; //echo $sql; $db->setQuery($sql); $fofriendsPost=$db->loadObjectList(); for($i=0;$i<count($fofriendsPost);$i++) { $foffriendPost=$fofriendsPost[$i]; $fofPostslist[$i]=$foffriendPost->wallid; } $fofPosts=implode(",",$fofPostslist); $totalPosts=''; if($fofPosts !='' && $totalPosts!='') $totalPosts=$totalPosts.','.$fofPosts; if($fofPosts !='' && $totalPosts=='') $totalPosts=$fofPosts; if($fPosts !='' && $totalPosts=='') $totalPosts=$fPosts; if($fPosts !='' && $totalPosts!='') $totalPosts=$totalPosts.','.$fPosts; //total Wall posts under privacy if($totalPosts) $whrprivacy=' and wall_id not in ('.$totalPosts.')'; $sql='select wall_id from #__awd_wall_privacy where privacy!="0" '.$whrprivacy.' order by wall_id'; $db->setQuery($sql); $privacyPOsts=$db->loadObjectList(); for($i=0;$i<count($privacyPOsts);$i++) { $privacyPOst=$privacyPOsts[$i]; $privacyPOstlist[$i]=$privacyPOst->wall_id; } $privacyPOsts=implode(",",$privacyPOstlist); if($wuid!=$user->id) { if(in_array($wuid,$friendlist)) { } else if(in_array($wuid,$friendoffriendlist)) { $where[]= ' id NOT IN (select a.id as wallid from #__awd_wall as a left join #__awd_wall_privacy as b on a.id=b.wall_id where (a.commenter_id ='.$wuid.' or a.user_id='.$wuid.') AND b.privacy="1")'; } else { $where[]= ' id NOT IN (select a.id as wallid from #__awd_wall as a left join #__awd_wall_privacy as b on a.id=b.wall_id where (a.commenter_id ='.$wuid.' or a.user_id='.$wuid.') AND (b.privacy="1" or b.privacy="2"))'; } } $whr=array(); if($fPosts !='') { $whr[]= '((id IN (select wall_id FROM #__awd_wall_privacy where privacy = "1" and wall_id in (' .$fPosts. '))))'; } if($totalPosts!='') $whr[]= '((id IN (select wall_id FROM #__awd_wall_privacy where privacy = "2" and wall_id in (' .$totalPosts. '))))'; $whr[]= '((id IN (select wall_id FROM #__awd_wall_privacy where privacy = "0")))'; if($wid!='' || $layout==mywall) { } else { if($privacyPOsts) $where[]= '((id NOT IN ('.$privacyPOsts.')))'; } if((int)$privacy==1){ if($layout == 'main'){ $where[] = '((commenter_id IN (' .$friendsuser. ')) OR (user_id = ' . $user->id . ' OR commenter_id = ' . $user->id . ') OR (group_id IS NOT NULL))'; }else{ $where[] = '((commenter_id IN (' .$friendsuser. ')) OR (user_id = ' . $user->id . ' OR commenter_id = ' . $user->id . '))'; } } if((int)$privacy==2){ if($friendoffriends=='') $friendoffriends=$user->id; if($friendoffriends!='' && $friends!='') { $friendoffriends=$friendoffriends.','.$friends; } if($friendoffriends=='' && $friends!='') { $friendoffriends=$friends; } if($layout == 'main'){ $where[] = '((commenter_id IN ('.$friendoffriends.')) OR (user_id = ' . $user->id . ' OR commenter_id = ' . $user->id . ') OR (group_id IS NOT NULL))'; }else{ $where[] = '((commenter_id IN (' .$friendoffriends. ')) OR (user_id = ' . $user->id . ' OR commenter_id = ' . $user->id . '))'; } } $where = count($where) ? ' WHERE ' . implode( ' AND ', $where ) : ''; if($_REQUEST['attendevent'] && $wallid) { $where =$where. ' OR id IN ('.$wallid.')'; } $whr = count($whr) ? ' OR ' . implode( ' OR ', $whr ) : ''; if($task!='' || $wid!='' || $layout==mywall) $where =$where; else $where =$where . $whr; $offset = $page*$postLimit; if($task == 'friends'){ $msgs = $wallModel->getAllMsgFriends($postLimit, $where, $offset); $nofMsgs = $wallModel->countMsgFriends($where); }else{ $msgs = $wallModel->getAllMsg($postLimit, $where, $offset, $privacy); $nofMsgs = $wallModel->countMsg($where, $privacy); } // if wid != 0 set page title for share link if($wid && isset($msgs[0])){ $document =& JFactory::getDocument(); $pageTitle = preg_replace("/\<a([^>]*)\>([^<]*)\<\/a\>/i", "$2", $msgs[0]->message); if($msgs[0]->type == 'video'){ $video = $wallModel->getVideoInfoByWid($msgs[0]->id); $pageTitle = $video->title; } if($msgs[0]->type == 'image'){ $image = $wallModel->getImageInfoByWid($msgs[0]->id); $pageTitle = $image->name; } if($msgs[0]->type == 'mp3'){ $mp3 = $wallModel->getMp3InfoByWid($msgs[0]->id); $pageTitle = $mp3->title; } if($msgs[0]->type == 'link'){ $link = $wallModel->getLinkInfoByWid($msgs[0]->id); $pageTitle = $link->title; } if($msgs[0]->type == 'file'){ $file = $wallModel->getFileInfoByWid($msgs[0]->id); $pageTitle = $file->title; } if($msgs[0]->type == 'jing'){ $jing = $wallModel->getJingInfoByWid($msgs[0]->id); $pageTitle = $jing->jing_title; } if($msgs[0]->type == 'event'){ $event = $wallModel->getEventInfoByWid($msgs[0]->id); $pageTitle = $event->title; } if($msgs[0]->type == 'article'){ $article = $wallModel->getArticleInfoByWid($msgs[0]->id); $pageTitle = $article->title; } $cName = AwdwallHelperUser::getDisplayName($msgs[0]->commenter_id); $pageTitle = addslashes(htmlspecialchars($pageTitle)); $document->setTitle($pageTitle); $document->setDescription('Wrote by ' . $cName); } // Load the form validation behavior JHTML::_('behavior.formvalidation'); // set receiver_id = user->id if wuid = 0 if($wuid == 0) $wuid = $user->id; if($layout == 'mywall' || $layout == 'cbmywall'){ require_once (JPATH_COMPONENT . DS . 'libraries' . DS . 'jslib.php'); // check friend to view // check privacy $isFriend = ''; $showPosts = 1; $friendStatus = 1; if((int)$privacy == 1){ if((int)$wuid != (int)$user->id){ $showPosts = JsLib::isFriend($user->id, $wuid); } if(!(int)$showPosts){ $wallUserName = AwdwallHelperUser::getDisplayName($wuid); //$mainframe->redirect(JRoute::_('index.php?option=com_awdwall&view=awdwall&layout=main&Itemid=' . $itemId, false), JText::sprintf("FRIEND TO VIEW USER WALL", $wallUserName)); } } if((int)$privacy == 2){ if((int)$wuid != (int)$user->id){ $showPosts = JsLib::isFriendOfFriend($user->id, $wuid); } } if((int)$wuid != (int)$user->id){ $isFriend = JsLib::isFriend($user->id, $wuid); $friendStatus = JsLib::getFriendStatus($user->id, $wuid); } $latestPost = $wallModel->getLatestPostByUserId($wuid); $this->assignRef('latestPost', $latestPost); $basicInfo = JsLib::getUserBasicInfo($wuid, $fields); $totalFriends = JsLib::countFriends($wuid); $friendLimit = (int)$config->get('nof_friends', 4); if($friendLimit > 6) $friendLimit = 6; $friends = JsLib::getAllFriends($wuid, $friendLimit); // get 4 first groups to display require_once (JPATH_COMPONENT . DS . 'models' . DS . 'group.php'); $where = array(); $where[] = 'ag.creator = ' . $wuid . ' OR agm.user_id =' . $wuid; $where = count($where) ? ' WHERE ' . implode( ' AND ', $where ) : ''; $groups = AwdwallModelGroup::getAllGrps($where, 4, 0); $this->assignRef('groups', $groups); // get friends need to approval $pendingFriends = JsLib::getPendingFriends($user->id); // get groups need to approval //$pendingGroups = JsLib::getPendingGroups($user->id); $this->assignRef('pendingFriends', $pendingFriends); $this->assignRef('pendingGroups', $pendingGroups); $this->assignRef('basicInfo', $basicInfo); $this->assignRef('totalFriends', $totalFriends); $this->assignRef('friends', $friends); $this->assignRef('isFriend', $isFriend); $this->assignRef('showPosts', $showPosts); $this->assignRef('friendStatus', $friendStatus); } if((int)$privacy == 1 || (int)$privacy == 2){ require_once (JPATH_COMPONENT . DS . 'libraries' . DS . 'jslib.php'); } //Userinfo of login user $userinfo = AwdwallHelperUser::getUserInfo($wuid); $this->assignRef('userinfo', $userinfo); //Total private message of user $totalpm=$wallModel->countpm($user->id); //echo $totalpm; // check group require_once (JPATH_COMPONENT . DS . 'models' . DS . 'group.php'); $groupModel = new AwdwallModelGroup(); //Total groups created by user $myGrps = $groupModel->getMyGrps($wuid); $totalmygroup=count($myGrps); //Count Event attend by user $query="Select count(*) from #__awd_wall_event_attend as a left join #__awd_wall as b on a.wall_id=b.id where b.wall_date IS NOT NULL and a.user_id =".$user->id." and status='1' and b.user_id!=".$user->id; $db->setQuery($query); $eventOfuser=$db->loadResult(); //Count Event posted by user $query="Select count(*) from #__awd_wall where user_id =".$user->id." and type='event' and wall_date IS NOT NULL "; $db->setQuery($query); $eventpostOfuser=$db->loadResult(); $totaleventOfuser=$eventOfuser+$eventpostOfuser; $this->assignRef('totaleventOfuser', $totaleventOfuser); $this->assignRef('totalmygroup', $totalmygroup); $this->assignRef('groupModel', $groupModel); $this->assignRef('totalpm', $totalpm); $this->assignRef('color', $color); $this->assignRef('displayName', $displayName); $this->assignRef('wuid', $wuid); $this->assignRef('msgs', $msgs); $this->assignRef('wallModel', $wallModel); $this->assignRef('videoLightbox', $videoLightbox); $this->assignRef('imageLightbox', $imageLightbox); $this->assignRef('task', $task); $this->assignRef('nofMsgs', $nofMsgs); $this->assignRef('page', $page); $this->assignRef('postLimit', $postLimit); $this->assignRef('commentLimit', $commentLimit); $this->assignRef('privacy', $privacy); $this->assignRef('displayVideo', $displayVideo); $this->assignRef('displayImage', $displayImage); $this->assignRef('displayMusic', $displayMusic); $this->assignRef('displayLink', $displayLink); $this->assignRef('displayFile', $displayFile); $this->assignRef('displayTrail', $displayTrail); $this->assignRef('displayJing', $displayJing); $this->assignRef('displayEvent', $displayEvent); $this->assignRef('displayCommentLike', $displayCommentLike); $this->assignRef('display_hightlightbox', $display_hightlightbox); $this->assignRef('displayArticle', $displayArticle); $this->assignRef('display_filterwall', $display_filterwall); $this->assignRef('display_filtervideo', $display_filtervideo); $this->assignRef('display_filterimage', $display_filterimage); $this->assignRef('display_filtermusic', $display_filtermusic); $this->assignRef('display_filterlink', $display_filterlink); $this->assignRef('display_filterfile', $display_filterfile); $this->assignRef('display_filterjing', $display_filterjing); $this->assignRef('display_filtertrail', $display_filtertrail); $this->assignRef('display_filterevent', $display_filterevent); $this->assignRef('display_filterarticle', $display_filterarticle); $this->assignRef('display_filterpm', $display_filterpm); $this->assignRef('displayPm', $displayPm); $this->assignRef('displayShare', $displayShare); $this->assignRef('displayLike', $displayLike); $this->assignRef('moderator_users', $moderator_users); $this->assignRef('display_group', $display_group); $this->assignRef('display_group_for_moderators', $display_group_for_moderators); $this->assignRef('arrTask', $arrTask); $this->assignRef('groupList', $groupList); $this->assignRef('user_groupid', $user_groupid); //joomla categorylist $query = "SELECT id AS value, title AS text FROM #__categories WHERE extension='com_content'"; //echo $query ; $db->setQuery($query); $catrows = $db->loadObjectList(); if(count($catrows)) { $types1[] = JHTML::_('select.option', '0', '- '. JText::_( 'Select Category' ) .' -' ); foreach( $db->loadObjectList() as $obj ) { $types1[] = JHTML::_('select.option', $obj->value, JText::_( $obj->text ) ); } $lists['catid'] = JHTML::_('select.genericlist', $types1, 'catid', 'class="inputbox" style="width:150px; height:20px; font-size:14px; " size="1" ', 'value', 'text', "$catid" ); } $this->assignRef('lists', $lists); // add modal box joomla // JHTML::_('behavior.modal'); //Select AM PM... $amPmSelect = array(); $amPmSelect[] = JHTML::_('select.option', 'AM', "am" ); $amPmSelect[] = JHTML::_('select.option', 'PM', "pm" ); $startAmPmSelect = JHTML::_('select.genericlist', $amPmSelect , 'starttime-ampm', array('class'=>'required inputbox','style'=>'width:50px !important;'), 'value', 'text', '' , false ); $endAmPmSelect = JHTML::_('select.genericlist', $amPmSelect , 'endtime-ampm', array('class'=>'required inputbox','style'=>'width:50px !important;'), 'value', 'text', '' , false ); $this->assignRef('startAmPmSelect', $startAmPmSelect); $this->assignRef('endAmPmSelect', $endAmPmSelect); //Select Hour... for($i = 1; $i <= 12; $i++) { $hours[] = JHTML::_('select.option', $i, sprintf( "%02d" ,$i) ); } $startHourSelect = JHTML::_('select.genericlist', $hours, 'starttime-hour', array('class'=>'required inputbox','style'=>'width:50px !important;'), 'value', 'text', '' , false ); $endHourSelect = JHTML::_('select.genericlist', $hours, 'endtime-hour', array('class'=>'required inputbox','style'=>'width:50px !important;'), 'value', 'text', '' , false ); $this->assignRef('startHourSelect', $startHourSelect); $this->assignRef('endHourSelect', $endHourSelect); //Select Minute... $minutes = array(); $minutes[] = JHTML::_('select.option', "00", "00" ); $minutes[] = JHTML::_('select.option', 15, "15" ); $minutes[] = JHTML::_('select.option', 30, "30" ); $minutes[] = JHTML::_('select.option', 45, "45" ); $startMinSelect = JHTML::_('select.genericlist', $minutes , 'starttime-minute', array('class'=>'required inputbox','style'=>'width:50px !important;'), 'value', 'text', '' , false ); $endMinSelect = JHTML::_('select.genericlist', $minutes , 'endtime-minute', array('class'=>'required inputbox','style'=>'width:50px !important;'), 'value', 'text', '' , false ); $this->assignRef('startMinSelect', $startMinSelect); $this->assignRef('endMinSelect', $endMinSelect); $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=".$wuid; $db->setQuery($query); $rows=$db->loadObjectList(); $this->assignRef('albumuserinfo', $rows[0]); } parent::display($tpl); }