Great module the only thing I wish is it had address support for cities or at least zip codes, especially considering the location module provides a city table. Otherwise seems solid, thanks for the commit.

CommentFileSizeAuthor
#4 paises.txt5.31 KBmguarinoni

Comments

johnhanley’s picture

Yeah, cities add an extra layer of bloat (database wise) if you're expecting a cities dropdown to be populated for a particular state/province. I suppose a text field could be added to allow the user to manually enter their city. I have actually considered doing this for zip code/postal code, which would be more useful because it'd be easy to look-up the user's city.

I'll keep this in mind. A bounty would be gladly welcomed.

johnhanley’s picture

Title: No support for City » Add support for City and/or Zip
summit’s picture

would love to have this also on D6!

mguarinoni’s picture

Title: Add support for City and/or Zip » Spanish Country Translate - simple script
Version: 5.x-1.2 » 6.x-1.2
Component: Code » Documentation
Assigned: Unassigned » mguarinoni
Category: feature » support
Issue tags: +spanish, +country, +translate
StatusFileSize
new5.31 KB

This script translate countries names in profile_location_country table, it need paises.txt that is attached in this post.

require_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

$handle = fopen("paises.txt", "rb");
$contents = '';
while (!feof($handle)) {
  $contents = fgets($handle, 4096);
  $aux=explode(",",$contents);
  db_query("UPDATE {profile_location_country} SET name = '".$aux[3]."' WHERE iso = '".$aux[2]."';");
}
fclose($handle);
johnhanley’s picture

Title: Spanish Country Translate - simple script » Add support for City and/or Zip

Thanks for the sharing the script, but please leave the original title intact.

johnhanley’s picture

Assigned: mguarinoni » Unassigned
johnhanley’s picture

Status: Active » Closed (fixed)

The existing 5.x/6.x branches of Profile Location have reached the end of their life cycle and no additional features will be added.