vb.org Archive - Last X Threads From A Particular Forum On Non-VB Page

Page 3 of 5

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

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Last X Threads From A Particular Forum On Non-VB Page (https://vborg.vbsupport.ru/showthread.php?t=62823)

palosanto

04-20-2004 11:07 PM

Quote:

Originally Posted by ga.net

$forum_id = "9"; // If you wish to display the posts from a specific forum, enter the forum id here. Otherwise, leave it blank

I left it blank but I get an error. Hows this?

I have the same error if I don't write 9. And if I write 0 or other number it does't work. :surprised:

Actually I have in my test index2.php it working but I only see the last 10 of a particular subforum (number9) NOT ALL THE MESAGES IN general. I don't understand

This is a bug or no?

Any idea?

Regards:

Palosanto :ermm:

Charlie Argueta

04-21-2004 03:13 PM

Where did you used the "tid" after all? this could be the problem of the hack.

See Ya

Jannefant

05-03-2004 07:44 PM

Quote:

Originally Posted by Anne Lise

Me too:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/barnemix/public_html/lastthreads3.php on line 41

Try to edit Line 41

Code:

$tsql = mysql_query("SELECT threadid,title,lastpost,postusername FROM thread WHERE forumid=$forum_id ORDER BY threadid DESC LIMIT $limit");

FROM thread must be modify to yourprefix_thread if you use a prefix

Fragpoint

05-09-2004 02:24 PM

I receive only an blank screen, no errors: http://www.fragpoint.de/lastthreads3.php
Why? Plz help.

I have changed this:

Code:

$tsql = mysql_query("SELECT threadid,title,lastpost,postusername FROM thread WHERE forumid=$forum_id ORDER BY threadid DESC LIMIT $limit");

to this:

Code:

$tsql = mysql_query("SELECT threadid,title,lastpost,postusername FROM vb3_thread WHERE forumid=$forum_id ORDER BY threadid DESC LIMIT $limit");

and i have changed this:

Code:

$psql = mysql_query("SELECT postid FROM post WHERE threadid=$tid ORDER BY postid ASC");

to this:

Code:

$psql = mysql_query("SELECT postid FROM vb3_post WHERE threadid=$tid ORDER BY postid ASC");

gwon	06-22-2004 04:06 PM

working well for me thanks :)

live @ http://www.somethingboring.com

hollyboy

06-25-2004 03:04 PM

Quote:

Originally Posted by Anne Lise

Me too:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/barnemix/public_html/lastthreads3.php on line 41

I get the same error

hollyboy

06-26-2004 09:59 AM

how can this hack be in the realeased forum when it doesn't work?

Johnny

08-12-2004 03:18 PM

Quote:

Originally Posted by palosanto

anyone know how to fix this error

aberg

08-13-2004 09:26 PM

Also this error, but i try it on version 3.0.3
So who knows the solution for this problem???

boiboi

08-14-2004 11:45 AM

doesn't work for me. shows the wrong time. my server is in pacific time and the forum is offset to +8. the hack always follow the server time.

All times are GMT. The time now is 07:05 AM.

Page 3 of 5

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01145 seconds Memory Usage 1,739KB 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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: