Vergleich install/resources/upgrade2.php - 1.8.1 - 1.8.22

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 35Zeile 35
	  PRIMARY KEY(bid)
);");


	  PRIMARY KEY(bid)
);");


	if($db->field_exists("icon", TABLE_PREFIX."attachtypes"))

	if($db->field_exists("icon", "attachtypes"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."attachtypes DROP icon;");
}

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."attachtypes DROP icon;");
}

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


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


	if($db->field_exists("outerwidth", TABLE_PREFIX."themes"))

	if($db->field_exists("outerwidth", "themes"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP outerwidth;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes ADD outerwidth varchar(15) NOT NULL;");


	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP outerwidth;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes ADD outerwidth varchar(15) NOT NULL;");


	if($db->field_exists("icon", TABLE_PREFIX."themes"))

	if($db->field_exists("icon", "themes"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP icon;");
}

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP icon;");
}

Zeile 73Zeile 73

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



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


	if($db->field_exists("bodybgimage", TABLE_PREFIX."themes"))

	if($db->field_exists("bodybgimage", "themes"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP bodybgimage;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes ADD bodybgimage varchar(100) NOT NULL default '' AFTER bodybgcolor;");


	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP bodybgimage;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes ADD bodybgimage varchar(100) NOT NULL default '' AFTER bodybgcolor;");


	if($db->field_exists("bodybgimageattributes", TABLE_PREFIX."themes"))

	if($db->field_exists("bodybgimageattributes", "themes"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP bodydbimageattributes;");
}

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP bodydbimageattributes;");
}

Zeile 97Zeile 97

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



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


	if($db->field_exists("language", TABLE_PREFIX."users"))

	if($db->field_exists("language", "users"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP language;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD language varchar(50) NOT NULL;");


	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP language;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD language varchar(50) NOT NULL;");


	if($db->field_exists("timeonline", TABLE_PREFIX."users"))

	if($db->field_exists("timeonline", "users"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP timeonline;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD timeonline bigint(30) NOT NULL default '0';");


	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP timeonline;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD timeonline bigint(30) NOT NULL default '0';");


	if($db->field_exists("showcodebuttons", TABLE_PREFIX."users"))

	if($db->field_exists("showcodebuttons", "users"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."user DROP showcodebuttons;");
}

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."user DROP showcodebuttons;");
}

Zeile 117Zeile 117

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



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


	if($db->field_exists("oldgroup", TABLE_PREFIX."awaitingactivation"))

	if($db->field_exists("oldgroup", "awaitingactivation"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation DROP oldgroup;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation ADD oldgroup bigint(30) NOT NULL;");


	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation DROP oldgroup;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation ADD oldgroup bigint(30) NOT NULL;");


	if($db->field_exists("misc", TABLE_PREFIX."awaitingactivation"))

	if($db->field_exists("misc", "awaitingactivation"))

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation DROP misc;");
}

	{
$db->write_query("ALTER TABLE ".TABLE_PREFIX."awaitingactivation DROP misc;");
}

Zeile 182Zeile 182
	$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'bbname', 'Board Name', 'The name of your message boards. We recommend that it is not over 75 characters.', 'text', 'MyBB Forums', 1, 1);");
$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'bburl', 'Board URL', 'The url to your forums.<br />Include the http://. Do NOT include a trailing slash.', 'text', '', 2, 1);");
$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'homename', 'Homepage Name', 'The name of your homepage. This will appear in the footer with a link to it.', 'text', 'MyBB', 3, 1);");

	$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'bbname', 'Board Name', 'The name of your message boards. We recommend that it is not over 75 characters.', 'text', 'MyBB Forums', 1, 1);");
$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'bburl', 'Board URL', 'The url to your forums.<br />Include the http://. Do NOT include a trailing slash.', 'text', '', 2, 1);");
$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'homename', 'Homepage Name', 'The name of your homepage. This will appear in the footer with a link to it.', 'text', 'MyBB', 3, 1);");

	$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'homeurl', 'Homepage URL', 'The full URL of your homepage. This will be linked to in the footer along with its name.', 'text', 'http://www.mybb.com', 4, 1);");

	$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'homeurl', 'Homepage URL', 'The full URL of your homepage. This will be linked to in the footer along with its name.', 'text', 'https://mybb.com', 4, 1);");

	$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'dateformat', 'Date Format', 'The format of the dates used on the forum. This format uses the PHP date() function. We recommend not changing this unless you know what you\'re doing.', 'text', 'm-d-Y', 1, 3);");
$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'adminemail', 'Admin Email', 'The administrator\'s email address. This will be used for outgoing emails sent via the forums.', 'text', '', 5, 1);");
$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'timeformat', 'Time Format', 'The format of the times used on the forum. This format uses PHP\'s date() function. We recommend not changing this unless you know what you\'re doing.', 'text', 'h:i A', 2, 3);");

	$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'dateformat', 'Date Format', 'The format of the dates used on the forum. This format uses the PHP date() function. We recommend not changing this unless you know what you\'re doing.', 'text', 'm-d-Y', 1, 3);");
$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'adminemail', 'Admin Email', 'The administrator\'s email address. This will be used for outgoing emails sent via the forums.', 'text', '', 5, 1);");
$db->write_query("INSERT INTO ".TABLE_PREFIX."settings (sid, name, title, description, optionscode, value, disporder, gid) VALUES (NULL, 'timeformat', 'Time Format', 'The format of the times used on the forum. This format uses PHP\'s date() function. We recommend not changing this unless you know what you\'re doing.', 'text', 'h:i A', 2, 3);");