ilch.de :: Forum :: Ilch Clan 1.1 :: Module und Modifikationen

Für ne eigene Seite z.B. für ein phpbb Forum hab ich was zwinker

phpbbforenticker

du must nur noch deine Angaben eingeben:
"localhost", // meistens localhost
"username", // dein FTP Username
"passwort" // dein FTP Passwort
"meine_db_1" // dein Datenbankname
$config_path = '/ilch/meinforum/'; // Pfad zur config.php
$root_path = 'http://meine-seite.de/ilch/meinforum/'; // Pfad zum Direktlink

weiterhin kannst du hier die Anzeige verändern:
$topic_length = '20'; // length of topic title
$topic_limit = '12'; // limit of displayed topics
$special_forums = '0'; // specify forums ('0' = no; '1' = yes)
$forum_ids = '92'; // IDs of forums; separate them with a comma

Ansehen kann man es sich hier externer Link, das Forum ist zwar nicht in Betrieb, weil wir das Ilch Forum verwenden, aber die Ansicht ist ersichtlich.

Gruß eisvogel

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

<?php
 
$verbindung=mysql_connect("localhost","username","passwort")
            or die("Verbindung fehlgeschlagen!");
            $datenbank=mysql_select_db("meine_db_1")
            or die("<br>Datenbank nicht gefunden!");
 
// ############         Edit below         ########################################
$topic_length = '20';   // length of topic title
$topic_limit = '12';   // limit of displayed topics
$special_forums = '0';   // specify forums ('0' = no; '1' = yes)
$forum_ids = '92';      // IDs of forums; separate them with a comma
 
$config_path = '/ilch/meinforum/';   // path to config.php
$root_path = 'http://meine-seite.de/ilch/meinforum/';      // link path
// ############         Edit above         #######################################
 
 
 
// ############## output ##############
echo '<table border="0" cellpadding="0" cellspacing="0" style="width: 100%" id="Table_DSF-Top5">
<body text="#000000" link="#000000" vlink="#333333" alink="#333333">
         <tr>
           <td colspan="4"><span class="small"><font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">
           Die '. $topic_limit .' letzten Themen im Forum</font></span></td><br>
         </tr>
         <tr>
 
            <td style="width: 20%"><span class="small">
            <strong>
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Foren</font></strong>
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:9px"></font
            </strong></span></td>
            <td style="width: 20%"><span class="small">
            <strong>
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">User</font>
            </strong>
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:9px"></font
            </strong></span></td>
            <td style="width: 20%"><span class="small">
            <strong>
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Datum</font>
            </strong></span></td>
            <td style="width: 20%"><span class="small"><strong>
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">Thema</font>
            </strong>
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:9px"></font
            </strong></span></td>
 
         </tr>';
// ############## output ##############
 
$where_forums = ( $special_forums == '0' ) ? '' : 't.forum_id NOT IN ('. $forum_ids .') AND ';
$sql = "SELECT t.*, f.forum_id, f.forum_name, u.username AS first_poster, u.user_id AS first_poster_id, u2.username AS last_poster, u2.user_id AS last_poster_id, p.post_username AS first_poster_name, p2.post_username AS last_poster_name, p2.post_time
   FROM ". $table_prefix ."phpbb_topics t, ". $table_prefix ."phpbb_forums f, ". $table_prefix ."phpbb_users u, ". $table_prefix ."phpbb_posts p, ". $table_prefix ."phpbb_posts p2, ". $table_prefix ."phpbb_users u2
   WHERE $where_forums t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id
   ORDER BY t.topic_last_post_id DESC LIMIT $topic_limit";
$result = mysql_query($sql);
if( !$result )
{
   die('SQL Statement Error: '. mysql_error());
   exit();
}
 
$line = array();
while( $row = mysql_fetch_array($result) )
{
   $line[] = $row;
}
 
for( $i = 0; $i < count($line); $i++ )
{
   $forum_id = $line[$i]['forum_id'];
   $forum_url = $root_path .'viewforum.php?f='. $forum_id;
   $topic_id = $line[$i]['topic_id'];
   $topic_url = $root_path .'viewtopic.php?t='. $topic_id;
 
   $topic_title = ( strlen($line[$i]['topic_title']) < $topic_length ) ? $line[$i]['topic_title'] : substr(stripslashes($line[$i]['topic_title']), 0, $topic_length) .'...';
 
   $topic_type =  ( $line[$i]['topic_type'] == '2' ) ? 'Announcement ': '';
   $topic_type .= ( $line[$i]['topic_type'] == '3' ) ? 'Global Announcement ': '';
   $topic_type .= ( $line[$i]['topic_type'] == '1' ) ? 'Sticky ': '';
   $topic_type .= ( $line[$i]['topic_vote'] ) ? 'Poll ': '';
 
   $views = $line[$i]['topic_views'];
   $replies = $line[$i]['topic_replies'];
 
   $first_time = date('d.m.Y', $line[$i]['topic_time']);
   $first_author = ( $line[$i]['first_poster_id'] != '-1' ) ? '<a href="'. $root_path .'profile.php?mode=viewprofile&u='. $line[$i]['first_poster_id'] .'" target="_blank">'. $line[$i]['first_poster'] .'</a>' : ( ($line[$i]['first_poster_name'] != '' ) ? $line[$i]['first_poster_name'] : 'guest' );
   $last_time = date('d.m.Y', $line[$i]['post_time']);
   $last_author = ( $line[$i]['last_poster_id'] != '-1' ) ? $line[$i]['last_poster'] : ( ($line[$i]['last_poster_name'] != '' ) ? $line[$i]['last_poster_name'] : 'guest' );
   $last_url = '<a href="'. $root_path .'viewtopic.php?p='. $line[$i]['topic_last_post_id'] .'#'. $line[$i]['topic_last_post_id'] .'" target="_blank">'. $last_author .'</a>';
 
   // ############## output ##############
   echo '<tr>
 
            <td style="width: 20%"><a href="'. $forum_url .'" target="_blank">
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $line[$i]['forum_name'] .'</font></a></td>
            <td style="width: 20%">
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $last_url .'</font></td>
            <td style="width: 20%">
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $last_time .'</font></td>
            <td style="width: 20%"><a href="'. $topic_url .'" target="_blank">
            <font face="Verdana, Arial, Helvetica, sans-serif" style="font-size:11px">'. $topic_title .'</font></a></td>
 
        </tr>';
 
   // ############## output ##############
}
 
echo '</table>';
 
            $sql = 'SELECT COUNT(post_id) FROM phpbb_posts';
if (!$result = mysql_query($sql))
{
  die('Fehler: ' . mysql_error());
}
$post_count = mysql_result($result, 0);
echo "Anzahl an Beiträgen im Forum: " . $post_count;
mysql_free_result($result);
 
mysql_close();
?>

Zuletzt modifiziert von eisvogel10 am 02.01.2010 - 15:06:59

Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Module und Modifikationen » Forenticker