- $updateTime = $address['updateTime'];
- $gmapsGeocoder = new GMapsGeocoder();
- $address = $gmapsGeocoder->getGeocodedAddress($address);
-
- if (!isset($address['geoloc'])) {
- XDB::execute('DELETE FROM profile_addresses
- WHERE pid = {?} AND id = {?} AND type = {?}',
- $address['pid'], $address['id'], $address['type']);
-
- Geocoder::getAreaId($address, 'administrativeArea');
- Geocoder::getAreaId($address, 'subAdministrativeArea');
- Geocoder::getAreaId($address, 'locality');
- XDB::execute('INSERT INTO profile_addresses (pid, type, id, flags, accuracy,
- text, postalText, postalCode, localityId,
- subAdministrativeAreaId, administrativeAreaId,
- countryId, latitude, longitude, updateTime, pub, comment,
- north, south, east, west)
- VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?},
- {?}, {?}, FROM_UNIXTIME({?}), {?}, {?}, {?}, {?}, {?}, {?})',
- $address['pid'], $address['type'], $address['id'], $flags, $address['accuracy'],
- $address['text'], $address['postalText'], $address['postalCode'], $address['localityId'],
- $address['subAdministrativeAreaId'], $address['administrativeAreaId'],
- $address['countryId'], $address['latitude'], $address['longitude'],
- $updateTime, $address['pub'], $address['comment'],
- $address['north'], $address['south'], $address['east'], $address['west']);
- } else {
- XDB::execute('UPDATE profile_addresses
- SET postalText = {?}
- WHERE pid = {?} AND id = {?} AND type = {?}',
- $address['postalText'], $address['pid'], $address['id'], $address['type']);
- }
-
- sleep(60); // So we don't get blacklisted by Google.