// example: return 23;

// IMPROVED VERSION FOR JOOMLA 1.5, SPECIFICALLY FOR GETTING CATEGORIES
// INCLUDING BLOG OR LIST STYLE CATEGORY PAGES

if ($option == "com_content" && $view == "article") {
//if ($option == "com_content") {
//if ($view == "article") {
//if (1==1) {
    /* if it's an article page without the catid mentioned in the url */
    $nullDate = $db->Quote($db->getNullDate());
    $my_id = $db->getEscaped((int)$id);
    $query = "SELECT created_by"
        . " FROM #__content WHERE id = '$my_id'";
    $db->setQuery( $query, 0, 1 );
    $row = $db->loadObject();
//    $category_id = $row->catid;
//    $section_id = $row->sectionid;
        $authorid = $row->created_by;
//echo $option;
//echo $view;

//echo "My ID: " . $my_id;       
//echo "Hello";
//echo $authorid;
        $query2 = "SELECT itemid, title FROM #__sobi2_item WHERE owner = " . $authorid;
//echo $query2;
    $db->setQuery( $query2, 0, 1 );
        $row = $db->loadObject();
        $authorsbiz = $row->title;
        $item = $row->itemid;
//        echo $item;
//      echo "See full Profile on " . $authorsbiz;
        $url = "http://mysite.com/index.php?option=com_ … 2Id=" . $item;
//        echo $url;
echo "*See full Profile on <a href='" .$url. "'>" . $authorsbiz . "</a>" ."*";
//print "<a href=\"http://www.link.com/=$id\">$id</a>";
}

///////////////////////////////////