Merhaba arkadaşlar, sitemde özgün bir sayfaya vbulletin son konuları aşağıdaki kod yardımıyla çekiyorum. Aşağıdaki kod vbseoya uyarlanabilirmi ? yapabilen varsa çok sevinirim.
Code:Code:<?php $db_host = "localhost"; $db_name = "sql_name"; $db_user = "mysql_username"; $db_pw = "password"; $forum_url = "http://www.website.com/"; $forum_id = ""; $limit = "10"; $titlecolor = "#0099cc"; $postedcolor = "#000000"; $txtlimit = "100"; ####################################### 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"); echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" background=\"bg.jpg\">"; 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><li><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></td></tr></li>"; } echo "</table>"; ?>


LinkBack URL
About LinkBacks





Reply With Quote
Sordum gibi zaten... Ama lisanssız bir kullanıcının işinin görülmesine neden olmak etik gelmediği için öyle bi kaygıyla yazdım üstteki mesajımı...
