Blame view

pma/transformation_wrapper.php 3.28 KB
a1684257   Administrator   first commit
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
  <?php
  /* vim: set expandtab sw=4 ts=4 sts=4: */
  /**
   *
   * @package PhpMyAdmin
   */
  
  /**
   *
   */
  define('IS_TRANSFORMATION_WRAPPER', true);
  
  /**
   * Gets a core script and starts output buffering work
   */
  require_once './libraries/common.inc.php';
  require_once './libraries/transformations.lib.php'; // Transformations
  $cfgRelation = PMA_getRelationsParam();
  
  /**
   * Ensures db and table are valid, else moves to the "parent" script
   */
  require_once './libraries/db_table_exists.lib.php';
  
  
  /**
   * Get the list of the fields of the current table
   */
  PMA_DBI_select_db($db);
  if (isset($where_clause)) {
      $result      = PMA_DBI_query('SELECT * FROM ' . PMA_backquote($table) . ' WHERE ' . $where_clause . ';', null, PMA_DBI_QUERY_STORE);
      $row         = PMA_DBI_fetch_assoc($result);
  } else {
      $result      = PMA_DBI_query('SELECT * FROM ' . PMA_backquote($table) . ' LIMIT 1;', null, PMA_DBI_QUERY_STORE);
      $row         = PMA_DBI_fetch_assoc($result);
  }
  
  // No row returned
  if (!$row) {
      exit;
  } // end if (no record returned)
  
  $default_ct = 'application/octet-stream';
  
  if ($cfgRelation['commwork'] && $cfgRelation['mimework']) {
      $mime_map = PMA_getMime($db, $table);
      $mime_options = PMA_transformation_getOptions((isset($mime_map[$transform_key]['transformation_options']) ? $mime_map[$transform_key]['transformation_options'] : ''));
  
      foreach ($mime_options AS $key => $option) {
          if (substr($option, 0, 10) == '; charset=') {
              $mime_options['charset'] = $option;
          }
      }
  }
  
  // For re-usability, moved http-headers and stylesheets
  // to a seperate file. It can now be included by libraries/header.inc.php,
  // querywindow.php.
  
  require_once './libraries/header_http.inc.php';
  // [MIME]
  if (isset($ct) && !empty($ct)) {
      $mime_type = $ct;
  } else {
      $mime_type = (isset($mime_map[$transform_key]['mimetype']) ? str_replace('_', '/', $mime_map[$transform_key]['mimetype']) : $default_ct) . (isset($mime_options['charset']) ? $mime_options['charset'] : '');
  }
  
  PMA_download_header($cn, $mime_type);
  
  if (! isset($resize)) {
      echo $row[$transform_key];
  } else {
      // if image_*__inline.inc.php finds that we can resize,
      // it sets $resize to jpeg or png
  
      $srcImage = imagecreatefromstring($row[$transform_key]);
      $srcWidth = ImageSX($srcImage);
      $srcHeight = ImageSY($srcImage);
  
      // Check to see if the width > height or if width < height
      // if so adjust accordingly to make sure the image
      // stays smaller then the $newWidth and $newHeight
  
      $ratioWidth = $srcWidth/$newWidth;
      $ratioHeight = $srcHeight/$newHeight;
  
      if ($ratioWidth < $ratioHeight) {
          $destWidth = $srcWidth/$ratioHeight;
          $destHeight = $newHeight;
      } else {
          $destWidth = $newWidth;
          $destHeight = $srcHeight/$ratioWidth;
      }
  
      if ($resize) {
          $destImage = ImageCreateTrueColor($destWidth, $destHeight);
      }
  
  //    ImageCopyResized($destImage, $srcImage, 0, 0, 0, 0, $destWidth, $destHeight, $srcWidth, $srcHeight);
  // better quality but slower:
      ImageCopyResampled($destImage, $srcImage, 0, 0, 0, 0, $destWidth, $destHeight, $srcWidth, $srcHeight);
  
      if ($resize == 'jpeg') {
          ImageJPEG($destImage, '', 75);
      }
      if ($resize == 'png') {
          ImagePNG($destImage);
      }
      ImageDestroy($srcImage);
      ImageDestroy($destImage);
  }
  ?>