Announcement

[Barrikin]

I was wondering if i could get Announcement's to show up on the forum index page.

[Barrikin]

What i mean is, that i would like to have the announcement bit that shows in forumdisply.php also show up in index.php

I have the code, from forumdisply.php but where would i put it in index.php thats the only problem.
// get announcements

$announcebits = '';

$announcements = $DB_site->query("
SELECT
announcementid, startdate, title, announcement.views,
user.username, user.userid, user.usertitle, user.customtitle
FROM " . TABLE_PREFIX . "announcement AS announcement
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = announcement.userid)
WHERE startdate <= " . (TIMENOW - $vboptions['hourdiff']) . "
AND enddate >= " . (TIMENOW - $vboptions['hourdiff']) . "
AND " . fetch_forum_clause_sql($foruminfo['forumid'], 'forumid') . "
ORDER BY startdate DESC
" . iif($vboptions['oneannounce'], "LIMIT 1"));

while ($announcement = $DB_site->fetch_array($announcements))
{
if ($announcement['customtitle'] == 2)
{
$announcement['usertitle'] = htmlspecialchars_uni($announcement['usertitle']);
}
$announcement['postdate'] = vbdate($vboptions['dateformat'], $announcement['startdate']);
if ($announcement['startdate'] > $lastread)
{
$announcement['statusicon'] = 'new';
}
else
{
$announcement['statusicon'] = 'old';
}
$announcement['views'] = vb_number_format($announcement['views']);
$announcementidlink = iif(!$vboptions['oneannounce'] , "&amp;announcementid=$announcement[announcementid]");

eval('$announcebits .= "' . fetch_template('forumdisplay_announcement') . '";');
}


(not sure if i need to have this here, but here it is anyhow.
Copyright ?2000?2004 Jelsoft Enterprises Ltd. All Rights Reserved.
This code may not be redistributed in whole or significant part.

[Barrikin]

No can help?

[Osterling]

try vbtemplates