[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  /*
   4  $HeadURL: https://textpattern.googlecode.com/svn/releases/4.0.8/source/textpattern/update/_to_4.0.8.php $
   5  $LastChangedRevision: 3057 $
   6  */
   7  
   8      if (!defined('TXP_UPDATE'))
   9      {
  10          exit("Nothing here. You can't access this file directly.");
  11      }
  12  
  13      $has_idx = 0;
  14      $rs = getRows('show index from `'.PFX.'txp_plugin`');
  15      foreach ($rs as $row) {
  16          if ($row['Key_name'] == 'status_type_idx')
  17              $has_idx = 1;
  18      }
  19  
  20      if (!$has_idx) {
  21          safe_query('alter ignore table `'.PFX.'txp_plugin` add index status_type_idx(`status`, `type`)');
  22      }
  23  
  24      # preserve old tag behaviour during upgrades
  25      safe_update('txp_page', "user_html = REPLACE(user_html, '<txp:if_section>', '<txp:if_section name=\"\">')", '1=1');
  26      safe_update('txp_page', "user_html = REPLACE(user_html, '<txp:if_category name=\"\">', '<txp:if_category>')", '1=1');
  27      safe_update('txp_form', "Form = REPLACE(Form, '<txp:if_section>', '<txp:if_section name=\"\">')", '1=1');
  28      safe_update('txp_form', "Form = REPLACE(Form, '<txp:if_category name=\"\">', '<txp:if_category>')", '1=1');
  29  
  30  ?>