Google Mapinator

[Design75]

Google Mapinator has been updated to v1.0 and works with ZC v1.5.0. The update should be available in Free Addons soon.

[Design75]

I just updated the plugin to version 1.1,

New in this version are the sql auto-installer, the ability to specify the width and height of the map through the admin panel, and add a custom marker image if wanted.

[lat9]

Wow! Nice job on the installer. I previously had v0.12 and the upgrade instructions went smoothly.

The only suggestion that I have is the "future-proof" the plugin for PHP 5.5 and later where the mysql_ function calls will be deprecated. I changed /ADMIN/includes/functions/extra_functions/google_mapinator.php to contain:

<?php
  if (!function_exists('gm_check_field')) {
    function gm_check_field($tableName,$columnName){
      global $sniffer;
      
      return $sniffer->field_exists($tableName, $columnName);
      
    } //end of function
  }

... making use of the built-in Zen Cart class to "sniff" the database.

[Design75]

Wow! Nice job on the installer. I previously had v0.12 and the upgrade instructions went smoothly.

The only suggestion that I have is the "future-proof" the plugin for PHP 5.5 and later where the mysql_ function calls will be deprecated. I changed /ADMIN/includes/functions/extra_functions/google_mapinator.php to contain:

<?php
  if (!function_exists('gm_check_field')) {
    function gm_check_field($tableName,$columnName){
      global $sniffer;
      
      return $sniffer->field_exists($tableName, $columnName);
      
    } //end of function
  }

... making use of the built-in Zen Cart class to "sniff" the database.

Hi Lat9,
Thanks for the update. I copied the installer from a Numinix module, but I like it too. It can use a little change though. I saw that the late Connor Kerr had a check in his installers if a module is installed, so the installer doesn't need to run every time an admin page is loaded. But this was one of the first modules I dared to update ;) .

[creyesx6]

Thanks for the update and contribution. I am having a problem with the map displaying. I have been working on it for a couple hours and cannot fig Iure out why my map is blank. the url to view is www.casablancafurnitureinc.com. I added the API key, verified coordinates, installed properly, etc. But it's still not displaying, just blank. Any help would be appreciated. Thank you.

[badarac]

Thanks for the update and contribution. I am having a problem with the map displaying. I have been working on it for a couple hours and cannot fig Iure out why my map is blank. the url to view is www.casablancafurnitureinc.com. I added the API key, verified coordinates, installed properly, etc. But it's still not displaying, just blank. Any help would be appreciated. Thank you.

I had the same trouble yesterday. I found that a number of items were missing from the configuration tables after the install. I was doing an upgrade to a 1.3.8 site. The 1.3.8 site no longer worked due to a php version change. It had a prior version of mapinator installed. I wound up adding the items to the config table manually or correcting the ones that were already there assigned to the wrong config group. That's where I'd start looking. The sql is in the file 1_Install_Files/admin/includes/installers/new_install.php

[creyesx6]

I had the same trouble yesterday. I found that a number of items were missing from the configuration tables after the install. I was doing an upgrade to a 1.3.8 site. The 1.3.8 site no longer worked due to a php version change. It had a prior version of mapinator installed. I wound up adding the items to the config table manually or correcting the ones that were already there assigned to the wrong config group. That's where I'd start looking. The sql is in the file 1_Install_Files/admin/includes/installers/new_install.php

Thanks, one question. When you added items to the config table manually are you speaking of the php file or the tables themselves in the database (ie phpmyadmin)?

[badarac]

Thanks, one question. When you added items to the config table manually are you speaking of the php file or the tables themselves in the database (ie phpmyadmin)?

I just fixed everything using phpmyadmin. I used the php file for the contents of the table.

[creyesx6]

I just fixed everything using phpmyadmin. I used the php file for the contents of the table.

Thanks badarac,
I went through the tables and did find that I needed to update configuration tables due to missing information and also found that the new_install.php was using the wrong table prefix for my database, however after the changes, I am still getting a blank map. Has anyone else had the same problem? I look forward to any further input. Thanks. once again the url is www.casablancafurnitureinc.com. It's the contact page I am finding the blank map image.

[badarac]

Thanks badarac,
I went through the tables and did find that I needed to update configuration tables due to missing information and also found that the new_install.php was using the wrong table prefix for my database, however after the changes, I am still getting a blank map. Has anyone else had the same problem? I look forward to any further input. Thanks. once again the url is www.casablancafurnitureinc.com. It's the contact page I am finding the blank map image.

When I go to the contact us page it tries to load the map and finally issues the following message:

Google has disabled use of the Maps API for this application. The provided key is not a valid Google API Key, or it is not authorized for the Google Maps Javascript API v3 on this site. If you are the owner of this application, you can learn about obtaining a valid key here: https://developers.google.com/maps/d...torial#api_key

You are probably using an old key and need to go through the process to get a new one. That should take care of it.