Deutscher

@Stefan Ok.. Now, all of us are waiting for Thomas Vielen Dank!

Vielen dank für Hilfe! I understand that : This is the original code of Thomas : $DB->query("SELECT tid, title, posts, last_poster_id as member_id, last_poster_name as member_name, last_post as post_date, views FROM ibf_topics WHERE state!='closed' AND approved=1 AND (moved_to IS NULL or moved_to='') $qe ORDER BY last_post DESC LIMIT 0,$limit"); and will be replaced with this? (your code) $DB->query("SELECT f.name, f.id, t.tid, t.title, t.posts, t.last_poster_id as member_id, t.last_poster_name as member_name, t.last_post as post_date, t.views FROM ibf_topics t LEFT JOIN ibf_forums f ON (t.forum_id = f.id) WHERE t.state!='closed' AND t.approved=1 AND (t.moved_to IS NULL or t.moved_to='') $qe ORDER BY last_post DESC LIMIT 0,$limit"); Am i right? So, i tried liked this but could not work :(

Thank you Thomas for this great script! I have a question.. When i click on the poster name, i want to show "the last post" instead of showing member info page. How can i do this? Which part of the script shoul be changed? (I'm sorry for my language. Actually i'm not a German but i love Germany and Germans. That's why my user name is always "Deutscher" ) Vielen dank! Regards..