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()
{
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'];
}
}
}
}
/**
* Delete configuration key from current context.
*
* @param string $key
*/
public static function deleteFromContext($key)
{
if (Shop::getContext() == Shop::CONTEXT_ALL) {
return;
}
$id_shop = null;
$id_shop_group = Shop::getContextShopGroupID(true);
if (Shop::getContext() == Shop::CONTEXT_SHOP) {
$id_shop = Shop::getContextShopID(true);
}
$id = Configuration::getIdByName($key, $id_shop_group, $id_shop);
Db::getInstance()->execute('
DELETE FROM ' . _DB_PREFIX_ . 'configuration
WHERE id_configuration = ' . (int) $id);
Db::getInstance()->execute('
DELETE FROM ' . _DB_PREFIX_ . 'configuration_lang
WHERE id_configuration = ' . (int) $id);
self::$_CONF = null;
}
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']);
}
}
