phpBB.de

Code: Alles auswählen

<?
$MY_HOST = "localhost";
$MY_DB_NAME = "xxx";
$MY_USER = "xxx";
$MY_PASS = "xxx";
$MY_DB_TABLE = "phpbb_posts_text";
$num_view_message = 11;


$connect = mysql_connect($MY_HOST, $MY_USER, $MY_PASS);
if(! $connect)
die("KEINE VERBINDUNG ZUR SERVER");

mysql_select_db($MY_DB_NAME, $connect)
or die ("KEINE VERBINDUNG ZUR DATENBANK");
?>

<table border='0' cellpadding="4" cellspacing="1">

<?

$count_view = 0;

$topten = mysql_query("SELECT post_id, post_subject FROM $MY_DB_TABLE ORDER by post_id DESC");			
	while($toptenausgabe = mysql_fetch_object($topten)) {

$count_view++;

$topten_title = $toptenausgabe->post_subject;
$post_id_db = $toptenausgabe->post_id;

	$topten_id = mysql_query("SELECT topic_id FROM phpbb_posts WHERE post_id='$post_id_db'");			
		while($toptenausgabe_id = mysql_fetch_object($topten_id)) {
		$t = $toptenausgabe_id->topic_id;	
		}
if ( $count_view < $num_view_message ) {
?>

<tr><td class="mntopboard"><b>- <a href='viewtopic.php?t=<? echo $t; ?>' target='newbrows'><? echo $topten_title; ?></a>
</b></span></td>
</tr>
<? } } ?>
</table>

Code: Alles auswählen

SELECT p.post_id, if(length(pt.post_subject)>0, pt.post_subject, t.topic_title) AS title
FROM phpbb_posts p
JOIN phpbb_posts_text pt ON (p.post_id = pt.post_id)
JOIN phpbb_topics t ON (t.topic_id = p.topic_id)
ORDER by p.post_time DESC