Vergleich install/resources/upgrade1.php - 1.2.0 - 1.2.2

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
*

 * Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
*

 * $Id: upgrade1.php 1930 2006-07-12 02:00:11Z chris $

 * $Id: upgrade1.php 2204 2006-09-07 23:57:07Z Tikitiki $

 */

/**

 */

/**

Zeile 26Zeile 26
	$output->print_header("Database Changes since Release Candidate 2");

$contents .= "<p>Making necessary database modifications...";

	$output->print_header("Database Changes since Release Candidate 2");

$contents .= "<p>Making necessary database modifications...";

	$db->query("ALTER TABLE users ADD regip varchar(50) NOT NULL;");






	
if(!$db->field_exists('regip', "users"))
{
$db->query("ALTER TABLE users ADD regip varchar(50) NOT NULL;");
}


	$db->query("ALTER TABLE banned CHANGE lifted lifted varchar(40) NOT NULL;");

	$db->query("ALTER TABLE banned CHANGE lifted lifted varchar(40) NOT NULL;");

	
$db->query("ALTER TABLE attachments ADD posthash varchar(50) NOT NULL AFTER pid;");
$db->query("ALTER TABLE attachments ADD thumbnail blob NOT NULL");
$db->query("ALTER TABLE attachments ADD thumbnailsm char(3) NOT NULL;");













		
if(!$db->field_exists('posthash', "attachments"))
{
$db->query("ALTER TABLE attachments ADD posthash varchar(50) NOT NULL AFTER pid;");
}

if(!$db->field_exists('thumbnail', "attachments"))
{
$db->query("ALTER TABLE attachments ADD thumbnail blob NOT NULL");
}

if(!$db->field_exists('thumbnailsm', "attachments"))
{
$db->query("ALTER TABLE attachments ADD thumbnailsm char(3) NOT NULL;");
}


	$db->query("DELETE FROM attachtypes");
$db->query("INSERT INTO attachtypes VALUES(NULL,'Compressed Archive','','zip gz tar rar ace cab','1024');");
$db->query("INSERT INTO attachtypes VALUES(NULL,'JPEG Image','','jpg jpe jpeg','500');");

	$db->query("DELETE FROM attachtypes");
$db->query("INSERT INTO attachtypes VALUES(NULL,'Compressed Archive','','zip gz tar rar ace cab','1024');");
$db->query("INSERT INTO attachtypes VALUES(NULL,'JPEG Image','','jpg jpe jpeg','500');");

Zeile 45Zeile 60
	$db->query("INSERT INTO attachtypes VALUES(NULL,'Microsoft Word Document','','doc rtf','1024');");
$db->query("INSERT INTO attachtypes VALUES(NULL,'Executable','','exe com bat','1024');");


	$db->query("INSERT INTO attachtypes VALUES(NULL,'Microsoft Word Document','','doc rtf','1024');");
$db->query("INSERT INTO attachtypes VALUES(NULL,'Executable','','exe com bat','1024');");


	$db->query("ALTER TABLE themes DROP small;");
$db->query("ALTER TABLE themes DROP smallend;");
$db->query("ALTER TABLE themes DROP font;");
$db->query("ALTER TABLE themes DROP fontend;");
$db->query("ALTER TABLE themes DROP large;");
$db->query("ALTER TABLE themes DROP largeend;");
$db->query("ALTER TABLE themes ADD smallfont varchar(150) NOT NULL;");
$db->query("ALTER TABLE themes ADD smallfontsize varchar(20) NOT NULL;");
$db->query("ALTER TABLE themes ADD normalfont varchar(150) NOT NULL;");
$db->query("ALTER TABLE themes ADD normalfontsize varchar(20) NOT NULL;");
$db->query("ALTER TABLE themes ADD largefont varchar(150) NOT NULL;");
$db->query("ALTER TABLE themes ADD largefontsize varchar(20) NOT NULL;");
$db->query("ALTER TABLE themes ADD menubgcolor varchar(15) NOT NULL;");
$db->query("ALTER TABLE themes ADD menubgimage varchar(100) NOT NULL;");
$db->query("ALTER TABLE themes ADD menucolor varchar(15) NOT NULL;");
$db->query("ALTER TABLE themes ADD menuhoverbgcolor varchar(15) NOT NULL;");
$db->query("ALTER TABLE themes ADD menuhoverbgimage varchar(100) NOT NULL;");
$db->query("ALTER TABLE themes ADD menuhovercolor varchar(15) NOT NULL;");
$db->query("ALTER TABLE themes ADD panelbgcolor varchar(15) NOT NULL;");
$db->query("ALTER TABLE themes ADD panelbgimage varchar(100) NOT NULL;");
$db->query("ALTER TABLE themes ADD linkhover varchar(15) NOT NULL AFTER link;");






































































	if($db->field_exists('small', "themes"))
{
$db->query("ALTER TABLE themes DROP small;");
}
if($db->field_exists('smallend', "themes"))
{
$db->query("ALTER TABLE themes DROP smallend;");
}
if($db->field_exists('font', "themes"))
{
$db->query("ALTER TABLE themes DROP font;");
}
if($db->field_exists('frontend', "themes"))
{
$db->query("ALTER TABLE themes DROP fontend;");
}
if($db->field_exists('large', "themes"))
{
$db->query("ALTER TABLE themes DROP large;");
}
if($db->field_exists('largeend', "themes"))
{
$db->query("ALTER TABLE themes DROP largeend;");
}

if(!$db->field_exists('smallfont', "themes"))
{
$db->query("ALTER TABLE themes ADD smallfont varchar(150) NOT NULL;");
}
if(!$db->field_exists('smallfontsize', "themes"))
{
$db->query("ALTER TABLE themes ADD smallfontsize varchar(20) NOT NULL;");
}
if(!$db->field_exists('normalfont', "themes"))
{
$db->query("ALTER TABLE themes ADD normalfont varchar(150) NOT NULL;");
}
if(!$db->field_exists('normalfontsize', "themes"))
{
$db->query("ALTER TABLE themes ADD normalfontsize varchar(20) NOT NULL;");
}
if(!$db->field_exists('largefont', "themes"))
{
$db->query("ALTER TABLE themes ADD largefont varchar(150) NOT NULL;");
}
if(!$db->field_exists('largefontsize', "themes"))
{
$db->query("ALTER TABLE themes ADD largefontsize varchar(20) NOT NULL;");
}
if(!$db->field_exists('menubgcolor', "themes"))
{
$db->query("ALTER TABLE themes ADD menubgcolor varchar(15) NOT NULL;");
}
if(!$db->field_exists('menubgimage', "themes"))
{
$db->query("ALTER TABLE themes ADD menubgimage varchar(100) NOT NULL;");
}
if(!$db->field_exists('menucolor', "themes"))
{
$db->query("ALTER TABLE themes ADD menucolor varchar(15) NOT NULL;");
}
if(!$db->field_exists('menuhoverbgcolor', "themes"))
{
$db->query("ALTER TABLE themes ADD menuhoverbgcolor varchar(15) NOT NULL;");
}
if(!$db->field_exists('menuhoverbgimage', "themes"))
{
$db->query("ALTER TABLE themes ADD menuhoverbgimage varchar(100) NOT NULL;");
}
if(!$db->field_exists('menuhovercolor', "themes"))
{
$db->query("ALTER TABLE themes ADD menuhovercolor varchar(15) NOT NULL;");
}
if(!$db->field_exists('panelbgcolor', "themes"))
{
$db->query("ALTER TABLE themes ADD panelbgcolor varchar(15) NOT NULL;");
}
if(!$db->field_exists('panelbgimage', "themes"))
{
$db->query("ALTER TABLE themes ADD panelbgimage varchar(100) NOT NULL;");
}
if(!$db->field_exists('linkhover', "themes"))
{
$db->query("ALTER TABLE themes ADD linkhover varchar(15) NOT NULL AFTER link;");
}
if(!$db->field_exists('extracss', "themes"))
{
$db->query("ALTER TABLE themes ADD extracss varchar(10) NOT NULL AFTER linkhover;");
}


	$db->query("UPDATE themes SET linkhover='#000000'");

$db->query("UPDATE themes SET smallfont='Verdana', smallfontsize='11px', normalfont='Verdana', normalfontsize='13px', largefont='Verdana', largefontsize='20px';");

$contents .= "done</p>";


	$db->query("UPDATE themes SET linkhover='#000000'");

$db->query("UPDATE themes SET smallfont='Verdana', smallfontsize='11px', normalfont='Verdana', normalfontsize='13px', largefont='Verdana', largefontsize='20px';");

$contents .= "done</p>";


	$db->query("DROP TABLE settinggroups;");

	$db->query("DROP TABLE IF EXISTS settinggroups;");

	$db->query("CREATE TABLE settinggroups (
gid smallint(6) NOT NULL auto_increment,
name varchar(220) NOT NULL default '',

	$db->query("CREATE TABLE settinggroups (
gid smallint(6) NOT NULL auto_increment,
name varchar(220) NOT NULL default '',

Zeile 82Zeile 166
	  PRIMARY KEY  (gid)
);");


	  PRIMARY KEY  (gid)
);");


	$db->query("DROP TABLE settings;");

	$db->query("DROP TABLE IF EXISTS settings;");

	$db->query("CREATE TABLE settings (
sid smallint(6) NOT NULL auto_increment,
name varchar(120) NOT NULL default '',

	$db->query("CREATE TABLE settings (
sid smallint(6) NOT NULL auto_increment,
name varchar(120) NOT NULL default '',