code optimize

[Scanu]

This is possible if you are in the same directory of the vbulletin site for example
This is the forums page: http://yoursite.com/forum.php
This is the script page: http://yoursite.com/script.php

PHP Code:

<?php
include 'includes/config.php';

## CUSTOMIZE SETTINGS FOR YOUR SITE ##
$db_host = $config['MasterServer']['servername'];
$db_name = $config['Database']['dbname'];
$db_user = $config['MasterServer']['username'] ;
$db_pw = $config['MasterServer']['password'];
$db_pre = $config['Database']['tableprefix'];
$forum_url = "http://forum.xxxx.com/"; // Change this to reflect to your forum's URL.
$forum_id = ""; 
$limit = "20"; // Number of posts displayed.
$txtlimit = "120"; // This is the character limit.

// Connecting to your database

mysql_connect($db_host, $db_user, $db_pw) 
OR die ("Cannot connect to your database user"); 
mysql_select_db($db_name) OR die("Cannot connect to your database"); 

if ($forum_id) {
    $forumid = "AND forumid=$forum_id";
}

if ($limit) {
    $limited = "LIMIT $limit";
}


$thread_sql = mysql_query("SELECT threadid, lastpost, lastposter, title FROM thread WHERE visible=1 AND open=1 AND forumid<>32 ORDER BY lastpost DESC LIMIT 0,5");
for($i = 0; $i<5; $i++)
{
  $tid = @mysql_result($thread_sql,$i,0);
  $lastpost = @mysql_result($thread_sql,$i,1);
  $lastposter = @mysql_result($thread_sql,$i,2);
//  $replaycount = @mysql_result($thread_sql,$i,9);
//  $views = @mysql_result($thread_sql,$i,17);
  $psql = mysql_query("SELECT postid FROM post WHERE threadid='$tid' ORDER BY postid DESC LIMIT 0,1");
  $pid = @mysql_result($psql,0,0);
  $title = @mysql_result($thread_sql,$i,3);
  $title = substr($title,0,$txtlimit);
$sitename = "http://forum.xxxxx.com/";
$sitelink = "showthread.php?t=$tid&p=$pid#post$pid";

?>

This should work, for the forum url i don't know what you can do :/