bs_change_mime_type.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3     /**
   4      * @version     1.0
   5      * @package     BLOBStreaming
   6      */
   7
   8     /**
   9      * Core library.
  10      */
  11     require_once './libraries/common.inc.php';
  12
  13     /**
  14      * @var     string  contains database name
  15      */
  16     $bsDB = isset($_REQUEST['bs_db']) ? urldecode($_REQUEST['bs_db']) : NULL;
  17
  18     /**
  19      * @var     string  contains table name
  20      */
  21     $bsTable = isset($_REQUEST['bs_table']) ? urldecode($_REQUEST['bs_table']) : NULL;
  22
  23     /**
  24      * @var     string  contains BLOB reference
  25      */
  26     $bsReference = isset($_REQUEST['bs_reference']) ? urldecode($_REQUEST['bs_reference']) : NULL;
  27
  28     /**
  29      * @var     string  contains MIME type
  30      */
  31     $bsNewMIMEType = isset($_REQUEST['bs_new_mime_type']) ? urldecode($_REQUEST['bs_new_mime_type']) : NULL;
  32
  33     // necessary variables exist
  34     if ($bsDB && $bsTable && $bsReference && $bsNewMIMEType)
  35     {
  36         // load PMA configuration
  37         $PMA_Config = $GLOBALS['PMA_Config'];
  38
  39         // if PMA configuration exists
  40         if (!empty($PMA_Config))
  41         {
  42             // if BS plugins exist
  43             if ($PMA_Config->get('BLOBSTREAMING_PLUGINS_EXIST'))
  44             {
  45                 $pbms_ref_tbl = $PMA_Config->get('PBMS_NAME') . '_reference';
  46                 $pbms_cust_content_type_tbl = $PMA_Config->get('PBMS_NAME') . '_custom_content_type';
  47
  48                 // if specified DB is selected
  49                 if (PMA_DBI_select_db($bsDB))
  50                 {
  51                     $query = "SELECT * FROM " . PMA_backquote($pbms_ref_tbl);
  52                     $query .= " WHERE Blob_url='" . PMA_sqlAddslashes($bsReference) . "'";
  53
  54                     $result = PMA_DBI_query($query);
  55
  56                     // if record exists
  57                     if ($data = PMA_DBI_fetch_assoc($result))
  58                     {
  59                         $query = "SELECT count(*) FROM " . PMA_backquote($pbms_cust_content_type_tbl);
  60                         $query .= " WHERE Blob_url='" . PMA_sqlAddslashes($bsReference) . "'";
  61
  62                         $result = PMA_DBI_query($query);
  63
  64                         // if record exists
  65                         if ($data = PMA_DBI_fetch_assoc($result))
  66                         {
  67                             if (1 == $data['count(*)'])
  68                             {
  69                                 $query = "UPDATE " . PMA_backquote($pbms_cust_content_type_tbl) . " SET Content_type='";
  70                                 $query .= PMA_sqlAddslashes($bsNewMIMEType) . "' WHERE Blob_url='" . PMA_sqlAddslashes($bsReference) . "'";
  71                             }
  72                             else
  73                             {
  74                                 $query = "INSERT INTO " . PMA_backquote($pbms_cust_content_type_tbl) . " (Blob_url, Content_type)";
  75                                 $query .= " VALUES('" . PMA_sqlAddslashes($bsReference) . "', '" . PMA_sqlAddslashes($bsNewMIMEType) . "')";
  76                             }
  77
  78                             $result = PMA_DBI_query($query);
  79
  80                             // if query execution succeeded
  81                             if ($result)
  82                             {
  83                                 // determine redirector page
  84                                 $newLoc = $cfg['PmaAbsoluteUri'] . 'sql.php?' . PMA_generate_common_url ('','', '&') . (isset($bsDB) ? '&db=' . urlencode($bsDB) : '') . (isset($bsTable) ? '&table=' . urlencode($bsTable) : '') . (isset($token) ? '&token=' . urlencode($token) : '') . (isset($goto) ? '&goto=' . urlencode($goto) : '') . '&reload=1&purge=1';
  85
  86                                 // redirect to specified page
  87                                 ?>
  88                                 <script>
  89                                     window.location = "<?php echo $newLoc ?>";
  90                                 </script>
  91                                 <?php
  92                             } // end if ($result)
  93                         } // end if ($data = PMA_DBI_fetch_assoc($result))
  94                     } // end if ($data = PMA_DBI_fetch_assoc($result))
  95                 } // end if (PMA_DBI_select_db($bsDB))
  96             } // end if ($PMA_Config->get('BLOBSTREAMING_PLUGINS_EXIST'))
  97         } // end if (!empty($PMA_Config))
  98     } // end if ($bsDB && $bsTable && $bsReference && $bsNewMIMEType)
  99
 100 ?>