Blue Static

<?php
/*=====================================================================*\
|| ###################################################################
|| # Bugdar
|| # Copyright ©2002-2007 Blue Static
|| #
|| # This program is free software; you can redistribute it and/or modify
|| # it under the terms of the GNU General Public License as published by
|| # the Free Software Foundation; version 2 of the License.
|| #
|| # This program is distributed in the hope that it will be useful, but
|| # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
|| # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
|| # more details.
|| #
|| # You should have received a copy of the GNU General Public License along
|| # with this program; if not, write to the Free Software Foundation, Inc.,
|| # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
|| ###################################################################
\*=====================================================================*/

define('STOP_MARK', 4);
define('ACTIVE_SITE', 'upgrade3.php');

require_once('./global.php');

page_start();

// ###################################################################

if ($bugsys->in['mark'] == 0)
{
?>
<h1>Welcome to Bugdar</h1>

<p>This upgrade will take from Bugdar 1.1.0 Beta 1 to Bugdar 1.1.0 Beta 2.</p>

<p>The following steps will make changes to your database schema so that you can run Bugdar 1.1.0 Beta 2.</p>

<p>To begin the process, please click the button below.</p>
<?php
}

// ###################################################################

if ($bugsys->in['mark'] == 1)
{
?>
	<h1>Language System Updates</h1>

	<p>In Bugdar 1.1.0 Beta 2, the language system was changed to use Gettext. These schema changes reflect that change.</p>
<?php

	$db->query("DROP TABLE " . TABLE_PREFIX . "localization");

	echo "Dropping the strings cache table<br />\n";

	$db->query("ALTER TABLE " . TABLE_PREFIX . "language DROP filename");

	echo "Dropping language.filename<br />\n";

	$db->query("ALTER TABLE " . TABLE_PREFIX . "language CHANGE languagecode langcode VARCHAR(5) NOT NULL");

	echo "Adding language.langcode for the Gettext language code<br />\n";

	$db->query("ALTER TABLE " . TABLE_PREFIX . "language DROP debug");

	echo "Dropping language.debug as language debug mode no longer exists<br />\n";

	$db->query("UPDATE " . TABLE_PREFIX . "language SET langcode = 'en_US' WHERE languageid = 1");

	echo "Setting the correct langcode for English (US)<br />\n";
}

// ###################################################################

if ($bugsys->in['mark'] == 2)
{
?>
	<h1>English US Changes</h1>

	<p>These changes bring the schema into English (US) compliance.</p>
<?php

	$db->query("ALTER TABLE " . TABLE_PREFIX . "favourite RENAME " . TABLE_PREFIX . "favorite");

	echo "Renaming table 'favourite' to 'favorite'<br />\n";

	$db->query("ALTER TABLE " . TABLE_PREFIX . "user CHANGE showcolours showcolors BOOL NULL");

	echo "Renaming user.showcolours to user.showcolors<br />\n";
}

// ###################################################################

if ($bugsys->in['mark'] == 3)
{
?>
	<h1>Adding New Permission Mask</h1>

	<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>
<?php

	$db->query("UPDATE " . TABLE_PREFIX . "usergroup SET permissions = permissions + 33554432 WHERE usergroupid IN (2, 5, 6)");

	echo "Increased permission levels<br />\n";
}

// ###################################################################

if ($bugsys->in['mark'] == 4)
{
?>
<h1>Version Number Change</h1>

<p>This step finishes the upgrade by inreasing your version number.</p>

<?php

	$db->query("UPDATE " . TABLE_PREFIX . "setting SET value = '1.1.0 Beta 2' WHERE varname = 'trackerversion'");

	build_settings();

?>

... done.

<?php
}

// ###################################################################

page_end();

/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>