vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Latest Posts on Forum Home (https://vborg.vbsupport.ru/showthread.php?t=110681)

PyroNET 03-17-2006 08:15 PM
Latest Posts on Forum Home
 
Hello.

I am trying to display the poster, threadid, and thread title of the latest post (not thread)

At the moment I have the following in a plugin set for the parse_templates hook

PHP Code:
$posts = $db->query("
    SELECT post.postid, post.username, thread.title, thread.threadid 
    FROM ". TABLE_PREFIX ."post 
        LEFT JOIN ". TABLE_PREFIX ."thread ON(thread.threadid = post.threadid) WHERE thread.visible IN (0,1,2) ORDER BY post.dateline DESC LIMIT 15
    ");

while ($posts2 = $db->fetch_array($posts)) {

$hiccup .= "<img class=\"inlineimg\" src=\"$stylevar[imgdir_button]/lastpost.gif\" alt=\"\" border=\"0\" /> <a href=\"showthread.php?$session[sessionurl_q]t=".$posts2[threadid]."\">".$posts2[title]."</a> (Posted by ".$posts2[username].")<br />";

} 
I would like to know how to change this so that it:
a.) Only displays gets the latest posts from forums that a guest would be able to view
b.) Doesn't show a thread more than once in the list... If the query returns more than one result from the same thread, they are collapsed into one with the poster of the latest post in that thread listed.

Any help appreciated.


All times are GMT. The time now is 02:19 AM.

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.00995 seconds
  • Memory Usage 1,714KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)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