<?php

/**
 * returns an array of posts in the given vbulletin thread (if possible)
 *
 * Allows some customization of what is returned.  If zeros are passed
 * for all optional values, the entire thread is returned.
 *
 * @return the page
 */
function _mymodule_get_vbulletin_thread_posts($thread_id,
                                              $num_initial_posts_to_skip = 0,
                                              $max_num_posts_returned = 0,
                                              $max_post_text_length = 0,
                                              $server = "db-your-db.your-domain.com",
                                              $username = "your-forums-username",
                                              $password = "your-db-password",
                                              $database_name = "your-db-name") {
  $posts = array();

  $db = mysql_connect($server, $username, $password);
  if ($db) {
    $sql = "SELECT post.postid AS postid, post.parentid AS parentid, " .
           "       post.username AS username, post.title AS title, " .
           "       post.dateline AS dateline, postparsed.pagetext_html AS pagetext " .
           "FROM `post`, `postparsed` " .
           "WHERE post.postid = postparsed.postid AND post.threadid = %d " .
           "ORDER BY dateline";
    $sql = sprintf($sql, $thread_id);

    if ($max_num_posts_returned > 0) {
      $sql .= " LIMIT %d";
      $sql = sprintf($sql, $max_num_posts_returned + $num_initial_posts_to_skip);
    }

    $num_posts = 0;
    $results = mysql_db_query($database_name, $sql, $db);
    while ($result = mysql_fetch_object($results)) {
      $num_posts++;
      if ($num_posts > $num_initial_posts_to_skip) {
        //  MAKE AN ARRAY FOR THIS FORUM POST.
        //  STORE IT UNDER ITS PARENT, OR AT THE TOP LEVEL IF NONE.
        $posts[] = array(
          'postid' => $result->postid,
          'parentid' => $result->parentid,
          'username' => $result->username,
          'title' => $result->title,
          'dateline' => $result->dateline,
          'pagetext' => $result->pagetext,
        );
      }
    }

    //  NOT STRICTLY NECESSARY, BUT FRIENDLY.
    mysql_close($db);
  }

  return $posts;
}




?>