function updaterequest($requestdata, $requesttemplatebody, $requesttemplate, $specialfid, $mode, $key, &$nocache)
{
global $db, $tablepre, $timestamp, $boardurl, $dateformat, $timeformat, $rewritestatus, $uc, $_DCACHE;
$function = $requestdata['function'];
$fids = isset($requestdata['fids']) ? $requestdata['fids'] : NULL;
$startrow = isset($requestdata['startrow']) ? intval($requestdata['startrow']) : 0;
$items = isset($requestdata['items']) ? intval($requestdata['items']) : 10;
$digest = isset($requestdata['digest']) ? intval($requestdata['digest']) : 0;
$stick = isset($requestdata['stick']) ? intval($requestdata['stick']) : 0;
$newwindow = isset($requestdata['newwindow']) ? $requestdata['newwindow'] : 1;
$LinkTarget = $newwindow == 1 ? " target='_blank'" : ($newwindow == 2 ? " target='main'" : NULL);
$sidestatus = !empty($requestdata['sidestatus']) ? 1 : 0;
$boardurl = empty($requestdata['boardurl']) ? $mode ? $boardurl : '' : $requestdata['boardurl'] . '/';
if ($function == 'threads') {
$orderby = isset($requestdata['orderby']) ? in_array($requestdata['orderby'], array('lastpost', 'dateline', 'replies', 'views', 'hourviews', 'todayviews', 'weekviews', 'monthviews')) ? $requestdata['orderby'] : 'lastpost' : 'lastpost';
$hours = isset($requestdata['hours']) ? intval($requestdata['hours']) : 0;
$highlight = isset($requestdata['highlight']) ? $requestdata['highlight'] : 0;
$picpre = isset($requestdata['picpre']) ? urldecode($requestdata['picpre']) : NULL;
$maxlength = !empty($requestdata['maxlength']) ? intval($requestdata['maxlength']) : 50;
$fnamelength = isset($requestdata['fnamelength']) ? intval($requestdata['fnamelength']) : 0;
$recommend = !empty($requestdata['recommend']) ? 1 : 0;
$tids = isset($requestdata['tids']) ? $requestdata['tids'] : NULL;
$keyword = !empty($requestdata['keyword']) ? $requestdata['keyword'] : NULL;
$typeids = isset($requestdata['typeids']) ? $requestdata['typeids'] : NULL;
$sortids = isset($requestdata['sortids']) ? $requestdata['sortids'] : NULL;
$special = isset($requestdata['special']) ? intval($requestdata['special']) : 0;
$rewardstatus = isset($requestdata['rewardstatus']) ? intval($requestdata['rewardstatus']) : 0;
$threadtype = isset($requestdata['threadtype']) ? intval($requestdata['threadtype']) : 0;
$threadsort = isset($requestdata['threadsort']) ? intval($requestdata['threadsort']) : 0;
$tag = !empty($requestdata['tag']) ? trim($requestdata['tag']) : NULL;
$messagelength = !empty($requestdata['messagelength']) ? intval($requestdata['messagelength']) : 255;
require DISCUZ_ROOT . './forumdata/cache/cache_forums.php';
$datalist = array();
$threadtypeids = array();
if ($keyword) {
if (preg_match("(AND|\\+|&|\\s)", $keyword) && !preg_match("(OR|\\|)", $keyword)) {
$andor = ' AND ';
$keywordsrch = '1';
$keyword = preg_replace("/( AND |&| )/is", "+", $keyword);
} else {
$andor = ' OR ';
$keywordsrch = '0';
$keyword = preg_replace("/( OR |\\|)/is", "+", $keyword);
}
$keyword = str_replace('*', '%', addcslashes($keyword, '%_'));
foreach (explode('+', $keyword) as $text) {
$text = trim($text);
if ($text) {
$keywordsrch .= $andor;
$keywordsrch .= "t.subject LIKE '%{$text}%'";
}
}
$keyword = " AND ({$keywordsrch})";
} else {
$keyword = '';
}
$sql = ($specialfid && $sidestatus ? ' AND t.fid = ' . $specialfid : ($fids ? ' AND t.fid IN (\'' . str_replace('_', '\',\'', $fids) . '\')' : '')) . $keyword . ($tids ? ' AND t.tid IN (\'' . str_replace('_', '\',\'', $tids) . '\')' : '') . ($typeids ? ' AND t.typeid IN (\'' . str_replace('_', '\',\'', $typeids) . '\')' : '') . ($sortids ? ' AND t.sortid IN (\'' . str_replace('_', '\',\'', $sortids) . '\')' : '') . ($special >= 0 && $special < 127 ? threadrange($special, 'special', 7) : '') . ($special & 16 && $rewardstatus ? $rewardstatus == 1 ? ' AND t.price < 0' : ' AND t.price > 0' : '') . ($digest > 0 && $digest < 15 ? threadrange($digest, 'digest') : '') . ($stick > 0 && $stick < 15 ? threadrange($stick, 'displayorder') : '');
if (in_array($orderby, array('hourviews', 'todayviews', 'weekviews', 'monthviews'))) {
$historytime = 0;
switch ($orderby) {
case 'hourviews':
$historytime = $timestamp - 3600 * $hours;
break;
case 'todayviews':
$historytime = mktime(0, 0, 0, date('m', $timestamp), date('d', $timestamp), date('Y', $timestamp));
break;
case 'weekviews':
$week = gmdate('w', $timestamp) - 1;
$week = $week != -1 ? $week : 6;
$historytime = mktime(0, 0, 0, date('m', $timestamp), date('d', $timestamp) - $week, date('Y', $timestamp));
break;
case 'monthviews':
$historytime = mktime(0, 0, 0, date('m', $timestamp), 1, date('Y', $timestamp));
break;
}
$sql .= ' AND t.dateline>=' . $historytime;
$orderby = 'views';
}
$sqlfrom = strexists($requesttemplate, '{message}') ? ",p.message FROM `{$tablepre}threads` t LEFT JOIN `{$tablepre}posts` p ON p.tid=t.tid AND p.first='1'" : "FROM `{$tablepre}threads` t";
if (strexists($requesttemplate, '{imgattach}')) {
$sqlfrom = ",a.remote,a.attachment,a.thumb {$sqlfrom} INNER JOIN `{$tablepre}attachments` a ON a.tid=t.tid";
$sql .= " AND a.isimage='1' AND a.readperm='0' AND a.price='0'";
$attachadd .= "GROUP BY a.tid";
$attachurl = $_DCACHE['settings']['attachurl'];
$attachurl = preg_match("/^((https?|ftps?):\\/\\/|www\\.)/i", $attachurl) ? $attachurl : $boardurl . $attachurl;
}
if ($recommend) {
$sqlfrom .= " INNER JOIN `{$tablepre}forumrecommend` fc ON fc.tid=t.tid";
}
if ($tag) {
$tags = explode(' ', $tag);
foreach ($tags as $tagk => $tagv) {
if (!preg_match('/^([\\x7f-\\xff_-]|\\w){3,20}$/', $tagv)) {
unset($tags[$tagk]);
}
}
if ($tags = implode("','", $tags)) {
$sqlfrom .= " INNER JOIN `{$tablepre}threadtags` tag ON tag.tid=t.tid AND tag.tagname IN ('{$tags}')";
}
}
$query = $db->query("SELECT t.tid,t.fid,t.readperm,t.author,t.authorid,t.subject,t.dateline,t.lastpost,t.lastposter,t.views,t.replies,t.highlight,t.digest,t.typeid,t.sortid\r\n\t\t\t{$sqlfrom} WHERE t.readperm='0'\r\n\t\t\t{$sql}\r\n\t\t\tAND t.displayorder>='0'\r\n\t\t\tAND t.fid>'0'\r\n\t\t\t{$attachadd}\r\n\t\t\tORDER BY t.{$orderby} DESC\r\n\t\t\tLIMIT {$startrow},{$items};");
while ($data = $db->fetch_array($query)) {
$datalist[$data['tid']]['fid'] = $data['fid'];
$datalist[$data['tid']]['fname'] = isset($_DCACHE['forums'][$data['fid']]['name']) ? str_replace('\\\'', ''', addslashes($_DCACHE['forums'][$data['fid']]['name'])) : NULL;
$datalist[$data['tid']]['fnamelength'] = strlen($datalist[$data['tid']]['fname']);
$datalist[$data['tid']]['subject'] = isset($data['subject']) ? str_replace('\\\'', ''', addslashes($data['subject'])) : NULL;
$datalist[$data['tid']]['dateline'] = gmdate("{$dateformat} {$timeformat}", $data['dateline'] + $_DCACHE['settings']['timeoffset'] * 3600);
$datalist[$data['tid']]['lastpost'] = gmdate("{$dateformat} {$timeformat}", $data['lastpost'] + $_DCACHE['settings']['timeoffset'] * 3600);
$datalist[$data['tid']]['lastposter'] = $data['lastposter'];
$datalist[$data['tid']]['authorid'] = $data['authorid'];
$datalist[$data['tid']]['views'] = $data['views'];
$datalist[$data['tid']]['replies'] = $data['replies'];
$datalist[$data['tid']]['highlight'] = $data['highlight'];
$datalist[$data['tid']]['message'] = cutmessage($data['message'], $messagelength);
$datalist[$data['tid']]['imgattach'] = ($data['remote'] ? $_DCACHE['settings']['ftp']['attachurl'] : $attachurl) . "/{$data['attachment']}" . ($_DCACHE['settings']['thumbstatus'] && $data['thumb'] ? '.thumb.jpg' : '');
if ($data['author']) {
$datalist[$data['tid']]['author'] = $data['author'];
} else {
$datalist[$data['tid']]['author'] = 'Anonymous';
$datalist[$data['tid']]['authorid'] = 0;
}
if ($data['lastposter']) {
$datalist[$data['tid']]['lastposter'] = $data['lastposter'];
} else {
$datalist[$data['tid']]['lastposter'] = '';
}
$datalist[$data['tid']]['typeid'] = $data['typeid'];
$datalist[$data['tid']]['sortid'] = $data['sortid'];
$datalist[$data['tid']]['subjectprefix'] = '';
$threadtypeids[] = $data['typeid'];
$threadtypeids[] = $data['sortid'];
}
if (($threadsort || $threadtype) && $threadtypeids) {
$typelist = array();
$query = $db->query("SELECT typeid, name FROM {$tablepre}threadtypes WHERE typeid IN ('" . implode('\',\'', $threadtypeids) . "')");
while ($typearray = $db->fetch_array($query)) {
$typelist[$typearray['typeid']] = $typearray['name'];
}
foreach ($datalist as $tid => $value) {
$subjectprefix = '';
if ($threadsort && $value['sortid'] && isset($typelist[$value['sortid']])) {
$subjectprefix .= '[' . $typelist[$value['sortid']] . ']';
}
if ($threadtype && $value['typeid'] && isset($typelist[$value['typeid']])) {
$subjectprefix .= '[' . $typelist[$value['typeid']] . ']';
}
$datalist[$tid]['subjectprefix'] = $subjectprefix;
}
}
$writedata = '';
if (is_array($datalist)) {
$colorarray = array('', '#EE1B2E', '#EE5023', '#996600', '#3C9D40', '#2897C5', '#2B65B7', '#8F2A90', '#EC1282');
$prefix = $picpre ? "<img src='{$picpre}' border='0' align='absmiddle'>" : NULL;
$requesttemplate = !$requesttemplate ? '{prefix} {subject}<br />' : $requesttemplate;
$order = 1;
foreach ($datalist as $tid => $value) {
$SubjectStyles = '';
if ($highlight && $value['highlight']) {
$string = sprintf('%02d', $value['highlight']);
$stylestr = sprintf('%03b', $string[0]);
$SubjectStyles .= " style='";
$SubjectStyles .= $stylestr[0] ? 'font-weight: bold;' : NULL;
$SubjectStyles .= $stylestr[1] ? 'font-style: italic;' : NULL;
$SubjectStyles .= $stylestr[2] ? 'text-decoration: underline;' : NULL;
$SubjectStyles .= $string[1] ? 'color: ' . $colorarray[$string[1]] : NULL;
$SubjectStyles .= "'";
}
$replace['{link}'] = $boardurl . "viewthread.php?tid={$tid}";
$value['prefixlength'] = $value['subjectprefix'] ? strlen(strip_tags($value['subjectprefix'])) : 0;
$value['maxlength'] = $maxlength - $value['prefixlength'];
$replace['{subject_nolink}'] = $value['subjectprefix'] . cutstr($value['subject'], $fnamelength ? $value['maxlength'] - $value['fnamelength'] : $value['maxlength'], '');
$replace['{subject_full}'] = $value['subjectprefix'] . $value['subject'];
$replace['{prefix}'] = $prefix;
$replace['{forum}'] = "<a href='" . $boardurl . "forumdisplay.php?fid={$value['fid']}'{$LinkTarget}>{$value['fname']}</a>";
$replace['{dateline}'] = $value['dateline'];
$replace['{subject}'] = "<a href='" . $boardurl . "viewthread.php?tid={$tid}' title='{$value['subject']}'{$SubjectStyles}{$LinkTarget}>" . $replace['{subject_nolink}'] . "</a>";
$replace['{message}'] = $value['message'];
if ($value['authorid']) {
$replace['{author}'] = "<a href='" . $boardurl . "space.php?uid={$value['authorid']}'{$LinkTarget}>{$value['author']}</a>";
} else {
$replace['{author}'] = $value['author'];
}
$replace['{author_nolink}'] = $value['author'];
if ($value['lastposter'] !== '') {
$replace['{lastposter}'] = "<a href='" . $boardurl . "space.php?username="******"'{$LinkTarget}>{$value['lastposter']}</a>";
$replace['{lastposter_nolink}'] = $value['lastposter'];
} else {
$replace['{lastposter}'] = $replace['{lastposter_nolink}'] = 'Anonymous';
}
$replace['{lastpost}'] = $value['lastpost'];
$replace['{views}'] = $value['views'];
$replace['{replies}'] = $value['replies'];
$replace['{imgattach}'] = $value['imgattach'];
$replace['{order}'] = $order++;
$writedata .= nodereplace($replace, $requesttemplate);
}
}
} elseif ($function == 'forums') {
$fups = isset($requestdata['fups']) ? $requestdata['fups'] : NULL;
$orderby = isset($requestdata['orderby']) ? in_array($requestdata['orderby'], array('displayorder', 'threads', 'posts')) ? $requestdata['orderby'] : 'displayorder' : 'displayorder';
$datalist = array();
$query = $db->query("SELECT `fid`,`fup`,`name`,`status`,`threads`,`posts`,`todayposts`,`displayorder`,`type`\r\n\t\t\tFROM `{$tablepre}forums`\r\n\t\t\tWHERE `type`!='group'\r\n\t\t\t" . ($fups ? "AND `fup` IN ('" . str_replace('_', '\',\'', $fups) . "') " : "") . "\r\n\t\t\tAND `status`='1'\r\n\t\t\tORDER BY " . ($orderby == 'displayorder' ? " `displayorder` ASC " : " `{$orderby}` DESC") . "\r\n\t\t\tLIMIT {$startrow}," . ($items > 0 ? $items : 65535) . ";");
while ($data = $db->fetch_array($query)) {
$datalist[$data['fid']]['name'] = str_replace('\\\'', ''', addslashes($data['name']));
$datalist[$data['fid']]['threads'] = $data['threads'];
$datalist[$data['fid']]['posts'] = $data['posts'];
$datalist[$data['fid']]['todayposts'] = $data['todayposts'];
}
$writedata = '';
if (is_array($datalist)) {
$requesttemplate = !$requesttemplate ? '{forumname}<br />' : $requesttemplate;
$order = 1;
foreach ($datalist as $fid => $value) {
$replace['{link}'] = $boardurl . "forumdisplay.php?fid={$fid}";
$replace['{forumname_nolink}'] = $value['name'];
$replace['{forumname}'] = "<a href='" . $boardurl . "forumdisplay.php?fid={$fid}'{$LinkTarget}>{$value['name']}</a>";
$replace['{threads}'] = $value['threads'];
$replace['{posts}'] = $value['posts'];
$replace['{todayposts}'] = $value['todayposts'];
$replace['{order}'] = $order++;
$writedata .= nodereplace($replace, $requesttemplate);
}
}
} elseif ($function == 'memberrank') {
$orderby = isset($requestdata['orderby']) ? in_array($requestdata['orderby'], array('credits', 'extcredits', 'posts', 'digestposts', 'regdate', 'hourposts', 'todayposts', 'weekposts', 'monthposts')) ? $requestdata['orderby'] : 'credits' : 'credits';
$hours = isset($requestdata['hours']) ? intval($requestdata['hours']) : 0;
$datalist = array();
switch ($orderby) {
case 'credits':
$sql = "SELECT m.`username`,m.`uid`,m.`credits` FROM `{$tablepre}members` m ORDER BY m.`credits` DESC";
break;
case 'extcredits':
$requestdata['extcredit'] = intval($requestdata['extcredit']);
$sql = "SELECT m.`username`,m.`uid`,m.`extcredits{$requestdata['extcredit']}` FROM `{$tablepre}members` m ORDER BY m.`extcredits{$requestdata['extcredit']}` DESC";
break;
case 'posts':
$sql = "SELECT m.`username`,m.`uid`,m.`posts` FROM `{$tablepre}members` m ORDER BY m.`posts` DESC";
break;
case 'digestposts':
$sql = "SELECT m.`username`,m.`uid`,m.`digestposts` FROM `{$tablepre}members` m ORDER BY m.`digestposts` DESC";
break;
case 'regdate':
$sql = "SELECT m.`username`,m.`uid`,m.`regdate` FROM `{$tablepre}members` m ORDER BY m.`regdate` DESC";
break;
case 'hourposts':
$historytime = $timestamp - 3600 * intval($hours);
$sql = "SELECT DISTINCT(p.author) AS username,p.authorid AS uid,COUNT(p.pid) AS postnum FROM `{$tablepre}posts` p WHERE p.`dateline`>={$historytime} AND p.`authorid`!='0' GROUP BY p.`author` ORDER BY `postnum` DESC";
break;
case 'todayposts':
$historytime = mktime(0, 0, 0, date('m', $timestamp), date('d', $timestamp), date('Y', $timestamp));
$sql = "SELECT DISTINCT(p.author) AS username,p.authorid AS uid,COUNT(p.pid) AS postnum FROM `{$tablepre}posts` p WHERE p.`dateline`>={$historytime} AND p.`authorid`!='0' GROUP BY p.`author` ORDER BY `postnum` DESC";
break;
case 'weekposts':
$week = gmdate('w', $timestamp) - 1;
$week = $week != -1 ? $week : 6;
$historytime = mktime(0, 0, 0, date('m', $timestamp), date('d', $timestamp) - $week, date('Y', $timestamp));
$sql = "SELECT DISTINCT(p.author) AS username,p.authorid AS uid,COUNT(p.pid) AS postnum FROM `{$tablepre}posts` p LEFT JOIN `{$tablepre}memberfields` mf ON mf.`uid` = p.`authorid` WHERE p.`dateline`>={$historytime} AND p.`authorid`!='0' GROUP BY p.`author` ORDER BY `postnum` DESC";
break;
case 'monthposts':
$historytime = mktime(0, 0, 0, date('m', $timestamp), 1, date('Y', $timestamp));
$sql = "SELECT DISTINCT(p.author) AS username,p.authorid AS uid,COUNT(p.pid) AS postnum FROM `{$tablepre}posts` p LEFT JOIN `{$tablepre}memberfields` mf ON mf.`uid` = p.`authorid` WHERE p.`dateline`>={$historytime} AND p.`authorid`!='0' GROUP BY p.`author` ORDER BY `postnum` DESC";
break;
}
$query = $db->query($sql . " LIMIT {$startrow},{$items};");
while ($data = $db->fetch_array($query, MYSQL_NUM)) {
$data[2] = $orderby == 'regdate' ? gmdate($dateformat, $data[2] + $_DCACHE['settings']['timeoffset'] * 3600) : $data[2];
$datalist[] = $data;
}
$writedata = '';
if (is_array($datalist)) {
$requesttemplate = !$requesttemplate ? '{regdate} {member} {value}<br />' : $requesttemplate;
$order = 1;
foreach ($datalist as $value) {
$replace['{regdate}'] = $replace['{value}'] = '';
if ($orderby == 'regdate') {
$replace['{regdate}'] = $value[2];
} else {
$replace['{value}'] = $value[2];
}
$replace['{uid}'] = $value[1];
$replace['{member}'] = "<a href='" . $boardurl . "space.php?uid={$value['1']}'{$LinkTarget}>{$value['0']}</a>";
$replace['{avatar}'] = "<a title='" . htmlspecialchars($value[0]) . "' href='" . $boardurl . "space.php?uid={$value['1']}'{$LinkTarget}>" . discuz_uc_avatar($value[1]) . "</a>";
$replace['{avatarsmall}'] = "<a title='" . htmlspecialchars($value[0]) . "' href='" . $boardurl . "space.php?uid={$value['1']}'{$LinkTarget}>" . discuz_uc_avatar($value[1], 'small') . "</a>";
$replace['{avatarbig}'] = "<a title='" . htmlspecialchars($value[0]) . "' href='" . $boardurl . "space.php?uid={$value['1']}'{$LinkTarget}>" . discuz_uc_avatar($value[1], 'big') . "</a>";
$replace['{order}'] = $order++;
$writedata .= nodereplace($replace, $requesttemplate);
}
}
} elseif ($function == 'stats') {
$info = isset($requestdata['info']) ? $requestdata['info'] : NULL;
if (is_array($info)) {
$language = $info;
$info_index = '';
$statsinfo = array();
$statsinfo['forums'] = $statsinfo['threads'] = $statsinfo['posts'] = 0;
$query = $db->query("SELECT `status`,`threads`,`posts`\r\n\t\t\t\t\tFROM `{$tablepre}forums` WHERE\r\n\t\t\t\t\t`status`='1';\r\n\t\t\t\t\t");
while ($forumlist = $db->fetch_array($query)) {
$statsinfo['forums']++;
$statsinfo['threads'] += $forumlist['threads'];
$statsinfo['posts'] += $forumlist['posts'];
}
unset($info['forums'], $info['threads'], $info['posts']);
foreach ($info as $index => $value) {
if ($index == 'members') {
$sql = "SELECT COUNT(*) FROM `{$tablepre}members`;";
} elseif ($index == 'online') {
$sql = "SELECT COUNT(*) FROM `{$tablepre}sessions`;";
} elseif ($index == 'onlinemembers') {
$sql = "SELECT COUNT(*) FROM `{$tablepre}sessions` WHERE `uid`>'0';";
}
if ($index == 'members' || $index == 'online' || $index == 'onlinemembers') {
$statsinfo[$index] = $db->result_first($sql);
}
}
unset($index, $value);
$writedata = '';
$requesttemplate = !$requesttemplate ? '{name} {value}<br />' : $requesttemplate;
foreach ($language as $index => $value) {
$replace['{name}'] = $value;
$replace['{value}'] = $statsinfo[$index];
$writedata .= str_replace(array_keys($replace), $replace, $requesttemplate);
}
}
} elseif ($function == 'images') {
$maxwidth = isset($requestdata['maxwidth']) ? $requestdata['maxwidth'] : 0;
$maxheight = isset($requestdata['maxheight']) ? $requestdata['maxheight'] : 0;
require DISCUZ_ROOT . './forumdata/cache/cache_forums.php';
$datalist = array();
$sql = ($specialfid && $sidestatus ? ' AND t.fid = ' . $specialfid : ($fids ? ' AND t.fid IN (\'' . str_replace('_', '\',\'', $fids) . '\')' : '')) . ($digest > 0 && $digest < 15 ? threadrange($digest, 'digest') : '');
$imagesql = "AND `attach`.`isimage`" . (!empty($requestdata['isimage']) ? $requestdata['isimage'] == 1 ? "='1'" : ($requestdata['isimage'] == 2 ? "='0'" : ">='0'") : ">='0'");
$methodsql = !empty($requestdata['threadmethod']) ? 'GROUP BY `attach`.`tid`' : '';
$hours = isset($requestdata['hours']) ? intval($requestdata['hours']) : 0;
$orderby = isset($requestdata['orderby']) ? in_array($requestdata['orderby'], array('dateline', 'downloads', 'hourdownloads', 'todaydownloads', 'weekdownloads', 'monthdownloads')) ? $requestdata['orderby'] : 'dateline' : 'dateline';
$orderbysql = $historytime = '';
switch ($orderby) {
case 'dateline':
$orderbysql = "ORDER BY `attach`.`dateline` DESC";
break;
case 'downloads':
$orderbysql = "ORDER BY `attach`.`downloads` DESC";
break;
case 'hourdownloads':
$historytime = $timestamp - 3600 * intval($hours);
$orderbysql = "ORDER BY `attach`.`downloads` DESC";
break;
case 'todaydownloads':
$historytime = mktime(0, 0, 0, date('m', $timestamp), date('d', $timestamp), date('Y', $timestamp));
$orderbysql = "ORDER BY `attach`.`downloads` DESC";
break;
case 'weekdownloads':
$week = gmdate('w', $timestamp) - 1;
$week = $week != -1 ? $week : 6;
$historytime = mktime(0, 0, 0, date('m', $timestamp), date('d', $timestamp) - $week, date('Y', $timestamp));
$orderbysql = "ORDER BY `attach`.`downloads` DESC";
break;
case 'monthdownloads':
$historytime = mktime(0, 0, 0, date('m', $timestamp), 1, date('Y', $timestamp));
$orderbysql = "ORDER BY `attach`.`downloads` DESC";
break;
}
$historytime = !$historytime ? $timestamp - 2592000 : $historytime;
$htsql = "`attach`.`dateline`>={$historytime}";
$query = $db->query("SELECT attach.*,t.tid,t.fid,t.digest,t.author,t.subject,t.displayorder\r\n\t\t\tFROM `{$tablepre}attachments` attach\r\n\t\t\tINNER JOIN `{$tablepre}threads` t\r\n\t\t\tON `t`.`tid`=`attach`.`tid` AND `displayorder`>='0'\r\n\t\t\tWHERE {$htsql} AND `attach`.`readperm`='0' AND `attach`.`price`='0'\r\n\t\t\t{$imagesql}\r\n\t\t\t{$sql}\r\n\t\t\t{$methodsql}\r\n\t\t\t{$orderbysql}\r\n\t\t\tLIMIT {$startrow},{$items};");
$attachurl = $_DCACHE['settings']['attachurl'];
$attachurl = preg_match("/^((https?|ftps?):\\/\\/|www\\.)/i", $attachurl) ? $attachurl : $boardurl . $attachurl;
$i = 0;
while ($data = $db->fetch_array($query)) {
$key = $requestdata['threadmethod'] ? $data['tid'] : $i++;
$datalist[$key]['threadlink'] = $boardurl . "redirect.php?goto=findpost&ptid={$data['tid']}&pid={$data['pid']}";
$datalist[$key]['imgfile'] = ($data['remote'] ? $_DCACHE['settings']['ftp']['attachurl'] : $attachurl) . "/{$data['attachment']}" . ($_DCACHE['settings']['thumbstatus'] && $data['thumb'] ? '.thumb.jpg' : '');
$datalist[$key]['file'] = $boardurl . "attachment.php?aid={$data['aid']}&k=" . md5($data[aid] . md5($_DCACHE['settings']['authkey']) . $timestamp) . "&t={$timestamp}";
$datalist[$key]['subject'] = str_replace('\\\'', ''', $data['subject']);
$datalist[$key]['filename'] = str_replace('\\\'', ''', $data['filename']);
$datalist[$key]['author'] = addslashes($data['author']);
$datalist[$key]['downloads'] = $data['downloads'];
$datalist[$key]['author'] = $data['author'];
$datalist[$key]['filesize'] = number_format($data['filesize']);
$datalist[$key]['dateline'] = gmdate("{$dateformat} {$timeformat}", $data['dateline'] + $_DCACHE['settings']['timeoffset'] * 3600);
$datalist[$key]['fname'] = isset($_DCACHE['forums'][$data['fid']]['name']) ? str_replace('\\\'', ''', addslashes($_DCACHE['forums'][$data['fid']]['name'])) : NULL;
$datalist[$key]['description'] = $data['description'] ? str_replace('\\\'', ''', addslashes($data['description'])) : NULL;
}
$writedata = '';
if (is_array($datalist)) {
$imgsize = ($maxwidth ? " width='{$maxwidth}'" : NULL) . ($maxheight ? " height='{$maxheight}'" : NULL);
$requesttemplate = !$requesttemplate ? '{file} ({filesize} Bytes)<br />' : $requesttemplate;
$order = 1;
foreach ($datalist as $value) {
$replace['{link}'] = $value['threadlink'];
$replace['{imgfile}'] = $value['imgfile'];
$replace['{url}'] = $value['file'];
$replace['{subject}'] = $value['subject'];
$replace['{filesubject}'] = $value['filename'];
$replace['{filedesc}'] = $value['description'];
$replace['{author}'] = $value['author'];
$replace['{dateline}'] = $value['dateline'];
$replace['{downloads}'] = $value['downloads'];
$replace['{filesize}'] = $value['filesize'];
$replace['{file}'] = "<a href='{$value['file']}'{$LinkTarget}>{$value['filename']}</a>";
$replace['{image}'] = "<a href='{$value['threadlink']}'{$LinkTarget}><img{$imgsize} src='{$value['imgfile']}' border='0'></a>";
$replace['{order}'] = $order++;
$writedata .= nodereplace($replace, $requesttemplate);
}
}
} elseif ($function == 'module') {
$requestrun = TRUE;
$settings = unserialize(get_magic_quotes_gpc() ? stripslashes($requestdata['settings']) : $requestdata['settings']);
if (@(!(include DISCUZ_ROOT . './include/request/' . $requestdata['module']))) {
return;
}
} else {
return;
}
$data = parsenode($writedata, $requesttemplatebody);
if ($rewritestatus) {
$searcharray = $replacearray = array();
if ($GLOBALS['rewritestatus'] & 1) {
$searcharray[] = "/\\<a href\\=\\'" . preg_quote($boardurl, '/') . "forumdisplay\\.php\\?fid\\=(\\d+)\\'/";
$replacearray[] = "<a href='{$boardurl}forum-\\1-1.html'";
}
if ($GLOBALS['rewritestatus'] & 2) {
$searcharray[] = "/\\<a href\\=\\'" . preg_quote($boardurl, '/') . "viewthread\\.php\\?tid\\=(\\d+)\\'/";
$replacearray[] = "<a href='{$boardurl}thread-\\1-1-1.html'";
}
if ($GLOBALS['rewritestatus'] & 4) {
$searcharray[] = "/\\<a href\\=\\'" . preg_quote($boardurl, '/') . "space\\.php\\?uid\\=(\\d+)\\'/";
$searcharray[] = "/\\<a href\\=\\'" . preg_quote($boardurl, '/') . "space\\.php\\?username\\=([^&]+?)\\'/";
$replacearray[] = "<a href='{$boardurl}space-uid-\\1.html'";
$replacearray[] = "<a href='{$boardurl}space-username-\\1.html'";
}
$data = preg_replace($searcharray, $replacearray, $data);
}
return $data;
}
$extcredits = $_DCACHE['settings']['extcredits'];
$creditstransextra = $_DCACHE['settings']['creditstransextra'];
$rewardend = $thread['price'] > 0;
$rewardprice = abs($thread['price']);
$message = cutmessage($db->result_first("SELECT message FROM {$tablepre}posts WHERE tid='{$tid}' AND first=1"), 100);
} elseif ($thread['special'] == 4) {
$message = cutmessage($db->result_first("SELECT message FROM {$tablepre}posts WHERE tid='{$tid}' AND first=1"), 100);
$number = $db->result_first("SELECT number FROM {$tablepre}activities WHERE tid='{$tid}'");
$applynumbers = $db->result_first("SELECT COUNT(*) FROM {$tablepre}activityapplies WHERE tid='{$tid}' AND verified=1");
$aboutmembers = $number - $applynumbers;
} elseif ($thread['special'] == 5) {
$message = cutmessage($db->result_first("SELECT message FROM {$tablepre}posts WHERE tid='{$tid}' AND first=1"), 100);
$debate = $db->fetch_first("SELECT affirmdebaters, negadebaters, affirmvotes, negavotes FROM {$tablepre}debates WHERE tid='{$tid}'");
$debate['affirmvoteswidth'] = $debate['affirmvotes'] ? intval(80 * (($debate['affirmvotes'] + 1) / ($debate['affirmvotes'] + $debate['negavotes'] + 1))) : 1;
$debate['negavoteswidth'] = $debate['negavotes'] ? intval(80 * (($debate['negavotes'] + 1) / ($debate['affirmvotes'] + $debate['negavotes'] + 1))) : 1;
} elseif ($thread['special'] == 6) {
require_once DISCUZ_ROOT . './api/video.php';
$video = $db->fetch_first("SELECT vid, vtitle, vthumb FROM {$tablepre}videos WHERE tid='{$tid}' ORDER BY displayorder LIMIT 1");
$video['vthumb'] = VideoClient_Util::getThumbUrl($video['vid'], 'small');
} else {
$message = cutmessage($db->result_first("SELECT message FROM {$tablepre}posts WHERE tid='{$tid}' AND first=1"), 100);
}
}
include template('request_thread');
} else {
$request_version = '1.0';
$request_name = $requestlang['thread_name'];
$request_description = $requestlang['thread_desc'];
$request_copyright = '<a href="http://www.comsenz.com" target="_blank">Comsenz Inc.</a>';
$request_settings = array('tid' => array($requestlang['thread_id'], '', 'text'));
}