<? 
include('db.php'); 
echo "Start"; 
$exclude = array('the','a','if','com','and','her','with'); 

$result = mysql_query("SELECT keywords FROM content WHERE keywords != '' AND enabled = 1 ORDER BY record_num DESC");
while($row = mysql_fetch_array($result)) {
	unset($arr);
	$arr = explode(',',$row[keywords]);
	foreach($arr as $i) {
		$allKeywords[] = trim($i); 
	}
}
mysql_query("TRUNCATE TABLE keywords");
foreach($allKeywords as $i) { 
		$qlower = mysql_real_escape_string(trim($i));
		if(strlen($qlower) > 2 && !in_array($qlower,$exclude)) {
		$result = mysql_query("SELECT word FROM keywords WHERE word = '$qlower'");
		if(mysql_num_rows($result) < 1) {
			mysql_query("INSERT INTO keywords (word, amount) VALUES ('$qlower',1)");
		}
		else {
			mysql_query("UPDATE keywords SET amount = amount+1 WHERE word = '$qlower'");
		}
		unset($result);
		}
}
echo "Done";
?>