[3.0.6] Enable Quick Reply in all forums

[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!

[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

[DBpbg]

It works! Thank you for the fast help.

[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'

[malaxpina]

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.

[KevC]

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.

[malaxpina]

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]

Didn't work for me. Any thoughts?

[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.

[KlownPosse45]

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]

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]

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.

[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

[KlownPosse45]

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]

Hello,

how can I disable this again?