<?php
$ini = parse_ini_file("conf.ini", true);


mysql_connect($ini['db']['host'], $ini['db']['user'], $ini['db']['pass']);
mysql_select_db($ini['db']['db']);

$row_limit=250000;
$distance_ref=-1;
$keep_going=1;
$counter=0;

while ($keep_going){
	$sql2 = mysql_query("SELECT reg_id,ABS(last_latitude-0)+ABS(last_longitude-0) as distance FROM gcm where notification_eqn=1 and reg_id<>'' and ABS(last_latitude-0)+ABS(last_longitude-0)>$distance_ref ORDER BY distance ASC limit $row_limit");
	
	$num_rows2 = mysql_num_rows($sql2);
	print($num_rows2."\n");
	if ($num_rows2>0){
		while ($data = mysql_fetch_assoc($sql2)) {
			$regidArray[] = $data['reg_id'];
			$distanceArray[] = $data['distance'];
		}
		$distance_ref=end($distanceArray);
		print(count($regidArray));
		
		print($distance_ref."\n");
		//sleep(1);
		//$files = glob($folder_eqn.'/*',GLOB_MARK);
		//foreach ($files as $file) {
		//		unlink($file);
		//}
		//rmdir($folder_eqn.'/');
		unset($distanceArray);
		unset($regidArray);
	}
	else{
		$keep_going=0;
	}
	$counter=$counter+1;
}
print($counter);
mysql_close();
?>