Info Mauritius        
Urlaub Info Mauritius
   
Webcam Mauritius
 
Mauritius Wetter
  Mauritius Forum  
Mauritius Bilder
 
Mauritius Unterkunft
   
Mauritius English Home
   

 

 
               

neues forum update

Alles über Forum Treffen, Abmeldungen in den Urlaub, Grüße aus dem Urlaub, wer fliegt wann...
Danksagungen und natürlich Kritiken.
Forumsregeln

neues forum update

Beitragvon stefan » Fr Nov 04, 2005 0:34

habe eben ein neues forum update eingespielt, damit ihr mal seht wie sowas aussieht hier die installations datei:

[code]
#################################################################
## MOD Title: phpBB 2.0.17 to phpBB 2.0.18 Code Changes
## MOD Author: markus_petrux < N/A > (Markus) N/A
## MOD Description: These are the Changes from phpBB 2.0.17 to phpBB 2.0.18 summed up into a little
## Mod. This might be very helpful if you want to update your Board and have installed a bunch
## of Mods. Then it's normally easier to apply the Code Changes than to install all Mods again.
##
## MOD Version: 1.0.1
##
## Installation Level: Advanced
## Installation Time: 2 Hours
## Files To Edit:
## common.php
## groupcp.php
## index.php
## login.php
## memberlist.php
## modcp.php
## posting.php
## privmsg.php
## search.php
## viewtopic.php
## admin/admin_board.php
## admin/admin_disallow.php
## admin/admin_smilies.php
## admin/admin_styles.php
## admin/admin_ug_auth.php
## admin/admin_user_ban.php
## admin/admin_users.php
## admin/index.php
## admin/page_footer_admin.php
## db/mysql.php
## db/mysql4.php
## includes/bbcode.php
## includes/constants.php
## includes/db.php
## includes/emailer.php
## includes/functions.php
## includes/functions_admin.php
## includes/functions_post.php
## includes/functions_search.php
## includes/functions_validate.php
## includes/page_header.php
## includes/page_tail.php
## includes/sessions.php
## includes/smtp.php
## includes/usercp_activate.php
## includes/usercp_avatar.php
## includes/usercp_register.php
## includes/usercp_sendpasswd.php
## includes/usercp_viewprofile.php
## language/lang_english/lang_admin.php
## language/lang_english/lang_main.php
## language/lang_english/email/topic_notify.tpl
## templates/subSilver/bbcode.tpl
## templates/subSilver/groupcp_info_body.tpl
## templates/subSilver/index_body.tpl
## templates/subSilver/login_body.tpl
## templates/subSilver/overall_header.tpl
## templates/subSilver/profile_add_body.tpl
## templates/subSilver/search_body.tpl
## templates/subSilver/search_results_posts.tpl
## templates/subSilver/subSilver.cfg
## templates/subSilver/admin/board_config_body.tpl
## templates/subSilver/admin/forum_admin_body.tpl
## templates/subSilver/admin/index_frameset.tpl
## templates/subSilver/admin/page_header.tpl
## templates/subSilver/admin/styles_addnew_body.tpl
## templates/subSilver/admin/styles_edit_body.tpl
## templates/subSilver/admin/styles_list_body.tpl
## templates/subSilver/admin/user_edit_body.tpl
##
## Included Files: install/update_to_latest.php
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
##############################################################
## Author Notes:
##
## Since this MOD is somehow complex, it is recommended to proceed as follows:
##
## 1) Disable the board from the ACP (General Admin, Configuration).
##
## 2) Make backups of your files and Database.
##
## 3) Upload and execute the file install/update_to_latest.php.
##
## 4) Remove the file install/update_to_latest.php from your webspace.
##
## 4) Install the MOD.
##
## 5) Enable the board from the ACP, back online.
##
##
## It is recommended to use EasyMOD to install this MOD ;-)
##
## Please, be sure to understand the MOD Templace actions.
## http://www.phpbb.com/kb/article.php?article_id=39
##
##
##############################################################
## MOD History:
##
## 2005-10-31 - Version 1.0.1
## - adjusted for the repackage
##
## 2005-10-30 - Version 1.0.0
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ DIY INSTRUCTIONS ]---------------------------------------------
#
BEFORE installing this MOD, you have to upload the file
install/update_to_latest.php, execute it and then delete it
from your webspace.

It will execute the following SQL statements:

CREATE TABLE phpbb_sessions_keys (
key_id varchar(32) DEFAULT '0' NOT NULL,
user_id mediumint(8) DEFAULT '0' NOT NULL,
last_ip varchar(8) DEFAULT '0' NOT NULL,
last_login int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (key_id, user_id),
KEY last_login (last_login)
);

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');

UPDATE phpbb_users SET user_active = 0 WHERE user_id = -1;
UPDATE phpbb_config SET config_value = '.0.18' WHERE config_name = 'version';
#
#-----[ OPEN ]---------------------------------------------
#
common.php

#
#-----[ FIND ]---------------------------------------------
#
// The following code (unsetting globals) was contributed by Matt Kavanagh

#
#-----[ REPLACE WITH ]---------------------------------------------
#
// The following code (unsetting globals)
// Thanks to Matt Kavanagh and Stefan Esser for providing feedback as well as patch files

#
#-----[ FIND ]---------------------------------------------
#
// PHP5 with register_long_arrays off?
if (!isset($HTTP_POST_VARS) && isset($_POST))
{
$HTTP_POST_VARS = $_POST;
$HTTP_GET_VARS = $_GET;
$HTTP_SERVER_VARS = $_SERVER;
$HTTP_COOKIE_VARS = $_COOKIE;
$HTTP_ENV_VARS = $_ENV;
$HTTP_POST_FILES = $_FILES;

// _SESSION is the only superglobal which is conditionally set
if (isset($_SESSION))
{
$HTTP_SESSION_VARS = $_SESSION;
}
}

#
#-----[ REPLACE WITH ]---------------------------------------------
#
// PHP5 with register_long_arrays off?
if (@phpversion() >= '5.0.0' && (!@ini_get('register_long_arrays') || @ini_get('register_long_arrays') == '0' || strtolower(@ini_get('register_long_arrays')) == 'off'))
{
$HTTP_POST_VARS = $_POST;
$HTTP_GET_VARS = $_GET;
$HTTP_SERVER_VARS = $_SERVER;
$HTTP_COOKIE_VARS = $_COOKIE;
$HTTP_ENV_VARS = $_ENV;
$HTTP_POST_FILES = $_FILES;

// _SESSION is the only superglobal which is conditionally set
if (isset($_SESSION))
{
$HTTP_SESSION_VARS = $_SESSION;
}
}

