Announcement

Collapse
No announcement yet.

SQL query tables

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

  • SQL query tables

    Hi,

    I'm looking for sql queries that can fetch info like :

    - user posts including content/body
    - nodes (channels) and sub-nodes(sub-channels)
    - user profile attributes

    Does anyone know the names of these tables?

    Thanks



  • #2
    - node, contenttype, text
    - node, contenttype, channel. In order to get the heirarchy, you need to query the closure table.
    - user, usertextfield, userfield (the last is for custom profile fields)
    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.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X