- Home
- Categorie
- Coding e Sistemistica
- PHP
- Modifica a Script per gli ultimi 10 topic
-
Modifica a Script per gli ultimi 10 topic
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 ""; } // Free Result mysql_free_result($result); // Close the Connection mysql_close($link);Grazie mille
-
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 ""; } // Free Result mysql_free_result($result); // Close the Connection mysql_close($link);Grazie mille
-
Ciao EthanDane,
nellla query quando estrapoli i topic basta dirgli di non prenderli dall'ID del forum che vuoi.
Se il tuo forum privato ha un id 15 allora aggiundi
AND forum_id!=15
-
Grazie mille giorgio
-
Salve mi associo pure io.
Ho creato in html la home del mio sito e vorrei inserire nella home gli ultimi messaggi 5 o 10 dal forum in phpbb, come posso fare?
Grazie
-
risollevo il topic
