[Tool] phpBB 2.0.18 to 2.0.19 Code Changes

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
21
75%
Very Good
4
14%
Good
0
No votes
Fair
1
4%
Poor
2
7%
 
Total votes: 28

chatasos
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos »

Update went fine....no quote problem....html is on.

Report Posts 1.2.3c (MODDB) - Report Posts 2.1.5 (ALPHA)
Rebuild Search 2.4.0 (MODDB)
MOD Version Checker 1.2.0 (MODDB)
Mega Mail System 0.9.8 (ALPHA)
Pagination Select List & Input Box (MODDB)
rockandorroll21
Registered User
Posts: 19
Joined: Sun Oct 16, 2005 7:07 pm

Post by rockandorroll21 »

Thanks for the help, it's all working now.
parsonsj
Registered User
Posts: 17
Joined: Thu Jul 14, 2005 6:38 am
Contact:

Thanks

Post by parsonsj »

Nice work!
reggien
Registered User
Posts: 84
Joined: Sat Feb 12, 2005 5:59 am

Post by reggien »

DragonMaster1 wrote:
asinshesq wrote:
jwchess wrote:I figure it out. If you enable html on the board, quoting no longer works.
On my board only admins were allowed to post html (own mod).
I disabled that and now quoting works correctly...

I can confirm this. If you allow html on your board (in my case, I allowed only <b> and <u>) then quoting does not work unless you leave in the original line in addition to the new line. In other words, you would change that part of the upgrade mod to this:

Code: Select all

#
#-----[ FIND ]---------------------------------------------
# Line 255
	$text = bbencode_first_pass_pda($text, $uid, '/\[quote=(\\\".*?\\\")\]/is', '[/quote]', '', false, '', "[quote:$uid=\\1]");

#
#-----[ BEFORE, ADD ]---------------------------------------------
# 
	$text = bbencode_first_pass_pda($text, $uid, '/\[quote=\\\\"(.*?)\\\\"\]/is', '[/quote]', '', false, '', "[quote:$uid=\\\"\\1\\\"]");
(the only change I made was to change "REPLACE WITH" to "BEFORE, ADD")

Alternatively, you can disable html on your board (which may be a good idea anyway and is what I ended up doing on my board).



I have not been allowing html and this quote problem still existed

However this fix of adding this extra line did fix it

Would there be any problems with keeping it added....as far a any security or board issues that it might/could cause?


I'd be very interested in knowing this as well.

In addition, I had a strange problem with quotation marks since the upgrade to 2.0.19. Whenever someone would post with quotation marks, instead of for example, "word" the result would be "word"

After hours of frustration looking and comparing bbcode.php I have found the problem in includes/functions_post.php with the code below. When I reverted back to the original code all worked fine. Is this, in addition to adding the code above to make quotes work properly, a major security risk? And if so, how does one correct it to make quotes and quotation marks work properly?

Code: Select all

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

#
#-----[ FIND ]---------------------------------------------
# Line 28
$html_entities_match = array('#&(?!(\#[0-9]+;))#', '#<#', '#>#');
$html_entities_replace = array('&', '<', '>');

#
#-----[ REPLACE WITH ]---------------------------------------------
# 
$html_entities_match = array('#&(?!(\#[0-9]+;))#', '#<#', '#>#', '#"#');
$html_entities_replace = array('&', '<', '>', '"');
$chaltza
Registered User
Posts: 6
Joined: Fri Nov 25, 2005 6:44 pm

Post by $chaltza »

I have problem with

Critical Error

FIND FAILED: In file [includes/usercp_register.php] could not find:

$strip_var_list = array('username' => 'username', 'email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests');
$strip_var_list['confirm_code'] = 'confirm_code';

when I try to update with Easy MOD.
Why?
$chaltza
Registered User
Posts: 6
Joined: Fri Nov 25, 2005 6:44 pm

Post by $chaltza »

I did a little research on my own, if I change code

from

Code: Select all

#
#-----[ FIND ]---------------------------------------------
# Line 110
	$strip_var_list = array('username' => 'username', 'email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests');
	$strip_var_list['confirm_code'] = 'confirm_code';

#
#-----[ REPLACE WITH ]---------------------------------------------
# 
	$strip_var_list = array('email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests', 'confirm_code' => 'confirm_code');

to

Code: Select all


