phpBB 2.0.4 to 2.0.5 Code Changes

[Acyd Burn]

• templates/subSilver/profile_view_body.tpl

1. FIND - Line 75
   

   Code: Select all

   
   		if ( navigator.userAgent.toLowerCase().indexOf('mozilla') != -1 && navigator.userAgent.indexOf('5.') == -1 )
   

   
   
   REPLACE WITH
   

   Code: Select all

   
   		if ( navigator.userAgent.toLowerCase().indexOf('mozilla') != -1 && navigator.userAgent.indexOf('5.') == -1 && navigator.userAgent.indexOf('6.') == -1 )
   

   
   

[Acyd Burn]

• templates/subSilver/viewforum_body.tpl

1. FIND - Line 89
   

   Code: Select all

   
   				<td class="gensmall"><img src="{FOLDER_LOCKED_NEW_IMG}" alt="{L_NEW_POSTS_TOPIC_LOCKED}" width="19" height="18" /></td>
   				<td class="gensmall">{L_NEW_POSTS_LOCKED}</td>
   				<td>  </td>
   				<td class="gensmall"><img src="{FOLDER_LOCKED_IMG}" alt="{L_NO_NEW_POSTS_TOPIC_LOCKED}" width="19" height="18" /></td>
   

   
   
   REPLACE WITH
   

   Code: Select all

   
   				<td class="gensmall"><img src="{FOLDER_LOCKED_NEW_IMG}" alt="{L_NEW_POSTS_LOCKED}" width="19" height="18" /></td>
   				<td class="gensmall">{L_NEW_POSTS_LOCKED}</td>
   				<td>  </td>
   				<td class="gensmall"><img src="{FOLDER_LOCKED_IMG}" alt="{L_NO_NEW_POSTS_LOCKED}" width="19" height="18" /></td>
   

   
   

[Acyd Burn]

• viewforum.php

1. FIND - Line 374
   

   Code: Select all

   
   	$s_auth_can .= sprintf($lang['Rules_moderate'], "<a href=\"modcp.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>');
   

   
   
   REPLACE WITH
   

   Code: Select all

   
   	$s_auth_can .= sprintf($lang['Rules_moderate'], "<a href=\"modcp.$phpEx?" . POST_FORUM_URL . "=$forum_id&start=" . $start . "&sid=" . $userdata['session_id'] . '">', '</a>');
   

   
   
2. FIND - Line 662
   

   Code: Select all

   
   		);
   	}
   
   

   
   
   AFTER, ADD
   

   Code: Select all

   
   	$topics_count -= $total_announcements;
   
   

   
   

[Acyd Burn]

• viewtopic.php

1. FIND - Line 32
   

   Code: Select all

   
   //
   // Start initial var setup
   //
   

   
   
   AFTER, ADD
   

   Code: Select all

   
   $topic_id = $post_id = 0;
   

   
   
2. FIND - Line 108
   

   Code: Select all

   
   			FROM " . TOPICS_TABLE . " t, " . TOPICS_TABLE . " t2, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2
   			WHERE t2.topic_id = $topic_id
   				AND p2.post_id = t2.topic_last_post_id
   				AND t.forum_id = t2.forum_id
   				AND p.post_id = t.topic_last_post_id
   				AND p.post_time $sql_condition p2.post_time
   				AND p.topic_id = t.topic_id
   			ORDER BY p.post_time $sql_ordering
   

   
   
   REPLACE WITH
   

   Code: Select all

   
   			FROM " . TOPICS_TABLE . " t, " . TOPICS_TABLE . " t2
   			WHERE
   				t2.topic_id = $topic_id
   				AND t.forum_id = t2.forum_id
   				AND t.topic_last_post_id $sql_condition t2.topic_last_post_id
   			ORDER BY t.topic_last_post_id $sql_ordering
   

   
   
3. FIND - Line 137
   

   Code: Select all

   
   $join_sql_table = ( !isset($post_id) ) ? '' : ", " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2 ";
   $join_sql = ( !isset($post_id) ) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= $post_id";
   $count_sql = ( !isset($post_id) ) ? '' : ", COUNT(p2.post_id) AS prev_posts";
   
   $order_sql = ( !isset($post_id) ) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC";
   

   
   
   REPLACE WITH
   

   Code: Select all

   
   $join_sql_table = ( empty($post_id) ) ? '' : ", " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2 ";
   $join_sql = ( empty($post_id) ) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= $post_id";
   $count_sql = ( empty($post_id) ) ? '' : ", COUNT(p2.post_id) AS prev_posts";
   
   $order_sql = ( empty($post_id) ) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC";
   

   
   
4. FIND - Line 618
   

   Code: Select all

   
   $pagination = ( $highlight_active ) ? generate_pagination("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&postdays=$post_days&postorder=$post_order&highlight=$highlight", $total_replies, $board_config['posts_per_page'], $start) : generate_pagination("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&postdays=$post_days&postorder=$post_order", $total_replies, $board_config['posts_per_page'], $start);
   

   
   
   REPLACE WITH
   

   Code: Select all

   
   $pagination = ( $highlight != '' ) ? generate_pagination("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&postdays=$post_days&postorder=$post_order&highlight=$highlight", $total_replies, $board_config['posts_per_page'], $start) : generate_pagination("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&postdays=$post_days&postorder=$post_order", $total_replies, $board_config['posts_per_page'], $start);
   

   
   
5. FIND - Line 696
   

   Code: Select all

   
   				AND vote_user_id = " . $userdata['user_id'];
   

   
   
   REPLACE WITH
   

   Code: Select all

   
   				AND vote_user_id = " . intval($userdata['user_id']);
   

   
   
6. FIND - Line 795
   

   Code: Select all

   
   		$s_hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" />';
   

   
   
   REPLACE WITH
   

   Code: Select all

   
   		$s_hidden_fields .= '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" />';
   
   		$template->assign_vars(array(
   			'POLL_QUESTION' => $vote_title,