Top

Latest post on your homepage ( phpbb )


PHP Code
+ 5 likes
Please Register to submit score.
Bookmark and Share
Average Score  7.7 (of 3 scores)
Date Added  Nov 14, 2008
Last Updated  Nov 15, 2008

Introduction

This is a php code it show the latest forum post with phpBB3 on the homepage of your website. It work with your config.php in your PHPBB directory. If you wish to show more then the latest 5 posts you can change the $topicnumber to whatever you wish to display.



Grab the Code

<?php
    // How Many Topics you want to display?
    $topicnumber = 5;
    // Change this to your phpBB path
    $urlPath = "/phpbb";
 
    // Database Configuration (Where your phpBB config.php file is located)
    include 'phpbb/config.php';
 
    $table_topics = $table_prefix. "topics";
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";
    $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysql_select_db("$dbname") or die("Could not select database");
 
    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND
    t.forum_id != 4 AND
    t.topic_status <> 2 AND
    p.post_id = t.topic_last_post_id AND
    p.poster_id = u.user_id
    ORDER BY p.post_id DESC LIMIT $topicnumber";
    $result = mysql_query($query) or die("Query failed");									
 
    print "<table cellpadding='3' cellSpacing='2' width='640'>";
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
 
    echo  "<tr valign='top'><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#FFCC00\"><b><a href=\"$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]#p$row[post_id]\" TARGET=\"_blank\">" .
    $row["topic_title"] .
    "</a></td></font></b><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#C0C0C0\"> by: <a href=\"$urlPath/memberlist.php?mode=viewprofile&u=$row[user_id]\" TARGET=\"_blank\">" .
    $row["username"] .
    "</td><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#C0C0C0\">" .
    date('F j, Y, g:i a', $row["post_time"]) .
    "</td></tr></font>";
    }
    print "</table>";
    mysql_free_result($result);
    mysql_close($link);
    ?>

Comments

  (31)  RSS
Hawkee
Comments: 1,039
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Nov 14, 2008 9:26 am
Neat, but which version of phpBB is this compatible with? Also it's always best to do your HTML separate from your PHP code so you don't need to backslash all those quotes.
Xpl0reR
Comments: 223
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Nov 14, 2008 1:48 pm
is it working on phpbb2 ?
LordHawk
Comments: 30
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Nov 15, 2008 7:17 am
I wrote this for phpBB3 , its currently not compatible with phpBB2 but I can make a version for phpBB2 if you need one Xpl0reR. I think i might add a marquee to it also for scrolling purposes if you would like that.
Xpl0reR
Comments: 223
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Nov 16, 2008 12:56 am
well, if you could do one for mirc, ( if its easyest, let me know )

something like this

<r00tb0y> New post on mircscripting forum ( http://mircscripting.info/forum ): date: Sun Nov 16, 2008 1:47 am - Forum: Snippets - Title: Private Messages Tip - User: XploreR - text: nice one Xaifas... - link: http://mircscripting.info/forum/viewtopic.php?p=3386#3386

That posts on a channel the new posts on a phpbb2 forum. and/or phpbb3. ( both would be great :)
F*U*R*B*Y*
Comments: 637
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Dec 5, 2008 2:06 am
http://www.hawkee.com/snippet/5420/ Heres a phpBB2 version of it. Hopefully everyone can really use it.
pdumelle
Comments: 1
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Dec 22, 2008 11:59 pm
How do i add this to my index page of my phpbb I made it a file and put it in the root and try to do an include in the overall_footer.html but it is not coming up I also tried to hard code it into that file and no luck

I got the code to work on another page but not on the fourm page
see http://cowplow.com/ it works but http://cowplow.com/plowtalk/ no luck
Hawkee
Comments: 1,039
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Dec 23, 2008 12:03 pm
The code does an include from phpbb/config.php so you need to make sure that is in sync with where you put it. If you put it inside phpbb/ then you need to change the include to just "config.php" without the phpbb/
F*U*R*B*Y*
Comments: 637
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Dec 24, 2008 2:50 am
i like how Xpl0rer askes for it in phpBB2, so i wrote one up, and he doesn't comment/rate/like it lol
ODD
Comments: 11
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Dec 27, 2008 3:45 am
gj nice one been looking for it but facing a problem as i need it as a joomla! plugin and i wld love to see one that works with mirc as xpl0rer said
ODD
Comments: 11
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jan 6, 2009 10:47 am
ok important question: inorder to use this script i would ahve to edit my config.php CHMOD (permissions) right? if so, thats a real security exploit!
Hawkee
Comments: 1,039
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jan 6, 2009 1:00 pm
You don't need to chmod anything, just include the phpBB config.php.
irchainscriptz
Comments: 125
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jan 6, 2009 1:49 pm
I like the snippet but as i can see wont work for ppl on Evo-nuke sites :P but other then that nice snippet there :)
LordHawk
Comments: 30
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jan 7, 2009 7:38 pm
thanks for all the nice feedback guys, Sorry for you having to answer the questions Hawkee. My aunt passed away so i was off dealing with family issues.
Hawkee
Comments: 1,039
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jan 7, 2009 7:53 pm
Oh no problem LordHawk, happy to help. Sorry about your loss.
Lunarpancake
Comments: 1
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jan 9, 2009 2:51 pm
LordHawk im interested in having a forum where I would post news / updates. I would like the complete newest post in this forum to show on my homepage (not forum index) could your code up top be modified to do this?

