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; }