List top sites that link back to your Dirtectory

[wesece]

Here is a little motivation for your customers to link back to your site.

See the "Top Sites with Recip." link on our Home page on the left side.

This will list the most popular links that have a reciprocal link!

here is how to get this done...

Edit Index.php:

Find:

Code:

      case 'top':
         $links = $db->GetAll ("SELECT * FROM `{$tables['link']['name']}` WHERE `STATUS` = '2' {$expire_where} ORDER BY `HITS` DESC LIMIT 0, ".LINKS_TOP);
$path[] = array ('ID' => '0', 'TITLE' => _L('Top Hits'), 'TITLE_URL' => '', 'DESCRIPTION' => '');
         break;

After add:

Code:

      case 'linkback':
         $links = $db->GetAll ("SELECT * FROM `{$tables['link']['name']}` WHERE `STATUS` = '2' AND `RECPR_URL` > '0' {$expire_where} ORDER BY `HITS` DESC LIMIT 0, ".LINKS_TOP);
$path[] = array ('ID' => '0', 'TITLE' => _L('LinkBack Sites'), 'TITLE_URL' => '', 'DESCRIPTION' => '');
         break;

Thats it..
Simply call this link using:

Code:

<a href="{$smarty.const.DOC_ROOT}/index.php?list=linkback">some text here</a>

For support start a new thread please.

[shadav]

v3.4
index.php
Find:

Code:

      case 'top':
         $links = $db->CacheGetAll ("SELECT * FROM `{$tables['link']['name']}` WHERE (`STATUS` = '2' OR {$permission_links_arts}) {$email_conf} {$expire_where} ORDER BY `HITS` DESC LIMIT 0, ".LINKS_TOP);
         $path[] = array ('ID' => '0', 'TITLE' => _L('Top Hits'), 'TITLE_URL' => '', 'DESCRIPTION' => '');
         break;