Advertisement:

Author Topic: topics with 0 reply's  (Read 21017 times)

Offline Ralexander

  • Newbie
  • *
  • Posts: 1
topics with 0 reply's
« 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

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 55,262
  • Gender: Male
    • Kindred-999 on GitHub
Re: topics with 0 reply's
« Reply #1 on: December 28, 2017, 02:30:54 PM »
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.

Offline br360

  • Lead Support Specialist
  • SMF Hero
  • *
  • Posts: 2,084
    • GenXcommunity
Re: topics with 0 reply's
« Reply #2 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

Offline albertlast

  • Development Contributor
  • Jr. Member
  • *
  • Posts: 196
Re: topics with 0 reply's
« Reply #3 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.