setQuery('SELECT post_title, id FROM #__blog_postings WHERE id = ' . $id); return $db->loadResult(); } function getObjectLink($id) { $link = 'index.php?option=com_blog&view=comments&pid='. $id; require_once(JPATH_SITE.DS.'includes'.DS.'application.php'); $component = JComponentHelper::getComponent('com_blog'); $menus = JApplication::getMenu('site'); $items = $menus->getItems('componentid', $component->id); if (count($items)) { $link .= "&Itemid=" . $items[0]->id; } $link = JRoute::_($link); return $link; } function getObjectOwner($id) { $db = JFactory::getDbo(); $query = "SELECT user_id FROM #__blog_postings WHERE id = " . $id; $db->setQuery( $query ); $userid = $db->loadResult(); return intval($userid); } }