[phpBT-dev] CVS: phpbt upgrade.php,NONE,1.1

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv4107

Added Files:
	upgrade.php 
Log Message:
Files for upgrading from previous version

--- NEW FILE: upgrade.php ---
<?php

// upgrade.php -- Upgrade from the previous version

define ('NO_AUTH', 1);
include 'include.php';

function upgrade() {
	global $q;
	
	$upgraded = $q->grab_field("select count(*) from ". TBL_CONFIGURATION.
		" where varname = 'STRICT_UPDATING'");
	if (!$upgraded) {
		// Move the support tables to use the table prefix
		// (if the table prefix is non-empty)
		if (strlen(TBL_PREFIX)) {
			$q->Halt_On_Error = 'no'; // We're going to ignore errors 
			$db_sess_table = ereg_replace(TBL_PREFIX, '', TBL_ACTIVE_SESSIONS);
			$db_seq_table = ereg_replace(TBL_PREFIX, '', TBL_DB_SEQUENCE);
			$q->query("alter table $db_sess_table rename to ". TBL_ACTIVE_SESSIONS);
			$q->query("alter table $db_seq_table rename to ". TBL_DB_SEQUENCE);
			$q->Halt_On_Error = 'yes'; // Stop ignoring errors
		} 

		// New configuration option
		$q->query('insert into '. TBL_CONFIGURATION.
			" (varname, varvalue, description, vartype) values ('STRICT_UPDATING', '0', 
			'Only the bug reporter, bug owner, managers, and admins can change a bug', 
			'bool')");
	}
	include 'templates/default/upgrade-finished.html';
}

if ($doit) {
	upgrade();
} else {
	include 'templates/default/upgrade.html';
}

?>