aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes
diff options
context:
space:
mode:
authorAndreas Fischer <bantu@phpbb.com>2012-05-22 03:11:53 +0200
committerAndreas Fischer <bantu@phpbb.com>2012-05-22 03:11:53 +0200
commit896b43aa5b7fe439106beb50cf56d6f066928537 (patch)
tree7e61cd177656fbb58700d1cc6ebc0d6795b887f4 /phpBB/includes
parentefbf14f029b7e6a1724fb1c5aa32294eb33017bc (diff)
downloadforums-896b43aa5b7fe439106beb50cf56d6f066928537.tar
forums-896b43aa5b7fe439106beb50cf56d6f066928537.tar.gz
forums-896b43aa5b7fe439106beb50cf56d6f066928537.tar.bz2
forums-896b43aa5b7fe439106beb50cf56d6f066928537.tar.xz
forums-896b43aa5b7fe439106beb50cf56d6f066928537.zip
[ticket/10565] Add line breaks to query in order to follow coding guidelines.
PHPBB3-10565
Diffstat (limited to 'phpBB/includes')
-rw-r--r--phpBB/includes/functions.php10
1 files changed, 7 insertions, 3 deletions
diff --git a/phpBB/includes/functions.php b/phpBB/includes/functions.php
index b415b2742d..bc811cc75b 100644
--- a/phpBB/includes/functions.php
+++ b/phpBB/includes/functions.php
@@ -1918,13 +1918,17 @@ function update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_ti
}
else
{
- $sql = 'SELECT t.forum_id FROM ' . TOPICS_TABLE . ' t
- LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt ON (tt.topic_id = t.topic_id AND tt.user_id = ' . $user->data['user_id'] . ')
+ $sql = 'SELECT t.forum_id
+ FROM ' . TOPICS_TABLE . ' t
+ LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt
+ ON (tt.topic_id = t.topic_id
+ AND tt.user_id = ' . $user->data['user_id'] . ')
WHERE t.forum_id = ' . $forum_id . '
AND t.topic_last_post_time > ' . $mark_time_forum . '
AND t.topic_moved_id = 0 ' .
$sql_update_unapproved . '
- AND (tt.topic_id IS NULL OR tt.mark_time < t.topic_last_post_time)';
+ AND (tt.topic_id IS NULL
+ OR tt.mark_time < t.topic_last_post_time)';
$result = $db->sql_query_limit($sql, 1);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);