phpBB.de

Code: Alles auswählen

<?php
//Hier deine Daten eintragen
$host="localhost";
$username="phpbb";
$password="xxxx";
$database="phpbb";

//Verbindung zur Datenbank
mysql_connect($host, $username, $password);

//Datenbankauswahl
mysql_select_db($database);

 $sql = 'SELECT t.topic_id, t.topic_title, f.forum_name, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username'
        . ' FROM phpbb_topics t, phpbb_forums f, phpbb_posts p, phpbb_users u'
        . ' WHERE t.topic_id = p.topic_id AND '
        . ' f.forum_id = t.forum_id AND '
        . ' t.topic_status <> 2 AND '
        . ' p.post_id = t.topic_last_post_id AND '
        . ' p.poster_id = u.user_id'
        . ' ORDER BY p.post_id DESC LIMIT 5';
// wenn Abfrage möglich...
if ( $result = mysql_query($sql) )
{
   // dann Schleife solange ein Ergebnis ausgelesen werden kann...
   while ( $row = mysql_fetch_assoc($result) )
   {
      // mysql_fetch_assoc() füllt $row wie ein array() im Format: array('post_time' => 12345678)
      $frmDatum = date("d.m.Y", $row['post_time']);
      $frmZeit = date("H:i:s", $row['post_time']);
      $post = $row['post_id'];
      $forum_id = $row['forum_id'];
$sql_from = ' phpbb_forums f';
$lastread_select = ' f.forums';
$sql = "SELECT f.* $lastread_select
	FROM $sql_from
	WHERE f.forum_id = $forum_id;
$result = $database->sql_query($sql);
$forum_data = $database->sql_fetchrow($result)";

      echo "<font color=black size=2><a href=./forum/viewtopic.php?p=$post#p$post><font color=blue size=2>".$row['topic_title']."</a><br><font color=black size=2>$frmDatum $frmZeit <br></br>";
      echo "Im Forum: " . $forum_data['forum_name'] . "<br><br>";
   }
 
}
mysql_close();
?>

Code: Alles auswählen

<?php
//Hier deine Daten eintragen
$host="localhost";
$username="xxx";
$password="xxx";
$database="xxx";

//Verbindung zur Datenbank
mysql_connect($host, $username, $password);

//Datenbankauswahl
mysql_select_db($database);

 $sql = 'SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username'
        . ' FROM phpbb_topics t, phpbb_forums f, phpbb_posts p, phpbb_users u'
        . ' WHERE t.topic_id = p.topic_id AND '
        . ' f.forum_id = t.forum_id AND '
        . ' t.topic_status <> 2 AND '
        . ' p.post_id = t.topic_last_post_id AND '
        . ' p.poster_id = u.user_id'
        . ' ORDER BY p.post_id DESC LIMIT 5';
// wenn Abfrage möglich...
if ( $result = mysql_query($sql) )
{
   // dann Schleife solange ein Ergebnis ausgelesen werden kann...
   while ( $row = mysql_fetch_assoc($result) )
   {
      // mysql_fetch_assoc() füllt $row wie ein array() im Format: array('post_time' => 12345678)
      $frmDatum = date("d.m.Y", $row['post_time']);
      $frmZeit = date("H:i:s", $row['post_time']);
      $post = $row['post_id'];
// Eventuell musst du hier den Pfad ändern für den Link ins Forum
      echo "<font color=black size=2><a href=../phpbb3/viewtopic.php?p=$post#p$post><font color=black size=2>".$row['topic_title']."</a><br>$frmDatum $frmZeit<br></br>";
   }
}
mysql_close();
?>

Code: Alles auswählen

 <!-- BEGIN announcements -->
   <div style="width:280px;padding:10px;margin-bottom:30px;border:1px solid black;<!-- IF announcements.S_ROW_COUNT is odd -->float:left;margin-left:5px;<!-- ELSE -->float:left;margin-left:335px;<!-- ENDIF -->">
 <span class="recipe">{announcements.TOPIC_TITLE}</span>
     <p><span class="boxtext">{announcements.POST_TEXT}</span></p></div>
      <!-- END announcements -->