e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.

{$term}", $string); } /** * Sends a signal to a process */ function doSignal() { global $data, $lang; $status = $data->sendSignal($_REQUEST['procpid'], $_REQUEST['signal']); if ($status == 0) doProcesses($lang['strsignalsent']); else doProcesses($lang['strsignalsentbad']); } /** * Searches for a named database object */ function doFind($confirm = true, $msg = '') { global $PHP_SELF, $data, $data, $misc; global $lang, $conf; if (!isset($_GET['term'])) $_GET['term'] = ''; if (!isset($_GET['filter'])) $_GET['filter'] = ''; $misc->printTrail('database'); $misc->printTabs('database','find'); $misc->printMsg($msg); echo "

\n"; echo "

_maxNameLen}\" />\n"; // Output list of filters. This is complex due to all the 'has' and 'conf' feature possibilities echo "\n"; echo "\n"; echo $misc->form; echo "\n"; echo "

\n"; // Default focus $misc->setFocus('forms[0].term'); // If a search term has been specified, then perform the search // and display the results, grouped by object type if ($_GET['term'] != '') { $rs = &$data->findObject($_GET['term'], $_GET['filter']); if ($rs->recordCount() > 0) { $curr = ''; while (!$rs->EOF) { // Output a new header if the current type has changed, but not if it's just changed the rule type if ($rs->f['type'] != $curr) { // Short-circuit in the case of changing from table rules to view rules; table cols to view cols; // table constraints to domain constraints if ($rs->f['type'] == 'RULEVIEW' && $curr == 'RULETABLE') { $curr = $rs->f['type']; } elseif ($rs->f['type'] == 'COLUMNVIEW' && $curr == 'COLUMNTABLE') { $curr = $rs->f['type']; } elseif ($rs->f['type'] == 'CONSTRAINTTABLE' && $curr == 'CONSTRAINTDOMAIN') { $curr = $rs->f['type']; } else { if ($curr != '') echo "\n"; $curr = $rs->f['type']; echo "

"; switch ($curr) { case 'SCHEMA': echo $lang['strschemas']; break; case 'TABLE': echo $lang['strtables']; break; case 'VIEW': echo $lang['strviews']; break; case 'SEQUENCE': echo $lang['strsequences']; break; case 'COLUMNTABLE': case 'COLUMNVIEW': echo $lang['strcolumns']; break; case 'INDEX': echo $lang['strindexes']; break; case 'CONSTRAINTTABLE': case 'CONSTRAINTDOMAIN': echo $lang['strconstraints']; break; case 'TRIGGER': echo $lang['strtriggers']; break; case 'RULETABLE': case 'RULEVIEW': echo $lang['strrules']; break; case 'FUNCTION': echo $lang['strfunctions']; break; case 'TYPE': echo $lang['strtypes']; break; case 'DOMAIN': echo $lang['strdomains']; break; case 'OPERATOR': echo $lang['stroperators']; break; case 'CONVERSION': echo $lang['strconversions']; break; case 'LANGUAGE': echo $lang['strlanguages']; break; case 'AGGREGATE': echo $lang['straggregates']; break; case 'OPCLASS': echo $lang['stropclasses']; break; } echo "

"; echo "

