phpBB.nl

Code: Selecteer alles

<?php
// Aantal topics om te tonen
define("TOPIC_COUNT", 10);

// Pad naar directory
define("PHPBB_PATH", "../forum/");

// URL naar phpBB 2 dir
define("PHPBB_LOCATION", "http://www.treinenplace.nl/forum/");

// Tijdformaat in PHP date()
define("TIME_FORMAT", "H:i");

// includeer de meuk
$phpbb_root_path = PHPBB_PATH;
if ( !defined('IN_PHPBB') )
{
  define('IN_PHPBB', true);
  include(PHPBB_PATH . 'extension.inc');
  include(PHPBB_PATH . 'config.'.$phpEx);
  include(PHPBB_PATH . 'includes/constants.'.$phpEx);
  include(PHPBB_PATH . 'includes/db.'.$phpEx);
}

// sql statement to fetch active topics van public forums
$sql = "SELECT DISTINCT t.topic_title, t.topic_last_post_id, p.post_time, f.forum_name
  FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . FORUMS_TABLE . " AS f
  WHERE
    t.forum_id = f.forum_id
      AND f.auth_view = " . AUTH_ALL . "
      AND p.topic_id = t.topic_id
      AND p.post_id = t.topic_last_post_id
  ORDER BY p.post_time DESC LIMIT " . TOPIC_COUNT;
$nt_result = $db->sql_query($sql);

if(!$nt_result)
{
    die("Failed obtaining list of active topics".mysql_error());
}
else
{
    $nt_data = $db->sql_fetchrowset($af_result);
}

if ( count($nt_data) == 0 )
{
    die("No topics found");
}
else
{
  /// functie om strings op te kappen  ////
function breekaf($variabele) {
        if(strlen($variabele) > 24) {
$variabele = substr($variabele,0,24) ."..";
                         }
      else {
}
  return $variabele;
}
////// functie einde! /////////

  // $nt_data contains all interesting data
  for ($i = 0; $i < count($nt_data); $i++)
  {

    $title = $nt_data[$i]['topic_title'];
    $url = PHPBB_LOCATION . 'viewtopic.' . $phpEx . "?" . POST_POST_URL . "=" . $nt_data[$i]['topic_last_post_id'] . "#" . $nt_data[$i]['topic_last_post_id'];
    $on_forum = '- ' . $nt_data[$i]['forum_name'] . ' forum';
    $post_time = date(TIME_FORMAT, $nt_data[$i]['post_time']);

?>
  <li><?php echo $post_time; ?> -
    <a href="<?php echo $url; ?>" title="<?php echo "$title $on_forum"; ?>"><?php echo(breekaf("$title")); ?></a></li>

<?php

  }
}
?>