Top

phpBB2 Last 5 Topics


PHP Code
+ 3 likes
Please Register to submit score.
Bookmark and Share
Average Score  8.0 (of 1 scores)
Date Added  Dec 05, 2008
Last Updated  Dec 05, 2008
Tags  bb  board  codes  discussion  discussion board  furby  php  phpbb  xstatic  xstatic codes 

Introduction

Basically, this is http://www.hawkee.com/snippet/5344/ but written for phpBB2 :)

Hopefully everyone can use this.

Grab the Code

<?php
 
	echo "<b>5 Latest Posts on the Discussion Forums.</b><br />";
 
	// 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 $urlPath.'/config.php';
 
	$link = mysql_connect($dbhost, $dbuser, $dbpasswd) or die("Could not connect");
	mysql_select_db($dbname) or die("Could not select database");
 
	// Get 5 Latest Posts.
	$qry = mysql_query("SELECT * FROM `posts` ORDER BY `post_id` DESC LIMIT 5");
	while($row=mysql_fetch_array($qry)) {
 
		// Get Author Name.
		$author1 = mysql_query("SELECT * FROM `users` WHERE `user_id` = '".$row['poster_id']."'");
		$author2 = mysql_fetch_array($author1);
		$author = $author2['username'];
 
		// Get the Forum Name
		$forum1 = mysql_query("SELECT * FROM `forums` WHERE `forum_id` = '".$row['forum_id']."'");
		$forum2 = mysql_fetch_array($forum1);
		$forum = $forum2['forum_name'];
 
		// Get the Topic Name.
		$topic1 = mysql_query("SELECT * FROM `topics` WHERE `topic_id` = '".$row['topic_id']."'");
		$topic2 = mysql_fetch_array($topic1);
		$topic = $topic2['topic_title'];
 
		printf("<b><a href=\"".$urlPath."/viewforum.php?f=%s\" target=\"_BLANK\">%s</a></b> -> <b><a href=\"".$urlPath."/viewtopic.php?f=%s&t=%s&p=%s#%s\" target=\"_BLANK\">%s</a></b> by <a href=\"".$urlPath."/profile.php?mode=viewprofile&u=%s\" TARGET=\"_blank\">%s</a><br />", $row['forum_id'], $forum, $row['forum_id'], $row['topic_id'], $row['post_id'], $row['post_id'], $topic, $row['poster_id'], $author);
 
	}
 
	mysql_free_result($row);
	mysql_close($link);
 
?>

Comments

  (14)  RSS
F*U*R*B*Y*
Comments: 637
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Dec 6, 2008 9:28 pm
no comments?
no scores?
no likes?

no nothing? :(
IuClik
Comments: 3
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Dec 8, 2008 1:53 pm
For Invision Power Board you have?
F*U*R*B*Y*
Comments: 637
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Dec 10, 2008 12:34 am
^_^ Nothing... I don't use it so I don't create scripts for it...

Any real comments/scores/likes for this script is welcomed....
NIGathan
Comments: 208
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Dec 10, 2008 1:21 am
http://www.hawkee.com/snippet/5420/

You sir, won a golden ticket. /me loads a bowl in celebration
F*U*R*B*Y*
Comments: 637
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Dec 11, 2008 12:22 am
no score and no likes :(
NIGathan
Comments: 208
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Dec 11, 2008 12:59 am
Heh, if I used php, I would rate/like, but its of no use to me
essami
Comments: 2
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Jan 26, 2009 11:06 am
Hi,

Id like to use this on my website but Im a total novice on this. If anyone has the patience to walk me through Id appreaciate it :)

My forum is here: www.fonal.com/forum

and Im trying to add the 5 newest posts on this page (a testpage): http://www.fonal.com/newstest.php

scroll down to see the problem, thanks!



F*U*R*B*Y*
Comments: 637
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Jan 26, 2009 9:58 pm
try having ./forum

instead of /forum *shrugs*

no idea, just a suggestion
essami
Comments: 2
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Jan 27, 2009 7:19 am
yes! that seems to have done the trick, now it says


5 Latest Posts on the Discussion Forums.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/fonal/fonal.com/newstest.php on line 133

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/fonal/fonal.com/newstest.php on line 154
LordHawk
Comments: 30
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on Feb 22, 2009 5:04 pm
Very nicely done Furby.
hawkeeuser
Comments: 4
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on May 6, 2009 10:48 am
Furby do we need to give db name userid or pass in line
$link = mysql_connect($dbhost, $dbuser, $dbpasswd)
because im getting error i only use a path /phpBB2
LordHawk
Comments: 30
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on May 7, 2009 8:31 am
Hawkeeuser, it uses the config.php already in phpbb. If your config file is properly set then it will work fine.
Hawkee
Comments: 1,035
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on May 7, 2009 10:40 am
Looks like this needs the include statements required to use the phpBB2 libraries. These can be found at the top of any of the phpBB2 front end php scripts such as viewforum.php
hawkeeuser
Comments: 4
 
PHP Snippet:  phpBB2 Last 5 Topics
Posted on May 7, 2009 12:06 pm
LordHawk its not like this the script need lil change but i fix it for me
no need for these lines
$urlPath = "/phpbb";
// Database Configuration (Where your phpBB config.php file is located)
include $urlPath.'/config.php';
if the below line is something like this
$link = mysql_connect($dbhost = '', $dbuser = 'yourdb user', $dbpasswd = 'your dbpass') or die("Could not connect");
mysql_select_db($dbname = 'your dbname') or die("Could not select database");
and you don't need this as well
mysql_free_result($row);
mysql_close($link);


Commenting Options

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

  
Bottom