arkadaşlar vbulletin son konuları başka sayfada gösterirken şu kodları kullanıyoruz.
<?
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "root"; // Change this to the name of your database.
$db_user = "forum"; // Change this to your database username.
$db_pw = ""; // Change this to your database password.
$forum_url = "http://forum.shaltr.com"; // Change this to reflect to your forum's URL.
$forum_id = ""; // If you wish to display the posts from a specific forum, enter the forum id here. Otherwise, leave it blank.
$limit = "10"; // Number of posts displayed.
$titlecolor = "#FF0000"; // This is the color of the title.
$postedcolor = "#FFFFFF"; // This is the color of the bottom text.
$txtlimit = "100"; // This is the character limit.
#######################################
// Connecting to your database
mysql_connect($db_host, $db_user, $db_pw)
OR die ("Cannot connect to your database");
mysql_select_db($db_name) OR die("Cannot connect to your database");
// Below is the beginning of a table. If you feel you don't need it, you may remove it.
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" bgcolor=\"#000000\">";
if ($forum_id) {
$forumid = "AND forumid=$forum_id";
}
if ($limit) {
$limited = "LIMIT $limit";
}
$thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter FROM thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost DESC $limited");
while($thread_get=mysql_fetch_array($thread_sql))
{
$lastpost = $thread_get['lastpost'];
$poster = $thread_get['lastposter'];
$tid = $thread_get['threadid'];
$psql = mysql_query("SELECT postid FROM post WHERE threadid=$tid ORDER BY postid DESC");
$getp=mysql_fetch_array($psql);
$pid = $getp['postid'];
$date2 = date ("m/d/y h:i A" ,$lastpost);
$title = $thread_get['title'];
$title = substr($title,0,$txtlimit);
echo "<tr><td><font size=\"2\" face=\"verdana,arial,geneva\"><a href=\"$forum_url/showthread.php?p=$pid#post$pid\" target=\"_blank\"><FONT SIZE=\"2\" COLOR=\"$titlecolor\" face=\"verdana,arial,geneva\">$title</FONT></a></font><br /><font color=\"$postedcolor\" face=\"verdana,arial,geneva\" size='1'>gönderen: $poster </FONT></td></tr>";
}
echo "</table>";
?>
burdaki forum id yi ben birden fazla forumdan çekmek istiyorum son konuları onu nası yapcam mesela yönetici bölümü var ondan çekmek istemiyorum diğer tüm idleri gircem onlardan çekcek fakat , koyunca olmuyo nasıl yapacağım ?
Vbulletin Son Konularda forum İd hakkında soru
6
●1.319
- 23-09-2007, 12:07:14Misafir adlı üyeden alıntı: mesajı görüntüle
arkadaşlar ben bunu nasıl kayan olarak yapabilriim bunlar altta altta - 05-12-2008, 17:36:00
<? $db_host = "localhost"; // Change this if your MySQL database host is different. $db_name = "root"; // Change this to the name of your database. $db_user = "forum"; // Change this to your database username. $db_pw = ""; // Change this to your database password. $forum_url = "http://forum.shaltr.com"; // Change this to reflect to your forum's URL. $forum_id = ""; // If you wish to display the posts from a specific forum, enter the forum id here. Otherwise, leave it blank. $yasak_id = "49,55"; // forum_id boş olucak ve gorunmesini istemediğiniz idleri aralarına , kullanarak giriniz. $limit = "10"; // Number of posts displayed. $titlecolor = "#FF0000"; // This is the color of the title. $postedcolor = "#FFFFFF"; // This is the color of the bottom text. $txtlimit = "100"; // This is the character limit. ####################################### // Connecting to your database mysql_connect($db_host, $db_user, $db_pw) OR die ("Cannot connect to your database"); mysql_select_db($db_name) OR die("Cannot connect to your database"); // Below is the beginning of a table. If you feel you don't need it, you may remove it. echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" bgcolor=\"#000000\">"; if ($forum_id) { $forumid = "AND forumid=$forum_id"; } else { if ($yasak_id) { $yasak_id = explode(",",$yasak_id); for ($i=0;$i<count($yasak_id);$i++) $forumid .= " AND forumid<>$yasak_id[$i]"; } } if ($limit) { $limited = "LIMIT $limit"; } $thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter FROM thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost DESC $limited"); while($thread_get=mysql_fetch_array($thread_sql)) { $lastpost = $thread_get['lastpost']; $poster = $thread_get['lastposter']; $tid = $thread_get['threadid']; $psql = mysql_query("SELECT postid FROM post WHERE threadid=$tid ORDER BY postid DESC"); $getp=mysql_fetch_array($psql); $pid = $getp['postid']; $date2 = date ("m/d/y h:i A" ,$lastpost); $title = $thread_get['title']; $title = substr($title,0,$txtlimit); echo "<tr><td><font size=\"2\" face=\"verdana,arial,geneva\"><a href=\"$forum_url/showthread.php?p=$pid#post$pid\" target=\"_blank\"><FONT SIZE=\"2\" COLOR=\"$titlecolor\" face=\"verdana,arial,geneva\">$title</FONT></a></font><br /><font color=\"$postedcolor\" face=\"verdana,arial,geneva\" size='1'>gönderen: $poster </FONT></td></tr>"; } echo "</table>"; ?>
başka bi çözüm yolu varmı ?