transformation_wrapper.php

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5 define('IS_TRANSFORMATION_WRAPPER', true);
   6
   7 /**
   8  * Gets a core script and starts output buffering work
   9  */
  10 require_once('./libraries/common.lib.php');
  11 require_once('./libraries/relation.lib.php'); // foreign keys
  12 require_once('./libraries/transformations.lib.php'); // Transformations
  13 $cfgRelation = PMA_getRelationsParam();
  14
  15 /**
  16  * Ensures db and table are valid, else moves to the "parent" script
  17  */
  18 require_once('./libraries/db_table_exists.lib.php');
  19
  20
  21 /**
  22  * Get the list of the fields of the current table
  23  */
  24 PMA_DBI_select_db($db);
  25 $table_def = PMA_DBI_query('SHOW FIELDS FROM ' . PMA_backquote($table), null, PMA_DBI_QUERY_STORE);
  26 if (isset($primary_key)) {
  27     $result      = PMA_DBI_query('SELECT * FROM ' . PMA_backquote($table) . ' WHERE ' . $primary_key . ';', null, PMA_DBI_QUERY_STORE);
  28     $row         = PMA_DBI_fetch_assoc($result);
  29 } else {
  30     $result      = PMA_DBI_query('SELECT * FROM ' . PMA_backquote($table) . ' LIMIT 1;', null, PMA_DBI_QUERY_STORE);
  31     $row         = PMA_DBI_fetch_assoc($result);
  32 }
  33
  34 // No row returned
  35 if (!$row) {
  36     exit;
  37 } // end if (no record returned)
  38
  39 $default_ct = 'application/octet-stream';
  40
  41 if ($cfgRelation['commwork'] && $cfgRelation['mimework']) {
  42     $mime_map = PMA_getMime($db, $table);
  43     $mime_options = PMA_transformation_getOptions((isset($mime_map[urldecode($transform_key)]['transformation_options']) ? $mime_map[urldecode($transform_key)]['transformation_options'] : ''));
  44
  45     foreach ($mime_options AS $key => $option) {
  46         if (substr($option, 0, 10) == '; charset=') {
  47             $mime_options['charset'] = $option;
  48         }
  49     }
  50 }
  51
  52 // garvin: For re-usability, moved http-headers and stylesheets
  53 // to a seperate file. It can now be included by libraries/header.inc.php,
  54 // querywindow.php.
  55
  56 require_once('./libraries/header_http.inc.php');
  57 // [MIME]
  58 if (isset($ct) && !empty($ct)) {
  59     $content_type = 'Content-Type: ' . urldecode($ct);
  60 } else {
  61     $content_type = 'Content-Type: ' . (isset($mime_map[urldecode($transform_key)]['mimetype']) ? str_replace('_', '/', $mime_map[urldecode($transform_key)]['mimetype']) : $default_ct) . (isset($mime_options['charset']) ? $mime_options['charset'] : '');
  62 }
  63
  64 if (isset($cn) && !empty($cn)) {
  65     $content_type .= "\n" . 'Content-Disposition: attachment; filename=' . urldecode($cn);
  66 }
  67
  68 header($content_type);
  69
  70 if (!isset($resize)) {
  71     echo $row[urldecode($transform_key)];
  72 } else {
  73     // if image_*__inline.inc.php finds that we can resize,
  74     // it sets $resize to jpeg or png
  75
  76     $srcImage = imagecreatefromstring($row[urldecode($transform_key)]);
  77     $srcWidth = ImageSX( $srcImage );
  78     $srcHeight = ImageSY( $srcImage );
  79
  80     // Check to see if the width > height or if width < height
  81     // if so adjust accordingly to make sure the image
  82     // stays smaller then the $newWidth and $newHeight
  83
  84     $ratioWidth = $srcWidth/$newWidth;
  85     $ratioHeight = $srcHeight/$newHeight;
  86
  87     if ($ratioWidth < $ratioHeight){
  88         $destWidth = $srcWidth/$ratioHeight;
  89         $destHeight = $newHeight;
  90     } else {
  91         $destWidth = $newWidth;
  92         $destHeight = $srcHeight/$ratioWidth;
  93     }
  94
  95     if ($resize) {
  96         $destImage = ImageCreateTrueColor( $destWidth, $destHeight);
  97     }
  98
  99 //    ImageCopyResized( $destImage, $srcImage, 0, 0, 0, 0, $destWidth, $destHeight, $srcWidth, $srcHeight );
 100 // better quality but slower:
 101     ImageCopyResampled( $destImage, $srcImage, 0, 0, 0, 0, $destWidth, $destHeight, $srcWidth, $srcHeight );
 102
 103     if ($resize == 'jpeg') {
 104         ImageJPEG( $destImage, '', 75 );
 105     }
 106     if ($resize == 'png') {
 107         ImagePNG( $destImage);
 108     }
 109     ImageDestroy( $srcImage );
 110     ImageDestroy( $destImage );
 111 }
 112
 113 /**
 114  * Close MySql non-persistent connections
 115  */
 116 if (isset($GLOBALS['controllink']) && $GLOBALS['controllink']) {
 117     @PMA_DBI_close($GLOBALS['controllink']);
 118 }
 119 if (isset($GLOBALS['userlink']) && $GLOBALS['userlink']) {
 120     @PMA_DBI_close($GLOBALS['userlink']);
 121 }
 122 ?>