source: extensions/database_migration/include/tab_config.inc.php @ 6222

<?php
// +-----------------------------------------------------------------------+
// | database_migration - a plugin for Piwigo                              |
// +-----------------------------------------------------------------------+
// | Copyright(C) 2010 Nicolas Roudaire             http://www.nikrou.net  |
// +-----------------------------------------------------------------------+
// | This program is free software; you can redistribute it and/or modify  |
// | it under the terms of the GNU General Public License version 2 as     |
// | published by the Free Software Foundation                             |
// |                                                                       |
// | 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                                                     |
// +-----------------------------------------------------------------------+

define('DEFAULT_DB_SQLITE', 'native');

load_language('install.lang', PHPWG_ROOT_PATH);

include_once PHPWG_ROOT_PATH . 'admin/include/functions_install.inc.php';

$Params = array('db_host', 'db_user', 'db_password', 'db_base');
$extraParams = array('prefix');
$mandatoryParams['sqlite'] = array('db_base');
$mandatoryParams['pgsql'] = array('db_host', 'db_user', 'db_password', 'db_base');

$dblayer = '';
$default_prefix = 'piwigo_';
$Actions = array('add', 'edit', 'del');
$action = null;

foreach (available_engines() as $key => $engine) {
  if ($key=='mysql') {
    continue;
  }
  $engines[$key] = $engine['label'];
}

$Connections = $me->getAllConnections();
$connection = array('prefix' => $default_prefix);

if (!empty($_GET['action']) && in_array($_GET['action'], $Actions)) {
  $action = $_GET['action'];
}

if ($action=='del') {
  if (empty($_GET['id']) || ($connection = $me->getConnection($_GET['id']))==null) {
    $action = null;
  } else {
    $me->removeConnection($_GET['id']);
    $me->save_config();
    $_SESSION['dm_messages']['infos'] = l10n('Connection deleted successfully'); 
    redirect($dm_base_url.'&amp;tab=config');
  }
}

if ($action=='edit') {
  if (empty($_GET['id']) || ($connection = $me->getConnection($_GET['id']))==null) {
    $action = null;
  } else {
    $dblayer = $_GET['id'];
  }
}

if (($action=='add') || ($action=='edit')) {
  if (!empty($_POST) && isset($_POST['dblayer'])) {
    $dblayer = $_POST['dblayer'];

    foreach ($Params as $param) {
      if (!empty($_POST[$param]) && in_array($param, $mandatoryParams[$dblayer])) {
        $connection[$param] = trim($_POST[$param]," /\n\t\r\0\x0B");
      } elseif (in_array($param, $mandatoryParams[$dblayer])) {
        $GLOBALS['page']['errors'][] = l10n(sprintf('%s is required', ucfirst($param)));
      } else {
        $connection[$param] = '';
      }
    }
    foreach ($extraParams as $param) {
      if (!empty($_POST[$param])) {
        $connection[$param] = trim($_POST['prefix'], " /\n\t\r\0\x0B");
      } else {
        $connection[$param] = '';
      }
    }
  }  

  if (!empty($_POST) && count($GLOBALS['page']['errors'])==0) {
    $connection['label'] = $engines[$dblayer];
    $me->addConnection($dblayer, $connection);
    $me->save_config();
    if ($action=='add') {
      $_SESSION['dm_messages']['infos'] = l10n('Connection added successfully'); 
    } else {
      $_SESSION['dm_messages']['infos'] = l10n('Connection updated successfully'); 
    }
    redirect($dm_base_url.'&amp;tab=config');
  }
}

if ($action=='edit' || $action=='add') {
  foreach ($Params as $param) {
    if (!empty($connection[$param])) {
      $GLOBALS['template']->assign(strtoupper($param), $connection[$param]);
    }
  }
  foreach ($extraParams as $param) {
    $GLOBALS['template']->assign(strtoupper($param), $connection[$param]);
  }
  $GLOBALS['template']->assign('DBLAYER', $dblayer);
}

if (count($Connections)>0) {
  $GLOBALS['template']->assign('CONNECTIONS', $Connections);
}

$GLOBALS['template']->assign('DM_ACTION', $action);
$GLOBALS['template']->assign('F_DB_ENGINES', $engines);
$GLOBALS['template']->assign('U_DM_LIST', $dm_base_url.'&amp;tab=config');
$GLOBALS['template']->assign('U_DM_ADD_CONNECTION', $dm_base_url.'&amp;tab=config&amp;action=add');
$GLOBALS['template']->assign('U_DM_DELETE_CONNECTION', $dm_base_url.'&amp;tab=config&amp;action=del&amp;id=');
$GLOBALS['template']->assign('U_DM_EDIT_CONNECTION', $dm_base_url.'&amp;tab=config&amp;action=edit&amp;id=');
?>