/** * Uninstall b2evolution: Delete DB & Cache files */ function uninstall_b2evolution() { global $DB; /* REMOVE PAGE CACHE */ load_class('_core/model/_pagecache.class.php', 'PageCache'); // Remove general page cache $PageCache = new PageCache(NULL); $PageCache->cache_delete(); // Skip if T_blogs table is already deleted. Note that db_delete() will not throw any errors on missing tables. if ($DB->query('SHOW TABLES LIKE "T_blogs"')) { // Get all blogs $blogs_SQL = new SQL(); $blogs_SQL->SELECT('blog_ID'); $blogs_SQL->FROM('T_blogs'); $blogs = $DB->get_col($blogs_SQL->get()); $BlogCache =& get_BlogCache('blog_ID'); foreach ($blogs as $blog_ID) { $Blog = $BlogCache->get_by_ID($blog_ID); // Remove page cache of current blog $PageCache = new PageCache($Blog); $PageCache->cache_delete(); } } /* REMOVE DATABASE */ db_delete(); echo '<p>' . T_('Reset done!') . '</p>'; }
public function delete($item_id) { // @TODO - try... catch... drupal_set_message("Deleted queue item " . $item_id); db_delete('queue')->condition('item_id', $item_id)->execute(); return TRUE; }
/** * Act on user account cancellations. * * The user account is being canceled. Depending on the account cancellation * method, the module should either do nothing, unpublish content, anonymize * content, or delete content and data belonging to the canceled user account. * * Expensive operations should be added to the global batch with batch_set(). * * @param $edit * The array of form values submitted by the user. * @param $account * The user object on which the operation is being performed. * @param $method * The account cancellation method. * * @see user_cancel_methods() * @see hook_user_cancel_methods_alter() * @see user_cancel() */ function hook_user_cancel($edit, $account, $method) { switch ($method) { case 'user_cancel_block_unpublish': // Unpublish nodes (current revisions). module_load_include('inc', 'node', 'node.admin'); $nodes = db_select('node', 'n')->fields('n', array('nid'))->condition('uid', $account->uid)->execute()->fetchCol(); node_mass_update($nodes, array('status' => 0)); break; case 'user_cancel_reassign': // Anonymize nodes (current revisions). module_load_include('inc', 'node', 'node.admin'); $nodes = db_select('node', 'n')->fields('n', array('nid'))->condition('uid', $account->uid)->execute()->fetchCol(); node_mass_update($nodes, array('uid' => 0)); // Anonymize old revisions. db_update('node_revision')->fields(array('uid' => 0))->condition('uid', $account->uid)->execute(); // Clean history. db_delete('history')->condition('uid', $account->uid)->execute(); break; case 'user_cancel_delete': // Delete nodes (current revisions). $nodes = db_select('node', 'n')->fields('n', array('nid'))->condition('uid', $account->uid)->execute()->fetchCol(); foreach ($nodes as $nid) { node_delete($nid); } // Delete old revisions. db_delete('node_revision')->condition('uid', $account->uid)->execute(); // Clean history. db_delete('history')->condition('uid', $account->uid)->execute(); break; } }
/** * Remove the record IF there are no records referencing this user. */ function updateDatabase($form, $myvalues) { //Perform some data quality checks now. if (!isset($myvalues['protocol_shortname'])) { die("Cannot delete record because missing protocol_shortname in array!\n" . var_dump($myvalues)); } $updated_dt = date("Y-m-d H:i", time()); $protocol_shortname = $myvalues['protocol_shortname']; //Backup all the existing records. $this->m_oPageHelper->copyProtocolLibToReplacedTable($protocol_shortname); $this->m_oPageHelper->copyKeywordsToReplacedTable($protocol_shortname); $this->m_oPageHelper->copyTemplateValuesToReplacedTable($protocol_shortname); //Delete all the records. $num_deleted = db_delete('raptor_protocol_lib')->condition('protocol_shortname', $protocol_shortname)->execute(); $num_deleted = db_delete('raptor_protocol_keywords')->condition('protocol_shortname', $protocol_shortname)->execute(); $num_deleted = db_delete('raptor_protocol_template')->condition('protocol_shortname', $protocol_shortname)->execute(); //Success? if ($num_deleted == 1) { $feedback = 'The ' . $protocol_shortname . ' protocol has been succesfully deleted.'; drupal_set_message($feedback); return 1; } //We are here because we failed. $feedback = 'Trouble deleting ' . $protocol_shortname . ' protocol!'; error_log($feedback . ' delete reported ' . $num_deleted); drupal_set_message($feedback, 'warning'); return 0; }
/** * Removes all URLs and all priority-rules from the URL-cache. */ public function clear() { // die('clear'); // drupal_set_message('<pre>PHPCrawlerD7URLCache::clear ' . print_r('', 1) . '</pre>'); // $this->conn->query("DELETE FROM " . $this->table . " WHERE crawler_id = '" . $this->crawler_id . "';"); db_delete($this->table)->condition('crawler_id', $this->crawler_id)->execute(); }
/** * This is an example implementation for the hook. Preforms actions when converting a node based on it's type. * * @param $data * An array containing information about the conversion process. The keys are * - dest_node_type The destination type of the node * - node The node object * - Any other information passed by $op = 'options' or $op = 'options validate' * @param $op * A string containing the operation which should be executed. These are the possible values * - insert Operations which should be run when the node is transferred to the new node type. * Usually for transferring and adding new node information into the database. * - delete Operations which should be run after the node is transferred to the new node type. * Usually for deleting unneeded information from the database after the transfer. * - options Configuration elements shown on the conversion form. Should return a FAPI array. * - options validate Validation check on the options elements. * @return * Should return a FAPI array only when using the options operation. */ function hook_node_convert_change($data, $op) { // All of this is just an example. if ($op == 'insert') { if ($data['dest_node_type'] == 'book') { $book = array(); $node = $data['node']; $book['link_path'] = 'node/' . $node->nid; $book['link_title'] = $node->title; $book['plid'] = 0; $book['menu_name'] = book_menu_name($node->nid); $mlid = menu_link_save($book); $book['bid'] = $data['hook_options']['bid']; if ($book['bid'] == 'self') { $book['bid'] = $node->nid; } $id = db_insert('book')->fields(array('nid' => $node->nid, 'mlid' => $book['mlid'], 'bid' => $book['bid']))->execute(); } if ($data['dest_node_type'] == 'forum') { $id = db_insert('forum')->fields(array('tid' => $data['hook_options']['forum'], 'vid' => $data['node']->vid, 'nid' => $data['node']->nid))->execute(); $id = db_insert('taxonomy_term_node')->fields(array('tid' => $data['hook_options']['forum'], 'vid' => $data['node']->vid, 'nid' => $data['node']->nid))->execute(); } } elseif ($op == 'delete') { if ($data['node']->type == 'book') { menu_link_delete($data['node']->book['mlid']); db_delete('book')->condition('mlid', $data['node']->book['mlid'])->execute(); } if ($data['node']->type == 'forum') { db_delete('forum')->condition('nid', $data['node']->nid)->execute(); db_delete('taxonomy_term_node')->condition('nid', $data['node']->nid)->execute(); } } elseif ($op == 'options') { $form = array(); if ($data['dest_node_type'] == 'book') { foreach (book_get_books() as $book) { $options[$book['nid']] = $book['title']; } $options = array('self' => '<' . t('create a new book') . '>') + $options; $form['bid'] = array('#type' => 'select', '#title' => t('Book'), '#options' => $options, '#description' => t('Your page will be a part of the selected book.'), '#attributes' => array('class' => 'book-title-select')); } if ($data['dest_node_type'] == 'forum') { $vid = variable_get('forum_nav_vocabulary', ''); $form['forum'] = taxonomy_form($vid); $form['forum']['#weight'] = 7; $form['forum']['#required'] = TRUE; $form['forum']['#options'][''] = t('- Please choose -'); } return $form; } elseif ($op == 'options validate') { $form_state = $data['form_state']; if ($data['dest_node_type'] == 'forum') { $containers = variable_get('forum_containers', array()); $term = $form_state['values']['hook_options']['forum']; if (in_array($term, $containers)) { $term = taxonomy_term_load($term); form_set_error('hook_options][forum', t('The item %forum is only a container for forums. Please select one of the forums below it.', array('%forum' => $term->name))); } } } }
public function delete() { if (!is_numeric($this->record['pid']) || self::load($this->record['pid']) === false) { throw new \Exception('The record being deleted does not exist.'); } db_delete('ablecore_menu_item_path')->condition('pid', $this->record['pid'])->execute(); }
/** * Actually removes the record IF there are no records referencing this user. * If records do reference it, then only marks it inactive. */ function updateDatabase($myvalues) { $bHasReferences = UserInfo::userIsReferenced($this->m_nUID); $feedback = NULL; if ($bHasReferences) { $updated_dt = date("Y-m-d H:i", time()); $nUpdated = db_update('raptor_user_profile')->fields(array('accountactive_yn' => 0, 'updated_dt' => $updated_dt))->condition('uid', $this->m_nUID, '=')->execute(); if ($nUpdated !== 1) { error_log("Failed to edit user back to database!\n" . var_dump($myvalues)); die("Failed to edit user back to database!\n" . var_dump($myvalues)); } $feedback = 'Marked user as inactive instead of deleted because referenced by other records.'; } else { //Delete all the child records first. $num_deleted = db_delete('raptor_user_modality')->condition('uid', $this->m_nUID, '=')->execute(); $num_deleted = db_delete('raptor_user_anatomy')->condition('uid', $this->m_nUID, '=')->execute(); $num_deleted = db_delete('raptor_user_group_membership')->condition('uid', $this->m_nUID, '=')->execute(); //Now delete the profile. $num_deleted = db_delete('raptor_user_profile')->condition('uid', $this->m_nUID, '=')->execute(); if ($this->m_nUID == 1) { //Do NOT delete this drupal user or will be very unhappy! error_log('Removed user 1 from RAPTOR but left it alone in Drupal users table.'); $feedback = 'Removed user from RAPTOR system.'; } else { //Now delete the Drupal user. $num_deleted = db_delete('users')->condition('uid', $this->m_nUID, '=')->execute(); $feedback = 'Removed the ADMIN user from RAPTOR system.'; } } drupal_set_message($feedback); return 1; }
function Destroy() { $this->service->PerformDeletion(); if ($this->id > 0) { db_delete('service', '`id`=' . $this->id); } }
function session_test() { tem_load('code/wfpl/test/session_test.html'); db_delete('wfpl_sessions'); db_delete('wfpl_session_data'); session_dump('Clean slate'); session_new(); session_dump('new session'); session_set('username', 'jason'); session_dump('username jason'); session_set('username', 'phil'); session_dump('overwrote username as phil'); $old = $GLOBALS['session_id']; session_new(); session_dump('new session'); session_set('username', 'jason'); session_set('bamph', 'foo'); session_dump('set username=jason and bamph=foo in new session'); session_clear('username'); session_dump('cleared username in new session'); _kill_session($old); session_dump('killed old session'); kill_session(); session_dump('kill_session()'); tem_output(); }
/** * Submits form with invalid, empty, and valid OPML files. */ protected function submitImportForm() { $before = db_query('SELECT COUNT(*) FROM {aggregator_feed}')->fetchField(); $form['files[upload]'] = $this->getInvalidOpml(); $this->drupalPostForm('admin/config/services/aggregator/add/opml', $form, t('Import')); $this->assertText(t('No new feed has been added.'), 'Attempting to upload invalid XML.'); $edit = array('remote' => file_create_url($this->getEmptyOpml())); $this->drupalPostForm('admin/config/services/aggregator/add/opml', $edit, t('Import')); $this->assertText(t('No new feed has been added.'), 'Attempting to load empty OPML from remote URL.'); $after = db_query('SELECT COUNT(*) FROM {aggregator_feed}')->fetchField(); $this->assertEqual($before, $after, 'No feeds were added during the two last form submissions.'); db_delete('aggregator_feed')->execute(); $feeds[0] = $this->getFeedEditArray(); $feeds[1] = $this->getFeedEditArray(); $feeds[2] = $this->getFeedEditArray(); $edit = array('files[upload]' => $this->getValidOpml($feeds), 'refresh' => '900'); $this->drupalPostForm('admin/config/services/aggregator/add/opml', $edit, t('Import')); $this->assertRaw(t('A feed with the URL %url already exists.', array('%url' => $feeds[0]['url[0][value]'])), 'Verifying that a duplicate URL was identified'); $this->assertRaw(t('A feed named %title already exists.', array('%title' => $feeds[1]['title[0][value]'])), 'Verifying that a duplicate title was identified'); $after = db_query('SELECT COUNT(*) FROM {aggregator_feed}')->fetchField(); $this->assertEqual($after, 2, 'Verifying that two distinct feeds were added.'); $feeds_from_db = db_query("SELECT title, url, refresh FROM {aggregator_feed}"); $refresh = TRUE; foreach ($feeds_from_db as $feed) { $title[$feed->url] = $feed->title; $url[$feed->title] = $feed->url; $refresh = $refresh && $feed->refresh == 900; } $this->assertEqual($title[$feeds[0]['url[0][value]']], $feeds[0]['title[0][value]'], 'First feed was added correctly.'); $this->assertEqual($url[$feeds[1]['title[0][value]']], $feeds[1]['url[0][value]'], 'Second feed was added correctly.'); $this->assertTrue($refresh, 'Refresh times are correct.'); }
/** * Delete an entry from the database. * */ public static function delete($entry = array()) { $select = db_delete('ea_contact_method_values'); foreach ($entry as $field => $value) { $select->condition($field, $value); } $select->execute(); }
/** * {@inheritdoc} */ public function orderSave(OrderInterface $order) { if (empty($order->payment_details['description'])) { db_delete('uc_payment_other')->condition('order_id', $order->id())->execute(); } else { db_merge('uc_payment_other')->key(array('order_id' => $order->id()))->fields(array('description' => $order->payment_details['description']))->execute(); } }
function delete($id) { if (db_delete($this->table, $this->primary_key . "=" . $id)) { return db_delete('order', 'transaction_id=' . $id); } else { return mysql_affected_rows(); } }
function delete($id) { if (db_delete($this->table, $this->primary_key . "=" . $id)) { return db_delete('news', 'admin=' . $id); } else { return mysql_affected_rows(); } }
public function __db_delete() { $id_key = $this->id_key(); $this->switch_to_db(); db_delete($this->db_table())->condition($id_key, $this->{$id_key})->execute(); $this->switch_from_db(); return $this; }
/** * {@inheritdoc} */ public function delete_form_submit(&$form_state) { parent::delete_form_submit($form_state); if (\Drupal::service('module_handler')->moduleExists('openlayers_block')) { $delta = _openlayers_block_get_block_id($form_state['item']->machine_name); db_delete('block')->condition('module', 'openlayers')->condition('delta', $delta)->execute(); } }
/** * {@inheritdoc} */ public function submitForm(array &$form, FormStateInterface $form_state) { db_delete('uc_weightquote_methods')->condition('mid', $this->methodId)->execute(); db_delete('uc_weightquote_products')->condition('mid', $this->methodId)->execute(); // rules_config_delete(array('get_quote_from_weightquote_' . $mid)); drupal_set_message(t('Weight quote shipping method deleted.')); $form_state->setRedirect('uc_quote.methods'); }
/** * Delete the record from the database. */ public function delete() { db_delete('bean')->condition('type', $this->type)->execute(); ctools_include('export'); ctools_export_crud_delete('bean_type', $this->type); field_attach_delete_bundle('bean', $this->type); bean_reset(); }
/** * Truncates database tables. * * @param array $tables * The list of tables to be truncated. */ public function truncateTables(array $tables = array()) { foreach ($tables as $table) { if (db_table_exists($table)) { db_delete($table)->execute(); } } }
/** * {@inheritdoc} */ public function submitForm(array &$form, array &$form_state) { $account = \Drupal::currentUser(); $cid = $form_state['values']; db_delete('oauth_consumer')->condition('cid', $cid)->execute(); drupal_set_message('OAuth consumer deleted.'); $form_state['redirect'] = 'user/' . $account->id() . '/oauth/consumer'; }
/** * Deletes a user_badge from all the tables. * It is the caller's responsibilty to let the user know this has been done. * The caller must have 'manage badges' permission. * * @param $bid * The badge ID. */ function user_badges_delete_badge($bid) { if (user_access('manage badges')) { db_delete('user_badges_badges')->condition('bid', $bid)->execute(); db_delete('user_badges_user')->condition('bid', $bid)->execute(); db_delete('user_badges_roles')->condition('bid', $bid)->execute(); } }
/** * Confirms that we can delete a single record successfully. */ function testSimpleDelete() { $num_records_before = db_query('SELECT COUNT(*) FROM {test}')->fetchField(); $num_deleted = db_delete('test')->condition('id', 1)->execute(); $this->assertIdentical($num_deleted, 1, 'Deleted 1 record.'); $num_records_after = db_query('SELECT COUNT(*) FROM {test}')->fetchField(); $this->assertEqual($num_records_before, $num_records_after + $num_deleted, 'Deletion adds up.'); }
/** * Delete an entry from the database. * */ public static function delete($entry) { $select = db_delete('ea_groupings'); foreach ($entry as $field => $value) { $select->condition($field, $value); } $select->execute(); }
/** * {@inheritdoc} */ public function process(OrderInterface $order, array $form, FormStateInterface $form_state) { db_delete('uc_order_comments')->condition('order_id', $order->id())->execute(); if (!$form_state->isValueEmpty(['panes', 'comments', 'comments'])) { uc_order_comment_save($order->id(), 0, $form_state->getValue(['panes', 'comments', 'comments']), 'order', uc_order_state_default('post_checkout'), TRUE); } return TRUE; }
public function delete() { $query = db_delete(static::$table); foreach ($this->values(static::$key) as $field => $value) { $query->condition($field, $value); } $query->execute(); $this->new = TRUE; }
function api_data_preset_gprint_remove($data_preset_gprint_id) { /* sanity checks */ validate_id_die($data_preset_gprint_id, "data_preset_gprint_id"); db_delete("preset_gprint", array( "id" => array("type" => DB_TYPE_INTEGER, "value" => $data_preset_gprint_id) )); }
/** * Performs actions on product classes. * * @param $type * The node type of the product class. * @param $op * The action being performed on the product class: * - insert: A new node type is created, or an existing node type is being * converted into a product type. * - update: A product class has been updated. * - delete: A product class has been deleted. Modules that have attached * additional information to the node type because it is a product type * should delete this information. */ function hook_uc_product_class($type, $op) { switch ($op) { case 'delete': db_delete('uc_class_attributes')->condition('pcid', $type)->execute(); db_delete('uc_class_attribute_options')->condition('pcid', $type)->execute(); break; } }
public function delete() { if ($this->consumerType) { $this->inDatabase = FALSE; return db_delete('ldap_authorization')->condition('consumer_type', $this->consumerType)->execute(); } else { return FALSE; } }
/** * Delete an agenda action */ function agenda_admin_delete_submit($form, $form_state) { // Clear the agenda variables table db_delete('agenda')->condition('bid', $form_state['values']['agenda_admin_delete_bid'])->execute(); // Also clear the block table db_delete('block')->condition('delta', $form_state['values']['agenda_admin_delete_bid'])->condition('module', 'agenda')->execute(); drupal_set_message('Agenda block was deleted'); drupal_goto('admin/config/services/agenda'); }