// Protect against GLOBALS tricks
if (isset($HTTP_POST_VARS['GLOBALS']) || isset($HTTP_POST_FILES['GLOBALS']) || isset($HTTP_GET_VARS['GLOBALS']) || isset($HTTP_COOKIE_VARS['GLOBALS']))
{
die("Hacking attempt");
}

// Protect against HTTP_SESSION_VARS tricks
if (isset($HTTP_SESSION_VARS) && !is_array($HTTP_SESSION_VARS))
{
die("Hacking attempt");
}

#
#-----[ FIND ]---------------------------------------------
#
if (@phpversion() < '4.0.0')
{
// PHP3 path; in PHP3, globals are _always_ registered

// We 'flip' the array of variables to test like this so that
// we can validate later with isset($test[$var]) (no in_array())
$test = array('HTTP_GET_VARS' => NULL, 'HTTP_POST_VARS' => NULL, 'HTTP_COOKIE_VARS' => NULL, 'HTTP_SERVER_VARS' => NULL, 'HTTP_ENV_VARS' => NULL, 'HTTP_POST_FILES' => NULL, 'phpEx' => NULL, 'phpbb_root_path' => NULL);

// Loop through each input array
@reset($test);
while (list($input,) = @each($test))
{
while (list($var,) = @each($$input))
{
// Validate the variable to be unset
if (!isset($test[$var]) && $var != 'test' && $var != 'input')
{
unset($$var);
}
}
}
}
else if (@ini_get('register_globals') == '1' || strtolower(@ini_get('register_globals')) == 'on')
{

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if (@ini_get('register_globals') == '1' || strtolower(@ini_get('register_globals')) == 'on')
{

#
#-----[ FIND ]---------------------------------------------
#
if (!isset($HTTP_SESSION_VARS))
{
$HTTP_SESSION_VARS = array();
}

// Merge all into one extremely huge array; unset
// this later
$input = array_merge($HTTP_GET_VARS, $HTTP_POST_VARS, $HTTP_COOKIE_VARS, $HTTP_SERVER_VARS, $HTTP_SESSION_VARS, $HTTP_ENV_VARS, $HTTP_POST_FILES);

unset($input['input']);
unset($input['not_unset']);

while (list($var,) = @each($input))
{
if (!in_array($var, $not_unset))
{
unset($$var);
}
}

unset($input);
}

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if (!isset($HTTP_SESSION_VARS) || !is_array($HTTP_SESSION_VARS))
{
$HTTP_SESSION_VARS = array();
}

// Merge all into one extremely huge array; unset
// this later
$input = array_merge($HTTP_GET_VARS, $HTTP_POST_VARS, $HTTP_COOKIE_VARS, $HTTP_SERVER_VARS, $HTTP_SESSION_VARS, $HTTP_ENV_VARS, $HTTP_POST_FILES);

unset($input['input']);
unset($input['not_unset']);

while (list($var,) = @each($input))
{
if (!in_array($var, $not_unset))
{
unset($$var);
}
}

unset($input);
}

#
#-----[ FIND ]---------------------------------------------
#
header("Location: install/install.$phpEx");

#
#-----[ REPLACE WITH ]---------------------------------------------
#
header('Location: ' . $phpbb_root_path . 'install/install.' . $phpEx);

#
#-----[ FIND ]---------------------------------------------
#
include($phpbb_root_path . 'includes/db.'.$phpEx);

#
#-----[ AFTER, ADD ]---------------------------------------------
#

// We do not need this any longer, unset for safety purposes
unset($dbpasswd);

