$database->setQuery( $sql );
$muh = $database->loadObjectList();
$total = count($muh);
//define pagination parameters
$limit = JRequest::getVar('limit', 5);
$limitstart = JRequest::getVar('limitstart', 0);
jimport( 'joomla.html.pagination' );
$pageNav = new JPagination($total, $limitstart, $limit);
$sql =
"SELECT "
. "\n v.viewer_id, "
. "lastview, "
. "\n v.viewscount, c.avatar, c.avatarapproved, c.banned, u.username, u.name "
. "\n FROM "
. "\n `#__comprofiler_views` v, `#__comprofiler` c, `#__users` u "
. "\n WHERE "
. "\n v.profile_id = " . $database->getEscaped($user->id)
. "\n AND c.id=v.viewer_id "
. "\n AND u.id=c.id "
. "\n AND c.id NOT IN (" . $database->getEscaped($LVexclusionlist) . ") "
. "\n ORDER BY "
. "\n v.lastview DESC ";
//. "\n LIMIT " . $database->getEscaped($listlimit);
$database->setQuery($sql, $limitstart, $limit);
$lastviews = $database->loadObjectList();
$viewercount=$total;
if($tab->description != null) {
$return .=
"<div class=\"tab_Description\">"
. unHtmlspecialchars(getLangDefinition($tab->description))
. "</div>";
}
$return =
"<table cellpadding=\"0\" cellspacing=\"1\" border=\"0\" width=\"100%\" align=\"center\" style='border: 1px solid #a10000;' >";
$colspan = 0;
Please Log in to join the conversation.
Please Log in to join the conversation.