MyBB Community Forums

Hi,

In my MySQL database I have many posts where users checked post option "disable smilies".

I would like to show all smilies, so I should to use a query to change all, can you tell me the exact query I have to use to avoid disasters in the database (mybb_posts table)?

Just: update mybb_posts set smilieoff=0
Replace "mybb_" with your table prefix

Thank you very much

Please keep in mind that it can be really useful to deactivate smilies for a single post, e.g. when you use specific strings that should not be mis-interpreted.

You'd better off checking those posts with deactivated smilies before running the SQL-Update all over the table.

[ExiTuS]