"
"alt" => null , // e.g. "text"
"tooltip" => "") );
}
if (( isset ( $sbConfig['poststats'] ) ? $sbConfig['poststats'] : $sbConfig['postStats'] ) && (($params->get('statPosts', '1')==2) || (($params->get('statPosts', '1')==1)&&($sbUserDetails !== false)))) {
$mi = array(); $mi["_UE_MENU_STATUS"][$params->get('statPostsText', "_UE_FORUM_TOTALPOSTS")]["_UE_FORUM_TOTALPOSTS"]=null;
$this->addMenu( array( "position" => "menuList" ,
"arrayPos" => $mi ,
"caption" => (($sbUserDetails !== false) ? $sbUserDetails->posts : "0") ,
"url" => "" ,
"target" => "" ,
"img" => null ,
"alt" => null ,
"tooltip" => "") );
}
if ($sbConfig['showkarma'] && ($sbUserDetails !== false) && (($params->get('statKarma', '1')==2)||(($params->get('statKarma', '1')==1)&&($sbUserDetails->karma!=0)))) {
$mi = array(); $mi["_UE_MENU_STATUS"][$params->get('statKarmaText', "_UE_FORUM_KARMA")]["_UE_FORUM_KARMA"]=null;
$this->addMenu( array( "position" => "menuList" ,
"arrayPos" => $mi ,
"caption" => $sbUserDetails->karma ,
"url" => "" ,
"target" => "" ,
"img" => null ,
"alt" => null ,
"tooltip" => "") );
}
}
/*
* Generates the menu and user status to display on the user profile by calling back $this->addMenu
* @param moscomprofilerTab $tab the tab database entry
* @param moscomprofilerUser $user the user being displayed
* @param int $ui 1 for front-end, 2 for back-end
* @return boolean either true, or false if ErrorMSG generated
*
function getMenuAndStatus( &$tab, &$user, $ui) {
if ( $this->com_name == 'com_kunena' ) {
global $fbConfig;
} else {
global $sbConfig;
$fbConfig =& $sbConfig;
}
$params=$this->params;
$newslettersRegList=$params->get('statDisplay', '1');
if ($newslettersRegList==1) {
if($this->config_filename) {
include_once ( $this->config_filename );
} else {
$this->_setErrorMSG(_UE_SBNOTINSTALLED);
return false;
}
$sbUserDetails = $this->_getSBstats($fbConfig, $user);
$this->_setStatusMenuSBstats($fbConfig, $user, $params, $sbUserDetails);
}
return true;
}
*/
/**
* ForumTab Internal method: sets User Status display according to $sbUserDetails for the $user
* @access private
* @param array sbConfig
* @param object user being displayed
* @param object sbUserDetails
*/
function & _getStats( $sbConfig, &$user, &$params, $sbUserDetails ) {
$stats = array();
if ( isset ( $sbConfig['showuserstats'] ) ? $sbConfig['showuserstats'] : $sbConfig['showstats'] ) {
if ($sbConfig['showranking'] && ($params->get('statRanking', '1') == 1) && ($sbUserDetails !== false)) {
$stats['forumrank'] = array( 'title' => $params->get('statRankingText', "_UE_FORUM_FORUMRANKING"),
'value' => $sbUserDetails->msg_userrank.($params->get('statRankingImg', '1')==1 ? $sbUserDetails->msg_userrankimg : "")
);
}
if ( ( isset ( $sbConfig['poststats'] ) ? $sbConfig['poststats'] : $sbConfig['postStats'] ) && (($params->get('statPosts', '1')==2) || (($params->get('statPosts', '1')==1)&&($sbUserDetails !== false)))) {
$stats['forumposts'] = array( 'title' => $params->get('statPostsText', "_UE_FORUM_TOTALPOSTS"),
'value' => (($sbUserDetails !== false) ? $sbUserDetails->posts : "0")
);
}
}
if ($sbConfig['showkarma'] && ($sbUserDetails !== false) && (($params->get('statKarma', '1')==2)||(($params->get('statKarma', '1')==1)&&($sbUserDetails->karma!=0)))) {
$stats['forumkarma'] = array( 'title' => $params->get('statKarmaText', "_UE_FORUM_KARMA"),
'value' => $sbUserDetails->karma
);
}
return $stats;
}
/**
* Generates the info for the custom fields for the forum
* @param moscomprofilerUser $user the user being displayed
* @return boolean either true, or false if ErrorMSG generated
*/
function getExtraFields( &$user ) {
$params = $this->params;
$newslettersRegList = $params->get('statDisplay', '1');
if ( $newslettersRegList == 1 ) {
if( $this->config_filename ) {
$fbConfig =& $this->_loadSbConfig();
$sbUserDetails = $this->_getSBstats( $fbConfig, $user );
return $this->_getStats( $fbConfig, $user, $params, $sbUserDetails );
} else {
$this->_setErrorMSG( _UE_SBNOTINSTALLED );
}
}
return null;
}
/**
* Generates the HTML to display the user profile tab
* @param moscomprofilerTab $tab the tab database entry
* @param moscomprofilerUser $user the user being displayed
* @param int $ui 1 for front-end, 2 for back-end
* @return mixed either string HTML for tab content, or false if ErrorMSG generated
*/
function getDisplayTab($tab,$user,$ui) {
global $_CB_framework, $_CB_database;
if ( $this->com_name == 'com_kunena' ) {
$base_url = $this->_getAbsURLwithParam(array(),'userProfile',false);
$fbunsub = cbGetParam( $_GET, 'fbunsubthread', '' );
if ( $fbunsub == '' ) {
$fbunsub = 'none';
}
switch ( $fbunsub ) {
case 'none':
break;
case 'all':
$this->_fbunsuball($user);
break;
default:
$fbunsub = (int) $fbunsub;
if ( $fbunsub ) {
$this->_fbunsubthread($user,$fbunsub);
}
break;
}
$fbunfav = cbGetParam( $_GET, 'fbunfavthread', '' );
if ( $fbunfav == '' ) {
$fbunfav = 'none';
}
switch ( $fbunfav ) {
case 'none':
break;
case 'all':
$this->_fbunfavall($user);
break;
default:
$fbunfav = (int) $fbunfav;
if ( $fbunfav ) {
$this->_fbunfavthread($user,$fbunfav);
}
break;
}
}
$return="";
$searchForm="";
if ($this->config_filename) {
$fbConfig =& $this->_loadSbConfig();
} else {
$return = _UE_SBNOTINSTALLED;
return $return;
}
$_CB_database->setQuery("SELECT id FROM #__menu WHERE link = " . $_CB_database->Quote( 'index.php?option=' . $this->com_name ) . " AND published = 1");
$Itemid = (int) $_CB_database->loadResult();
$return .= $this->_writeTabDescription( $tab, $user );
$params =& $this->params;
$newslettersRegList = $params->get( 'statDisplay', '1' );
$sbUserDetails = $this->_getSBstats( $fbConfig, $user );
if ( $newslettersRegList == 2 ) {
$return .= $this->_getDisplaySBstats( $fbConfig, $user, $params, $sbUserDetails );
}
$postsNumber = $params->get('postsNumber', '10');
$pagingEnabled = $params->get('pagingEnabled', 0);
$searchEnabled = $params->get('searchEnabled', 0);
$pagingParams = $this->_getPaging(array(),array("fposts_"));
if ($_CB_framework->myId() != $user->id) {
//determine visitors allowable threads based on session
$sql = "SELECT allowed FROM #__" . $this->sql_prefix . "_sessions WHERE userid = " . (int) $_CB_framework->myId() . " LIMIT 1";
$_CB_database->setQuery($sql);
//print $_CB_database->getQuery();
$allowedCats=$_CB_database->loadResult();
if($allowedCats==null) {
//get only the publicly accessible forums..
$_CB_database->setQuery( "SELECT id FROM #__" . $this->sql_prefix . "_categories WHERE published=1 AND pub_access=0");
$allowed_forums=$_CB_database->loadObjectList();
$i=0;
$allow_forum = array();
foreach ($allowed_forums as $af){
if (count ($allow_forum) == 0 ){
$allow_forum[0]=$af->id;
}
else {
$allow_forum[$i]=$af->id;
$i++;
}
}
$allowedCats=implode(",",$allow_forum);
}
if(strtolower($allowedCats)=='na') $allowedCats=null;
} else {
$allowedCats=null;
}
if ($pagingEnabled) {
if (!$searchEnabled) $pagingParams["fposts_search"]=null;
//Count for paging
// $query = "SELECT count(*) FROM #__" . $this->sql_prefix . "_messages WHERE userid=".$user->id
// .($pagingParams["fposts_search"] ? " AND subject LIKE '%".cbEscapeSQLsearch($this->_sbEscape($pagingParams["fposts_search"]))."%'"
// : "");
$query="SELECT COUNT(*)"
. "\n FROM #__" . $this->sql_prefix . "_messages AS a, "
. "\n #__" . $this->sql_prefix . "_categories AS b, #__" . $this->sql_prefix . "_messages AS c, #__" . $this->sql_prefix . "_messages_text AS d"
. "\n WHERE a.catid = b.id"
. "\n AND a.thread = c.id"
. "\n AND a.id = d.mesid"
. "\n AND a.hold = 0 AND b.published = 1"
. "\n AND a.userid=" . (int) $user->id
. ($allowedCats!=null ? "\n AND b.id IN ($allowedCats)" :"")
. ($pagingParams["fposts_search"] ? "\n AND (a.subject LIKE '%".cbEscapeSQLsearch($this->_sbEscape($pagingParams["fposts_search"]))."%'"
." OR d.message LIKE '%".cbEscapeSQLsearch($pagingParams["fposts_search"])."%')"
: "");
$_CB_database->setQuery($query);
$total = $_CB_database->loadResult();
if (!is_numeric($total)) $total = 0;
$userHasPosts = ($total>0 || ($pagingParams["fposts_search"] && ($sbUserDetails !== false) && $sbUserDetails->posts>0));
if ($pagingParams["fposts_limitstart"] === null) $pagingParams["fposts_limitstart"] = "0";
if ($postsNumber > $total) $pagingParams["fposts_limitstart"] = "0";
if ($searchEnabled) {
$searchForm = $this->_writeSearchBox($pagingParams, "fposts_", "style=\"float:right;\"", "class=\"inputbox\"" );
} else {
$pagingParams["fposts_search"] = "0";
}
} else {
$pagingParams["fposts_limitstart"] = "0";
$pagingParams["fposts_search"] = "0";
}
switch ($pagingParams["fposts_sortby"]) {
case "subject":
$order = "a.subject ASC, a.time DESC";
break;
case "category":
$order = "b.id ASC, a.time DESC";
break;
case "hits":
$order = "c.hits DESC, a.time DESC";
break;
case "date":
default:
$order = "a.time DESC";
break;
}
$query="SELECT a.* , b.id as category, b.name as catname, c.hits AS 'threadhits'"
. "\n FROM #__" . $this->sql_prefix . "_messages AS a, "
. "\n #__" . $this->sql_prefix . "_categories AS b, #__" . $this->sql_prefix . "_messages AS c, #__" . $this->sql_prefix . "_messages_text AS d"
. "\n WHERE a.catid = b.id"
. "\n AND a.thread = c.id"
. "\n AND a.id = d.mesid"
. "\n AND a.hold = 0 AND b.published = 1"
. "\n AND a.userid=" . (int) $user->id
. ($allowedCats!=null ? "\n AND b.id IN ($allowedCats)" :"")
. ($pagingParams["fposts_search"] ? "\n AND (a.subject LIKE '%".cbEscapeSQLsearch($this->_sbEscape($pagingParams["fposts_search"]))."%'"
." OR d.message LIKE '%".cbEscapeSQLsearch($pagingParams["fposts_search"])."%')"
: "")
. "\n ORDER BY " . $order
. "\n LIMIT " . (int) ( $pagingParams["fposts_limitstart"] ? $pagingParams["fposts_limitstart"] : 0 ) . "," . (int) $postsNumber;
$_CB_database->setQuery( $query );
//print $_CB_database->getQuery();
$items = $_CB_database->loadObjectList();
if(count($items) >0) {
if ($pagingParams["fposts_search"]) $title = sprintf(_UE_FORUM_FOUNDPOSTS,$total);
elseif ($pagingEnabled) $title = sprintf(_UE_FORUM_POSTS,$postsNumber);
else $title = sprintf(_UE_FORUM_LASTPOSTS,$postsNumber);
$return .= "";
$return .= $title;
// TW change - added following line of code
$return .= "
";
if ($pagingEnabled && $searchEnabled) $return .= $searchForm . "