[DEV] jQ User Map api3

[4seven]

I dont know, why v.0.0.3 dont work for you and why much updates?
There is only one Install as ModX which you can install via AutoMod.
Just look for jQ_User_Map_api3_v.0.0.3.zip. Only additional thing is,
that you must build 2 CPF Fields before you install the mod.

That wont change in v.1.0.0.

The only fix @ this time is this
viewtopic.php?f=3&t=109&p=760#p728

Impossible to register, the forum refuses my answer anti-spam

Just give the right answer.

[tester]

Ok,

I download the V0.0.3 archive from the first page of this topic and i follow the instruction including in the install.xml file…

And nothing…

I started again three times, installed, uninstalled, reinstalled…

Follow the basics instructions (before off course)…

And always nothing…

The user map page is empty : no user !

In my UCP, i can't fill the Custom Profile Field, when i cam again in my profile page, it is empty… impossible to fill it.

I'm very disappointed :/

[4seven]

From hundreds of succesfull installs you are the first, where it dont work.
So check the pre-install and the main install again and again.

And if some thing dont work, tell me exactly what dont show up etc. etc.

And always nothing…

Not very informativ. Have you installed v.0.0.3 via AutoMod?

If not, build the needed SQL columns with MySQL or MySQLDumper..

Code: Select all

ALTER TABLE phpbb_users ADD user_map_latitude varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_map_longitude varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_jq_online int(1) NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_map_location varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_map_location_desc varchar(400) COLLATE utf8_bin NOT NULL DEFAULT '0';

..and switch on the Debug Mode in config.php.
So you can see error messages, if any. Thats helpfull.

[MaamuT]

Yess, finally registered;)

Thx for your patience, I all will start again while following your instructions.

I did not use automod, I made a manual installation (how to use automod ?).

I will activate the debug mode and I return here if they are still not good.

[4seven]

AutoMod

https://www.phpbb.com/customise/db/offi ... l/automod/
https://www.phpbb.com/customise/db/offi ... /faq/f_792

[MaamuT]

Wahou, prompt response

I am on my fourth attempt…

Suspense…

[MaamuT]

Hop ! :

Code: Select all

- Open user_weather/user_map_config.php and check all settings, before you ask anything

Is it normal that nothing occurs when I load this page ?

When i send my new profile :

Code: Select all

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' user_map_longitude = , user_map_location = 'le_tampon' WHERE user_id = 213' at line 2 [1064]

[4seven]

Code: Select all

- Open user_weather/user_map_config.php and check all settings, before you ask anything

Is it normal that nothing occurs when I load this page ?

Its just a config file. Do all relevant settings here and load it up again

When i send my new profile :

Code: Select all

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' user_map_longitude = , user_map_location = 'le_tampon' WHERE user_id = 213' at line 2 [1064]

Check the installation again. Seems you dont have make the SQL Install.
viewtopic.php?f=2&t=200&p=779#p774

[MaamuT]

Check the installation again. Seems you dont have make the SQL Install.
viewtopic.php?f=2&t=200&p=779#p774

I made well this action in PhpMyAdmin, the tables were indeed modified.

EDIT :

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_user_map.php on line 239: file_get_contents() [function.file-get-contents]: URL file-access is disabled in the server configuration
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_user_map.php on line 239: file_get_contents(http://maps.google.com/maps/api/geocode/json?address=56+rue+benjamin+hoarau+le+tampon&sensor=false) [function.file-get-contents]: failed to open stream: no suitable wrapper could be found

I had not seen this part of the message of debug :/

If i load the api page with the CPF content, the result are ok…

I am seeking an alternative to the function file_get_contents, grumffffff

[MaamuT]

Yupi !

The problem came well from the function file_get_contents, deactivated by my provider, as well as the function fopen…

My solution, use curl function :

Code: Select all

//$geo_map = file_get_contents('http://maps.google.com/maps/api/geocode/json?address=' . $profile_fields_town_map . '&sensor=false');

// file_get_content alternative (if bloqued by provider)
$get_url = 'http://maps.google.com/maps/api/geocode/json?address=' . $profile_fields_town_map . '&sensor=false';
$get_content = curl_init();
curl_setopt($get_content, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($get_content, CURLOPT_URL, $get_url);
$geo_map = curl_exec($get_content);