function logout($account_id)
{
$db_map_misc = new dbmapping_misc();
$db_map_misc->MAP_account_logout($account_id, $this);
}
function MAP_account_delete_misc($account_id, $username, $MAP_this)
{
### Get the remote account id from the username
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'SELECT id FROM ' . $db_prefix . 'members
WHERE name = ' . $db->qstr($username);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_get_remote_account_id', $db->ErrorMsg());
return;
}
$remote_account_id = $result->fields['id'];
if ($remote_account_id != "") {
### Convert their posts and topics into guest postings..
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'UPDATE ' . $db_prefix . 'posts SET
author_id=' . $db->qstr(0) . '
WHERE author_id=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_update_misc_posts_to_guests', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Convert their posts and topics into guest postings..
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'UPDATE ' . $db_prefix . 'topics SET
starter_id=' . $db->qstr(0) . '
WHERE starter_id=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_update_misc_topics_to_guests', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Delete their profile listings
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'DELETE FROM ' . $db_prefix . 'pfields_content WHERE member_id=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_topics_to_guests', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Delete member extra content
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'DELETE FROM ' . $db_prefix . 'member_extra WHERE id=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_member_extra_content', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Delete member messages
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'DELETE FROM ' . $db_prefix . 'messages WHERE member_id=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_member_messages', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Delete member contacts
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'DELETE FROM ' . $db_prefix . 'contacts WHERE member_id=' . $db->qstr($remote_account_id) . '
OR contact_id=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_member_contacts', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Delete member subscriptions tracker
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'DELETE FROM ' . $db_prefix . 'tracker WHERE member_id=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_member_sub_tracker', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Delete member subscriptions forum tracker
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'DELETE FROM ' . $db_prefix . 'forum_tracker WHERE member_id=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_member_sub_forum_tracker', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Delete member warn_logs
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'DELETE FROM ' . $db_prefix . 'warn_logs WHERE wlog_mid=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_member_warn_logs', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Delete member from validating
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'DELETE FROM ' . $db_prefix . 'validating WHERE member_id=' . $db->qstr($remote_account_id);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_member_validating', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### Delete IBF member avatar picture
$delete_avatars = new dbmapping_misc();
$delete_avatars->ibf_delete_avatars($remote_account_id);
### Delete IBF member profile picture
$delete_photos = new dbmapping_misc();
$delete_photos->ibf_delete_photos($remote_account_id);
### Get the member count from the remote db
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'SELECT MEM_COUNT FROM ' . $db_prefix . 'stats';
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_add_misc_get_remote_stats', $db->ErrorMsg());
return;
}
$mem_count = $result->fields['MEM_COUNT'] - 1;
### Update the IBF stats
$dbm = new db_mapping();
$db = $dbm->DB_connect(false, $MAP_this->map['map']);
eval('@$db_prefix = DB2_PREFIX' . strtoupper($MAP_this->map['map']) . ';');
$sql = 'UPDATE ' . $db_prefix . 'stats SET MEM_COUNT=' . $db->qstr($mem_count);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'Map_account_delete_misc_update_stats', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
}
}
