View Top 20 Sites in Admin Section

[persut]

1) in admin/summery.php

add code at the end of the top categories code after the } around line 169

// top listings
	
  $query = "select title, hits from idx_link where hits > 0 order by hits desc";
  $result = $conn->Execute($query);
  $total = $result->RecordCount();
	
	$number=$i=0;
	while($i<20 && $i<$total) {
	
	  $result->move($i);
	  $cid = $result->Fields("category_id");
      $hits = $result->Fields("hits");
	  $title = $result->Fields("title");
	  $url = $result->Fields("url");
		
		if($i%2) $tbl_class = "tbl_light";
		else $tbl_class = "tbl_light2";
		
		$number++;
	
		$top_listings_by_hits .= "
		  <tr class=$tbl_class>
			  <td align=left width=15>$number.</td>
				<td align=left><a href=$url>$title</a></td>
				<td align=right>$hits</td>
			</tr>
		";
		$i++;
	}

then in admin_tpl add to the summery.html

<!-- top listings -->

<table cellpadding='1' cellspacing='0' border='0' align='center' width='90%' class=tbl_border>
<tr>
  <td>
    <table cellpadding='4' cellspacing='0' border='0' width='100%'>
      <tr>
        <td class=tbl_caption colspan="4">Top listings by hits       </td>
      </tr>
			
			<%top_listings_by_hits%>
			
    </table>    
  </td>
</tr>
</table>

<p>&nbsp;
<!-- top listings -->

[Veg]

Many thanks for the contribution.

It is always appreciated.

[tjoerg]

Hello persut,

you might have a look at:
http://www.nicecoder.com/community/s...?threadid=1308

greets

[persut]

basicly thats what i did(from other post), but i also created a new page for top 100 of each website and listing. and added links in the summery page.