Bu sekliyle istedigim bölümden en son eklenen 10 konuyu gösteriyorum.
Ama benim istedigim onlarin normal konu adinda link olmasi degil.
Ben onu eklentideki resmi veya konu icindeki ilk resmi gösterip resme tikladiklarinda gitmelerini istiyorum.
Konun icindeki ilk resmi cekmesi süper olur ama olacagini düsünmüyorum .O yüzden en mantiklisi eklenti ama konu icindeki ilk resmi gösterirse süper olur.
Cok sey istiyorum sanirim
Not : Veri Vbulletinden cekliyor.
<?
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "xxxxx"; // Change this to the name of your database.
$db_user = "xxxxx"; // Change this to your database username.
$db_pw = "xxxxx"; // Change this to your database password.
$forum_url = "http://www.xxxxxx.net"; // Change this to reflect to your forum's URL.
$forum_id = "xxxx"; // 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 = "#000000"; // 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=\"#FFFFFF\">";
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['threads[x]'];
$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>";
?>Yardimi dokunan herkeze simdiden tesekkürler