printTrail('database'); $misc->printTitle($lang['strdrop'], 'pg.database.drop'); echo "

", sprintf($lang['strconfdropdatabase'], $misc->printVal($_REQUEST['database'])), "

\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; } else { $status = $data->dropDatabase($_POST['database']); if ($status == 0) { $_reload_drop_database = true; doDefault($lang['strdatabasedropped']); } else doDefault($lang['strdatabasedroppedbad']); } } /** * Displays a screen where they can enter a new database */ function doCreate($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('server'); $misc->printTitle($lang['strcreatedatabase'], 'pg.database.create'); $misc->printMsg($msg); if (!isset($_POST['formName'])) $_POST['formName'] = ''; // Default encoding is that in language file if (!isset($_POST['formEncoding'])) { if (isset($lang['appdbencoding'])) $_POST['formEncoding'] = $lang['appdbencoding']; else $_POST['formEncoding'] = ''; } if (!isset($_POST['formSpc'])) $_POST['formSpc'] = ''; // Fetch all tablespaces from the database if ($data->hasTablespaces()) $tablespaces = &$data->getTablespaces(); echo "
\n"; echo "\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; // Tablespace (if there are any) if ($data->hasTablespaces() && $tablespaces->recordCount() > 0) { echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; } echo "
{$lang['strname']}_maxNameLen}\" value=\"", htmlspecialchars($_POST['formName']), "\" />
{$lang['strencoding']}\n"; echo "\t\t\t\n"; echo "\t\t
{$lang['strtablespace']}\n\t\t\t\n\t\t
\n"; echo "

\n"; echo "\n"; echo "

\n"; echo "
\n"; } /** * Actually creates the new view in the database */ function doSaveCreate() { global $data, $lang, $_reload_browser; // Default tablespace to null if it isn't set if (!isset($_POST['formSpc'])) $_POST['formSpc'] = null; // Check that they've given a name and a definition if ($_POST['formName'] == '') doCreate($lang['strdatabaseneedsname']); else { $status = $data->createDatabase($_POST['formName'], $_POST['formEncoding'], $_POST['formSpc']); if ($status == 0) { $_reload_browser = true; doDefault($lang['strdatabasecreated']); } else doCreate($lang['strdatabasecreatedbad']); } } /** * Displays options for cluster download */ function doExport($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('server'); $misc->printTabs('server','export'); $misc->printMsg($msg); echo "
\n"; echo "\n"; echo "\n"; // Data only echo "\n"; echo "\n"; echo "\n\n"; echo "\n\n"; // Structure only echo "\n"; echo "\n\n"; // Structure and data echo "\n"; echo "\n"; echo "\n\n"; echo "\n\n"; echo "\n\n"; echo "
{$lang['strformat']}{$lang['stroptions']}
"; echo "{$lang['strdataonly']}{$lang['strformat']}\n
{$lang['stroids']}
{$lang['strstructureonly']}{$lang['strdrop']}
"; echo "{$lang['strstructureanddata']}{$lang['strformat']}\n
{$lang['strdrop']}
{$lang['stroids']}
\n"; echo "

{$lang['stroptions']}

\n"; echo "

{$lang['strshow']}\n"; echo "
{$lang['strdownload']}

\n"; echo "

\n"; echo "

\n"; echo $misc->form; echo "

\n"; echo "
\n"; } /** * Show default list of databases in the server */ function doDefault($msg = '') { global $data, $conf, $misc; global $PHP_SELF, $lang; $misc->printTrail('server'); $misc->printTabs('server','databases'); $misc->printMsg($msg); $databases = &$data->getDatabases(); $columns = array( 'database' => array( 'title' => $lang['strdatabase'], 'field' => 'datname', ), 'owner' => array( 'title' => $lang['strowner'], 'field' => 'datowner', ), 'encoding' => array( 'title' => $lang['strencoding'], 'field' => 'datencoding', ), 'tablespace' => array( 'title' => $lang['strtablespace'], 'field' => 'tablespace', ), 'actions' => array( 'title' => $lang['stractions'], ), 'comment' => array( 'title' => $lang['strcomment'], 'field' => 'datcomment', ), ); $actions = array( 'properties' => array( 'title' => $lang['strproperties'], 'url' => 'redirect.php?section=database&', 'vars' => array('database' => 'datname'), ), 'drop' => array( 'title' => $lang['strdrop'], 'url' => "{$PHP_SELF}?action=confirm_drop&subject=database&", 'vars' => array('database' => 'datname'), ), 'privileges' => array( 'title' => $lang['strprivileges'], 'url' => "privileges.php?subject=database&", 'vars' => array('database' => 'datname'), ) ); if (!$data->hasTablespaces()) unset($columns['tablespace']); if (!isset($data->privlist['database'])) unset($actions['privileges']); $misc->printTable($databases, $columns, $actions, $lang['strnodatabases']); echo "

{$lang['strcreatedatabase']}

\n"; } $misc->printHeader($lang['strdatabases']); $misc->printBody(); switch ($action) { case 'export': doExport(); break; case 'save_create': if (isset($_POST['cancel'])) doDefault(); else doSaveCreate(); break; case 'create': doCreate(); break; case 'drop': if (isset($_REQUEST['drop'])) doDrop(false); else doDefault(); break; case 'confirm_drop': doDrop(true); break; default: doDefault(); break; } $misc->printFooter(); ?> e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.


DISEÑO DE HERRAMIENTAS PARA PORTAL DE GESTIÓN DE CENTROS DOCENTES

: LEIVA JIMÉNEZ, ANDRÉS
: Ingeniería Telecomunicación
Contenido del proyecto:
Directorio raíz  >  proyecto  >  proyecto  >  per_doc  >  administrador  >  phpPgAdmin  >  all_db.php