too many friends

12 years 10 months ago #81122 by krileon
Replied by krileon on topic Re:too many friends
Done. ;)

Open: [code:1]/components/com_comprofiler/comprofiler.html.php[/code:1]

[code:1] // Tab 1: Manange Connections:
echo $tabs->startTab("myCon",_UE_MANAGECONNECTIONS,"connections"«»);

Add the following directly below it:
global $database, $my;
$cbCon = new cbConnection($my->id);
$total = $cbCon->getConnectionsCount($my->id);
$connectionsNumber = 10;
$pagingParams = $tabs->_getPaging(array(),array("connections_"«»));
if ($pagingParams["connections_limitstart"] === null)
$pagingParams["connections_limitstart"] = "0";
if ($connectionsNumber > $total)
$pagingParams["connections_limitstart"] = "0";
$query = "SELECT DISTINCT m.*,,,u.username,u.lastvisitDate,c.avatar,c.avatarapproved,, IF(s.session_id=null,0,1) AS 'isOnline' "
. "\n FROM #__comprofiler_members AS m"
. "\n LEFT JOIN #__comprofiler AS c ON"
. "\n LEFT JOIN #__users AS u ON"
. "\n LEFT JOIN #__session AS s ON"
. "\n WHERE m.referenceid=". (int) $my->id .""
. "\n AND c.approved=1 AND c.confirmed=1 AND c.banned=0 AND u.block=0 AND m.accepted=1"
. "\n LIMIT ".($pagingParams["connections_limitstart"]?$pagingParams["connections_limitstart"]:"0"«»).",".$connectionsNumber;
$database->setQuery( $query );
$connections = $database->loadObjectList();

Locate: [code:1]foreach($connections AS $connection) {[/code:1]

Scroll to: [code:1]echo "</table><br />";[/code:1]

Add the following directly below it:
[code:1] if ($connectionsNumber < $total) echo "<div style='width:95%;text-align:center;'>".$tabs->_CONSwritePaging($pagingParams,"connections_",$connectionsNumber,$total)."</div>";

Default connection limit is 10 per page. You may change this by editing:
[code:1]$connectionsNumber = 10;[/code:1]


[code:1]function _writePaging[/code:1]

Add the following function:
[code:1] function _CONSwritePaging( $pagingParams, $postfix, $limit, $total, $task = 'manageConnections' )
$base_url = 'index.php?option=com_comprofiler&task='.$task;
$prefix = $this->_getPrefix( $postfix );
return writePagesLinks( $pagingParams[$postfix . 'limitstart'], $limit, $total, $base_url, null, $prefix );

Save and that's it. Manage Connections tab is now paginated.

Post edited by: krileon, at: 2008/12/02 18:17

Post edited by: krileon, at: 2008/12/02 18:46

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

12 years 8 months ago #86243 by rc03tl
Replied by rc03tl on topic Re:too many friends
I added this fix but I ended up with an error message on line 1573 for an undefined task
specifically with this line
$total = $cbCon->getConnectionsCount($my->id);
crashed the whole manage connections page so I went back to original

I would love to paginate this feature as well. 8]

Thanks in advance

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.188 seconds