Pulling threads and displaying elsewhere

[davidw]

While I'm working on a project, I'm fixing to start on another. What I need to do is pull the latest x threads from forum y.

For example: I want to say let me display the last 3 or 6 (editable) threads from forum 103 (aka http://www.yoursite.com/forumdisplay.php?f=73).

How should I best approach this?

[Paul M]

Is it a public forum ? What do you mean by 'editable' threads (open ?)

[davidw]

It is a public forum, but I was just using that as an example. Editable meaning that it can be controlled eventually by the admincp. I want to be able to put put in 3, 4, or 5, latest threads to be chosen and to be able to change this at a later time.

[Paul M]

If it's a publicly viewable forum then just a bit of PHP to run an SQL Select

(Select * from thread where forumid = 123 order by dateline desc limit 5)

Then more php to loop through the resulting data displaying the thread information as required.

You can create a couple of settings in vbulletin options for the forumid and limit, then use them in the php so you can change the values in your acp.

[davidw]

Ok, thanks I figured it would be something like that - seems easy enough anyways. I'll play around with this next week or after that when I can get to work on it.

[davidw]

Ok, two more questions...
(I was gonna start on this next week but decided to start earlier).

1. How do I pull the title from the forumid? (eg. the forum's title) -
2. How do I pull the post from the threadid?

Here's my work in progress...

PHP Code:

<?php

        $forumid1=73;
        $desclimit1=3;
        $titlelen1=22;
        
//        $forumid2=53;
//        $desclimit2=3;
//        $titlelen1=22;

//        $forumid3=67;
//        $desclimit3=3;
//        $titlelen3=22;

//        $forumid4=71;
//        $desclimit4=3;
//        $titlelen4=22;

//        $forumid5=66;
//        $desclimit5=3;
//        $titlelen5=22;

//        $forumid6=69;
//        $desclimit6=3;
//        $titlelen6=22;

//        $forumid7=68;
//        $desclimit7=3;
//        $titlelen7=22;

//        $forumid8=70;
//        $desclimit8=3;
//        $titlelen8=22;

//        $forumid9=;
//        $desclimit9=3;
//        $titlelen9=22;

//        $forumid10=;
//        $desclimit10=3;
//        $titlelen10=22;

$news1=mysql_query("
        SELECT *
        FROM ".TABLE_PREFIX."thread
        WHERE forumid='$forumid1'
        ORDER BY dateline
        DESC LIMIT='$desclimit1'
        ") or die(mysql_error());

// Return title, replycount, postusername, last poster, views, date

$newstitle1            =    $news1['title'];
$newsdate1            =    $news1['date'];
$newstime1            =    $news1['time'];
$newsreplycount1    =    $news1['replycount'];
$newsviews1            =    $news1['views'];
$newspostusername1    =    $news1['postusername'];
$newslastposter1    =    $news1['lastposter'];
$newspost1            =    $news1['post'];

// Create link to full article

while ( $row = mysql_fetch_array ( $news1 ) ) 
    {
        ?><table align="center">
            <tr>
                <td align="left" width="550"><?php print $newstitle1; ?></td>
                <td align="right" width="80"><?php print $newsdate1; ?><br /></td>
                <td align="right" width="70"><?php print $newstime1; ?><br /></td>
            </tr>
            <tr>
                <td colspan="3" align="left"><?php print $newspost1; ?></td>
            </tr>
            <tr>
                <td align="left" width="300">Last Posted By:<?php print $newslastposter1; ?></td>
                <td align="right" width="200">Views:<?php print $newsviews1; ?><br /></td>
                <td align="right" width="200">Replies:<?php print $newsreplycount1; ?><br /></td>
            </tr>
        </table><?php
    } 

?>