vb.org Archive - Feed latest topics onto a non vb page

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Feed latest topics onto a non vb page (https://vborg.vbsupport.ru/showthread.php?t=117649)

Thug	06-04-2006 08:51 PM

Feed latest topics onto a non vb page

hi
how would i Feed latest topics onto a non vb page

thanx
eg
www.ukmusic.com bottom right corner

sambah

06-05-2006 01:26 AM

Code:

$result = mysql_query("SELECT * FROM teensay_vbboardscurrent.thread WHERE forumid!=59 AND forumid!=62 ORDER BY 'threadid' DES$



        $count = 0;



        while ($row = mysql_fetch_array($result)) {

                $count++;

                ( (is_float($count/2)) ? $color = '#E8F2FF' : $color='#C1DCFF' );

                $tpl->assign('ht_bg', $color);

                $tpl->assign('ht_id', $row['threadid']);

                $tpl->assign('ht_title', $row['title']);

                $tpl->assign('ht_name', $row['lastposter']);

                $tpl->assign('ht_date', date("d.m.y h:i:s",$row['lastpost']));

                $hottopics .= $tpl->parse($templatepath.'/home/hottopics_template.html');

        }



        $ch .= '</table>';

Should work for you :)

Thug	06-05-2006 05:36 AM

m.. lookin for more help as i wudnt no where to put thid

WEBDosser

06-05-2006 07:23 AM

Quote:

Originally Posted by sambah

Code:

$result = mysql_query("SELECT * FROM teensay_vbboardscurrent.thread WHERE forumid!=59 AND forumid!=62 ORDER BY 'threadid' DES$



        $count = 0;



        while ($row = mysql_fetch_array($result)) {

                $count++;

                ( (is_float($count/2)) ? $color = '#E8F2FF' : $color='#C1DCFF' );

                $tpl->assign('ht_bg', $color);

                $tpl->assign('ht_id', $row['threadid']);

                $tpl->assign('ht_title', $row['title']);

                $tpl->assign('ht_name', $row['lastposter']);

                $tpl->assign('ht_date', date("d.m.y h:i:s",$row['lastpost']));

                $hottopics .= $tpl->parse($templatepath.'/home/hottopics_template.html');

        }



        $ch .= '</table>';

Should work for you :)

how would this work?.. looks like it not even part of vBulletin.

sambah

06-05-2006 07:31 AM

Quote:

Originally Posted by Thug

m.. lookin for more help as i wudnt no where to put thid

Obviously you need to change the sql query line:

Code:

$result = mysql_query("SELECT * FROM yourdbname.thread WHERE forumid!=59 AND forumid!=62 ORDER BY 'threadid' DES$

The bolded parts need changed:

yourdbname needs to be your forums database name

The forum ID numbers are just forumid's that you dont want to display in the latest posts eg. staffroom, debug, etc

You'll also need to include a config.php file or something with your db details in it

Also thats just the code needed. you'll need to stick it in the design yourself :)

Thug	06-05-2006 08:31 AM

im to lost to doit sorry but im a newbie so i need it to be like a hack with instructions lol

SaintDog

06-07-2006 05:34 AM

It really depends on what specifically your looking to pull and how you want the information pulled. The above doesn't make use of vBulletin's coding directly or allow you open modification from the template system (which would ease how you display the data).

Insert the following into your PHP file.

PHP Code:


		
			
$getthreads = $vbulletin->db->query_read("

    SELECT * FROM thread

    WHERE forumid = ''

    LIMIT 5

    ORDER BY threadid

    DESC

    ");



    while ($threads = $vbulletin->db->fetch_array($getthreads))

    {

        $dateposted = vbdate('m-d-Y', $news['postdateline']);



        eval('print_output("' . fetch_template('latest_thread_display') . '");');

    }

Then, create a new template through the vBulletin Admin Control Panel named 'latest_thread_display' (without quotes) and insert the following:

Code:



$thread[title]

<br />

Posted By: $thread[postusername]

<br />

Posted On: $dateposted

<br />

<br />

The above MySQL Query will pull the last 5 threads from the database and use the 'latest_thread_display' template as the acting template to display the data.

To use the above, however, you will need to include global.php within your PHP file, as noted below, else the functions will not...function :).

PHP Code:


		
			
require_once('./global.php');

Thug	06-07-2006 08:47 PM

this is what my file looks like and get error on
http://www.globalvibez.com/test.php

PHP Code:


		
			
<?php
   chdir('/home/global/public_html/forum'); 
   require_once('/home/global/public_html/forum/global.php');  
?>


<?php
$getthreads = $vbulletin->db->query_read("
    SELECT * FROM thread
    WHERE forumid = ''
    LIMIT 5
    ORDER BY threadid
    DESC
    ");

    while ($threads = $vbulletin->db->fetch_array($getthreads))
    {
        $dateposted = vbdate('m-d-Y', $news['postdateline']);

        eval('print_output("' . fetch_template('latest_thread_display') . '");');
    }  


?>

$thread[title]

Posted By: $thread[postusername]

Posted On: $dateposted

SaintDog

06-08-2006 01:14 AM

Ok, here's what you need to do :-).

Create a PHP file called testing.php and insert the following inside (verbatim)

PHP Code:


		
			
<?php



require_once('path/to/global.php');



$getthreads = $vbulletin->db->query_read("

    SELECT * FROM thread

    WHERE forumid = ''

    LIMIT 5

    ORDER BY threadid

    DESC

    ");



    while ($threads = $vbulletin->db->fetch_array($getthreads))

    {

        $dateposted = vbdate('m-d-Y', $news['postdateline']);



        eval('$threaddisplay .= "' . fetch_template('custom_latest_thread_display') . '";');

    }



eval('print_output("' . fetch_template('custom_index') . '");');



?>

Via the AdminCP create a New Template within your vBulletin Style named 'custom_index' (without the quotes) and add to it the following:

Code:

$threaddisplay

Now create a new template called 'custom_latest_thread_display' (again, without the quotes) and insert the following into it.

PHP Code:


		
			
$thread[title]

<br />

Posted By: $thread[postusername]

<br />

Posted On: $dateposted

<br />

<br />

You need to change the path to global.php to your corresponding path. If you are on a CPanel based server (i.e. you can login to your control panel via domain.com/cpanel), then you need to use /home/cpanelusername/public_html/forum/global.php.

Let me know if this works for you. If not, I will create a file for you myself and help you as much as I can given my free time :).

noppid

06-08-2006 01:40 AM

Put javascript on the html page and pull your latest threads from your external.php.

Latest vBulletin Threads on HTML Pages with Javascript.

The file is a freebie. Use it as is or feel free to borrow from it.

All times are GMT. The time now is 10:09 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01162 seconds Memory Usage 1,766KB 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 (5)bbcode_code_printable (5)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: