Changeset 26331 for extensions/rv_gmaps/trunk/maintain.inc.php

Timestamp:

Dec 29, 2013, 3:14:42 PM (10 years ago)

Author:

rvelices

Message:

rv_gmaps compatible with nez latitude/longitude fields in piwigo core 2.6

File:

• extensions/rv_gmaps/trunk/maintain.inc.php (modified) (3 diffs)

extensions/rv_gmaps/trunk/maintain.inc.php

@@ -1 +1 @@
 <?php
+function rvgm_drop_old_columns()
+{
+  $q = '
+ALTER TABLE '.IMAGES_TABLE.' DROP COLUMN `lat`';
+  pwg_query( $q );
+
+  $q = '
+ALTER TABLE '.IMAGES_TABLE.' DROP COLUMN `lon`';
+  pwg_query( $q );
+}
+
 function plugin_install()
 {
-  $q = '
-ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN `lat` DOUBLE(8,6)';
-  pwg_query($q);
-  
-  $q = '
-ALTER TABLE '.IMAGES_TABLE.' ADD INDEX images_lat(`lat`)';
-  pwg_query($q);
-
-  $q = '
-ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN `lon` DOUBLE(9,6)';
-  pwg_query($q);
-  
   $q = '
 INSERT INTO '.CONFIG_TABLE.' (param,value,comment)
@@ -25 +24 @@
 {
   global $conf;
+
+  $query = 'SHOW COLUMNS FROM '. IMAGES_TABLE .' LIKE "latitude";';
+
+  if (pwg_db_num_rows(pwg_query($query)))
+                rvgm_drop_old_columns();
+        pwg_query('DELETE FROM '.CONFIG_TABLE.' WHERE param IN("gmaps_auto_sync")');
 
   if (!isset($conf['rv_gmaps_add_map.php']) or $conf['rv_gmaps_add_map.php'])
@@ -68 +73 @@
 function plugin_uninstall()
 {
-  $q = '
-ALTER TABLE '.IMAGES_TABLE.' DROP COLUMN `lat`';
-  pwg_query( $q );
-
-  $q = '
-ALTER TABLE '.IMAGES_TABLE.' DROP COLUMN `lon`';
-  pwg_query( $q );
+  rvgm_drop_old_columns();
 
   $q = '