2 /*=====================================================================*\
3 || ###################################################################
5 || # Copyright (c)2004-2008 Blue Static
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 2 of the License.
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
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 \*=====================================================================*/
22 define('STOP_MARK', 4);
23 define('ACTIVE_SITE', 'upgrade3.php');
25 require_once('./global.php');
29 // ###################################################################
31 if ($input->in
['mark'] == 0)
34 <h1
>Welcome to Bugdar
</h1
>
36 <p
>This upgrade will take from Bugdar
1.1.0 Beta
1 to Bugdar
1.1.0 Beta
2.</p
>
38 <p
>The following steps will make changes to your database schema so that you can run Bugdar
1.1.0 Beta
2.</p
>
40 <p
>To begin the process
, please click the button below
.</p
>
44 // ###################################################################
46 if ($input->in
['mark'] == 1)
49 <h1
>Language System Updates
</h1
>
51 <p
>In Bugdar
1.1.0 Beta
2, the language system was changed to
use Gettext
. These schema changes reflect that change
.</p
>
54 $db->query("DROP TABLE " . TABLE_PREFIX
. "localization");
56 echo "Dropping the strings cache table<br />\n";
58 $db->query("ALTER TABLE " . TABLE_PREFIX
. "language DROP filename");
60 echo "Dropping language.filename<br />\n";
62 $db->query("ALTER TABLE " . TABLE_PREFIX
. "language CHANGE languagecode langcode VARCHAR(5) NOT NULL");
64 echo "Adding language.langcode for the Gettext language code<br />\n";
66 $db->query("ALTER TABLE " . TABLE_PREFIX
. "language DROP debug");
68 echo "Dropping language.debug as language debug mode no longer exists<br />\n";
70 $db->query("UPDATE " . TABLE_PREFIX
. "language SET langcode = 'en_US' WHERE languageid = 1");
72 echo "Setting the correct langcode for English (US)<br />\n";
75 // ###################################################################
77 if ($input->in
['mark'] == 2)
80 <h1
>English US Changes
</h1
>
82 <p
>These changes bring the schema into
English (US
) compliance
.</p
>
85 $db->query("ALTER TABLE " . TABLE_PREFIX
. "favourite RENAME " . TABLE_PREFIX
. "favorite");
87 echo "Renaming table 'favourite' to 'favorite'<br />\n";
89 $db->query("ALTER TABLE " . TABLE_PREFIX
. "user CHANGE showcolours showcolors BOOL NULL");
91 echo "Renaming user.showcolours to user.showcolors<br />\n";
94 // ###################################################################
96 if ($input->in
['mark'] == 3)
99 <h1
>Adding
New Permission Mask
</h1
>
101 <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
>
104 $db->query("UPDATE " . TABLE_PREFIX
. "usergroup SET permissions = permissions + 33554432 WHERE usergroupid IN (2, 5, 6)");
106 echo "Increased permission levels<br />\n";
109 // ###################################################################
111 if ($input->in
['mark'] == 4)
114 <h1
>Version Number Change
</h1
>
116 <p
>This step finishes the upgrade by inreasing your version number
.</p
>
120 $db->query("UPDATE " . TABLE_PREFIX
. "setting SET value = '1.1.0 Beta 2' WHERE varname = 'trackerversion'");
131 // ###################################################################