PHP-Nuke Nederland

PHP-Nuke Nederland: Forums

PHP-Nuke Nederland :: View topic - [FIX] Handmatig upgraden van 2.0.16 -> 2.0.17

Forum FAQ • Search • Memberlist • Usergroups • Register • • Profile • Log in to check your private messages • Log in

[FIX] Handmatig upgraden van 2.0.16 -> 2.0.17

PHP-Nuke Nederland Forum Index » Bugs / Fixes

Author

Message

BlueLion
Administrator

Joined: Aug 21, 2004
Posts: 2834

Posted: Wed 10 Aug 2005 1:58

phpBB 2.0.16 to phpBB 2.0.17 Code Changes

These are the Changes from phpBB 2.0.16 to phpBB 2.0.17 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.

When you find a 'AFTER, ADD'-Statement, the Code have to be added after the last line quoted in the 'FIND'-Statement.
When you find a 'BEFORE, ADD'-Statement, the Code have to be added before the first line quoted in the 'FIND'-Statement.
When you find a 'REPLACE WITH'-Statement, the Code quoted in the 'FIND'-Statement have to be replaced completely with the quoted Code in the 'REPLACE WITH'-Statement.

After you have finished this tutorial, you have to upload the install/update_to_latest.php file, execute it and then delete it from your webspace.

modules/Forums/admin/admin_ug_auth.php

FIND - Line 417

Code:

      FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u
      WHERE ug.group_id = aa.group_id
         AND u.user_id = ug.user_id

AFTER, ADD

Code:

AND ug.user_pending = 0

FIND - Line 572

Code:

$sql = "SELECT *
FROM " . FORUMS_TABLE . " f
ORDER BY forum_order";

REPLACE WITH

Code:

$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 ASC";

FIND - Line 608

Code:

$sql = "SELECT u.user_id, u.username, u.user_level, g.group_id, g.group_name, g.group_single_user FROM " . USERS_TABLE . " u, " . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug WHERE ";

REPLACE WITH

Code:

$sql = "SELECT u.user_id, u.username, u.user_level, g.group_id, g.group_name, g.group_single_user, ug.user_pending FROM " . USERS_TABLE . " u, " . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug WHERE ";

FIND - Line 836

Code:

$t_usergroup_list = '';
 for($i = 0; $i < count($ug_info); $i++)
 {
 $ug = ( $mode == 'user' ) ? 'group&' . POST_GROUPS_URL : 'user&' . POST_USERS_URL;

 $t_usergroup_list .= ( ( $t_usergroup_list != '' ) ? ', ' : '' ) . '<a href="' . append_sid("admin_ug_auth.$phpEx?mode=$ug=" . $id[$i]) . '">' . $name[$i] . '</a>';

REPLACE WITH

Code:

$t_usergroup_list = $t_pending_list = '';
 for($i = 0; $i < count($ug_info); $i++)
 {
 $ug = ( $mode == 'user' ) ? 'group&' . POST_GROUPS_URL : 'user&' . POST_USERS_URL;

 if (!$ug_info[$i]['user_pending'])
 {
 $t_usergroup_list .= ( ( $t_usergroup_list != '' ) ? ', ' : '' ) . '<a href="' . append_sid("admin_ug_auth.$phpEx?mode=$ug=" . $id[$i]) . '">' . $name[$i] . '</a>';
 }
 else
 {
 $t_pending_list .= ( ( $t_pending_list != '' ) ? ', ' : '' ) . '<a href="' . append_sid("admin_ug_auth.$phpEx?mode=$ug=" . $id[$i]) . '">' . $name[$i] . '</a>';
 }

FIND - Line 911

Code:

'GROUP_MEMBERSHIP' => $lang['Usergroup_members'] . ' : ' . $t_usergroup_list)

REPLACE WITH

Code:

'GROUP_MEMBERSHIP' => $lang['Usergroup_members'] . ' : ' . $t_usergroup_list . ' ' . $lang['Pending_members'] . ' : ' . $t_pending_list)

modules/Forums/admin/admin_users.php

FIND - Line 89

Code:

SET poster_id = " . DELETED . ", post_username = '$username'

REPLACE WITH

Code:

SET poster_id = " . DELETED . ", post_username = '" . str_replace("\\'", "''", addslashes($this_userdata['username'])) . "'

includes/bbcode.php

FIND - Line 203

Code:

$patterns[] = "#\[url\]([\w]+?://[^ \"\n\r\t<]*?)\[/url\]#is";
$replacements[] = $bbcode_tpl['url1'];

// [url]www.phpbb.com[/url] code.. (no xxxx:// prefix).
$patterns[] = "#\[url\]((www|ftp)\.[^ \"\n\r\t<]*?)\[/url\]#is";
$replacements[] = $bbcode_tpl['url2'];

// [url=xxxx://www.phpbb.com]phpBB[/url] code..
$patterns[] = "#\[url=([\w]+?://[^ \"\n\r\t<]*?)\]([^?\n\r\t].*?)\[/url\]#is";
$replacements[] = $bbcode_tpl['url3'];

