Hello support at Joomprod,
Please I am using Ads Manager Internationally. People will post ads from different countries and cities. I can't manually add all the cities and towns in the whole world. So I am using Google Map for my users to choose their locations.

I need the locations in the Ads list view page but I don't want the map on the ads list view page. The map takes a lot of space, as It makes it difficult to see the city by name and creates too many details on the ads list view page.

Please is there away to just have the city or the location as a text but not a map?

Alternatively, please do you have list of all countries, towns and cities I can just dump in my database to create all the worldwide locations? Or can you please give any guide about any third party data I can get somewhere to dump in my database to create these locations on my site?

Thank you admin for your reply.

Actually I do not need the countires/cities/towns and the maps at the same time. What I want is to get rid of the map on the list view page but have only the city/town/country on the list view page. I think that is how it's supposed to be in Adsmanager. While It makes sense to have map at the details page it doesnt look good at all to have map on every ad at the list view page.

Now that you have suggested geonames.org, I will try it. But please how is it going to be? I First, I will have to create All countries under as parent field called "Country" in Joomla admin and then create a conditional field for it called "Cities/Towns" in Joomla admin, then paste the countries database in PHPMyAdmin in the "ad_country" table and do same for the "ad_citytown" table?

If this is within your support scope, please can you give me better idea how to use the database collected from Geonames.org?
Thank you

Hello juloadmin,
Thank you for the response.
I am still working on this. Hopefully, in the future, I will have the out of the box sql tables for others who might also want this featureI am looking for.