aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/mcp/mcp_reports.php
diff options
context:
space:
mode:
authorNils Adermann <naderman@naderman.de>2006-03-28 18:59:00 +0000
committerNils Adermann <naderman@naderman.de>2006-03-28 18:59:00 +0000
commit112a0e876145d204cfbb0effe9400953bb0cc689 (patch)
tree3b44366fce78e2124c9d7fcbd94b86ef0f029811 /phpBB/includes/mcp/mcp_reports.php
parenta22c4b96bfed52433324ca3618229e411a1bdfc8 (diff)
downloadforums-112a0e876145d204cfbb0effe9400953bb0cc689.tar
forums-112a0e876145d204cfbb0effe9400953bb0cc689.tar.gz
forums-112a0e876145d204cfbb0effe9400953bb0cc689.tar.bz2
forums-112a0e876145d204cfbb0effe9400953bb0cc689.tar.xz
forums-112a0e876145d204cfbb0effe9400953bb0cc689.zip
- don't show too old reports/queue entries
git-svn-id: file:///svn/phpbb/trunk@5752 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/mcp/mcp_reports.php')
-rwxr-xr-xphpBB/includes/mcp/mcp_reports.php3
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/includes/mcp/mcp_reports.php b/phpBB/includes/mcp/mcp_reports.php
index 390024e199..fdd2ba9d8d 100755
--- a/phpBB/includes/mcp/mcp_reports.php
+++ b/phpBB/includes/mcp/mcp_reports.php
@@ -215,7 +215,7 @@ class mcp_reports
$sort_days = $total = 0;
$sort_key = $sort_dir = '';
$sort_by_sql = $sort_order_sql = array();
- mcp_sorting('reports', $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $forum_id, $topic_id);
+ mcp_sorting($mode, $sort_days, $sort_key, $sort_dir, $sort_by_sql, $sort_order_sql, $total, $forum_id, $topic_id);
$forum_topics = ($total == -1) ? $forum_info['forum_topics'] : $total;
$limit_time_sql = ($sort_days) ? 'AND t.topic_last_post_time >= ' . (time() - ($sort_days * 86400)) : '';
@@ -238,6 +238,7 @@ class mcp_reports
" . (($sort_order_sql[0] == 'r') ? 'AND ru.user_id = p.poster_id' : '') . "
" . (($topic_id) ? "AND p.topic_id = $topic_id" : '') . "
AND t.topic_id = p.topic_id
+ $limit_time_sql
ORDER BY $sort_order_sql";
$result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);