public static function getJoomlaTemplate($client = 'site')
{
static $template = array();
if (!array_key_exists($client, $template)) {
$clientId = $client == 'site' ? 0 : 1;
$db = DiscussHelper::getDbo();
if (DiscussHelper::isJoomla15()) {
$query = 'SELECT template FROM `#__templates_menu`' . ' WHERE client_id = ' . $db->quote($clientId) . ' AND menuid = 0';
} else {
$query = 'SELECT template FROM `#__template_styles` AS s' . ' LEFT JOIN `#__extensions` AS e ON e.type = `template` AND e.element=s.template AND e.client_id=s.client_id' . ' WHERE s.client_id = ' . $db->quote($clientId) . ' AND home = 1';
}
$db->setQuery($query);
// Fallback template
if (!($result = $db->loadResult())) {
$result = $client == 'site' ? 'beez_20' : 'bluestork';
}
$template[$client] = $result;
}
return $template[$client];
}
public static function getLanguageQuery()
{
if (DiscussHelper::isJoomla15()) {
return '';
}
$lang = JFactory::getLanguage()->getTag();
$langQuery = '';
if (!empty($lang) && $lang != '*') {
$db = DiscussHelper::getDBO();
$langQuery = ' AND (' . $db->nameQuote('language') . '=' . $db->Quote($lang) . ' OR ' . $db->nameQuote('language') . ' = ' . $db->Quote('*') . ' )';
}
return $langQuery;
}
