forked from mariuz/firebirdwebadmin
/
showblob.php
executable file
·122 lines (99 loc) · 3.63 KB
/
showblob.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
<?php
// Purpose displays the blob specified through the GET-varibles
// Author Lutz Brueckner <irie@gmx.de>
// Copyright (c) 2000, 2001, 2002, 2003, 2004, 2005 by Lutz Brueckner,
// published under the terms of the GNU General Public Licence v.2,
// see file LICENCE for details
// GET-Variables specifying the blob to display:
//
// $table: table containing the blob
// $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;
case 'hex':
echo hex_view($blob);
break;
}
echo "</body>\n"
. "</html>\n";
function hex_view($data) {
global $s_cust;
$len = strlen($data);
$lines = ceil($len / 16);
$offset = $values = $ascii = '';
$p = 0;
for ($i=1; $i<=$lines; $i++) {
$offset .= sprintf('%08x', $p);
for ($j=0; $j<16; $j++) {
if ($p > $len -1) {
break;
}
$values .= sprintf('%02x', ord($data[$p])).' ';
$ascii .= hex2ascii($data[$p]);
$p++;
}
$offset .= "<br>\n";
$values .= "<br>\n";
$ascii .= "<br>\n";
}
return "<table>\n<tr>\n"
."<td>\n<table>\n<tr>\n<td bgcolor=\"".$s_cust['color']['area']."\" class=\"hex\">\n"
.$offset
."</td>\n</tr>\n</table>\n</td>\n"
."<td>\n<table>\n<tr>\n<td class=\"hex\">\n"
.$values
."</td>\n</tr>\n</table>\n</td>\n"
."<td>\n<table>\n<tr>\n<td bgcolor=\"".$s_cust['color']['area']."\" class=\"hex\">\n"
.$ascii
."</td>\n</tr>\n</table>\n</td>\n"
."</tr>\n</table>\n";
}
function hex2ascii($val) {
return (ord($val) > 31 && ord($val) < 128) ? str_replace(' ', ' ', htmlspecialchars($val)) : '.';
}
?>