function updateForumCount($fid, $topic, $replies, $tpost = 0)
{
    global $db, $db_fcachenum;
    $fm = $db->get_one("SELECT fup,type,password,allowvisit,f_type FROM pw_forums WHERE fid=" . S::sqlEscape($fid));
    if ($fm['type'] == 'category') {
        return false;
    }
    delfcache($fid, $db_fcachenum);
    $topic = intval($topic);
    $article = $topic + intval($replies);
    $tpost = intval($tpost);
    $lastpost = '';
    $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 1");
    if ($lt) {
        if ($lt['postdate'] == $lt['lastpost']) {
            $subject = substrs($lt['subject'], 26);
        } else {
            $subject = 'Re:' . substrs($lt['subject'], 26);
        }
        $lastpost = ",lastpost=" . S::sqlEscape($subject . "\t" . $lt['lastposter'] . "\t" . $lt['lastpost'] . "\t" . "read.php?tid={$lt['tid']}&page=e#a");
    }
    $db->update("UPDATE pw_forumdata SET article=article+'{$article}',topic=topic+'{$topic}',tpost=tpost+'{$tpost}'{$lastpost} WHERE fid=" . S::sqlEscape($fid));
    Perf::gatherInfo('changeForumData', array('fid' => $fid));
    if (($fm['type'] == 'sub' || $fm['type'] == 'sub2') && ($fids = getUpFids($fid))) {
        if ($fm['password'] != '' || $fm['allowvisit'] != '' || $fm['f_type'] == 'hidden') {
            $lastpost = '';
        }
        $db->update("UPDATE pw_forumdata SET article=article+'{$article}',subtopic=subtopic+'{$topic}',tpost=tpost+'{$tpost}'{$lastpost} WHERE fid IN(" . S::sqlImplode($fids) . ')');
        Perf::gatherInfo('changeForumData', array('fid' => $fids));
    }
}

 /**
  *加入多条学校数据
  * @param array $data数据
  * @return array $schoolIds学校id
  */
 function addSchools($data)
 {
     if (!S::isArray($data)) {
         return false;
     }
     $fieldData = array();
     $schoolNames = array();
     $schoolDb = $this->_getSchoolDao();
     foreach ($data as $value) {
         $value['areaid'] = intval($value['areaid']);
         $value['schoolname'] = trim($value['schoolname']);
         $value['schoolname'] = trim(substrs($value['schoolname'], 32, 'N'), '  ');
         $schoolNames[] = trim($value['schoolname']);
         $value['type'] = $value['type'] ? intval($value['type']) : 1;
         if (!$value['schoolname'] || $value['areaid'] < 0 || $value['type'] < 0) {
             continue;
         }
         $fieldData[] = $value;
     }
     $schoolIds = $schoolDb->checkSchoolNames((int) $value['areaid'], $value['type'], $schoolNames);
     if ($schoolIds > 0) {
         return $schoolIds;
     }
     return $schoolDb->addSchools($fieldData);
 }

 function topicPost($tid, $postdata)
 {
     global $timestamp, $winduid, $windid;
     if (!$this->info) {
         return false;
     }
     $this->_db->update("INSERT INTO pw_argument SET " . S::sqlSingle(array('tid' => $tid, 'cyid' => $this->info['id'], 'postdate' => $timestamp, 'lastpost' => $timestamp)));
     if ($postdata['ifcheck'] > 0) {
         require_once R_P . 'u/require/core.php';
         //tnum加一
         //* $this->_db->update("UPDATE pw_colonys SET tnum=tnum+'1',pnum=pnum+'1',todaypost=todaypost+'1' WHERE id=" . S::sqlEscape($this->cyid));
         $this->_db->update(pwQuery::buildClause("UPDATE :pw_table SET tnum=tnum+1,pnum=pnum+1,todaypost=todaypost+1 WHERE id=:id", array('pw_colonys', $this->cyid)));
         $this->info['tnum']++;
         $this->info['pnum']++;
         updateGroupLevel($this->cyid, $this->info);
         if ($this->info['ifopen']) {
             $weiboService = L::loadClass('weibo', 'sns');
             /* @var $weiboService PW_Weibo */
             $weiboContent = substrs(stripWindCode($postdata['content']), 125);
             $weiboExtra = array('cyid' => $this->cyid, 'title' => stripslashes($postdata['title']), 'cname' => $this->info['cname']);
             $weiboService->send($winduid, $weiboContent, 'group_article', $tid, $weiboExtra);
         }
     }
     //更新群成员表里面的最后发言时间
     $this->_db->update("UPDATE pw_cmembers SET lastpost=" . S::sqlEscape($timestamp) . " WHERE uid=" . S::sqlEscape($winduid));
 }

 function getSourceData($sourceId)
 {
     $data = $this->_getThreadData($sourceId);
     if (!$data || $this->_checkIfDelete($data)) {
         return array();
     }
     $data['content'] = preg_replace("/\\[attachment=[0-9]+\\]/is", '', $data['content']);
     $data['descrip'] = substrs(stripWindCode($data['content']), 100);
     $data['frominfo'] = 'ÂÛ̳';
     return $data;
 }

 function getSourceData($sourceId)
 {
     $data = $this->_getDiaryData($sourceId);
     if (!$data) {
         return array();
     }
     $data['descrip'] = substrs(stripWindCode($data['content']), 100);
     $data['frominfo'] = 'хуж╬';
     $data['author'] = $data['username'];
     return $data;
 }

 function _cookData($data)
 {
     global $db_bbsurl;
     $data['url'] = $db_bbsurl . '/apps.php?q=group&cyid=' . $data['id'];
     $data['title'] = $data['cname'];
     $data['image'] = $this->_getGroupImage($data['cnimg']);
     $data['descrip'] = substrs(strip_tags(stripWindCode($data['descrip'])), 100);
     if ($data['credit']) {
         $data['credit'] = (int) $data['credit'];
     }
     return $data;
 }

 /**
  * @param $_summary the $_summary to set
  */
 function set_summary($_summary, $convert)
 {
     if ($_summary) {
         $_summary = stripWindCode($_summary);
         $_summary = strip_tags($_summary);
         $_summary = str_replace(array('"', "\n", "\r", ' ', '&', '<', '', ' '), '', $_summary);
         $_summary = substrs($_summary, 255);
         if ($convert) {
             $wordsfb = L::loadClass('FilterUtil');
             $_summary = $wordsfb->convert($_summary);
         }
         $this->_summary = trim($_summary);
     }
 }

