PHP pwQuery::buildClause方法代码示例

 function increase($userId, $increments)
 {
     $userId = intval($userId);
     if ($userId <= 0 || !is_array($increments)) {
         return 0;
     }
     $incrementStatement = array();
     foreach ($increments as $field => $offset) {
         $offset = intval($offset);
         if (!$offset) {
             continue;
         }
         if ($offset < 0) {
             $incrementStatement[] = $field . "=" . $field . $offset;
         } else {
             $incrementStatement[] = $field . "=" . $field . "+" . $offset;
         }
     }
     if (empty($incrementStatement)) {
         return 0;
     }
     //* $this->_db->update("UPDATE " . $this->_tableName . " SET " . implode(", ", $incrementStatement) . " WHERE uid=" . $this->_addSlashes($userId));
     $this->_db->update(pwQuery::buildClause("UPDATE :pw_table SET " . implode(", ", $incrementStatement) . " WHERE uid=:uid", array($this->_tableName, $userId)));
     return $this->_db->affected_rows();
 }

 function reduceReplyNumByCommentid($num, $commentid)
 {
     $num = intval($num);
     $commentid = intval($commentid);
     if ($num < 1 || $commentid < 1) {
         return false;
     }
     return $this->_db->update(pwQuery::buildClause("UPDATE :pw_table SET replynum=replynum-" . S::sqlEscape($num) . ' WHERE commentid=:commentid', array($this->_tableName, $commentid)));
 }

 function delUserByIds($uids)
 {
     if (!is_array($uids) || !count($uids)) {
         return;
     }
     $userService = $this->_getUserService();
     $userService->deletes($uids);
     $count = $userService->count();
     $lastestUser = $userService->getLatestNewUser();
     //* $this->db->update("UPDATE pw_bbsinfo SET newmember=" . S::sqlEscape($lastestUser['username']) . ',totalmember=' . S::sqlEscape($count) . " WHERE id='1'");
     $this->db->update(pwQuery::buildClause("UPDATE :pw_table SET newmember=:newmember,totalmember=:totalmember WHERE id=:id", array('pw_bbsinfo', $lastestUser['username'], $count)));
 }

 /**
  * 更新
  * 
  * @param int $commentid  
  * @param array $fieldsData
  * @return boolean
  */
 function updateReplynumByCommentid($exp = '+1', $commentid)
 {
     $commentid = intval($commentid);
     if ($commentid < 1 || !$exp) {
         return false;
     }
     $num = intval(trim($exp, '+-'));
     if (strpos($exp, '+') !== false) {
         return $this->_db->update(pwQuery::buildClause("UPDATE :pw_table SET replynum=replynum+" . S::sqlEscape($num) . ' WHERE commentid=:commentid', array($this->_tableName, $commentid)));
     } else {
         return $this->_db->update(pwQuery::buildClause("UPDATE :pw_table SET replynum=replynum-" . S::sqlEscape($num) . ' WHERE commentid=:commentid', array($this->_tableName, $commentid)));
     }
     return false;
 }

 /**
  * 批量增加套餐信息
  * @param array $fieldData
  * @return bool
  */
 function addSpreads($fieldData)
 {
     if (!S::isArray($fieldData)) {
         return false;
     }
     $data = array();
     foreach ($fieldData as $value) {
         $value = $this->_checkAllowField($value, $this->_allowFields);
         if (!S::isArray($value)) {
             continue;
         }
         $data[] = $value;
     }
     if (!S::isArray($data)) {
         return false;
     }
     return $this->_db->query(pwQuery::buildClause('INSERT INTO :table VALUES :data', array($this->_tableName, S::sqlMulti($data))));
 }

     exit;
 } elseif ($_POST['action'] == 'submit') {
     S::gp(array('selid'), 'P');
     $_tmpSelid = $selid;
     $selid = checkselid($selid);
     if ($selid === false) {
         $basename = "javascript:history.go(-1);";
         adminmsg('operate_error');
     } elseif ($selid == '') {
         //* $db->update("UPDATE pw_forums SET allowhtm='0' $sqladd");
         $db->update(pwQuery::buildClause("UPDATE :pw_table SET allowhtm='0' {$sqladd}", array('pw_forums')));
     } elseif ($selid) {
         //* $db->update("UPDATE pw_forums SET allowhtm='1' $sqladd AND fid IN($selid)");
         //* $db->update("UPDATE pw_forums SET allowhtm='0' $sqladd AND fid NOT IN($selid)");
         $db->update(pwQuery::buildClause("UPDATE :pw_table SET allowhtm='1' {$sqladd} AND fid IN(:fid)", array('pw_forums', $_tmpSelid)));
         $db->update(pwQuery::buildClause("UPDATE :pw_table SET allowhtm='0' {$sqladd} AND fid NOT IN(:fid)", array('pw_forums', $_tmpSelid)));
     }
     updatecache_f();
     adminmsg('operate_success');
 } elseif ($action == 'creat') {
     @set_time_limit(0);
     $pwServer['REQUEST_METHOD'] != 'POST' && PostCheck($verify);
     S::gp(array('creatfid', 'percount', 'step', 'tfid', 'forumnum'));
     $fids = $tid = $fieldadd = $tableadd = $tids = '';
     !is_array($creatfid) && ($creatfid = explode(',', $creatfid));
     if (in_array('all', $creatfid)) {
         $query = $db->query("SELECT fid FROM pw_forums {$sqladd} AND allowhtm='1'");
         while ($rt = $db->fetch_array($query)) {
             $fids .= ($fids ? ',' : '') . $rt['fid'];
         }
         $creatfid = explode(',', $fids);

/**
 * 圈子中各种用户发表信息统计，记录、分享、群组、相册、回复等
 *
 * @param string $exp 表达式，包含+或-符号
 */
function countPosts($exp = '+1')
{
    global $db;
    $num = intval(trim($exp, '+-'));
    if (strpos($exp, '+') !== false) {
        //* $db->update("UPDATE pw_bbsinfo SET o_post=o_post+".S::sqlEscape($num,false).",o_tpost=o_tpost+".S::sqlEscape($num,false));
        $db->update(pwQuery::buildClause("UPDATE :pw_table SET o_post=o_post+:o_post, o_tpost=o_tpost+:o_tpost", array('pw_bbsinfo', $num, $num)));
    } else {
        //* $db->update("UPDATE pw_bbsinfo SET o_post=o_post-".S::sqlEscape($num,false).",o_tpost=o_tpost-".S::sqlEscape($num,false));
        $db->update(pwQuery::buildClause("UPDATE :pw_table SET o_post=o_post-:o_post, o_tpost=o_tpost-:o_tpost", array('pw_bbsinfo', $num, $num)));
    }
}

 function _mergeThreads(&$tmp, $toid, $fromid, $cydb)
 {
     if ($cydb[$toid]['classid'] == $cydb[$fromid]['classid']) {
         //$this->_db->update("UPDATE pw_argument a LEFT JOIN pw_threads b ON a.tid=b.tid SET a.cyid=" . S::sqlEscape($toid) . " WHERE a.cyid=" . S::sqlEscape($fromid));
         $this->_db->update(pwQuery::buildClause("UPDATE :pw_table1 a LEFT JOIN :pw_table2 b ON a.tid=b.tid SET a.cyid=:cyidx WHERE a.cyid=:cyid", array('pw_argument', 'pw_threads', $toid, $fromid)));
         $tmp['tnum'] = $this->_db->affected_rows();
         $tmp['pnum'] = $cydb[$fromid]['pnum'];
     } else {
         global $db_plist;
         $ptable_a = array('pw_posts');
         if ($db_plist) {
             foreach ($db_plist as $key => $val) {
                 $key > 0 && ($ptable_a[] = 'pw_posts' . $key);
             }
         }
         $pnum = 0;
         foreach ($ptable_a as $val) {
             $this->_db->update("UPDATE pw_argument a LEFT JOIN {$val} b ON a.tid=b.tid SET b.fid=" . S::sqlEscape($cydb[$toid]['classid']) . " WHERE a.cyid=" . S::sqlEscape($fromid));
             $pnum += $this->_db->affected_rows();
         }
         $this->_db->update("UPDATE pw_argument a LEFT JOIN pw_attachs b ON a.tid=b.tid SET b.fid=" . S::sqlEscape($cydb[$toid]['classid']) . " WHERE a.cyid=" . S::sqlEscape($fromid));
         //$this->_db->update("UPDATE pw_argument a LEFT JOIN pw_threads b ON a.tid=b.tid SET a.cyid=" . S::sqlEscape($toid) . ",b.fid=" . S::sqlEscape($cydb[$toid]['classid']) . " WHERE a.cyid=" . S::sqlEscape($fromid));
         $this->_db->update(pwQuery::buildClause("UPDATE :pw_table1 a LEFT JOIN :pw_table2 b ON a.tid=b.tid SET a.cyid=:cyidx, b.fid=:bid WHERE a.cyid=:cyid", array('pw_argument', 'pw_threads', $toid, $cydb[$toid]['classid'], $fromid)));
         $tnum = $this->_db->affected_rows();
         $tmp['tnum'] = $tnum;
         $tmp['pnum'] = $pnum + $tnum;
         require_once R_P . 'require/updateforum.php';
         updateForumCount($cydb[$toid]['classid'], $tnum, $pnum);
         updateForumCount($cydb[$fromid]['classid'], -$tnum, -$pnum);
     }
 }

         $lt = $db->get_one("SELECT tid,author,postdate,lastpost,lastposter,subject FROM pw_threads WHERE fid=" . S::sqlEscape($fid) . "AND specialsort=0 AND ifcheck=1 AND lastpost>0 ORDER BY lastpost DESC LIMIT 0,1");
         if ($lt['tid']) {
             $lt['subject'] = substrs($lt['subject'], 21);
             if ($lt['postdate'] != $lt['lastpost']) {
                 $lt['subject'] = 'Re:' . $lt['subject'];
                 $add = '&page=e#a';
             }
             $toread = $cms ? '&toread=1' : '';
             $htmurl = $db_readdir . '/' . $fid . '/' . date('ym', $lt['postdate']) . '/' . $lt['tid'] . '.html';
             $new_url = file_exists(R_P . $htmurl) && $allowhtm == 1 && !$cms ? "{$R_url}/{$htmurl}" : "read.php?tid={$lt['tid']}{$toread}{$add}";
             $lastinfo = addslashes(S::escapeChar($lt['subject']) . "\t" . $lt['lastposter'] . "\t" . $lt['lastpost'] . "\t" . $new_url);
         } else {
             $lastinfo = '';
         }
         //* $db->update("UPDATE pw_forumdata SET topic=".S::sqlEscape($topic).',article=article+'.S::sqlEscape($article).',lastpost='.S::sqlEscape($lastinfo).' WHERE fid='.S::sqlEscape($fid));
         $db->update(pwQuery::buildClause("UPDATE :pw_table SET topic=:topic, article=article+:article,lastpost=:lastpost WHERE fid=:fid", array('pw_forumdata', $topic, $article, $lastinfo, $fid)));
     }
     if ($goon) {
         adminmsg('updatecache_step', EncodeUrl($j_url));
     } else {
         adminmsg('operate_success');
     }
 } elseif ($action == 'thread') {
     $pwServer['REQUEST_METHOD'] != 'POST' && PostCheck($verify);
     S::gp(array('step', 'percount'));
     !$step && ($step = 1);
     !$percount && ($percount = 300);
     $start = ($step - 1) * $percount;
     $next = $start + $percount;
     $step++;
     $j_url = "{$basename}&action={$action}&step={$step}&percount={$percount}";

 function _insertUser()
 {
     global $timestamp, $onlineip, $credit;
     /**
     		$pwSQL = S::sqlSingle(array(
     			'uid' => $this->uid,
     			'username' => $this->data['username'],
     			'password' => $this->data['password'],
     			'safecv' => $this->data['safecv'],
     			'email' => $this->data['email'],
     			'groupid' => $this->data['groupid'],
     			'memberid' => $this->data['memberid'],
     			'regdate' => $timestamp,
     			'yz' => $this->data['yz'],
     			'userstatus' => $this->data['userstatus'],
     			'newpm' => 0
     		));
     		$this->db->update("REPLACE INTO pw_members SET $pwSQL");
     		**/
     $pwSQL = array('uid' => $this->uid, 'username' => $this->data['username'], 'password' => $this->data['password'], 'safecv' => $this->data['safecv'], 'email' => $this->data['email'], 'groupid' => $this->data['groupid'], 'memberid' => $this->data['memberid'], 'regdate' => $timestamp, 'yz' => $this->data['yz'], 'userstatus' => $this->data['userstatus'], 'newpm' => 0);
     pwQuery::replace('pw_members', $pwSQL);
     /**
     		$pwSQL = S::sqlSingle(array(
     			'uid' => $this->uid,
     			'postnum' => 0,
     			'lastvisit' => $timestamp,
     			'thisvisit' => $timestamp,
     			'onlineip' => $onlineip
     		));
     		$this->db->pw_update(
     			'SELECT uid FROM pw_memberdata WHERE uid=' . S::sqlEscape($this->uid),
     			'UPDATE pw_memberdata SET ' . $pwSQL . ' WHERE uid=' . S::sqlEscape($this->uid),
     			'INSERT INTO pw_memberdata SET ' . $pwSQL
     		);
     		**/
     $pwSQL = array('uid' => $this->uid, 'postnum' => 0, 'lastvisit' => $timestamp, 'thisvisit' => $timestamp, 'onlineip' => $onlineip);
     $this->db->pw_update('SELECT uid FROM pw_memberdata WHERE uid=' . S::sqlEscape($this->uid), pwQuery::updateClause('pw_memberdata', 'uid =:uid', array($this->uid), $pwSQL), pwQuery::insertClause('pw_memberdata', $pwSQL));
     //$this->db->update("REPLACE INTO pw_memberdata SET $pwSQL");
     require_once R_P . 'require/credit.php';
     $credit->addLog('reg_register', L::reg('rg_regcredit'), array('uid' => $this->uid, 'username' => stripslashes($this->data['username']), 'ip' => $onlineip));
     $credit->sets($this->uid, L::reg('rg_regcredit'), false);
     $credit->runsql();
     //* $this->db->update("UPDATE pw_bbsinfo SET newmember=" . S::sqlEscape($this->data['username']) . ",totalmember=totalmember+1 WHERE id='1'");
     $this->db->update(pwQuery::buildClause("UPDATE :pw_table SET newmember=:newmember,totalmember=totalmember+1 WHERE id=:id", array('pw_bbsinfo', $this->data['username'], 1)));
     $this->memberinfo or $this->memberinfo['uid'] = $this->uid;
     if ($this->memberinfo) {
         /**
         			$this->db->update("REPLACE INTO pw_memberinfo SET uid=" . S::sqlEscape($this->uid) . ',' . S::sqlSingle($this->memberinfo));
         			**/
         $_temp = array('uid' => $this->uid) + $this->memberinfo;
         pwQuery::replace('pw_memberinfo', $_temp);
     }
     $statistics = L::loadClass('Statistics', 'datanalyse');
     $statistics->register();
 }

<?php

!function_exists('readover') && exit('Forbidden');
$query = $db->query("SELECT id,uid,fid FROM pw_banuser WHERE type='1' AND startdate+days*86400<" . S::sqlEscape($timestamp));
$ids = $uids1 = $uids2 = array();
while ($rt = $db->fetch_array($query)) {
    $ids[] = $rt['id'];
    if ($rt['fid']) {
        $uids2[] = $rt['uid'];
    } else {
        $uids1[] = $rt['uid'];
    }
}
if ($ids) {
    $userService = L::loadClass('UserService', 'user');
    /* @var $userService PW_UserService */
    $db->update("DELETE FROM pw_banuser WHERE id IN(" . S::sqlImplode($ids) . ")");
    $uids1 && $userService->updates($uids1, array('groupid' => -1));
    /**
    	$uids2 && $db->update("UPDATE pw_members m LEFT JOIN pw_banuser b ON m.uid=b.uid AND b.fid>0 SET m.userstatus=m.userstatus&(~1) WHERE b.uid is NULL AND m.uid IN(".S::sqlImplode($uids2).")");
    	**/
    $uids2 && $db->update(pwQuery::buildClause("UPDATE :pw_table m LEFT JOIN pw_banuser b ON m.uid=b.uid AND b.fid>0 SET m.userstatus=m.userstatus&(~1) WHERE b.uid is NULL AND m.uid IN(:uid)", array('pw_members', $uids2)));
}

 /**
  * 取消评分
  * @param $tid
  * @param $pids
  * @param $params
  */
 function deletePing($params = array())
 {
     global $groupid, $windid, $winduid, $credit, $onlineip, $timestamp, $gp_gptype;
     //* $threadService = L::loadClass("threads", 'forum');
     require_once R_P . 'require/credit.php';
     foreach ($this->postData as $pid => $atc) {
         $rpid = $pid == 'tpc' ? '0' : $pid;
         // delete pinglog
         $pingdata = $this->db->get_one('SELECT * FROM pw_pinglog WHERE tid=' . S::sqlEscape($this->tid) . ' AND pid=' . S::sqlEscape($rpid) . ' AND pinger=' . S::sqlEscape($windid) . ' ORDER BY pingdate DESC LIMIT 1');
         //$this->db->update('DELETE FROM pw_pinglog WHERE id=' . S::sqlEscape($pingdata['id']));
         pwQuery::delete('pw_pinglog', 'id=:id', array($pingdata['id']));
         $this->update_markinfo($this->tid, $rpid);
         //* $threadService->clearTmsgsByThreadId($this->tid);
         Perf::gatherInfo('changeTmsgWithThreadIds', array('tid' => $this->tid));
         $addpoint = $pingdata['point'];
         if (!($cid = $credit->getCreditTypeByName($pingdata['name']))) {
             continue;
         }
         $cName = $credit->cType[$cid];
         $addpoint = $addpoint > 0 ? -$addpoint : abs($addpoint);
         !$atc['subject'] && ($atc['subject'] = substrs(strip_tags(convert($atc['content'])), 35));
         $credit->addLog('credit_delping', array($cid => $addpoint), array('uid' => $atc['authorid'], 'username' => $atc['author'], 'ip' => $onlineip, 'operator' => $windid, 'tid' => $this->tid, 'subject' => $atc['subject'], 'reason' => $params['atc_content']));
         $credit->set($atc['authorid'], $cid, $addpoint);
         if (!is_numeric($pid)) {
             //* $this->db->update('UPDATE pw_threads SET ifmark=ifmark+'.S::sqlEscape($addpoint).' WHERE tid='.S::sqlEscape($tid));
             $this->db->update(pwQuery::buildClause("UPDATE :pw_table SET ifmark=ifmark+:ifmark WHERE tid=:tid", array('pw_threads', $addpoint, $this->tid)));
         }
         if ($params['ifmsg'] && !$atc['anonymous'] && $atc['author'] != $windid) {
             //发消息
             $title = getLangInfo('writemsg', 'delping_title', array('sender' => $windid, 'receiver' => $atc['author']));
             $content = getLangInfo('writemsg', 'delping_content', array('manager' => $windid, 'fid' => $atc['fid'], 'tid' => $this->tid, 'pid' => $pid, 'subject' => $atc['subject'], 'postdate' => get_date($atc['postdate']), 'forum' => strip_tags($this->forum->foruminfo['name']), 'affect' => "{$cName}:{$addpoint}", 'admindate' => get_date($timestamp), 'reason' => stripslashes($params['atc_content']), 'sender' => $windid, 'receiver' => $atc['author']));
             $this->sendMessage($atc['author'], $title, $content);
         }
         if ($gp_gptype == 'system') {
             require_once R_P . 'require/writelog.php';
             $log = array('type' => 'credit', 'username1' => $atc['author'], 'username2' => $windid, 'field1' => $atc['fid'], 'field2' => '', 'field3' => '', 'descrip' => 'creditdel_descrip', 'timestamp' => $timestamp, 'ip' => $onlineip, 'tid' => $this->tid, 'forum' => strip_tags($this->forum->foruminfo['name']), 'subject' => $atc['subject'], 'affect' => "{$name}:{$addpoint}", 'reason' => $params['atc_content']);
             writelog($log);
         }
         $pingLog[$pid] = $pingdata['id'];
     }
     $credit->runsql();
     defined('AJAX') && ($GLOBALS['pingLog'] = $pingLog);
     //GLOBAL
     if ($this->forum->foruminfo['allowhtm'] && $_REQUEST['page'] == 1) {
         $StaticPage = L::loadClass('StaticPage');
         $StaticPage->update($this->tid);
     }
     return true;
 }

             $last = $db->get_one($sql);
             # 更新主题的回复数,最后回复信息
             //$sql = "UPDATE pw_threads SET replies=replies-".S::sqlEscape($num) . ",lastpost=" . S::sqlEscape($last['postdate'],false) . ",lastposter =" . S::sqlEscape($last['author'],false) . "WHERE tid=" . S::sqlEscape($tid);
             $sql = pwQuery::buildClause('UPDATE :pw_table SET replies = replies - :replies, lastpost = :lastpost, lastposter = :lastposter WHERE tid = :tid', array('pw_threads', $num, $last['postdate'], $last['author'], $tid));
             $db->update($sql);
             # memcache refresh
             // $threadList = L::loadClass("threadlist", 'forum');
             // $threadList->updateThreadIdsByForumId($fid,$tid);
             Perf::gatherInfo('changeThreadWithForumIds', array('fid' => $fid));
         }
         # 更新版块文章数
         /**
         					$sql = "UPDATE pw_forumdata SET article=article-".S::sqlEscape($forum_count)." WHERE fid=".S::sqlEscape($fid);
         					$db->update($sql);
         					**/
         $db->update(pwQuery::buildClause("UPDATE :pw_table SET article=article-:article WHERE fid=:fid", array('pw_forumdata', $forum_count, $fid)));
     }
     foreach ($db_threads as $tid => $thread) {
         $toUser = array();
         foreach ($thread as $post) {
             $toUser[] = $post['author'];
         }
         $sql = "SELECT subject FROM pw_threads WHERE tid =" . S::sqlEscape($tid);
         $subject = $db->get_value($sql);
         M::sendNotice($toUser, array('title' => getLangInfo('writemsg', 'filtermsg_post_del_title'), 'content' => getLangInfo('writemsg', 'filtermsg_post_del_content', array('subject' => $subject))));
     }
 }
 $delarticle->delReply($replydb, $db_recycle);
 if (is_array($objid)) {
     $filter_id = implode(',', $objid);
     if ($filter_id) {

        $_cacheService = Perf::gatherCache('pw_space');
        $tmp = $_cacheService->getSpaceByUid($winduid);
        $tovisitors = $tmp['tovisitors'];
    } else {
        $tovisitors = $db->get_value("SELECT tovisitors FROM pw_space WHERE uid=" . S::sqlEscape($winduid));
    }
    $tovisitors = unserialize($tovisitors);
    is_array($tovisitors) || ($tovisitors = array());
    if (!isset($tovisitors[$uid]) || $timestamp - $tovisitors[$uid] > 900) {
        $tovisitors[$uid] = $timestamp;
        arsort($tovisitors);
        if (count($tovisitors) > 12) {
            array_pop($tovisitors);
        }
        //$db->update("UPDATE pw_space SET tovisits=tovisits+'1',tovisitors=" . S::sqlEscape(serialize($tovisitors),false) .  " WHERE uid=" . S::sqlEscape($winduid));
        $db->update(pwQuery::buildClause("UPDATE :pw_table SET tovisits=tovisits+1,tovisitors=:tovisitors WHERE uid=:uid", array('pw_space', serialize($tovisitors), $winduid)));
    }
    //猪头回收
    $user_icon = explode('|', $space['icon']);
    if ($user_icon[4] && $space['tooltime'] < $timestamp - 86400) {
        $space['icon'] = "{$user_icon['0']}|{$user_icon['1']}|{$user_icon['2']}|{$user_icon['3']}|0";
        /**
        		$db->update("UPDATE pw_members SET icon=".S::sqlEscape($space['icon'],false)." WHERE uid=".S::sqlEscape($space['uid']));
        		**/
        pwQuery::update('pw_members', 'uid =:uid', array($space['uid']), array('icon' => $space['icon']));
    }
}
$isSpace = true;
$spaceTemplate = "";
$spacestyle = $space['spacestyle'] === '2' || $space['spacestyle'] === '3' ? $space['spacestyle'] : 2;
$spaceTemplate = 'space_' . $spacestyle . '_index';

         $msgdb[] = array('toUser' => $fromdb['author'], 'title' => getLangInfo('writemsg', 'unite_title', array('manager' => $windid)), 'content' => getLangInfo('writemsg', 'unite_content', array('manager' => $windid, 'fid' => $fid, 'tid' => $totid, 'subject' => $todb['subject'], 'postdate' => get_date($todb['postdate']), 'forum' => strip_tags($forum[$fid]['name']), 'admindate' => get_date($timestamp), 'reason' => stripslashes($atc_content))));
     }
     $log = array('type' => 'unite', 'username1' => $fromdb['author'], 'username2' => $windid, 'field1' => $fid, 'field2' => '', 'field3' => '', 'descrip' => 'unite_descrip', 'timestamp' => $timestamp, 'ip' => $onlineip, 'tid' => $totid, 'subject' => substrs($todb['subject'], 28), 'forum' => $forum[$fid]['name'], 'reason' => stripslashes($atc_content));
     writelog($log);
     $istucool && $tucoolService->delete($fromdb['tid']);
     //更新评分
     $oldPid = $fromdb['pid'] == 'tpc' ? 0 : $fromdb['pid'];
     //$db->update(pwQuery::buildClause('UPDATE :pw_table SET tid=:tid1,pid=:pid WHERE tid=:tid AND pid=0', array('pw_pinglog', $totid, $pid, $fromdb['tid'])));
     //$db->update(pwQuery::buildClause('UPDATE :pw_table SET tid=:tid1 WHERE tid=:tid AND pid>0', array('pw_pinglog', $totid, $fromdb['tid'])));
     pwQuery::update('pw_pinglog', 'tid=:tid', array($fromdb['tid']), array('tid' => $totid, 'pid' => $pid));
     //pwQuery::update('pw_pinglog', 'tid=:tid AND pid>0', array($fromdb['tid']), array('tid'=>$totid));
     //更新elements
     pwQuery::delete('pw_elements', 'id=:id AND type IN (:type)', array($fromdb['tid'], array('newpic', 'hitsort', 'hitsortday', 'hitsortweek', 'replysort', 'replysortday', 'replysortweek')));
 }
 //$db->update("UPDATE pw_threads SET replies=replies+" . S::sqlEscape($replies, false) . " WHERE tid=" . S::sqlEscape($totid));
 $db->update(pwQuery::buildClause('UPDATE :pw_table SET replies=replies+:replies WHERE tid=:tid', array('pw_threads', $replies, $totid)));
 $pw_tmsgs = GetTtable($totid);
 //* $db->update("UPDATE $pw_tmsgs SET remindinfo=" . S::sqlEscape($remindinfo, false) . " WHERE tid=" . S::sqlEscape($totid));
 pwQuery::update($pw_tmsgs, 'tid=:tid', array($totid), array('remindinfo' => $remindinfo));
 updateforum($fid);
 $weiboService = L::loadClass('weibo', 'sns');
 $fromColonyIds && $weiboService->deleteWeibosByObjectIdsAndType($fromColonyIds, 'group_article');
 $fromArticleIds && $weiboService->deleteWeibosByObjectIdsAndType($fromArticleIds, 'article');
 $tousername = $db->get_value("SELECT author FROM pw_threads WHERE tid=" . S::sqlEscape($totid));
 M::sendNotice(array($tousername), array('title' => getLangInfo('writemsg', 'unite_title'), 'content' => getLangInfo('writemsg', 'unite_content', array('manager' => $windid, 'fid' => $fid, 'tid' => $totid, 'subject' => $todb['subject'], 'postdate' => get_date($todb['postdate']), 'forum' => strip_tags($forum[$fid]['name']), 'admindate' => get_date($timestamp), 'reason' => stripslashes($atc_content)))));
 if ($ifmsg) {
     sendMawholeMessages($msgdb);
 }
 //* $threads = L::loadClass('Threads', 'forum');
 //* $threads->delThreads($totid);
 //* $threads->delThreads($fromdb['tid']);