editors pick 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 , $front_picks;

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

// mod for picks on the front page
  $query = "select link_id, title, url from idx_link where pick=1 order by date desc";
  $result = $conn->Execute($query);
  if($result) {
    $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++;
		$front_picks .= "$number. <a href=detail.php?id=$lid>$title</a><br>";
		$i++;
    }
  }
// mod end

change the following:

// mod for picks on the front page
  DisplayTemplate($theme_path."index.html",
	  "\$category, \$new_links, \$front_picks,\$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:
<%front_picks%>

to change the number that appears, change the 5 in the line

while($i<5 && $i<$total) {

haven't tried it, but it seems that it should work

[esm]

deleted

[lewisw]

For me to get it to work I needed to remove the last } before
// mod end.
Lewis

[esm]

yep, I also had to add the $front_picks.="</table>"; and the if ($result)

[lewisw]

Esm,
I would like to have front picks use the go.php instead of detail.php .
Where would I make this change ?
best
Lewis

[lewisw]

Never mind.
Sorry for the stupid question.

$front_picks .= "$number. <a href=detail.php?id=$lid>$title</a><br>";

It's in index.php