How do I enable/add random news threads?

[Chris-777]

There's another post on this, but in the 3.0 forum.

On 3.5.3, I'd like to get the news module to pull random threads from the forum that I use for new posts.

I believe this is the query in news.php:

ORDER BY " . iif($mod_options['portal_news_sticky'], 'sticky DESC,') . iif($mod_options['portal_news_orderby'] == 'postdateline', 'dateline', $mod_options['portal_news_orderby']) . " $mod_options[portal_news_direction]

Just not entirely sure how/what to change. Thanks!

[Brian]

Just change that entire line to this:

ORDER BY RAND()

[Chris-777]

Edit: That did it, thanks!

(problem was corrupt file from my FTP program).

Much appreciated.