source: extensions/edit_gmaps/admin/admin.php @ 9413

<?php 
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
include_once(PHPWG_ROOT_PATH.'admin/include/tabsheet.class.php');

$colonnes = cl_get_columns_of(IMAGES_TABLE);

$key = array_search('lon', $colonnes[IMAGES_TABLE]); 
if (!$key){
    $q = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN `lon` DOUBLE(9,6)';
    pwg_query($q);      
}       
$key = array_search('lat', $colonnes[IMAGES_TABLE]); 
if (!$key){
    $q = 'ALTER TABLE '.IMAGES_TABLE.' ADD COLUMN `lat` DOUBLE(9,6)';
    pwg_query($q);      
}       
$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'] = 'edit';
else
  $page['tab'] = $_GET['tab'];

$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();

$my_base_url = $tabsheet->sheets[ $page['tab'] ]['url'];
$template->set_filename( 'tab_data', dirname(__FILE__).'/admin_'.$page['tab'].'.tpl' );
include_once( dirname(__FILE__).'/admin_'.$page['tab'].'.php');
 
$template->assign_var_from_handle( 'TAB_DATA', 'tab_data');
$template->assign_var_from_handle( 'ADMIN_CONTENT', 'plugin_admin_content');

?>