Soda Tasting, an online show for those who love soda

Bookmark and Share

phpBB 2.0.4 to 2.0.5 Code Changes

Postby Acyd Burn » June 22nd 2003, 10:58 am

  • language/lang_english/email/coppa_welcome_inactive.tpl
  1. FIND - Line 47
    Code: Select all
    
    Once the administrator has recived the above form via fax or regular mail your account will be activated.
    


    REPLACE WITH
    Code: Select all
    
    Once the administrator has received the above form via fax or regular mail your account will be activated.
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

Postby Acyd Burn » June 22nd 2003, 10:58 am

  • language/lang_english/lang_admin.php
  1. FIND - Line 254
    Code: Select all
    
    $lang['Board_disable_explain'] = 'This will make the board unavailable to users. Do not log out when you disable the board because you will not be able to log back in!';
    


    REPLACE WITH
    Code: Select all
    
    $lang['Board_disable_explain'] = 'This will make the board unavailable to users. Administrators are able to access the Administration Panel while the board is disabled.';
    

  2. FIND - Line 334
    Code: Select all
    
    $lang['Cookie_secure_explain'] = 'If your server is running via SSL, set this to enabled, else leave as disabled';
    $lang['Session_length'] = 'Session length [ seconds ]';
    
    


    AFTER, ADD
    Code: Select all
    
    // Visual Confirmation
    $lang['Visual_confirm'] = 'Enable Visual Confirmation';
    $lang['Visual_confirm_explain'] = 'Requires users enter a code defined by an image when registering.';
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

Postby Acyd Burn » June 22nd 2003, 10:59 am

  • language/lang_english/lang_main.php
  1. FIND - Line 607
    Code: Select all
    
    $lang['Password_mismatch'] = 'The passwords you entered did not match.';
    $lang['Current_password_mismatch'] = 'The current password you supplied does not match that stored in the database.';
    $lang['Password_long'] = 'Your password must be no more than 32 characters.';
    


    AFTER, ADD
    Code: Select all
    
    $lang['Too_many_registers'] = 'You have made too many registration attempts. Please try again later.';
    

  2. FIND - Line 662
    Code: Select all
    
    
    
    //
    


    AFTER, ADD
    Code: Select all
    
    // Visual confirmation system strings
    //
    $lang['Confirm_code_wrong'] = 'The confirmation code you entered was incorrect';
    $lang['Too_many_registers'] = 'You have exceeded the number of registration attempts for this session. Please try again later.';
    $lang['Confirm_code_impaired'] = 'If you are visually impaired or cannot otherwise read this code please contact the %sAdministrator%s for help.';
    $lang['Confirm_code'] = 'Confirmation code';
    $lang['Confirm_code_explain'] = 'Enter the code exactly as you see it. The code is case sensitive and zero has a diagonal line through it.';
    
    
    
    //
    

  3. FIND - Line 888
    Code: Select all
    
    $lang['None_selected'] = 'You have no selected any topics to perform this operation on. Please go back and select at least one.';
    


    REPLACE WITH
    Code: Select all
    
    $lang['None_selected'] = 'You have not selected any topics to perform this operation on. Please go back and select at least one.';
    

  4. FIND - Line 934
    Code: Select all
    
    $lang['10'] = 'GMT + 10 Hours';
    $lang['11'] = 'GMT + 11 Hours';
    $lang['12'] = 'GMT + 12 Hours';
    


    AFTER, ADD
    Code: Select all
    
    $lang['13'] = 'GMT + 13 Hours';
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

