public static function loadConfiguration()
{
self::$_CONF = array();
self::$_CONF_LANG = array();
$result = Db::getInstance()->ExecuteS('
SELECT c.`name`, cl.`id_lang`, cl.`value` as cl_value, c.`value` as c_value
FROM `' . _DB_PREFIX_ . 'configuration` c
LEFT JOIN `' . _DB_PREFIX_ . 'configuration_lang` cl ON (c.id_configuration = cl.id_configuration)');
if (is_array($result)) {
foreach ($result as $row) {
self::$_CONF[$row['name']] = $row['c_value'];
if ($row['id_lang']) {
self::$_CONF_LANG[(int) $row['id_lang']][$row['name']] = $row['cl_value'];
}
}
}
}
public static function loadConfiguration()
{
self::$_CONF = array();
self::$_CONF_LANG = array();
self::$_CONF_IDS = array();
$db = Db::getInstance();
$result = $db->ExecuteS('
SELECT c.`id_configuration`, c.`name`, cl.`id_lang`, cl.`value` cl_value, c.`value` c_value
FROM `' . _DB_PREFIX_ . 'configuration` c
LEFT JOIN `' . _DB_PREFIX_ . 'configuration_lang` cl ON (c.id_configuration = cl.id_configuration)', false);
if ($result) {
while ($row = $db->nextRow($result)) {
self::$_CONF_IDS[$row['name']] = (int) $row['id_configuration'];
self::$_CONF[$row['name']] = $row['c_value'];
if ($row['id_lang']) {
self::$_CONF_LANG[(int) $row['id_lang']][$row['name']] = $row['cl_value'];
}
}
}
}
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']] = stripslashes($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[(int) $row['id_lang']][$row['name']] = stripslashes($row['value']);
}
}
