This use on the Web, outside phpbb

Code: Select all

<?php
$topicnumber = 10;
$urlPath = "http://www.phpbb.sk";
include 'config.php';
$table_topics = $table_prefix. "topics";
$table_forums = $table_prefix. "forums";
$table_posts = $table_prefix. "posts";
$table_users = $table_prefix. "users";
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
mysql_select_db("$dbname") or die("Could not select database");
$query = "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 $table_topics t, $table_forums f, $table_posts p, $table_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 $topicnumber";
$result = mysql_query($query) or die("Query failed");
print "<table class='bodyline' width='180' border='0' cellspacing='1' cellpadding='4'><tr><td class='cat' align='center'><span class='cattitle'>Posledné témy</span></td></tr>";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo  "<tr><td class='row1'><span class='siteTextMed'>&bull; " . date('d M Y', $row["post_time"]) . "</span><br /><span class='siteTextSmall'><a href=\"$urlPath/viewtopic.php?t=$row[topic_id]\">" . $row["topic_title"] . "</a></span></td></tr>";
}
print "</table>";
mysql_free_result($result);
?>

He knew could this somebody adjust like this that it will be screen seo addresses et non viewtopic.php?t=1

thx

Maybe you could start working from this script, as it's already checking censoring and such.

It should be easy to adapt the output to what you like.

++

thx

dcz wrote:Maybe you could start working from this script, as it's already checking censoring and such.

It should be easy to adapt the output to what you like.

++

I was trying this and doesn't work this repair me this this www.phpbb.sk/viewtopic.php?t= et non rewrite record

Try quoting my post and grab the code from there, there is a problem (it's adding spaces in the text breaking the code) with the wrapping function I never have time to fix

dcz wrote:Try quoting my post and grab the code from there, there is a problem (it's adding spaces in the text breaking the code) with the wrapping function I never have time to fix

ok, thx

Try I am this and doesn't work this.
http://www.phpbb.sk/features.php
he knew ought me repair the kod like this that functioned on 100% ?

Please post the code you are using

Code: Select all

<?php
$topicnumber = 10;
$urlPath = "http://www.phpbb.sk";
include 'config.php';
$table_topics = $table_prefix. "topics";
$table_forums = $table_prefix. "forums";
$table_posts = $table_prefix. "posts";
$table_users = $table_prefix. "users";
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
mysql_select_db("$dbname") or die("Could not select database");
$query = "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 $table_topics t, $table_forums f, $table_posts p, $table_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 $topicnumber";
$result = mysql_query($query) or die("Query failed");
print "<table class='bodyline' width='180' border='0' cellspacing='1' cellpadding='4'><tr><td class='cat' align='center'><span class='cattitle'>Posledné témy</span></td></tr>";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo  "<tr><td class='row1'><span class='siteTextMed'>&bull; " . date('d M Y', $row["post_time"]) . "</span><br /><span class='siteTextSmall'><a href=\"$urlPath/viewtopic.php?t=$row[topic_id]\">" . $row["topic_title"] . "</a></span></td></tr>";
}
print "</table>";
mysql_free_result($result);
?>

And non-he shows me references to last contribution but only on a given subject

I meant, the other one, as it is working, so I though I could see the mistake fast.

Your code is not checking censor nor it is able to use the format_url function, as it not in phpBB session.

So I think, starting from the other one would be better.

++