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