<?
include '../connect.php';

$current_page=(int)(empty($_GET['page'])||$_GET['page']<=0 ? 1 : $_GET['page']); // setting as integer
$per_page=100;
$next=$current_page+1;
$start = ($current_page ? ($current_page - 1) * $per_page : 0);

$area_sql = mysql_query("SELECT * FROM ads WHERE aky_done='1' ORDER BY adid ASC LIMIT 100");
//$area_sql = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM ads WHERE aky_done=1 ORDER BY adid DESC LIMIT {$start},{$per_page}");
//$rowstotal = mysql_query("Select FOUND_ROWS()"); $rowstotal  = mysql_fetch_array($rowstotal);$rowstotal=$rowstotal[0];
$x = ($current_page!=1 ? ($current_page-1) * $per_page : 1);

while($area_row = mysql_fetch_array($area_sql)){ 
	foreach($area_row AS $key => $val) { $$key = stripslashes($val); }
 
 	$description = purify($description, false);
	$services_offered = (strpos($services_offered,'||') !== false ? '' : purify($services_offered, false));
	$refund = purify($refund, false);
	$areas_cover = purify($areas_cover, "Areas we cover: ");
	
	if(substr($establishment, -1) == '.'){$establishment = substr_replace($establishment ,"",-1);}
	if(is_numeric ($establishment)){$establishment = "We have been established since ".$establishment;}
	$establishment = purify($establishment.".", "Establishment: ");


	$desc = addslashes(trim("$description$services_offered$establishment$areas_cover$refund"));
			
	$r3 = mysql_query("UPDATE ads SET description = '{$desc}', aky_done = '0' WHERE adid = '{$adid}'") or die(mysql_error());
	

	echo "<b>$x</b> - $adid - $active<br>";echo nl2br($aky_text).'<hr>';$x++;
}

function purify($string, $addon){
	$na = array('na','n/a','n/a.','n / a','n / a.','N / a','N / a.','N/A','N / A','N / A.','N/ A','N /A','none','None','none.','None.');
	if($string && strlen($string) > 2 && !in_array($string, $na)){
		$string = trim(preg_replace('/\s+/', ' ', $string));
		if(substr($string, -1) == ','){$string = substr_replace($string ,"",-1);}
		if(substr($string, -2) == '!.'){$string = substr_replace($string ,"",-1);}
		if(substr($string, -2) == ',.'){$string = substr_replace($string ,".",-2);}
		if(substr($string, -1) != '!'){if(substr($string, -1) != '.'){$string.= '.';}}
		$string .= "\n\n";	
		return ucfirst(($addon!=false ? $addon.$string : $string));
	}else{
		return '';
	}
	
}

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

/* 
if(!($start>=$rowstotal-$per_page)){$pagin_html.='<a class="curv3 pgn" href="?page='.$next.'">Next &raquo;</a>';}else{$pagin_html.='<a class="curv3 pgn inactive deselect">Next &raquo;</a>';}
echo $pagin_html; */
?>

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