1<?php 2// +-----------------------------------------------------------------------+ 3// | This file is part of Piwigo. | 4// | | 5// | For copyright and license information, please view the COPYING.txt | 6// | file that was distributed with this source code. | 7// +-----------------------------------------------------------------------+ 8 9if (!defined('PHPWG_ROOT_PATH')) 10{ 11 die('Hacking attempt!'); 12} 13 14$upgrade_description = 'add "latitude" and "longitude" fields'; 15 16// add fields 17$query = ' 18ALTER TABLE '. IMAGES_TABLE .' 19 ADD `latitude` DOUBLE(8, 6) DEFAULT NULL, 20 ADD `longitude` DOUBLE(9, 6) DEFAULT NULL 21;'; 22pwg_query($query); 23 24// add index 25$query = ' 26ALTER TABLE '. IMAGES_TABLE .' 27 ADD INDEX `images_i6` (`latitude`) 28;'; 29pwg_query($query); 30 31// search for old "lat" field 32$query = 'SHOW COLUMNS FROM '. IMAGES_TABLE .' LIKE "lat";'; 33 34if (pwg_db_num_rows(pwg_query($query))) 35{ 36 // duplicate non-null values 37 $query = ' 38UPDATE '. IMAGES_TABLE .' 39 SET latitude = lat, 40 longitude = lon 41 WHERE lat IS NOT NULL 42 AND lon IS NOT NULL 43;'; 44 pwg_query($query); 45} 46 47echo "\n".$upgrade_description."\n"; 48 49?> 50