📄 threads.inc.php
字号:
<?php
/*
[Discuz!] (C)2001-2009 Comsenz Inc.
This is NOT a freeware, use is subject to license terms
$Id: threads.inc.php 16886 2008-11-26 05:08:30Z cnteacher $
*/
if(!defined('IN_DISCUZ') || !defined('IN_MODCP')) {
exit('Access Denied');
}
$op = !in_array($op , array('threads', 'posts')) ? 'threads' : $op;
$do = !empty($do) ? dhtmlspecialchars($do) : '';
$modtpl = $op == 'posts' ? 'modcp_posts' : 'modcp_threads';
if($op == 'threads') {
if($fid && $forum['ismoderator']) {
$result = array();
foreach (array('threadoption', 'viewsless', 'viewsmore', 'repliesless', 'repliesmore', 'noreplydays') as $key) {
$$key = isset($$key) && is_numeric($$key) ? intval($$key) : '';
$result[$key] = $$key;
}
foreach (array('starttime', 'endtime', 'keywords', 'users') as $key) {
$result[$key] = isset($$key) ? dhtmlspecialchars($$key) : '';
}
$threadoptionselect = array($threadoption => 'selected');
if($do == 'search' && submitcheck('submit')) {
$sql = '';
if($threadoption > 0 && $threadoption < 255) {
$sql .= " AND special='$threadoption'";
} elseif($threadoption == 999) {
$sql .= " AND digest in(1,2,3)";
} elseif($threadoption == 888) {
$sql .= " AND displayorder IN(1,2,3)";
}
$sql .= $viewsless !== ''? " AND views<='$viewsless'" : '';
$sql .= $viewsmore !== ''? " AND views>='$viewsmore'" : '';
$sql .= $repliesless !== ''? " AND replies<='$repliesless'" : '';
$sql .= $repliesmore !== ''? " AND replies>='$repliesmore'" : '';
$sql .= $noreplydays !== ''? " AND lastpost<='$timestamp'-'$noreplydays'*86400" : '';
$sql .= $starttime != '' ? " AND dateline>='".strtotime($starttime)."'" : '';
$sql .= $endtime != '' ? " AND dateline<='".strtotime($endtime)."'" : '';
if(trim($keywords)) {
$sqlkeywords = '';
$or = '';
$keywords = explode(',', str_replace(' ', '', $keywords));
for($i = 0; $i < count($keywords); $i++) {
$sqlkeywords .= " $or subject LIKE '%".$keywords[$i]."%'";
$or = 'OR';
}
$sql .= " AND ($sqlkeywords)";
$keywords = implode(', ', $keywords);
}
if(trim($users)) {
$sql .= " AND author IN ('".str_replace(',', '\',\'', str_replace(' ', '', trim($users)))."')";
}
if($sql) {
$query = $db->query("SELECT tid FROM {$tablepre}threads WHERE fid='$fid' AND displayorder>=0 $sql ORDER BY displayorder DESC, lastpost DESC LIMIT 1000");
$tids = $comma = '';
$count = 0;
while ($tid = $db->fetch_array($query)) {
$tids .= $comma.$tid['tid'];
$comma = ',';
$count ++;
}
$result['tids'] = $tids;
$result['count'] = $count;
$result['fid'] = $fid;
$modsession->set('srchresult', $result, true);
$db->free_result($query);
unset($result, $tids);
$do = 'list';
$page = 1;
} else {
$do = '';
}
}
$page = max(1, intval($page));
$total = 0;
$query = $multipage = '';
if(empty($do)) {
$total = $db->result_first("SELECT count(*) FROM {$tablepre}threads WHERE fid='$fid' AND displayorder>=0");
$tpage = ceil($total / $tpp);
$page = min($tpage, $page);
$multipage = multi($total, $tpp, $page, "$cpscript?action=$action&op=$op&fid=$fid&do=$do");
if($total) {
$start = ($page - 1) * $tpp;
$query = $db->query("SELECT * FROM {$tablepre}threads WHERE fid='$fid' AND displayorder>=0 ORDER BY displayorder DESC, lastpost DESC LIMIT $start, $tpp");
}
} else {
$result = $modsession->get('srchresult');
$threadoptionselect = array($result['threadoption'] => 'selected');
if($result['fid'] == $fid) {
$total = $result['count'];
$tpage = ceil($total / $tpp);
$page = min($tpage, $page);
$multipage = multi($total, $tpp, $page, "$cpscript?action=$action&op=$op&fid=$fid&do=$do");
if($total) {
$start = ($page - 1) * $tpp;
$query = $db->query("SELECT * FROM {$tablepre}threads WHERE tid in($result[tids]) ORDER BY lastpost DESC LIMIT $start, $tpp");
}
}
}
$postlist = array();
if($query) {
require_once DISCUZ_ROOT.'./include/misc.func.php';
while ($thread = $db->fetch_array($query)) {
$postlist[] = procthread($thread);
}
}
}
return;
}
if($op == 'posts') {
$error = 0;
$result = array();
$result['threadoption'] = intval($threadoption);
$starttime = !preg_match("/^(0|\d{4}\-\d{1,2}\-\d{1,2})$/", $starttime) ? gmdate('Y-n-j', $timestamp + $timeoffset * 3600 - 86400 * 7) : $starttime;
$endtime = $adminid == 3 || !preg_match("/^(0|\d{4}\-\d{1,2}\-\d{1,2})$/", $endtime) ? gmdate('Y-n-j', $timestamp + $timeoffset * 3600) : $endtime;
foreach (array('starttime', 'endtime', 'keywords', 'users', 'useip') as $key) {
$$key = isset($$key) ? trim($$key) : '';
$result[$key] = dhtmlspecialchars($$key);
}
$threadoptionselect = array($threadoption => 'selected');
$fidadd = '';
if($fid && $modforums['list'][$fid]) {
$fidadd = "AND fid='$fid'";
} else {
if($adminid == 1 && $adminid == $groupid) {
$fidadd = '';
} elseif(!$modforums['fids']) {
$fidadd = 'AND 0 ';
} else {
$fidadd = "AND fid in($modforums[fids])";
}
}
if($do == 'delete' && submitcheck('deletesubmit')) {
if(!$allowmassprune) {
$error = 4;
return;
}
$tidsdelete = $pidsdelete = '0';
$prune = array();
if($pids = implodeids($delete)) {
$tidsdelete = $pidsdelete = '0';
$query = $db->query("SELECT fid, tid, pid, first, authorid FROM {$tablepre}posts WHERE pid IN ($pids) $fidadd");
while($post = $db->fetch_array($query)) {
$prune['forums'][] = $post['fid'];
$prune['thread'][$post['tid']]++;
$pidsdelete .= ",$post[pid]";
$tidsdelete .= $post['first'] ? ",$post[tid]" : '';
}
}
if($pidsdelete) {
require_once DISCUZ_ROOT.'./include/post.func.php';
$query = $db->query("SELECT attachment, thumb, remote FROM {$tablepre}attachments WHERE pid IN ($pidsdelete) OR tid IN ($tidsdelete)");
while($attach = $db->fetch_array($query)) {
dunlink($attach['attachment'], $attach['thumb'], $attach['remote']);
}
if(!$nocredit) {
$postsarray = $tuidarray = $ruidarray = array();
$query1 = $db->query("SELECT pid, first, authorid FROM {$tablepre}posts WHERE pid IN ($pidsdelete)");
$query2 = $db->query("SELECT pid, first, authorid FROM {$tablepre}posts WHERE tid IN ($tidsdelete)");
while(($post = $db->fetch_array($query1)) || ($post = $db->fetch_array($query2))) {
$postsarray[$post['pid']] = $post;
}
foreach($postsarray as $post) {
if($post['first']) {
$tuidarray[] = $post['authorid'];
} else {
$ruidarray[] = $post['authorid'];
}
}
if($tuidarray) {
updatepostcredits('-', $tuidarray, $creditspolicy['post']);
}
if($ruidarray) {
updatepostcredits('-', $ruidarray, $creditspolicy['reply']);
}
}
$db->query("DELETE FROM {$tablepre}attachments WHERE pid IN ($pidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}attachments WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}threadsmod WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}threadsmod WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}threads WHERE tid IN ($tidsdelete)");
$deletedthreads = $db->affected_rows();
$db->query("DELETE FROM {$tablepre}posts WHERE pid IN ($pidsdelete)");
$deletedposts = $db->affected_rows();
$db->query("DELETE FROM {$tablepre}posts WHERE tid IN ($tidsdelete)");
$deletedposts += $db->affected_rows();
$db->query("DELETE FROM {$tablepre}polloptions WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}polls WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}rewardlog WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}trades WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}rewardlog WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}activities WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}activityapplies WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
$db->query("DELETE FROM {$tablepre}typeoptionvars WHERE tid IN ($tidsdelete)", 'UNBUFFERED');
if(count($prunt['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 {$tablepre}threads SET replies=replies-$decrease WHERE tid IN (".implode(',', $tidarray).")");
}
}
foreach(array_unique($prune['forums']) as $id) {
updateforumcount($id);
}
}
$do = 'list';
}
if($do == 'search' && submitcheck('searchsubmit')) {
if(($starttime == '0' && $endtime == '0') || ($keywords == '' && $useip == '' && $users == '')) {
$error = 1;
return ;
}
$sql = '';
if($threadoption == 1) {
$sql .= " AND first='1'";
} elseif($threadoption == 2) {
$sql .= " AND first='0'";
}
if($starttime != '0') {
$starttime = strtotime($starttime);
$sql .= " AND dateline>'$starttime'";
}
if($adminid == 1 && $endtime != gmdate('Y-n-j', $timestamp + $timeoffset * 3600)) {
if($endtime != '0') {
$endtime = strtotime($endtime);
$sql .= " AND dateline<'$endtime'";
}
} else {
$endtime = $timestamp;
}
if(($adminid == 2 && $endtime - $starttime > 86400 * 16) || ($adminid == 3 && $endtime - $starttime > 86400 * 8)) {
$error = '2';
return;
}
if($users != '') {
$uids = $comma = '';
$query = $db->query("SELECT uid FROM {$tablepre}members WHERE username IN ('".str_replace(',', '\',\'', str_replace(' ', '', $users))."')");
while($member = $db->fetch_array($query)) {
$uids .= $comma.$member[uid]; $comma = ',';
}
if($uids) {
$sql .= " AND authorid IN ($uids)";
}
}
if(trim($keywords)) {
$sqlkeywords = '';
$or = '';
$keywords = explode(',', str_replace(' ', '', $keywords));
for($i = 0; $i < count($keywords); $i++) {
if(strlen($keywords[$i]) > 3) {
$sqlkeywords .= " $or message LIKE '%".$keywords[$i]."%'";
$or = 'OR';
} else {
$error = 3;
return ;
}
}
$sql .= " AND ($sqlkeywords)";
}
$useip = trim($useip);
if($useip != '') {
$sql .= " AND useip LIKE '".str_replace('*', '%', $useip)."'";
}
if($sql) {
$query = $db->query("SELECT pid FROM {$tablepre}posts WHERE 1 $fidadd $sql ORDER BY dateline DESC LIMIT 1000");
$pids = $comma = '';
$count = 0;
while ($pid = $db->fetch_array($query)) {
$pids .= $comma.$pid['pid'];
$comma = ',';
$count ++;
}
$result['pids'] = $pids;
$result['count'] = $count;
$result['fid'] = $fid;
$modsession->set('srchresult_p'.$fid, $result, true);
$db->free_result($query);
unset($result, $pids);
$do = 'list';
$page = 1;
} else {
$do = '';
}
}
$page = max(1, intval($page));
$total = 0;
$query = $multipage = '';
if($do == 'list') {
$result = $modsession->get('srchresult_p'.$fid);
$threadoptionselect = array($result['threadoption'] => 'selected');
if($result['fid'] == $fid) {
$total = $result['count'];
$tpage = ceil($total / $tpp);
$page = min($tpage, $page);
$multipage = multi($total, $tpp, $page, "$cpscript?action=$action&op=$op&fid=$fid&do=$do");
if($total && $result[pids]) {
$start = ($page - 1) * $tpp;
$query = $db->query("SELECT p.*, t.subject as tsubject FROM {$tablepre}posts p LEFT JOIN {$tablepre}threads t USING(tid) WHERE pid in($result[pids]) ORDER BY dateline DESC LIMIT $start, $tpp");
}
}
}
$postlist = array();
if($query) {
while ($post = $db->fetch_array($query)) {
$post['dateline'] = gmdate("$dateformat $timeformat", $post['dateline'] + $timeoffset * 3600);
$post['message'] = dhtmlspecialchars(cutstr($post['message'], 200), 200);
$post['forum'] = $modforums['list'][$post[fid]];
$post['modthreadkey'] = modthreadkey($post['tid']);
$postlist[] = $post;
}
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -