Code:
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'entertainment');
// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();
// get special data templates from the datastore
$specialtemplates = array();
// pre-cache templates used by all actions
$globaltemplates = array();
// pre-cache templates used by specific actions
$actiontemplates = array();
require_once('./global.php');
require_once('./includes/functions_bigthree.php');
require_once('./includes/functions_showthread.php');
require_once('./includes/functions_bbcodeparse.php');
$forumid = 2;
// query to get 1 thread
$post = $DB_site->query_first("SELECT post.postid, thread.postusername as username, thread.title, thread.postuserid as userid, post.pagetext as pagetext, thread.threadid as threadid, thread.forumid as forumid,user.usertitle as usertitle FROM " . TABLE_PREFIX . "thread as thread
LEFT JOIN " .TABLE_PREFIX . "post as post ON (post.postid = thread.firstpostid)
LEFT JOIN " .TABLE_PREFIX . "user as user ON (user.userid = thread.postuserid)
WHERE thread.forumid = $forumid and thread.visible = 1
ORDER BY thread.dateline DESC
LIMIT 1
");
$attachments = $DB_site->query("
SELECT filename, filesize, visible, attachmentid, counter, postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize
FROM " . TABLE_PREFIX . "attachment
WHERE postid = $post[postid]
ORDER BY dateline
");
while ($attachment = $DB_site->fetch_array($attachments))
{
$post['attachments']["$attachment[attachmentid]"] = $attachment;
}
// get attachment info
if (is_array($post['attachments']))
{
foreach($post['attachments'] AS $attachmentid => $attachment)
{
$post['image'] .= 'http://www.webbie.net/community/attachment_no_perm.php?attachmentid='.$attachment[attachmentid].'&stc=1';
}
}
$post['pagetext'] = parse_bbcode($post['pagetext'], $forumid, 1);
// this will shorten it
$post['pagetext'] = fetch_trimmed_title($post['pagetext'], 200);
//print_r($post);
?>
I use this on a regular html file, with this line on top of any html file outside of vbulletin:
Code:
<?php
chdir("/home/weebie/public_html/community/");
include("./topstory.php");
?>
Now, I've decide to use vbindex and place my index.html into the vbulletin template. How do I still be able to use the commands that I have above inside a template, such as //$post['image'] etc..? How do I include all this, please help....