No replies to this topic

[visiblesoul]

This is a hack that allows you display Highest Rated/Most Voted Topsites using my existing "Latest TopSites block 1.0" available at the link below. The topsites will be displayed in the block in the same order they are displayed in the Topsite module itself.

http://www.visiblesoul.net/resources/downl...ils.php?file=75


FIND:

$query = $DB->query("SELECT id, title, link, banner, banner2 FROM mkp_topsite WHERE validate = '1' ORDER BY id DESC LIMIT $limit");

REPLACE WITH:

$query = $DB->query("SELECT id, title, link, banner, banner2, click, rate, trate FROM mkp_topsite WHERE validate = '1' ORDER BY `trate` DESC, `rate` DESC, `click` DESC LIMIT $limit");

-=DKC=-