top 5 by hits on index page

[esm]

in the function ShowMainPage of the index.php file:

change the following:

  // mod for $top_links_by_hits
  global $category,$new_links,$hot_links,$login_box,$rec_links,$recomended_listing,
	  $total_link,$total_hits,$total_category,$total_member,$total_milis,$top_links_by_hits;

then after the line "$new_links = $new_links_obj->Display();" insert the following:

// mod for top5 by hits
  $query = "select link_id, title, url from idx_link where hits > 0 order by hits desc";
  $result = $conn->Execute($query);
  $total = $result->RecordCount();
	$number=$i=0;
	while($i<5 && $i<$total) {
	  	$result->move($i);
	  	$lid = $result->Fields("link_id");
		$title = $result->Fields("title");
		$url = $result->Fields("url");
		$number++;
		$top_links_by_hits .= "$number. <a href=detail.php?id=$lid>$title</a><br>";
		$i++;
    }
// mod end

change the following:

// mod for $top_links_by_hits
  DisplayTemplate($theme_path."index.html",
	  "\$category,\$new_links,\$top_links_by_hits,\$hot_links,\$login_box,".
		"\$rec_links,\$recomended_listing,".
		"\$total_online,\$members_online,\$guess_online,\$username_online,".
		"\$total_link,\$total_hits,\$total_category,\$total_member,\$total_milis");

then in index.html of the themes/default folder, add the following where you want it to print out:
<%top_links_by_hits%>



Anyone know how to stop vB from inserting extra lines into the code or from wapping the line in the middle of a word???
I love vB! I love vB! I love vB!

[dody]

what is the different with TOP 10 listing in index.php
You can set how many list in admin cp -> setup -> Main Hot Link Limit

[esm]

hey, this was 5 days ago. How do you expect me to remember that far back.

I did it in response to http://www.nicecoder.com/community/s...&threadid=1482

it may be a duplicate