#
#-----[ OPEN ]---------------------------------------------
#
groupcp.php

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $temp_url = append_sid("search.$phpEx?search_author=" . urlencode($username) . "&amp;showresults=posts");
#
$temp_url = append_sid("search

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
$username

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
$row['username']

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $search_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_search'] . '" alt="' . $lang['Search_user_posts'] . '" title="' . $lang['Search_user_posts'] . '" border="0" /></a>';
#
$search_img = '<a href="'

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
. $lang['Search_user_posts']

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
. sprintf($lang['Search_user_posts'], $row['username'])

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
. $lang['Search_user_posts']

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
. sprintf($lang['Search_user_posts'], $row['username'])

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $search = '<a href="' . $temp_url . '">' . $lang['Search_user_posts'] . '</a>';
#
$search = '<a href="'

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
. $lang['Search_user_posts']

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
. sprintf($lang['Search_user_posts'], $row['username'])

#
#-----[ FIND ]---------------------------------------------
#
//
// Load and process templates
//

#
#-----[ AFTER, ADD ]---------------------------------------------
#
$page_title = $lang['Group_Control_Panel'];

#
#-----[ OPEN ]---------------------------------------------
#
index.php

#
#-----[ FIND ]---------------------------------------------
# NOTE --- There's no explicit action to take place here. This FIND is just aimed to point you to the right place the next action.
#
//
// Obtain a list of topic ids which contain
// posts made since user last visited
//

#
#-----[ FIND ]---------------------------------------------
#
if ( $userdata['session_logged_in'] )
{

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if ($userdata['session_logged_in'])
{
// 60 days limit
if ($userdata['user_lastvisit'] < (time() - 5184000))
{
$userdata['user_lastvisit'] = time() - 5184000;
}


#
#-----[ OPEN ]---------------------------------------------
#
login.php

#
#-----[ FIND ]---------------------------------------------
#
else if( ( isset($HTTP_GET_VARS['logout']) || isset($HTTP_POST_VARS['logout']) ) && $userdata['session_logged_in'] )
{

#
#-----[ AFTER, ADD ]---------------------------------------------
#
// session id check
if ($sid == '' || $sid != $userdata['session_id'])
{
message_die(GENERAL_ERROR, 'Invalid_session');
}


#
#-----[ FIND ]---------------------------------------------
#
if( isset($HTTP_POST_VARS['redirect']) || isset($HTTP_GET_VARS['redirect']) )

#
#-----[ BEFORE, ADD ]---------------------------------------------
#
$forward_page = '';


#
#-----[ FIND ]---------------------------------------------
#
if(count($forward_match) > 1)
{
$forward_page = '';

for($i = 1; $i < count($forward_match); $i++)

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if(count($forward_match) > 1)
{
for($i = 1; $i < count($forward_match); $i++)

#
#-----[ FIND ]---------------------------------------------
#
}
else
{
$forward_page = '';
}

#
#-----[ REPLACE WITH ]---------------------------------------------
#
}

#
#-----[ FIND ]---------------------------------------------
#
make_jumpbox('viewforum.'.$phpEx, $forum_id);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
make_jumpbox('viewforum.'.$phpEx);

#
#-----[ OPEN ]---------------------------------------------
#
memberlist.php

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $mode_types = array('joindate', 'username', 'location', 'posts', 'email', 'website', 'topten');
#
$mode_types = array('joindate',

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
'joindate'

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
'joined'

#
#-----[ OPEN ]---------------------------------------------
#
modcp.php

#
#-----[ FIND ]---------------------------------------------
#
message_die(MESSAGE, sprintf($lang['Sorry_auth_delete'], $is_auth['auth_delete_type']));

#
#-----[ REPLACE WITH ]---------------------------------------------
#
message_die(GENERAL_MESSAGE, sprintf($lang['Sorry_auth_delete'], $is_auth['auth_delete_type']));

#
#-----[ FIND ]---------------------------------------------
#
'U_SEARCHPOSTS' => append_sid("search.$phpEx?search_author=" . urlencode($username) . "&amp;showresults=topics"))

#
#-----[ REPLACE WITH ]---------------------------------------------
#
'U_SEARCHPOSTS' => append_sid("search.$phpEx?search_author=" . (($id == ANONYMOUS) ? 'Anonymous' : urlencode($username)) . "&amp;showresults=topics"))

#
#-----[ OPEN ]---------------------------------------------
#
posting.php

#
#-----[ FIND ]---------------------------------------------
#
$refresh = $preview ||

#
#-----[ AFTER, ADD ]---------------------------------------------
#
$orig_word = $replacement_word = array();

#
#-----[ FIND ]---------------------------------------------
#
$topic_type = ( !empty($HTTP_POST_VARS['topictype']) ) ? intval($HTTP_POST_VARS['topictype']) : POST_NORMAL;

#
#-----[ AFTER, ADD ]---------------------------------------------
#
$topic_type = ( in_array($topic_type, array(POST_NORMAL, POST_STICKY, POST_ANNOUNCE)) ) ? $topic_type : POST_NORMAL;

#
#-----[ FIND ]---------------------------------------------
#
$sql = "SELECT f.*, t.topic_status, t.topic_title

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
t.topic_title

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------------
#
, t.topic_type

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $select_sql = ( !$submit ) ? ", t.topic_title, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig" : '';
#
$select_sql = ( !$submit ) ? "

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
( !$submit ) ? "

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
(!$submit) ? '

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
, u.user_sig

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------------
#
, u.user_sig_bbcode_uid

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
"

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
'

#
#-----[ FIND ]---------------------------------------------
#
if ( $mode == 'quote' )
{
$topic_id = $post_info['topic_id'];
}

#
#-----[ AFTER, ADD ]---------------------------------------------
#
if ( $mode == 'newtopic' )
{
$post_data['topic_type'] = POST_NORMAL;
}

#
#-----[ FIND ]---------------------------------------------
#
$post_data['edit_poll'] = false;
}

#
#-----[ AFTER, ADD ]---------------------------------------------
#
if ( $mode == 'poll_delete' && !isset($poll_id) )
{
message_die(GENERAL_MESSAGE, $lang['No_such_post']);
}

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $user_sig = ( $post_info['user_sig'] != '' && $board_config['allow_sig'] ) ? $post_info['user_sig'] : '';
#
$user_sig = ( $post_info['user_sig'] != ''

#
#-----[ AFTER, ADD ]---------------------------------------------
#
$userdata['user_sig_bbcode_uid'] = $post_info['user_sig_bbcode_uid'];

#
#-----[ OPEN ]---------------------------------------------
#
privmsg.php

#
#-----[ FIND ]---------------------------------------------
#
if ( $sent_info['sent_items'] >= $board_config['max_sentbox_privmsgs'] )

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if ($board_config['max_sentbox_privmsgs'] && $sent_info['sent_items'] >= $board_config['max_sentbox_privmsgs'])

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $search_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_search'] . '" alt="' . $lang['Search_user_posts'] . '" title="' . $lang['Search_user_posts'] . '" border="0" /></a>';
#
$search_img = '<a href="'

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
. $lang['Search_user_posts']

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
. sprintf($lang['Search_user_posts'], $username_from)

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
. $lang['Search_user_posts']

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
. sprintf($lang['Search_user_posts'], $username_from)

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $search = '<a href="' . $temp_url . '">' . $lang['Search_user_posts'] . '</a>';
#
$search = '<a href="'

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
. $lang['Search_user_posts']

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
. sprintf($lang['Search_user_posts'], $username_from)

#
#-----[ FIND ]---------------------------------------------
#
if ( $saved_info['savebox_items'] >= $board_config['max_savebox_privmsgs'] )

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if ($board_config['max_savebox_privmsgs'] && $saved_info['savebox_items'] >= $board_config['max_savebox_privmsgs'] )

#
#-----[ FIND ]---------------------------------------------
#
if ( $submit )

#
#-----[ BEFORE, ADD ]---------------------------------------------
#
if ($submit && $mode == 'edit')
{
$sql = 'SELECT privmsgs_from_userid
FROM ' . PRIVMSGS_TABLE . '
WHERE privmsgs_id = ' . (int) $privmsg_id . '
AND privmsgs_from_userid = ' . $userdata['user_id'];

if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, "Could not obtain message details", "", __LINE__, __FILE__, $sql);
}

if (!($row = $db->sql_fetchrow($result)))
{
message_die(GENERAL_MESSAGE, $lang['No_such_post']);
}
$db->sql_freeresult($result);

unset($row);
}


#
#-----[ FIND ]---------------------------------------------
#
$to_userdata = $db->sql_fetchrow($result);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if (!($to_userdata = $db->sql_fetchrow($result)))
{
$error = TRUE;
$error_msg = $lang['No_such_user'];
}

#
#-----[ FIND ]---------------------------------------------
#
if ( $inbox_info['inbox_items'] >= $board_config['max_inbox_privmsgs'] )

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if ($board_config['max_inbox_privmsgs'] && $inbox_info['inbox_items'] >= $board_config['max_inbox_privmsgs'])

#
#-----[ FIND ]---------------------------------------------
#
'USERNAME' => $to_username,

#
#-----[ REPLACE WITH ]---------------------------------------------
#
'USERNAME' => stripslashes($to_username),

#
#-----[ FIND ]---------------------------------------------
#
if ( !empty($HTTP_GET_VARS[POST_USERS_URL]) )

#
#-----[ FIND ]---------------------------------------------
#
}

if ( $mode == 'edit' )

#
#-----[ REPLACE WITH ]---------------------------------------------
#
}
else if ( $mode == 'edit' )

