<?
/**
* Mod Title: Latest posts/topics
* Mod Version: phpBB 2.0
* Author: Pegas ([email protected]) (originally made by ?, previous version by LiLCoolboy (M@urice Cheung))
* Description: Shows latest posts or topics on any page, 2 optional parameters
* Release: v3.0, 27.01.2003
***
* DeMo: http://kocky-online.cz (Czech language)
* Installation Level: Easy
* Installation Time: 5 minutes
* Files To Edit: 0
* Included Files: (if necessary)
***
* Installation Notes:
* Put this code into new file, set $serverPath and $urlPath,
* upload this file onto server and include into your page and you are done!
* -- OR --
* Put this code into your page, set $serverPath and $urlPath,
* and you are done!
***
* Parameters:
* There are 2 optional parameters when calling this code as standalone file via include!
* type - whether to show topics or posts
* type=posts - posts [default when missing]
* type=topics - topics
* count - how much posts/topics show
* count=# [default is 3]
***
* Examples (assume that your file with this code is hilites.php):
* hilites.php?type=topics&count=5
* - shows latest 5 topics
* hilites.php?type=topics
* - shows latest 3 topics
* hilites.php
* - shows latest 3 posts
***
* Revision:
* v1.0
* author: ?
* v2.0
* author: LiLCoolboy (M@urice Cheung)
* - not working without significant changes, mistypes
* v3.0
* author: Petr Gasparik
* + added parameters when called as standalone file
* + posts/topics selection corrected
* + corrected mistypes
*/
$urlPath = "ABSOLUTE_PATH_OF_YOUR_FORUM"; //example: if your forum URL looks like http://kocky-online.cz/forum, this should be "/forum"
$serverPath = "PATH_TO/config.php"; //example: when this file is in URL path /forum/mod, this should be ../config.php
if(empty($count))
$count = "3"; //default value of how many posts/topics to show
if(empty($type))
$type = "posts"; //default value of whether to show 'posts' or 'topics'
$titleLimit = 30; //this is max.length of 'title' of topic/post
$moreLimit = 20; //this is max.length of 'more' (used in posts)
//-----------------[ DO NOT EDIT BELOW HERE ]-------------------------
include_once("$serverPath");
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection");
@mysql_select_db("$dbname",$db) or die("here we die");
if($type == "posts")
{
$prefix = 'p';
$sql = "SELECT x.post_subject as title, p.post_id as id, f.forum_id, t.topic_title as more "
."FROM ${table_prefix}topics t, ${table_prefix}forums f, ${table_prefix}posts p, ${table_prefix}posts_text x "
."WHERE t.topic_id = p.topic_id AND f.forum_id = t.forum_id AND p.post_id = x.post_id "
."ORDER BY p.post_id DESC "
."LIMIT $count";
}
else
{
$prefix = 't';
$sql = "SELECT t.topic_title as title, t.topic_id as id, f.forum_id, '' as more "
."FROM ${table_prefix}topics t, ${table_prefix}forums f "
."WHERE f.forum_id = t.forum_id "
."ORDER BY topic_time DESC "
."LIMIT $count";
}
//echo $sql;
if($r = mysql_query($sql, $db)) {
while($m = mysql_fetch_array($r)) {
$j = stripslashes($m[title]);
$k = substr($j, 0, $titleLimit) . "...";
if(!empty($m[more]))
$m[more] = '('.substr($m[more], 0, $moreLimit) . '...)';
if ($type == 'posts') {
$anchor = '#'.$m[id];
}
//-------------------[ THIS IS ONLY LINE YOU COULD CHANGE ]--------------------------
echo "<a title=\"$m[title]\" href=\"$urlPath/viewtopic.php?${prefix}=$m[id]&sid=$m[forum_id]${anchor}\">$k</a> $m[more]<br>";
}
}
/
//-------------------[ DO NOT EDIT UP HERE ]--------------------------
?>
