Show number of threads on specific forum in post bit?
(2020-02-23, 01:36 PM)Crazycat Wrote:
(2020-02-23, 01:10 PM)LouisRep Wrote: Thanks guys, uploaded it here:

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

Thank you very much! This is the kind of feedback I was hoping for. Will look into it when I find the time Smile

Forum Jump:

Users browsing this thread: 1 Guest(s)