/**
* Load all languages in memory for caching
*/
public static function loadLanguages()
{
self::$_LANGUAGES = array();
$result = Db::getInstance()->ExecuteS('
SELECT `id_lang`, `name`, `iso_code`, `active`
FROM `' . _DB_PREFIX_ . 'lang`');
foreach ($result as $row) {
self::$_LANGUAGES[(int) $row['id_lang']] = array('id_lang' => (int) $row['id_lang'], 'name' => $row['name'], 'iso_code' => $row['iso_code'], 'active' => (int) $row['active']);
}
}
/**
* Load all languages in memory for caching
*/
public static function loadLanguages()
{
self::$_LANGUAGES = array();
$result = Db::getInstance()->ExecuteS('SELECT * FROM `' . _DB_PREFIX_ . 'lang`');
foreach ($result as $row) {
self::$_LANGUAGES[(int) $row['id_lang']] = $row;
}
}
/**
* Load all languages in memory for caching
*/
public static function loadLanguages()
{
self::$_LANGUAGES = array();
$sql = 'SELECT l.*, ls.`id_shop`
FROM `' . _DB_PREFIX_ . 'lang` l
LEFT JOIN `' . _DB_PREFIX_ . 'lang_shop` ls ON (l.id_lang = ls.id_lang)';
$result = Db::getInstance()->executeS($sql);
foreach ($result as $row) {
if (!isset(self::$_LANGUAGES[(int) $row['id_lang']])) {
self::$_LANGUAGES[(int) $row['id_lang']] = $row;
}
self::$_LANGUAGES[(int) $row['id_lang']]['shops'][(int) $row['id_shop']] = true;
}
}
/**
* Load all languages in memory for caching
*/
public static function loadLanguages()
{
self::$_LANGUAGES = array();
$db = Db::getInstance();
$result = $db->ExecuteS('SELECT * FROM `' . _DB_PREFIX_ . 'lang`', false);
while ($row = $db->nextRow($result)) {
self::$_LANGUAGES[(int) $row['id_lang']] = $row;
}
}