LordHawk
Comments: 30
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jan 9, 2009 7:14 pm
hmm it would take a decent amount of modifying but sure it can be done.
F*U*R*B*Y*
Comments: 637
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jan 9, 2009 10:01 pm
not really.... just have a truncate function, then just call it upon command :S

quite simple...
PsychoJosh
Comments: 1
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jan 29, 2009 3:57 am
LordHawk
Comments: 30
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Feb 2, 2009 3:19 pm
There is a nice news system that can be arranged like that its called Fusion news.
popcorn
Comments: 1
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Mar 12, 2009 7:55 am
How can this be used for a page that use iframe to show the forum??
I want to show my visitors the last 5 posts on my website. But i cant get the iframe to show the latest post. It only opens up the forum in full.

Problem is that i first have to address the page containing the iframe, then the iframe have to be called to open the correct post. How to do this??
hawkeeuser
Comments: 4
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on May 9, 2009 5:24 pm
simply use the iframe with link separate page of this script
mbartelt
Comments: 1
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jun 7, 2009 2:07 pm
What must I change to show only new posts from a part of the forum? My forum has different boards about HiFi/Homecinema, Games, Fischertechnik and Hiking. So I only want to show new posts in the Hiking part.

Thanks

Manfred
websiteministries
Comments: 1
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jun 22, 2009 8:54 am
Awesome script. Exactly what I was looking for! A+++++++ I hardly ever sign up for forums, but I signed up just so that I could thank you and rate this script.
Eepeepee
Comments: 1
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jun 23, 2009 4:53 pm
Nice!

Just one little thing: the script does not produce valid html (any version)

The font and bold tags get opened inside the <td>, but closed outside it (</td></font></b>). It's no biggie since anyone that cares probably knows how to fix it, but still I wanted to bring it up. Also you could add some line breaks there for improved readability.

But yeah anyway, thanks a bunch, the snippet was a great help to me. :)
scotty2024
Comments: 2
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jul 14, 2009 12:49 pm
Is there a way to exclude certain forums or even categories? For example, I have a moderator category with three different forums that I don't want displayed. How can I exclude them?
Thanks.
Hawkee
Comments: 1,039
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jul 14, 2009 1:05 pm
scotty2024, you probably have to explicity indicate this in the SQL query. Maybe add something like "AND f.forum_id != 123 AND f.forum_id !=234" etc.
scotty2024
Comments: 2
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jul 14, 2009 1:10 pm
Never mind, figured it out. For anyone else wanting to do this, change the query to something like this:

$query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
WHERE t.topic_id = p.topic_id AND
f.forum_id = t.forum_id AND
t.forum_id <> X AND
t.topic_status <> 2 AND
p.post_id = t.topic_last_post_id AND
p.poster_id = u.user_id AND
ORDER BY p.post_id DESC LIMIT $topicnumber";

Note the line "t.forum_id <> X AND". Change X to the number of the forum. This number can be found by looking at the URL of the forum. It is f=X in the URL. For example http://www.yourwebsite.com/viewforum.php?f=5. In this case it is 5. You can repeat the line t.forum_id <> X AND for each for you want excluded.
LordHawk
Comments: 30
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jul 14, 2009 6:06 pm
Correct Scotty. Sorry ive been really busy, with my site and trying to keep up with the changing times.
VinX
Comments: 56
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Jul 31, 2009 3:00 am
i would really love to see a vBulletin version ..
LordHawk
Comments: 30
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Aug 1, 2009 5:32 am
Im currently working on a SMF version of this same code. I can look into vBulletin also.
VinX
Comments: 56
 
PHP Snippet:  Latest post on your homepage ( phpbb )
Posted on Aug 2, 2009 9:19 am
sweet , thanks LordHawk <3

Commenting Options

Register or Login to Hawkee.com or use your Facebook or Twitter account by clicking the corresponding button below.

  
Bottom