function updateStatus($errdoc_status) { global $application; $tables = Configuration::getTables(); $columns = $tables['store_settings']['columns']; $query = new DB_Update('store_settings'); $query->addUpdateValue($columns['value'], (int) $errdoc_status); $query->WhereValue($columns['name'], DB_EQ, 'enable_error_document'); $application->db->getDB_Result($query); }
function clearAttributesForCardType($type) { global $application; $tables = Configuration::getTables(); $attributes = $tables['credit_card_attributes_to_types']['columns']; $query = new DB_Delete('credit_card_attributes_to_types'); $query->WhereValue($attributes['type'], DB_EQ, $type); $application->db->getDB_Result($query); }
/** * Removes option by name. Prevents removal of protected Avactis options. * * @package Avactis * @subpackage Option * @since 4.7.5 * * * @param string $option Name of option to remove. */ function asc_delete_option($option) { global $application; $option = trim($option); if (empty($option)) { return false; } $result = asc_get_option($option); if ($result) { $tables = Configuration::getTables(); $tr = $tables['options']['columns']; $db_delete = new DB_Delete('options'); $db_delete->WhereValue($tr['option_name'], DB_EQ, $option); $application->db->PrepareSQL($db_delete); $application->db->DB_Exec(); /** * Fires after a specific option has been deleted. * * The dynamic portion of the hook name, `$option`, refers to the option name. * * @param string $option Name of the deleted option. */ do_action("asc_delete_option_{$option}", $option); return true; } else { return ''; } }
public static function getActiveSkin() { global $application; $skins = array(); $tables = Configuration::getTables(); $columns = $tables['store_settings']['columns']; $query = new DB_Select('store_settings'); $query->addSelectField($columns["variable_value"], "variable_value"); $query->WhereValue($columns['name'], DB_EQ, STOREFRONT_ACTIVE_SKIN); $skins = $application->db->getDB_Result($query); return $skins[0]['variable_value']; }