• 07-09-2007, 22:29:26
    #1
    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 ?
  • 07-09-2007, 22:39:37
    #2
    if ($forum_id) {
    $forumid = "AND forumid=$forum_id"
    ;
    }

    bu kısmı
    $forumid = "AND forumid<>4";

    şeklinde deneyiniz, 4 sizin yönetici forumunun id si
  • 07-09-2007, 22:49:39
    #3
    olmadı kardeş başka bi çözüm yolu varmı ?
  • 08-09-2007, 04:22:46
    #4
    başındaki if li kısmı da sildin dimi?
  • 23-09-2007, 12:07:14
    #5
    Misafir adlı üyeden alıntı: mesajı görüntüle
    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 ?


    arkadaşlar ben bunu nasıl kayan olarak yapabilriim bunlar altta altta
  • 05-12-2008, 15:13:08
    #6
    Eposta Aktivasyonu Gerekmekte
    sadece 2 tane forumu bu linklerin dışında tutmak istiyorum
    mesela
    49 ve 55 id li forumları bunu nasıl yaparım
  • 05-12-2008, 17:36:00
    #7
    <?
    $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>";
    
    ?>