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);
 }
Example #3
0
/**
 * 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'];
 }