<?php
/*
 * Gallery - a web based photo album viewer and editor
 * Copyright (C) 2000-2007 Bharat Mediratta
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or (at
 * your option) any later version.
 *
 * This program is distributed in the hope that it will be useful, but
 * WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA  02110-1301, USA.
 */
/**
 * @package map
 * @author Steven N. Severinghaus <sns@severinghaus.org>
 * @version $Revision: 1259 $
 *
 * This is some of the ugliest code I've ever written. Please do not
 * judge me by it. :)
 *
 */

/**
 * Map
 *
 * This module provides Google Map for Gallery items.
 *
 * @package map
 */
class mapModule extends GalleryModule {

    function mapModule() {
	global $gallery;
	$this->setId('map');
	$this->setName($gallery->i18n('Google Map Module'));
	$this->setDescription($gallery->i18n('Show items on a dynamic Google Map'));
	$this->setVersion('0.5.4');
	$this->setGroup('gallery', $gallery->i18n('Gallery'));
	$this->setCallbacks('registerEventListeners|getSiteAdminViews|getItemSummaries'
			    . '|getItemLinks');
	$this->setRequiredCoreApi(array(7, 0));
	$this->setRequiredModuleApi(array(3, 0));
    }

    /**
     * @see GalleryModule::registerEventListeners()
     */
    function registerEventListeners() {
	GalleryCoreApi::requireOnce('modules/map/classes/mapHelper.class');
	GalleryCoreApi::registerEventListener('GalleryEntity::delete', new mapHelper());
	GalleryCoreApi::registerEventListener('GalleryEntity::save', new mapHelper());
    }

    function needsConfiguration() {
	/* This module requires a Google Map API key. */
	list ($ret, $value) = $this->getParameter('MapKeys');
	if ($ret) {
	    return array($ret, null);
	}
	return array(null, empty($value) || $value == '');
    }

    /**
     * @see GalleryModule::autoConfigure
     */
    function autoConfigure() {

	list ($ret, $needsConfiguration) = $this->needsConfiguration();
	if ($ret) {
	    return array($ret, false);
	}

	if (!$needsConfiguration) {
	    return array(null, true);
	}

	GalleryCoreApi::setPluginParameter('module', 'map', 'googleMapKey', '');
	GalleryCoreApi::setPluginParameter('module', 'map', 'mapWidth', 600);
	GalleryCoreApi::setPluginParameter('module', 'map', 'mapHeight', 400);
	GalleryCoreApi::setPluginParameter('module', 'map', 'centerLongLat', '0,0');
	GalleryCoreApi::setPluginParameter('module', 'map', 'zoomLevel', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'zoomInLevel', 5);
	GalleryCoreApi::setPluginParameter('module', 'map', 'mapType', 'G_NORMAL_MAP');
	GalleryCoreApi::setPluginParameter('module', 'map', 'showZoomScale', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'showMapType', 1);
	GalleryCoreApi::setPluginParameter('module', 'map', 'showZoomLinks', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'showItemSummaries', 1);
	GalleryCoreApi::setPluginParameter('module', 'map', 'showItemDescriptions', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'regroupAlbums', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'regroupItems', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'regroupDist', 15);
	GalleryCoreApi::setPluginParameter('module', 'map', 'regroupIcon', 'zoom-in-trans');
	GalleryCoreApi::setPluginParameter('module', 'map', 'useMarkerSet', 'smallpushpins');
	GalleryCoreApi::setPluginParameter('module', 'map', 'useAlbumMarkerSet', 'smallpushpins');
	GalleryCoreApi::setPluginParameter('module', 'map', 'useGroupMarkerSet', 'smallpushpins');
	GalleryCoreApi::setPluginParameter('module', 'map', 'defaultphotocolor', 'GREEN');
	GalleryCoreApi::setPluginParameter('module', 'map', 'defaultalbumcolor', 'YELLOW');
	GalleryCoreApi::setPluginParameter('module', 'map', 'defaultgroupcolor', 'RED');
	GalleryCoreApi::setPluginParameter('module', 'map', 'useParentColor', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'GxMagnifier', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'GxMagnifier2', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'MapControlType', 'Small');
	GalleryCoreApi::setPluginParameter('module', 'map', 'MapControlPos', '0');
	GalleryCoreApi::setPluginParameter('module', 'map', 'MapControlPosOffX', '10');
	GalleryCoreApi::setPluginParameter('module', 'map', 'MapControlPosOffY', '15');
	GalleryCoreApi::setPluginParameter('module', 'map', 'AutoCenterZoom', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'ShowExportGELink', 1);
	GalleryCoreApi::setPluginParameter('module', 'map', 'ExpandAlbumLegend', 1);
	GalleryCoreApi::setPluginParameter('module', 'map', 'ExpandPhotoLegend', 1);
	GalleryCoreApi::setPluginParameter('module', 'map', 'ShowFilters', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'LegendPos', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'GxMagnifierFeature', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'ThemeFeature', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'MarkerFeature', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'LegendFeature', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'FilterFeature', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'GroupFeature', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'RouteFeature', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'ThumbBarPos', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'ThumbHeight', 60);
	GalleryCoreApi::setPluginParameter('module', 'map', 'linktype', 0);
	GalleryCoreApi::setPluginParameter('module', 'map', 'AdminHelp', 1);
	GalleryCoreApi::setPluginParameter('module', 'map', 'UserHelp', 1);
	list ($ret, $exifModule) = GalleryCoreApi::loadPlugin('module', 'exif', false);
	if ($ret) {
	    return array(null, false);
	} else {
	    if (!version_compare ('1.0.1', $exifModule->getVersion(), '<=')) {
		GalleryCoreApi::setPluginParameter('module', 'map', 'oldexifversion', 1);
	    } else {
		GalleryCoreApi::setPluginParameter('module', 'map', 'oldexifversion', 0);
	    }
	}
	list ($ret, $imagemagickModule) =
		GalleryCoreApi::loadPlugin('module', 'imagemagick', false);
	if ($ret) {
	    return array(null, false);
	} else {
	    if (empty($imagemagickModule)) {
		GalleryCoreApi::setPluginParameter('module', 'map', 'noimagemagick', 1);
	    } else {
		GalleryCoreApi::setPluginParameter('module', 'map', 'noimagemagick', 0);
	    }
	}
	return array(null, false);
    }

