vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Pulling threads and displaying elsewhere (https://vborg.vbsupport.ru/showthread.php?t=119806)

davidw 06-28-2006 02:37 PM
Pulling threads and displaying elsewhere
 
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 06-28-2006 04:49 PM
Is it a public forum ? What do you mean by 'editable' threads (open ?)

davidw 06-28-2006 06:08 PM
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 06-28-2006 07:51 PM
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 06-28-2006 09:25 PM
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 06-30-2006 12:48 PM
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
    } 

?>


All times are GMT. The time now is 11:33 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01862 seconds
  • Memory Usage 1,742KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete