Last 10 listings on the main page only (phpld v2)

[smiling]

Hi

I know there is a similar thread in this forum but it's getting confusing and most importantly it didn't get me anywhere so I need to ask again if anyone can help me with this one...

I am using the latest free version of PHPLD (2) on my site and I need to display the last 10 listings on my main page.

It would be great if the mod is coded in a way that if I wanted to.. I could change the number of listing from let's say 10 to 15 and it would still work the same way.

Can anyone help me with this one pls?? I would really appreciate it someone could. I don't really wanna switch to any other script because I like everything about PHPLD..

[smiling]

Place in main.tpl below {/strip}
<table width=894" height="300" align="center" cellspacing="0" cellpadding="0" border="0">
<td width="50%" rowspan="0" border="0" valign="top">
{if count($top_ten) gt 0}
<h3>{l}Top Ten Links{/l}</h3>
{foreach from=$top_ten item=link name=links}
{include file="link.tpl" link=$link}
{/foreach}
{/if}</td>

<td width="50%" rowspan="0" border="0" valign="top">
{if count($last_ten) gt 0}
<h3>{l}Latest Ten Links{/l}</h3>
{foreach from=$last_ten item=link name=links}
{include file="link.tpl" link=$link}
{/foreach}
{/if}
</td>
</table>

Place in index.php above echo $tpl->fetch('main.tpl', $id);

$top_ten = $db->GetAll("SELECT * FROM `{$tables['link']['name']}` WHERE `STATUS` = '2' ORDER BY `HITS` DESC LIMIT 0, 10");
$last_ten = $db->GetAll("SELECT * FROM `{$tables['link']['name']}` WHERE `STATUS` = '2' ORDER BY `ID` DESC LIMIT 0, 10");
$tpl->assign('top_ten' , $top_ten );
$tpl->assign('last_ten', $last_ten);

[smiling]

Is there a way to get this on the main page ONLY?


phpld 2.0
{if $category.ID eq 0 and !$q and !$p}

your code here

{/if}

phpld 3.06
{if $category.ID eq 0 and !$list and !$search}

your code here

{/if}

[smiling]

use
<a href="{$link.URL}" target="_blank">{$link.TITLE}</a>
<br />

instead of {include file="link.tpl" link=$link}