bigike
03-23-2005, 10:27 PM
I have a php script which calls the most recent thread, author and first x number of words from a forum, but I am not sure what to put in the template, which "houses" the script. Here is the php script:
<?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') . '";');
?>
Here is the template I have, but I am not sure what variables to put in it to display the things pulled from the php script:
<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="90%">
<tr>
<td class="tcat">
<strong><span class="smallfont">$vba_options[portal_blockbullet] $vboptions[bbtitle] Features</strong></span>
</td>
</tr>
</table>
<table align="center" border="0" cellpadding="0" cellspacing="$stylevar[cellspacing]" class="tborder" width="90%" height="150">
<tr>
<td class="alt1">
<div align="center">$box_forumid_1thread</div>
</td>
</tr>
</tbody>
</table>
Any help would be GREATLY appreciated, because no one has been able to help me so far. Noppid has been the only one to give me useful tips over at vBulletin.org.
<?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') . '";');
?>
Here is the template I have, but I am not sure what variables to put in it to display the things pulled from the php script:
<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="90%">
<tr>
<td class="tcat">
<strong><span class="smallfont">$vba_options[portal_blockbullet] $vboptions[bbtitle] Features</strong></span>
</td>
</tr>
</table>
<table align="center" border="0" cellpadding="0" cellspacing="$stylevar[cellspacing]" class="tborder" width="90%" height="150">
<tr>
<td class="alt1">
<div align="center">$box_forumid_1thread</div>
</td>
</tr>
</tbody>
</table>
Any help would be GREATLY appreciated, because no one has been able to help me so far. Noppid has been the only one to give me useful tips over at vBulletin.org.

