| Zeile 6 | Zeile 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 26 | Zeile 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 45 | Zeile 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 82 | Zeile 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 '',
|