Results 1 to 3 of 3

Thread: How do I enable/add random news threads?

  1. #1
    Member
    Join Date
    Jan 2006
    Location
    Boston, MA
    Posts
    37

    Default How do I enable/add random news threads?

    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:

    Code:
    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!

  2. #2
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,460

    Default Re: How do I enable/add random news threads?

    Just change that entire line to this:

    ORDER BY RAND()

  3. #3
    Member
    Join Date
    Jan 2006
    Location
    Boston, MA
    Posts
    37

    Default Re: How do I enable/add random news threads?

    Edit: That did it, thanks!

    (problem was corrupt file from my FTP program).

    Much appreciated.
    Last edited by Chris-777; 01-17-2006 at 02:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Random News Thread
    By Gary Bolton in forum "How Do I..." Questions
    Replies: 5
    Last Post: 01-17-2006, 02:40 PM
  2. vBa CMPS edit news threads in news options
    By SNW in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 11-03-2005, 05:27 PM
  3. Single RANDOM news item from specified forum
    By Milorad in forum Add-On Modules & Modifications
    Replies: 10
    Last Post: 04-17-2005, 03:55 PM
  4. Can I do that (random news)
    By hani in forum Troubleshooting / "How do I..." Questions
    Replies: 1
    Last Post: 10-10-2004, 02:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •