MyBB Community Forums

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

Hey!

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

(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

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
+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');