1
I Template di Joomla! 3 / Re:override css modulo [RISOLTO]
« il: 17 Mar 2016, 09:19:04 »
Grazie mille del chiarimento!
Questa sezione ti permette di visualizzare tutti i post inviati da questo utente. N.B: puoi vedere solo i post relativi alle aree dove hai l'accesso.
// This loads the module position
$document = JFactory::getDocument();
$renderer = $document->loadRenderer('modules');
$position = "YOURPOSITIONNAME";
$options = array('style' => 'raw');
echo $renderer->render($position, $options, null);
SELECT b.virtuemart_category_id, b.category_name
FROM jos_virtuemart_categories a, jos_virtuemart_categories_it_it b, jos_virtuemart_category_categories c
WHERE a.virtuemart_category_id = b.virtuemart_category_id AND b.virtuemart_category_id = c.category_child_id AND a.published = 1 AND c.category_parent_id = 174
ORDER BY b.category_name
$db = JFactory::getDBO();
// Create a new query object.
$query = $db -> getQuery(true);
$query -> select($db -> quoteName(array('b.virtuemart_category_id','b.category_name')));
$query -> from($db -> quoteName('#__virtuemart_categories a','#__virtuemart_categories_it_it b','#__virtuemart_category_categories c'));
$query -> where($db -> quoteName('a.virtuemart_category_id') . ' = ' . quoteName('b.virtuemart_category_id') . ' AND ' . quoteName('b.virtuemart_category_id') . ' = ' . quoteName('c.category_child_id') . ' AND ' . quoteName('a.published') . ' = 1 AND ' . quoteName('c.category_parent_id') . ' = ' . $category_id);
$query -> order($db->quoteName('b.category_name') . ' ASC');
$db->setQuery($query);
$results = $db-> loadAssocList();
|