Lo ultimo en el Foro |
/**
* Mod Title: Latest posts/topics
* Mod Version: phpBB 2.0
* Author: Pegas (pegas@ami.cz) (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 = "/foros"; //example: if your forum URL looks like http://kocky-online.cz/forum, this should be "/forum"
$serverPath = "foros/config.php"; //example: when this file is in URL path /forum/mod, this should be ../config.php
if(empty($count))
$count = "15"; //default value of how many posts/topics to show
if(empty($type))
$type = "topics"; //default value of whether to show 'posts' or 'topics'
$titleLimit = 20; //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 "".ucfirst(strtolower(utf8_encode($k)))."..."; //$k
}
}
//
//-------------------[ DO NOT EDIT UP HERE ]--------------------------
?>
|
|
Escrito por Mordisquitos
|
Sábado, 03 de Octubre de 2009 20:31 |
NOA - Association for the Protection of Animals
Knjaza Milosa 57
Banja Luka
Bosnia-Herzegovina
Teléfono:+387 - 659 33617
Email:
Esta dirección electrónica esta protegida contra spam bots. Necesita activar JavaScript para visualizarla
Web:www.drustvonoa.org
Stichting Dierenopvang Bosnië (SDB)
Postbus 3147
3031 DC Dordrecht
Netherlands
Teléfono:+31 - 6 4619 8579
Email:
Esta dirección electrónica esta protegida contra spam bots. Necesita activar JavaScript para visualizarla
Web:www.hondenopvang.com
The Sarajevo Society for the Prevention of Cruelty to Animals 'SOS'
Ferde Hauptmana 7/1
71000
Sarajevo
BiH
Bosnia-Herzegovina
Teléfono:+387 - 33 651 435
Email:
Esta dirección electrónica esta protegida contra spam bots. Necesita activar JavaScript para visualizarla
Web:www.sossarajevo.org
|
|
Animalistas conectados |
Tenemos 36 invitados conectado(s) |
|