function writelog($log)
{
    global $db, $db_moneyname, $db_rvrcname, $db_bbsurl;
    $log['username1'] = S::escapeChar($log['username1']);
    $log['username2'] = S::escapeChar($log['username2']);
    $log['field1'] = S::escapeChar($log['field1']);
    $log['field2'] = S::escapeChar($log['field2']);
    $log['field3'] = S::escapeChar($log['field3']);
    if (!$log['subject']) {
        $log['subject'] = substrs($db_bbsurl . '/read.php?tid=' . $log['tid'], 28);
    }
    $log['descrip'] = S::escapeChar(getLangInfo('log', $log['descrip'], $log));
    $db->update("INSERT INTO pw_adminlog" . " SET " . S::sqlSingle(array('type' => $log['type'], 'username1' => $log['username1'], 'username2' => $log['username2'], 'field1' => $log['field1'], 'field2' => $log['field2'], 'field3' => $log['field3'], 'descrip' => $log['descrip'], 'timestamp' => $log['timestamp'], 'ip' => $log['ip']), false));
}

 /**
  * 调取指定个数和指定用户的的道具信息
  * @param $uid 调取的用户
  * @param $num 调取的个数
  * @return array 
  */
 function getToolsByUidAndNum($uid, $num)
 {
     $tools = array();
     $query = $this->_db->query("SELECT u.*,t.name,t.price,t.creditype,t.stock,t.descrip,t.type,t.logo FROM pw_usertool u LEFT JOIN pw_tools t ON t.id=u.toolid WHERE u.uid=" . S::sqlEscape($uid) . " AND u.nums>0 LIMIT " . intval($num));
     while ($rt = $this->_db->fetch_array($query)) {
         if (empty($rt['logo'])) {
             $rt['logo'] = $GLOBALS['imgpath'] . '/nopic.gif';
         } else {
             $rt['logo'] = "u/images/toolcenter/tool/{$rt['toolid']}.gif";
         }
         $rt['subdescrip'] = substrs($rt['descrip'], 20);
         $tools[] = $rt;
     }
     return $tools;
 }

