elkarte / Elkarte

sources/subs/Unread.class.php

Indentation +12 added lines, -12 removed lines

@@ -358,7 +358,7 @@ 
 	 */
 	private function _getUnreadReplies($start, $limit, $include_avatars = false)
 	{
-        $request = $this->_db->query('unread_replies', '
+		$request = $this->_db->query('unread_replies', '
 				SELECT DISTINCT t.id_topic
 				FROM {db_prefix}topics AS t
 					INNER JOIN {db_prefix}messages AS m ON (m.id_topic = t.id_topic AND m.id_member = {int:current_member})' . (strpos($this->_sort_query, 'ms.') === false ? '' : '
@@ -369,19 +369,19 @@ 
 				WHERE t.id_board IN ({array_int:boards})
 					AND t.id_last_msg >= {int:min_message}
 					AND COALESCE(lt.id_msg, lmr.id_msg, 0) < t.id_last_msg' .
-            ($this->_post_mod ? ' AND t.approved = {int:is_approved}' : '') .
-            ($this->_unwatch ? ' AND COALESCE(lt.unwatched, 0) != 1' : '') . '
+			($this->_post_mod ? ' AND t.approved = {int:is_approved}' : '') .
+			($this->_unwatch ? ' AND COALESCE(lt.unwatched, 0) != 1' : '') . '
 				ORDER BY {raw:order}
 				LIMIT {int:offset}, {int:limit}',
-            array_merge($this->_query_parameters, array(
-                'current_member' => $this->_user_id,
-                'min_message' => $this->_min_message,
-                'is_approved' => 1,
-                'order' => $this->_sort_query . ($this->_ascending ? '' : ' DESC'),
-                'offset' => $start,
-                'limit' => $limit,
-            ))
-        );
+			array_merge($this->_query_parameters, array(
+				'current_member' => $this->_user_id,
+				'min_message' => $this->_min_message,
+				'is_approved' => 1,
+				'order' => $this->_sort_query . ($this->_ascending ? '' : ' DESC'),
+				'offset' => $start,
+				'limit' => $limit,
+			))
+		);
 
 		$topics = array();
 		while ($row = $this->_db->fetch_assoc($request))

sources/subs/Topic.subs.php

Indentation +21 added lines, -21 removed lines

@@ -1598,7 +1598,7 @@ 
 	$db = database();
 
 	// Get the messages and stick them into an array.
-    $request = $db->query('', '
+	$request = $db->query('', '
 		SELECT m.subject, COALESCE(mem.real_name, m.poster_name) AS real_name, m.poster_time, m.body, m.id_msg, m.smileys_enabled, m.id_member FROM
 		(SELECT m.id_msg FROM {db_prefix}messages AS m
 		WHERE m.id_topic = {int:current_topic}' . (empty($messages['before']) ? '' : '
@@ -1611,17 +1611,17 @@ 
 		LIMIT {int:start}, {int:messages_per_page}) AS o JOIN {db_prefix}messages as m ON o.id_msg=m.id_msg LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
 		ORDER BY m.id_msg DESC
 		',
-        array(
-            'current_topic' => $topic,
-            'no_split_msgs' => !empty($messages['excluded']) ? $messages['excluded'] : array(),
-            'split_msgs' => !empty($messages['included']) ? $messages['included'] : array(),
-            'is_approved' => 1,
-            'start' => $start,
-            'messages_per_page' => $items_per_page,
-            'msg_before' => !empty($messages['before']) ? (int) $messages['before'] : 0,
-            'msg_after' => !empty($messages['after']) ? (int) $messages['after'] : 0,
-        )
-    );
+		array(
+			'current_topic' => $topic,
+			'no_split_msgs' => !empty($messages['excluded']) ? $messages['excluded'] : array(),
+			'split_msgs' => !empty($messages['included']) ? $messages['included'] : array(),
+			'is_approved' => 1,
+			'start' => $start,
+			'messages_per_page' => $items_per_page,
+			'msg_before' => !empty($messages['before']) ? (int) $messages['before'] : 0,
+			'msg_after' => !empty($messages['after']) ? (int) $messages['after'] : 0,
+		)
+	);
 
 	$messages = array();
 	$parser = \BBC\ParserWrapper::instance();
@@ -2177,8 +2177,8 @@ 
 	);
 
 	// When evaluating potentially huge offsets, grab the ids only, first.
-    // The performance impact is still significant going from three columns to one.
-    $request = $db->query('display_get_post_poster', '
+	// The performance impact is still significant going from three columns to one.
+	$request = $db->query('display_get_post_poster', '
 		SELECT m.id_msg, m.id_member, m.approved
 		FROM (SELECT id_msg FROM {db_prefix}messages
 		WHERE id_topic = {int:current_topic}' . (!$modSettings['postmod_active'] || allowedTo('approve_posts') ? '' : '
@@ -2187,13 +2187,13 @@ 
 		ORDER BY id_msg ' . ($sort ? '' : 'DESC') . ($limit['messages_per_page'] == -1 ? '' : '
 		LIMIT ' . $limit['start'] . ', ' . $limit['offset']) . ') AS o JOIN {db_prefix}messages as m ON o.id_msg=m.id_msg
 		ORDER BY m.id_msg ' . ($sort ? '' : 'DESC'),
-        array(
-            'current_member' => $user_info['id'],
-            'current_topic' => $topic,
-            'is_approved' => 1,
-            'blank_id_member' => 0,
-        )
-    );
+		array(
+			'current_member' => $user_info['id'],
+			'current_topic' => $topic,
+			'is_approved' => 1,
+			'blank_id_member' => 0,
+		)
+	);
 
 	while ($row = $db->fetch_assoc($request))
 	{