function mergeAccount($new_id, $old_id) { parent::mergeAccounts($new_id, $old_id); $query = 'UPDATE ' . $this->addDatabasePrefix('material_link_file') . ' SET deleter_id = "' . encode(AS_DB, $new_id) . '" WHERE deleter_id = "' . encode(AS_DB, $old_id) . '";'; $result = $this->_db_connector->performQuery($query); if (!isset($result) or !$result) { include_once 'functions/error_functions.php'; trigger_error('Problems creating material_link_file from query: "' . $query . '"', E_USER_WARNING); } }
function mergeAccounts($new_id, $old_id) { parent::mergeAccounts($new_id, $old_id); $query = 'SELECT * FROM ' . $this->addDatabasePrefix('link_items') . ' WHERE creator_id = "' . encode(AS_DB, $new_id) . '" AND first_item_id ="' . encode(AS_DB, $old_id) . '"'; $result = $this->_db_connector->performQuery($query); if (isset($result)) { foreach ($result as $row) { $update = "UPDATE " . $this->addDatabasePrefix("link_items") . " SET "; $update .= " first_item_id = " . encode(AS_DB, $new_id); $update .= " WHERE item_id = " . $row['item_id']; $result2 = $this->_db_connector->performQuery($update); if (!isset($result2) or !$result2) { include_once 'functions/error_functions.php'; trigger_error('Problems creating link_items: "' . $this->_dberror . '" from query: "' . $query . '"', E_USER_WARNING); } } } $query = 'SELECT * FROM ' . $this->addDatabasePrefix('link_items') . ' WHERE creator_id = "' . encode(AS_DB, $new_id) . '" AND second_item_id ="' . encode(AS_DB, $old_id) . '"'; $result = $this->_db_connector->performQuery($query); if (isset($result)) { foreach ($result as $row) { $update = "UPDATE " . $this->addDatabasePrefix("link_items") . " SET "; $update .= " second_item_id = " . encode(AS_DB, $new_id); $update .= " WHERE item_id = " . $row['item_id']; $result2 = $this->_db_connector->performQuery($update); if (!isset($result2) or !$result2) { include_once 'functions/error_functions.php'; trigger_error('Problems creating link_items from query: "' . $query . '"', E_USER_WARNING); } } } }