[3.0.6] Enable Quick Reply in all forums

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
DBpbg
Registered User
Posts: 16
Joined: Tue Oct 20, 2009 3:55 pm
Location: Germany

[3.0.6] Enable Quick Reply in all forums

Post by DBpbg » Sat Nov 21, 2009 12:57 pm

Hello,
I just upgraded my phpBB from 3.0.5 to 3.0.6. A very nice update-Feature!

Due to this update, I uninstalled the Quick Reply mod to activate the new default quick reply option. But is there a way to activate this function in all forums at once (via MySQL?)?
The manual way would take a lot of time.

Thank you for help!
Last edited by JimA on Sat Nov 21, 2009 2:59 pm, edited 1 time in total.
Reason: Topic icon changed
Dennis

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7618
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: [3.0.6] Enable Quick Reply in all forums

Post by JimA » Sat Nov 21, 2009 1:05 pm

If you're using MySQL, this SQL query should enable Quick Reply in all forums. :)

Code: Select all

UPDATE phpbb_forums SET forum_flags = forum_flags + 64 WHERE forum_type = 1 AND forum_flags & 64 <> 1
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

DBpbg
Registered User
Posts: 16
Joined: Tue Oct 20, 2009 3:55 pm
Location: Germany

Re: [3.0.6] Enable Quick Reply in all forums

Post by DBpbg » Sat Nov 21, 2009 1:07 pm

It works! Thank you for the fast help. ;)
Dennis

asmalik12
Registered User
Posts: 91
Joined: Fri Mar 27, 2009 3:26 pm
Location: Lahore, Pakistan
Contact:

Re: [3.0.6] Enable Quick Reply in all forums

Post by asmalik12 » Mon Nov 23, 2009 8:28 am

error in my board :

Error

SQL query:

UPDATE phpbb_forums SET forum_flags = forum_flags +64 WHERE forum_type =1 AND forum_flags &64 <>1

MySQL said:
#1054 - Unknown column 'forum_type' in 'where clause'
"Think 100 times before you take a decision, But once that decision is taken, stand by it as one man." - Quaid-e-Azam

Image

malaxpina
Registered User
Posts: 3
Joined: Wed Jul 07, 2004 4:22 pm
Contact:

Re: [3.0.6] Enable Quick Reply in all forums

Post by malaxpina » Tue Nov 24, 2009 12:26 pm

JimA wrote:If you're using MySQL, this SQL query should enable Quick Reply in all forums. :)

Code: Select all

UPDATE phpbb_forums SET forum_flags = forum_flags + 64 WHERE forum_type = 1 AND forum_flags & 64 <> 1

Can i add this SQL query in database_update.php? ¿How?

Thanks.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69217
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: [3.0.6] Enable Quick Reply in all forums

Post by KevC » Tue Nov 24, 2009 12:28 pm

malaxpina wrote:Can i add this SQL query in database_update.php? ¿How?
No need.
Just to go your database, click the SQL tab, paste, go, done.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

malaxpina
Registered User
Posts: 3
Joined: Wed Jul 07, 2004 4:22 pm
Contact:

Re: [3.0.6] Enable Quick Reply in all forums

Post by malaxpina » Tue Nov 24, 2009 12:32 pm

Kevin Clark wrote:
malaxpina wrote:Can i add this SQL query in database_update.php? ¿How?
No need.
Just to go your database, click the SQL tab, paste, go, done.
But i want add the sql query to database_update.php.

If i update some diferents forums, it is faster and I can not forget.

vanya_y
Registered User
Posts: 20
Joined: Mon Dec 05, 2005 8:46 am
Location: Ukraine
Contact:

Re: [3.0.6] Enable Quick Reply in all forums

Post by vanya_y » Tue Nov 24, 2009 9:47 pm

Didn't work for me. Any thoughts?

Blazeflack
Registered User
Posts: 50
Joined: Sat May 16, 2009 2:00 pm

Re: [3.0.6] Enable Quick Reply in all forums

Post by Blazeflack » Wed Nov 25, 2009 2:15 am

I made a very small MOD a little while ago that lets you enable quick reply in all your forums. It executes the same kind of SQL as have already been posted in this thread.

