sql voor uitlezen database phpbb3.

[denis]

• Adres van je forum: http://18+
  Event. modificaties op je forum:
  Wanneer ontstond het probleem?
  phpBB versie:3.0.10
  
  
  Heb je onlangs iets veranderd aan je forum?
  Wat is het probleem?

Hallo mensen.
ik zoek de sql voor uitlezen database phpbb3 omdat ik de laatste 5 berichten wil plaatsen op een frontpage buiten het forum om.
echter wil me dat maar niet lukken.
Wie kan me helpen hieraan.
Gaat me enkel om de sql code om de berichten uit te lezen en deeerste 10 karaters te displayen op de frontpage.

dit heb ik nu,

Code: Selecteer alles

<?php

// Freeware by Scriptol.com

// User configuration: update these data according to your own website

$site = "http://www.xxxxxxxxxx.nl/";
$forumdir = "***********/";
$formatflag = false;

// End of user configuration

$cvt = array( 
   "(´)"=>"'",
   "(à)"=>"&agrave;",
   "(â)"=>"&acirc;",
   "(ä)"=>"&auml;",
   "(ç)"=>"&ccedil;",
   "(è)"=>"&egrave;",
   "(é)"=>"&eacute;",
   "(ê)"=>"&ecirc;",
   "(ë)"=>"&euml;",
   "(î)"=>"&icirc;",
   "(ï)"=>"&iuml;",
   "(ô)"=>"&ocirc;",
   "(ö)"=>"&ouml;",
   "(ù)"=>"&ugrave;",
   "(ü)"=>"&uuml;",
   "(û)"=>"&ucirc;",
   "(«)"=>"&laquo;",
   "(»)"=>"&raquo;",
   "(©)"=>"&copy;",
   "(§)"=>"&para;",
);   
   

// Use this function only if the format differs

function convert($content)
{
    $len = count($cvt);
    while($htmlchar = current($cvt))
    {
      $letter = key($cvt);
      preg_replace($letter, $htmlchar, $content);
      next($cvt);
    }
    return $content;
}  

// Use  to convert to UTF-8

function makeUTF($desc)
{  
  $desc = UTF8_encode($desc);
  $desc = stripslashes($desc);
  return($desc);
}  



function display($host, $dbname, $dbuser, $password, $size)
{
    global $site;
    global $forum;
    global $topiclist;
    global $table_prefix;     

    $db = @mysql_connect($host, $dbuser,$password);
    mysql_select_db($dbname);
 
    $posts = $table_prefix."posts";
    $users = $table_prefix."users"; 
    $top = $table_prefix."topics";
  
/*    
    $sql = "SELECT REF.post_id, TOP.topic_id, TXT.post_subject, REF.post_time, USER.username, TOP.topic_first_post_id
     FROM $posts REF, $texts TXT, $users USER, $top TOP
     WHERE REF.post_id = TOP.topic_first_post_id
     AND REF.post_id = TXT.post_id
     AND USER.user_id = TOP.topic_poster 
     ORDER BY post_time DESC LIMIT $size";
 */  
  
      $sql = "SELECT TOP.topic_id, TOP.topic_title, TOP.topic_time, USER.username 
     FROM $posts REF, $users USER, $top TOP
     WHERE REF.post_id = TOP.topic_first_post_id     
     AND TOP.topic_poster = USER.user_id
     ORDER BY REF.post_time DESC LIMIT $size";






   
     // optionally:  AND TOP.forum_id IN (1,2,4,5, ...)  
     
    $results = mysql_query($sql) or die(mysql_error());
     
    // Extracting and displaying titles
      
    while($line = mysql_fetch_assoc($results)) 
    {
       $title = $line['topic_title'];
       //$title = $line['post_subject'];
       $url = $forum . "viewtopic.php?t=" . $line['topic_id'];
       
       if($formatflag) $title = convert($title);

       $username = $line['username'];
       $date = strftime("%A %B %e, %Y %H:%M", $line['topic_time']+(0));
     
       echo "<span class=style2><a target=k href='$url'>*$title*</a><hr></span><br>\n";
    }
     
}

if(substr($site, -1, 1) != "/") $site = $site. "/";
$forum = $site . $forumdir;
if(substr($forum,-1, 1) != "/") $forum = $forum. "/";

include($forumdir."config.php");

if (! PHPBB_INSTALLED) die("phpBB not installed in $forumdir");

display($dbhost, $dbname , $dbuser, $dbpasswd , 5);     

?>

[Pola]

Ik stel voor dat je het volgende Wiki bericht bekijkt: Toon laatste berichten extern.

Als je er aan de hand van dat artikel niet uitkomt, wil je dan aangeven wat er niet werkt of fout gaat?