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

* Navigator

Expand - Collapse

* Statistic


  • *Total Posts: 16430
  • *Total Topics: 2522
  • *Online Today: 5
  • *Most Online: 292
(12. Nov 2016, 09:37:31)
  • *Users: 0
  • *Guests: 0
  • *Spiders: 1
  • *Total: 1

  • *Google

* Calendar

Mo
Tu
We
Th
Fr
Sa
Su
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Most Ppopular Post Block

Started by forfun, 12. Apr 2011, 01:00:26

previous topic - next topic

0 Members and 0 Guests are viewing this topic.

forfun

12. Apr 2011, 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
12. Apr 2011, 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
18. Apr 2011, 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
18. Apr 2011, 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
23. Apr 2011, 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.