Announcement

Collapse
No announcement yet.

List forums by threads/posts (SQL Command Even)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • List forums by threads/posts (SQL Command Even)

    Just out of pure interest for my members I would like to list my forums by threads and posts, I would be happy with an SQL command to show me this.

    Thanks
    http://www.TheOlderGamers.com
    Your Mature Gaming Community!

  • #2
    What do you mean exactly?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Simply a listing of forums by popularity.

      So I can list the forums with the most threads ascendingly, the forum with the most posts ascendingly.

      My members would like to know which forums are the most active basically.
      http://www.TheOlderGamers.com
      Your Mature Gaming Community!

      Comment


      • #4
        Try this...
        Code:
        SELECT
            title,
            replycount
        FROM
            forum
        WHERE
            parentid > 0
        ORDER BY
            replycount DESC
        Lats...

        Comment

        Related Topics

        Collapse

        Working...
        X