PHP deletepost函数代码示例

 function usesubmit()
 {
     global $_G;
     if (empty($_GET['pid'])) {
         showmessage(lang('magic/repent', 'repent_info_nonexistence'));
     }
     $_G['tid'] = $_GET['ptid'];
     $post = getpostinfo($_GET['pid'], 'pid', array('p.first', 'p.tid', 'p.fid', 'p.authorid', 'p.replycredit', 't.status as thread_status'));
     $this->_check($post);
     require_once libfile('function/post');
     require_once libfile('function/delete');
     if ($post['first']) {
         if ($have_replycredit = C::t('forum_replycredit')->fetch($post['tid'])) {
             $thread = C::t('forum_thread')->fetch($post['tid']);
             if ($thread['replycredit']) {
                 updatemembercount($post['authorid'], array($_G['setting']['creditstransextra'][10] => $replycredit));
             }
             C::t('forum_replycredit')->delete($post['tid']);
             C::t('common_credit_log')->delete_by_operation_relatedid(array('RCT', 'RCA', 'RCB'), $post['tid']);
         }
         deletethread(array($post['tid']));
         updateforumcount($post['fid']);
     } else {
         if ($post['replycredit'] > 0) {
             updatemembercount($post['authorid'], array($_G['setting']['creditstransextra'][10] => -$post['replycredit']));
             C::t('common_credit_log')->delete_by_uid_operation_relatedid($post['authorid'], 'RCA', $post['tid']);
         }
         deletepost(array($_GET['pid']));
         updatethreadcount($post['tid']);
     }
     usemagic($this->magic['magicid'], $this->magic['num']);
     updatemagiclog($this->magic['magicid'], '2', '1', '0', 0, 'tid', $_G['tid']);
     showmessage(lang('magic/repent', 'repent_succeed'), $post['first'] ? 'forum.php?mod=forumdisplay&fid=' . $post['fid'] : dreferer(), array(), array('alert' => 'right', 'showdialog' => 1, 'locationtime' => true));
 }

 function usesubmit()
 {
     global $_G;
     if (empty($_G['gp_pid'])) {
         showmessage(lang('magic/repent', 'repent_info_nonexistence'));
     }
     $_G['tid'] = $_G['gp_ptid'];
     $post = getpostinfo($_G['gp_pid'], 'pid', array('p.first', 'p.tid', 'p.fid', 'p.authorid', 'p.replycredit', 't.status as thread_status'));
     $this->_check($post);
     require_once libfile('function/post');
     require_once libfile('function/delete');
     if ($post['first']) {
         if ($have_replycredit = DB::fetch_first("SELECT * FROM " . DB::table('forum_replycredit') . " WHERE tid ='{$post['tid']}' LIMIT 1")) {
             if ($replycredit = DB::result_first("SELECT replycredit FROM " . DB::table('forum_thread') . " WHERE tid = '{$post['tid']}'")) {
                 updatemembercount($post['authorid'], array($_G['setting']['creditstransextra'][10] => $replycredit));
             }
             DB::delete('forum_replycredit', "tid = '{$post['tid']}'");
             DB::delete('common_credit_log', "operation IN ('RCT', 'RCA', 'RCB') AND relatedid IN({$post['tid']})");
         }
         deletethread(array($post['tid']));
         updateforumcount($post['fid']);
     } else {
         if ($post['replycredit'] > 0) {
             updatemembercount($post['authorid'], array($_G['setting']['creditstransextra'][10] => -$post['replycredit']));
             DB::delete('common_credit_log', "uid = '{$post['authorid']}' AND operation = 'RCA' AND relatedid IN({$post['tid']})");
         }
         deletepost(array($_G['gp_pid']));
         updatethreadcount($post['tid']);
     }
     usemagic($this->magic['magicid'], $this->magic['num']);
     updatemagiclog($this->magic['magicid'], '2', '1', '0', 0, 'tid', $_G['tid']);
     showmessage(lang('magic/repent', 'repent_succeed'), $post['first'] ? 'forum.php?mod=forumdisplay&fid=' . $post['fid'] : dreferer(), array(), array('showdialog' => 1, 'locationtime' => true));
 }

 protected function _handleEvilPost($tid, $pid, $evilType, $evilLevel = 1)
 {
     include_once DISCUZ_ROOT . './source/language/lang_admincp_cloud.php';
     $securityService = Cloud::loadClass('Service_Security');
     $securityService->writeLog($pid, 'pid');
     $evilPost = C::t('#security#security_evilpost')->fetch($pid);
     if (count($evilPost)) {
         return true;
     } else {
         require_once libfile('function/delete');
         require_once libfile('function/forum');
         require_once libfile('function/post');
         $data = array('pid' => $pid, 'tid' => $tid, 'evilcount' => 1, 'eviltype' => $evilType, 'createtime' => TIMESTAMP);
         $post = get_post_by_pid($pid);
         if (is_array($post) && count($post) > 0) {
             if ($tid != $post['tid']) {
                 return false;
             }
             $thread = get_thread_by_tid($tid);
             if ($post['first']) {
                 $data['type'] = 1;
                 if ($this->_checkThreadIgnore($tid)) {
                     return false;
                 }
                 C::t('#security#security_evilpost')->insert($data, false, true);
                 $this->_updateEvilCount('thread');
                 deletethread(array($tid), true, true, true);
                 updatemodlog($tid, 'DEL', 0, 1, $extend_lang['security_modreason']);
             } else {
                 $data['type'] = 0;
                 if ($this->_checkPostIgnore($pid, $post)) {
                     return false;
                 }
                 C::t('#security#security_evilpost')->insert($data, false, true);
                 $this->_updateEvilCount('post');
                 deletepost(array($pid), 'pid', true, false, true);
             }
             if (!empty($post['authorid'])) {
                 $data = array('uid' => $post['authorid'], 'createtime' => TIMESTAMP);
                 C::t('#security#security_eviluser')->insert($data, false, true);
             }
         } else {
             $data['operateresult'] = 2;
             C::t('#security#security_evilpost')->insert($data, false, true);
         }
         if ($evilLevel >= 5) {
             $user = C::t('common_member')->fetch($post['authorid'], 0, 1);
             $this->_handleBandUser($user, 1);
         }
     }
     return true;
 }

 function usesubmit()
 {
     global $_G;
     if (empty($_G['gp_pid'])) {
         showmessage(lang('magic/repent', 'repent_info_nonexistence'));
     }
     $_G['tid'] = $_G['gp_ptid'];
     $post = getpostinfo($_G['gp_pid'], 'pid', array('p.first', 'p.tid', 'p.fid', 'p.authorid'));
     $this->_check($post);
     require_once libfile('function/post');
     require_once libfile('function/delete');
     if ($post['first']) {
         deletethread("tid='{$post['tid']}'");
         updateforumcount($post['fid']);
     } else {
         deletepost("pid='{$_G['gp_pid']}'");
         updatethreadcount($post['tid']);
     }
     usemagic($this->magic['magicid'], $this->magic['num']);
     updatemagiclog($this->magic['magicid'], '2', '1', '0', 0, 'tid', $_G['tid']);
     showmessage(lang('magic/repent', 'repent_succeed'), $post['first'] ? 'forum.php?mod=forumdisplay&fid=' . $post['fid'] : dreferer(), array(), array('showdialog' => 1, 'locationtime' => 1));
 }

     $prune['forums'][] = $post['fid'];
     $prune['thread'][$post['tid']]++;
     $pidsdelete[] = $post['pid'];
     if ($post['first']) {
         $tidsdelete[] = $post['tid'];
     }
     if ($post['first']) {
         my_thread_log('delete', array('tid' => $post['tid']));
     } else {
         my_post_log('delete', array('pid' => $post['pid']));
     }
 }
 if ($pidsdelete) {
     require_once libfile('function/post');
     require_once libfile('function/delete');
     $deletedposts = deletepost($pidsdelete, 'pid', !$_G['gp_donotupdatemember'], $posttable);
     $deletedthreads = deletethread($tidsdelete, !$_G['gp_donotupdatemember'], !$_G['gp_donotupdatemember']);
     if (count($prune['thread']) < 50) {
         foreach ($prune['thread'] as $tid => $decrease) {
             updatethreadcount($tid);
         }
     } else {
         $repliesarray = array();
         foreach ($prune['thread'] as $tid => $decrease) {
             $repliesarray[$decrease][] = $tid;
         }
         foreach ($repliesarray as $decrease => $tidarray) {
             DB::query("UPDATE " . DB::table('forum_thread') . " SET replies=replies-{$decrease} WHERE tid IN (" . implode(',', $tidarray) . ")");
         }
     }
     if ($_G['setting']['globalstick']) {

     $tileid = mysql_real_escape_string($_POST['tileid']);
     $userid = mysql_real_escape_string($_POST['userid']);
     sorttiles($tileid, $userid);
     break;
 case "homepage_public":
     $id = mysql_real_escape_string($_POST['id']);
     homepage_public($authuserid);
     break;
 case "userpublic_detail":
     $id = mysql_real_escape_string($_POST['id']);
     userpublic_detail($id);
     break;
 case "deletepost":
     $finao_id = mysql_real_escape_string($_POST['finao_id']);
     $userpostid = mysql_real_escape_string($_POST['userpostid']);
     deletepost($authuserid, $finao_id, $userpostid);
     break;
 case "registration":
     $type = mysql_real_escape_string($_POST['type']);
     $email = mysql_real_escape_string($_POST['email']);
     $password = mysql_real_escape_string($_POST['password']);
     $fname = mysql_real_escape_string($_POST['fname']);
     $lname = mysql_real_escape_string($_POST['lname']);
     $fbid = 0;
     if ($type == 2) {
         $fbid = mysql_real_escape_string($_POST['facebook_id']);
     }
     registration($type, $email, $password, $fname, $lname, $fbid);
     break;
 case "whotofollow":
     whotofollow($authuserid);

function deletethreads($tids = array())
{
    global $_G;
    static $cleartable = array('forum_threadmod', 'forum_relatedthread', 'forum_post', 'forum_poll', 'forum_polloption', 'forum_trade', 'forum_activity', 'forum_activityapply', 'forum_debate', 'forum_debatepost', 'forum_attachment', 'forum_typeoptionvar', 'forum_forumrecommend', 'forum_postposition');
    foreach ($tids as $tid) {
        my_thread_log('delete', array('tid' => $tid));
    }
    $threadsdel = 0;
    if ($tids = dimplode($tids)) {
        $auidarray = array();
        $query = DB::query("SELECT uid, attachment, dateline, thumb, remote, aid FROM " . DB::table('forum_attachment') . " WHERE tid IN ({$tids})");
        while ($attach = DB::fetch($query)) {
            dunlink($attach);
            if ($attach['dateline'] > $_G['setting']['losslessdel']) {
                $auidarray[$attach['uid']] = !empty($auidarray[$attach['uid']]) ? $auidarray[$attach['uid']] + 1 : 1;
            }
        }
        if ($auidarray) {
            updateattachcredits('-', $auidarray, $_G['setting']['creditspolicy']['postattach']);
        }
        require_once libfile('function/delete');
        foreach ($cleartable as $tb) {
            if ($tb == 'forum_post') {
                deletepost("tid IN ({$tids})");
                continue;
            }
            DB::query("DELETE FROM " . DB::table($tb) . " WHERE tid IN ({$tids})", 'UNBUFFERED');
        }
        DB::query("DELETE FROM " . DB::table('forum_thread') . " WHERE tid IN ({$tids})");
        $threadsdel = DB::affected_rows();
    }
    return $threadsdel;
}

                 $tidsdelete[] = $post['tid'];
             }
             $pidsdelete[] = $post['pid'];
             $pidsthread[$post['pid']] = $post['tid'];
         }
         foreach ($pidsdelete as $key => $pid) {
             if (in_array($pidsthread[$pid], $tidsdelete)) {
                 unset($pidsdelete[$key]);
                 unset($prune['thread'][$pidsthread[$pid]]);
                 updatemodlog($pidsthread[$pid], 'DEL');
             } else {
                 updatemodlog($pidsthread[$pid], 'DLP');
             }
         }
     }
     deletepost($pidsdelete, 'pid', false, $posttableid, true);
 }
 unset($postlist);
 if ($tidsdelete) {
     deletethread($tidsdelete, true, true, true);
 }
 if (!empty($prune)) {
     foreach ($prune['thread'] as $tid => $decrease) {
         updatethreadcount($tid);
     }
     foreach (array_unique($prune['forums']) as $fid) {
     }
 }
 if ($_G['setting']['globalstick']) {
     updatecache('globalstick');
 }

         if ($post['first']) {
             $tuidarray[] = $post['authorid'];
         } else {
             $ruidarray[] = $post['authorid'];
         }
     }
     if ($tuidarray) {
         updatepostcredits('-', $tuidarray, 'post');
     }
     if ($ruidarray) {
         updatepostcredits('-', $ruidarray, 'reply');
     }
 }
 require_once libfile('function/delete');
 $deletedposts = deletepost("pid IN ({$pidsdelete})");
 $deletedposts += deletepost("tid IN ({$tidsdelete})");
 $deletedthreads = deletethread("tid IN ({$tidsdelete})");
 if (count($prune['thread']) < 50) {
     foreach ($prune['thread'] as $tid => $decrease) {
         updatethreadcount($tid);
     }
 } else {
     $repliesarray = array();
     foreach ($prune['thread'] as $tid => $decrease) {
         $repliesarray[$decrease][] = $tid;
     }
     foreach ($repliesarray as $decrease => $tidarray) {
         DB::query("UPDATE " . DB::table('forum_thread') . " SET replies=replies-{$decrease} WHERE tid IN (" . implode(',', $tidarray) . ")");
     }
 }
 foreach (array_unique($prune['forums']) as $id) {

     $result['count'] = count($result['pids']);
     $modsession->set($cachekey, $result, true);
     unset($result);
 }
 if ($pidsdelete) {
     require_once libfile('function/post');
     require_once libfile('function/delete');
     $forums = array();
     $query = DB::query('SELECT fid, recyclebin FROM ' . DB::table('forum_forum') . " WHERE fid IN (" . dimplode($prune['forums']) . ")");
     while ($value = DB::fetch($query)) {
         $forums[$value['fid']] = $value;
     }
     foreach ($pidsdelete as $fid => $pids) {
         foreach ($pids as $pid) {
             if (!$tidsdelete[$pid]) {
                 $deletedposts = deletepost($pid, 'pid', !getgpc('nocredit'), $posttableid, $forums[$fid]['recyclebin']);
                 updatemodlog($pids_tids[$pid], 'DLP');
             } else {
                 $deletedthreads = deletethread($tidsdelete[$pid], false, !getgpc('nocredit'), $forums[$fid]['recyclebin']);
                 updatemodlog($tidsdelete[$pid], 'DEL');
             }
         }
     }
     if (count($prune['thread']) < 50) {
         foreach ($prune['thread'] as $tid => $decrease) {
             updatethreadcount($tid);
         }
     } else {
         $repliesarray = array();
         foreach ($prune['thread'] as $tid => $decrease) {
             $repliesarray[$decrease][] = $tid;

function recyclebinpostdelete($deletepids, $posttableid = false)
{
    if (empty($deletepids)) {
        return 0;
    }
    require_once libfile('function/delete');
    return deletepost($deletepids, 'pid', true, $posttableid);
}

function handleEvilPost($tid, $pid, $evilType, $evilLevel = 1)
{
    global $_G;
    if (notOpenService()) {
        return false;
    }
    include_once DISCUZ_ROOT . './source/language/lang_admincp_cloud.php';
    loadSecLog($pid, 'pid');
    $evilPost = DB::fetch_first("SELECT * FROM " . DB::table('security_evilpost') . " WHERE pid='{$pid}'");
    if (is_array($evilPost)) {
        $data = $evilPost;
        $data['evilcount'] = $evilPost['evilcount'] + 1;
    } else {
        require_once libfile('function/delete');
        require_once libfile('function/forum');
        require_once libfile('function/post');
        $data = array('pid' => $pid, 'tid' => $tid, 'evilcount' => 1, 'eviltype' => $evilType, 'createtime' => TIMESTAMP);
        $post = get_post_by_pid($pid);
        if (is_array($post) && count($post) > 0) {
            if ($tid != $post['tid']) {
                return false;
            }
            if ($post['first']) {
                $data['type'] = 1;
                if (checkThreadIgnore($tid)) {
                    return false;
                }
                DB::insert('security_evilpost', $data, 0, 1);
                updateEvilCount('thread');
                DB::query("UPDATE " . DB::table('forum_thread') . " SET displayorder='-1', digest='0', moderated='1' WHERE tid = '" . $tid . "'");
                deletethread(array($tid), true, true, true);
                updatepost(array('invisible' => '-1'), "tid = '" . $tid . "'");
                updatemodlog($tid, 'DEL', 0, 1, $extend_lang['security_modreason']);
            } else {
                $data['type'] = 0;
                if (checkPostIgnore($pid, $post)) {
                    return false;
                }
                DB::insert('security_evilpost', $data, 0, 1);
                updateEvilCount('post');
                deletepost(array($pid), 'pid', true, false, true);
            }
        } else {
            $data['operateresult'] = 2;
            DB::insert('security_evilpost', $data, 0, 1);
        }
    }
    return true;
}

         dunlink($attach);
     }
     if ($member['uid']) {
         require_once libfile('function/post');
         $pidsdelete = $tidsdelete = '0';
         $postarray = getfieldsofposts('pid, fid, tid, first', "authorid='{$member['uid']}'");
         foreach ($postarray as $post) {
             $prune['forums'][] = $post['fid'];
             $prune['thread'][$post['tid']]++;
             if ($post['first']) {
                 $tidsdelete .= ",{$post['tid']}";
             }
             $pidsdelete .= ",{$post['pid']}";
         }
         deletepost("pid IN ({$pidsdelete})");
         deletepost("tid IN ({$tidsdelete})");
         deletethread("tid IN ({$tidsdelete})");
         if (!empty($prune)) {
             foreach ($prune['thread'] as $tid => $decrease) {
                 updatethreadcount($tid);
             }
             foreach (array_unique($prune['forums']) as $fid) {
                 updateforumcount($fid);
             }
         }
         if ($_G['setting']['globalstick']) {
             updatecache('globalstick');
         }
     }
 }
 if ($_G['gp_delblog']) {

             $pmlist[] = array('act' => 'modthreads_delete', 'notevar' => array('reason' => dhtmlspecialchars($_G['gp_reason']), 'threadsubject' => $thread['subject']), 'authorid' => $thread['authorid']);
         }
     }
     if ($recyclebintids) {
         DB::query("UPDATE " . DB::table('forum_thread') . " SET displayorder='-1', moderated='1' WHERE tid IN ({$recyclebintids})");
         updatemodworks('MOD', DB::affected_rows());
         updatepost(array('invisible' => '-1'), "tid IN ({$recyclebintids})");
         updatemodlog($recyclebintids, 'DEL');
     }
     $query = DB::query("SELECT attachment, thumb, remote, aid FROM " . DB::table('forum_attachment') . " WHERE tid IN ({$deletetids})");
     while ($attach = DB::fetch($query)) {
         dunlink($attach);
     }
     DB::query("DELETE FROM " . DB::table('forum_thread') . " WHERE tid IN ({$deletetids})", 'UNBUFFERED');
     require_once libfile('function/delete');
     deletepost("tid IN ({$deletetids})");
     DB::query("DELETE FROM " . DB::table('forum_polloption') . " WHERE tid IN ({$deletetids})");
     DB::query("DELETE FROM " . DB::table('forum_poll') . " WHERE tid IN ({$deletetids})", 'UNBUFFERED');
     DB::query("DELETE FROM " . DB::table('forum_trade') . " WHERE tid IN ({$deletetids})", 'UNBUFFERED');
     DB::query("DELETE FROM " . DB::table('forum_attachment') . " WHERE tid IN ({$deletetids})", 'UNBUFFERED');
     DB::query("DELETE FROM " . DB::table('forum_attachmentfield') . " WHERE tid IN ({$deletetids})", 'UNBUFFERED');
 }
 foreach ($moderation['validate'] as $tid) {
     my_thread_log('validate', array('tid' => $tid));
 }
 if ($validatetids = dimplode($moderation['validate'])) {
     $tids = $comma = $comma2 = '';
     $moderatedthread = array();
     $query = DB::query("SELECT t.fid, t.tid, t.authorid, t.subject, t.author, t.dateline FROM " . DB::table('forum_thread') . " t\n\t\t\t\tWHERE t.tid IN ({$validatetids}) AND t.displayorder='{$pstat}' AND " . ($modfidsadd ? "t.{$modfidsadd}" : '1'));
     while ($thread = DB::fetch($query)) {
         $tids .= $comma . $thread['tid'];

function deletemember($uids, $other = 1)
{
    $query = DB::query("DELETE FROM " . DB::table('common_member') . " WHERE uid IN ({$uids})");
    $numdeleted = DB::affected_rows();
    DB::query("DELETE FROM " . DB::table('common_member_field_forum') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    DB::query("DELETE FROM " . DB::table('common_member_field_home') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    DB::query("DELETE FROM " . DB::table('common_member_count') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    DB::query("DELETE FROM " . DB::table('common_member_log') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    DB::query("DELETE FROM " . DB::table('common_member_profile') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    DB::query("DELETE FROM " . DB::table('common_member_security') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    DB::query("DELETE FROM " . DB::table('common_member_status') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    DB::query("DELETE FROM " . DB::table('common_member_validate') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    DB::query("DELETE FROM " . DB::table('forum_access') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    DB::query("DELETE FROM " . DB::table('forum_moderator') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
    if ($other) {
        DB::query("DELETE FROM " . DB::table('common_member_validate') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
        DB::query("DELETE FROM " . DB::table('common_member_magic') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
        $query = DB::query("SELECT uid, attachment, thumb, remote, aid FROM " . DB::table('forum_attachment') . " WHERE uid IN ({$uids})");
        while ($attach = DB::fetch($query)) {
            dunlink($attach);
        }
        DB::query("DELETE FROM " . DB::table('forum_attachment') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
        DB::query("DELETE FROM " . DB::table('forum_attachmentfield') . " WHERE uid IN ({$uids})", 'UNBUFFERED');
        deletepost("authorid IN ({$uids})", true, false);
    }
    DB::query("DELETE FROM " . DB::table('home_feed') . " WHERE uid IN ({$uids}) OR (id IN ({$uids}) AND idtype='uid')");
    $doids = array();
    $query = DB::query("SELECT * FROM " . DB::table('home_doing') . " WHERE uid IN ({$uids})");
    while ($value = DB::fetch($query)) {
        $doids[$value['doid']] = $value['doid'];
    }
    DB::query("DELETE FROM " . DB::table('home_doing') . " WHERE uid IN ({$uids})");
    $delsql = !empty($doids) ? "doid IN (" . dimplode($doids) . ") OR " : "";
    DB::query("DELETE FROM " . DB::table('home_docomment') . " WHERE {$delsql} uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('home_share') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('home_album') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('common_credit_rule_log') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('common_credit_rule_log_field') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('home_notification') . " WHERE (uid IN ({$uids}) OR authorid IN ({$uids}))");
    DB::query("DELETE FROM " . DB::table('home_poke') . " WHERE (uid IN ({$uids}) OR fromuid IN ({$uids}))");
    $query = DB::query("SELECT filepath, thumb, remote FROM " . DB::table('home_pic') . " WHERE uid IN ({$uids})");
    while ($value = DB::fetch($query)) {
        deletepicfiles($value);
    }
    DB::query("DELETE FROM " . DB::table('home_pic') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('home_blog') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('home_blogfield') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('home_comment') . " WHERE (uid IN ({$uids}) OR authorid IN ({$uids}) OR (id IN ({$uids}) AND idtype='uid'))");
    DB::query("DELETE FROM " . DB::table('home_visitor') . " WHERE (uid IN ({$uids}) OR vuid IN ({$uids}))");
    DB::query("DELETE FROM " . DB::table('home_class') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('home_friend') . " WHERE (uid IN ({$uids}) OR fuid IN ({$uids}))");
    DB::query("DELETE FROM " . DB::table('home_clickuser') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('common_invite') . " WHERE (uid IN ({$uids}) OR fuid IN ({$uids}))");
    DB::query("DELETE FROM " . DB::table('common_mailcron') . ", " . DB::table('common_mailqueue') . " USING " . DB::table('common_mailcron') . ", " . DB::table('common_mailqueue') . " WHERE " . DB::table('common_mailcron') . ".touid IN ({$uids}) AND " . DB::table('common_mailcron') . ".cid=" . DB::table('common_mailqueue') . ".cid");
    DB::query("DELETE FROM " . DB::table('common_myinvite') . " WHERE (touid IN ({$uids}) OR fromuid IN ({$uids}))");
    DB::query("DELETE FROM " . DB::table('home_userapp') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('home_userappfield') . " WHERE uid IN ({$uids})");
    DB::query("DELETE FROM " . DB::table('home_show') . " WHERE uid IN ({$uids})");
    manyoulog('user', $uids, 'delete');
    require_once libfile('function/forum');
    foreach (explode(',', $uids) as $uid) {
        my_thread_log('deluser', array('uid' => $uid));
    }
    return $numdeleted;
}