Announcement

Collapse
No announcement yet.

extracting forum's posts replies?

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

  • extracting forum's posts replies?

    hi there,

    i'm trying to extract post replies in specific forum from DB
    u use this:
    Code:
    SELECT replycount FROM `vb_forum` WHERE forumid=134
    and it gets the the current value

    but now i want to substract from this value posts made by user X in this forumid=134

    can you help me with the code?

    thanks

    Ross
    Latest Tech News in the World
    Кейс със снимка по поръчка

  • #2
    Get the results from your first query
    And then make a new query where you limit it to just the userid.

    And you then make a php calculation of a-b = c

    Comment


    • #3
      yes but where is located user's posts?
      i mean where are the posts count made by userid=x in forumid=y

      thanks
      Latest Tech News in the World
      Кейс със снимка по поръчка

      Comment


      • #4
        These are questions we can't provide support for, you'll have to ask on vBulletin.org. The tables are linked to eachother because a thread table has first post id, and posts link back to the thread table, and both have userid's etc.

        Comment

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