function getOneInfo($uid)
{
    global $db;
    $uid = (int) $uid;
    if (!$uid) {
        Showmsg('undefined_action');
    }
    $oneinfo = $db->get_one("SELECT m.uid,m.username,m.email,m.groupid,m.memberid,m.icon,m.gender,m.regdate,m.honor,m.bday,m.medals,m.userstatus,md.thisvisit,md.onlinetime,md.postnum,md.digests,md.rvrc,md.money,md.credit,md.lastvisit,md.lastpost,md.todaypost,md.f_num FROM pw_members m LEFT JOIN pw_memberdata md ON m.uid=md.uid WHERE m.uid=" . pwEscape($uid));
    if ($oneinfo) {
        require_once R_P . 'require/showimg.php';
        list($oneinfo['face']) = showfacedesign($oneinfo['icon'], 1);
        $oneinfo['honor'] = substrs($oneinfo['honor'], 90);
        return $oneinfo;
    } else {
        return false;
    }
}

 /**
  * 格式化输出结果
  * @param unknown_type $data
  * @return unknown
  */
 function _cookData($data)
 {
     global $db_bbsurl, $db_windpost;
     $data['url'] = $data['url'] ? $data['url'] : $db_bbsurl . '/notice.php?fid=' . $data['fid'] . '#' . $data['aid'];
     $data['title'] = convert($data['subject'], $db_windpost);
     if ($data['author']) {
         $userService = L::loadClass('userService', 'user');
         $userId = $userService->getUserIdByUserName($data['author']);
         $data['authorurl'] = 'u.php?uid=' . $userId;
     } else {
         $data['authorurl'] = '';
     }
     $data['content'] = convert($data['content'], $db_windpost);
     $data['descrip'] = substrs(strip_tags($data['content']), 100);
     $data['postdate'] = $data['startdate'];
     return $data;
 }

