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 :/