No announcement yet.

How to Query to list all usernames in a vB5 thread ?

  • Filter
  • Time
  • Show
Clear All
new posts

  • How to Query to list all usernames in a vB5 thread ?

    Hi I have thread with 140 pages and I want to list all usernames who have posted on this thread, because writing down all names one by one takes too much time.

    Pls Help.
    Last edited by emral; Tue 30 Jun '20, 7:53am.

  • #2
    You can try something like: SELECT * FROM node WHERE parentid=XXXXX

    XXXXX would be the nodeid of the topic. However if you allow comments, you'll miss those. A problem with hierarchal node systems is that you don't actually know what needs to be retrieved until you traverse the entire ancestry tree (this is the closure table btw). Hard to do in a single query.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.


    • #3
      Thank you very much, that was what I was looking for.


      Related Topics