// [url=www.phpbb.com]phpBB[/url] code.. (no xxxx:// prefix).
$patterns[] = "#\[url=((www|ftp)\.[^ \"\n\r\t<]*?)\]([^?\n\r\t].*?)\[/url\]#is";

REPLACE WITH

Code:

$patterns[] = "#\[url\]([\w]+?://[\w\#$%&~/.\-;:=,?@\[\]+]*?)\[/url\]#is";
$replacements[] = $bbcode_tpl['url1'];

// [url]www.phpbb.com[/url] code.. (no xxxx:// prefix).
$patterns[] = "#\[url\]((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]+]*?)\[/url\]#is";
$replacements[] = $bbcode_tpl['url2'];

// [url=xxxx://www.phpbb.com]phpBB[/url] code..
$patterns[] = "#\[url=([\w]+?://[\w\#$%&~/.\-;:=,?@\[\]+]*?)\]([^?\n\r\t].*?)\[/url\]#is";
$replacements[] = $bbcode_tpl['url3'];

// [url=www.phpbb.com]phpBB[/url] code.. (no xxxx:// prefix).
$patterns[] = "#\[url=((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]+]*?)\]([^?\n\r\t].*?)\[/url\]#is";

FIND - Line 627

Code:

$ret = preg_replace("#(^|[\n ])([\w]+?://[^ \"\n\r\t<]*)#is", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $ret);

// matches a "www|ftp.xxxx.yyyy[/zzzz]" kinda lazy URL thing
// Must contain at least 2 dots. xxxx contains either alphanum, or "-"
// zzzz is optional.. will contain everything up to the first space, newline,
// comma, double quote or <.
$ret = preg_replace("#(^|[\n ])((www|ftp)\.[^ \"\t\n\r<]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $ret);

REPLACE WITH

Code:

$ret = preg_replace("#(^|[\n ])([\w]+?://[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $ret);

// matches a "www|ftp.xxxx.yyyy[/zzzz]" kinda lazy URL thing
// Must contain at least 2 dots. xxxx contains either alphanum, or "-"
// zzzz is optional.. will contain everything up to the first space, newline,
// comma, double quote or <.
$ret = preg_replace("#(^|[\n ])((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $ret);

includes/functions.php

FIND - Line 120

Code:

if (intval($user) == 0 || $force_str)

REPLACE WITH

Code:

if (!is_numeric($user) || $force_str)
FIND - Line 581

Code:

define(HAS_DIED, 1);

REPLACE WITH

Code:

define('HAS_DIED', 1);

includes/functions_validate.php

FIND - Line 33

Code:

$username = preg_replace('#\s+#', ' ', $username);
// Limit username length
$username = substr(str_replace("\'", "'", $username), 0, 25);
$username = str_replace("'", "''", $username);

REPLACE WITH

Code:

$username = preg_replace('#\s+#', ' ', trim($username));
$username = phpbb_clean_username($username);

includes/usercp_activate.php

FIND - Line 50

Code:

}
else if ((trim($row['user_actkey']) == trim($HTTP_GET_VARS['act_key'])) && (trim($row['user_actkey']) != ''))
{

AFTER, ADD

Code:

   if (intval($board_config['require_activation']) == USER_ACTIVATION_ADMIN && $userdata['user_level'] != ADMIN)
   {
      message_die(GENERAL_MESSAGE, $lang['Not_Authorised']);
   }

includes/usercp_avatar.php

FIND - Line 89

Code:

function user_avatar_url($mode, &$error, &$error_msg, $avatar_filename)
{

AFTER, ADD

Code:

global $lang;

includes/usercp_viewprofile.php

FIND - Line 168

Code:

$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 = '<a href="' . $temp_url . '">' . $lang['Search_user_posts'] . '</a>';

REPLACE WITH

Code:

$search_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_search'] . '" alt="' . $lang['Search_user_posts'] . '" title="' . sprintf($lang['Search_user_posts'], $profiledata['username']) . '" border="0" /></a>';
$search = '<a href="' . $temp_url . '">' . sprintf($lang['Search_user_posts'], $profiledata['username']) . '</a>';

modules/Private_Messages/index.php

FIND - Line 701

Code:

   if ( $delete_all )
   {
      switch($folder)
      {
         case 'inbox':
            $delete_type = "privmsgs_to_userid = " . $userdata['user_id'] . " AND (
            privmsgs_type = " . PRIVMSGS_READ_MAIL . " OR privmsgs_type = " . PRIVMSGS_NEW_MAIL . " OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " )";
            break;

         case 'outbox':
            $delete_type = "privmsgs_from_userid = " . $userdata['user_id'] . " AND ( privmsgs_type = " . PRIVMSGS_NEW_MAIL . " OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " )";
            break;

         case 'sentbox':
            $delete_type = "privmsgs_from_userid = " . $userdata['user_id'] . " AND privmsgs_type = " . PRIVMSGS_SENT_MAIL;
            break;

         case 'savebox':
            $delete_type = "( ( privmsgs_from_userid = " . $userdata['user_id'] . "
               AND privmsgs_type = " . PRIVMSGS_SAVED_OUT_MAIL . " )
            OR ( privmsgs_to_userid = " . $userdata['user_id'] . "
               AND privmsgs_type = " . PRIVMSGS_SAVED_IN_MAIL . " ) )";
            break;
      }

      $sql = "SELECT privmsgs_id
         FROM " . PRIVMSGS_TABLE . "
         WHERE $delete_type";
      if ( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not obtain id list to delete all messages', '', __LINE__, __FILE__, $sql);
      }

      while ( $row = $db->sql_fetchrow($result) )
      {
         $mark_list[] = $row['privmsgs_id'];
      }

      unset($delete_type);
   }

REPLACE WITH

Code:

$delete_sql_id = '';

 if (!$delete_all)
 {
 for ($i = 0; $i < count($mark_list); $i++)
 {
 $delete_sql_id .= (($delete_sql_id != '') ? ', ' : '') . intval($mark_list[$i]);
 }
 $delete_sql_id = "AND privmsgs_id IN ($delete_sql_id)";
 }

 switch($folder)
 {
 case 'inbox':
 $delete_type = "privmsgs_to_userid = " . $userdata['user_id'] . " AND (
 privmsgs_type = " . PRIVMSGS_READ_MAIL . " OR privmsgs_type = " . PRIVMSGS_NEW_MAIL . " OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " )";
 break;

 case 'outbox':
 $delete_type = "privmsgs_from_userid = " . $userdata['user_id'] . " AND ( privmsgs_type = " . PRIVMSGS_NEW_MAIL . " OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " )";
 break;

 case 'sentbox':
 $delete_type = "privmsgs_from_userid = " . $userdata['user_id'] . " AND privmsgs_type = " . PRIVMSGS_SENT_MAIL;
 break;

 case 'savebox':
 $delete_type = "( ( privmsgs_from_userid = " . $userdata['user_id'] . "
 AND privmsgs_type = " . PRIVMSGS_SAVED_OUT_MAIL . " )
 OR ( privmsgs_to_userid = " . $userdata['user_id'] . "
 AND privmsgs_type = " . PRIVMSGS_SAVED_IN_MAIL . " ) )";
 break;
 }

 $sql = "SELECT privmsgs_id
 FROM " . PRIVMSGS_TABLE . "
 WHERE $delete_type $delete_sql_id";

 if ( !($result = $db->sql_query($sql)) )
 {
 message_die(GENERAL_ERROR, 'Could not obtain id list to delete messages', '', __LINE__, __FILE__, $sql);
 }

 $mark_list = array();
 while ( $row = $db->sql_fetchrow($result) )
 {
 $mark_list[] = $row['privmsgs_id'];
 }

 unset($delete_type);

