[3.2][3.3][BETA] Usermap for phpBB

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Suggested Hosts
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
User avatar
Mike-on-Tour
Registered User
Posts: 152
Joined: Wed Jan 15, 2020 3:51 pm
Location: Germany
Name: Michael
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Mike-on-Tour »

Hm, that is weird, the line numbers don't match with my original file 'main_listener.php'. :o
What did you do before this error occurred? And did it happen only once?
All other functions do work properly?
Watz fo lunch?
If you like my extensions and maybe want to buy me lunch: Image
User avatar
Mike-on-Tour
Registered User
Posts: 152
Joined: Wed Jan 15, 2020 3:51 pm
Location: Germany
Name: Michael
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Mike-on-Tour »

I have just tried this request in my browser, it seems that you haven't enabled your account for the free web service, please refer to the explanation for the Geonames user in the ACP.
Watz fo lunch?
If you like my extensions and maybe want to buy me lunch: Image
User avatar
Jorup16
Registered User
Posts: 426
Joined: Sun Dec 14, 2008 5:13 am
Location: Zacapa, Guatemala
Name: Jorge
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Jorup16 »

Mike-on-Tour wrote:
Thu May 14, 2020 9:28 pm
Hm, that is weird, the line numbers don't match with my original file 'main_listener.php'. :o
What did you do before this error occurred? And did it happen only once?
All other functions do work properly?
Well I didn't actually do anything, I just activated the extension and registered on the page as the instructions indicate.

Mike-on-Tour wrote:
Thu May 14, 2020 9:47 pm
I have just tried this request in my browser, it seems that you haven't enabled your account for the free web service, please refer to the explanation for the Geonames user in the ACP.

Apparently if I'm registered, my username appears in the corner. In addition, a user validation email arrived.



EDIT:
It was a problem in user activation. It is assumed that I had already activated my user through the email I received, but it was not.

So I had to click on this link for the free service to be activated.

https://www.geonames.org/enablefreewebservice
Spanish Translations for Ext phpBB :D - Traducciones al español para Ext phpBB :)
>>>>> https://github.com/Jorup16 <<<<<
User avatar
Jorup16
Registered User
Posts: 426
Joined: Sun Dec 14, 2008 5:13 am
Location: Zacapa, Guatemala
Name: Jorge
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Jorup16 »

Is there a problem with Ecuador's postal codes? I have some Ecuadorian users and they cannot see the map.

I thought it was a problem with my site, so I changed my zip code in your test forum but it didn't work.


Zip Code 010107 - Ecuador
Spanish Translations for Ext phpBB :D - Traducciones al español para Ext phpBB :)
>>>>> https://github.com/Jorup16 <<<<<
User avatar
Dr.Death
Registered User
Posts: 400
Joined: Fri Apr 25, 2003 10:04 am
Location: Germany
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Dr.Death »

Take a look here:

https://www.geonames.org/postal-codes/

If the country is not listed, it will not work.


Maybe the Extension Author should remove the not listet countries.
Last edited by Dr.Death on Sat May 16, 2020 2:00 pm, edited 1 time in total.
Doc.
User avatar
Mike-on-Tour
Registered User
Posts: 152
Joined: Wed Jan 15, 2020 3:51 pm
Location: Germany
Name: Michael
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Mike-on-Tour »

Either removing them from the list or mark them as unservicable sounds like a good idea. I will look into this.
I have to admit that I haven't thought about this possibility.
Watz fo lunch?
If you like my extensions and maybe want to buy me lunch: Image
User avatar
Jorup16
Registered User
Posts: 426
Joined: Sun Dec 14, 2008 5:13 am
Location: Zacapa, Guatemala
Name: Jorge
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Jorup16 »

Dr.Death wrote:
Sat May 16, 2020 10:56 am
Take a look here:

https://www.geonames.org/postal-codes/

If the country is not listed, it will not work.


Maybe the Extension Author should remove the not listet countries.

Indeed, Ecuador does not appear in that list.
Spanish Translations for Ext phpBB :D - Traducciones al español para Ext phpBB :)
>>>>> https://github.com/Jorup16 <<<<<
User avatar
3Di
Former Team Member
Posts: 16052
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano 🇮🇹 - Frankfurt 🇩🇪
Name: Marco
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by 3Di »

An User Map can only work with Geo Location (GPS coordinates) IMHO.

Postal codes are not the way to go,
I do not know if there is a service which provides all of the world-wide postal codes but I do not think so, at least for free.
To request support for our extensions you can also contact me here: phpBB Studio

