Ahmad
04-15-2004, 10:00 PM
Hi,
This is my first public hack. I hope I'm not breaking any rules! :rolleyes:
This is an enhanced version of external.php that gives you two little useful features:
1. Control the number of threads you want to get (up to 50 threads, or even more).
2. Change the order of threads from the date of the thread to the date of the last post.
This will allow you to make an external list of your latest XX posts using JavaScript, XML, or RSS.
Installation
1. Make a copy of the file external.php in the same directory and call it external2.php.
2. Open external2.php in your favorite text editor.
3. Look for these lines:
if ($forumchoice != '')
{
// query last 15 threads from visible / chosen forums
Add these lines above them:
// see if there is a count preference
if ($_REQUEST['limit'])
{
$limit = intval($_REQUEST['limit']);
if ($limit > 50)
{
$limit = 50;
}
}
else
{
$limit = 15;
}
// see if there is an ordering preference
if ($_REQUEST['orderby'] == 'lastpost') {
$orderby = 'thread.lastpost DESC';
}
else
{
$orderby = 'thread.dateline DESC';
}
Then find these two lines:
ORDER BY thread.dateline DESC
LIMIT 15
And replace them with:
ORDER BY $orderby
LIMIT $limit
Usage
Just like you would use external.php, but with the following extra parameters:
1. limit: this controls the number of threads you want to be displayed. You cannot go beyond 50 here. If not set to anything, it will return 15 threads.
2. orderby: if set to 'lastpost', it will give you the last XX number of threads based on the last post to the thread. If set to anything else (or not set at all), it will give you the last XX number of threads based on their start date (this order doesn't change when someone replies to a thread).
If you ignore both extra parameters limit and orderby, the script will act just like the normal external.php. So, you can use it in place of external.php, instead of as an second (external2.php) script.
I hope you will find it useful.
This is my first public hack. I hope I'm not breaking any rules! :rolleyes:
This is an enhanced version of external.php that gives you two little useful features:
1. Control the number of threads you want to get (up to 50 threads, or even more).
2. Change the order of threads from the date of the thread to the date of the last post.
This will allow you to make an external list of your latest XX posts using JavaScript, XML, or RSS.
Installation
1. Make a copy of the file external.php in the same directory and call it external2.php.
2. Open external2.php in your favorite text editor.
3. Look for these lines:
if ($forumchoice != '')
{
// query last 15 threads from visible / chosen forums
Add these lines above them:
// see if there is a count preference
if ($_REQUEST['limit'])
{
$limit = intval($_REQUEST['limit']);
if ($limit > 50)
{
$limit = 50;
}
}
else
{
$limit = 15;
}
// see if there is an ordering preference
if ($_REQUEST['orderby'] == 'lastpost') {
$orderby = 'thread.lastpost DESC';
}
else
{
$orderby = 'thread.dateline DESC';
}
Then find these two lines:
ORDER BY thread.dateline DESC
LIMIT 15
And replace them with:
ORDER BY $orderby
LIMIT $limit
Usage
Just like you would use external.php, but with the following extra parameters:
1. limit: this controls the number of threads you want to be displayed. You cannot go beyond 50 here. If not set to anything, it will return 15 threads.
2. orderby: if set to 'lastpost', it will give you the last XX number of threads based on the last post to the thread. If set to anything else (or not set at all), it will give you the last XX number of threads based on their start date (this order doesn't change when someone replies to a thread).
If you ignore both extra parameters limit and orderby, the script will act just like the normal external.php. So, you can use it in place of external.php, instead of as an second (external2.php) script.
I hope you will find it useful.