<?
include("/usr/home/explorexxx/domains/baberankings.com/admin/conf/cj_rerank.conf");
include("/usr/home/explorexxx/domains/baberankings.com/admin/conf/mysql.conf");
$TABLE_STATS = "stats";
$TABLE_SITES = "sites";

if ($hour_t) { 
	$last_24 = time() - 90000;
	$text_q2 = "unix_timestamp($TABLE_STATS.id)>$last_24";
} else {
	$date = date("Y-m-d");
	$text_q2 = "$TABLE_STATS.id LIKE '$date%'";
}
$dblnk = @mysql_connect("$DB_HOST","$DB_USER","$DB_PW");

$query = "select $TABLE_SITES.id,$TABLE_SITES.site_name,$TABLE_SITES.url,$TABLE_SITES.domain,sum($TABLE_STATS.uniq) as uniq_hits from $TABLE_SITES, $TABLE_STATS where $text_q2 and $TABLE_STATS.siteid=$TABLE_SITES.id and $TABLE_SITES.out_type !=0 group by $TABLE_SITES.id order by uniq_hits DESC";
$result = mysql_db_query($DB_NAME, $query, $dblnk);
$a=1; $flag=0;
while(list($id, $site_name, $url,$domain,$uniq) = mysql_fetch_row($result)) {
	if ($domain != "bookmarks") {
		if ($site_name=="") { $site_name=$domain; }
		$top[$a]="$uniq|$url|$site_name|";
		$a++;
		$flag=1;
	}
}
mysql_close($dblnk);

if ($flag==1) {
	$info_ar = file("$path_to_index");
	$temp_ar = file("$path_to_template");
	for(reset($info_ar); list($key,$value) = each($info_ar); ) { $info.= $value; }
	for(reset($temp_ar); list($key,$value) = each($temp_ar); ) { $temp.= $value; }
	$info = str_replace("\n","<!-#New#->",$info);
	$temp = str_replace("\n","<!-#New#->",$temp);

	for ($i=1; $i<=$canbe; $i++) {
		$part = split("\|",$top[$i]);
		$to_look_link = "<!--".$i."l-->";
		$to_look_name = "<!--".$i."n-->";
		$to_look_hits = "<!--".$i."h-->";
		$link = $url_to_send.$part[1];
		$temp = str_replace($to_look_link,$link,$temp);
		$temp = str_replace($to_look_name,$part[2],$temp);
		$temp = str_replace($to_look_hits,$part[0],$temp);
	}
	 $to_look1 = "<!--Top_Begin-->";
	 $to_look2 = "<!--Top_End-->";
	 $patt = "/$to_look1(.*)$to_look2/";
	 $temp = $to_look1.$temp.$to_look2;
	 $info = preg_replace($patt, $temp, $info);
	 $info = str_replace("<!-#New#->","\n",$info);

	$fp = fopen("$path_to_index","w");
	flock($fp,2);
	fputs($fp, $info);
	flock($fp,3);
	fclose($fp);
}
?>