Code: Select all
<html>
<head>
<title>Poor man's portal</title>
</head>
<body>
<?php
$dbhost = 'localhost:3036';
$dbuser = 'someuser;
$dbpass = 'somepasswd';
//PHP Version 5.3.29
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn ) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully<p>';
mysql_select_db( 'someDB' );
$sql = "SELECT topic_title,topic_poster,topic_time,username,user_email FROM phpbb_topics,phpbb_users WHERE topic_poster=user_id";
$res = mysql_query($sql);
while ($data = mysql_fetch_assoc($res)) {
$date_published = date('r', $data['topic_time']);
echo "Title: " . $data['topic_title'] . "<br>" . "Time: ". $date_published . "<br>" . " Poster: ". $data['username'] . "<br>" . " Email: ". $data['user_email'] . "<p>";
}
echo "Fetched data successfully\n<p>";
mysql_close($conn);
?>
</body>
</html>
TBH that's one page I never use, to the extent that I removed it from my menu* to save clutter. The only ones I ever use are "Unread posts" and, very occasionally, "Active topics".