FIND - Line 1507

Code:

         $mode = 'reply';
      }
   }

AFTER, ADD

Code:

   else
   {
      $privmsg_subject = $privmsg_message = '';
   }
FIND - Line 2036

Code:

$l_box_size_status = '';
break;
}
}

AFTER, ADD

Code:

else
{
$inbox_limit_img_length = $inbox_limit_pct = $l_box_size_status = '';
}

modules/Forums/templates/subSilver/faq_body.tpl

FIND - Line 37

Code:

<td class="{faq_block.faq_row.ROW_CLASS}" align="left" valign="top"><a name="{faq_block.faq_row.U_FAQ_ID}"></a>{faq_block.faq_row.FAQ_QUESTION} {faq_block.faq_row.FAQ_ANSWER} <a class="postlink" href="#Top">{L_BACK_TO_TOP}</a></td>

REPLACE WITH

Code:

modules/Forums/viewtopic.php

FIND - Line 992

Code:

REPLACE WITH

Code:

$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 = '<a href="' . $temp_url . '">' . sprintf($lang['Search_user_posts'], $postrow[$i]['username']) . '</a>';

Je forum tabellen worden met de volgende query geupdate:

Code:

UPDATE nuke_bbconfig SET config_value='.0.17' where config_name='version';

BlueLion
Administrator

Joined: Aug 21, 2004
Posts: 2834

Posted: Wed 10 Aug 2005 1:58

FIX

Donaties

Adverteren

Wilt u het forum steunen, dan kunt u nu eenvoudig doneren met PayPal.

PHP-Nuke Nederland Forum Index » Bugs / Fixes

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Forums ©


All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © 2004-2008 by BlueLion. SEO enhanced with the Sitemapper script You can syndicate our news using the file backend.php or ultramode.txt PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license. Pagina rendering: 0.14 seconden	RSS Feeds:
:: fisubsilver shadow phpbb2 style by Daz :: PHP-Nuke theme by BlueLion ::