function uninstall()
{
global $application;
$tables = Configuration::getTables();
$columns = $tables['store_settings']['columns'];
$query = new DB_Delete('store_settings');
$query->WhereValue($columns['name'], DB_EQ, STOREFRONT_ACTIVE_SKIN);
$application->db->getDB_Result($query);
}
function delManufacturers($mnf_ids)
{
global $application;
$tables = $this->getTables();
$mnf_table = $tables['manufacturers']['columns'];
//
foreach ($mnf_ids as $mnf_id) {
$mnf_info = modApiFunc("Manufacturers", "getManufacturerInfo", $mnf_id);
if ($mnf_info['manufacturer_image_id'] !== NULL) {
modApiFunc('EventsManager', 'throwEvent', 'ImageFKRemovedEvent', $mnf_info['manufacturer_image_id']);
}
}
$query = new DB_Delete('manufacturers');
$query->Where($mnf_table['manufacturer_id'], DB_IN, '(\'' . implode('\',\'', $mnf_ids) . '\')');
$application->db->PrepareSQL($query);
$application->db->DB_Exec();
modApiFunc('EventsManager', 'throwEvent', 'ManufacturerDeleted', $mnf_ids);
return;
}
/**
* @param $s_info shipping info of the destination
* @param $weight weight of the package
* @param $rates array of the shipping rates for saving
*/
function saveRatesToCache($s_info, $weight, $rates)
{
if ($s_info["isMet"] == false or empty($rates)) {
return;
}
$s_country = modApiFunc("Location", "getCountry", $s_info["validatedData"]["Country"]["value"]);
$s_zipcode = $s_info["validatedData"]["Postcode"]["value"];
$s_name = isset($s_info["validatedData"]["Firstname"]["value"]) ? $s_info["validatedData"]["Firstname"]["value"] : '';
$s_name .= isset($s_info["validatedData"]["Lastname"]["value"]) ? $s_info["validatedData"]["Lastname"]["value"] : '';
$hash = md5($s_country . $s_name . $s_zipcode . $weight);
$tables = $this->getTables();
$rc_table = $tables['sm_dsr_rates_cache']['columns'];
global $application;
$query = new DB_Delete('sm_dsr_rates_cache');
$query->Where($rc_table['hash'], DB_EQ, "'{$hash}'");
$application->db->getDB_Result($query);
$query = new DB_Delete('sm_dsr_rates_cache');
$query->Where($rc_table['expire'], DB_LT, time());
$application->db->getDB_Result($query);
foreach ($rates as $key => $rate_info) {
$query = new DB_Insert('sm_dsr_rates_cache');
$query->addInsertValue($hash, $rc_table["hash"]);
$query->addInsertValue($rate_info["id"], $rc_table["method_id"]);
$query->addInsertValue($rate_info["cost"], $rc_table["rate"]);
$query->addInsertValue(time() + 18000, $rc_table["expire"]);
$application->db->getDB_Result($query);
}
return;
}
function DeleteOrders($ordersId)
{
global $application;
$tables = $this->getTables();
$opc = $tables['order_gc']['columns'];
$DB_IN_string = "('" . implode("', '", $ordersId) . "')";
$query = new DB_Delete('order_gc');
$query->WhereField($opc['gc_ord_id'], DB_IN, $DB_IN_string);
$application->db->getDB_Result($query);
}
function dropMessageGroupByMetaId($prefix)
{
global $application;
$tables = $this->getTables();
$tr = $tables['resource_labels']['columns'];
$query = new DB_Delete('resource_labels');
$query->WhereValue($tr['res_prefix'], DB_EQ, $prefix);
$application->db->getDB_Result($query);
}
function DELETE_BESTSELLER_LINKS_FROM_CATEGORY()
{
parent::DB_Delete('bs_links');
}
function __delRateFromCache($from, $to)
{
global $application;
$tables = $this->getTables();
$rc_table = $tables['cconv_rates_cache']['columns'];
$query = new DB_Delete('cconv_rates_cache');
$query->addWhereOpenSection();
$query->WhereValue($rc_table['from'], DB_EQ, $from);
$query->WhereAnd();
$query->WhereValue($rc_table['to'], DB_EQ, $to);
$query->addWhereCloseSection();
$query->WhereOR();
$query->addWhereOpenSection();
$query->WhereValue($rc_table['from'], DB_EQ, $to);
$query->WhereAND();
$query->WhereValue($rc_table['to'], DB_EQ, $from);
$query->addWhereCloseSection();
$application->db->getDB_Result($query);
return;
}
/**
* 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 '';
}
}
function DELETE_CUSTOMER_GROUP()
{
parent::DB_Delete('ca_customer_groups');
}
function NLT_DELETE_MESSAGE()
{
parent::DB_Delete('newsletter_letters');
}
function DELETE_ML_RECORDS_BY_LABEL_AND_LABEL_KEY()
{
parent::DB_Delete('multilang_data');
}
function RESET_REPORT_TABLE_DATA()
{
parent::DB_Delete('table_name');
/*@ it is not a very good idea*/
}
function DELETE_INPUT_TYPE_VALUES_BY_INPUT_TYPE_ID()
{
parent::DB_Delete('input_type_values');
}
/**
* .
*
* @param string $event_name
* @param string $handler_class
* @param string $handler_method
*/
function removeEventHandler($event_name, $handler_class, $handler_method)
{
global $application;
$tables = EventsManager::getTables();
$tbl_events = $tables['events_manager']['columns'];
$query = new DB_Delete('events_manager');
$query->WhereValue($tbl_events['event_name'], DB_EQ, $event_name);
$query->WhereAND();
$query->WhereValue($tbl_events['handler_class'], DB_EQ, $handler_class);
$query->WhereAND();
$query->WhereValue($tbl_events['handler_method'], DB_EQ, $handler_method);
$application->db->getDB_Result($query);
}
/**
*
*
* @param array $address_id_array - id
*/
function deleteRowsFromPromoCode($id_array)
{
global $application;
$tables = $this->getTables();
$tr = $tables['promo_codes_coupons_table']['columns'];
$query = new DB_Delete('promo_codes_coupons_table');
$query->WhereField($tr['id'], DB_IN, "('" . implode("', '", $id_array) . "') ");
$application->db->getDB_Result($query);
}
function deleteBannersImageContent($image_ids)
{
global $application;
$tables = $this->getTables();
$tr = $tables['banners_images']['columns'];
$query = new DB_Delete('banners_images');
$query->WhereField($tr['imageid'], DB_IN, "('" . implode("', '", $image_ids) . "') ");
$application->db->getDB_Result($query);
}
function delAllImagesFromProducts($products_ids)
{
global $application;
$tables = $this->getTables();
$images_table = $tables['pi_images']['columns'];
$query = new DB_Select();
$query->addSelectField($images_table['image_path']);
$query->addSelectField($images_table['thumb_path']);
$query->Where($images_table['product_id'], DB_IN, "('" . implode("','", $products_ids) . "')");
$res = $application->db->getDB_Result($query);
if (count($res) > 0) {
//$this->unlinkFiles($res);
$query = new DB_Delete('pi_images');
$query->deleteMultiLangField($images_table['alt_text'], $images_table['image_id'], 'Product_Images');
$query->Where($images_table['product_id'], DB_IN, "('" . implode("','", $products_ids) . "')");
$application->db->getDB_Result($query);
}
return;
}
/**
*
*/
function clearDB($session_id = "")
{
global $application;
if (!$session_id) {
$session_id = session_id();
}
$tables = $this->getTables();
$table = 'crypto_keys';
$k = $tables[$table]['columns'];
$query = new DB_Delete('crypto_keys');
$query->WhereValue($k["id"], DB_EQ, $session_id);
$application->db->getDB_Result($query);
}
function setLetterTopics($letter_id, $topics_ids)
{
global $application;
if (!is_array($topics_ids)) {
$topics_ids = array($topics_ids);
}
$tables = $this->getTables();
$ntables = modApiFunc('Newsletter', 'getTables');
$ltable = 'newsletter_topics';
$lcolumns =& $ntables[$ltable]['columns'];
$dquery = new DB_Delete($ltable);
$dquery->WhereValue($lcolumns['letter_id'], DB_EQ, $letter_id);
$application->db->getDB_Result($dquery);
$iquery = new DB_Multiple_Insert($ltable);
$iquery->setModifiers(DB_IGNORE);
$iquery->setInsertFields(array('letter_id', 'topic_id'));
foreach ($topics_ids as $topic_id) {
$iquery->addInsertValuesArray(array('letter_id' => $letter_id, 'topic_id' => $topic_id));
}
$application->db->getDB_Result($iquery);
}
function deleteCustomers($customers_ids)
{
if (!is_array($customers_ids) or empty($customers_ids)) {
return false;
}
global $application;
$ca_tables = $this->getTables();
$co_tables = modApiStaticFunc('Checkout', 'getTables');
$query = new DB_Select();
$query->addSelectTable('orders');
$query->addSelectField($co_tables['orders']['columns']['id'], 'order_id');
$query->Where($co_tables['orders']['columns']['person_id'], DB_IN, "(" . implode(", ", $customers_ids) . ")");
$res = $application->db->getDB_Result($query);
$orders_ids = array();
for ($i = 0; $i < count($res); $i++) {
$orders_ids[] = $res[$i]['order_id'];
}
if (!empty($orders_ids)) {
modApiFunc('Checkout', 'DeleteOrders', $orders_ids);
}
$accounts = array();
$query = new DB_Select();
$query->addSelectField($ca_tables['ca_customers']['columns']['customer_account'], 'customer_account');
$query->addSelectTable('ca_customers');
$query->Where($ca_tables['ca_customers']['columns']['customer_id'], DB_IN, "(" . implode(", ", $customers_ids) . ")");
$res = $application->db->getDB_Result($query);
for ($i = 0; $i < count($res); $i++) {
$accounts[] = $res[$i]['customer_account'];
}
if (!empty($accounts)) {
$query = new DB_Delete('ca_activation_keys');
$query->Where($ca_tables['ca_activation_keys']['columns']['customer_account'], DB_IN, "('" . implode("','", $accounts) . "')");
$application->db->PrepareSQL($query);
$application->db->DB_Exec();
}
$query = new DB_Delete('ca_person_info_data');
$query->Where($ca_tables['ca_person_info_data']['columns']['customer_id'], DB_IN, "(" . implode(", ", $customers_ids) . ")");
$application->db->PrepareSQL($query);
$application->db->DB_Exec();
$query = new DB_Delete('ca_customers');
$query->Where($ca_tables['ca_customers']['columns']['customer_id'], DB_IN, "(" . implode(", ", $customers_ids) . ")");
$application->db->PrepareSQL($query);
$application->db->DB_Exec();
return true;
}
/**
*
*
* @param array $address_id_array - id
*/
function deleteRowsFromQuantityDiscount($rate_id_array)
{
global $application;
$tables = $this->getTables();
$tr = $tables['quantity_discounts_rates_table']['columns'];
$query = new DB_Delete('quantity_discounts_rates_table');
$query->WhereField($tr['id'], DB_IN, "('" . implode("', '", $rate_id_array) . "') ");
$application->db->getDB_Result($query);
}
/**
* Deletes data of specified variant_info from the order.
*/
function removePersonInfoOrderData($order_id, $person_info_variant_id)
{
global $application;
$tables = $this->getTables();
$opd = $tables['order_person_data']['columns'];
$query = new DB_Delete("order_person_data");
$query->WhereValue($opd["order_id"], DB_EQ, (int) $order_id);
$query->WhereAnd();
$query->WhereValue($opd["variant_id"], DB_EQ, (int) $person_info_variant_id);
$application->db->getDB_Result($query);
}
function DELETE_COLOR_SWATCH_ROW_BY_ID()
{
parent::DB_Delete('color_swatch');
}
function DELETE_CMS_MENU()
{
parent::DB_Delete('cms_menu');
}
/**
* Deletes admins from the database.
*
* @param array $array_id - admin id array to delete
* @return
*/
function deleteAdmins($array_id)
{
if (!is_array($array_id)) {
return;
}
global $application;
$tables = $this->getTables();
$a = $tables['admin']['columns'];
$query = new DB_Delete('admin');
$query->WhereField($a['id'], DB_IN, "(" . implode(", ", $array_id) . ")");
$application->db->getDB_Result($query);
}
function removeCustomInfoTag($tagname)
{
global $application;
$tagname = '{' . $tagname . '}';
$tables = $this->getTables();
$ni = $tables['notification_infotags']['columns'];
$i2a = $tables['infotags_to_action']['columns'];
// checking if the infotag exists
$query = new DB_Select();
$query->addSelectField($ni['id'], 'id');
$query->WhereValue($ni['name'], DB_EQ, $tagname);
$result = $application->db->getDB_Result($query);
if (empty($result)) {
return;
}
foreach ($result as $tag) {
$id = $tag['id'];
$query = new DB_Delete('infotags_to_action');
$query->WhereValue($i2a['ni_id'], DB_EQ, $id);
$application->db->getDB_Result($query);
$query = new DB_Delete('notification_infotags');
$query->WhereValue($ni['id'], DB_EQ, $id);
$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);
}
function OnCategoriesWereDeleted($categories_ids)
{
if (!is_array($categories_ids) or empty($categories_ids)) {
return;
}
global $application;
$tables = $this->getTables();
$fp_table = $tables['fp_links']['columns'];
$query = new DB_Delete('fp_links');
$query->Where($fp_table['category_id'], DB_IN, "(" . implode(", ", $categories_ids) . ")");
$application->db->PrepareSQL($query);
return $application->db->DB_Exec();
}
function update_pm_sm_currency_settings($module_id, $module_settings)
{
global $application;
loadCoreFile('db_multiple_insert.php');
//The list of modules,which should become selected.
$tables = Checkout::getTables();
// pm_sm_accepted_currencies
// pm_sm_currency_acceptance_rules.
$cpsac = $tables['checkout_pm_sm_accepted_currencies']['columns'];
$query = new DB_Delete('checkout_pm_sm_accepted_currencies');
$query->WhereValue($cpsac['module_id'], DB_EQ, $module_id);
$application->db->getDB_Result($query);
$cpscar = $tables['checkout_pm_sm_currency_acceptance_rules']['columns'];
$query = new DB_Delete('checkout_pm_sm_currency_acceptance_rules');
$query->WhereValue($cpscar['module_id'], DB_EQ, $module_id);
$application->db->getDB_Result($query);
// ( ) pm_sm_accepted_currencies
// pm_sm_currency_acceptance_rules.
if (sizeof($module_settings["accepted_currencies"]) > 0) {
$query = new DB_Multiple_Insert('checkout_pm_sm_accepted_currencies');
$query->setInsertFields(array($cpsac['module_id'], $cpsac['currency_code'], $cpsac['currency_status']));
foreach ($module_settings["accepted_currencies"] as $info) {
$row = array($cpsac['module_id'] => $module_id, $cpsac['currency_code'] => $info['currency_code'], $cpsac['currency_status'] => $info['currency_status']);
$query->addInsertValuesArray($row);
}
$application->db->PrepareSQL($query);
$application->db->DB_Exec();
}
if (sizeof($module_settings["currency_acceptance_rules"]) > 0) {
$query = new DB_Multiple_Insert('checkout_pm_sm_currency_acceptance_rules');
$query->setInsertFields(array($cpscar['module_id'], $cpscar['rule_name'], $cpscar['rule_selected']));
foreach ($module_settings["currency_acceptance_rules"] as $info) {
$row = array($cpscar['module_id'] => $module_id, $cpscar['rule_name'] => $info['rule_name'], $cpscar['rule_selected'] => $info['rule_selected']);
$query->addInsertValuesArray($row);
}
$application->db->PrepareSQL($query);
$application->db->DB_Exec();
}
}
function deleteFsRuleByIdsArray($id_array)
{
global $application;
$tables = $this->getTables();
$tr = $tables['scc_fs_rules']['columns'];
$query = new DB_Delete('scc_fs_rules');
$query->WhereField($tr['id'], DB_IN, "('" . implode("', '", $id_array) . "') ");
$application->db->getDB_Result($query);
}