public function handle_deletion($is_topic_post, $id, $tid, $fid)
{
global $lang_delete;
require FEATHER_ROOT . 'include/search_idx.php';
if ($is_topic_post) {
// Delete the topic and all of its posts
delete_topic($tid);
update_forum($fid);
redirect(get_link('forum/' . $fid . '/'), $lang_delete['Topic del redirect']);
} else {
// Delete just this one post
delete_post($id, $tid);
update_forum($fid);
// Redirect towards the previous post
$post = DB::for_table('posts')->select('id')->where('topic_id', $tid)->where_lt('id', $id)->order_by_desc('id')->find_one();
redirect(get_link('post/' . $post['id'] . '/#p' . $post['id']), $lang_delete['Post del redirect']);
}
}
$all_id = '';
while ($row = $db->fetch_row($result)) {
$all_id .= ($all_id != '' ? ',' : '') . $row[0];
}
}
}
//Move post in the new topic
if ($all_id) {
$db->query('UPDATE ' . $db->prefix . 'posts SET topic_id=' . $new_topic_id . ' WHERE id IN(' . $all_id . ')') or error('Unable to update user last visit data', __FILE__, __LINE__, $db->error());
} else {
$db->query('UPDATE ' . $db->prefix . 'posts SET topic_id=' . $new_topic_id . ' WHERE id=' . $post_id) or error('Unable to update user last visit data', __FILE__, __LINE__, $db->error());
}
//Update topics and forum if required
update_topic($new_topic_id);
if ($del_old_topic || $all_id) {
delete_topic($old_topic_id);
update_forum($old_fid);
// Update the forum FROM which the topic was moved
if ($new_forum) {
update_forum($new_fid);
}
// Update the forum FROM which the topic was moved
require PUN_ROOT . 'include/search_idx.php';
// Bit silly should be probably improved: in order to remove the subject from the old topic, we need:
// 1. remove all the words (message and subject) from the search tables
// 2. add the words from the message only in the search tables !!!
strip_search_index($post_id);
update_search_index('post', $post_id, $message);
} else {
update_topic($old_topic_id);
if ($new_forum) {
$topic_post_id = $db->result($result);
$is_topic_post = $id == $topic_post_id ? true : false;
// Do we have permission to edit this post?
if (($pun_user['g_delete_posts'] == '0' || $pun_user['g_delete_topics'] == '0' && $is_topic_post || $cur_post['poster_id'] != $pun_user['id'] || $cur_post['closed'] == '1') && !$is_admmod) {
message($lang_common['No permission']);
}
// Load the delete.php language file
require PUN_ROOT . 'lang/' . $pun_user['language'] . '/delete.php';
if (isset($_POST['delete'])) {
if ($is_admmod) {
confirm_referrer('delete.php');
}
require PUN_ROOT . 'include/search_idx.php';
if ($is_topic_post) {
// Delete the topic and all of it's posts
delete_topic($cur_post['tid']);
update_forum($cur_post['fid']);
redirect('viewforum.php?id=' . $cur_post['fid'], $lang_delete['Topic del redirect']);
} else {
// Delete just this one post
delete_post($id, $cur_post['tid']);
update_forum($cur_post['fid']);
redirect('viewtopic.php?id=' . $cur_post['tid'], $lang_delete['Post del redirect']);
}
}
$page_title = pun_htmlspecialchars($pun_config['o_board_title']) . ' / ' . $lang_delete['Delete post'];
require PUN_ROOT . 'header.php';
require PUN_ROOT . 'include/parser.php';
$cur_post['message'] = parse_message($cur_post['message'], $cur_post['hide_smilies']);
?>
<div class="linkst">
function delete_user($user_id, $delete_posts = false)
{
global $forum_db, $db_type, $forum_config;
$return = ($hook = get_hook('fn_delete_user_start')) ? eval($hook) : null;
if ($return != null) {
return;
}
// First we need to get some data on the user
$query = array('SELECT' => 'u.username, u.group_id, g.g_moderator', 'FROM' => 'users AS u', 'JOINS' => array(array('INNER JOIN' => 'groups AS g', 'ON' => 'g.g_id=u.group_id')), 'WHERE' => 'u.id=' . $user_id);
($hook = get_hook('fn_delete_user_qr_get_user_data')) ? eval($hook) : null;
$result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
$user = $forum_db->fetch_assoc($result);
// Delete any subscriptions
$query = array('DELETE' => 'subscriptions', 'WHERE' => 'user_id=' . $user_id);
($hook = get_hook('fn_delete_user_qr_delete_subscriptions')) ? eval($hook) : null;
$forum_db->query_build($query) or error(__FILE__, __LINE__);
// Delete any subscriptions forum
$query = array('DELETE' => 'forum_subscriptions', 'WHERE' => 'user_id=' . $user_id);
($hook = get_hook('fn_delete_user_qr_delete_forum_subscriptions')) ? eval($hook) : null;
$forum_db->query_build($query) or error(__FILE__, __LINE__);
// Remove him/her from the online list (if they happen to be logged in)
$query = array('DELETE' => 'online', 'WHERE' => 'user_id=' . $user_id);
($hook = get_hook('fn_delete_user_qr_delete_online')) ? eval($hook) : null;
$forum_db->query_build($query) or error(__FILE__, __LINE__);
// Should we delete all posts made by this user?
if ($delete_posts) {
@set_time_limit(0);
// Find all posts made by this user
$query = array('SELECT' => 'p.id, p.topic_id, t.forum_id, t.first_post_id', 'FROM' => 'posts AS p', 'JOINS' => array(array('INNER JOIN' => 'topics AS t', 'ON' => 't.id=p.topic_id')), 'WHERE' => 'p.poster_id=' . $user_id);
($hook = get_hook('fn_delete_user_qr_get_user_posts')) ? eval($hook) : null;
$result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
while ($cur_post = $forum_db->fetch_assoc($result)) {
if ($cur_post['first_post_id'] == $cur_post['id']) {
delete_topic($cur_post['topic_id'], $cur_post['forum_id']);
} else {
delete_post($cur_post['id'], $cur_post['topic_id'], $cur_post['forum_id']);
}
}
} else {
// Set all his/her posts to guest
$query = array('UPDATE' => 'posts', 'SET' => 'poster_id=1', 'WHERE' => 'poster_id=' . $user_id);
($hook = get_hook('fn_delete_user_qr_reset_user_posts')) ? eval($hook) : null;
$forum_db->query_build($query) or error(__FILE__, __LINE__);
}
// Delete the user
$query = array('DELETE' => 'users', 'WHERE' => 'id=' . $user_id);
($hook = get_hook('fn_delete_user_qr_delete_user')) ? eval($hook) : null;
$forum_db->query_build($query) or error(__FILE__, __LINE__);
// Delete user avatar
delete_avatar($user_id);
// If the user is a moderator or an administrator, we remove him/her from the moderator list in all forums
// and regenerate the bans cache (in case he/she created any bans)
if ($user['group_id'] == FORUM_ADMIN || $user['g_moderator'] == '1') {
clean_forum_moderators();
// Regenerate the bans cache
if (!defined('FORUM_CACHE_FUNCTIONS_LOADED')) {
require FORUM_ROOT . 'include/cache.php';
}
generate_bans_cache();
}
($hook = get_hook('fn_delete_user_end')) ? eval($hook) : null;
}
$n = '&page=' . abs($n);
}
$path = $config['url_path'] . '/read.php?id=' . $delete_data['reply'] . $n;
print_out(lang('success_deleted_post'), lang('redirecting'), $path);
}
}
}
}
} else {
if (isset($_GET['delete_topic'])) {
if (alpha($_GET['delete_topic'], 'numeric')) {
// Try getting that data!
$delete_data = topic($_GET['delete_topic']);
// Is it their topic?
if ($delete_data['starter_id'] == $user_data['id']) {
$result = delete_topic($_GET['delete_topic']);
if ($result === "ID_INVALID") {
print_out(lang_parse('error_invalid_given', array(lang('id'))), lang('redirecting'));
} else {
if ($result === "DELETING_POSTS") {
print_out(lang('error_deleting_posts'), lang('redirecting'));
} else {
if ($result === "DELETING_TOPIC") {
print_out(lang('error_deleting_topic'), lang('redirecting'));
}
}
}
if (!$error) {
print_out(lang('success_deleted_topic'), lang('redirecting'));
}
}
protected function delete()
{
global $db;
$params = array();
if ($this->method == "POST") {
if (sizeof($this->args) == 2) {
$type = $this->args[0];
$main_arg = $this->args[1];
if (is_numeric($main_arg)) {
if ($type == "subject") {
$params["sid"] = $main_arg;
return delete_subject($db, $params);
} else {
if ($type == "topic") {
$params["tid"] = $main_arg;
return delete_topic($db, $params);
} else {
if ($type == "section") {
$params["section_id"] = $main_arg;
return delete_section($db, $params);
} else {
if ($type == "example") {
$params["eid"] = $main_arg;
return delete_example($db, $params);
} else {
return "No such object exists in the database!";
}
}
}
}
} else {
return "The associated id needs to be a numerical value!";
}
} else {
return "This requires two parameters: the object type and associated id!";
}
} else {
return "This only accepts POST requests!";
}
}
$title = "FaqForge - $context";
$dbLink = mysql_connect ($dbServer, $dbUser, $dbPass);
mysql_select_db ($dbName);
switch ( $action )
{
case "deleteTopic":
{
$message = delete_topic_test ( $id, $dbLink );
break;
}
case "DELETEtopic": // FAULT_3 WDM
{
delete_topic ( $id, $dbLink );
break;
}
case "addNewTopic":
{
add_new_topic ( $newTitle, $newParent, $newContext, $newOrder, $dbLink );
break;
}
case "commit":
{
update_page ( stripslashes($faqText), $pageId, $id, $dbLink );
break;
}
case "Update Topic":
{
$topicPublish = ( $topicPublish == "on" ) ? "y" : "n";
function op_topic_del($id, $change, $reason, $check = false)
{
$topic = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "topic where id = " . $id);
if ($check) {
$result['status'] = 1;
return $result;
}
if (check_user_auth("topic", "del")) {
require_once APP_ROOT_PATH . 'system/model/topic.php';
$del_result = delete_topic($id);
$o_reason = $reason;
$reason .= "分享被删除";
if ($change == 1) {
modify_account(get_op_change("topic", "del"), $topic['user_id'], $reason);
$reason .= get_op_change_show("topic", "del");
}
if ($change == 1 || $o_reason != "") {
send_msg($topic['user_id'], $reason, "notify", 0);
}
$result['status'] = 1;
} else {
$result['status'] = 0;
$result['info'] = "没有权限";
}
return $result;
}
redirect('viewforum.php?id=' . $cur_post['fid']);
} else {
// Reset just this one post
$db->query('UPDATE ' . $db->prefix . 'posts SET soft = 0 WHERE id=' . $id) or error('Unable to soft delete post', __FILE__, __LINE__, $db->error());
update_forum($cur_post['fid']);
// Redirect towards the comment
redirect('viewtopic.php?pid=' . $id . '#p' . $id);
}
}
if (isset($_POST['delete'])) {
// Make sure they got here from the site
confirm_referrer('delete.php');
require FORUM_ROOT . 'include/search_idx.php';
if ($is_topic_post) {
// Delete the thread and all of its posts
delete_topic($cur_post['tid'], "hard");
update_forum($cur_post['fid']);
redirect('viewforum.php?id=' . $cur_post['fid']);
} else {
// Delete just this one post
delete_post($id, $cur_post['tid'], $cur_post['poster_id']);
update_forum($cur_post['fid']);
// Redirect towards the previous post
$result = $db->query('SELECT id FROM ' . $db->prefix . 'posts WHERE topic_id=' . $cur_post['tid'] . ' AND id < ' . $id . ' ORDER BY id DESC LIMIT 1') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
$post_id = $db->result($result);
redirect('viewtopic.php?pid=' . $post_id . '#p' . $post_id);
}
}
$page_title = array(luna_htmlspecialchars($luna_config['o_board_title']), __('Delete comment', 'luna'));
define('FORUM_ACTIVE_PAGE', 'delete');
require FORUM_ROOT . 'include/parser.php';
patch_topic($id);
?>
</li>
</ul>
</div>
<br />
<div class="table_main">
<div id="container">
<?php
// blocco topic
if (@$_POST['block'] == 1) {
manage_block_topic($username, $id);
}
// cancello topic
if (@$_POST['delete_topic'] == 1) {
delete_topic($username, $id);
}
// aggiunta nuovo messaggio
if (@$_GET['send'] == 1) {
insert_topic(@$_POST['reply'], $id);
}
// sposto topic
if (@$_GET['move_topic'] == 1) {
move_topic(@$_POST['move_t_id'], @$_POST['to_forum']);
}
// setta topic
if (@$_GET['set_topic'] == 1) {
set_topic(@$_POST['set_topic'], $id);
}
$t_id = check_t_id($id);
$query = "SELECT id, f_id, t_id, author, title, data, replyof, last, ora, date \n\t\t FROM " . __PREFIX__ . "topic \n\t\t WHERE id = '" . $id . "' \n\t\t OR replyof = '" . $id . "' \n\t\t ORDER BY id, last DESC";
public function delete_users()
{
global $lang_admin_users;
if ($this->request->post('users')) {
$user_ids = is_array($this->request->post('users')) ? array_keys($this->request->post('users')) : explode(',', $this->request->post('users'));
$user_ids = array_map('intval', $user_ids);
// Delete invalid IDs
$user_ids = array_diff($user_ids, array(0, 1));
} else {
$user_ids = array();
}
if (empty($user_ids)) {
message($lang_admin_users['No users selected']);
}
// Are we trying to delete any admins?
$is_admin = DB::for_table('users')->where_in('id', $user_ids)->where('group_id', FEATHER_ADMIN)->find_one();
if ($is_admin) {
message($lang_admin_users['No delete admins message']);
}
if ($this->request->post('delete_users_comply')) {
// Fetch user groups
$user_groups = array();
$select_fetch_user_groups = array('id', 'group_id');
$result = DB::for_table('users')->select_many($select_fetch_user_groups)->where_in('id', $user_ids)->find_many();
foreach ($result as $cur_user) {
if (!isset($user_groups[$cur_user['group_id']])) {
$user_groups[$cur_user['group_id']] = array();
}
$user_groups[$cur_user['group_id']][] = $cur_user['id'];
}
// Are any users moderators?
$group_ids = array_keys($user_groups);
$select_fetch_user_mods = array('g_id', 'g_moderator');
$result = DB::for_table('groups')->select_many($select_fetch_user_mods)->where_in('g_id', $group_ids)->find_many();
foreach ($result as $cur_group) {
if ($cur_group['g_moderator'] == '0') {
unset($user_groups[$cur_group['g_id']]);
}
}
// Fetch forum list and clean up their moderator list
$select_mods = array('id', 'moderators');
$result = DB::for_table('forums')->select_many($select_mods)->find_many();
foreach ($result as $cur_forum) {
$cur_moderators = $cur_forum['moderators'] != '' ? unserialize($cur_forum['moderators']) : array();
foreach ($user_groups as $group_users) {
$cur_moderators = array_diff($cur_moderators, $group_users);
}
if (!empty($cur_moderators)) {
DB::for_table('forums')->where('id', $cur_forum['id'])->find_one()->set('moderators', serialize($cur_moderators))->save();
} else {
DB::for_table('forums')->where('id', $cur_forum['id'])->find_one()->set_expr('moderators', 'NULL')->save();
}
}
// Delete any subscriptions
DB::for_table('topic_subscriptions')->where_in('user_id', $user_ids)->delete_many();
DB::for_table('forum_subscriptions')->where_in('user_id', $user_ids)->delete_many();
// Remove them from the online list (if they happen to be logged in)
DB::for_table('online')->where_in('user_id', $user_ids)->delete_many();
// Should we delete all posts made by these users?
if ($this->request->post('delete_posts')) {
require FEATHER_ROOT . 'include/search_idx.php';
@set_time_limit(0);
// Find all posts made by this user
$select_user_posts = array('p.id', 'p.topic_id', 't.forum_id');
$result = DB::for_table('posts')->table_alias('p')->select_many($select_user_posts)->inner_join('topics', array('t.id', '=', 'p.topic_id'), 't')->inner_join('forums', array('f.id', '=', 't.forum_id'), 'f')->where('p.poster_id', $user_ids)->find_many();
if ($result) {
foreach ($result as $cur_post) {
// Determine whether this post is the "topic post" or not
$result2 = DB::for_table('posts')->where('topic_id', $cur_post['topic_id'])->order_by('posted')->find_one_col('id');
if ($this->db->result($result2) == $cur_post['id']) {
delete_topic($cur_post['topic_id']);
} else {
delete_post($cur_post['id'], $cur_post['topic_id']);
}
update_forum($cur_post['forum_id']);
}
}
} else {
// Set all their posts to guest
DB::for_table('posts')->where_in('poster_id', '1')->update_many('poster_id', $user_ids);
}
// Delete the users
DB::for_table('users')->where_in('id', $user_ids)->delete_many();
// Delete user avatars
foreach ($user_ids as $user_id) {
delete_avatar($user_id);
}
// Regenerate the users info cache
if (!defined('FORUM_CACHE_FUNCTIONS_LOADED')) {
require FEATHER_ROOT . 'include/cache.php';
}
generate_users_info_cache();
redirect(get_link('admin/users/'), $lang_admin_users['Users delete redirect']);
}
return $user_ids;
}
$form->assign('nextCommand', 'exEditTopic');
$form->assign('topicTitle', $topicSettingList['topic_title']);
$dialogBox->form($form->render());
} catch (Exception $ex) {
if (claro_debug_mode()) {
$dialogBox->error('<pre>' . $ex->__toString() . '</pre>');
} else {
$dialogBox->error($ex->getMessage());
}
}
} else {
$dialogBox->error(get_lang('Unknown topic'));
}
break;
case 'exDelTopic':
if (delete_topic($topicId)) {
$dialogBox->success(get_lang('This topic has been deleted'));
} else {
$dialogBox->error(get_lang('Error while deleting topic'));
}
break;
//TODO : lock and notification commands should be handled by ajax calls
//TODO : lock and notification commands should be handled by ajax calls
case 'exLock':
if (set_topic_lock_status($topicId, true)) {
$dialogBox->success(get_lang('This topic is now locked'));
} else {
$dialogBox->error(get_lang('Error while updating topic lock status'));
}
break;
case 'exUnlock':
public function do_del_topic()
{
global_run();
if (intval($GLOBALS['user_info']['id']) == 0) {
$result['status'] = 0;
$result['info'] = $GLOBALS['lang']['PLEASE_LOGIN_FIRST'];
} else {
$id = intval($_REQUEST['id']);
$topic = $GLOBALS['db']->getRow("select id,user_id from " . DB_PREFIX . "topic where id = " . $id);
if (!$topic) {
$result['status'] = 0;
$result['info'] = $GLOBALS['lang']['TOPIC_NOT_EXIST'];
} else {
$count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "topic where (fav_id = " . $id . " or (origin_id = " . $id . " and fav_id <> 0)) and user_id = " . intval($GLOBALS['user_info']['id']));
if ($count > 0) {
$result['status'] = 1;
require_once APP_ROOT_PATH . "system/model/topic.php";
$del_id = $GLOBALS['db']->getOne("SELECT id FROM " . DB_PREFIX . "topic where (fav_id = " . $id . " or (origin_id = " . $id . " and fav_id <> 0)) and user_id = " . intval($GLOBALS['user_info']['id']));
$tid = delete_topic($del_id);
} else {
$result['status'] = 0;
$result['info'] = "你还没喜欢";
}
}
}
ajax_return($result);
}
$db->update('users', $update, 'id=:id', $data);
}
}
update_forum($post['forum_id']);
redirect(panther_link($panther_url['admin_posts']), $lang_admin_posts['Post approved redirect']);
} else {
if (($panther_user['g_mod_sfs_report'] == '1' || $panther_user['is_admin']) && $action == '3' && $panther_config['o_sfs_api'] != '') {
//If the user wasn't a guest we need to get the email from the users table
$email = $post['poster_email'] == '' && $post['poster_id'] != 1 ? $post['email'] : $post['poster_email'];
//Reporting now made fun =)
if (!stopforumspam_report($panther_config['o_sfs_api'], $post['poster_ip'], $email, $post['poster'], $post['message'])) {
message($lang_common['Unable to add spam data']);
}
}
if ($is_topic_post) {
delete_topic($post['topic_id']);
update_forum($post['forum_id']);
} else {
delete_post($post_id, $post['topic_id']);
update_forum($post['forum_id']);
}
redirect(panther_link($panther_url['admin_posts']), $lang_admin_posts['Post deleted redirect']);
}
}
$data = array(':gid' => $panther_user['g_id']);
$page_title = array($panther_config['o_board_title'], $lang_admin_common['Admin'], $lang_admin_common['Posts']);
define('PANTHER_ACTIVE_PAGE', 'admin');
require PANTHER_ROOT . 'header.php';
generate_admin_menu('posts');
$posts = array();
$ps = $db->run('SELECT t.id AS topic_id, t.forum_id, p.poster, p.poster_id, p.posted, p.message, p.id AS pid, p.hide_smilies, t.subject, f.forum_name, f.moderators FROM ' . $db->prefix . 'posts AS p INNER JOIN ' . $db->prefix . 'topics AS t ON p.topic_id = t.id LEFT JOIN ' . $db->prefix . 'forums AS f ON t.forum_id = f.id LEFT JOIN ' . $db->prefix . 'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=:gid) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND p.approved=0 AND p.deleted=0 ORDER BY p.posted DESC', $data);
create_topic(Flight::request());
});
Flight::route('GET /topics', function () {
incl('get_topics');
get_topics(Flight::request());
});
Flight::route('/topics', function () {
method_not_allowed();
});
Flight::route('GET /topics/@topic_id', function ($topic_id) {
incl('get_topic');
get_topic($topic_id, Flight::request());
});
Flight::route('DELETE /topics/@topic_id', function ($topic_id) {
incl('delete_topic');
delete_topic($topic_id, Flight::request());
});
Flight::route('/topic/@topic_id', function ($topic_id) {
method_not_allowed();
});
Flight::route('POST /single_use/programming_language_test', function () {
incl('test_programming_language');
test_programming_language(Flight::request());
});
Flight::route('/single_use/programming_language_test', function () {
method_not_allowed();
});
Flight::route('POST /single_use/question_test', function () {
incl('test_question');
test_question(Flight::request());
});
public function delete_user($id)
{
global $lang_profile;
// Get the username and group of the user we are deleting
$select_info_delete_user = array('group_id', 'username');
$result = DB::for_table('users')->where('id', $id)->select_many($select_info_delete_user)->find_one();
$group_id = $result['group_id'];
$username = $result['username'];
if ($group_id == FEATHER_ADMIN) {
message($lang_profile['No delete admin message']);
}
if ($this->request->post('delete_user_comply')) {
// If the user is a moderator or an administrator, we remove him/her from the moderator list in all forums as well
$group_mod = DB::for_table('groups')->where('g_id', $group_id)->find_one_col('g_moderator');
if ($group_id == FEATHER_ADMIN || $group_mod == '1') {
$select_info_delete_moderators = array('id', 'moderators');
$result = DB::for_table('forums')->select_many($select_info_delete_moderators)->find_many();
foreach ($result as $cur_forum) {
$cur_moderators = $cur_forum['moderators'] != '' ? unserialize($cur_forum['moderators']) : array();
if (in_array($id, $cur_moderators)) {
unset($cur_moderators[$username]);
if (!empty($cur_moderators)) {
DB::for_table('forums')->where('id', $cur_forum['id'])->find_one()->set('moderators', serialize($cur_moderators))->save();
} else {
DB::for_table('forums')->where('id', $cur_forum['id'])->find_one()->set_expr('moderators', 'NULL')->save();
}
}
}
}
// Delete any subscriptions
DB::for_table('topic_subscriptions')->where('user_id', $id)->delete_many();
DB::for_table('forum_subscriptions')->where('user_id', $id)->delete_many();
// Remove him/her from the online list (if they happen to be logged in)
DB::for_table('online')->where('user_id', $id)->delete_many();
// Should we delete all posts made by this user?
if ($this->request->post('delete_posts')) {
require FEATHER_ROOT . 'include/search_idx.php';
// Hold on, this could take some time!
@set_time_limit(0);
// Find all posts made by this user
$select_user_posts = array('p.id', 'p.topic_id', 't.forum_id');
$result = DB::for_table('posts')->table_alias('p')->select_many($select_user_posts)->inner_join('topics', array('t.id', '=', 'p.topic_id'), 't')->inner_join('forums', array('f.id', '=', 't.forum_id'), 'f')->where('p.poster_id', $id)->find_many();
if ($result) {
foreach ($result as $cur_post) {
// Determine whether this post is the "topic post" or not
$result2 = DB::for_table('posts')->where('topic_id', $cur_post['topic_id'])->order_by('posted')->find_one_col('id');
if ($this->db->result($result2) == $cur_post['id']) {
delete_topic($cur_post['topic_id']);
} else {
delete_post($cur_post['id'], $cur_post['topic_id']);
}
update_forum($cur_post['forum_id']);
}
}
} else {
// Set all his/her posts to guest
DB::for_table('posts')->where_in('poster_id', '1')->update_many('poster_id', $id);
}
// Delete the user
DB::for_table('users')->where('id', $id)->delete_many();
// Delete user avatar
delete_avatar($id);
// Regenerate the users info cache
if (!defined('FORUM_CACHE_FUNCTIONS_LOADED')) {
require FEATHER_ROOT . 'include/cache.php';
}
generate_users_info_cache();
if ($group_id == FEATHER_ADMIN) {
generate_admins_cache();
}
redirect(get_base_url(), $lang_profile['User delete redirect']);
}
}
