forked from ezsystems/ezpublish-legacy
/
index_image_mysql.php
108 lines (92 loc) · 3.16 KB
/
index_image_mysql.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
<?php
define( 'TABLE_METADATA', 'ezdbfile' );
define( 'TABLE_DATA', 'ezdbfile_data' );
function _die( $value )
{
header( $_SERVER['SERVER_PROTOCOL'] . " 500 Internal Server Error" );
die( $value );
}
// Connect to storage database.
$serverString = STORAGE_HOST;
if ( defined( 'STORAGE_SOCKET' ) && STORAGE_SOCKET )
$serverString .= ':' . STORAGE_SOCKET;
elseif ( defined( 'STORAGE_PORT' ) )
$serverString .= ':' . STORAGE_PORT;
$maxTries = 3;
$tries = 0;
while ( $tries < $maxTries )
{
if ( $db = mysql_connect( $serverString, STORAGE_USER, STORAGE_PASS ) )
break;
++$tries;
}
if ( !$db )
_die( "Unable to connect to storage server.\n" );
if ( !mysql_select_db( STORAGE_DB, $db ) )
_die( "Unable to select database " . STORAGE_DB . ".\n" );
if ( !$res = mysql_query( "SET NAMES '" . ( defined( 'STORAGE_CHARSET' ) ? STORAGE_CHARSET : 'utf8' ) . "'", $db ) )
_die( "Failed to set character set.\n" );
$filename = ltrim( $_SERVER['SCRIPT_NAME'], "/"); // Issue #015459
// Fetch file metadata.
$filePathHash = mysql_real_escape_string( $filename );
$sql = "SELECT * FROM " . TABLE_METADATA . " WHERE name_hash=MD5('$filePathHash')" ;
if ( !$res = mysql_query( $sql, $db ) )
_die( "Failed to retrieve file metadata\n" );
if ( !( $metaData = mysql_fetch_array( $res, MYSQL_ASSOC ) ) ||
$metaData['mtime'] < 0 )
{
header( $_SERVER['SERVER_PROTOCOL'] . " 404 Not Found" );
?>
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML><HEAD>
<TITLE>404 Not Found</TITLE>
</HEAD><BODY>
<H1>Not Found</H1>
The requested URL <?php echo htmlspecialchars( $filename ); ?> was not found on this server.<P>
</BODY></HTML>
<?php
mysql_free_result( $res );
mysql_close( $db );
exit( 1 );
}
mysql_free_result( $res );
// Verify the filesize
$sql = "SELECT SUM(LENGTH(filedata)) AS size FROM " . TABLE_DATA . " WHERE name_hash=MD5('$filePathHash')";
if ( !$res = mysql_query( $sql, $db ) )
{
header( $_SERVER['SERVER_PROTOCOL'] . " 500 Internal Server Error" );
exit();
}
$row = mysql_fetch_row( $res );
if ( $row[0] != $metaData['size'] )
{
header( $_SERVER['SERVER_PROTOCOL'] . " 500 Internal Server Error" );
exit();
}
// Fetch file data.
$sql = "SELECT filedata, offset FROM " . TABLE_DATA . " WHERE name_hash=MD5('$filePathHash') ORDER BY offset";
// Set cache time out to 100 minutes by default
$expiry = defined( 'EXPIRY_TIMEOUT' ) ? EXPIRY_TIMEOUT : 6000;
if ( $res = mysql_query( $sql, $db ) )
{
// Output HTTP headers.
$path = $metaData['name'];
$size = $metaData['size'];
$mimeType = $metaData['datatype'];
$mtime = $metaData['mtime'];
$mdate = gmdate( 'D, d M Y H:i:s', $mtime ) . ' GMT';
header( "Content-Length: $size" );
header( "Content-Type: $mimeType" );
header( "Last-Modified: $mdate" );
header( "Expires: " . gmdate('D, d M Y H:i:s', time() + $expiry) . ' GMT' );
header( "Connection: close" );
header( "X-Powered-By: eZ Publish" );
header( "Accept-Ranges: none" );
header( 'Served-by: ' . $_SERVER["SERVER_NAME"] );
// Output image data.
while ( $row = mysql_fetch_row( $res ) )
echo $row[0];
mysql_free_result( $res );
}
mysql_close( $db );
?>