[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.6.6
  13   */
  14  
  15  
  16  $upgrade_detail = array(
  17      "revert_all_templates" => 0,
  18      "revert_all_themes" => 0,
  19      "revert_all_settings" => 0
  20  );
  21  
  22  @set_time_limit(0);
  23  
  24  function upgrade23_dbchanges()
  25  {
  26      global $db, $output;
  27  
  28      $output->print_header("Updating Database");
  29      echo "<p>Performing necessary upgrade queries...</p>";
  30  
  31      if($db->field_exists('canusecustomtools', 'moderators'))
  32      {
  33          $db->drop_column('moderators', 'canusecustomtools');
  34      }
  35  
  36      if($db->field_exists('cansendemailoverride', 'usergroups'))
  37      {
  38          $db->drop_column('usergroups', 'cansendemailoverride');
  39      }
  40  
  41      switch($db->type)
  42      {
  43          case "pgsql":
  44          case "sqlite":
  45              $db->add_column('moderators', 'canusecustomtools', "int NOT NULL default '0'");
  46              $db->add_column('usergroups', 'cansendemailoverride', "int NOT NULL default '0'");
  47              break;
  48          default:
  49              $db->add_column('moderators', 'canusecustomtools', "int(1) NOT NULL default '0'");
  50              $db->add_column('usergroups', 'cansendemailoverride', "int(1) NOT NULL default '0'");
  51              break;
  52      }
  53  
  54      $db->update_query('moderators', array('canusecustomtools' => 1), "canmanagethreads = '1'");
  55  
  56      $output->print_contents("<p>Click next to continue with the upgrade process.</p>");
  57      $output->print_footer("23_done");
  58  }