From 9b64a5d50cc491d4a8d256104db865463119c7bc Mon Sep 17 00:00:00 2001
From: Bart van Bragt <bartvb@users.sourceforge.net>
Date: Sat, 8 Sep 2001 18:24:34 +0000
Subject: Altered layout of phpbb_config table

git-svn-id: file:///svn/phpbb/trunk@1010 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/develop/convert_conf.php | 96 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 96 insertions(+)
 create mode 100644 phpBB/develop/convert_conf.php

(limited to 'phpBB/develop')

diff --git a/phpBB/develop/convert_conf.php b/phpBB/develop/convert_conf.php
new file mode 100644
index 0000000000..3e7fb0d606
--- /dev/null
+++ b/phpBB/develop/convert_conf.php
@@ -0,0 +1,96 @@
+<?
+
+$phpbb_root_path = "../";
+
+include($phpbb_root_path . 'extension.inc');
+include($phpbb_root_path . 'config.'.$phpEx);
+include($phpbb_root_path . 'includes/constants.'.$phpEx);
+include($phpbb_root_path . 'includes/db.'.$phpEx);
+
+$sql = "SELECT *
+	FROM " . CONFIG_TABLE;
+if(!$result = $db->sql_query($sql))
+{
+	message_die(CRITICAL_ERROR, "Could not query config information", "", __LINE__, __FILE__, $sql);
+}
+else
+{
+	$board_config = $db->sql_fetchrow($result);
+}
+
+$newconfigtable = $table_prefix . "newconfig";
+
+$sql = "SELECT config_name, config_value FROM ". CONFIG_TABLE;
+if( $result = $db->sql_query($sql) )
+{
+	die("Don't run this script twice!<br>\n");
+}
+
+$sql = "	CREATE TABLE $newconfigtable (
+				config_name varchar(255) NOT NULL,
+				config_value varchar(255) NOT NULL,
+			   PRIMARY KEY (config_name)
+			)";
+print "Creating temporary table: $newconfigtable<p>\n";
+if( !$result = $db->sql_query($sql) )
+{
+	print("Couldn't create new config table<br>\n");
+}
+
+$error = 0;
+while (list($name, $value) = each($board_config))
+{
+	if(is_int($name))
+	{
+		// Skip numeric array elements (we only want the associative array)
+		continue;
+	}
+
+	// Rename sys_template
+	if ($name == 'sys_template')
+	{
+		$name = 'board_template';
+	}
+	// Rename system_timezone
+	if ($name == 'system_timezone')
+	{
+		$name = 'board_timezone';
+	}
+	print "$name = $value<br>\n";
+	$value = addslashes($value);
+	$sql = "INSERT INTO $newconfigtable (config_name, config_value) VALUES ('$name', '$value')";
+	if( !$result = $db->sql_query($sql) )
+	{
+		print("Couldn't insert '$name' into new config table");
+		$error = 1;
+	}
+}
+
+if ($error != 1)
+{
+	print "Dropping old table<p>\n";
+	$sql = "DROP TABLE ". CONFIG_TABLE;
+	if( !$result = $db->sql_query($sql) )
+	{
+		die("Couldn't drop old table");
+	}
+	print "Renaming $newconfigtable to ".CONFIG_TABLE."<p>\n";
+	$sql = "ALTER TABLE $newconfigtable RENAME ".CONFIG_TABLE;
+	if( !$result = $db->sql_query($sql) )
+	{
+		die("Couldn't rename new config table");
+	}
+	print "Renaming ".SESSIONS_TABLE." to ".$table_prefix."sessions<br>\n";
+	$sql = "ALTER TABLE ".SESSIONS_TABLE." RENAME ".$table_prefix."sessions";
+	if( !$result = $db->sql_query($sql) )
+	{
+		die("Couldn't rename session table");
+	}
+	
+}
+
+$db->sql_close();
+
+	echo "<BR><BR>COMPLETE<BR>";
+
+?>
-- 
cgit v1.2.1