<?


include_once('connect.php');


$area_sql = mysql_query("SELECT * FROM `cats3` WHERE `scoot` = '0' ORDER BY cat_id DESC 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 = str_replace('&amp;','And',$cat_name);
echo $mid; echo '<hr>';



 $proxy_proxy = '203.202.248.35:80';
 $url = 'http://www.scoot.co.uk/find/'.$cat_name.'-in-uk';
 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_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,'Get your free business listing')) { echo 'error'; echo '<meta http-equiv="refresh" content="0" />' ;die; }
else {

$regexp = "<a href=\"/find/(.*)\">(.*)</a>";
if(preg_match_all("#$regexp#siU", $get, $matches)) {


foreach($matches[2] as $keywords){
$keywords = str_replace(',','',$keywords);
echo "<br>$keywords";
$keywords=str_replace("'","",$keywords);
mysql_query("INSERT INTO score3 SET result='{$keywords}', results_for='{$mcat_name}'");

}
} 
if ($keywords) {mysql_query("UPDATE cats3 SET scoot='found',cat_name='{$cat_name}' WHERE cat_id='$mid'"); echo updates; } 
else { mysql_query("UPDATE cats3 SET scoot='not found',cat_name='{$cat_name}' WHERE cat_id='$mid'"); echo updates; }
}






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