Vergleich install/resources/upgrade2.php - 1.2.0 - 1.2.4

  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: upgrade2.php 1930 2006-07-12 02:00:11Z chris $

 * $Id: upgrade2.php 2199 2006-09-05 00:37:41Z Tikitiki $

 */

/**

 */

/**

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

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

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

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

 
	
$db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."badwords");

	$db->query("CREATE TABLE ".TABLE_PREFIX."badwords (
bid smallint(6) NOT NULL auto_increment,
badword varchar(100) NOT NULL,

	$db->query("CREATE TABLE ".TABLE_PREFIX."badwords (
bid smallint(6) NOT NULL auto_increment,
badword varchar(100) NOT NULL,

Zeile 33Zeile 35
	  PRIMARY KEY(bid)
);");


	  PRIMARY KEY(bid)
);");


	$db->query("ALTER TABLE ".TABLE_PREFIX."attachtypes ADD icon varchar(100) NOT NULL;");




	if(!$db->field_exists("icon", TABLE_PREFIX."attachtypes"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."attachtypes ADD icon varchar(100) NOT NULL;");
}

	$db->query("DELETE FROM ".TABLE_PREFIX."attachtypes;");

$db->query("INSERT INTO ".TABLE_PREFIX."attachtypes (atid, name, mimetype, extension, maxsize, icon) VALUES (1, 'Zip File', 'application/zip', 'zip', 1024, 'images/attachtypes/zip.gif');");

	$db->query("DELETE FROM ".TABLE_PREFIX."attachtypes;");

$db->query("INSERT INTO ".TABLE_PREFIX."attachtypes (atid, name, mimetype, extension, maxsize, icon) VALUES (1, 'Zip File', 'application/zip', 'zip', 1024, 'images/attachtypes/zip.gif');");

Zeile 52Zeile 57
	$db->query("INSERT INTO ".TABLE_PREFIX."attachtypes (atid, name, mimetype, extension, maxsize, icon) VALUES (15, '', 'application/pdf', 'pdf', 2048, 'images/attachtypes/pdf.gif');");
$db->query("INSERT INTO ".TABLE_PREFIX."attachtypes (atid, name, mimetype, extension, maxsize, icon) VALUES (16, '', 'image/bmp', 'bmp', 500, 'images/attachtypes/image.gif');");


	$db->query("INSERT INTO ".TABLE_PREFIX."attachtypes (atid, name, mimetype, extension, maxsize, icon) VALUES (15, '', 'application/pdf', 'pdf', 2048, 'images/attachtypes/pdf.gif');");
$db->query("INSERT INTO ".TABLE_PREFIX."attachtypes (atid, name, mimetype, extension, maxsize, icon) VALUES (16, '', 'image/bmp', 'bmp', 500, 'images/attachtypes/image.gif');");


	$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD outerwidth varchar(15) NOT NULL;");
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD outercolor varchar(15) NOT NULL;");







	if(!$db->field_exists("outerwidth", TABLE_PREFIX."themes"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD outerwidth varchar(15) NOT NULL;");
}
if(!$db->field_exists("icon", TABLE_PREFIX."themes"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD outercolor varchar(15) NOT NULL;");
}

	$db->query("ALTER TABLE ".TABLE_PREFIX."themes CHANGE body bodybgcolor varchar(15) NOT NULL;");

	$db->query("ALTER TABLE ".TABLE_PREFIX."themes CHANGE body bodybgcolor varchar(15) NOT NULL;");

	$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD bodybgimage varchar(100) NOT NULL default '' AFTER bodybgcolor;");
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD bodybgimageattributes varchar(100) NOT NULL default '' AFTER bodybgimage;");









	
if(!$db->field_exists("bodybgimage", TABLE_PREFIX."themes"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD bodybgimage varchar(100) NOT NULL default '' AFTER bodybgcolor;");
}
if(!$db->field_exists("bodybgimageattributes", TABLE_PREFIX."themes"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."themes ADD bodybgimageattributes varchar(100) NOT NULL default '' AFTER bodybgimage;");
}


	$db->query("UPDATE ".TABLE_PREFIX."themes SET outerwidth='0', bodybgcolor='#e3e3e3', bodybgimage='images/Light/logo_bg.png', bodybgimageattributes='repeat-x'");

	$db->query("UPDATE ".TABLE_PREFIX."themes SET outerwidth='0', bodybgcolor='#e3e3e3', bodybgimage='images/Light/logo_bg.png', bodybgimageattributes='repeat-x'");

 
	
$db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."regimages;");

	$db->query("CREATE TABLE ".TABLE_PREFIX."regimages (
imagehash varchar(32) NOT NULL,
imagestring varchar(8) NOT NULL,

	$db->query("CREATE TABLE ".TABLE_PREFIX."regimages (
imagehash varchar(32) NOT NULL,
imagestring varchar(8) NOT NULL,

Zeile 67Zeile 87

$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET cpstyle=''");



$db->query("UPDATE ".TABLE_PREFIX."adminoptions SET cpstyle=''");


	$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD language varchar(50) NOT NULL;");
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD timeonline bigint(30) NOT NULL default '0';");
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD showcodebuttons int(1) NOT NULL default '1';");










	if(!$db->field_exists("language", TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD language varchar(50) NOT NULL;");
}
if(!$db->field_exists("timeonline", TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD timeonline bigint(30) NOT NULL default '0';");
}
if(!$db->field_exists("showcodebuttons", TABLE_PREFIX."users"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."users ADD showcodebuttons int(1) NOT NULL default '1';");
}

	$db->query("UPDATE ".TABLE_PREFIX."users SET language='english', showcodebuttons=1");


	$db->query("UPDATE ".TABLE_PREFIX."users SET language='english', showcodebuttons=1");


	$db->query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation ADD oldgroup bigint(30) NOT NULL;");
$db->query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation ADD misc varchar(255) NOT NULL;");







	if(!$db->field_exists("oldgroup", TABLE_PREFIX."awaitingactivation"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation ADD oldgroup bigint(30) NOT NULL;");
}
if(!$db->field_exists("misc", TABLE_PREFIX."awaitingactivation"))
{
$db->query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation ADD misc varchar(255) NOT NULL;");
}

	$db->query("DELETE FROM ".TABLE_PREFIX."awaitingactivation WHERE type='e'");


	$db->query("DELETE FROM ".TABLE_PREFIX."awaitingactivation WHERE type='e'");


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

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

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

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

Zeile 89Zeile 124
	  PRIMARY KEY  (sid)
);");


	  PRIMARY KEY  (sid)
);");


 
	$db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."reportedposts;");

	$db->query("CREATE TABLE ".TABLE_PREFIX."reportedposts (
rid smallint(6) NOT NULL auto_increment,
pid smallint(6) NOT NULL,

	$db->query("CREATE TABLE ".TABLE_PREFIX."reportedposts (
rid smallint(6) NOT NULL auto_increment,
pid smallint(6) NOT NULL,

Zeile 101Zeile 137
	  PRIMARY KEY (rid)
);");


	  PRIMARY KEY (rid)
);");


 
	$db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."threadsread;");

	$db->query("CREATE TABLE ".TABLE_PREFIX."threadsread (
tid smallint(6) NOT NULL,
uid smallint(6) NOT NULL,

	$db->query("CREATE TABLE ".TABLE_PREFIX."threadsread (
tid smallint(6) NOT NULL,
uid smallint(6) NOT NULL,