CB and K2 are probably the greatest extensions to grace Joomla.

I am trying to alter the cbauthortab to show k2 item links rather than the joomla articles and forward the author links in the k2 items to the users CB profile.

Does anybody have suggestions on how one would approach such a task?

Post edited by: krileon, at: 2010/11/18 20:55

I 've altered cb.authortab.php to fetch k2 table directly.
It works fine and shows k2 articles related to the user on cb tab.

[code:1]
$query = "SELECT a.id, a.catid, a.title, a.hits,a.created, ROUND( r.rating_sum / r.rating_count ) AS rating,r.rating_count";
if ( $jVer == 1 ) {
$query .= ', CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug,'
. ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug';
}
$query .= "\n FROM #__k2_items AS a"
. "\n LEFT JOIN #__k2_rating AS r ON r.itemID=a.id"
. "\n INNER JOIN #__k2_categories AS s ON s.id=a.catid OR s.parent = a.catid"
;
if ( $jVer == 1 ) {
$query .= "\n LEFT JOIN #__categories AS cc ON cc.id = a.catid";
}
$query .= "\n WHERE a.created_by=". (int) $user->id .""
. "\n AND a.published = 1 "
. "\n AND a.trash = 0 "
. "\n AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now')"
. "\n AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now')"
. "\n AND a.access <= " . (int) $_CB_framework->myCmsGid()
. "\n ORDER BY a.created DESC"
;
$_CB_database->setQuery( $query );

.....
finally change article anchor link to
.....
$url = cbSef( 'index.php?option=com_k2&view=item&id=' . item->id);

[/code:1]

<a href="onlyreviews.com/keith-harrell.html">keith harrell

Hello,
Where I must copy this code?