function getOneInfo($uid)
{
    global $db;
    $uid = (int) $uid;
    if (!$uid) {
        Showmsg('undefined_action');
    }
    $userService = L::loadClass('UserService', 'user');
    /* @var $userService PW_UserService */
    $oneinfo = $userService->get($uid, true, true);
    if ($oneinfo) {
        require_once R_P . 'require/showimg.php';
        list($oneinfo['face']) = showfacedesign($oneinfo['icon'], 1);
        $oneinfo['honor'] = substrs($oneinfo['honor'], 90);
        return $oneinfo;
    } else {
        return false;
    }
}

 require_once R_P . 'require/functions.php';
 $customdes = getLangInfo('other', 'invite_custom_des');
 $tmpUrlAdd .= '&a=invite';
 if ($type == 'groupactive') {
     $invite_url = $db_bbsurl . '/u.php?a=invite&type=groupactive&id=' . $id . '&uid=' . $winduid . '&hash=' . appkey($winduid, $type);
     $activeArray = $db->get_one("SELECT * FROM pw_active WHERE id=" . S::sqlEscape($id));
     $objectName = $activeArray['title'];
     $objectDescrip = substrs($activeArray['content'], 30);
     $activeId = $activeArray['id'];
     $emailContent = getLangInfo('email', 'email_groupactive_invite_content');
 } else {
     $id = $cyid;
     $type = 'group';
     $invite_url = $db_bbsurl . '/u.php?a=invite&type=group&id=' . $cyid . '&uid=' . $winduid . '&hash=' . appkey($winduid, $type);
     $objectName = $colony['cname'];
     $objectDescrip = substrs($colony['descrip'], 30);
     $emailContent = getLangInfo('email', 'email_group_invite_content');
 }
 if (empty($_POST['step'])) {
     S::gp("id", null, 2);
     //* @include_once pwCache::getPath(D_P.'data/bbscache/o_config.php');
     pwCache::getData(D_P . 'data/bbscache/o_config.php');
     $friend = getFriends($winduid) ? getFriends($winduid) : array();
     foreach ($friend as $key => $value) {
         $frienddb[$value['ftid']][] = $value;
     }
     $query = $db->query("SELECT * FROM pw_friendtype WHERE uid=" . S::sqlEscape($winduid) . " ORDER BY ftid");
     $friendtype = array();
     while ($rt = $db->fetch_array($query)) {
         $friendtype[$rt['ftid']] = $rt;
     }

function getmco($c, $i, $n = 0, $r = 0)
{
    $m = 200;
    return ($r > 0 && strstr($c, "\r") ? '<br/>' : '') . (strlen($c) > $m ? mbookencode(substrs($c, $m - 5)) . '<br/><a href="?m=list&amp;id=' . $i . ($n > 0 ? '#reply-' . $n : '') . '">查看全部 &gt;&gt;</a>' : mbookencode($c));
}

        }
        !$rt['pid'] && ($rt['pid'] = 'tpc');
        $rt['fname'] = $forum[$rt['fid']]['name'];
        $showdb[$key] = $rt;
    }
    require_once PrintEot('show');
    footer();
} else {
    $pw_attachs = L::loadDB('attachs', 'forum');
    $rt = $pw_attachs->get($aid);
    if ($rt && $rt['tid'] && $rt['fid']) {
        $pw_tmsgs = GetTtable($rt['tid']);
        $rtinfo = $db->get_one("SELECT t.fid,t.subject,t.ifcheck,t.ifshield,tm.content,m.username\r\n\t\t\tFROM pw_threads t LEFT JOIN {$pw_tmsgs} tm ON tm.tid=t.tid\r\n\t\t\tLEFT JOIN pw_members m ON m.uid=t.authorid\r\n\t\t\tWHERE t.tid=" . S::sqlEscape($rt['tid'], false));
        if (in_array($rtinfo['fid'], $fidoff) || $rtinfo['ifshield'] == '2' || $groupid != '3' && $groupid != '4' && ($rtinfo['needrvrc'] > $userrvrc || !$rtinfo['ifcheck'] || $rtinfo['ifshield'] || strpos($rtinfo['content'], "[post]") !== false && strpos($rtinfo['content'], "[/post]") !== false || strpos($rtinfo['content'], "[hide") !== false && strpos($rtinfo['content'], "[/hide]") !== false || strpos($rtinfo['content'], "[sell") !== false && strpos($rtinfo['content'], "[/sell]") !== false)) {
            Showmsg('pic_not_exists');
        }
        $rt['subject'] = $rtinfo['subject'];
        $rt['username'] = $rtinfo['username'];
        $a_url = geturl($rt['attachurl'], 'show');
        $rt['a_url'] = is_array($a_url) ? $a_url[0] : $a_url;
        $uid = $rt['uid'];
        $type = 1;
        $owner = $rt['username'];
        !$rt['pid'] && ($rt['pid'] = 'tpc');
        !$rt['descrip'] && ($rt['descrip'] = substrs(stripWindCode($rtinfo['content']), 120));
    } else {
        Showmsg('pic_not_exists');
    }
    require_once PrintEot('show');
    footer();
}

                            </li>
  <li>
                                <label>
                                    推荐人：
                                </label>
                                
                                   <i><?php 
        echo $r['uname'];
        ?>