#
#-----[ FIND ]---------------------------------------------
#
$privmsg_subject = $privmsg_message = '';

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$privmsg_subject = $privmsg_message = $to_username = '';

#
#-----[ FIND ]---------------------------------------------
#
'S_SIGNATURE_CHECKED' => ( $attach_sig ) ? ' checked="checked"' : '',
'S_NAMES_SELECT' => $user_names_select,

#
#-----[ REPLACE WITH ]---------------------------------------------
#
'S_SIGNATURE_CHECKED' => ( $attach_sig ) ? ' checked="checked"' : '',

#
#-----[ OPEN ]---------------------------------------------
#
search.php

#
#-----[ FIND ]---------------------------------------------
#
$split_search = ( !strstr($multibyte_charset, $lang['ENCODING']) ) ? split_words(clean_words('search', stripslashes($search_keywords), $stopword_array, $synonym_array), 'search') : split(' ', $search_keywords);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$stripped_keywords = stripslashes($search_keywords);
$split_search = ( !strstr($multibyte_charset, $lang['ENCODING']) ) ? split_words(clean_words('search', $stripped_keywords, $stopword_array, $synonym_array), 'search') : split(' ', $search_keywords);
unset($stripped_keywords);

#
#-----[ FIND ]---------------------------------------------
#
ORDER BY c.cat_id, f.forum_order";

#
#-----[ REPLACE WITH ]---------------------------------------------
#
ORDER BY c.cat_order, f.forum_order";

#
#-----[ OPEN ]---------------------------------------------
#
viewtopic.php

#
#-----[ FIND ]---------------------------------------------
#
if ( !isset($topic_id) && !isset($post_id) )

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if (!$topic_id && !$post_id)

#
#-----[ FIND ]---------------------------------------------
#
AND t.topic_last_post_id $sql_condition t2.topic_last_post_id

#
#-----[ BEFORE, ADD ]---------------------------------------------
#
AND t.topic_moved_id = 0

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $join_sql_table = ( empty($post_id) ) ? '' : ", " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2 ";
#
$join_sql_table = ( empty($post_id) )

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
( empty($post_id) )

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
(!$post_id)

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $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";
#
$join_sql = ( empty($post_id) )

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
( empty($post_id) )

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
(!$post_id)

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $count_sql = ( empty($post_id) ) ? '' : ", COUNT(p2.post_id) AS prev_posts";
#
$count_sql = ( empty($post_id) )

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
( empty($post_id) )

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
(!$post_id)

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $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";
#
$order_sql = ( empty($post_id) )

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
( empty($post_id) )

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
(!$post_id)


#
#-----[ FIND ]---------------------------------------------
#
$redirect = ( isset($post_id) ) ? POST_POST_URL . "=$post_id" : POST_TOPIC_URL . "=$topic_id";
$redirect .= ( isset($start) ) ? "&start=$start" : '';

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$redirect = ($post_id) ? POST_POST_URL . "=$post_id" : POST_TOPIC_URL . "=$topic_id";
$redirect .= ($start) ? "&start=$start" : '';

#
#-----[ FIND ]---------------------------------------------
#
if ( !empty($post_id) )

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if ($post_id)

#
#-----[ FIND ]---------------------------------------------
#
$highlight_match .= (($highlight_match != '') ? '|' : '') . str_replace('*', '\w*', phpbb_preg_quote($words[$i], '#'));

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$highlight_match .= (($highlight_match != '') ? '|' : '') . str_replace('*', '\w*', preg_quote($words[$i], '#'));

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $search_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_search'] . '" alt="' . $lang['Search_user_posts'] . '" title="' . sprintf($lang['Search_user_posts'], $postrow[$i]['username']) . '" border="0" /></a>';
#
$search_img = '<a href="'

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
. $lang['Search_user_posts']

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
. sprintf($lang['Search_user_posts'], $postrow[$i]['username'])

#
#-----[ FIND ]---------------------------------------------
#
if ( $board_config['allow_bbcode'] )
{
if ( $user_sig != '' && $user_sig_bbcode_uid != '' )
{

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if ($user_sig != '' && $user_sig_bbcode_uid != '')
{

#
#-----[ FIND ]---------------------------------------------
#
$user_sig = ( $board_config['allow_bbcode'] ) ? bbencode_second_pass($user_sig, $user_sig_bbcode_uid) : preg_replace('/\:[0-9a-z\:]+\]/si', ']', $user_sig);
}

if ( $bbcode_uid != '' )
{
$message = ( $board_config['allow_bbcode'] ) ? bbencode_second_pass($message, $bbcode_uid) : preg_replace('/\:[0-9a-z\:]+\]/si', ']', $message);
}
}

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$user_sig = ($board_config['allow_bbcode']) ? bbencode_second_pass($user_sig, $user_sig_bbcode_uid) : preg_replace("/\:$user_sig_bbcode_uid/si", '', $user_sig);
}

if ($bbcode_uid != '')
{
$message = ($board_config['allow_bbcode']) ? bbencode_second_pass($message, $bbcode_uid) : preg_replace("/\:$bbcode_uid/si", '', $message);
}

#
#-----[ OPEN ]---------------------------------------------
#
admin/admin_board.php

#
#-----[ FIND ]---------------------------------------------
#
$board_email_form_yes = ( $new['board_email_form'] ) ? "checked=\"checked\"" : "";

#
#-----[ BEFORE, ADD ]---------------------------------------------
#
$allow_autologin_yes = ($new['allow_autologin']) ? 'checked="checked"' : '';
$allow_autologin_no = (!$new['allow_autologin']) ? 'checked="checked"' : '';


#
#-----[ FIND ]---------------------------------------------
#
"L_VISUAL_CONFIRM_EXPLAIN" => $lang['Visual_confirm_explain'],

#
#-----[ AFTER, ADD ]---------------------------------------------
#
"L_ALLOW_AUTOLOGIN" => $lang['Allow_autologin'],
"L_ALLOW_AUTOLOGIN_EXPLAIN" => $lang['Allow_autologin_explain'],
"L_AUTOLOGIN_TIME" => $lang['Autologin_time'],
"L_AUTOLOGIN_TIME_EXPLAIN" => $lang['Autologin_time_explain'],

#
#-----[ FIND ]---------------------------------------------
#
"CONFIRM_DISABLE" => $confirm_no,

#
#-----[ FIND ]---------------------------------------------
#
"ACTIVATION_NONE_CHECKED" => $activation_none,

