function get_field_computed_source($tablename, $fieldname) { $csource = get_blob_content('SELECT F.RDB$COMPUTED_SOURCE' . ' FROM RDB$RELATION_FIELDS R' . ' INNER JOIN RDB$FIELDS F' . ' ON F.RDB$FIELD_NAME=R.RDB$FIELD_SOURCE' . " WHERE R.RDB\$FIELD_NAME='" . $fieldname . "'" . " AND R.RDB\$RELATION_NAME='" . $tablename . "'"); return $csource; }
function get_domain_check($dname) { return substr(get_blob_content('SELECT RDB$VALIDATION_SOURCE' . ' FROM RDB$FIELDS' . " WHERE RDB\$FIELD_NAME='" . $dname . "'"), 6); }
// $col : column containing the blob // $where: sql-where-clause specifying the primary keys to fetch the blob require './inc/script_start.inc.php'; if ($_SERVER['REQUEST_METHOD'] == 'GET') { $table = get_request_data('table', 'GET'); $col = get_request_data('col', 'GET'); $where = get_request_data('where', 'GET'); } else { $table = get_request_data('table'); $col = get_request_data('col'); $where = get_request_data('where'); $s_wt['blob_as'][$col] = get_request_data('blobtype'); } $imageurl = 'showimage.php?where=' . urlencode($where) . '&table=' . $table . '&col=' . $col; $imageurl .= '&' . uniqid('UNIQ_'); $blob = get_blob_content(sprintf('SELECT %s FROM %s %s', $col, $table, $where)); $title = build_title(sprintf('Blob from %s %s', $table, $where), FALSE); echo html_head($title) . '<body bgcolor="' . $s_cust['color']['area'] . "\">\n" . js_window_resize(BLOB_WINDOW_WIDTH, BLOB_WINDOW_HEIGHT) . '<form method="post" action="' . url_session($_SERVER['PHP_SELF']) . '" name="showblob_form">' . "\n" . hidden_field('table', htmlentities($table)) . hidden_field('col', htmlentities($col)) . hidden_field('where', htmlentities($where)) . "<table>\n<tr>\n<td>\n" . get_selectlist('blobtype', $blob_types, $s_wt['blob_as'][$col], TRUE) . "</td>\n<td>\n" . '<input type="submit" name="change_blobtype" value="Change Type">' . "\n" . "</td>\n<td width=\"50\">\n</td>\n<td>\n" . '<input type="button" value="Close" onClick="self.close()">' . "\n" . "</td>\n</tr>\n<table>\n" . "</form>\n"; $blobas = isset($s_wt['blob_as'][$col]) && $s_wt['blob_as'][$col] != '' ? $s_wt['blob_as'][$col] : 'hex'; switch ($blobas) { case 'png': case 'jpg': case 'gif': echo '<img src="' . $imageurl . "\">\n"; break; case 'text': echo '<pre align="left">' . htmlspecialchars($blob) . "</pre>\n"; break; case 'html': echo $blob; break;
// published under the terms of the GNU General Public Licence v.2, // see file LICENCE for details // GET-Variables specifying the blob // // $table: table containing the blob // $col : column containing the blob // $where: sql-where-clause specifying the primary keys to fetch the blob require './inc/configuration.inc.php'; require './inc/session.inc.php'; session_start(); localize_session_vars(); require './lang/' . (isset($s_cust) ? $s_cust['language'] : LANGUAGE) . '.inc.php'; require './inc/functions.inc.php'; $dbhandle = db_connect() or ib_error(); $table = $_GET['table']; $col = $_GET['col']; $where = $_GET['where']; $sql = sprintf('SELECT %s FROM %s %s', $col, $table, $where); $blob = get_blob_content($sql); switch ($s_wt['blob_as'][$col]) { case 'png': header('Content-Type: image/png'); break; case 'jpg': header('Content-Type: image/jpg'); break; case 'gif': header('Content-Type: image/gif'); break; } echo $blob;