<?


include_once('connect.php');


$area_sql = mysql_query("SELECT * FROM `score3` WHERE `hotfrog` = '0' ORDER BY results_for ASC LIMIT 1");

if(!mysql_num_rows($area_sql)){echo 'done';die;}
while($area_row = mysql_fetch_array($area_sql)){

$mid=$area_row['score_id'];
$mcat_name =$area_row['results_for'];
$mcat_name = str_replace("'","",$mcat_name);
$cat_name =strtolower($area_row['results_for']);
$cat_name = str_replace(' ','-',$cat_name);

}

$left = (2690845-$mid);
echo $mid; echo '<hr>';
echo $cat_name; echo '<hr>';


 $proxy_proxy = '195.102.23.53:80';
 $url = 'http://www.hotfrog.co.uk/Products/'.$cat_name;

 

  $curl = curl_init(); 
  curl_setopt($curl, CURLOPT_URL, $url); 
  curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); 
  curl_setopt($curl, CURLOPT_TIMEOUT, 10); 
  curl_setopt($curl, CURLOPT_HEADER, TRUE);
  curl_setopt($curl, CURLOPT_FOLLOWLOCATION, TRUE);
  curl_setopt($curl, CURLOPT_PROXY, $proxy_proxy); 
  curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/7 GTB5');
  $get = curl_exec($curl); // execute the curl command 
  curl_close($curl);

//echo  $url; echo "<hr>";


if (!strpos($get,'Reed Business Information')) { echo 'error';  echo '<meta http-equiv="refresh" content="1" />'; die; }



if (strpos($get,'Page extinct')) { mysql_query("UPDATE score3 SET hotfrog='1' WHERE results_for='$mcat_name'"); echo updates; 
} else {
//echo $get; die;
 $getmaincat = preg_match('/<h1>(.*)<\/h1>/smi', $get, $maincat);
$maincat = $maincat[1]; $maincat = str_replace("&#39;","",$maincat); $maincat = str_replace("'","",$maincat); $maincat = str_replace("-"," ",$maincat);
echo "$maincat <hr>";

$alllinks = preg_match_all('#http://www.hotfrog.co.uk/Products/([^/]*)">#iU', $get, $links); 



foreach($links[1] as $keywords){
$keywords = str_replace('-',' ',$keywords); $keywords = str_replace("'","",$keywords);
echo "<br>$keywords";
$keywords=str_replace("'","",$keywords); $keywords=str_replace("&#39;","",$keywords); $keywords=str_replace(" & "," And ",$keywords); $keywords=strtolower($keywords);

mysql_query("INSERT INTO score3 SET result='{$keywords}', results_for='{$maincat}' on duplicate key update pop=pop+100");
}

mysql_query("UPDATE score3 SET hotfrog='1' WHERE results_for='$mcat_name'");

}


 



?>
<meta http-equiv="refresh" content="0" />