#
#-----[ REPLACE WITH ]---------------------------------------------
#
'ALLOW_AUTOLOGIN_YES' => $allow_autologin_yes,
'ALLOW_AUTOLOGIN_NO' => $allow_autologin_no,
'AUTOLOGIN_TIME' => (int) $new['max_autologin_time'],

#
#-----[ OPEN ]---------------------------------------------
#
admin/admin_disallow.php

#
#-----[ FIND ]---------------------------------------------
#
message_die(MESSAGE, $lang['Fields_empty']);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
message_die(GENERAL_MESSAGE, $lang['Fields_empty']);

#
#-----[ OPEN ]---------------------------------------------
#
admin/admin_smilies.php

#
#-----[ FIND ]---------------------------------------------
#
$smile_url = ( isset($HTTP_POST_VARS['smile_url']) ) ? trim($HTTP_POST_VARS['smile_url']) : trim($HTTP_GET_VARS['smile_url']);

#
#-----[ AFTER, ADD ]---------------------------------------------
#
$smile_url = phpbb_ltrim(basename($smile_url), "'");

#
#-----[ FIND ]---------------------------------------------
#
message_die(MESSAGE, $lang['Fields_empty']);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
message_die(GENERAL_MESSAGE, $lang['Fields_empty']);

#
#-----[ FIND ]---------------------------------------------
#
$smile_url = ( isset($HTTP_POST_VARS['smile_url']) ) ? $HTTP_POST_VARS['smile_url'] : $HTTP_GET_VARS['smile_url'];

#
#-----[ AFTER, ADD ]---------------------------------------------
#
$smile_url = phpbb_ltrim(basename($smile_url), "'");

#
#-----[ FIND ]---------------------------------------------
#
message_die(MESSAGE, $lang['Fields_empty']);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
message_die(GENERAL_MESSAGE, $lang['Fields_empty']);

#
#-----[ OPEN ]---------------------------------------------
#
admin/admin_styles.php

#
#-----[ FIND ]---------------------------------------------
#
"L_STYLESHEET" => $lang['Stylesheet'],

#
#-----[ AFTER, ADD ]---------------------------------------------
#
"L_STYLESHEET_EXPLAIN" => $lang['Stylesheet_explain'],

#
#-----[ OPEN ]---------------------------------------------
#
admin/admin_ug_auth.php

#
#-----[ FIND ]---------------------------------------------
#
$sql = "SELECT *
FROM " . FORUMS_TABLE . " f
ORDER BY forum_order";

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$sql = 'SELECT f.*
FROM ' . FORUMS_TABLE . ' f, ' . CATEGORIES_TABLE . ' c
WHERE f.cat_id = c.cat_id
ORDER BY c.cat_order, f.forum_order';

#
#-----[ FIND ]---------------------------------------------
#
if( count($name) )
{
$t_usergroup_list = $t_pending_list = '';

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$t_usergroup_list = $t_pending_list = '';
if( count($name) )
{

#
#-----[ FIND ]---------------------------------------------
#
else
{
$t_usergroup_list = $lang['None'];
}

#
#-----[ REPLACE WITH ]---------------------------------------------
#

$t_usergroup_list = ($t_usergroup_list == '') ? $lang['None'] : $t_usergroup_list;
$t_pending_list = ($t_pending_list == '') ? $lang['None'] : $t_pending_list;

#
#-----[ OPEN ]---------------------------------------------
#
admin/admin_user_ban.php

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# if (preg_match('#^(([a-z0-9&.-_+])|(\*))+@[a-z0-9\-]+\.([a-z0-9\-]+\.)*?[a-z]+$#is', trim($email_list_temp[$i])))
#
'#^(([a-z0-9&.-_+])|(\*))+@[a-z0-9\-]+\.([a-z0-9\-]+\.)*?[a-z]+$#is'

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
'#^(([a-z0-9&.-_+])|(\*))+@[a-z0-9\-]+\.([a-z0-9\-]+\.)*?[a-z]+$#is'

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
'/^(([a-z0-9&\'\.\-_\+])|(\*))+@(([a-z0-9\-])|(\*))+\.([a-z0-9\-]+\.)*?[a-z]+$/is'

#
#-----[ OPEN ]---------------------------------------------
#
admin/admin_users.php

#
#-----[ FIND ]---------------------------------------------
#
if( $HTTP_POST_VARS['deleteuser'] )

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if( $HTTP_POST_VARS['deleteuser'] && ( $userdata['user_id'] != $user_id ) )

#
#-----[ FIND ]---------------------------------------------
#
$user_avatar_local = ( isset( $HTTP_POST_VARS['avatarselect'] ) && !empty($HTTP_POST_VARS['submitavatar'] ) && $board_config['allow_avatar_local'] ) ? $HTTP_POST_VARS['avatarselect'] : ( ( isset( $HTTP_POST_VARS['avatarlocal'] ) ) ? $HTTP_POST_VARS['avatarlocal'] : '' );

#
#-----[ AFTER, ADD ]---------------------------------------------
#
$user_avatar_category = ( isset($HTTP_POST_VARS['avatarcatname']) && $board_config['allow_avatar_local'] ) ? htmlspecialchars($HTTP_POST_VARS['avatarcatname']) : '' ;

#
#-----[ FIND ]---------------------------------------------
#
$user_avatar = $user_avatar_local;

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$user_avatar = $user_avatar_category . '/' . $user_avatar_local;

#
#-----[ FIND ]---------------------------------------------
#
$avatar_sql = ", user_avatar = '" . str_replace("\'", "''", $user_avatar_local) . "', user_avatar_type = " . USER_AVATAR_GALLERY;

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$avatar_sql = ", user_avatar = '" . str_replace("\'", "''", phpbb_ltrim(basename($user_avatar_category), "'") . '/' . phpbb_ltrim(basename($user_avatar_local), "'")) . "', user_avatar_type = " . USER_AVATAR_GALLERY;

#
#-----[ FIND ]---------------------------------------------
#
$avatar_images[$file][$avatar_row_count][$avatar_col_count] = $file . "/" . $sub_file;

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$avatar_images[$file][$avatar_row_count][$avatar_col_count] = $sub_file;

#
#-----[ FIND ]---------------------------------------------
#
"AVATAR_IMAGE" => "../" . $board_config['avatar_gallery_path'] . "/" . $avatar_images[$category][$i][$j])

#
#-----[ REPLACE WITH ]---------------------------------------------
#
"AVATAR_IMAGE" => "../" . $board_config['avatar_gallery_path'] . '/' . $category . '/' . $avatar_images[$category][$i][$j])

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $s_hidden_fields = '<input type="hidden" name="mode" value="edit" /><input type="hidden" name="agreed" value="true" /><input type="hidden" name="coppa" value="' . $coppa . '" />';
#
<input type="hidden" name="mode" value="edit" />

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
<input type="hidden" name="coppa" value="' . $coppa . '" />

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------------
#
<input type="hidden" name="avatarcatname" value="' . $category . '" />

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# $s_hidden_fields .= '<input type="hidden" name="avatarlocal" value="' . $user_avatar_local . '" />';
#
<input type="hidden" name="avatarlocal" value="' . $user_avatar_local . '" />

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
<input type="hidden" name="avatarlocal" value="' . $user_avatar_local . '" />

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------------
#
<input type="hidden" name="avatarcatname" value="' . $user_avatar_category . '" />

