Samuele E. Locatelli
43 lines
1.1 KiB
PHP
43 lines
1.1 KiB
PHP
<?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();
|
|
?>
|