网络营销电子商务研究中心 - Last 10 listings on the main page only (phpld v2)

网络营销电子商务研究中心 (https://www.0058.net/index.php)

- Web Directory (https://www.0058.net/forumdisplay.php?f=60)

- - Last 10 listings on the main page only (phpld v2) (https://www.0058.net/showthread.php?t=2559)

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

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..

Place in main.tpl below {/strip}

Code:

<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);

Code:

$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);

Code:

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}

use

Code:

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

<br />

instead of

Code:

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