PDA

View Full Version : How To Get Last Threads


Naxon
05 Jun 2007, 22:34
Do the following steps if you want to get the last threads from your vBulletin system.


Create a new php file (like "test.php").
Paste this code

<html>
<head>
<style type="text/CSS">
body {
font-family:Arial;
font-size:8pt;
color:Black;
}
</style>
</head>
<body>
<?php
include "includes/config.php";
$con = mysql_connect($config['MasterServer']['servername'], $config['MasterServer']['username'], $config['MasterServer']['password']) or die(mysql_error());
mysql_select_db($config['Database']['dbname'], $con) or die(mysql_error());
$select = mysql_query("SELECT * FROM `thread`ORDER BY `lastpostid` DESC LIMIT 0,10") or die(mysql_error());
$address = "http://vbulletin.com/"; // Change to your address. Example: "http://vbulletin.com/forum/".
while ($row=mysql_fetch_array($select)) {
echo "<img src=\"{$address}/images/statusicon/thread_new.gif\" /> <a href=\"{$address}/showthread.php?id={$row['threadid']}{$row['threadid']}\" target=\"_self\">{$row['title']}</a>";
echo "<br />";
}
?>
</body>
</html>

Change the variable $address to your forum's address (There is an example on the code...).
If you want the query not to select from some forum, like forum number 3, replace it with this code:

<html>
<head>
<style type="text/CSS">
body {
font-family:Arial;
font-size:8pt;
color:Black;
}
</style>
</head>
<body>
<?php
include "includes/config.php";
$con = mysql_connect($config['MasterServer']['servername'], $config['MasterServer']['username'], $config['MasterServer']['password']) or die(mysql_error());
mysql_select_db($config['Database']['dbname'], $con) or die(mysql_error());
$select = mysql_query("SELECT * FROM `thread` WHERE `forumid`!='3' ORDER BY `lastpostid` DESC LIMIT 0,10") or die(mysql_error());
$address = "http://vbulletin.com/"; // Change to your address. Example: "http://vbulletin.com/forum/".
while ($row=mysql_fetch_array($select)) {
echo "<img src=\"{$address}/images/statusicon/thread_new.gif\" /> <a href=\"{$address}/showthread.php?id={$row['threadid']}{$row['threadid']}\" target=\"_self\">{$row['title']}</a>";
echo "<br />";
}
?>
</body>
</html>

Or from more than one forum.. like 3, 5 and 10, use this code:

<html>
<head>
<style type="text/CSS">
body {
font-family:Arial;
font-size:8pt;
color:Black;
}
</style>
</head>
<body>
<?php
include "includes/config.php";
$con = mysql_connect($config['MasterServer']['servername'], $config['MasterServer']['username'], $config['MasterServer']['password']) or die(mysql_error());
mysql_select_db($config['Database']['dbname'], $con) or die(mysql_error());
$select = mysql_query("SELECT * FROM `thread` WHERE `forumid`!='3' AND `forumid`!='5' AND `forumid`!='10' ORDER BY `lastpostid` DESC LIMIT 0,10") or die(mysql_error());
$address = "http://vbulletin.com/"; // Change to your address. Example: "http://vbulletin.com/forum/".
while ($row=mysql_fetch_array($select)) {
echo "<img src=\"{$address}/images/statusicon/thread_new.gif\" /> <a href=\"{$address}/showthread.php?id={$row['threadid']}{$row['threadid']}\" target=\"_self\">{$row['title']}</a>";
echo "<br />";
}
?>
</body>
</html>

Save the file and upload it to the Main Forum Folder, Where Index.php.Enjoy :)