#
#-----[ OPEN ]---------------------------------------------
#
admin/index.php

#
#-----[ FIND ]---------------------------------------------
#
if ($fsock = @fsockopen('www.phpbb.com', 80, $errno, $errstr))

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if ($fsock = @fsockopen('www.phpbb.com', 80, $errno, $errstr, 10))

#
#-----[ FIND ]---------------------------------------------
#
$version_info .= '<br />' . sprintf($lang['Latest_version_info'], $latest_version) . sprintf($lang['Current_version_info'], '2' . $board_config['version']) . '</p>';

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$version_info .= '<br />' . sprintf($lang['Latest_version_info'], $latest_version) . ' ' . sprintf($lang['Current_version_info'], '2' . $board_config['version']) . '</p>';

#
#-----[ OPEN ]---------------------------------------------
#
admin/page_footer_admin.php

#
#-----[ FIND ]---------------------------------------------
#
//
// Show the overall footer.
//

#
#-----[ BEFORE, ADD ]---------------------------------------------
#
global $do_gzip_compress;


#
#-----[ FIND ]---------------------------------------------
#
'TRANSLATION_INFO' => $lang['TRANSLATION_INFO'])

#
#-----[ REPLACE WITH ]---------------------------------------------
#
'TRANSLATION_INFO' => (isset($lang['TRANSLATION_INFO'])) ? $lang['TRANSLATION_INFO'] : ((isset($lang['TRANSLATION'])) ? $lang['TRANSLATION'] : ''))

#
#-----[ OPEN ]---------------------------------------------
#
db/mysql.php

#
#-----[ FIND ]---------------------------------------------
#
$result = $this->rowset[$query_id][$field];

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$result = $this->rowset[$query_id][0][$field];

#
#-----[ OPEN ]---------------------------------------------
#
db/mysql4.php

#
#-----[ FIND ]---------------------------------------------
#
$result = $this->rowset[$query_id][$field];

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$result = $this->rowset[$query_id][0][$field];

#
#-----[ OPEN ]---------------------------------------------
#
includes/bbcode.php

#
#-----[ FIND ]---------------------------------------------
#
bbcode_array_push($stack, $match);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
array_push($stack, $match);

#
#-----[ FIND ]---------------------------------------------
#
$match = bbcode_array_pop($stack);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$match = array_pop($stack);

#
#-----[ FIND ]---------------------------------------------
#
$match = bbcode_array_pop($stack);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$match = array_pop($stack);

#
#-----[ FIND ]---------------------------------------------
#
/**
* This function does exactly what the PHP4 function array_push() does
* however, to keep phpBB compatable with PHP 3 we had to come up with our own
* method of doing it.
*/

#
#-----[ REPLACE WITH ]---------------------------------------------
#
/**
* This function does exactly what the PHP4 function array_push() does
* however, to keep phpBB compatable with PHP 3 we had to come up with our own
* method of doing it.
* This function was deprecated in phpBB 2.0.18
*/

#
#-----[ FIND ]---------------------------------------------
#
/**
* This function does exactly what the PHP4 function array_pop() does
* however, to keep phpBB compatable with PHP 3 we had to come up with our own
* method of doing it.
*/

#
#-----[ REPLACE WITH ]---------------------------------------------
#
/**
* This function does exactly what the PHP4 function array_pop() does
* however, to keep phpBB compatable with PHP 3 we had to come up with our own
* method of doing it.
* This function was deprecated in phpBB 2.0.18
*/

#
#-----[ FIND ]---------------------------------------------
#
$orig[] = "/(?<=.\W|\W.|^\W)" . phpbb_preg_quote($smilies[$i]['code'], "/") . "(?=.\W|\W.|\W$)/";

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$orig[] = "/(?<=.\W|\W.|^\W)" . preg_quote($smilies[$i]['code'], "/") . "(?=.\W|\W.|\W$)/";

#
#-----[ OPEN ]---------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]---------------------------------------------
#
define('SESSIONS_TABLE', $table_prefix.'sessions');

#
#-----[ AFTER, ADD ]---------------------------------------------
#
define('SESSIONS_KEYS_TABLE', $table_prefix.'sessions_keys');

#
#-----[ OPEN ]---------------------------------------------
#
includes/db.php

#
#-----[ FIND ]---------------------------------------------
#
message_die(CRITICAL_ERROR, "Could not connect to the database");

#
#-----[ REPLACE WITH ]---------------------------------------------
#
message_die(CRITICAL_ERROR, "Could not connect to the database");

#
#-----[ OPEN ]---------------------------------------------
#
includes/emailer.php

#
#-----[ FIND ]---------------------------------------------
#
$drop_header .= '[\r\n]*?' . phpbb_preg_quote($match[1], '#');

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$drop_header .= '[\r\n]*?' . preg_quote($match[1], '#');

#
#-----[ FIND ]---------------------------------------------
#
$drop_header .= '[\r\n]*?' . phpbb_preg_quote($match[1], '#');

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$drop_header .= '[\r\n]*?' . preg_quote($match[1], '#');

#
#-----[ FIND ]---------------------------------------------
#
$str = preg_replace('#' . phpbb_preg_quote($spacer, '#') . '$#', '', $str);

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$str = preg_replace('#' . preg_quote($spacer, '#') . '$#', '', $str);

#
#-----[ OPEN ]---------------------------------------------
#
includes/functions.php

#
#-----[ FIND ]---------------------------------------------
# NOTE --- Removing trailing whitespaces
#
$username = phpbb_rtrim($username, "\\");

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$username = phpbb_rtrim($username, "\\");

#
#-----[ FIND ]---------------------------------------------
#
// added at phpBB 2.0.12 to fix a bug in PHP 4.3.10 (only supporting charlist in php >= 4.1.0)
function phpbb_rtrim($str, $charlist = false)