Postby Acyd Burn » June 22nd 2003, 11:00 am

  • login.php
  1. FIND - Line 57
    Code: Select all
    
    		$username = isset($HTTP_POST_VARS['username']) ? $HTTP_POST_VARS['username'] : '';
    		$password = isset($HTTP_POST_VARS['password']) ? $HTTP_POST_VARS['password'] : '';
    
    		$sql = "SELECT user_id, username, user_password, user_active, user_level
    			FROM " . USERS_TABLE . "
    			WHERE username = '" . str_replace("\'", "''", $username) . "'";
    


    REPLACE WITH
    Code: Select all
    
    		$username = isset($HTTP_POST_VARS['username']) ? trim(htmlspecialchars($HTTP_POST_VARS['username'])) : '';
    		$username = substr(str_replace("\\'", "'", $username), 0, 25);
    		$username = str_replace("'", "\\'", $username);
    		$password = isset($HTTP_POST_VARS['password']) ? $HTTP_POST_VARS['password'] : '';
    
    		$sql = "SELECT user_id, username, user_password, user_active, user_level
    			FROM " . USERS_TABLE . "
    			WHERE username = '" . str_replace("\\'", "''", $username) . "'";
    

  2. FIND - Line 97
    Code: Select all
    
    					$redirect = str_replace("?", "&", $redirect);
    
    					$template->assign_vars(array(
    						'META' => '<meta http-equiv="refresh" content="3;url=' . "login.$phpEx?redirect=$redirect&sid=" . $userdata['session_id'] . '">')
    					);
    
    					$message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], '<a href="' . "login.$phpEx?redirect=$redirect&sid=" . $userdata['session_id'] . '">', '</a>') . '<br /><br />' .  sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
    


    REPLACE WITH
    Code: Select all
    
    					$redirect = str_replace('?', '&', $redirect);
    
    					$template->assign_vars(array(
    						'META' => "<meta http-equiv=\"refresh\" content=\"3;url=login.$phpEx?redirect=$redirect\">")
    					);
    
    					$message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], "<a href=\"login.$phpEx?redirect=$redirect\">", '</a>') . '<br /><br />' .  sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
    

  3. FIND - Line 115
    Code: Select all
    
    				'META' => '<meta http-equiv="refresh" content="3;url=' . "login.$phpEx?redirect=$redirect&sid=" . $userdata['session_id'] . '">')
    			);
    
    			$message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], '<a href="' . "login.$phpEx?redirect=$redirect&sid=" . $userdata['session_id'] . '">', '</a>') . '<br /><br />' .  sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
    
    			message_die(GENERAL_MESSAGE, $message);
    		}
    	}
    	else if( ( isset($HTTP_GET_VARS['logout']) || isset($HTTP_POST_VARS['logout']) ) && $userdata['session_logged_in'] )
    	{
    		// session id check
    		if ($sid == '' || $sid != $userdata['session_id'])
    		{
    			message_die(GENERAL_ERROR, 'Invalid_session');
    		}
    
    


    REPLACE WITH
    Code: Select all
    
    				'META' => "<meta http-equiv=\"refresh\" content=\"3;url=login.$phpEx?redirect=$redirect\">")
    			);
    
    			$message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], "<a href=\"login.$phpEx?redirect=$redirect\">", '</a>') . '<br /><br />' .  sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');
    
    			message_die(GENERAL_MESSAGE, $message);
    		}
    	}
    	else if( ( isset($HTTP_GET_VARS['logout']) || isset($HTTP_POST_VARS['logout']) ) && $userdata['session_logged_in'] )
    	{
    

  4. FIND - Line 200
    Code: Select all
    
    		$s_hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="redirect" value="' . $forward_page . '" />';
    


    REPLACE WITH
    Code: Select all
    
    		$s_hidden_fields = '<input type="hidden" name="redirect" value="' . $forward_page . '" />';
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

Postby Acyd Burn » June 22nd 2003, 11:00 am

  • memberlist.php
  1. FIND - Line 40
    Code: Select all
    
    	$mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
    


    REPLACE WITH
    Code: Select all
    
    	$mode = ( isset($HTTP_POST_VARS['mode']) ) ? htmlspecialchars($HTTP_POST_VARS['mode']) : htmlspecialchars($HTTP_GET_VARS['mode']);
    

  2. FIND - Line 120
    Code: Select all
    
    		$order_by = "user_regdate ASC LIMIT $start, " . $board_config['topics_per_page'];
    


    REPLACE WITH
    Code: Select all
    
    		$order_by = "user_regdate $sort_order LIMIT $start, " . $board_config['topics_per_page'];
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

Postby Acyd Burn » June 22nd 2003, 11:01 am

  • modcp.php
  1. FIND - Line 666
    Code: Select all
    
    		if (isset($HTTP_POST_VARS['split_type_all']) || isset($HTTP_POST_VARS['split_type_beyond']))
    		{
    			$posts = $HTTP_POST_VARS['post_id_list'];
    
    			$post_id_sql = '';
    			for ($i = 0; $i < count($posts); $i++)
    			{
    				$post_id_sql .= (($post_id_sql != '') ? ', ' : '') . intval($posts[$i]);
    			}
    


    REPLACE WITH
    Code: Select all
    
    		$post_id_sql = '';
    
    		if (isset($HTTP_POST_VARS['split_type_all']) || isset($HTTP_POST_VARS['split_type_beyond']))
    		{
    			$posts = $HTTP_POST_VARS['post_id_list'];
    
    			for ($i = 0; $i < count($posts); $i++)
    			{
    				$post_id_sql .= (($post_id_sql != '') ? ', ' : '') . intval($posts[$i]);
    			}
    		}
    
    		if ($post_id_sql != '')
    		{
    

  2. FIND - Line 777
    Code: Select all
    
    			$s_hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="' . POST_FORUM_URL . '" value="' . $forum_id . '" /><input type="hidden" name="mode" value="split" />';
    


    REPLACE WITH
    Code: Select all
    
    			$s_hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="' . POST_FORUM_URL . '" value="' . $forum_id . '" /><input type="hidden" name="' . POST_TOPIC_URL . '" value="' . $topic_id . '" /><input type="hidden" name="mode" value="split" />';
    

  3. FIND - Line 1154
    Code: Select all
    
    			'PAGINATION' => generate_pagination("modcp.$phpEx?" . POST_FORUM_URL . "=$forum_id", $forum_topics, $board_config['topics_per_page'], $start),
    


    REPLACE WITH
    Code: Select all
    
    			'PAGINATION' => generate_pagination("modcp.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'], $forum_topics, $board_config['topics_per_page'], $start),
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

Postby Acyd Burn » June 22nd 2003, 11:01 am

  • posting.php
  1. REMOVE - Line 123
    Code: Select all
    
    // Compare sid ... if sids don't match
    // output message ... note that AOL'ers may
    // obtain this error until the session code
    // is modified to change the 6 to 4 in the IP
    // comparison checks ... or if a user takes
    // longer than session time to submit the form
    // both can be easily altered by the admin
    //
    if ( $submit || $refresh )
    {
    	if (!isset($HTTP_POST_VARS['sid']) || $HTTP_POST_VARS['sid'] != $userdata['session_id'])
    	{
    		// I've not added this to the language set at this time ... re-releasing
    		// every single language to include this for the once in a blue moon
    		// time it will be output is just not worthwhile at present.
    		message_die(GENERAL_MESSAGE, 'Invalid_session');
    	}
    }
    
    //
    

  2. FIND - Line 417
    Code: Select all
    
    	$s_hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="' . POST_POST_URL . '" value="' . $post_id . '" />';
    


    REPLACE WITH
    Code: Select all
    
    	$s_hidden_fields = '<input type="hidden" name="' . POST_POST_URL . '" value="' . $post_id . '" />';
    

  3. FIND - Line 515
    Code: Select all
    
    		$message .=  '<br /><br />' . sprintf($lang['Click_view_message'], '<a href="' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id") . '">', '</a>');
    		message_die(GENERAL_MESSAGE, $message);
    	}
    


    AFTER, ADD
    Code: Select all
    
    	else
    	{
    		redirect(append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id", true));
    	}
    

  4. FIND - Line 913
    Code: Select all
    
    $hidden_form_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="mode" value="' . $mode . '" />';
    


    REPLACE WITH
    Code: Select all
    
    $hidden_form_fields = '<input type="hidden" name="mode" value="' . $mode . '" />';
    

  5. FIND - Line 1065
    Code: Select all
    
    	if( $mode == 'editpost' && $post_data['edit_poll'] )
    


    REPLACE WITH
    Code: Select all
    
    	if( $mode == 'editpost' && $post_data['edit_poll'] && $post_data['has_poll'])
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

Postby Acyd Burn » June 22nd 2003, 11:03 am

  • privmsg.php
  1. FIND - Line 38
    Code: Select all
    
    $html_entities_match = array('#&#', '#<#', '#>#');
    


    REPLACE WITH
    Code: Select all
    
    $html_entities_match = array('#&(?!(\#[0-9]+;))#', '#<#', '#>#');
    

  2. FIND - Line 374
    Code: Select all
    
    		'edit' => '<a href="' . $post_urls['edit'] . '" />' . $lang['Edit_pm'] . '</a>'
    


    REPLACE WITH
    Code: Select all
    
    		'edit' => '<a href="' . $post_urls['edit'] . '">' . $lang['Edit_pm'] . '</a>'
    

  3. FIND - Line 440
    Code: Select all
    
    	$s_hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="mark[]" value="' . $privmsgs_id . '" />';
    


    REPLACE WITH
    Code: Select all
    
    	$s_hidden_fields = '<input type="hidden" name="mark[]" value="' . $privmsgs_id . '" />';
    

  4. REMOVE - Line 667
    Code: Select all
    
    	// session id check
    	if ($sid == '' || $sid != $userdata['session_id'])
    	{
    		message_die(GENERAL_ERROR, 'Invalid_session');
    	}
    
    

  5. FIND - Line 675
    Code: Select all
    
    		$s_hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="mode" value="' . $mode . '" />';
    


    REPLACE WITH
    Code: Select all
    
    		$s_hidden_fields = '<input type="hidden" name="mode" value="' . $mode . '" />';
    

  6. REMOVE - Line 894
    Code: Select all
    
    	// session id check
    	if ($sid == '' || $sid != $userdata['session_id'])
    	{
    		message_die(GENERAL_ERROR, 'Invalid_session');
    	}
    	
    

  7. FIND - Line 1070
    Code: Select all
    
    		redirect("privmsg.$phpEx?folder=savebox");
    


    REPLACE WITH
    Code: Select all
    
    		redirect(append_sid("privmsg.$phpEx?folder=savebox", true));
    

  8. REMOVE - Line 1141
    Code: Select all
    
    		// session id check
    		if ($sid == '' || $sid != $userdata['session_id'])
    		{
    			message_die(GENERAL_ERROR, 'Invalid_session');
    		}
    
    

  9. REMOVE - Line 1303
    Code: Select all
    
    				$email_headers = 'From: ' . $board_config['board_email'] . "\nReturn-Path: " . $board_config['board_email'] . "\n";
    
    

  10. FIND - Line 1312
    Code: Select all
    
    				$emailer->use_template('privmsg_notify', $to_userdata['user_lang']);
    				$emailer->extra_headers($email_headers);
    


    REPLACE WITH
    Code: Select all
    
    				$emailer->from($board_config['board_email']);
    				$emailer->replyto($board_config['board_email']);
    
    				$emailer->use_template('privmsg_notify', $to_userdata['user_lang']);
    

  11. FIND - Line 1458
    Code: Select all
    
    			$user_sig = (  $board_config['allow_sig'] ) ? $privmsg['user_sig'] : '';
    


    REPLACE WITH
    Code: Select all
    
    			$user_sig = ( $board_config['allow_sig'] ) ? (($privmsg['privmsgs_type'] == PRIVMSGS_NEW_MAIL) ? $user_sig : $privmsg['user_sig']) : '';
    

  12. FIND - Line 1579
    Code: Select all
    
    		$s_hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="folder" value="' . $folder . '" />';
    


    REPLACE WITH
    Code: Select all
    
    		$s_hidden_fields = '<input type="hidden" name="folder" value="' . $folder . '" />';
    

  13. FIND - Line 1701
    Code: Select all
    
    	$s_hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="folder" value="' . $folder . '" />';
    


    REPLACE WITH
    Code: Select all
    
    	$s_hidden_fields = '<input type="hidden" name="folder" value="' . $folder . '" />';
    

  14. FIND - Line 1713
    Code: Select all
    
    	$template->assign_vars(array(
    		'SUBJECT' => preg_replace($html_entities_match, $html_entities_replace, $privmsg_subject), 
    


    REPLACE WITH
    Code: Select all
    
    	$privmsg_subject = preg_replace($html_entities_match, $html_entities_replace, $privmsg_subject);
    	$privmsg_subject = str_replace('"', '"', $privmsg_subject);
    
    	$template->assign_vars(array(
    		'SUBJECT' => $privmsg_subject, 
    

  15. FIND - Line 2070
    Code: Select all
    
    	'S_HIDDEN_FIELDS' => '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" />',
    


    REPLACE WITH
    Code: Select all
    
    	'S_HIDDEN_FIELDS' => '',
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

Postby Acyd Burn » June 22nd 2003, 11:03 am

  • profile.php
  1. FIND - Line 118
    Code: Select all
    
    else
    {
    	redirect(append_sid("index.$phpEx", true));
    }
    


    REPLACE WITH
    Code: Select all
    
    
    redirect(append_sid("index.$phpEx", true));
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

Postby Acyd Burn » June 22nd 2003, 11:04 am

  • search.php
  1. FIND - Line 149
    Code: Select all
    
    	$store_vars = array('search_results', 'total_match_count', 'split_search', 'sort_by', 'sort_dir', 'show_results', 'return_chars');
    
    	//
    


    AFTER, ADD
    Code: Select all
    
    	// Search ID Limiter, decrease this value if you experience further timeout problems with searching forums
    	$limiter = 5000;
    
    	//
    

  2. FIND - Line 182
    Code: Select all
    
    						WHERE poster_id = " . $userdata['user_id'];;
    


    REPLACE WITH
    Code: Select all
    
    						WHERE poster_id = " . $userdata['user_id'];
    

  3. FIND - Line 222
    Code: Select all
    
    				$sql = "SELECT post_id 
    					FROM " . POSTS_TABLE . " 
    					WHERE poster_id IN ($matching_userids)";
    


    AFTER, ADD
    Code: Select all
    
    				
    				if ($search_time)
    				{
    					$sql .= " AND post_time >= " . $search_time;
    				}
    

  4. FIND - Line 412
    Code: Select all
    
    		{
    			if ( $show_results == 'topics' )
    			{
    


    AFTER, ADD
    Code: Select all
    
    				//
    				// This one is a beast, try to seperate it a bit (workaround for connection timeouts)
    				//
    				$search_id_chunks = array();
    				$count = 0;
    				$chunk = 0;
    
    				if (count($search_ids) > $limiter)
    				{
    					for ($i = 0; $i < count($search_ids); $i++) 
    					{
    						if ($count == $limiter)
    						{
    							$chunk++;
    							$count = 0;
    						}
    					
    						$search_id_chunks[$chunk][$count] = $search_ids[$i];
    						$count++;
    					}
    				}
    				else
    				{
    					$search_id_chunks[0] = $search_ids;
    				}
    
    				$search_ids = array();
    
    				for ($i = 0; $i < count($search_id_chunks); $i++)
    				{
    

  5. FIND - Line 453
    Code: Select all
    
    						WHERE post_id IN (" . implode(", ", $search_ids) . ") 
    


    REPLACE WITH
    Code: Select all
    
    							WHERE post_id IN (" . implode(", ", $search_id_chunks[$i]) . ") 
    

  6. FIND - Line 475
    Code: Select all
    
    						WHERE p.post_id IN (" . implode(", ", $search_ids) . ") 
    


    REPLACE WITH
    Code: Select all
    
    							WHERE p.post_id IN (" . implode(", ", $search_id_chunks[$i]) . ") 
    

  7. FIND - Line 485
    Code: Select all
    
    				$search_ids = array();
    				while( $row = $db->sql_fetchrow($result) )
    				{
    					$search_ids[] = $row['topic_id'];
    				}
    				$db->sql_freeresult($result);
    
    				$total_match_count = sizeof($search_ids);
    		
    			}
    			else if ( $search_author != '' || $search_time || $auth_sql != '' )
    			{
    				$where_sql = ( $search_author == '' && $auth_sql == '' ) ? 'post_id IN (' . implode(', ', $search_ids) . ')' : 'p.post_id IN (' . implode(', ', $search_ids) . ')';
    


    REPLACE WITH
    Code: Select all
    
    					while ($row = $db->sql_fetchrow($result))
    					{
    						$search_ids[] = $row['topic_id'];
    					}
    					$db->sql_freeresult($result);
    				}
    
    				$total_match_count = sizeof($search_ids);
    		
    			}
    			else if ( $search_author != '' || $search_time || $auth_sql != '' )
    			{
    				$search_id_chunks = array();
    				$count = 0;
    				$chunk = 0;
    
    				if (count($search_ids) > $limiter)
    				{
    					for ($i = 0; $i < count($search_ids); $i++) 
    					{
    						if ($count == $limiter)
    						{
    							$chunk++;
    							$count = 0;
    						}
    					
    						$search_id_chunks[$chunk][$count] = $search_ids[$i];
    						$count++;
    					}
    				}
    				else
    				{
    					$search_id_chunks[0] = $search_ids;
    				}
    
    				$search_ids = array();
    
    				for ($i = 0; $i < count($search_id_chunks); $i++)
    				{
    					$where_sql = ( $search_author == '' && $auth_sql == '' ) ? 'post_id IN (' . implode(', ', $search_id_chunks[$i]) . ')' : 'p.post_id IN (' . implode(', ', $search_id_chunks[$i]) . ')';
    					$select_sql = ( $search_author == '' && $auth_sql == '' ) ? 'post_id' : 'p.post_id';
    

  8. FIND - Line 545
    Code: Select all
    
    				$sql = "SELECT p.post_id 
    


    REPLACE WITH
    Code: Select all
    
    					$sql = "SELECT " . $select_sql . " 
    

  9. REMOVE - Line 553
    Code: Select all
    
    				$search_ids = array();
    

  10. FIND - Line 557
    Code: Select all
    
    
    				$db->sql_freeresult($result);
    


    REPLACE WITH
    Code: Select all
    
    					$db->sql_freeresult($result);
    				}
    

  11. FIND - Line 644
    Code: Select all
    
    		// so we can serialize it and place it in the DB
    		//
    		$store_search_data = array();
    


    AFTER, ADD
    Code: Select all
    
    
    		//
    		// Limit the character length (and with this the results displayed at all following pages) to prevent
    		// truncated result arrays. Normally, search results above 12000 are affected.
    		// - to include or not to include
    		/*
    		$max_result_length = 60000;
    		if (strlen($search_results) > $max_result_length)
    		{
    			$search_results = substr($search_results, 0, $max_result_length);
    			$search_results = substr($search_results, 0, strrpos($search_results, ','));
    			$total_match_count = count(explode(', ', $search_results));
    		}
    		*/
    
    

  12. FIND - Line 671
    Code: Select all
    
    			SET search_id = $search_id, search_array = '$result_array'
    


    REPLACE WITH
    Code: Select all
    
    			SET search_id = $search_id, search_array = '" . str_replace("\'", "''", $result_array) . "'
    

User avatar
Acyd Burn
Consultant
 
Posts: 650
Joined: April 19th 2002, 7:00 pm
Location: Germany (Oldb)

PreviousNext

Return to phpBB 2: Fixes and Code Changes

Who is online

Users browsing this forum: No registered users and 4 guests