My MOD is for people who might only have FTP access and no MySQL login (for whatever reason). You can install the MOD with AutoMOD or do it by hand. When installed you will see the option to enable quick reply below the "Purge Now" option in the general tab of the ACP.

I have submitted the MOD to the database and it should be reviewed and hopefully published soon. If you want to test it right away just let me know and I will upload it.

KlownPosse45
Registered User
Posts: 18
Joined: Wed Nov 25, 2009 3:57 am

Re: [3.0.6] Enable Quick Reply in all forums

Post by KlownPosse45 » Wed Nov 25, 2009 4:14 am

JimA wrote:If you're using MySQL, this SQL query should enable Quick Reply in all forums. :)

Code: Select all

UPDATE phpbb_forums SET forum_flags = forum_flags + 64 WHERE forum_type = 1 AND forum_flags & 64 <> 1
Not that familiar with the forum_flags column, but shouldn't the last condition be:

Code: Select all

AND forum_flags & 64 <> 64

vanya_y
Registered User
Posts: 20
Joined: Mon Dec 05, 2005 8:46 am
Location: Ukraine
Contact:

Re: [3.0.6] Enable Quick Reply in all forums

Post by vanya_y » Wed Nov 25, 2009 8:23 am

KlownPosse45 wrote: Not that familiar with the forum_flags column, but shouldn't the last condition be:

Code: Select all

AND forum_flags & 64 <> 64
So everyone who tried that has problems now? :) In my forum a lot of records were updated when running this query...

KlownPosse45
Registered User
Posts: 18
Joined: Wed Nov 25, 2009 3:57 am

Re: [3.0.6] Enable Quick Reply in all forums

Post by KlownPosse45 » Wed Nov 25, 2009 1:10 pm

vanya_y wrote:
KlownPosse45 wrote: Not that familiar with the forum_flags column, but shouldn't the last condition be:

Code: Select all

AND forum_flags & 64 <> 64
So everyone who tried that has problems now? :) In my forum a lot of records were updated when running this query...
No, no, it shouldn't really cause any problems. Most of your forum_flags will have been updated from a number below 64 and then there is no issue. You can check the new values in the table for forum_type = 1. I'm not sure the 128-bit marker is even used as a flag. If you have a bunch of new forum_flags in the 90's for instance, then it doesn't matter at all.

User avatar
cYbercOsmOnauT
Registered User
Posts: 362
Joined: Wed Jun 16, 2004 8:22 am
Location: Goettingen, Germany
Name: Tekin Birdüzen

Re: [3.0.6] Enable Quick Reply in all forums

Post by cYbercOsmOnauT » Thu Nov 26, 2009 9:14 am

The better way to do it (mySQL) is

Code: Select all

UPDATE phpbb_forums SET forum_flags = (forum_flags | 64) WHERE forum_type = 1
Regards,
Tekin
phpBB-installation and reparation. Prof. PHP coding with function guarantee. Just contact me at: t.birduezen@web-coding.eu.
Ex-German Support Team Member | phpBB Development Environment

KlownPosse45
Registered User
Posts: 18
Joined: Wed Nov 25, 2009 3:57 am

Re: [3.0.6] Enable Quick Reply in all forums

Post by KlownPosse45 » Thu Nov 26, 2009 1:00 pm

cYbercOsmOnauT wrote:The better way to do it (mySQL) is

Code: Select all

UPDATE phpbb_forums SET forum_flags = (forum_flags | 64) WHERE forum_type = 1
Indeed, it does exactly the same as:

Code: Select all

UPDATE phpbb_forums SET forum_flags = forum_flags + 64 WHERE forum_type = 1 AND forum_flags & 64 <> 64
But is shorter and more intuitive.

Code: Select all

x & 64 <> 1
Is meaningless, though, as the left side never evaluates to 1, so the condition will always be true and therefore has no effect.

enkigur
Registered User
Posts: 74
Joined: Sun Mar 25, 2007 9:49 pm

Re: [3.0.6] Enable Quick Reply in all forums

Post by enkigur » Wed Dec 02, 2009 3:02 pm

Hello,

how can I disable this again?

Locked

Return to “[3.0.x] Support Forum”