help w/ a template that calls most recent posts, title, etc.

[BigIke]

I'm doing something similar with my site that www.nymfans.com did with theirs. I'm trying to add a module on top of my site (http://s116946478.onlinehome.us/vb/cmps_index.php) where the latest thread in a specific forum id is shown, and I need help with the template to do so. I know that I need to make a table, but I'm not sure where to put the variables. Can anyone help? Thanks in advance.

(I think i posted this in the wrong forum, I think it should be in modification discussion)

anyone?

[BigIke]

does anyone know? ive posted at every possible vbulletin site but to no avail... i think this could be a quick answer if anyone would take the time to read it

[Jolten]

It's not a quick answer. It requires a php script or modification to one along with templates. Your best bet is to download a portal and look at the code used there.

[BigIke]

i have the actual php script already to do so, all i need help with is the actual template that utilizes the php script.. does that help? it also might be that i dont know what im talking about. but i have a php script that goes something like this:

<?php

/* Needed for use without vBA
require_once('./global.php');
*/

/* ###### VARIOUS SETTINGS ###### */

$box_max_title_length=30;
$box_max_post_length=80;
$box_do_parse=0; /* Set to 1 to parse BBCODE */
$box_attachment_file="http://nymfans.com/forums/attachment.php?";

/* ###### GRABBING DATA ###### */

/* Only needed if you're going to be using bbcode */
if($box_do_parse==1){require_once('./includes/functions_bbcodeparse.php');}

/* Forum to Grab thread/post from */
$box_forumid_1=22;

/* Grabbing the thread */
$box_forumid_1thread = $DB_site->query_first("SELECT * FROM ".TABLE_PREFIX."thread
WHERE forumid = '$box_forumid_1' ORDER BY thread.dateline DESC ");

/* Grabbing the first post */
$box_forumid_1_first_post=$DB_site->query_first("SELECT * FROM ".TABLE_PREFIX."post
WHERE threadid = '$box_forumid_1thread[threadid]' ORDER BY dateline ASC");

/* Grabbing the first attachment */
$box_forumid_1_image=$DB_site->query_first("SELECT * FROM ".TABLE_PREFIX."attachment
WHERE postid = '$box_forumid_1_first_post[postid]' ORDER BY dateline DESC");

$image1=$box_forumid_1_image['attachmentid'];

/* ###### FORMATING DATA ###### */

/* Max title length */
if(strlen($box_forumid_1thread[title])>$box_max_title_length){
$box_forumid_1thread[title]=substr($box_forumid_1thread[title], 0, $box_max_title_length);
}

/* Max post length */
if($box_forumid_1_first_post[pagetext]>$box_max_post_length){
$box_forumid_1_first_post[pagetext]=substr($box_forumid_1_first_post[pagetext], 0, $box_max_post_length);
}

/* Parse BBCODE if desired */
if($box_do_parse==1){
$box_forumid_1_first_post[pagetext]=parse_bbcode($box_forumid_1_first_post[pagetext]);
}

/* IMAGE CREATION */
$box_1_image="<img src='".$box_attachment_file."attachmentid=$img_m&stc=1' width='100' height='100' border='0'/>";

/* Template to use for data */
eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('TEMPLATE_NAME_HERE') . '";');

?>

I have vBAdvanced installed on my forums, I'm just not sure of what coding to put in the template on the top module.