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);
}
}
}
}
