In the discuss system settings, there is a value for "Enable Hot Threads" and also "Sticky" threads. I want to know more about how to implement them. The documentation is a little sparse on this issue.
We already have a tool kindly provided by mintnl to push contents (in that case, recent posts) onto other pages, and that tool should work for multiple database calls. There also should be other calls that are interesting, like most comments, most views, and so on. Its just database calls, right?
I did find this info about the database of discuss:
replies integer (10) Amount of replies on the thread.
views integer (10) Amount of views on the thread.
This looks very much like what I want, to be able to serve up on my front page a short list of the threads with most replies and with most views. But what would the code look like?
EDIT: Here is the link to the intro to the discuss db:
http://rtfm.modx.com/extras/revo/discuss/discuss.database-model and here is the whole db schema, which should hold the answer to this question
https://github.com/modxcms/Discuss/blob/develop/_build/schema/discuss.mysql.schema.xml
[ed. note: nuan88 last edited this post 9 years, 10 months ago.]
