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

$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
}

?>