• Welcome to Simple Machines Community Forum. Please login or sign up.

topics with 0 reply's

Started by Ralexander, December 28, 2017, 04:58:41 AM

Previous topic - Next topic

Ralexander

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

Kindred

That would be a really expensive query. 
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

br360

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

albertlast

Well the essential query to find all topics where no replay exists,
is not so heavy as you believe:

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.

Advertisement: