|
How To Get Last Threads
by
06 Jun 2007
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
PHP 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:
PHP 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:
PHP 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 
|