Source: /textpattern/update/_to_4.3.0.php - 44 lines - 1477 bytes - Text - Print

   1  <?php
   2  
   3  /*
   4   * Textpattern Content Management System
   5   * http://textpattern.com
   6   *
   7   * Copyright (C) 2016 The Textpattern Development Team
   8   *
   9   * This file is part of Textpattern.
  10   *
  11   * Textpattern is free software; you can redistribute it and/or
  12   * modify it under the terms of the GNU General Public License
  13   * as published by the Free Software Foundation, version 2.
  14   *
  15   * Textpattern is distributed in the hope that it will be useful,
  16   * but WITHOUT ANY WARRANTY; without even the implied warranty of
  17   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  18   * GNU General Public License for more details.
  19   *
  20   * You should have received a copy of the GNU General Public License
  21   * along with Textpattern. If not, see <http://www.gnu.org/licenses/>.
  22   */
  23  
  24  if (!defined('TXP_UPDATE')) {
  25      exit("Nothing here. You can't access this file directly.");
  26  }
  27  
  28  // Raw CSS is now the only option.
  29  safe_delete('txp_prefs', "event = 'css' AND name = 'edit_raw_css_by_default'");
  30  
  31  $rs = getRows("SELECT name, css FROM `".PFX."txp_css`");
  32  foreach ($rs as $row) {
  33      if (preg_match('%^[a-zA-Z0-9/+]*={0,2}$%', $row['css'])) {
  34          // Data is still base64 encoded.
  35          safe_update('txp_css', "css = '".doSlash(base64_decode($row['css']))."'", "name = '".doSlash($row['name'])."'");
  36      }
  37  }
  38  
  39  // Add column for file title.
  40  $cols = getThings("DESCRIBE `".PFX."txp_file`");
  41  
  42  if (!in_array('title', $cols)) {
  43      safe_alter('txp_file', "ADD title VARCHAR(255) NULL AFTER filename");
  44  }