public static function loadConfiguration() { /* Configuration */ self::$_CONF = array(); $result = Db::getInstance()->ExecuteS('SELECT `name`, `value` FROM `' . _DB_PREFIX_ . 'configuration`'); if ($result) { foreach ($result as $row) { self::$_CONF[$row['name']] = $row['value']; } } /* Multilingual configuration */ self::$_CONF_LANG = array(); $result = Db::getInstance()->ExecuteS(' SELECT c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS value FROM `' . _DB_PREFIX_ . 'configuration_lang` cl LEFT JOIN `' . _DB_PREFIX_ . 'configuration` c ON c.id_configuration = cl.id_configuration'); if ($result === false) { die(Tools::displayError('Invalid loadConfiguration() SQL query!')); } foreach ($result as $row) { self::$_CONF_LANG[intval($row['id_lang'])][$row['name']] = $row['value']; } }
public static function loadConfiguration() { self::$_CONF = array(); $result = Db::getInstance()->getAll(' SELECT * FROM `' . DB_PREFIX . 'configuration`'); if (is_array($result)) { foreach ($result as $row) { self::$_CONF[$row['name']] = $row['value']; } } }