Newest Posts on Main page

[Zeus]

Is there a hack that lets you put the most recent posts in the forum on the main page of your site?

Where can I get it?

I search too this hack :(

I searched it in my last thread "help*_*", too.

Have nobody make one jet?

I've seen this in action on Sitepoint (http://www.sitepoint.com) so it can be done.
How being the definitive question

<?php
// Set this to the max number of threads to display
$maxthreads = 10;

require("./admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<a href=\"showthread.php?threadid=$latest_array[threadid]\">$latest_array[title]</a>";
}

?>

Ratorasniki, do I just copy & paste that code onto my main html page to get these Topics to show up there?

Firstly thanks for the help really aprreciate it.

i tried pasting the code into my page but it generated a parse error on the line with the SQL query on it.

echo "<a href=\"http://www.yoursite.com/path_to_forum/showthread.php?threadid=$latest_array[threadid]\">$latest_array[title]</a><br>";

Change this and it works perfect. Thanks Ratorasniki *_*

$servername="****";
$dbusername="****";
$dbpassword="****";
$dbname="****";

At this instead of "require("./admin/config.php");" Zeus.

I tried that it still dosent work, again the error is with the SQL query statement.

I'm using php3 will that make a difference?
(I have made the necessary php3 extension changes)

Use a PHP Include for this File in your Main Page and just change the Password stuff, etc.. in the file.

This have to work.

yes thats worked, Excellent stuff

Danke
Thank you
Go raibh math agat.

I don't get it guys.. I'm new to VBB modification.
I see all these neat things I can be using but I still don't know how to have this text come up on my page page..

Can someone please lay it out for me?
I've tried making these files and then linking to them by puttings this on my main page ( <!--#include virtual="/forums/online.php"--> )
But nothing works still.. What am I doing wrong?

you can only include php code in a php page, which means it ends with either .php or .php3
a .shtml page can't execute php.

Thx very much guys!!
That work very nice

Ohh, OK. So how would I include that php code in a regular HTML page?

Or how can I convert my HTML page into PHP?

You dont have to do anything with html.

First download the code MB posted

Make the changes as for your website and forum

Upload it to your root directory(if you want them to display on the main index page of your site)

Add this to your index page where you want the posts to appear:

<?php include('forum.txt');?>

Save it as index.php

I finally got it.. thanks guys!

It gives it to me in a big hunk tho?

http://form-kaos.com/forum/newthreads.php

Ideas on fixing?

you need to include <br> in the echo thing

If you use this, than all threads are shown on the mainpage, even threads that are in internal forums.

Is there a solution for this?

very nice and easy to install.

Is there a way i could have the date of the post and the name of the poster + the title? like in http://www.sitepoint.com/

thank you in advance

yes, that is the script that will solve all of our problems.
I have asked Wayne on their forums about it, but got no reply :(

Originally posted by auto
you can only include php code in a php page, which means it ends with either .php or .php3
a .shtml page can't execute php.

Um, actually it will if you use a SSI. As long as your server supports PHP parsing, you can include a PHP file via SSI (see this (http://www.vbulletin.com/forum/showthread.php?s=&threadid=10932)). Also, you can use the extension of .phtml on PHP files, assuming your server supports this.

Originally posted by TommyXXL
If you use this, than all threads are shown on the mainpage, even threads that are in internal forums.

Do you mean private forums that are limited access? If so, here's the solution. Change the line
$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads";
to
$query = "SELECT * FROM thread WHERE forumid!=XX ORDER BY lastpost DESC LIMIT $maxthreads";
and change the XX to the number of the forum you want to exclude. (You can determine the forum number by going to your main forums page and mousing over the link to each forum. The forum number is the part of the url after forumid; e.g. http://yoursite.com/forumdisplay.php?s=&forumid=36. To exclude more than one forum, add this:
AND forumid!=XX
for each additional forum you want to exclude. MAKE SURE you add a space before the word AND and a space after XX and you change the XX to the number you want excluded. Example: I want to exclude forums 6, 12, and 35.
$query = "SELECT * FROM thread WHERE forumid!=6 AND forumid!=12 AND forumid!=35 ORDER BY lastpost DESC LIMIT $maxthreads";
Second example: I want to exclude forum 6.
$query = "SELECT * FROM thread WHERE forumid!=6 ORDER BY lastpost DESC LIMIT $maxthreads";

[SVTBlackLight01]

Is there a way to get the user and date to display too.