href}\">", _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&table=", urlencode($rs->f['name']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&view=", urlencode($rs->f['name']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&sequence=", urlencode($rs->f['name']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&table=", urlencode($rs->f['relname']), "&column=", urlencode($rs->f['name']), "&action=properties\">", $misc->printVal($prefix), $misc->printVal($rs->f['relname']), '.', _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&view=", urlencode($rs->f['relname']), "&column=", urlencode($rs->f['name']), "&action=properties\">", $misc->printVal($prefix), $misc->printVal($rs->f['relname']), '.', _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&table=", urlencode($rs->f['relname']), "\">", $misc->printVal($prefix), $misc->printVal($rs->f['relname']), '.', _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&table=", urlencode($rs->f['relname']), "\">", $misc->printVal($prefix), $misc->printVal($rs->f['relname']), '.', _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&domain=", urlencode($rs->f['relname']), "\">", $misc->printVal($prefix), $misc->printVal($rs->f['relname']), '.', _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&table=", urlencode($rs->f['relname']), "\">", $misc->printVal($prefix), $misc->printVal($rs->f['relname']), '.', _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&reltype=table&relation=", urlencode($rs->f['relname']), "\">", $misc->printVal($prefix), $misc->printVal($rs->f['relname']), '.', _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&reltype=view&relation=", urlencode($rs->f['relname']), "\">", $misc->printVal($prefix), $misc->printVal($rs->f['relname']), '.', _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&function=", urlencode($rs->f['name']), "&function_oid=", urlencode($rs->f['oid']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&type=", urlencode($rs->f['name']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&domain=", urlencode($rs->f['name']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "&operator=", urlencode($rs->f['name']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}\">", _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "
href}&schema=", urlencode($rs->f['schemaname']), "\">", $misc->printVal($prefix), _highlight($misc->printVal($rs->f['name']), $_GET['term']), "

\n"; echo "

", $rs->recordCount(), " ", $lang['strobjects'], "

\n"; } else echo "

{$lang['strnoobjects']}

\n"; } } /** * Displays options for database download */ function doExport($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('database'); $misc->printTabs('database','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"; // MSIE cannot download gzip in SSL mode - it's just broken if (!(strstr($_SERVER['HTTP_USER_AGENT'], 'MSIE') && isset($_SERVER['HTTPS']))) { echo "
{$lang['strdownloadgzipped']}\n"; } echo "

\n"; echo "

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

\n"; echo "

\n"; } /** * Show the current status of all database variables */ function doVariables() { global $PHP_SELF, $data, $misc; global $lang; // Fetch the variables from the database $variables = &$data->getVariables(); $misc->printTrail('database'); $misc->printTabs('database','variables'); $columns = array( 'variable' => array( 'title' => $lang['strname'], 'field' => 'name', ), 'value' => array( 'title' => $lang['strsetting'], 'field' => 'setting', ), ); $actions = array(); $misc->printTable($variables, $columns, $actions, $lang['strnodata']); } /** * Show all current database connections and any queries they * are running. */ function doProcesses($msg = '') { global $PHP_SELF, $data, $misc; global $lang; // Fetch the processes from the database $processes = &$data->getProcesses($_REQUEST['database']); $misc->printTrail('database'); $misc->printTabs('database','processes'); $misc->printMsg($msg); $columns = array( 'user' => array( 'title' => $lang['strusername'], 'field' => 'usename', ), 'process' => array( 'title' => $lang['strprocess'], 'field' => 'procpid', ), 'query' => array( 'title' => $lang['strsql'], 'field' => 'current_query', ), 'start_time' => array( 'title' => $lang['strstarttime'], 'field' => 'query_start', ), ); if ($data->hasSignals()) { $columns['actions'] = array('title' => $lang['stractions']); $actions = array( 'cancel' => array( 'title' => $lang['strcancel'], 'url' => "{$PHP_SELF}?action=signal&signal=CANCEL&database=" . urlencode($_REQUEST['database']) . "&", 'vars' => array('procpid' => 'procpid') ) ); } else $actions = array(); // Remove query start time for <7.4 if (!isset($processes->f['query_start'])) unset($columns['start_time']); $misc->printTable($processes, $columns, $actions, $lang['strnodata']); } /** * Allow database administration and tuning tasks */ function doAdmin($action = '', $msg = '') { global $PHP_SELF, $data, $misc; global $lang; switch ($action) { case 'vacuum': $status = $data->vacuumDB('', isset($_REQUEST['vacuum_analyze']), isset($_REQUEST['vacuum_full']), isset($_REQUEST['vacuum_freeze']) ); if ($status == 0) doAdmin('', $lang['strvacuumgood']); else doAdmin('', $lang['strvacuumbad']); break; case 'analyze': $status = $data->analyzeDB(); if ($status == 0) doAdmin('', $lang['stranalyzegood']); else doAdmin('', $lang['stranalyzebad']); break; case 'recluster': $status = $data->recluster(); if ($status == 0) doAdmin('', $lang['strclusteredgood']); else doAdmin('', $lang['strclusteredbad']); break; case 'reindex'; $status = $data->reindex('DATABASE', $_REQUEST['database'], isset($_REQUEST['reindex_force'])); if ($status == 0) doAdmin('', $lang['strreindexgood']); else doAdmin('', $lang['strreindexbad']); break; default: $misc->printTrail('database'); $misc->printTabs('database','admin'); $misc->printMsg($msg); // Vacuum echo "\n"; // Analyze echo "\n"; // Recluster if ($data->hasRecluster()){ echo "\n"; } // Reindex echo "\n"; break; } } /** * Allow execution of arbitrary SQL statements on a database */ function doSQL() { global $PHP_SELF, $data, $misc; global $lang; if (!isset($_REQUEST['query'])) $_REQUEST['query'] = ''; $misc->printTrail('database'); $misc->printTabs('database','sql'); echo "

{$lang['strentersql']}

\n"; echo "\n"; // Default focus $misc->setFocus('forms[0].query'); } /** * Show confirmation of drop and perform actual drop */ function doDrop($confirm) { global $PHP_SELF, $data, $data, $misc; global $lang, $_reload_browser; if ($confirm) { $misc->printTrail('schema'); $misc->printTitle($lang['strdrop'],'pg.schema.drop'); echo "

", sprintf($lang['strconfdropschema'], $misc->printVal($_REQUEST['schema'])), "

\n"; echo "\n"; } else { $status = $data->dropSchema($_POST['schema'], isset($_POST['cascade'])); if ($status == 0) { $_reload_browser = true; doDefault($lang['strschemadropped']); } else doDefault($lang['strschemadroppedbad']); } } /** * Displays a screen where they can enter a new schema */ function doCreate($msg = '') { global $data, $misc; global $PHP_SELF, $lang; if (!isset($_POST['formName'])) $_POST['formName'] = ''; if (!isset($_POST['formAuth'])) $_POST['formAuth'] = $_SESSION['webdbUsername']; if (!isset($_POST['formSpc'])) $_POST['formSpc'] = ''; if (!isset($_POST['formComment'])) $_POST['formComment'] = ''; // Fetch all users from the database $users = &$data->getUsers(); $misc->printTrail('database'); $misc->printTitle($lang['strcreateschema'],'pg.schema.create'); $misc->printMsg($msg); echo "

\n"; echo "\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; // Owner echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n"; echo "

{$lang['strname']}	_maxNameLen}\" value=\"", htmlspecialchars($_POST['formName']), "\" />
{$lang['strowner']}	\n\t\t\t\n\t\t
{$lang['strcomment']}	", htmlspecialchars($_POST['formComment']), "

