Show number of threads on specific forum in post bit?
#1
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
Reply
#2
it requires a custom plugin [not readily available. if comfortable, you may hire a coder for making it]

--- moved to plugin requests ---
Reply
#3
Hey!

Maybe this can help: https://community.mybb.com/mods.php?acti...w&pid=1322
Reply
#4
(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
Reply
#5
For anyone reading this thread: I made my own plugin for this. Will refine it and upload it in a few days.
Reply
#6
^ good to know that Smile
Reply
#7
Note that fetching this in a per page load could be resource consuming. I would recommend caching such value.
Reply
#8
(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
Reply
#9
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.
Reply
#10
(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');
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)