phpBB.de

Code: Alles auswählen

<?php
///////////////////////////////////////////////////////////
// MOD Name:  Last X Post
//
//  Authors:
//       Retro  <unknown@unkown>
//       Martin <phpbb@websnail.net>
//       John B. Abela <abela@phpbb.com>
//       Malkavian <nid@backstab.org>
//
///////////////////////////////////////////////////////////
// DESCRIPTION:
//       This file will display the most recent X posts
//       in any file on your server. You can either
//       place this code in a seperate file and INCLUDE
//       it, or place this code directly into an existing
//       file.
//
///////////////////////////////////////////////////////////
// VERSION HISTORY:
//
//       17/02/2002 Malkavian
//              Changed Sql statement to check vs the last_post_id
//              from topic table
//       12/26/2001 - John B. Abela -
//             Inital Documentation And Formating
//             Streamlined Code,
//             CHANGED:
//                 DISTINCT topic.topic_title,
//             TO:
//                 DISTINCT post.post_subject
//             as I felt it was a better method of displaying.
//
//       12/10/2001 - Martin -
//             Substantial Upgrade Including 'Time-Zone'
//
//       12/08/2001 - Retro -
//             Initial Release - Edited From phpBB1 MOD
//             origianlly written by John B. Abela & Frank F.
//
///////////////////////////////////////////////////////////
// NOTES:
//
///////////////////////////////////////////////////////////
// SET PATHS
///////////////////////////////////////////////////////////
//
$ServerPath = "config.php";//- Note: No trailing forward slash
$URLPath = "http://www.deineseite.ch/phpbb3";  //- Note: No trailing forward slash !
//
///////////////////////////////////////////////////////////
// MISC SETTINGS
///////////////////////////////////////////////////////////
//
$PostNumber = "15";  // How Many Posts To Display
$timediff = 0;// Time difference between server and board time
$FontFace = "Verdana, Arial";  //- Font Face
$FontSize1 = "-1";  //- Font Size 1
$FontSize2 = "-1";  //- Font Size 2
$FontColor = "#000000";  //- Font Color
$TableWidth = "75%";  //- Table Width
$TableAlign = "CENTER";  //- Table Align
//
///////////////////////////////////////////////////////////
// CONNECT TO DB
///////////////////////////////////////////////////////////
//
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");
//
///////////////////////////////////////////////////////////
// SQL STATEMENT
///////////////////////////////////////////////////////////
//
$sql = "SELECT DISTINCT post.post_subject, topic.topic_title, post.post_id, post.post_time
FROM phpbb_posts AS post, phpbb_topics AS topic
WHERE  topic.forum_id NOT IN (1, 9) AND post.post_id = post.post_id AND post.topic_id = topic.topic_id AND post.post_id = topic.topic_last_post_id
ORDER BY post.post_time DESC LIMIT $PostNumber";

///////////////////////////////////////////////////////////
// SETTING/VARIABLES/STUFF
///////////////////////////////////////////////////////////
//
if($r = mysql_query($sql, $db)) {
echo '<TABLE CELLPADDING="5" CELLSPACING="5" BORDER="5" ALIGN="'.$TableAlign.'" WIDTH="'.$TableWidth.'">';
while($m = mysql_fetch_array($r)) {
  $temp = $m[3];
    if ($timediff) {
        $diffsecs = $timediff * 3600;
        $temp += $diffsecs;
    }
$pd = getdate ($temp);
    if ($m[1]) {
        $j = stripslashes($m[1]);
    } else {
        $j = stripslashes($m[0]);
    }
$k = substr($j, 0, 30) . "...";
    if ($pd['minutes'] < 10) {
        $pmins = "0".$pd['minutes'];
    } else {
        $pmins = $pd['minutes'];
    }
    if ($pd['hours'] < 10) {
        $phours = "0".$pd['hours'];
    } else {
        $phours = $pd['hours'];
    }
  echo '<TR><TD align="left"><font color="blue" size="2"><a Target="_blank" href="'.$URLPath.'/viewtopic.php?p='.$m[2].'#'.$m[2].'">'.$k.'</a></TD>';
  echo '<TD align="right"><font color="blue" size="2">('.$pd['mday']."  ".substr($pd['month'],0,3)." - ".$pd['hours'].':'.$pmins.')</TD></TR>';
    }
  echo "</TABLE>";
}
?>

Code: Alles auswählen

include("/pfad zu deinem forum/last_x_posts.php");

Code: Alles auswählen

$k = substr($j, 0, 30) . "...";

Code: Alles auswählen

WHERE  topic.forum_id NOT IN (1, 9)