Adding php-code to vbulletin (real example)

[sprintic]

I have a website, where I decided to insert vbulletin into its template. I've managed to do that by adding static html code to vbulletin templates. Right now it's the main page of http://www.stockmarketsreview.com

But there is one thing I want to do. I want to place dynamic news under the forum body at the main page. Dynamic news can be checked here http://www.stockmarketsreview.com/news/, they are taken from mysql database with the following code:

<table cellspacing="0" cellpadding="0" width="990">



<tr style="padding-top:15px">
<td>
<?

@ $db = mysql_connect('********', '********', '********');
mysql_select_db('********');
$query_news= "SELECT `id`,
`name_id`,
DATE_FORMAT( date, '%e %M %Y'),
`title`,
`short_text`,
`country`,
`bric`,
`europe`
FROM `news`
ORDER by `date` DESC
LIMIT 0,40";
$result_news=mysql_query($query_news);
while(list($id, $name_id, $date, $title, $short_text, $country, $bric, $europe)=mysql_fetch_row($result_news))
{
?>

<a class="story_title" href="<?php echo GLOBAL_ADDRESS; ?>/news/<?php echo $name_id; ?>/"><?php echo $title; ?></a>
<br>
<font class="date"><?php echo $date; ?>,</font>

<?
if ($country=='USA')
{
?>
<font class="country_near_date_usa"><?php echo $country; ?></font>
<br>

<?
}
?>


<?
if ($europe=='1')
{
?>
<font class="country_near_date_europe">Europe</font>
<br>

<?
}
?>

<?
if ($bric=='1')
{
?>
<font class="country_near_date_bric">BRIC, <?php echo $country; ?></font>
<br>

<?
}
?>

<?
if ($country!='USA' && $europe!='1' && $bric!='1')
{
?>
<font class="country_near_date_other">Other markets, <?php echo $country; ?></font>
<br>

<?
}
?>



<font class="story"><?php echo $short_text; ?></font>
<br><br>

<?
}
}
//-----------------------------------------------------------------------
?>

</td>

<td width="165" valign="top" style="padding-left:5px">
<?php include("adsense_160x600.php");?>
</td>


<td width="305" valign="top" style="padding-left:5px">

<table align="right">

<tr><td>
<?php include("left_us.php");?>
</td></tr>

<tr><td>
<br>
</td></tr>

<tr><td>
<?php include("left_europe.php");?>
</td></tr>

<tr><td>
<br>
</td></tr>

<tr><td>
<?php include("left_india.php");?>
</td></tr>

<tr><td>
<br>
</td></tr>

<tr><td>
<?php include("left_china.php");?>
</td></tr>

<tr><td>
<br>
</td></tr>

<tr><td>
<?php include("left_russia.php");?>
</td></tr>

<tr><td>
<br>
</td></tr>

<tr><td>
<?php include("left_brazil.php");?>
</td></tr>

</table>

</td>


</tr>
</table></td></tr>




</table>

So I want to ask how should I add this code to vbulletin forum main page? I've searched many websites, but didn't find such examples. Help me please.

[Opserty]

Put it in its own PHP file, then Including External Files (http://www.vbulletin.com/docs/html/main/templates_externalfiles)

Note: Using $db in your script may cause conflicts with vBulletin's inbuilt variables.