I have been working on a custom news block that displays a compact recent news item of any singular forums. I have it so far that it takes you to the forum of a last post but not to the last post in that forum. So the link generated would be something like; http://web site/viewtopic.php?f2&t=26 ...

Sorted it thanks Kevin.

I hadn't thought about releasing this block but if there is interest then I could release it once completed.

Will give you more info about it when I get a working version finished.

tried the following to connect $offset = ($pageNum - 1) * $rowsPerPage; $sql = "SELECT * FROM phpbb_reviews LIMIT $offset, $rowsPerPage"; $result = $db->sql_query($sql); got this error [phpBB Debug] PHP Notice: in file /portal/block/reviews.php on line 14: mysql_connect() [function.mysql-c...

what is the best and safest way to run the sql for this block, i know there are built in db connections and certain ways to query the database. I have two queries; 1. the alternative to the way i tested this I believe I don't require. $con = mysql_connect("localhost","root","...

Thanks for the quick reply buddy. Works a treat.

A little guidance please. i have created this in the portal/blocks folder called reviews.php // how many rows to show per page $rowsPerPage = 2; // by default we show first page $pageNum = 1; // if $_GET['page'] defined, use it as page number if(isset($_GET['page'])) { $pageNum = $_GET['page']; } //...

Hello everyone, just a quick hello and thank you to all the team for the hard work in developing this mod. Some may know me from around so hi