#
#-----[ FIND ]---------------------------------------------
# Line 110
	
      $strip_var_list = array('username' => 'username', 'email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests', 'name_first' => 'name_first', 'name_last' => 'name_last');
	$strip_var_list['confirm_code'] = 'confirm_code';

#
#-----[ REPLACE WITH ]---------------------------------------------
# 
      $strip_var_list = array('email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests', 'name_first' => 'name_first', 'name_last' => 'name_last', 'confirm_code' => 'confirm_code');
	
is this ok?
asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Post by asinshesq »

$chaltza wrote: ...is this ok?

Seems fine.
User avatar
jmwgomz
Registered User
Posts: 129
Joined: Mon Jul 25, 2005 11:16 pm
Location: San Diego
Contact:

Post by jmwgomz »

Just tried to install this using easymod and here's what I got:

Critical Error

FIND FAILED: In file [templates/subSilver/index_body.tpl] could not find:

<table width="100%" cellspacing="0" cellpadding="2" border="0" align="center">
<tr>
<td align="left" valign="bottom"><span class="gensmall">
<!-- BEGIN switch_user_logged_in -->
{LAST_VISIT_DATE}<br />
<!-- END switch_user_logged_in -->
{CURRENT_TIME}<br /></span><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a></span></td>
<td align="right" valign="bottom" class="gensmall">
<!-- BEGIN switch_user_logged_in -->
<a href="{U_SEARCH_NEW}" class="gensmall">{L_SEARCH_NEW}</a><br /><a href="{U_SEARCH_SELF}" class="gensmall">{L_SEARCH_SELF}</a><br />
<!-- END switch_user_logged_in -->
<a href="{U_SEARCH_UNANSWERED}" class="gensmall">{L_SEARCH_UNANSWERED}</a></td>
</tr>
</table>

MOD script line #257



What does this mean???/What should I do???
"lo sono nella tribu. E tu?"
User avatar
jmwgomz
Registered User
Posts: 129
Joined: Mon Jul 25, 2005 11:16 pm
Location: San Diego
Contact:

Post by jmwgomz »

please delete/disregard the previous post. it is in the wrong thread. :oops:
"lo sono nella tribu. E tu?"
†Phoenix†
Registered User
Posts: 5
Joined: Tue Jan 31, 2006 2:23 pm

Post by †Phoenix† »

Help please. I installed this and now I can't log into my forum here is the error that I am getting. How do I fix this??? Thank you:)


Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM phpbb_users WHERE username = '†Phoenix†'

Line : 66
File : login.php
asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Post by asinshesq »

†Phoenix† wrote: Help please. I installed this and now I can't log into my forum here is the error that I am getting. How do I fix this??? Thank you:)


Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM phpbb_users WHERE username = '†Phoenix†'

Line : 66
File : login.php

As it says right at the beginning of the mod:

Code: Select all

##		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.
If you don't do that, your db won't have the field the script is looking for. So, copy the install folder to your phpbb2 root directory (it's probably called phpbb2 unless you renamed it something else), then use your browser to navigate to [your_forum_address]/install/update_to_latest.php . Follow diorections and once you are done, make sure you delete the install directory from your root phpbb2 directory since you won't be able to sign into your forum until you do.
†Phoenix†
Registered User
Posts: 5
Joined: Tue Jan 31, 2006 2:23 pm

Post by †Phoenix† »

Thank you so much for your help. I am sorry I didn't know what that meant exactally. Sorry to be a bother.
asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Post by asinshesq »

†Phoenix† wrote: Thank you so much for your help. I am sorry I didn't know what that meant exactally. Sorry to be a bother.

No problem...we were all new once ;) And I must say that I agree that note is not terribly clear for someone who is new at this! Let us know if it all works out.
igami
Registered User
Posts: 79
Joined: Fri Jun 17, 2005 6:49 pm

Post by igami »

Worked like a charm for me ...

Course I'm curious with an update why it doesnt say Powered by phpBB © 2001, 2006 phpBB Group

Then I looked at this board and it still states 2003 :lol:
tony44
Registered User
Posts: 232
Joined: Sun Apr 17, 2005 4:34 pm

Post by tony44 »

Can someone confirm that this is the sql code? I like pasting this into phpmyadmin rather than running the script.

Code: Select all

UPDATE phpbb_config SET config_value='.0.19' WHERE config_name='version';
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '15');
ALTER TABLE phpbb_users   ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users   ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL;
Post Reply

Return to “[2.0.x] MOD Database Releases”