Possible to have the user's location show (via Gmap) within their profile page?

Create a block at admin/build/block and insert the following code (Drupal 5) Make sure you select php input filter.

if (arg(0)=='user' && is_numeric(arg(1))) {
   $block = array();
    $result = db_fetch_array(db_query("SELECT latitude, longitude FROM {location} WHERE eid = %d AND type = 'user'", arg(1)));
    if (!$result) {
      return;
    }
    $macro = variable_get('gmap_location_block_macro_'. $node->type, FALSE);
    if (!$macro) {
      $macro = variable_get('gmap_location_block_macro', '[gmap |zoom=10 |width=100% |height=200px |control=Small |type=Map]');
    }
    $map = array(
      '#map' => 'gmap_location_authorblock',
      '#settings' => gmap_parse_macro($macro),
    );
    $map['#settings']['behavior']['notype'] = TRUE;
    $map['#settings']['markers'] = array();
    $map['#settings']['markers'][] = array(
      'latitude' => $result['latitude'],
      'longitude' => $result['longitude'],
      'markername' => variable_get('gmap_user_map_marker', 'drupal'),
      'label' => check_plain($node->name),
    );
    $map['#settings']['latitude'] = $result['latitude'];
    $map['#settings']['longitude'] = $result['longitude'];

    print theme('gmap', $map);
}

Good Day,

I tried the code above but I am getting an error

user warning: Unknown column 'type' in 'where clause' query: SELECT latitude, longitude FROM cmmc_location WHERE lid = 1 AND type = 'user' in /hsphere/local/home/mysite.com/includes/database.mysql.inc on line 174.

Looking at the location table structure, there is no entry for eid. I do have lid. Any ideas?

Thank you,

Mark

The solution was for Drupal 5 not 6...

You'll have to debug the differences to get it to work in 6.

I think original post is for 5.7? Thanks.

The long way

The way I did it was to use advance profile kit + location module + nodeprofile + panels2 + gmap

once you configure all of the modules. In your user profile panel add the location map block.

@New Zeal

Thanks for the post man. I only changed this line:

$result = db_fetch_array(db_query("SELECT latitude, longitude FROM {location} WHERE eid = %d AND type = 'user'", arg(1)));

to this:

$result = db_fetch_array(db_query("SELECT latitude, longitude FROM {location} WHERE lid = %d", arg(1)));

Drupal 5.14

mherchel, which fix did you try?

another idea to try: use content profile, and add a cck field to the profile to display the map. (maybe by adding a view that finds the location for the uid for content profile type nodes, maybe with a relation on content profile, and use a display of a gmap... I know that is a lot of maybe's)

Also, try using the latest dev version, there have been a lot of commits and it might be working better in there.

Post back if you are still wanting to get this to work.

marked #360759: Help with map display within profile as a duplicate of this one. (It has a pointer to another module that might help as an alternative.)

marked #396618: Display user's location in a block as a duplicate of this one

That code works using Drupal6 and the actual location module. The only problem is ballon it's empty. How to customize baloon's content?

<?php
if (arg(0)=='user' && is_numeric(arg(1))) {
   $block = array();
    $result = db_fetch_array(db_query("SELECT latitude, longitude FROM {location} JOIN {location_instance} using(lid) WHERE uid = %d", arg(1)));
    if (!$result) {
      return;
    }
    $macro = variable_get('gmap_location_block_macro_'. $node->type, FALSE);
    if (!$macro) {
      $macro = variable_get('gmap_location_block_macro', '[gmap |zoom=10 |width=100% |height=200px |control=Small |type=Map]');
    }
    $map = array(
      '#map' => 'gmap_location_authorblock',
      '#settings' => gmap_parse_macro($macro),
    );
    $map['#settings']['behavior']['notype'] = TRUE;
    $map['#settings']['markers'] = array();
    $map['#settings']['markers'][] = array(
      'latitude' => $result['latitude'],
      'longitude' => $result['longitude'],
      'markername' => variable_get('gmap_user_map_marker', 'drupal'),
      'label' => check_plain($node->name),
    );
    $map['#settings']['latitude'] = $result['latitude'];
    $map['#settings']['longitude'] = $result['longitude'];

    print theme('gmap', $map);
}
?>

Same here... code from post #9 worked a treat. Thanks everyone.