Subversion Repositories eFlore/Applications.coel

Rev

Rev 1696 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1696 Rev 1713
Line 39... Line 39...
39 
}
 39 
}
Line 40... Line 40...
40 
 
 40 
 
41 
printf("cache already contains %d entries, will start in 4 seconds:\n", count($cache));
 41 
printf("cache already contains %d entries, will start in 4 seconds:\n", count($cache));
Line 42... Line -...
42 
sleep(4);
 - 
 
43 
 
 - 
 
44 
// correction
 - 
 
45 
$db->query('UPDATE coel_structure SET cs_longitude = REPLACE(cs_longitude, ",", "."), cs_latitude = REPLACE(cs_latitude, ",", ".")');
 - 
 
46 
$db->query('ALTER TABLE coel_structure MODIFY cs_longitude DOUBLE(12,9) NULL DEFAULT NULL');
 - 
 
47 
$db->query('ALTER TABLE coel_structure MODIFY cs_latitude DOUBLE(12,9) NULL DEFAULT NULL');
 - 
 
48 
$db->query('UPDATE coel_structure SET cs_latitude = NULL, cs_longitude = NULL WHERE cs_latitude = "0" AND cs_longitude = "0"');
 42 
sleep(4);
49 
$db->query('UPDATE coel_structure SET cs_nbre_personne = NULL WHERE cs_nbre_personne = 0');
 43 
 
50 
// smooth:
 44 
// smooth:
51 
$q = "SELECT * FROM coel_structure".
 45 
$q = "SELECT * FROM coel_structure".
52 
	" WHERE cs_latitude IS NULL OR cs_latitude = '' OR cs_longitude IS NULL".
 46 
	" WHERE cs_latitude IS NULL OR cs_latitude = '' OR cs_longitude IS NULL".