function config($option, $show = '')
{
global $mtconf;
$database =& JFactory::getDBO();
# Get all config groups
$database->setQuery('SELECT * FROM #__mt_configgroup ' . ($show == 'all' ? '' : 'WHERE displayed = 1 ') . 'ORDER BY ordering ASC');
$configgroups = $database->loadResultArray();
# Get all configs
$database->setQuery('SELECT c.* FROM (#__mt_config AS c, #__mt_configgroup AS cg) ' . 'WHERE cg.groupname = c.groupname ' . ($show == 'all' ? '' : 'AND c.displayed = \'1\' ') . 'ORDER BY cg.ordering ASC, c.ordering');
$configs = $database->loadObjectList('varname');
# Map
$map = array();
$map[] = JHTML::_('select.option', "mapquest", "MapQuest");
$map[] = JHTML::_('select.option', "yahoomaps", "Yahoo! Maps");
$map[] = JHTML::_('select.option', "googlemaps", "Google Maps");
$map[] = JHTML::_('select.option', "googlemaps_ca", "Google Maps Canada");
$map[] = JHTML::_('select.option', "googlemaps_cn", "Google Maps China");
$map[] = JHTML::_('select.option', "googlemaps_fr", "Google Maps France");
$map[] = JHTML::_('select.option', "googlemaps_de", "Google Maps Germany");
$map[] = JHTML::_('select.option', "googlemaps_it", "Google Maps Italy");
$map[] = JHTML::_('select.option', "googlemaps_jp", "Google Maps Japan");
$map[] = JHTML::_('select.option', "googlemaps_es", "Google Maps Spain");
$map[] = JHTML::_('select.option', "googlemaps_uk", "Google Maps UK");
$lists['map'] = JHTML::_('select.genericlist', $map, 'map', 'class="inputbox" size="1"', 'value', 'text', $configs['map']->value);
# Image Library list
$imageLibs = array();
$imageLibs = detect_ImageLibs();
if (!empty($imageLibs['gd1'])) {
$thumbcreator[] = JHTML::_('select.option', 'gd1', 'GD Library ' . $imageLibs['gd1']);
}
$thumbcreator[] = JHTML::_('select.option', 'gd2', 'GD2 Library ' . (array_key_exists('gd2', $imageLibs) ? $imageLibs['gd2'] : ''));
$thumbcreator[] = JHTML::_('select.option', 'netpbm', isset($imageLibs['netpbm']) ? $imageLibs['netpbm'] : "Netpbm");
$thumbcreator[] = JHTML::_('select.option', 'imagemagick', isset($imageLibs['imagemagick']) ? $imageLibs['imagemagick'] : "Imagemagick");
$lists['resize_method'] = JHTML::_('select.genericlist', $thumbcreator, 'resize_method', 'class="text_area" size="3"', 'value', 'text', $configs['resize_method']->value);
# Sort Direction
$sort[] = JHTML::_('select.option', "asc", JText::_('Ascending'));
$sort[] = JHTML::_('select.option', "desc", JText::_('Descending'));
$lists['sort_direction'] = $sort;
# Category Order
$cat_order = array();
$cat_order[] = JHTML::_('select.option', '', JText::_(' '));
$cat_order[] = JHTML::_('select.option', "cat_name", JText::_('Name'));
$cat_order[] = JHTML::_('select.option', "cat_featured", JText::_('Featured'));
$cat_order[] = JHTML::_('select.option', "cat_created", JText::_('Created'));
$lists['cat_order'] = $cat_order;
# Listing Order
$listing_order = array();
$listing_order[] = JHTML::_('select.option', "link_name", JText::_('Name'));
$listing_order[] = JHTML::_('select.option', "link_hits", JText::_('Hits'));
$listing_order[] = JHTML::_('select.option', "link_votes", JText::_('Votes'));
$listing_order[] = JHTML::_('select.option', "link_rating", JText::_('Rating'));
$listing_order[] = JHTML::_('select.option', "link_visited", JText::_('Visit'));
$listing_order[] = JHTML::_('select.option', "link_featured", JText::_('Featured'));
$listing_order[] = JHTML::_('select.option', "link_created", JText::_('Created'));
$listing_order[] = JHTML::_('select.option', "link_modified", JText::_('Modified'));
$listing_order[] = JHTML::_('select.option', "address", JText::_('Address'));
$listing_order[] = JHTML::_('select.option', "city", JText::_('City'));
$listing_order[] = JHTML::_('select.option', "state", JText::_('State'));
$listing_order[] = JHTML::_('select.option', "country", JText::_('Country'));
$listing_order[] = JHTML::_('select.option', "postcode", JText::_('Postcode'));
$listing_order[] = JHTML::_('select.option', "telephone", JText::_('Telephone'));
$listing_order[] = JHTML::_('select.option', "fax", JText::_('Fax'));
$listing_order[] = JHTML::_('select.option', "email", JText::_('Email'));
$listing_order[] = JHTML::_('select.option', "website", JText::_('Website'));
$listing_order[] = JHTML::_('select.option', "price", JText::_('Price'));
$lists['listing_order'] = $listing_order;
# Review Order
$review_order[] = JHTML::_('select.option', '', JText::_(' '));
$review_order[] = JHTML::_('select.option', "rev_date", JText::_('Review date'));
$review_order[] = JHTML::_('select.option', "vote_helpful", JText::_('Total helpful votes'));
$review_order[] = JHTML::_('select.option', "vote_total", JText::_('Total votes'));
$lists['review_order'] = $review_order;
# User Access
$access = array();
$access[] = JHTML::_('select.option', "-1", JText::_('None'));
$access[] = JHTML::_('select.option', "0", JText::_('Public'));
$access[] = JHTML::_('select.option', "1", JText::_('Registered only'));
$lists['user_access'] = $access;
# User Access2
$lists['user_access2'] = array_merge($access, array(JHTML::_('select.option', "2", JText::_('Registered only except listing owner'))));
# SEF's link slug type
$sef_link_slug_type = array();
$sef_link_slug_type[] = JHTML::_('select.option', "1", JText::_('Alias'));
$sef_link_slug_type[] = JHTML::_('select.option', "2", JText::_('Link ID'));
$lists['sef_link_slug_type'] = $sef_link_slug_type;
/*
# Custom fields
$database->setQuery( 'SELECT * FROM #__mt_customfield' );
$customfields = $database->loadObjectList('cf_id');
*/
HTML_mtree::config($configs, $configgroups, $lists, $option);
}
function getChildren($cat_id, $cat_level)
{
global $mtconf;
$database =& JFactory::getDBO();
$cat_ids = array();
if ($cat_level > 0) {
$sql = "SELECT cat_id, cat_name, cat_parent, cat_cats, cat_links FROM #__mt_cats WHERE cat_published=1 && cat_approved=1 && cat_parent= " . $database->quote($cat_id) . ' ';
if (!$mtconf->get('display_empty_cat')) {
$sql .= "&& ( cat_cats > 0 || cat_links > 0 ) ";
}
$sql .= "\nORDER BY cat_name ASC ";
$database->setQuery($sql);
$cat_ids = $database->loadObjectList();
if (count($cat_ids)) {
foreach ($cat_ids as $cid) {
$children_ids = HTML_mtree::getChildren($cid->cat_id, $cat_level - 1);
$cat_ids = array_merge($cat_ids, $children_ids);
}
}
}
return $cat_ids;
}
