Simple Machines Community Forum

SMF Development => Feature Requests => Topic started by: Ralexander on December 28, 2017, 04:58:41 AM

Title: topics with 0 reply's
Post by: Ralexander on December 28, 2017, 04:58:41 AM
I did google it but could not find a mod for finding topics with an amount of reply's.
I want to find all started topics without any reply... and it would be great if  I could find topics with 1, 2, 3 and so on reply's.

If it not exist, I would like this feature.
If it exist, can you please show me this mod / feature.

Thanks
Alex
Title: Re: topics with 0 reply's
Post by: Kindred on December 28, 2017, 02:30:54 PM
That would be a really expensive query. 
Title: Re: topics with 0 reply's
Post by: br360 on December 28, 2017, 06:31:43 PM
Take into consideration what Kindred said, but here is a mod that may do what you want- (only topics with zero replies though )

https://custom.simplemachines.org/mods/index.php?mod=4088
Title: Re: topics with 0 reply's
Post by: albertlast on December 29, 2017, 07:40:11 AM
Well the essential query to find all topics where no replay exists,
is not so heavy as you believe:
Code: [Select]
select st.id_topic
from smf_topics st
where st.id_first_msg = st.id_last_msg

Tested under smf 2.1,
when you need this information often you could add an index a cross the two fields.