install/upgrade3.php

   1 <?php
   2 /*=====================================================================*\
   3 || ###################################################################
   4 || # Bugdar [#]version[#]
   5 || # Copyright ©2002-[#]year[#] Blue Static
   6 || #
   7 || # This program is free software; you can redistribute it and/or modify
   8 || # it under the terms of the GNU General Public License as published by
   9 || # the Free Software Foundation; version [#]gpl[#] of the License.
  10 || #
  11 || # This program is distributed in the hope that it will be useful, but
  12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
  13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
  14 || # more details.
  15 || #
  16 || # You should have received a copy of the GNU General Public License along
  17 || # with this program; if not, write to the Free Software Foundation, Inc.,
  18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
  19 || ###################################################################
  20 \*=====================================================================*/
  21
  22 define('STOP_MARK', 4);
  23 define('ACTIVE_SITE', 'upgrade3.php');
  24
  25 require_once('./global.php');
  26
  27 page_start();
  28
  29 // ###################################################################
  30
  31 if ($bugsys->in['mark'] == 0)
  32 {
  33 ?>
  34 <h1>Welcome to Bugdar</h1>
  35
  36 <p>This upgrade will take from Bugdar 1.1.0 Beta 1 to Bugdar 1.1.0 Beta 2.</p>
  37
  38 <p>The following steps will make changes to your database schema so that you can run Bugdar 1.1.0 Beta 2.</p>
  39
  40 <p>To begin the process, please click the button below.</p>
  41 <?php
  42 }
  43
  44 // ###################################################################
  45
  46 if ($bugsys->in['mark'] == 1)
  47 {
  48 ?>
  49         <h1>Language System Updates</h1>
  50
  51         <p>In Bugdar 1.1.0 Beta 2, the language system was changed to use Gettext. These schema changes reflect that change.</p>
  52 <?php
  53
  54         $db->query("DROP TABLE " . TABLE_PREFIX . "localization");
  55
  56         echo "Dropping the strings cache table<br />\n";
  57
  58         $db->query("ALTER TABLE " . TABLE_PREFIX . "language DROP filename");
  59
  60         echo "Dropping language.filename<br />\n";
  61
  62         $db->query("ALTER TABLE " . TABLE_PREFIX . "language CHANGE languagecode langcode VARCHAR(5) NOT NULL");
  63
  64         echo "Adding language.langcode for the Gettext language code<br />\n";
  65
  66         $db->query("ALTER TABLE " . TABLE_PREFIX . "language DROP debug");
  67
  68         echo "Dropping language.debug as language debug mode no longer exists<br />\n";
  69 }
  70
  71 // ###################################################################
  72
  73 if ($bugsys->in['mark'] == 2)
  74 {
  75 ?>
  76         <h1>English US Changes</h1>
  77
  78         <p>These changes bring the schema into English (US) compliance.</p>
  79 <?php
  80
  81         $db->query("ALTER TABLE " . TABLE_PREFIX . "favourite RENAME " . TABLE_PREFIX . "favorite");
  82
  83         echo "Renaming table 'favourite' to 'favorite'<br />\n";
  84
  85         $db->query("ALTER TABLE " . TABLE_PREFIX . "user CHANGE showcolours showcolors BOOL NULL");
  86
  87         echo "Renaming user.showcolours to user.showcolors<br />\n";
  88 }
  89
  90 // ###################################################################
  91
  92 if ($bugsys->in['mark'] == 3)
  93 {
  94 ?>
  95         <h1>Adding New Permission Mask</h1>
  96
  97         <p>Bugdar 1.1.0 Beta 2 introduces a new permission called "canviewownhidden" which enables users to view hidden bugs that they reported. This is being turned on for registered users, developers, and administrators.</p>
  98 <?php
  99
 100         $db->query("UPDATE " . TABLE_PREFIX . "usergroup SET permissions = permissions + 33554432 WHERE usergroupid IN (2, 5, 6)");
 101
 102         echo "Increased permission levels<br />\n";
 103 }
 104
 105 // ###################################################################
 106
 107 if ($bugsys->in['mark'] == 4)
 108 {
 109 ?>
 110 <h1>Version Number Change</h1>
 111
 112 <p>This step finishes the upgrade by inreasing your version number.</p>
 113
 114 <?php
 115
 116         require_once('./includes/settings.php');
 117
 118         $db->query("UPDATE " . TABLE_PREFIX . "setting SET value = '1.1.0 Beta 2' WHERE varname = 'trackerversion'");
 119
 120         build_settings();
 121
 122 ?>
 123
 124 ... done.
 125
 126 <?php
 127 }
 128
 129 // ###################################################################
 130
 131 page_end();
 132
 133 /*=====================================================================*\
 134 || ###################################################################
 135 || # $HeadURL$
 136 || # $Id$
 137 || ###################################################################
 138 \*=====================================================================*/
 139 ?>