upgrade.php

<?php 

// This script should be deleted after is has been run. 

// This script removes changecount from the fields in the database replacing it with old_changecount
// This script also adds a tiddler to each workspace which sets it to use the simpleTheme

// ensures that the request is being made by the server and not through the proxy.php file

include_once("includes/header.php");


if(@mysql_num_rows(mysql_query("SELECT * FROM instance_history where version='1.7'")) > 0)
{
	echo "Your database has already been ugraded to ccTiddly 1.7";
	exit;
}

echo "<h1>Upgrade.php</h1>";
$form = "<form method='post'><input name='adminPassword' /><input type='submit' value='upgrade'/></form>";

if($tiddlyCfg['adminPassword']==""){
	echo "<b>If you are seeing this message unexpectedly please contact your system administrator. </b><hr />An upgrade password is required in the <b>includes/config.php</b> file. Please set the variable at line 13 of <b>includes/config.php</b> and then refresh this page.";
	exit;
}elseif(!$_POST['adminPassword']){
	echo "<b>If you are seeing this message unexpectedly please contact your system administrator. </b><hr /><b>Please ensure that you have a full database backup in place before upgrading.</b><br /></br />Please enter your admin password to confirm that you wish to upgrade from ccTiddly 1.6 to 1.7.</p> Please note that upgrading may take afew minutes if you have a large database.".$form;
	exit;
}elseif($_POST['adminPassword']!=$tiddlyCfg['adminPassword']){
	echo "incorrect password entered.".$form;
	exit;
}



$fail = 0;
$s = 'UPDATE tiddler SET body=(REPLACE (body, "\\\n","\\n"));';
if(!mysql_query($s)) {$fail++;}
if(!mysql_query("UPDATE tiddler SET body=(REPLACE (body,'\\\s','\\\'));")) {$fail++;}
if(!mysql_query("UPDATE tiddler SET body=(REPLACE (body,'&amp;','&'));")) {$fail++;}
if(!mysql_query("UPDATE tiddler SET body=(REPLACE (body,'&lt;','<'));")) {$fail++;}
if(!mysql_query("UPDATE tiddler SET body=(REPLACE (body,'&gt;','>'));")) {$fail++;}
if(!mysql_query("UPDATE tiddler SET body=(REPLACE (body, '&quot;','\"'));")) {$fail++;}


if($fail > 0){
	echo "something went wrong. Please refresh the page to rerun this script, if you continue to have difficulties please contact the ccTiddly google groups : 
	http://groups.google.com/group/ccTiddly";
	exit;
}

$q = "SELECT * FROM ".$tiddlyCfg['table']['workspace'];
$result = mysql_query($q);

while ($row = db_fetch_assoc($result)){ 
	if ($row['name']!=""){
		$SQL_CHECK = "SELECT * FROM tiddler where workspace_name='".$row['name']."' and title='UpgradeConfig17'";
		$res = mysql_query($SQL_CHECK);
		if (mysql_num_rows($res) > 0){
			echo "Tiddler already exists in the workspace ".$row['name'];
		}else{
			$SQL = "insert into tiddler (title, modifier, creator, modified, created, body, workspace_name, tags, revision) values ('UpgradeConfig17', 'ccTiddly', 'ccTiddly', '200809000000', '200809000000',  'config.options.txtTheme = \"simpleTheme\"', '".$row['name']."', 'systemConfig', 1)";
			$rs = mysql_query($SQL);
			if(!rs || mysql_error()){
				echo "FAILED TO EXECUTE : ".$SQL;
			//	echo mysql_error();	
			}else{
				echo "Update tiddler created for workspace ".$row['name'].".";
			}		
		}		
		
	 
		echo "<hr />";
	} 	
}

$SQL2 = "UPDATE ".$tiddlyCfg['table']['main']." SET fields=(REPLACE (fields,'changecount=','old_change_count='))";
mysql_query($SQL2);

if($fail == 0) {
	$SQL = "CREATE TABLE `instance_history` (
		`id` VARCHAR( 20 ) NOT NULL ,
		`date` VARCHAR( 20 ) NOT NULL ,
		`version` VARCHAR( 50 ) NOT NULL ,
		`description` VARCHAR( 500 ) NOT NULL ,
		PRIMARY KEY ( `id`))";
	mysql_query($SQL);

 	$SQL = "INSERT INTO `instance_history` (`id` ,`date` ,`version` ,`description`) VALUES ('', '".mktime()."', '1.7', '1.7 upgrade');";	
	mysql_query($SQL);
	
	echo "<h1>Your database has been upgraded.</h1> Please return to your homepage";
}

?>