Changeset 9377 for extensions/edit_gmaps/admin/admin.php

Timestamp:

Feb 25, 2011, 12:44:14 PM (13 years ago)

Author:

cljosse

Message:

[edit_gmaps] adding support to the altitude.

File:

• extensions/edit_gmaps/admin/admin.php (modified) (2 diffs)

extensions/edit_gmaps/admin/admin.php

@@ -3 +3 @@
 include_once(PHPWG_ROOT_PATH.'admin/include/tabsheet.class.php');
 
+$colonnes = cl_get_columns_of(IMAGES_TABLE);
+$key = array_search('alt', $colonnes[IMAGES_TABLE]); 
+if (!$key){
+    $q = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN `alt` DOUBLE(9,6)';
+    pwg_query($q);      
+}               
+/**
+* list all columns of each given table
+*
+* @return array of array
+*/
+function cl_get_columns_of($table)
+{
+    $columns_of = array();
+    $query = 'DESC '.$table.';';
+    $result = mysql_query($query);      
+    $columns_of[$table] = array();   
+
+    if ($result)   
+        while ($row = mysql_fetch_row($result))
+           array_push($columns_of[$table], $row[0]);
+        
+    return $columns_of;
+}
+
+
 $template->set_filename('plugin_admin_content', dirname(__FILE__).'/admin.tpl');
 
 if (!isset($_GET['tab']))
-  $page['tab'] = 'config';
+  $page['tab'] = 'edit';
 else
   $page['tab'] = $_GET['tab'];
-  $page['tab'] =   'edit';
+
 $my_base_url = get_admin_plugin_menu_link(__FILE__);
 
 $tabsheet = new tabsheet();
 $tabsheet->add( 'edit', 'Edit', add_url_params( $my_base_url, array('tab'=>'edit') ) );
+//$tabsheet->add( 'edit_meta', 'Edit_meta', add_url_params( $my_base_url, array('tab'=>'edit_meta') ) );
 $tabsheet->select($page['tab']);
 $tabsheet->assign();
@@ -24 +51 @@
 $template->assign_var_from_handle( 'ADMIN_CONTENT', 'plugin_admin_content');
 
-
 ?>