#
#-----[ BEFORE, ADD ]---------------------------------------------
#
/**
* This function is a wrapper for ltrim, as charlist is only supported in php >= 4.1.0
* Added in phpBB 2.0.18
*/
function phpbb_ltrim($str, $charlist = false)
{
if ($charlist === false)
{
return ltrim($str);
}

$php_version = explode('.', PHP_VERSION);

// php version < 4.1.0
if ((int) $php_version[0] < 4 || ((int) $php_version[0] == 4 && (int) $php_version[1] < 1))
{
while ($str{0} == $charlist)
{
$str = substr($str, 1);
}
}
else
{
$str = ltrim($str, $charlist);
}

return $str;
}


#
#-----[ FIND ]---------------------------------------------
#
$orig_word[] = '#\b(' . str_replace('\*', '\w*?', phpbb_preg_quote($row['word'], '#')) . ')\b#i';

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$orig_word[] = '#\b(' . str_replace('\*', '\w*?', preg_quote($row['word'], '#')) . ')\b#i';

#
#-----[ OPEN ]---------------------------------------------
#
includes/functions_admin.php

#
#-----[ FIND ]---------------------------------------------
#
$sql = "SELECT forum_id, forum_name
FROM " . FORUMS_TABLE . "
ORDER BY cat_id, forum_order";

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$sql = 'SELECT f.forum_id, f.forum_name
FROM ' . CATEGORIES_TABLE . ' c, ' . FORUMS_TABLE . ' f
WHERE f.cat_id = c.cat_id
ORDER BY c.cat_order, f.forum_order';

#
#-----[ FIND ]---------------------------------------------
#
$sql = ( $row['total_posts'] ) ? "UPDATE " . TOPICS_TABLE . " SET topic_replies = " . ( $row['total_posts'] - 1 ) . ", topic_first_post_id = " . $row['first_post'] . ", topic_last_post_id = " . $row['last_post'] . " WHERE topic_id = $id" : "DELETE FROM " . TOPICS_TABLE . " WHERE topic_id = $id";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update topic', '', __LINE__, __FILE__, $sql);
}

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if ($row['total_posts'])
{
// Correct the details of this topic
$sql = 'UPDATE ' . TOPICS_TABLE . '
SET topic_replies = ' . ($row['total_posts'] - 1) . ', topic_first_post_id = ' . $row['first_post'] . ', topic_last_post_id = ' . $row['last_post'] . "
WHERE topic_id = $id";

if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not update topic', '', __LINE__, __FILE__, $sql);
}
}
else
{
// There are no replies to this topic
// Check if it is a move stub
$sql = 'SELECT topic_moved_id
FROM ' . TOPICS_TABLE . "
WHERE topic_id = $id";

if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not get topic ID', '', __LINE__, __FILE__, $sql);
}

if ($row = $db->sql_fetchrow($result))
{
if (!$row['topic_moved_id'])
{
$sql = 'DELETE FROM ' . TOPICS_TABLE . " WHERE topic_id = $id";

if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not remove topic', '', __LINE__, __FILE__, $sql);
}
}
}

$db->sql_freeresult($result);
}

#
#-----[ OPEN ]---------------------------------------------
#
includes/functions_post.php

#
#-----[ FIND ]---------------------------------------------
# NOTE --- This is a partial match, the whole line on a fresh installation looks like this:
# function submit_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id, &$topic_type, &$bbcode_on, &$html_on, &$smilies_on, &$attach_sig, &$bbcode_uid, &$post_username, &$post_subject, &$post_message, &$poll_title, &$poll_options, &$poll_length)
#
function submit_post(

#
#-----[ IN-LINE FIND ]---------------------------------------------
#
&$post_username, &$post_subject, &$post_message, &$poll_title

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------------------
#
$post_username, $post_subject, $post_message, $poll_title

#
#-----[ FIND ]---------------------------------------------
#
if ($mode == 'delete')
{
$delete_sql = (!$post_data['first_post'] && !$post_data['last_post']) ? " AND user_id = " . $userdata['user_id'] : '';
$sql = "DELETE FROM " . TOPICS_WATCH_TABLE . " WHERE topic_id = $topic_id" . $delete_sql;
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not change topic notify data', '', __LINE__, __FILE__, $sql);
}
}
else

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if ($mode != 'delete')

#
#-----[ FIND ]---------------------------------------------
#
$page_title = $lang['Emoticons'] . " - $topic_title";

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$page_title = $lang['Emoticons'];

#
#-----[ OPEN ]---------------------------------------------
#
includes/functions_search.php

#
#-----[ FIND ]---------------------------------------------
#
function split_words(&$entry, $mode = 'post')

#
#-----[ REPLACE WITH ]---------------------------------------------
#
function split_words($entry, $mode = 'post')

#
#-----[ OPEN ]---------------------------------------------
#
includes/functions_validate.php

#
#-----[ FIND ]---------------------------------------------
# NOTE --- Removing trailing whitespaces
#
$username = phpbb_clean_username($username);

$sql = "SELECT username
FROM " . USERS_TABLE . "

#
#-----[ REPLACE WITH ]---------------------------------------------
#
$username = phpbb_clean_username($username);

$sql = "SELECT username
FROM " . USERS_TABLE . "

#
#-----[ FIND ]---------------------------------------------
#
if ($row = $db->sql_fetchrow($result))

#
#-----[ REPLACE WITH ]---------------------------------------------
#
while ($row = $db->sql_fetchrow($result))

#
#-----[ FIND ]---------------------------------------------
#
if (preg_match("#\b(" . str_replace("\*", ".*?", phpbb_preg_quote($row['disallow_username'], '#')) . ")\b#i", $username))

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if (preg_match("#\b(" . str_replace("\*", ".*?", preg_quote($row['disallow_username'], '#')) . ")\b#i", $username))

#
#-----[ FIND ]---------------------------------------------
#
if (preg_match("#\b(" . str_replace("\*", ".*?", phpbb_preg_quote($row['word'], '#')) . ")\b#i", $username))

#
#-----[ REPLACE WITH ]---------------------------------------------
#
if (preg_match("#\b(" . str_replace("\*", ".*?", preg_quote($row['word'], '#')) . ")\b#i", $username))

#
#-----[ OPEN ]---------------------------------------------
#
includes/page_header.php

#
#-----[ FIND ]---------------------------------------------
#
$template->assign_block_vars('switch_user_logged_out', array());

#
#-----[ AFTER, ADD ]---------------------------------------------
#
//
// Allow autologin?
//
if (!isset($board_config['allow_autologin']) || $board_config['allow_autologin'] )
{
$template->assign_block_vars('switch_allow_autologin', array());
$template->assign_block_vars('switch_user_logged_out.switch_allow_autologin', array());
}