    function activate($postActivationEvent = true) {

	$base = substr(dirname(__FILE__), 0, -11);
	$urltmp  = parse_url(GalleryUtilities::convertPathToUrl($base));
	$url = $urltmp['path'];

	GalleryCoreApi::setPluginParameter('module', 'map', 'gallerybase', $base);
	GalleryCoreApi::setPluginParameter('module', 'map', 'urlbase', $url);

	/* Register the Map Edit Permission, no error checking */
	$ret = GalleryCoreApi::registerPermission($this->getId(), 'map.EditMap',
		$this->_translate('[Google Map] Allow Coordinate Editing'));

	/* By default admin can edit everything */
	list ($ret, $rootalbum) =
		GalleryCoreApi::getPluginParameter('module', 'core', 'id.rootAlbum');
	list ($ret, $siteadmins) =
		GalleryCoreApi::getPluginParameter('module', 'core', 'id.adminGroup');
	$ret = GalleryCoreApi::addGroupPermission($rootalbum, $siteadmins, 'map.EditMap', true);
	if ($ret) {
	    return array($ret->wrap(__FILE__, __LINE__), null);
	}

	list ($ret, $redirect) = parent::activate($postActivationEvent);
	if ($ret) {
	    return array($ret, null);
	}

	return array(null, $redirect);

    }

    function getConfigurationView() {
	return 'map.MapSiteAdmin';
    }

    /**
     * @see GalleryModule::getSiteAdminViews()
     */
    function getSiteAdminViews() {
	global $gallery;
	return array(null, array(array('name' => $this->_translate('Google Map'),
				       'view' => 'map.MapSiteAdmin')));
    }

    /**
     * @see GalleryModule::getItemSummaries()
     */
    function getItemSummaries($items, $permissions) {
	GalleryCoreApi::requireOnce('modules/map/classes/mapHelper.class');
	GalleryCoreApi::requireOnce('lib/smarty_plugins/modifier.markup.php');
	$summaries = $data = array();

	list ($ret, $data) = mapHelper::fetchFieldValues($items, 'summary');
	if ($ret) {
	    return array($ret, null);
	}

	foreach ($data as $itemId => $fields) {
	    $list = array();
	    foreach ($fields as $field => $value) {
		$list[] = $field . ': ' . smarty_modifier_markup($value);
	    }
	    if (!empty($list)) {
		$summaries[$itemId] = implode("<br/>\n", $list);
	    }
	}
	return array(null, $summaries);
    }

