To use this website completely, it is necessary to store cookies on your computer.
 

* Statistic

  • *Total Posts: 16418
  • *Total Topics: 2549
  • *Online Today: 10
  • *Most Online: 292
(2016 November 12, 09:37:31)
  • *Users: 0
  • *Guests: 0
  • *Spiders: 2
  • *Total: 2

  • *Baidu (2)

Most Ppopular Post Block

Started by forfun, 2011 April 12, 01:00:26

previous topic - next topic

0 Members and 0 Guests are viewing this topic.

forfun

2011 April 12, 01:00:26
It would be nice, if we have a "most Popular Posts" block.
Please inform if it is exist, and whenever it becomes available.
Thanks much in advanced

feline

#1
2011 April 12, 13:25:52
What you mean with "Most popular Posts" ?
Many are stubborn in relation to the path, a few in relation to the target.

forfun

#2
2011 April 18, 04:29:45
What I am looking for is the block that will show all the posts that have the most replies from all ,or selected boards.
I hope this will make some sense.
Thanks MUCH in advanced

feline

#3
2011 April 18, 17:07:15
You can try a query like this:

SELECT m.subject, t.id_topic, b.name, m.id_board, m.id_msg, t.num_replies
FROM smf_topics AS t
LEFT JOIN smf_messages AS m ON (t.id_first_msg = m.id_msg)
LEFT JOIN smf_boards AS b ON (b.id_board = t.id_board)
WHERE t.id_board IN (
list of board id's )
ORDER BY t.num_replies DESC
LIMIT
max entries you will see
Many are stubborn in relation to the path, a few in relation to the target.

forfun

#4
2011 April 23, 06:41:33
Thanks for your effort, Feline!
But I have NO knowledge about programming, so I guess I have to wait until someone create a block like this (as a feature in Vbullletin board), then I can use.
My wish is you will add it into the next PortaMx version.