\n"; echo "

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

\n"; echo "

\n"; } /** * Actually creates the new schema in the database */ function doSaveCreate() { global $data, $lang, $_reload_browser; // Check that they've given a name if ($_POST['formName'] == '') doCreate($lang['strschemaneedsname']); else { $status = $data->createSchema($_POST['formName'], $_POST['formAuth'], $_POST['formComment']); if ($status == 0) { $_reload_browser = true; doDefault($lang['strschemacreated']); } else doCreate($lang['strschemacreatedbad']); } } /** * Show default list of schemas in the server */ function doDefault($msg = '') { global $data, $misc, $conf; global $PHP_SELF, $lang; $misc->printTrail('database'); $misc->printTabs('database','schemas'); $misc->printMsg($msg); // Check that the DB actually supports schemas if ($data->hasSchemas()) { $schemas = &$data->getSchemas(); $columns = array( 'schema' => array( 'title' => $lang['strschema'], 'field' => 'nspname', ), 'owner' => array( 'title' => $lang['strowner'], 'field' => 'nspowner', ), 'actions' => array( 'title' => $lang['stractions'], ), 'comment' => array( 'title' => $lang['strcomment'], 'field' => 'nspcomment', ), ); $actions = array( 'properties' => array( 'title' => $lang['strproperties'], 'url' => "redirect.php?section=schema&database=".urlencode($_REQUEST['database'])."&", 'vars' => array('schema' => 'nspname'), ), 'drop' => array( 'title' => $lang['strdrop'], 'url' => "{$PHP_SELF}?action=confirm_drop&database=".urlencode($_REQUEST['database'])."&", 'vars' => array('schema' => 'nspname'), ), 'privileges' => array( 'title' => $lang['strprivileges'], 'url' => "privileges.php?subject=schema&database=".urlencode($_REQUEST['database'])."&", 'vars' => array('schema' => 'nspname'), ), 'alter' => array( 'title' => $lang['stralter'], 'url' => "{$PHP_SELF}?action=alter_schema&database=".urlencode($_REQUEST['database'])."&", 'vars' => array('schema' => 'nspname'), ), ); $misc->printTable($schemas, $columns, $actions, $lang['strnoschemas']); echo "

{$lang['strcreateschema']}

\n"; } else { // If the database does not support schemas... echo "

{$lang['strnoschemas']}

\n"; } } /** * Display a form to permit editing schema properies. * TODO: permit changing name, owner */ function doAlterSchema($msg = '') { global $data, $misc,$PHP_SELF, $lang; $misc->printTrail('schema'); $misc->printTitle($lang['stralter'],'pg.schema.alter'); $misc->printMsg($msg); $schema = &$data->getSchemaByName($_REQUEST['schema']); if ($schema->recordCount() > 0) { if (!isset($_POST['comment'])) $_POST['comment'] = $schema->f['nspcomment']; if (!isset($_POST['schema'])) $_POST['schema'] = $_REQUEST['schema']; echo "

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

{$lang['strcomment']}	", htmlspecialchars($_POST['comment']), "

\n"; echo "

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

\n"; echo "

\n"; } else { echo "

{$lang['strnodata']}

\n"; } } /** * Save the form submission containing changes to a schema */ function doSaveAlterSchema($msg = '') { global $data, $misc,$PHP_SELF, $lang; $status = $data->updateSchema($_POST['schema'], $_POST['comment']); if ($status == 0) doDefault($lang['strschemaaltered']); else doAlterSchema($lang['strschemaalteredbad']); } $misc->printHeader($lang['strschemas']); $misc->printBody(); switch ($action) { case 'find': if (isset($_GET['term'])) doFind(false); else doFind(true); break; case 'recluster': case 'reindex': case 'analyze': case 'vacuum': doAdmin($action); break; case 'admin': doAdmin(); break; case 'sql': doSQL(); break; case 'save_create': if (!isset($_POST['cancel'])) doSaveCreate(); else doDefault(); break; case 'create': doCreate(); break; case 'drop': if (isset($_POST['drop'])) doDrop(false); else doDefault(); break; case 'confirm_drop': doDrop(true); break; case 'variables': doVariables(); break; case 'processes': doProcesses(); break; case 'export': doExport(); break; case 'signal': doSignal(); break; case 'alter_schema': if (isset($_POST['cancel'])) doDefault(); elseif (isset($_POST['alter'])) doSaveAlterSchema(); else doAlterSchema(); break; default: if ($data->hasSchemas()) doDefault(); else doSQL(); break; } $misc->printFooter(); ?> e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.