Page 1 of 2

[3.0.6] Enable Quick Reply in all forums

Posted: Sat Nov 21, 2009 12:57 pm
by DBpbg
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!

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Sat Nov 21, 2009 1:05 pm
by JimA
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

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Sat Nov 21, 2009 1:07 pm
by DBpbg
It works! Thank you for the fast help. ;)

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Mon Nov 23, 2009 8:28 am
by asmalik12
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'

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Tue Nov 24, 2009 12:26 pm
by malaxpina
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.

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Tue Nov 24, 2009 12:28 pm
by KevC
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.

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Tue Nov 24, 2009 12:32 pm
by malaxpina
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.

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Tue Nov 24, 2009 9:47 pm
by vanya_y
Didn't work for me. Any thoughts?

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Wed Nov 25, 2009 2:15 am
by Blazeflack
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.

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Wed Nov 25, 2009 4:14 am
by KlownPosse45
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

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Wed Nov 25, 2009 8:23 am
by vanya_y
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...

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Wed Nov 25, 2009 1:10 pm
by KlownPosse45
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.

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Thu Nov 26, 2009 9:14 am
by cYbercOsmOnauT
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

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Thu Nov 26, 2009 1:00 pm
by KlownPosse45
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.

Re: [3.0.6] Enable Quick Reply in all forums

Posted: Wed Dec 02, 2009 3:02 pm
by enkigur
Hello,

how can I disable this again?