Announcement

Collapse
No announcement yet.

thread count in certain forums?

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

  • thread count in certain forums?

    Can i find out how many threads (not reply posts) a user has made in certain forums at all?


    thanks...

  • #2
    There is no direct way to do this. You would have to run queries on the database to get the information.

    SELECT count(*) FROM prefix_thread WHERE forumid=XX AND postuserid = YY

    Replace prefix_ with the table prefix defined in your config.php. Replace XX with the forum's id and YY with the user's id. You would have to rerun the query for each forum and user that you want the information for.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Thanks for that that will do the trick ....

      Comment


      • #4
        what if we want more than one forum id? please help

        Comment


        • #5
          # replace what is needed and X,Y,Z with forom identification number.
          SELECT count(*) FROM prefix_thread WHERE forumid IN (X,Y,Z) AND postuserid = YY

          Comment

          Loading...
          Working...
          X