php vbulletin help

Discussion in 'PHP' started by Lpspider, Dec 5, 2007.

  1. #1
    I'm using the current php code to get content from my database and display on my page. I'm using vbulletin software.

    What I'd like to do, however, is alter this code to make it so it continues to only display posts from a particular forum, but also only shows posts that haven't been responded too.

    i messed with this a bit and simply couldn't get it. If someone would be so kind to help me out I would greatly appreciate it.

    <?php
    
    
    // Connect to the database server
    $dbcnx = @mysql_connect('localhost', 'database', 'pass');
    if (!$dbcnx) {
    die( '<p>Unable to connect to the ' .
    'database server at this time.</p>' );
    }
    
    // Select the database
    if (! @mysql_select_db('database') ) {
    die( '<p>Unable to locate  ' .
    'database at this time.</p>' );
    }
    ?>
    
    
    
    <?php
    // Request the text
    $result = @mysql_query("SELECT p.userid,postuserid,lastposter,t.title,t.threadid AS threadid,p.pagetext AS pagetext
    												FROM wfthread t
    												left join wfpost p 
    
    on(p.postid=t.firstpostid)
    where forumid in(14,15,24,34,7,71,5)
    
                            order by lastpost DESC 
                            LIMIT 0,10 ");
                            
    if (!$result) {
    die('<p>Error performing query: ' . mysql_error() .
    '</p>');
    }
    
    
    while ( $row = mysql_fetch_array($result) ) {
    
                   
    
    echo('<a href="showthread.php?threadid=' . $row['threadid'] . '&goto=lastpost"> ' . $row['title'] . '</a><br>by ' . $row['lastposter'] . '<br><br>');
    }
    
    ?>
    Code (markup):
    Thanks in advance.
     
    Lpspider, Dec 5, 2007 IP
    Brandon Sheley likes this.
  2. Lpspider

    Lpspider Well-Known Member

    Messages:
    2,216
    Likes Received:
    56
    Best Answers:
    0
    Trophy Points:
    160
    #2
    Anyone at all?
     
    Lpspider, Dec 8, 2007 IP