Updateanleitung von phpBB 2.0.17 auf 2.0.18
Verfasst: So 30.Okt, 2005 17:51
gibt wieder mal arbeit, hat einer schon ne anleitung dafür gefunden?
phpBB-Support, PC Hilfe und vieles mehr...
https://www.oxpus.de:443/
Code: Alles auswählen
privmsg.php
#
#-----[ FIND ]---------------------------------------------
#
$privmsg_subject = $privmsg_message = '';
#
#-----[ REPLACE WITH ]---------------------------------------------
#
$privmsg_subject = $privmsg_message = $to_username = '';
viewtopic.php
#
#-----[ 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);
}
admin_ug_auth.php
#
#-----[ FIND ]---------------------------------------------
#
if( count($name) )
{
$t_usergroup_list = $t_pending_list = '';
#
#-----[ REPLACE WITH ]---------------------------------------------
#
$t_usergroup_list = $t_pending_list = '';
if( count($name) )
{
function_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 . "
session.php (CTracker)
#
#-----[ 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)) )
{
message_die(CRITICAL_ERROR, 'Could not obtain lastvisit data from user table', '', __LINE__, __FILE__, $sql);
}
$userdata = $db->sql_fetchrow($result);
if ( $user_id != ANONYMOUS )
{
$auto_login_key = $userdata['user_password'];
if ( $auto_create )
{
if ( isset($sessiondata['autologinid']) && $userdata['user_active'] )
{
// We have to login automagically
if( $sessiondata['autologinid'] === $auto_login_key )
{
// autologinid matches password
$login = 1;
$enable_autologin = 1;
}
else
{
// No match; don't login, set as anonymous user
$login = 0;
$enable_autologin = 0;
$user_id = $userdata['user_id'] = ANONYMOUS;
$sql = 'SELECT * FROM ' . USERS_TABLE . ' WHERE user_id = ' . ANONYMOUS;
$result = $db->sql_query($sql);
$userdata = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
}
}
else
{
// Autologin is not set. Don't login, set as anonymous user
$login = 0;
$enable_autologin = 0;
$user_id = $userdata['user_id'] = ANONYMOUS;
$sql = 'SELECT * FROM ' . USERS_TABLE . ' WHERE user_id = ' . ANONYMOUS;
$result = $db->sql_query($sql);
$userdata = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
}
}
else
{
$login = 1;
}
}
else
{
$login = 0;
$enable_autologin = 0;
}
#
#-----[ REPLACE WITH ]---------------------------------------------
#
$current_time = time();
//
// Are auto-logins allowed?
// If allow_autologin is not set or is true then they are
// (same behaviour as old 2.0.x session code)
//
if (isset($board_config['allow_autologin']) && !$board_config['allow_autologin'])
{
$enable_autologin = $sessiondata['autologinid'] = false;
}
//
// First off attempt to join with the autologin value if we have one
// If not, just use the user_id value
//
$userdata = array();
if ($user_id != ANONYMOUS)
{
if (isset($sessiondata['autologinid']) && (string) $sessiondata['autologinid'] != '' && $user_id)
{
$sql = 'SELECT u.*
FROM ' . USERS_TABLE . ' u, ' . SESSIONS_KEYS_TABLE . ' k
WHERE u.user_id = ' . (int) $user_id . "
AND u.user_active = 1
AND k.user_id = u.user_id
AND k.key_id = '" . md5($sessiondata['autologinid']) . "'";
if (!($result = $db->sql_query($sql)))
{
message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch', '', __LINE__, __FILE__, $sql);
}
$userdata = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$enable_autologin = $login = 1;
}
else if (!$auto_create)
{
$sessiondata['autologinid'] = '';
$sessiondata['userid'] = $user_id;
$sql = 'SELECT *
FROM ' . USERS_TABLE . '
WHERE user_id = ' . (int) $user_id . '
AND user_active = 1';
if (!($result = $db->sql_query($sql)))
{
message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch', '', __LINE__, __FILE__, $sql);
}
$userdata = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$login = 1;
}
}
//
// At this point either $userdata should be populated or
// one of the below is true
// * Key didn't match one in the DB
// * User does not exist
// * User is inactive
//
if (!sizeof($userdata) || !is_array($userdata) || !$userdata)
{
$sessiondata['autologinid'] = '';
$sessiondata['userid'] = $user_id = ANONYMOUS;
$enable_autologin = $login = 0;
$sql = 'SELECT *
FROM ' . USERS_TABLE . '
WHERE user_id = ' . (int) $user_id;
if (!($result = $db->sql_query($sql)))
{
message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch', '', __LINE__, __FILE__, $sql);
}
$userdata = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
}
usercp_activate.php
#
#-----[ OPEN ]---------------------------------------------
#
includes/usercp_activate.php
#
#-----[ FIND ]---------------------------------------------
#
if (intval($board_config['require_activation']) == USER_ACTIVATION_ADMIN && $userdata['user_level'] != ADMIN)
{
message_die(GENERAL_MESSAGE, $lang['Not_Authorised']);
}
#
#-----[ REPLACE WITH ]---------------------------------------------
#
if (intval($board_config['require_activation']) == USER_ACTIVATION_ADMIN && $row['user_newpasswd'] == '')
{
if (!$userdata['session_logged_in'])
{
redirect(append_sid('login.' . $phpEx . '?redirect=profile.' . $phpEx . '&mode=activate&' . POST_USERS_URL . '=' . $row['user_id'] . '&act_key=' . trim($HTTP_GET_VARS['act_key'])));
}
else if ($userdata['user_level'] != ADMIN)
{
message_die(GENERAL_MESSAGE, $lang['Not_Authorised']);
}
}
index_body.tpl
#
#
# NOTE --- The following action is related to the new autologin option (it can be disabled from the ACP).
#
#-----[ FIND ]---------------------------------------------
#
{L_AUTO_LOGIN}
<input class="text" type="checkbox" name="autologin" />
#
#-----[ BEFORE, ADD ]---------------------------------------------
#
<!-- BEGIN switch_allow_autologin -->
#
#-----[ AFTER, ADD ]---------------------------------------------
#
<!-- END switch_allow_autologin -->
#
#-----[ OPEN ]---------------------------------------------
# NOTE --- Remember to do this for all your installed styles!
#
templates/subSilver/admin/forum_admin_body.tpl
#
#
# NOTE --- The following action fixes a bug in the subSilver template
#
#-----[ FIND ]---------------------------------------------
#
<td class="catRight" align="center" valign="middle"><span class="gen"> </span></td>
#
#-----[ REPLACE WITH ]---------------------------------------------
#
<td class="catRight" align="center" valign="middle"><span class="gen"> </span></td>
Code: Alles auswählen
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;
}Code: Alles auswählen
ORDER BY c.cat_id, f.forum_order";
#
#-----[ REPLACE WITH ]---------------------------------------------
#
ORDER BY c.cat_order, f.forum_order";Code: Alles auswählen
#
#-----[ 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';Code: Alles auswählen
$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);
}
}Code: Alles auswählen
$topic_type = ( !empty($HTTP_POST_VARS['topictype']) ) ? intval($HTTP_POST_VARS['topictype']) : POST_NORMAL;Code: Alles auswählen
$topic_type = ( in_array($topic_type, array(POST_NORMAL, POST_STICKY, POST_ANNOUNCE)) ) ? $topic_type : POST_NORMAL;wo könnte ich da müll gebaut haben?phpBB : Critical Error
Error clearing session table
DEBUG MODE
SQL Error : 1146 Table 'orgi.sessions_table' doesn't exist
DELETE FROM SESSIONS_TABLE WHERE session_logged_in = 0;
Line : 190
File : sessions.php
Code: Alles auswählen
$topic_type = ( in_array($topic_type, array(POST_NORMAL, POST_STICKY, POST_ANNOUNCE,POST_GLOBAL_TOPIC,POST_GLOBAL_ANNOUNCE)) ) ? $topic_type : POST_NORMAL;