setQuery( 'SELECT filetitle, id FROM #__downloads_files WHERE id = ' . $id ); return $db->loadResult(); } function getObjectLink($id) { $_Itemid = self::getItemid('com_remository'); $link = JoomlaTuneRoute::_( 'index.php?option=com_remository&func=fileinfo&id=' . $id . '&Itemid=' . $_Itemid ); return $link; } function getObjectOwner($id) { $db = JFactory::getDbo(); $db->setQuery( 'SELECT userid FROM #__downloads_files WHERE id = ' . $id ); $userid = $db->loadResult(); return $userid; } }