public static function get_country_name($country_code) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $language = CJFunctions::get_country_language(); $query->select('country_name')->from('#__corejoomla_countries')->where('country_code = ' . $db->q($country_code) . ' and language = ' . $db->q($language)); $db->setQuery($query); $country = $db->loadResult(); return $country; }