<?


include 'connect.php';

//SELECT * FROM articles  WHERE MATCH(title, body) AGAINST ('PHP')


$area_sql = mysql_query("SELECT * FROM `ads` WHERE boz = '' ORDER BY adid ASC LIMIT 1");
if(!mysql_num_rows($area_sql)){echo 'done';die;}
while($area_row = mysql_fetch_array($area_sql)){


$madid=$area_row['adid'];
$mcategory=$area_row['category'];
//$category=mysql_escape_string($area_row['category']);
//$stripped_name=str_replace(" ", " +", $stripped_name);
echo "$madid: $mcategory<br>";
//echo $mcategory;
$mcategory = array_filter(explode(' || ',$mcategory));

foreach($mcategory as $val) {

//echo "$val<hr>";

$area_sql2 = mysql_query("SELECT * FROM `cats2` WHERE name = '{$val}' LIMIT 1");
if(mysql_num_rows($area_sql2)){$makit .= " || $val";} 
 
}
if($makit) {$makit= "$makit || "; mysql_query("UPDATE ads SET category='{$makit}', boz='1',`seo_title`='' WHERE adid = '{$madid}'");} else {mysql_query("UPDATE ads SET category='', boz='1',`seo_title`='' WHERE adid = '{$madid}'");}
echo $makit;
//ECHO "SELECT * FROM cats2 WHERE MATCH(name) AGAINST ('+$stripped_name' IN BOOLEAN MODE')";

//if($tagid) {ECHO "<HR>$tagid";  mysql_query("UPDATE cats2 SET del='1' WHERE tagid = '{$tagid}'");}

}


	//mysql_query("UPDATE towns_new SET junk='1' WHERE town_id = '{$mtown_id}'");




?>

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