View Single Post
  #5  
Old 03-03-2002, 10:42 PM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

use this:
PHP Code:
<?php
error_reporting
(7);

$templatesused "home_reviews,home_mainpage";

chdir("/home/path/to/web/forum");
require(
"./global.php");

$reviews="1";
$reviewposts="3";

$newsql=$DB_site->query("SELECT * FROM thread WHERE forumid='$reviews' ORDER BY dateline DESC LIMIT $reviewposts");
while (
$new=$DB_site->fetch_array($newsql)) {
  
$newthreadid=$new[threadid];
  
$newtitle=$new[title];

  
$getnewsql=$DB_site->query_first("SELECT * FROM post WHERE threadid='$newthreadid' ORDER BY postid ASC LIMIT 1");
  
$newtime=vbdate($timeformat,$new[dateline]);
  
$newdate=vbdate($dateformat,$new[dateline]);
  
$newpagetext=$new[pagetext];
  
$newpagetext=bbcodeparse($newpagetext);

  eval(
"\$newthisweek .= \"".gettemplate('home_reviews')."\";");
}

eval(
"dooutput(\"".gettemplate('home_mainpage')."\");");
?>
this will call the first post only of a specific thread. the code is self explanatory.
NOTE: $reviews is the forum ID you want to pull the info from, and $reviewposts is the no. of posts you want to pull from.
in this way you can have a custom template to show where ever you want it in your website

you could also make the forum invisible so it will not show on the forums list. the script will still pull the info.

regards,
nakkid.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01255 seconds
  • Memory Usage 1,780KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete