vb.org Archive - Last new posts

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

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Last new posts (https://vborg.vbsupport.ru/showthread.php?t=57003)

lasto

09-12-2003 02:01 PM

Last new posts

i want to show the last 20 posts made on the forum on a seperate page does anyone have an idea on how to do this ??

assassingod

09-12-2003 02:30 PM

I think it will be something like this.

PHP Code:


		
			
<?php

error_reporting(7);

require('./global.php');



$latestthread=$DB_site->query_first("SELECT title,threadid,dateline FROM thread ORDER BY dateline desc LIMIT 20");



    echo ("Latest 20 threads: <br /> <a href=\"showthread.php?s=$session[sessionhash]&amp;threadid=$latestthread[threadid]\">$latestthread[title]</a>");





?>

Untested, should work. If it doesn't, i'll look further into it

lasto

09-12-2003 03:14 PM

u nearly there m8

i get a Warning: Cannot modify header information - headers already sent by (output started

then it shows one new post underneath it

lasto

09-12-2003 03:17 PM

ok i took out the error reporting bit

and no error now but it only shows one post still

assassingod

09-12-2003 03:31 PM

Try

PHP Code:


		
			
<?php 

error_reporting(7); 

require('./global.php'); 



$latestthread=$DB_site->query_first("SELECT title,threadid,dateline FROM thread ORDER BY dateline DESC LIMIT 20"); 



    echo ("Latest 20 threads: <br /> <a href=\"showthread.php?s=$session[sessionhash]&amp;threadid=$latestthread[threadid]\">$latestthread[title]</a>"); 





?>

lasto

09-12-2003 03:36 PM

same m8

no error but only one latest thread/post is showing

NTLDR

09-12-2003 03:49 PM

$DB_site->query_first() will only return one result, no matter now may rows you tell it to fetch from the DB. You need to use $DB_site->query() and use $DB_site->fetch_array() in a while loop to get more than one item from the DB.

assassingod

09-12-2003 04:46 PM

Quote:

Originally Posted by NTLDR

Duh, I am an idiot :rolleyes: Thanks Lee

It should be this

PHP Code:


		
			
<?php

error_reporting(7);

require('./global.php');



$latestthread=$DB_site->query("SELECT title,threadid,dateline FROM thread ORDER BY dateline DESC LIMIT 20");

    while ($latestthreads=$DB_site->fetch_array($latestthread)) {

    echo ("<a href=\"$bburl\showthread.php?s=$session[sessionhash]&amp;threadid=$latestthreads[threadid]\">$latestthreads[title]</a><br /> ");

}



?>

lasto

09-12-2003 05:02 PM

works perfect :)

can i use <smallfont> in a php file to make text a lot smaller ?
also thanks to assassingod and NTLDR

lasto

09-12-2003 05:05 PM

sorry one final question

i knwo u helped enough but the above is fine but it only gets new threads dont it,how can i do the exact same but for posts.

assassingod

09-12-2003 09:02 PM

You can probably use the smallfont tag yes.

As for posts, I'll look into it

assassingod

09-12-2003 09:09 PM

Use this:

PHP Code:


		
			
<?php

error_reporting(7);

require('./global.php');



$latestthread=$DB_site->query("SELECT title,threadid,lastpost FROM thread ORDER BY lastpost DESC LIMIT 20");

    while ($latestthreads=$DB_site->fetch_array($latestthread)) {

    echo ("<a href=\"$bburl\showthread.php?s=$session[sessionhash]&amp;threadid=$latestthreads[threadid]\">$latestthreads[title]</a><br /> ");

}



?>

lasto

09-12-2003 10:50 PM

cheers assassingod i have suzzed the posts out by ripping it out of another hack :)

i still cant get em to show in me frame in small font - it still shows em as big text even though ive used the <smallfont> command which looks untidy as i have it in an iframe and posts stretch over to 2 lines

assassingod

09-12-2003 11:02 PM

The code I posted above works perfectly for new posts;)

If smallfont doesnt work, youll have to use

Code:

<font size=\"2\"><a href=\"$bburl\showthread.php?s=$session[sessionhash]&amp;threadid=$latestthreads[threadid]\">$latestthreads[title]</a></font>

All times are GMT. The time now is 03:53 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01094 seconds Memory Usage 1,755KB 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_code_printable (4)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (14)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
Messages: