[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.4
  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 upgrade21_dbchanges()
  22  {
  23      global $cache, $db, $output, $mybb;
  24  
  25      $output->print_header("Updating Database");
  26  
  27      echo "<p>Performing necessary upgrade queries...</p>";
  28  
  29      $db->delete_query("settings", "name = 'standardheaders'");
  30  
  31      if($db->field_exists('showinbirthdaylist', 'usergroups'))
  32      {
  33          $db->drop_column("usergroups", "showinbirthdaylist");
  34      }
  35  
  36      if($db->field_exists('canoverridepm', 'usergroups'))
  37      {
  38          $db->drop_column("usergroups", "canoverridepm");
  39      }
  40  
  41      if($db->field_exists('canusesig', 'usergroups'))
  42      {
  43          $db->drop_column("usergroups", "canusesig");
  44      }
  45  
  46      if($db->field_exists('canusesigxposts', 'usergroups'))
  47      {
  48          $db->drop_column("usergroups", "canusesigxposts");
  49      }
  50  
  51      if($db->field_exists('signofollow', 'usergroups'))
  52      {
  53          $db->drop_column("usergroups", "signofollow");
  54      }
  55  
  56      if($db->field_exists('postnum', 'profilefields'))
  57      {
  58          $db->drop_column("profilefields", "postnum");
  59      }
  60  
  61      switch($db->type)
  62      {
  63          case "pgsql":
  64          case "sqlite":
  65              $db->add_column("profilefields", "postnum", "bigint NOT NULL default '0'");
  66              $db->add_column("usergroups", "showinbirthdaylist", "int NOT NULL default '0'");
  67              $db->add_column("usergroups", "canoverridepm", "int NOT NULL default '0'");
  68              $db->add_column("usergroups", "canusesig", "int NOT NULL default '0'");
  69              $db->add_column("usergroups", "canusesigxposts", "bigint NOT NULL default '0'");
  70              $db->add_column("usergroups", "signofollow", "int NOT NULL default '0'");
  71              break;
  72          default:
  73              $db->add_column("profilefields", "postnum", "bigint(30) NOT NULL default '0'");
  74              $db->add_column("usergroups", "showinbirthdaylist", "int(1) NOT NULL default '0'");
  75              $db->add_column("usergroups", "canoverridepm", "int(1) NOT NULL default '0'");
  76              $db->add_column("usergroups", "canusesig", "int(1) NOT NULL default '0'");
  77              $db->add_column("usergroups", "canusesigxposts", "bigint(30) NOT NULL default '0'");
  78              $db->add_column("usergroups", "signofollow", "int(1) NOT NULL default '0'");
  79              break;
  80      }
  81  
  82      // Update all usergroups to show in the birthday list
  83      $db->update_query("usergroups", array("showinbirthdaylist" => 1));
  84  
  85      // Update our nice usergroups to use a signature
  86      $groups = $cache->read("usergroups");
  87  
  88      foreach($groups as $group)
  89      {
  90          $disallowed_array = array(1, 5, 7);
  91          if(in_array($group['gid'], $disallowed_array) || $group['isbannedgroup'] == 1)
  92          {
  93              continue;
  94          }
  95  
  96          $db->update_query("usergroups", array("canusesig" => 1), "gid = '{$group['gid']}'");
  97      }
  98  
  99      $output->print_contents("<p>Click next to continue with the upgrade process.</p>");
 100      $output->print_footer("21_done");
 101  }
 102