#
#-----[ OPEN ]---------------------------------------------
#
includes/page_tail.php

#
#-----[ FIND ]---------------------------------------------
#
//
// Show the overall footer.
//

#
#-----[ BEFORE, ADD ]---------------------------------------------
#

global $do_gzip_compress;


#
#-----[ FIND ]---------------------------------------------
#
'TRANSLATION_INFO' => ( isset($lang['TRANSLATION_INFO']) ) ? $lang['TRANSLATION_INFO'] : '',

#
#-----[ REPLACE WITH ]---------------------------------------------
#
'TRANSLATION_INFO' => (isset($lang['TRANSLATION_INFO'])) ? $lang['TRANSLATION_INFO'] : ((isset($lang['TRANSLATION'])) ? $lang['TRANSLATION'] : ''),

#
#-----[ OPEN ]---------------------------------------------
#
includes/sessions.php

#
#-----[ FIND ]---------------------------------------------
#
$current_time = time();
$expiry_time = $current_time - $board_config['session_length'];

//
// Try and pull the last time stored in a cookie, if it exists
//
$sql = "SELECT *
FROM " . USERS_TABLE . "
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{

Benutzeravatar
stefan
moris forum membre a'élite
moris forum membre a'élite
 
Beiträge: 3555
Bilder: 164
Registriert: Do Jun 12, 2003 14:35
Wohnort: Mauritius

Info Mauritius Annonce
 

Beitragvon anne » Fr Nov 04, 2005 1:35

zu :doof) um zu versehen,

gut das wie den Stefan hier haben i:()

danke, anne
Benutzeravatar
anne
moris forum membre a'élite
moris forum membre a'élite
 
Beiträge: 2905
Bilder: 0
Registriert: Mi Sep 10, 2003 12:05
Wohnort: Deutschland

Beitragvon Goldi » Fr Nov 04, 2005 12:01

.....da gibt es auch nichts zu verstehen.
Und dieses Kapitel könnte man auch unter "Unverwertbar" ablegen! :harry)
Goldi
content sa forum la
content sa forum la
 
Beiträge: 63
Registriert: So Okt 02, 2005 16:51

Beitragvon Tommy » Fr Nov 04, 2005 13:24

Hallo Stefan,

na ja, man sieht, dass Du nicht durch ein irgendwie attraktiv geartetes Umfeld von der Arbeit abgelenkt wirst :lol:

Hut ab,

viele Grüße

Tommy
Viele Grüße

Tommy

Immer wieder gerne auf Mauritius und im Meer darunter ;-))
Benutzeravatar
Tommy
moris forum membre a'élite
moris forum membre a'élite
 
Beiträge: 476
Bilder: 79
Registriert: Do Feb 17, 2005 18:18
Wohnort: Düsseldorf

Beitragvon Daggi » Fr Nov 04, 2005 14:03

Und Goldi hat immer was zu kacken.

Daggi
Daggi
content partagé
content partagé
 
Beiträge: 121
Registriert: Di Aug 02, 2005 16:11
Wohnort: Pereybere

Beitragvon Goldi » Fr Nov 04, 2005 14:21

Ja Daggilein, da nimmst Du Sachen in den Mund, die würde ich nicht mal anfassen..... :luve)
Goldi
content sa forum la
content sa forum la
 
Beiträge: 63
Registriert: So Okt 02, 2005 16:51

Beitragvon Daggi » Fr Nov 04, 2005 14:39

Hallo Goldi,

vielleicht solltest Du Dir mal überlegen, warum hier von sovielen Seiten gegen Dich geschossen wird. Wird wohl einen Grund haben. Kann doch nicht immer an den anderen liegen. Habe mich bisher ja zurückgehalten, aber mittlerweile ist dein Querulantentum doch ziemlich auffällig.

Damit verabschiede ich mich für die nächsten 4 Wochen.

Und Tschüss !!!
Daggi
content partagé
content partagé
 
Beiträge: 121
Registriert: Di Aug 02, 2005 16:11
Wohnort: Pereybere

Beitragvon anne » Fr Nov 04, 2005 15:59

Hi Goldi

.....da gibt es auch nichts zu verstehen.
Und dieses Kapitel könnte man auch unter "Unverwertbar" ablegen!


wenn WIR es nicht verstehen,
dann heißt es nicht, das es nicht doch Leute im Forum gibt,
die Stefans posting verstehen und es vielleicht für sich verwerten können.

was hast du mit Tunesien zu tun ?
ich frage wegen Deiner Flagge

gruss anne
Benutzeravatar
anne
moris forum membre a'élite
moris forum membre a'élite
 
Beiträge: 2905
Bilder: 0
Registriert: Mi Sep 10, 2003 12:05
Wohnort: Deutschland

Beitragvon stefan » Fr Nov 04, 2005 16:53

hier noch eine sache an euch alle, wenn ihr nicht in der lage seit, einfach mal etwas unkommentiert stehen zu lassen, sondern immer wieder kleine sticheleien hier oder da.
ist dies nicht ein zeugnis von groesse, sonder in meinen augen von dummheit.

leben und leben lassen!

somit wenn so ne stichelei wieder kommt, fliegt es aus dem topic raus, da es ja nichts mit dem thema zu tun hat.

wuerde vielen von euch gerne en beissholz schenken.

aber soviele habe ich gerade nicht zur hand :mrgreen:

goldi hat ne letzte warnung bekommen, da ich nicht den sinn sehe, warum ich mir das antun sollte, weil es ohne goldi vorher auch ging.

aber auch an euch, einfach mal die sabbel halten und die leute bekommen nicht die beachtung die sie erhaschen wollen, sie gehen von selber wieder!

aber wenn jeder seinen senf dazu gibt, wird ein problem nicht geloest,

also jeder mal an die eigene nase fassen und nicht wundern wenn ich nun leute sperre oder einfach mal "fuer sich sammeln", ein paar tage vor die tuer setze, manchmal hilfts.

forumsrichtlinien haben wir nun, bitte daran halten> ALLE!
gruss
stefan
Benutzeravatar
stefan
moris forum membre a'élite
moris forum membre a'élite
 
Beiträge: 3555
Bilder: 164
Registriert: Do Jun 12, 2003 14:35
Wohnort: Mauritius

Beitragvon Goldi » Fr Nov 04, 2005 21:20

edit

Goldi wollte BYE BYE sagen, fand aber nicht die richtigen worte.
Goldi
content sa forum la
content sa forum la
 
Beiträge: 63
Registriert: So Okt 02, 2005 16:51

Info Mauritius Annonce
 
Nächste

Zurück zu Forum Meldestelle



 


Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 3 Gäste