    /**
     * @see GalleryModule::getRewriteRules()
     */
    function getRewriteRules() {
	global $gallery;
	$rules = array();

	$rule = array();
	$rule['comment'] = 'View Google Map Group';
	$rule['match'] = array('view' => 'map.ShowMap');
	$rule['pattern'] = 'Map/%Group%';
	$rule['keywords'] = array(
		'Group' => array(
			'pattern' => '(G{1}[0-9]+)*',
			'help' => $this->_translate('The ID of the group to show, '
						    . 'No group will show the default Map')));
	$rules[0] = $rule;

	return $rules;
    }

    /**
     * @see GalleryModule::performFactoryRegistrations()
     */
    function performFactoryRegistrations() {
	/* Register our item edit plugin */
	$ret = GalleryCoreApi::registerFactoryImplementation(
		'ItemEditPlugin', 'mapItemEdit', 'mapItemEdit',
		'modules/map/mapItemEdit.inc', 'map', null);
	if ($ret) {
	    return $ret;
	}

	/* Register interface implementation */
	$ret = GalleryCoreApi::registerFactoryImplementation(
		'mapInterface_1_0', 'mapHelper', 'map',
		'modules/map/classes/mapHelper.class', 'map', null);
	if ($ret) {
	    return $ret;
	}

	/* Register search implementation */
	$ret = GalleryCoreApi::registerFactoryImplementation(
		'GallerySearchInterface_1_0', 'mapSearch', 'map',
		'modules/map/classes/mapSearch.class', 'map', null);
	if ($ret) {
	    return $ret;
	}

	$ret = GalleryCoreApi::registerFactoryImplementation(
		'MaintenanceTask', 'PopulateGPSEXIFInfos', 'PopulateGPSEXIFInfos',
		'modules/map/classes/PopulateGPSEXIFInfos.class', 'map', null);
	if ($ret) {
	    return $ret;
	}

	$ret = GalleryCoreApi::registerFactoryImplementation(
		'MaintenanceTask', 'WriteExifHeaderToPictures', 'WriteExifHeaderToPictures',
		'modules/map/classes/WriteExifHeaderToPictures.class', 'map', null);
	if ($ret) {
	    return $ret;
	}

	return null;
    }

    /**
     * @see GalleryModule::getItemLinks()
     */
    function getItemLinks($items, $wantsDetailedLinks, $permissions) {
	global $gallery;
	GalleryCoreApi::requireOnce('modules/map/classes/mapHelper.class');
	$links = array();

	list ($ret, $linktype) = GalleryCoreApi::getPluginParameter('module', 'map', 'linktype');
	if (empty($linktype)) {
	    $linktype = 0;
	}
	list ($ret, $ExportGELink) = 
		GalleryCoreApi::getPluginParameter('module', 'map', 'ShowExportGELink');
	foreach ($items as $item) {
	    $itemId = $item->getId();
	    $type = $item->getEntityType();
	    if ($linktype != 3) {
		if ($type == 'GalleryPhotoItem') {
		    $NitemId = $item->getParentId();
		} else {
		    $NitemId = $itemId;
		}
		list ($ret, $item) = GalleryCoreApi::loadEntitiesById($NitemId);
		$name = $item->getTitle();
  
		$goodalbum  = false;
		if ($linktype == 2) {
		    $goodalbum = true; /* Always filter on current album */
		}
  
		if ($linktype == 1) {
		    /* Dynamic link -> search for item in the album/subalbum with GPS coords */
		    list ($ret, $count) = mapHelper::getCountItemWithCoords($item->getId());
		    if ($ret) {
                return array($ret, null);
            }
            if ($count != 0){
                $goodalbum = true;
            }
		}
		if (isset($wantsDetailedLinks[$itemId])) {
		    /* The View in Google Earth Link (only if enabled in the Panel) */
		    if ($ExportGELink) {
			$links[$itemId][] =
				array('text' => $this->_translate('View in Google Earth'),
				      'params' => array('view' => 'map.GoogleEarth',
							'itemId' => $itemId));
		    }
		    /* The Google Map link */
		    if ($goodalbum) {
			$links[$itemId][] =
				array('text' => $this->_translate('View Album on a Map'),
				      'params' => array('view' => 'map.ShowMap',
							'Mode' => 'Normal',
							'Group' => '',
							'album' => $name));
		    } else {
			/*
			 * The current album (or parent of the current photo) does not have any
			 * GPS item, check from the root
			 */
        		list ($ret, $count) = mapHelper::getCountItemWithCoords();
        		if ($ret) {
                            return array($ret, null);
                        }
                        if ($count) {
			    /* There are some items to show in the Gallery Display the Map Link */
			    $links[$itemId][] = array('text' => $this->_translate('Show a Google Map'),
			    			      'params' => array('view' => 'map.ShowMap'));
			}
		    }
		}
	    }
	}
	return array(null, $links);
    }

