How To Get Last Threads - vb.org Archive

		vb.org Archive > vBulletin Article Depository > Read An Article > vBulletin 3 Articles
How To Get Last Threads

Thread Tools

How To Get Last Threads

Naxon

Join Date: Oct 2006

Posts: 122

Israel

Naxon

06-04-2007, 09:00 PM

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

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT. The time now is 02:16 PM.

The Arcive of vBulletin Modifications Site.