I have several websites on the same db running on joomla 2.5. I would like to display the articles from a category (article +sub-category) that are from an other website but on the same db.
I was thinking to use the native joomla module that displays the articles from a category and to modified its php and ask it to pickup the category from an other table (bbb_tables)
Here is the helper.php of the native module (in the FTP) that displays articles of a category. (../module/display_articles_category ): it is programmed to play with the internal aaa_tables
"bbb_" is the DB I want the module to use so I guess I should add that piece of code somewhere:
$db = & JDatabase::getInstance($options);$options['prefix'] = 'bbb';
Somewhere around here : but how?
defined('_JEXEC') or die;
$com_path = JPATH_SITE.'/components/com_content/';
require_once $com_path.'router.php';
require_once $com_path.'helpers/route.php';
JModelLegacy::addIncludePath($com_path . '/models', 'ContentModel');
abstract class modArticlesCategoryHelper {
public static function getList(&$params) {
// Get an instance of the generic articles model
$articles = JModelLegacy::getInstance('Articles', 'ContentModel', array('ignore_request' => true));
// Set application parameters in model
$app = JFactory::getApplication();
$appParams = $app->getParams();
$articles->setState('params', $appParams);
Thanks