MyBB Community Forums

Hi,

I have a lot of threads without a default Icon so, did you know a SQL Query for apply a thread Icon ID on each thread without any thread icon?

Thanks.

UPDATE `mybb_threads` SET `icon` = 'X' WHERE `icon` = '' OR `icon` = '0';

Change the X to the ID of the post icon you want to use, which you can find at ACP > Configuration > Post Icons > **choose post icon** > Edit > ID is at the end of the URL.

Thanks Matt.

Take a look here.

nice, thank you