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 deleteFPLinksFromCategory($category_id, $fp_ids) { global $application; $tables = $this->getTables(); $fp_table = $tables['fp_links']['columns']; $query = new DB_Delete('fp_links'); $query->WhereValue($fp_table['category_id'], DB_EQ, $category_id); $query->WhereAND(); $query->Where($fp_table['fp_id'], DB_IN, "(" . implode(", ", $fp_ids) . ")"); $application->db->PrepareSQL($query); return $application->db->DB_Exec(); }
function deleteRPLinksFromProduct($product_id, $rp_ids) { global $application; $tables = $this->getTables(); $rp_table = $tables['rp_links']['columns']; $query = new DB_Delete('rp_links'); $query->WhereValue($rp_table['product_id'], DB_EQ, $product_id); $query->WhereAND(); $query->Where($rp_table['rp_id'], DB_IN, "(" . implode(", ", $rp_ids) . ")"); $application->db->PrepareSQL($query); return $application->db->DB_Exec(); }
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); }
/** * 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 dropActivationKey($val, $type = 'key_value') { if (!in_array($type, array('key_value', 'customer_account')) or !is_string($val)) { return false; } global $application; $tables = $this->getTables(); $keys_table = $tables['ca_activation_keys']['columns']; $query = new DB_Delete('ca_activation_keys'); $query->WhereValue($keys_table[$type], DB_EQ, $val); $application->db->PrepareSQL($query); return $application->db->DB_Exec(); }
/** * */ 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 delFilesFromProduct($product_id, $files_ids) { global $application; $tables = $this->getTables(); $file_table = $tables['pf_files']['columns']; $query = new DB_Select(); $query->addSelectField($file_table['file_path']); $query->WhereValue($file_table['product_id'], DB_EQ, $product_id); $query->WhereAND(); $query->Where($file_table['file_id'], DB_IN, '(\'' . implode('\',\'', $files_ids) . '\')'); $query->WhereAND(); $query->WhereValue($file_table['is_uploaded'], DB_EQ, 'Y'); $res = $application->db->getDB_Result($query); $this->unlinkFiles($res); $query = new DB_Delete('pf_files'); $query->WhereValue($file_table['product_id'], DB_EQ, $product_id); $query->WhereAND(); $query->Where($file_table['file_id'], DB_IN, '(\'' . implode('\',\'', $files_ids) . '\')'); $application->db->PrepareSQL($query); $application->db->DB_Exec(); return; }
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 ''; } }
/** * deletes set and it's rates from DB * * @param int $sid */ function deleteSetFromDB($sid) { global $application; // delete file, if present $set = $this->getSet($sid); if (isset($set[0]['filename'])) { $fullpath = $application->getAppIni("PRODUCT_FILES_DIR") . "TaxRateByZip_CSVs/" . $set[0]['filename']; if (is_file($fullpath)) { unlink($fullpath); } } // delete set $tables = TaxRateByZip::getTables(); $table = "tax_zip_sets"; $columns = $tables[$table]['columns']; $query = new DB_Delete($table); $query->WhereValue($columns['id'], DB_EQ, $sid); $application->db->getDB_Result($query); // delete set rates $this->clearSetInDB($sid); }
/** * @ describe the function Modules_Manager->uninstallModule. * @param ModuleInfo $moduleInfo */ function uninstallModule($moduleInfo) { global $application; if ($moduleInfo->name == 'Modules_Manager') { return; // it can't reinstall itself } // start module insatllation, // use the static method call install() $modname = $moduleInfo->name; $this->includeAPIFileOnce($modname); call_user_func(array($modname, 'uninstall')); // delete from the specified module list $tables = $this->getTables(); $module_tbl = 'module'; $module_columns = $tables[$module_tbl]['columns']; $module_class_tbl = 'module_class'; $module_class_columns = $tables[$module_class_tbl]['columns']; $db_select = new DB_Select(); $db_select->addSelectTable($module_tbl); $db_select->addSelectField($module_columns['id']); $db_select->WhereValue($module_columns['name'], DB_EQ, $moduleInfo->name); list(list($moduleId)) = $application->db->getDB_Result($db_select, QUERY_RESULT_NUM); $getAllExtensionTables = array_keys($modname::getTables()); foreach ($getAllExtensionTables as $table) { if (DB_MySQL::DB_isTableExists($application->getAppIni('DB_TABLE_PREFIX') . $table)) { $del_query = new DB_Table_Delete($table); $application->db->getDB_Result($del_query); } } /*Remove extension directory if this is an extension -- BEGIN */ $directory = $application->getAppIni('PATH_ADD_MODULES_DIR') . strtolower($moduleInfo->name) . "/"; if (is_dir($directory)) { modApiFunc('Shell', 'removeDirectory', $directory); } /*Remove extension directory if this is an extension -- END */ // delete all linked records from module_class $db_delete = new DB_Delete($module_class_tbl); $db_delete->WhereValue($module_class_columns['module_id'], DB_EQ, $moduleId); $application->db->getDB_Result($db_delete); // delete a record from module $db_delete = new DB_Delete($module_tbl); $db_delete->WhereValue($module_columns['id'], DB_EQ, $moduleId); $application->db->getDB_Result($db_delete); CCacheFactory::clearAll(); }
function removeEmails($num, $emails_count) { global $application; $tables = $this->getTables(); $table = 'newsletter_temp'; $query = new DB_Delete($table); $query->WhereValue($tables[$table]['columns']['recipient_num'], DB_EQ, $num); $query->DeleteOrder($tables[$table]['columns']['recipient_id'], 'ASC'); $query->DeleteLimit($emails_count); $application->db->PrepareSQL($query); $application->db->DB_Exec(); }
/** * Clears the table Inventory Tracking for one product. * (If necessary, it can be rewritten for clearing the table Inventory * Tracking for several products). * * @param string $parent_entity - entity name * @param int $entity_id - ID of the entity the table should be cleared for. * @return bool; true if the table is cleared, false otherwise */ function __clearITForEntity($parent_entity, $entity_id) { global $application; $tables = $this->getTables(); $it_table = $tables['po_inventory']['columns']; $query = new DB_Delete('po_inventory'); $query->WhereValue($it_table['parent_entity'], DB_EQ, $parent_entity); $query->WhereAND(); $query->WhereValue($it_table['entity_id'], DB_EQ, $entity_id); $application->db->PrepareSQL($query); if ($application->db->DB_Exec()) { // $this->updateOptionsSettingsForEntity($parent_entity,$entity_id,array('IT_ACTUAL'=>'Y')); return true; } else { return false; } }
function deleteTaxRate($id) { global $application; $tables = $this->getTables(); $tr = $tables['tax_rates']['columns']; $query = new DB_Delete('tax_rates'); $query->WhereValue($tr['id'], DB_EQ, $id); $application->db->getDB_Result($query); }
function delImagesFromProduct($product_id, $images_ids, $del_from_server) { global $application; $tables = $this->getTables(); $imgs_table = $tables['pi_images']['columns']; $query = new DB_Select(); $query->addSelectField($imgs_table['image_path']); $query->addSelectField($imgs_table['thumb_path']); $query->WhereValue($imgs_table['product_id'], DB_EQ, $product_id); $query->WhereAND(); $query->Where($imgs_table['image_id'], DB_IN, '(\'' . implode('\',\'', $images_ids) . '\')'); $res = $application->db->getDB_Result($query); if (strcmp($del_from_server, 'yes') == 0) { $this->unlinkFiles($res); } $query = new DB_Delete('pi_images'); $query->deleteMultiLangField($imgs_table['alt_text'], $imgs_table['image_id'], 'Product_Images'); $query->WhereValue($imgs_table['product_id'], DB_EQ, $product_id); $query->WhereAND(); $query->Where($imgs_table['image_id'], DB_IN, '(\'' . implode('\',\'', $images_ids) . '\')'); $application->db->getDB_Result($query); return; }
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 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); }
/** * Deletes old records in the news table. * After that <= NEWS_MAX_COUNT records remain. */ function deleteOldNews() { global $application; $tables = $this->getTables(); $columns = $tables['news']['columns']; # select the latest date piece of news among the remain ones in the table... $query = new DB_Select('news'); $query->addSelectField($columns['date'], 'NewsDate'); $query->SelectOrder($columns['date'], 'DESC'); $query->SelectLimit($this->settings[NEWS_MAX_COUNT] - 1, 1); $result = $application->db->getDB_Result($query); if ($result == NULL) { return; } # ...delete all the latest news @ check this line $query = new DB_Delete('news'); $query->WhereValue($columns['date'], DB_LT, $result[0]['NewsDate']); $query->WhereAND(); $query->WhereValue($columns['type'], DB_EQ, 'avactis'); $application->db->getDB_Result($query); }
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; }
/** * . * * @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); }
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 removePages($csv) { global $application; loadCoreFile('csv_parser.php'); $csv_parser = new CSV_Parser(); $tables = MenuManager::getTables(); $table = 'admin_pages'; $columns = $tables[$table]['columns']; list($flt, $pages) = $csv_parser->parse_file($csv); if (count($pages) > 0) { foreach ($pages as $key => $page) { $query = new DB_Delete($table); $query->WhereValue($columns['identifier'], DB_EQ, $page["identifier"]); $application->db->getDB_Result($query); } } }