[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * MyBB 1.8
   4   * Copyright 2014 MyBB Group, All Rights Reserved
   5   *
   6   * Website: http://www.mybb.com
   7   * License: http://www.mybb.com/about/license
   8   *
   9   */
  10  
  11  /**
  12   * Upgrade Script: 1.8.8
  13   */
  14  
  15  $upgrade_detail = array(
  16      "revert_all_templates" => 0,
  17      "revert_all_themes" => 0,
  18      "revert_all_settings" => 0
  19  );
  20  
  21  function upgrade37_dbchanges()
  22  {
  23      global $db, $output;
  24  
  25      $output->print_header("Updating Database");
  26      echo "<p>Performing necessary upgrade queries...</p>";
  27      flush();
  28  
  29      if($db->field_exists('canviewdeletionnotice', 'usergroups'))
  30      {
  31          $db->drop_column("usergroups", "canviewdeletionnotice");
  32      }
  33  
  34      if($db->field_exists('canviewdeletionnotice', 'forumpermissions'))
  35      {
  36          $db->drop_column("forumpermissions", "canviewdeletionnotice");
  37      }
  38  
  39      switch($db->type)
  40      {
  41          case "pgsql":
  42              $db->add_column("forumpermissions", "canviewdeletionnotice", "smallint NOT NULL default '0' AFTER caneditattachments");
  43              $db->add_column("usergroups", "canviewdeletionnotice", "smallint NOT NULL default '0' AFTER caneditattachments");
  44              break;
  45          default:
  46              $db->add_column("forumpermissions", "canviewdeletionnotice", "tinyint(1) NOT NULL default '0' AFTER caneditattachments");
  47              $db->add_column("usergroups", "canviewdeletionnotice", "tinyint(1) NOT NULL default '0' AFTER caneditattachments");
  48              break;
  49      }
  50  
  51      $output->print_contents("<p>Click next to continue with the upgrade process.</p>");
  52      $output->print_footer("37_done");
  53  }