/**
* Get a list of the available content language items.
*
* @param boolean $all True to include All (*)
* @param boolean $translate True to translate All
*
* @return string
*
* @since 11.1
*
* @see JFormFieldContentLanguage
*/
public static function existing($all = false, $translate=false)
{
if (empty(self::$items)) {
// Get the database object and a new query object.
$db = JFactory::getDBO();
$query = $db->getQuery(true);
// Build the query.
$query->select('a.lang_code AS value, a.title AS text, a.title_native');
$query->from('#__languages AS a');
$query->where('a.published >= 0');
$query->order('a.title');
// Set the query and load the options.
$db->setQuery($query);
self::$items = $db->loadObjectList();
if ($all) {
array_unshift(self::$items, new JObject(array('value'=>'*','text'=>$translate ? JText::alt('JALL','language') : 'JALL_LANGUAGE')));
}
// Detect errors
if ($db->getErrorNum()) {
JError::raiseWarning(500, $db->getErrorMsg());
}
}
return self::$items;
}
/**
* Get a list of the available content language items.
*
* @param boolean $all True to include All (*)
* @param boolean $translate True to translate All
*
* @return string
*
* @see JFormFieldContentLanguage
* @since 1.6
*/
public static function existing($all = false, $translate = false)
{
if (empty(self::$items)) {
// Get the database object and a new query object.
$db = JFactory::getDbo();
$query = $db->getQuery(true);
// Build the query.
$query->select('a.lang_code AS value, a.title AS text, a.title_native')->from('#__languages AS a')->where('a.published >= 0')->order('a.title');
// Set the query and load the options.
$db->setQuery($query);
self::$items = $db->loadObjectList();
}
if ($all) {
$all_option = array(new JObject(array('value' => '*', 'text' => $translate ? JText::alt('JALL', 'language') : 'JALL_LANGUAGE')));
return array_merge($all_option, self::$items);
} else {
return self::$items;
}
}