    function upgrade($currentversion) {
	global $gallery;
	$storage =& $gallery->getStorage();

	list ($ret, $exifModule) = GalleryCoreApi::loadPlugin('module', 'exif', false);
	if ($ret) {
	    /**
	     * @todo This doesn't seem right. The upgrade shouldn't bail out just because this
	     * plugin couldn't be loaded. It's not required for core functionality of this module.
	     */
	    return $ret; 
	} else {
	    GalleryCoreApi::setPluginParameter('module', 'map', 'oldexifversion', 0);
	    if (!version_compare('1.0.1', $exifModule->getVersion(), '<=')) {
		GalleryCoreApi::setPluginParameter('module', 'map', 'oldexifversion', 1);
	    }
	}
	list ($ret, $imagemagickModule) =
		GalleryCoreApi::loadPlugin('module', 'imagemagick', false);
	if ($ret) {
	    /*
	     * @todo This doesn't seem right. The upgrade shouldn't bail out just because this
	     * plugin couldn't be loaded. It's not required for core functionality of this module.
	     */
	    return $ret;
	} else {
	    GalleryCoreApi::setPluginParameter('module', 'map', 'noimagemagick', 0);
	}

	if (ctype_alpha(substr($currentversion, -1, 1))) {
	    $currentVersion = substr($currentversion, 0, -1);
	}
	else {
	    $currentVersion = $currentversion;
	}

	switch (true) {
	case (!isset($currentversion) or $currentversion == '0'):
	    /* Nothing to do */
	break;
	case ($currentVersion <= '0.3.2' and $currentVersion > '0'):
	    /* Upgrade from when we were using CustomField */

	    /* get CustomfieldMap table fields related to Map */
	    $query = '
	    SELECT *
	    FROM
	      [GalleryCustomFieldMap]
	    WHERE
	      [GalleryCustomFieldMap::field] = \'GPS\'
	      OR
	      [GalleryCustomFieldMap::field] = \'Colors\'
	      OR
              [GalleryCustomFieldMap::field] = \'Color\'
	      OR
	      [GalleryCustomFieldMap::field] = \'ZoomLevel\'
	    ';
	    list ($ret, $results) = $gallery->search($query, array(), array());

	    if ($results->resultCount() > 0) { /* Verify that it isn't empty */
		while ($result = $results->nextResult()) {
		    if ($result[1] == 'Color') {
			$result[1] = 'Colors'; /* Replace the "color" field for "colors" */
		    }

		    $insertquery = '
		    INSERT INTO
		    [mapMap]
		    VALUES (\'' . $result[0] . '\',\'' . $result[1] . '\',\'' . $result[2]
			    . '\',\'' . $result[3] . '\',\'' . $result[4] . '\')
		    ';
    
		    $ret = $storage->execute($insertquery); /* put the values in Mapmap */
		    if ($ret) {
			return $ret;
		    }

		}
	    }

	case ($currentVersion < '0.4.5' and $currentVersion > '0.4.0'):
	    /* Upgrade from before the routes were able to be filters */
	    /* Get the Routes field */
	    $routes = GalleryCoreApi::getPluginParameter('module', 'map', 'Routes');
	    $newroutes = array();

	    /* Update with new parameters set to no */
	    if (!empty($routes[1])) {  /* There is some routes, upgrading */
		$allroutes = explode ('|', $routes[1]);
		foreach ($allroutes as $route) {
		    $usingnewroutes = strpos($route, '`Yes`No') ? 1 : 0 
			    + strpos($route, '`Yes`Yes') ? 1 : 0
			    + strpos($route, '`No`Yes') ? 1 : 0
			    + strpos($route, '`No`No') ? 1 : 0;
		    $posyes = strpos($route, '`Yes');
		    $posno = strpos($route, '`No');
		    if ($posyes and $usingnewroutes == 0) {
			$newroutes[] = substr($route, 0, $posyes + 4) . '`No'
				       . substr($route, $posyes + 4) . '<br>';
		    } else if ($posno and $usingnewroutes == 0) {
			$newroutes[] = substr($route, 0, $posno+3) . '`No'
				       . substr($route, $posno + 3) . '<br>';
		    }
		}
		if ($newroutes != '1')  {
		    $theroutes = implode('|', $newroutes);
		    /* Set the new routes in the database */
		    GalleryCoreApi::setPluginParameter('module', 'map', 'Routes', $theroutes);
		}
	    }
	case ($currentVersion < '0.4.5'):
	    /* copy markers to the module directory (we don't care if that fails) */
	    /**
	     * @todo The substr() method is fragile. Change to use
	     * GalleryCoreApi::getPluginBaseDir() for now, then getCodeBasePath() for Gallery 2.3+
	     */
	    $basegallerydir = substr(dirname(__FILE__), 0, -11);
	    /**
	     * @todo This is the only place CopyDir is used. If we can move that functionality
	     * here, we can eliminate filecopy.class altogether.
	     */
	    GalleryCoreApi::requireOnce('modules/map/classes/filecopy.class');
	    @CopyDir($basegallerydir . '../images/map', $basegallerydir . 'map/images/markers', 0777, 
		    false);
	    @rm($basegallerydir . 'images/map');

	case ($currentVersion < '0.4.5' and $currentVersion > '0.4.0'):
	    /* Upgrade routes to be pointing to Item instead of coordinates of items */
	    /* Get current routes */
	    list ($ret, $routes) = GalleryCoreApi::getPluginParameter('module', 'map', 'Routes');
	    $newroutes = '';
	    if (!empty($routes)) { /* there is some route, fix them :-) */
		$allroutes = explode ('|', $routes);
		foreach ($allroutes as $route) { /* go through each route */
		    $routeinfos = explode ('`', $route);
		    $theroute = $routeinfos[0] . '`' . $routeinfos[1] . '`' . $routeinfos[2]
				. '`' . $routeinfos[3] . '`' . $routeinfos[4] . '`' . $routeinfos[5]
				. '`' . $routeinfos[6];
		    for ($i = 7; $i< count($routeinfos); $i++) {
			/* Search for the itemid from the coordinate and replace */
			$query = '					    
			SELECT
			  [mapMap::itemId]
			FROM
			  [mapMap]
			WHERE
			  [mapMap::value] = \'' . $routeinfos[$i] . '\'
			';
			list ($ret, $results) = $storage->search($query);
			if ($results->resultCount > 0) {
			    $result = $results->nextResult();
			    $theroute .= '`' . $result[0];
			}
			else {
			    $theroute .= '`' . $routeinfos[$i];
			}
		    }
		    if ($newroutes == '') {
			$newroutes = $theroute;
		    } else {
			$newroutes .= '|' . $theroute;
		    }
		}
		/* Replace route with new infos */
		GalleryCoreApi::setPluginParameter('module', 'map', 'Routes', $newroutes);
	    }
	case ($currentVersion > '0.3.2' and $currentVersion < '0.4.8'):
	/* attempt to change the database itemId from int to varchar */

	$query =
	'ALTER TABLE
	  [mapMap]
	CHANGE
	  [mapMap::itemId]
	  [mapMap::itemId] VARCHAR(11) DEFAULT \'0\' NOT NULL
	';

	$ret = $storage->execute($query); /* put the values in mapMap */
	if ($ret) {
	    return $ret;
	}
	case ($currentVersion < '0.5.0'):
	    $ret = $storage->configureStore($this->getId(), array('mapMap:1.2'));
	    if ($ret) {
		return $ret;
	    }
	case ($currentVersion < '0.5.1'):
	    /* Reverse the existing 'GPS' coordinatesin the DB ******************************** */
	    $query = '
	    SELECT *
	    FROM
	      [mapMap]
	    WHERE
	      [mapMap::field] = \'GPS\'
	    ';
	    list ($ret, $results) = $gallery->search($query, array(), array());

	    if ($results->resultCount() > 0) { /* Verify that it isn't empty */
		while ($result = $results->nextResult()) {

		    if (!empty($result[2])) {
			$tempcoord = explode(',', $result[2]);
			$result[2] = "$tempcoord[1],$tempcoord[0]";
		    }

		    $updatequery = '
		    UPDATE
		      [mapMap]
		    SET
		      [mapMap::value] = \'' . $result[2] . '\'
		    WHERE
		      [mapMap::itemId] = \'' . $result[0] . '\'
		      AND
		      [mapMap::field] = \'' . $result[1] . '\'
		      AND
		      [mapMap::setId] = \'' . $result[3] . '\'
		      AND
		      [mapMap::setType] = \'' . $result[4] . '\'
		    ';

		    $ret = $storage->execute($updatequery); /* put the values in Mapmap */
		    if ($ret) {
			return $ret;
		    }

		}
	    }
	    /* End reversing GPS coordinates in DB ********************************************* */

	    /* Update map type **************************************************************** */
	    $query = '
	    SELECT *
	    FROM
	      [GalleryPluginParameterMap]
	    WHERE
	      [GalleryPluginParameterMap::pluginType] = \'module\'
	      AND
	      [GalleryPluginParameterMap::pluginId] = \'map\'
	      AND
	      [GalleryPluginParameterMap::parameterName] = \'mapType\'
	    ';
	    list ($ret, $results) = $gallery->search($query, array(), array());

	    if ($results->resultCount() > 0) { /* Verify that it isn't empty */
		while ($result = $results->nextResult()) {

		    if (!empty($result[4])) {
			if ($result[4] == 'G_MAP_TYPE') {
			    $result[4] = 'G_NORMAL_MAP';
			}
			if ($result[4] == 'G_SATELLITE_TYPE') {
			    $result[4] = 'G_SATELLITE_MAP';
			}
			if ($result[4] == 'G_HYBRID_TYPE') {
			    $result[4] = 'G_HYBRID_MAP';
			}

		    }

		    $updatequery = '
		    UPDATE
		      [PluginParameterMap]
		    SET
		      [GalleryPluginParameterMap::parameterValue] = \'' . $result[4] . '\'
		    WHERE
		      [GalleryPluginParameterMap::pluginType] = \'' . $result[0] . '\'
		      AND
		      [GalleryPluginParameterMap::pluginId] = \'' . $result[1] . '\'
		      AND
		      [GalleryPluginParameterMap::itemId] = \'' . $result[2] . '\'
		      AND
		      [GalleryPluginParameterMap::parameterName] = \'' . $result[3] . '\'
		    ';

		    $ret = $storage->execute($updatequery); /* put the values in Mapmap */
		    if ($ret) {
			return $ret;
		    }

		}
	    }
	    /* End updating the Map Type in the DB  ******************************************** */

	    /* Reverse the Map Center parameter ************************************************ */
	    $query = '
	    SELECT *
	    FROM
	      [GalleryPluginParameterMap]
	    WHERE
	      [GalleryPluginParameterMap::pluginType] = \'module\'
	      AND
	      [GalleryPluginParameterMap::pluginId] = \'map\'
	      AND
	      [GalleryPluginParameterMap::parameterName] = \'centerLongLat\'
	    ';
	    list ($ret, $results) = $gallery->search($query, array(), array());

	    if ($results->resultCount() > 0) { /* Verify that it isn't empty */
		while ($result = $results->nextResult()) {

		    if (!empty($result[4])) {
			$tempcoord = explode(',', $result[4]);
			$result[4] = "$tempcoord[1],$tempcoord[0]";
		    }

		    $updatequery = '
		    UPDATE
		      [GalleryPluginParameterMap]
		    SET
		      [GalleryPluginParameterMap::parameterValue] = \'' . $result[4] . '\'
		    WHERE
		      [GalleryPluginParameterMap::pluginType] = \'' . $result[0] . '\'
		      AND
		      [GalleryPluginParameterMap::pluginId] = \'' . $result[1] . '\'
		      AND
		      [GalleryPluginParameterMap::itemId] = \'' . $result[2] . '\'
		      AND
		      [GalleryPluginParameterMap::parameterName] = \'' . $result[3] . '\'
		    ';

		    $ret = $storage->execute($updatequery); /* put the values in Mapmap */
		    if ($ret) {
			return $ret;
		    }

		}
	    }
	    /* End reversing the coordinates in the Map Center Paramater ******************* */

	    /* Reverse the Default Map Center parameter *********************************** */
	    $query = '
	    SELECT *
	    FROM
	      [GalleryPluginParameterMap]
	    WHERE
	      [GalleryPluginParameterMap::pluginType] = \'module\'
	      AND
	      [GalleryPluginParameterMap::pluginId] = \'map\'
	      AND [GalleryPluginParameterMap::parameterName] = \'GVMCenter\'
	    ';
	    list ($ret, $results) = $gallery->search($query, array(), array());

	    if ($results->resultCount() > 0) { /* Verify that it isn't empty */
		while ($result = $results->nextResult()) {

		    if (!empty($result[4])) {
			$tempcoord = explode(',', $result[4]);
			$result[4] = "$tempcoord[1],$tempcoord[0]";
		    }

		    $updatequery = '
		    UPDATE
		      [GalleryPluginParameterMap]
		    SET
		      [GalleryPluginParameterMap::parameterValue] = \'' . $result[4] . '\'
		    WHERE
		      [GalleryPluginParameterMap::pluginType] = \'' . $result[0] . '\'
		      AND
		      [GalleryPluginParameterMap::pluginId] = \'' . $result[1] . '\'
		      AND
		      [GalleryPluginParameterMap::itemId] = \'' . $result[2] . '\'
		      AND
		      [GalleryPluginParameterMap::parameterName] = \'' . $result[3] . '\'
		    ';

		    $ret = $storage->execute($updatequery); /* put the values in Mapmap */
		    if ($ret) {
			return $ret;
		    }

		}
	    }
	    /* End reversing the coordinates in the Default Map Center Paramater *********** */

	    /* Updating the Zoom Level **************************************************** */
	    $query = '
	    SELECT *
	    FROM
	      [GalleryPluginParameterMap]
	    WHERE
	      [GalleryPluginParameterMap::pluginType] = \'module\'
	      AND
	      [GalleryPluginParameterMap::pluginId] = \'map\'
	      AND
	      [GalleryPluginParameterMap::parameterName] = \'zoomLevel\'
	    ';
	    list ($ret, $results) = $gallery->search($query, array(), array());

	    if ($results->resultCount() > 0) { /* Verify that it isn't empty */
		while ($result = $results->nextResult()) {

		    if (!empty($result[4])) {
			$result[4] = 17 - $result[4];
		    }

		    $updatequery = '
		    UPDATE
		      [GalleryPluginParameterMap]
		    SET
		      [GalleryPluginParameterMap::parameterValue] = \'' . $result[4] . '\'
		    WHERE
		      [GalleryPluginParameterMap::pluginType] = \'' . $result[0] . '\'
		      AND
		      [GalleryPluginParameterMap::pluginId] = \'' . $result[1] . '\'
		      AND
		      [GalleryPluginParameterMap::itemId] = \'' . $result[2] . '\'
		      AND
		      [GalleryPluginParameterMap::parameterName] = \'' . $result[3] . '\'
		    ';

		    $ret = $storage->execute($updatequery); /* put the values in Mapmap */
		    if ($ret) {
			return $ret;
		    }

		}
	    }
	    /* End updating the Map Zoom *************************************************** */

	    /* Updating the Default Zoom Level ******************************************** */
	    $query = '
	    SELECT *
	    FROM
	      [GalleryPluginParameterMap]
	    WHERE
	      [GalleryPluginParameterMap::pluginType] = \'module\'
	      AND
	      [GalleryPluginParameterMap::pluginId] = \'map\'
	      AND
	      [GalleryPluginParameterMap::parameterName] = \'GVMZoom\'
	    ';
	    list ($ret, $results) = $gallery->search($query, array(), array());

	    if ($results->resultCount() > 0) { /* Verify that it isn't empty */
		while ($result = $results->nextResult()) {

		    if (!empty($result[4])) {
			$result[4] = 17 - $result[4];
		    }

		    $updatequery = '
		    UPDATE
		      [GalleryPluginParameterMap]
		    SET
		      [GalleryPluginParameterMap::parameterValue] = \'' . $result[4] . '\'
		    WHERE
		      [GalleryPluginParameterMap::pluginType] = \'' . $result[0] . '\'
		      AND
		      [GalleryPluginParameterMap::pluginId] = \'' . $result[1] . '\'
		      AND
		      [GalleryPluginParameterMap::itemId] = \'' . $result[2] . '\'
		      AND
		      [GalleryPluginParameterMap::parameterName] = \'' . $result[3] . '\'
		    ';

		    $ret = $storage->execute($updatequery); /* put the values in Mapmap */
		    if ($ret) {
			return $ret;
		    }

		}
	    }
	    /* End updating the Default Map Zoom ****************************************** */

	    /* Updating the Default ZoomIn Level ***************************************** */
	    $query = '
	    SELECT *
	    FROM
	      [GalleryPluginParameterMap]
	    WHERE
	      [GalleryPluginParameterMap::pluginType] = \'module\'
	      AND
	      [GalleryPluginParameterMap::pluginId] = \'map\'
	      AND
	      [GalleryPluginParameterMap::parameterName] = \'zoomInLevel\'
	    ';
	    list ($ret, $results) = $gallery->search($query, array(), array());

	    if ($results->resultCount() > 0) { /* Verify that it isn't empty */
		while ($result = $results->nextResult()) {

		    if (!empty($result[4])) {
			$result[4] = 17 - $result[4];
		    }

		    $updatequery = '
		    UPDATE
		      [GalleryPluginParameterMap]
		    SET
		      [GalleryPluginParameterMap::parameterValue] = \'' . $result[4] . '\'
		    WHERE
		      [GalleryPluginParameterMap::pluginType] = \'' . $result[0] . '\'
		      AND
		      [GalleryPluginParameterMap::pluginId] = \'' . $result[1] . '\'
		      AND
		      [GalleryPluginParameterMap::itemId] = \'' . $result[2] . '\'
		      AND
		      [GalleryPluginParameterMap::parameterName] = \'' . $result[3] . '\'
		    ';

		    $ret = $storage->execute($updatequery); /* put the values in Mapmap */
		    if ($ret) {
			return $ret;
		    }

		}
	    }
	    /* End updating the Default Map ZoomIn **************************************** */

	    /* Updating the Manual Filter information ************************************ */
	    $query = '
	    SELECT *
	    FROM
	      [GalleryPluginParameterMap]
	    WHERE
	      [GalleryPluginParameterMap::pluginType] = \'module\'
	      AND
	      [GalleryPluginParameterMap::pluginId] = \'map\'
	      AND
	      [GalleryPluginParameterMap::parameterName] = \'Filters\'
	    ';
	    list ($ret, $results) = $gallery->search($query, array(), array());

	    if ($results->resultCount() > 0) { /* Verify that it isn't empty */
		while ($result = $results->nextResult()) {

		    if (!empty($result[4])) { /* we do have some filters, start the upgrade */
			$filterarray = explode('|', $result[4]);
			foreach ($filterarray as $key => $filterinfos) {
			    $infos = explode('`', $filterinfos);
			    $tempcenter = explode(',', $infos[3]);
			    /* invert the coordinates for this filter */
			    $infos[3] = $tempcenter[1] . ',' . $tempcenter[0];
			    $infos[2] = 17 - $infos[2];  /* change the zoom for this filter */
			    /* put the new infos back into the original array */
			    $filterarray[$key] = implode ('`', $infos);
			}
			/* put all the fixed filter into the result */
			$result[4] = implode('|', $filterarray);
		    }

		    $updatequery = '
		    UPDATE
		      [GalleryPluginParameterMap]
		    SET
		      [GalleryPluginParameterMap::parameterValue] = \'' . $result[4] . '\'
		    WHERE
		      [GalleryPluginParameterMap::pluginType] = \'' . $result[0] . '\'
		      AND
		      [GalleryPluginParameterMap::pluginId] = \'' . $result[1] . '\'
		      AND
		      [GalleryPluginParameterMap::itemId] = \'' . $result[2] . '\'
		      AND
		      [GalleryPluginParameterMap::parameterName] = \'' . $result[3] . '\'
		    ';

		    $ret = $storage->execute($updatequery); /* put the values in Mapmap */
		    if ($ret) {
			return $ret;
		    }

		}
	    }
	    /* End updating the Manual Filter Information  ******************************** */
	    case ($currentversion < '0.5.3'):
	    /* Get Information for the "Colors", "AlbumColor" and "PhotoColor" fields and move all of it to "Color" */
	    $updatequery = '
	    UPDATE
	      [mapMap]
	    SET
	      [mapMap::field] = \'Color\'
	    WHERE
	      [mapMap::field] = \'Colors\'
	      OR
	      [mapMap::field] = \'AlbumColor\'
	      OR
	      [mapMap::field] = \'PhotoColor\'
	    ';
	    $ret = $storage->execute($updatequery); /* put the values in Mapmap */
	    if ($ret) {
			return $ret;
	    }
	}

	return null;
    }

}
?>