<?
if($SERVER_NAME==localhost){
$mysql_server = "localhost";
$mysql_user = "root";
$mysql_pass = "pollak";
$mysql_db = "hs";
}
else {
$mysql_server = "**********";
$mysql_user = "*******";
$mysql_pass = "*******";
$mysql_db = "******";
}
$forum_url = "forum"; // url zum Forum ohne das "/"
$maxlen = "40"; // kürzt die Überschrift nach X Zeichen
$show = "5"; // zeigt X Threads an
mysql_connect("$mysql_server","$mysql_user","$mysql_pass") OR DIE ("- <a href=\"$forum_url\" target=\"_blank\">$forum_url</a><br>\n");
mysql_select_db("$mysql_db");
$totalposts = mysql_query("SELECT postid as count FROM post");
$posts = mysql_fetch_array($totalposts);
$kram = mysql_query("SELECT threadid, title, forumid, lastpost, lastposter, iconid, postuserid, replycount, views FROM thread WHERE forumid = 2 OR forumid = 7 OR forumid = 3 OR forumid = 11 ORDER BY lastpost DESC LIMIT 0,$show");
while ($thread=mysql_fetch_array($kram)) {
$topic_long = $thread[title];
$clicks = $thread[views]; // hier werden die Klicks gezählt
$poster = $thread[lastposter] ; // wie heisst der gute Poster :)
$userinfo = $thread[postuserid] ; // ID des Posters ermitteln
$antworten = $thread[replycount] ; // Anworten werden gezählt
if (strlen($thread[title])>=$maxlen)
{
$thread[title]=substr($thread[title],0,$maxlen)."...";
}
$datum = date("H:i:s","$thread[lastpost]");
?>
Demo;
http://s-c.zocker-forum.de/