网络营销电子商务研究中心 - Front page "Latest Links" and "Top Links" (phpld)

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

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

- - Front page "Latest Links" and "Top Links" (phpld) (https://www.0058.net/showthread.php?t=2557)

Front page "Latest Links" and "Top Links" (phpld)

I would like to add my Latest Links and my Top Links to my index page instead of having a seperate page for them. How would I go about doing this?

Try this:

Open index.php and find:

Code:

echo $tpl->fetch('main.tpl', $id);

BEFORE that add this code:

Code:

$top10 = $db->GetOne("SELECT * FROM {$tables['link']['name']} WHERE STATUS = 2 ORDER BY HITS DESC LIMIT 0,10");

$last10 = $db->GetOne("SELECT * FROM {$tables['link']['name']} WHERE STATUS = 2 ORDER BY ID DESC LIMIT 0,10");

$tpl->assign('top10', $top10);

$tpl->assign('last10', $last10);

Open main.tpl

Where you want the top10 list to appear add:

Code:

{foreach from=$top10 item=link name=links}

{$link.URL}



{/foreach}

Where you want the last10 list to appear add:

Code:

{foreach from=$last10 item=link name=links}

{$link.URL}



{/foreach}

I've added the code and got it up and running, but, it's showing on all my pages, how can I limit it to the frontpage only?