Please PM me only to request paid works. Thx. Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
🚀 Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
Jorup16
Registered User
Posts: 426
Joined: Sun Dec 14, 2008 5:13 am
Location: Zacapa, Guatemala
Name: Jorge
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Jorup16 »

Spanish Translations for Ext phpBB :D - Traducciones al español para Ext phpBB :)
>>>>> https://github.com/Jorup16 <<<<<
User avatar
Mike-on-Tour
Registered User
Posts: 152
Joined: Wed Jan 15, 2020 3:51 pm
Location: Germany
Name: Michael
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Mike-on-Tour »

Jorup16 wrote:
Sat May 16, 2020 4:36 pm
Spanish Translation:

https://www.solidfiles.com/v/LwnpD3KAXLDkA
Thanks a lot, Jorge (Thumb up!)
Watz fo lunch?
If you like my extensions and maybe want to buy me lunch: Image
User avatar
Mike-on-Tour
Registered User
Posts: 152
Joined: Wed Jan 15, 2020 3:51 pm
Location: Germany
Name: Michael
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Mike-on-Tour »

3Di wrote:
Sat May 16, 2020 4:28 pm
An User Map can only work with Geo Location (GPS coordinates) IMHO.

Postal codes are not the way to go,
I do not know if there is a service which provides all of the world-wide postal codes but I do not think so, at least for free.
Geonames.org provides the coordinates for the country code / postal code combination, sadly not for every country in the world.
The basic idea is that everybody knows the country and the postal code of the location he lives in; coordinates are something different and judging by some of the questions you get here in this forum I have my doubts that everybody can give proper coordinates for the place he lives.

I'm looking for a solution.
Watz fo lunch?
If you like my extensions and maybe want to buy me lunch: Image
User avatar
3Di
Former Team Member
Posts: 16052
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano 🇮🇹 - Frankfurt 🇩🇪
Name: Marco
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by 3Di »

There are the GPS coordinates for each city/village etc AFAIK, a generic one.

Example
https://www.latlong.net/place/berlin-germany-9966.html -
https://www.google.com/maps/place/52%C2 ... d13.404954

So ideally the logic should be:

1 - user input just the City/Country
2 - code searchs the GPS coordinates
3 - code places the location on the Map

here we need a library. Don't know if exists.
To request support for our extensions you can also contact me here: phpBB Studio

Please PM me only to request paid works. Thx. Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
🚀 Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
3Di
Former Team Member
Posts: 16052
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano 🇮🇹 - Frankfurt 🇩🇪
Name: Marco
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by 3Di »

Maybe it is worth to explore https://developers.google.com/maps/docu ... ding/start
Geocoding is the process of converting addresses (like a street address) into geographic coordinates (like latitude and longitude), which you can use to place markers on a map, or position the map.
To request support for our extensions you can also contact me here: phpBB Studio

Please PM me only to request paid works. Thx. Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
🚀 Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
thecaretaker1
Registered User
Posts: 101
Joined: Tue Dec 30, 2014 8:38 pm

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by thecaretaker1 »

Thought I'd give the Usermap extension a try. All registered and activated with Geonames.

When I try to add my post code and country in the user control panel (Profile) I am getting the following error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'pf.pf_phpbb_location' in 'field list' [1054]

SQL

SELECT u.user_id, u.username, u.user_colour, pf.pf_phpbb_location, pf.pf_mot_zip, pf.pf_mot_land FROM phpbb_profile_fields_data AS pf INNER JOIN phpbb_users AS u ON pf.user_id = u.user_id WHERE u.user_id = 2

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/mot/usermap/event/main_listener.php
LINE: 391
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/mot/usermap/event/main_listener.php
LINE: 259
CALL: mot\usermap\event\main_listener->process_user_profile_data()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 214
CALL: mot\usermap\event\main_listener->ucp_profile_info_modify_sql_ary()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 44
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/includes/ucp/ucp_profile.php
LINE: 399
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: ucp_profile->main()

FILE: [ROOT]/ucp.php
LINE: 407
CALL: p_master->load_active()
I already have 2 custom profiles on my forum. Could this be the issue?
User avatar
Mike-on-Tour
Registered User
Posts: 152
Joined: Wed Jan 15, 2020 3:51 pm
Location: Germany
Name: Michael
Contact:

Re: [3.2][3.3][BETA] Usermap for phpBB

Post by Mike-on-Tour »

The extension is missing the predefined profile field 'location' which is by default part of phpbb. Did you by any chance remove it from your profile fields list?
The profile should look something like this (of course there can be more fields):
UCP_Profile1.jpg
Watz fo lunch?
If you like my extensions and maybe want to buy me lunch: Image
Post Reply

Return to “Extensions in Development”