</i>
                            </li>

                        </ul>
                    </dd>
<label>推荐理由：</label><span style="width:170px;"><?php 
        echo substrs($r['why'], 48, 0, 1);
        ?>
</span>
                </dl>
<?php 
    }
}
?>
                <div style="clear: both;width:86px;height:58px;">
                </div>
            </div>
    
    </div>
    </div>

    

 function buildApplied($list)
 {
     $list['title'] = substrs($list['title'], 56);
     $html = '';
     $html .= '<div id="applied_' . $list[id] . '">';
     $html .= '<div class="jobpop_h current"><a href="javascript:;" class="menu_tasksA_title" hidefocus="true"><b></b>' . $list[title] . ' <span>' . $list[gain] . '</span></a></div>';
     $html .= '	<dl class="cc taskA_dl" style="display:none;">';
     $html .= '    <dt><img src="' . $list[icon] . '" /></dt>';
     $html .= '    <dd>';
     $html .= '    <table width="100%" style="table-layout:fixed;">';
     $html .= '        <tr class="vt">';
     $html .= '			<td width="80">完成条件:</td>';
     $html .= '    		<td id="job_condition_' . $list[id] . '">' . $list[condition] . '</td>';
     $html .= '		  </tr>';
     $html .= '        <tr class="vt">';
     $html .= '            <td>完成奖励:</td>';
     $html .= '            <td class="s2">' . $list[reward] . '</td>';
     $html .= '        </tr>';
     $html .= '            <tr class="vt">';
     $html .= '            <td>任务描述:</td>';
     $html .= '                <td>' . $list[description] . '</td>';
     $html .= '         </tr>';
     $html .= '         <tr class="vt">';
     $html .= '            <td></td>';
     $html .= '                <td><span class="fr">' . $list[btn] . '</span></td>';
     $html .= '         </tr>';
     $html .= '   </table>';
     $html .= '   </dd>';
     $html .= '  </dl>';
     $html .= '</div>';
     return $html;
 }

 }
 $delarticle = L::loadClass('DelArticle', 'forum');
 /* @var $delarticle PW_DelArticle */
 foreach ($dpids as $dtid => $pids) {
     $pw_tmsgs = GetTtable($dtid);
     $dfid = $dtids[$dtid];
     $threaddb = $db->get_one("SELECT t.tid,t.fid,t.author,t.authorid,t.postdate,t.subject,t.topped,t.anonymous,t.ifshield,t.ptable,t.ifcheck,tm.aid FROM pw_threads t LEFT JOIN {$pw_tmsgs} tm ON tm.tid=t.tid WHERE t.tid='{$dtid}'");
     if (!$threaddb) {
         continue;
     }
     $pw_posts = GetPtable($threaddb['ptable']);
     $pids = S::sqlImplode($pids);
     $query = $db->query("SELECT pid,fid,tid,aid,author,authorid,postdate,subject,content,anonymous,ifcheck FROM {$pw_posts} WHERE tid='{$dtid}' AND fid='{$dfid}' AND pid IN({$pids})");
     $replydb = array();
     while ($result = $db->fetch_array($query)) {
         !$result['subject'] && ($result['subject'] = substrs($rt['content'], 35));
         $result['postdate'] = get_date($result['postdate']);
         $result['ptable'] = $threaddb['ptable'];
         $replydb[] = $result;
     }
     /*删除回复*/
     $delarticle->delReply($replydb, false);
     /*删除静态*/
     $htmurl = $db_htmdir . '/' . $dfid . '/' . get_date('ym', $threaddb['postdate']) . '/' . $dtid . '.html';
     if (file_exists(R_P . $htmurl)) {
         P_unlink(R_P . $htmurl);
     }
 }
 //* P_unlink(D_P.'data/bbscache/c_cache.php');
 pwCache::deleteData(D_P . 'data/bbscache/c_cache.php');
 adminmsg('operate_success', "{$admin_file}?adminjob=superdel&admintype=article&action={$action}&fid={$_POST['fid']}&tid={$_POST['tid']}&pstart={$pstart}&pend={$pend}&author=" . rawurlencode($author) . "&keyword=" . rawurlencode($keyword) . "&userip={$userip}&tcounts={$tcounts}&counts={$counts}&nums={$nums}&ptable={$ptable}&page={$page}");

     /* 删除操作 */
 } elseif ($type == 'del') {
     define('AJAX', 1);
     S::gp(array('id'), '', 1);
     $id = (int) $id;
     if ($id < 1) {
         adminmsg('operate_error', "{$basename}&action=user");
     }
     require_once PrintApp('admin_user');
     ajax_footer();
     /* 删除操作 */
 } elseif ($type == 'deldo') {
     define('AJAX', 1);
     S::gp(array('id', 'descrip'));
     $id = (int) $id;
     $descrip = substrs($descrip, 200);
     if ($id < 1) {
         adminmsg('operate_error', "{$basename}&action=user");
     }
     $awardMedalInfo = $medalService->getAwardMedalById($id);
     $medal = $medalService->getMedal($awardMedalInfo['medal_id']);
     //获取medal信息
     if ($medal['type'] == 1) {
         adminmsg('medal_error');
     }
     $result = $medalService->recoverMedal($id, $descrip);
     //摘除操作
     if (is_array($result)) {
         adminmsg($result[1], "{$basename}&action=user");
     } else {
         adminmsg('medal_ajax_operate_success');

function updatecommend($fid, $forumset)
{
    global $db, $timestamp;
    $forumset['commendnum'] < 1 && ($forumset['commendnum'] = 10);
    $commend = array();
    $commendlist = '';
    if ($forumset['commendlist']) {
        $commendlist = pwImplode(explode(',', $forumset['commendlist']));
        $query = $db->query("SELECT tid,authorid,author,subject FROM pw_threads WHERE tid IN({$commendlist}) AND fid=" . pwEscape($fid));
        while ($rt = $db->fetch_array($query)) {
            if ($forumset['commendlength'] && strlen($rt['subject']) > $forumset['commendlength']) {
                $rt['subject'] = substrs($rt['subject'], $forumset['commendlength']);
            }
            $commend[] = $rt;
        }
    }
    $count = count($commend);
    if ($forumset['autocommend'] && $count < $forumset['commendnum']) {
        $limit = pwLimit($forumset['commendnum'] - $count);
        switch ($forumset['autocommend']) {
            case '1':
                $orderby = 'postdate';
                break;
            case '2':
                $orderby = 'lastpost';
                break;
            case '3':
                $orderby = 'hits';
                break;
            case '4':
                $orderby = 'replies';
                break;
            default:
                $orderby = 'digest';
                break;
        }
        $sql = $forumset['commendlist'] ? " AND tid NOT IN({$commendlist})" : '';
        $query = $db->query("SELECT tid,authorid,author,subject FROM pw_threads WHERE fid=" . pwEscape($fid) . " AND topped='0' {$sql} ORDER BY {$orderby} DESC {$limit}");
        while ($rt = $db->fetch_array($query)) {
            if ($forumset['commendlength'] && strlen($rt['subject']) > $forumset['commendlength']) {
                $rt['subject'] = substrs($rt['subject'], $forumset['commendlength']);
            }
            $commend[] = $rt;
        }
    }
    $forumset['ifcommend'] = $timestamp;
    $forumsetdb = addslashes(serialize($forumset));
    $commend = $commend ? addslashes(serialize($commend)) : '';
    $db->update("UPDATE pw_forumsextra" . " SET " . pwSqlSingle(array('forumset' => $forumsetdb, 'commend' => $commend)) . ' WHERE fid=' . pwEscape($fid));
    require_once R_P . 'admin/cache.php';
    updatecache_forums($fid);
}