vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Get New Posts ... (https://vborg.vbsupport.ru/showthread.php?t=117472)

saxonian 06-02-2006 07:18 PM
Get New Posts ...
 
I'm trying to get the top five new posts for public viewing on an external page, It won't have any constant connection to my board (for the exception of getting the info about the latest posts. To start, I am playing about with phpMyAdmin to get the newest 5 posts

HTML Code:
SELECT *
FROM vb3_thread INNER JOIN vb3_user on vb3_thread.lastposter = vb3_user.username
INNER JOIN vb3_post ON vb3_post.threadid = vb3_thread.threadid
INNER JOIN vb3_forum ON vb3_forum.forumid = vb3_thread.forumid
GROUP BY vb3_thread.threadid
ORDER BY vb3_thread.lastpost DESC
LIMIT 0, 5
This does as I want, but I am unsure how to modify this so it won't show threads from private forums, i.e. only show items from forums in which the public (non-registered users) can see.

If someone could point me in the right direction that would be great.

Thanks all

Edit: OK, I sorta know what I want to happen, but if someone can tell me how to interpret the forum permission string that would be great.

xXSesshomaruXx 06-03-2006 03:59 PM
try playing around with vBExternal... it allows you to choose the forum id you'd like to display


All times are GMT. The time now is 06:16 PM.

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.01519 seconds
  • Memory Usage 1,706KB
  • 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_html_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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