MyBB Community Forums

Full Version: Count classic postbit and linear thread mode?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Is there a way to count the numbers of users using classic postbit mode, and linear thread mode?

I know the SQL values for these are classicpostbit and threadmode, but i want to count the users. It'll help me make decisions for my theme.

Thank you Smile
My apologies if i didn't use the prefix [How to?] properly. It is my belief that this is to ask for a how to (or also to give a how to). I notice my post has gotten a lot of views (though still no answer, sadly). I didn't intend to mislead people into thinking this is a howto.

However, i do feel this is a useful question, so if anyone knows the answer, don't hesitate!
SELECT COUNT(threadmode) AS number  FROM `mybb_users` 
WHERE threadmode='linear'

SELECT COUNT(classicpostbit) AS number  FROM `mybb_users` 
WHERE classicpostbit='1'
Thank you very much. That did the trick!

Marked as Solved.