Salve a tutti, per il mio forum di discussione phpBB uso un piccolo script che mi permette di stampare gli ultimi 10 topic.
Mi domandavo come faccio a non far apparire anche i topic privati? ossia quelli che riguardano i forum privati e non al pubblico?
Lo script è il seguente:
Codice PHP:
// Basic Configuration
// How Many Topics you want to display?
$topicnumber = 10;
// Scrolling towards up or down?
$scroll = "up";
// Change this to your phpBB path
$urlPath = "http://www/forum";
// Database Configuration (Where your phpBB config.php file is located
include './forum/config.php';
// Connecting & Selecting Databases
$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");
// Perform Sql Query
$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");
// Outcome of the HTML
// Be carefull when you edit these!
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$topic_title=substr("$row[topic_title]", 0, 24);
$topic_title = preg_replace("/<(.*?)>/","",$topic_title);
$topic_title = ereg_replace( "<[^<>]+>", "", $topic_title );
$topic_title = str_replace("\"",""",$topic_title);
print "<ul>";
echo "[*]<a href=\"$urlPath/viewtopic.php?topic=$row[topic_id]&forum=$row[forum_id]\" title=\"Forum Cellulari\">» $topic_title " .
".." .
" </a><img src=\"http://www.cellulartopic.com/images/ico_topics.gif\" alt=\"vai al topic sul cellulare\" />";
print "[/list]";
}
// Free Result
mysql_free_result($result);
// Close the Connection
mysql_close($link);
Grazie mille