MyBB Community Forums

Full Version: Show number of threads on specific forum in post bit?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
I want to show the number of threads a user has in a specific subforum in the user's postbit. How would I do this?

Edit: Made a simple version: https://community.mybb.com/mods.php?acti...w&pid=1342
it requires a custom plugin [not readily available. if comfortable, you may hire a coder for making it]

--- moved to plugin requests ---
(2020-02-07, 02:29 AM)Xalysis Wrote: [ -> ]Hey!

Maybe this can help: https://community.mybb.com/mods.php?acti...w&pid=1322

Thank you. I'll see if I can rewe some code to fit my purposes
For anyone reading this thread: I made my own plugin for this. Will refine it and upload it in a few days.
^ good to know that Smile
Note that fetching this in a per page load could be resource consuming. I would recommend caching such value.
(2020-02-15, 11:10 PM)LouisRep Wrote: [ -> ]For anyone reading this thread: I made my own plugin for this. Will refine it and upload it in a few days.

This is good to hear Smile
+rep
Thanks guys, uploaded it here: https://community.mybb.com/mods.php?acti...w&pid=1342

This is my first php project, so feedback is welcome.
(2020-02-23, 01:10 PM)LouisRep Wrote: [ -> ]Thanks guys, uploaded it here: https://community.mybb.com/mods.php?acti...w&pid=1342

This is my first php project, so feedback is welcome.

I had a look to your plugin, I think you can optimize a little bit.
In count_threads, your query retrieve everything from threads table... Could be heavy. You can just get "tid" field, or better directly get the count.:
$query = $db->write_query("SELECT COUNT(DISTINCT(tid)) AS nbtid FROM ".TABLE_PREFIX."threads WHERE uid=$uid AND fid=$fid AND visible=1");
$threadCount = $db->fetch_field($query, 'nbtid');
Pages: 1 2