[Wildthinks]

Hi everybody.... here come a little tutorial for last threads on your mainpage ... demo hier: http://swishzone.net

Ok
1. Install webtemplates from logician :lick:

2. create a query called: _last_10_threads

PHP Code:

query name:
_last_10_threads

query:
SELECT thread.title as threadname, thread.threadid,  thread.forumid, from_unixtime(post.dateline,'%d.%m.%Y - %H:%i:%s') as dd, left(post.pagetext,80) as pagetxt, post.username, post.userid, forum.forumid, forum.title FROM thread,post,forum where post.threadid=thread.threadid and   thread.forumid=forum.forumid and thread.forumid<>20 and thread.forumid<>9 and thread.forumid<>32 order by post.dateline desc limit 10

Description: what you want
no result text: what you want


table row:
<tr id="catportalleft">
<td>
<b><smallfont><a href="$bburl/forumdisplay.php?s=&forumid=??thread.forumid?? title="Klick hier um zum Forum zu kommen">Forum: ??Forum.title??</a></b></smallfont>
<tr>
<td><smallfont><b><a href="$bburl/showthread.php?s=&threadid=??threadid??" title="Klick hier um zum Thema zu kommen"><b><img src="$bburl/https://vborg.vbsupport.ru/images/icons/icon1.gif" valign="bottom" alt="Arrow" border="0">Title: ??threadname??<b></a></b> 
<tr>
<td>
<smallfont>??pagetxt??... [<a href="$bburl/member.php?s=&action=getinfo&userid=??post.userid??" title="Profile von ??post.username?? ansehen">??post.username??</a>]</smallfont></td>
</tr>
<tr>
<td bgcolor="{alternate}"><smallfont>
??dd??</smallfont></td>
</smallfont>
<td>
</tr>
</td>
</tr>
<td>-</td> 


3. create webtemplate

PHP Code:

Templatename: last10threads
pagecount: what you want (0 is good)

Template:
[cansee]everybody[/cansee] [options]templatequeryon[/options] 
<table cellpadding="4" cellspacing="1" border="0" width="100%"> 
<tr id="catportalleft"> 
<td><normalfont color="#FFF788"><b>Letzten 10 Themen </b></normalfont></td> 
</tr> 
$_last_10_threads
</table> 


4. include wherever you want this:

PHP Code:

<?php include ("http://www.yourdomain.de/vbdir/show.php?pg=last10threads"); ?>

That's all and works fine on my site....

The last posts with Date, Poster, Forumname and the first 80 Characters... in this version from Webtemplates dont work the smilies...but Logician is going with the development... i hope