vb.org Archive - how display posts only one forum ?

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

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

- - how display posts only one forum ? (https://vborg.vbsupport.ru/showthread.php?t=152394)

roxxx

07-16-2007 07:50 AM

how display posts only one forum ?

how display posts only one forum ?

How will be query ?

nexialys

07-16-2007 11:25 AM

hum, you'll have to be clearer on this one, and use a basic english language... translation engines are horrible with small sentences.

roxxx

07-16-2007 12:51 PM

example: Programming Discussions
how display use query last 10 posts (post not thread) with Programming Discussions ?

nico_swd

07-16-2007 05:23 PM

PHP Code:


		
			
"SELECT * FROM ". TABLE_PREFIX ."post WHERE forumid = xx AND visible = 1"

roxxx

07-16-2007 06:38 PM

yes, I tried same, but

forumid field is not into tables post :(

nico_swd

07-16-2007 06:52 PM

I see. And...

PHP Code:


		
			
"SELECT
    post.*
FROM
    ". TABLE_PREFIX ."thread AS thread,
    ". TABLE_PREFIX ."post AS post
WHERE
    thread.forumid = XX AND
    post.threadid = thread.threadid AND
    post.visible = 1
GROUP BY
    post.postid
LIMIT
    10"

roxxx

07-17-2007 10:38 AM

thank you

Eikinskjaldi

07-17-2007 11:34 PM

that query wont show the latest 10.

You will need to add an order by post.dateline (or postid, I guess) desc at the end. Also, you should use join to join tables, not where

PHP Code:


		
			
"SELECT post.*
FROM ". TABLE_PREFIX ."thread AS thread,
JOIN ". TABLE_PREFIX ."post AS post
USING (threadid)
WHERE
    thread.forumid = XX AND
    post.visible = 1
ORDER BY
    post.postid DESC
LIMIT
    10"

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01139 seconds Memory Usage 1,721KB 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 (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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: