36
36
global $data, $misc;
37
37
global $lang, $conf;
39
if (!isset($_GET['term'])) $_GET['term'] = '';
40
if (!isset($_GET['filter'])) $_GET['filter'] = '';
39
if (!isset($_REQUEST['term'])) $_REQUEST['term'] = '';
40
if (!isset($_REQUEST['filter'])) $_REQUEST['filter'] = '';
42
42
$misc->printTrail('database');
43
43
$misc->printTabs('database','find');
44
44
$misc->printMsg($msg);
46
echo "<form action=\"database.php\" method=\"get\">\n";
47
echo "<p><input name=\"term\" value=\"", htmlspecialchars($_GET['term']),
46
echo "<form action=\"database.php\" method=\"post\">\n";
47
echo "<p><input name=\"term\" value=\"", htmlspecialchars($_REQUEST['term']),
48
48
"\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" />\n";
49
49
// Output list of filters. This is complex due to all the 'has' and 'conf' feature possibilities
50
50
echo "<select name=\"filter\">\n";
51
echo "\t<option value=\"\"", ($_GET['filter'] == '') ? ' selected="selected"' : '', ">{$lang['strallobjects']}</option>\n";
51
echo "\t<option value=\"\"", ($_REQUEST['filter'] == '') ? ' selected="selected"' : '', ">{$lang['strallobjects']}</option>\n";
52
52
if ($data->hasSchemas())
53
echo "\t<option value=\"SCHEMA\"", ($_GET['filter'] == 'SCHEMA') ? ' selected="selected"' : '', ">{$lang['strschemas']}</option>\n";
54
echo "\t<option value=\"TABLE\"", ($_GET['filter'] == 'TABLE') ? ' selected="selected"' : '', ">{$lang['strtables']}</option>\n";
55
echo "\t<option value=\"VIEW\"", ($_GET['filter'] == 'VIEW') ? ' selected="selected"' : '', ">{$lang['strviews']}</option>\n";
56
echo "\t<option value=\"SEQUENCE\"", ($_GET['filter'] == 'SEQUENCE') ? ' selected="selected"' : '', ">{$lang['strsequences']}</option>\n";
57
echo "\t<option value=\"COLUMN\"", ($_GET['filter'] == 'COLUMN') ? ' selected="selected"' : '', ">{$lang['strcolumns']}</option>\n";
58
echo "\t<option value=\"RULE\"", ($_GET['filter'] == 'RULE') ? ' selected="selected"' : '', ">{$lang['strrules']}</option>\n";
59
echo "\t<option value=\"INDEX\"", ($_GET['filter'] == 'INDEX') ? ' selected="selected"' : '', ">{$lang['strindexes']}</option>\n";
60
echo "\t<option value=\"TRIGGER\"", ($_GET['filter'] == 'TRIGGER') ? ' selected="selected"' : '', ">{$lang['strtriggers']}</option>\n";
61
echo "\t<option value=\"CONSTRAINT\"", ($_GET['filter'] == 'CONSTRAINT') ? ' selected="selected"' : '', ">{$lang['strconstraints']}</option>\n";
62
echo "\t<option value=\"FUNCTION\"", ($_GET['filter'] == 'FUNCTION') ? ' selected="selected"' : '', ">{$lang['strfunctions']}</option>\n";
53
echo "\t<option value=\"SCHEMA\"", ($_REQUEST['filter'] == 'SCHEMA') ? ' selected="selected"' : '', ">{$lang['strschemas']}</option>\n";
54
echo "\t<option value=\"TABLE\"", ($_REQUEST['filter'] == 'TABLE') ? ' selected="selected"' : '', ">{$lang['strtables']}</option>\n";
55
echo "\t<option value=\"VIEW\"", ($_REQUEST['filter'] == 'VIEW') ? ' selected="selected"' : '', ">{$lang['strviews']}</option>\n";
56
echo "\t<option value=\"SEQUENCE\"", ($_REQUEST['filter'] == 'SEQUENCE') ? ' selected="selected"' : '', ">{$lang['strsequences']}</option>\n";
57
echo "\t<option value=\"COLUMN\"", ($_REQUEST['filter'] == 'COLUMN') ? ' selected="selected"' : '', ">{$lang['strcolumns']}</option>\n";
58
echo "\t<option value=\"RULE\"", ($_REQUEST['filter'] == 'RULE') ? ' selected="selected"' : '', ">{$lang['strrules']}</option>\n";
59
echo "\t<option value=\"INDEX\"", ($_REQUEST['filter'] == 'INDEX') ? ' selected="selected"' : '', ">{$lang['strindexes']}</option>\n";
60
echo "\t<option value=\"TRIGGER\"", ($_REQUEST['filter'] == 'TRIGGER') ? ' selected="selected"' : '', ">{$lang['strtriggers']}</option>\n";
61
echo "\t<option value=\"CONSTRAINT\"", ($_REQUEST['filter'] == 'CONSTRAINT') ? ' selected="selected"' : '', ">{$lang['strconstraints']}</option>\n";
62
echo "\t<option value=\"FUNCTION\"", ($_REQUEST['filter'] == 'FUNCTION') ? ' selected="selected"' : '', ">{$lang['strfunctions']}</option>\n";
63
63
if ($data->hasDomains())
64
echo "\t<option value=\"DOMAIN\"", ($_GET['filter'] == 'DOMAIN') ? ' selected="selected"' : '', ">{$lang['strdomains']}</option>\n";
64
echo "\t<option value=\"DOMAIN\"", ($_REQUEST['filter'] == 'DOMAIN') ? ' selected="selected"' : '', ">{$lang['strdomains']}</option>\n";
65
65
if ($conf['show_advanced']) {
66
echo "\t<option value=\"AGGREGATE\"", ($_GET['filter'] == 'AGGREGATE') ? ' selected="selected"' : '', ">{$lang['straggregates']}</option>\n";
67
echo "\t<option value=\"TYPE\"", ($_GET['filter'] == 'TYPE') ? ' selected="selected"' : '', ">{$lang['strtypes']}</option>\n";
68
echo "\t<option value=\"OPERATOR\"", ($_GET['filter'] == 'OPERATOR') ? ' selected="selected"' : '', ">{$lang['stroperators']}</option>\n";
69
echo "\t<option value=\"OPCLASS\"", ($_GET['filter'] == 'OPCLASS') ? ' selected="selected"' : '', ">{$lang['stropclasses']}</option>\n";
66
echo "\t<option value=\"AGGREGATE\"", ($_REQUEST['filter'] == 'AGGREGATE') ? ' selected="selected"' : '', ">{$lang['straggregates']}</option>\n";
67
echo "\t<option value=\"TYPE\"", ($_REQUEST['filter'] == 'TYPE') ? ' selected="selected"' : '', ">{$lang['strtypes']}</option>\n";
68
echo "\t<option value=\"OPERATOR\"", ($_REQUEST['filter'] == 'OPERATOR') ? ' selected="selected"' : '', ">{$lang['stroperators']}</option>\n";
69
echo "\t<option value=\"OPCLASS\"", ($_REQUEST['filter'] == 'OPCLASS') ? ' selected="selected"' : '', ">{$lang['stropclasses']}</option>\n";
70
70
if ($data->hasConversions())
71
echo "\t<option value=\"CONVERSION\"", ($_GET['filter'] == 'CONVERSION') ? ' selected="selected"' : '', ">{$lang['strconversions']}</option>\n";
72
echo "\t<option value=\"LANGUAGE\"", ($_GET['filter'] == 'LANGUAGE') ? ' selected="selected"' : '', ">{$lang['strlanguages']}</option>\n";
71
echo "\t<option value=\"CONVERSION\"", ($_REQUEST['filter'] == 'CONVERSION') ? ' selected="selected"' : '', ">{$lang['strconversions']}</option>\n";
72
echo "\t<option value=\"LANGUAGE\"", ($_REQUEST['filter'] == 'LANGUAGE') ? ' selected="selected"' : '', ">{$lang['strlanguages']}</option>\n";
74
74
echo "</select>\n";
75
75
echo "<input type=\"submit\" value=\"{$lang['strfind']}\" />\n";
176
echo "<li><a href=\"redirect.php?subject=schema&{$misc->href}&schema=", $misc->printVal($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
176
echo "<li><a href=\"redirect.php?subject=schema&{$misc->href}&schema=", $misc->printVal($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
180
180
if (!empty($prefix))
181
181
echo "<a href=\"tables.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
182
182
echo "<a href=\"redirect.php?subject=table&{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&table=",
183
urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
183
urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
187
187
if (!empty($prefix))
188
188
echo "<a href=\"views.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
189
189
echo "<a href=\"redirect.php?subject=view&{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&view=",
190
urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
190
urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
194
194
if (!empty($prefix))
195
195
echo "<a href=\"sequences.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
196
196
echo "<a href=\"sequences.php?subject=sequence&action=properties&{$misc->href}&schema=", urlencode($rs->fields['schemaname']),
197
"&sequence=", urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
197
"&sequence=", urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
199
199
case 'COLUMNTABLE':
212
212
echo "<a href=\"viewproperties.php?subject=view&{$misc->href}&view=", urlencode($rs->fields['relname']), "&schema=", urlencode($rs->fields['schemaname']), "\">", $misc->printVal($rs->fields['relname']), "</a>.";
213
213
echo "<a href=\"colproperties.php?{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&view=",
214
214
urlencode($rs->fields['relname']), "&column=", urlencode($rs->fields['name']), "\">",
215
_highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
215
_highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
219
219
if (!empty($prefix))
220
220
echo "<a href=\"redirect.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "}</a>.";
221
221
echo "<a href=\"redirect.php?subject=table&{$misc->href}&table=", urlencode($rs->fields['relname']), "&schema=", urlencode($rs->fields['schemaname']), "\">", $misc->printVal($rs->fields['relname']), "</a>.";
222
echo "<a href=\"indexes.php?{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&table=", urlencode($rs->fields['relname']), "\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
222
echo "<a href=\"indexes.php?{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&table=", urlencode($rs->fields['relname']), "\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
224
224
case 'CONSTRAINTTABLE':
227
227
echo "<a href=\"redirect.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
228
228
echo "<a href=\"redirect.php?subject=table&{$misc->href}&table=", urlencode($rs->fields['relname']), "&schema=", urlencode($rs->fields['schemaname']), "\">", $misc->printVal($rs->fields['relname']), "</a>.";
229
229
echo "<a href=\"constraints.php?{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&table=",
230
urlencode($rs->fields['relname']), "\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
230
urlencode($rs->fields['relname']), "\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
232
232
case 'CONSTRAINTDOMAIN':
234
234
if (!empty($prefix))
235
235
echo "<a href=\"domains.php?subject=schema&{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "\">", $misc->printVal($prefix), "</a>.";
236
236
echo "<a href=\"domains.php?action=properties&{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&domain=", urlencode($rs->fields['relname']), "\">",
237
$misc->printVal($rs->fields['relname']), '.', _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
237
$misc->printVal($rs->fields['relname']), '.', _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
266
266
echo "<a href=\"functions.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
267
267
echo "<a href=\"functions.php?action=properties&{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&function=",
268
268
urlencode($rs->fields['name']), "&function_oid=", urlencode($rs->fields['oid']), "\">",
269
_highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
269
_highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
273
273
if (!empty($prefix))
274
274
echo "<a href=\"types.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
275
275
echo "<a href=\"types.php?action=properties&{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&type=",
276
urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
276
urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
280
280
if (!empty($prefix))
281
281
echo "<a href=\"domains.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
282
282
echo "<a href=\"domains.php?action=properties&{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&domain=",
283
urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
283
urlencode($rs->fields['name']), "\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
287
287
if (!empty($prefix))
288
288
echo "<a href=\"operators.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
289
289
echo "<a href=\"operators.php?action=properties&{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "&operator=",
290
urlencode($rs->fields['name']), "&operator_oid=", urlencode($rs->fields['oid']) ,"\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
290
urlencode($rs->fields['name']), "&operator_oid=", urlencode($rs->fields['oid']) ,"\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
292
292
case 'CONVERSION':
294
294
if (!empty($prefix))
295
295
echo "<a href=\"conversions.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
296
296
echo "<a href=\"conversions.php?{$misc->href}&schema=", urlencode($rs->fields['schemaname']),
297
"\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
297
"\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
300
echo "<li><a href=\"languages.php?{$misc->href}\">", _highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
300
echo "<li><a href=\"languages.php?{$misc->href}\">", _highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
302
302
case 'AGGREGATE':
304
304
if (!empty($prefix))
305
305
echo "<a href=\"aggregates.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
306
306
echo "<a href=\"aggregates.php?{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "\">",
307
_highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
307
_highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";
311
311
if (!empty($prefix))
312
312
echo "<a href=\"redirect.php?subject=schema&{$misc->href}&schema=", urlencode($prefix), "\">", $misc->printVal($prefix), "</a>.";
313
313
echo "<a href=\"opclasses.php?{$misc->href}&schema=", urlencode($rs->fields['schemaname']), "\">",
314
_highlight($misc->printVal($rs->fields['name']), $_GET['term']), "</a></li>\n";
314
_highlight($misc->printVal($rs->fields['name']), $_REQUEST['term']), "</a></li>\n";