DrupalBin

[Mon Jan 25 23:14:00 2010] [error] [client ::1] Array\n(\n    [q] => user/1/info/place_of_living\n    [lng] => 11.25\n    [lat] => 50.28933925329177\n    [country] => Deutschland\n    [region] => Th\xc3\xbcringen\n    [city] => Neuhaus-Schierschnitz\n)\n, referer: http://localhost:8080/drupal/user/1/info/edit

[Mon Jan 25 23:14:00 2010] [error] [client ::1] Array\n(\n    [q] => user/1/info/place_of_living\n)\n, referer: http://localhost:8080/drupal/user/1/info/edit

 

function profileadds_menu() {

        $items['user/%user_uid_optional/info/place_of_living'] = array(

          'page callback' => 'storeGeoData',

          'page arguments' => array(1),

          'access callback' => TRUE,

          'type' => MENU_CALLBACK,

        );

        return $items;

 

function storeGeoData ($account) {

       

        $gcity = check_plain($_GET['city']);

        $gcountry = $_GET['country'];

        $gregion = $_GET['region'];

        error_log(print_r($_GET, TRUE));

       

        $query = "SELECT birthdate_month, birthdate_day, birthdate_year, gender, languages, skype, msn, icq, mobile, telephone, address, zipcode, website, relationship, "

                              ." interests, clubs, advicedwebsites"

                        ."  FROM {profileadds} WHERE uid = %d";

                        $result = db_query($query, $account->uid);

        if(db_fetch_object($result)) {

                $query = "UPDATE {profileadds} SET country = '%s', region = '%s', city = '%s' WHERE uid = %d";

                db_query($query, $gcountry, $gregion, $gcity, $account -> uid);

        }

        else {

                $query = "INSERT INTO {profileadds} (uid, country, region, city) VALUES (%d, '%s', '%s', '%s')";

                db_query($query, $account -> uid, $gcountry, $gregion, $gcity);

        }