<?


include_once('connect.php');


$area_sql = mysql_query("SELECT * FROM `cats` WHERE `test` = 'fff' AND `cat_name` LIKE '%s' AND `cat_name` NOT LIKE '%ies' LIMIT 1");

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

$mid=$area_row['cat_id'];
$mcat_name =$area_row['cat_name'];
$cat_name =strtolower($area_row['cat_name']);
$cat_name = str_replace(' ','-',$cat_name);
$cat_name = substr_replace($cat_name,"",-1);

}
echo $mid; echo '<hr>';
echo $cat_name; echo '<hr>';



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

 
 echo  $url; echo "<hr>";
  $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);




if (!strpos($get,'Reed Business Information')) { echo 'error';  die; }

//echo $get; 

if (strpos($get,'Page extinct')) { mysql_query("UPDATE cats SET test='not' WHERE cat_id='$mid'"); echo updates; 
} else {
//echo $get; die;
 $getmaincat = preg_match('/<h1>(.*)<\/h1>/smi', $get, $maincat);
$maincat = $maincat[1]; $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);
echo "<br>$keywords";
mysql_query("INSERT INTO score SET result='{$keywords}', results_for='{$maincat}'");
}


if ($keywords) {mysql_query("UPDATE cats SET cat_name='$maincat',test='s' WHERE cat_id='$mid'"); echo updates; } else {mysql_query("UPDATE cats SET cat_name='$maincat',test='ns' WHERE cat_id='$mid'"); echo updates;}
}






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