<?php
set_time_limit(0);
include_once 'lib/php/include/dbConstants.php';

$adv_keywords = array();
	//$expire = "900";
	//$mkey = md5("crawler_advKeywords");
	//if(!$adv_keywords = mCache::mGet()->get($mkey)){
		$db = mysql_connect (MSACOMMON_DB_HOST_ADMIN, MSACOMMON_DB_USER_ADMIN, MSACOMMON_DB_PASS_ADMIN);
		@mysql_select_db ("Admin", $db);
		if($db)
			echo "db <br>";
		$kSql = "SELECT ck.keyword from campaign_keywords ck left join campaign c on (ck.campaign_id = c.id) where c.status = 'A'";
		$kRes = mysql_query($kSql, $db);
		echo mysql_num_rows($kRes)."<br>";
		/*while($kRow = mysql_fetch_assoc($kRes))
		{	
			if($kRow['keyword'] && !in_array($kRow['keyword'], $adv_keywords))
				$adv_keywords[] = $kRow['keyword'];
		}*/
		
		$bSql = "SELECT bk.keyword from ads_campaign_keywords_broadmatch bk left join campaign c on (bk.campaign_id = c.id) where c.status = 'A'";
		$bRes = mysql_query($bSql, $db);
		echo mysql_num_rows($bRes)."<br>";
		/*while($bRow = mysql_fetch_assoc($bRes))
		{
			if($bRow['keyword'] && !in_array($bRow['keyword'], $adv_keywords))
				$adv_keywords[] = $bRow['keyword'];
		}*/
		
		var_dump($adv_keywords);
		//mCache::mGet()->set($mkey, $adv_keywords, 0, $expire);
	//}
	//else
	//	echo "mc";
	//return $adv_keywords;
?>