| Zeile 6 | Zeile 6 |
|---|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* $Id: upgrade5.php 5016 2010-06-12 00:24:02Z RyanGordon $
| * $Id: upgrade5.php 5440 2011-04-15 10:18:35Z Tomm $
|
*/
/**
| */
/**
|
| Zeile 198 | Zeile 198 |
|---|
replacement text NOT NULL,
active char(3) NOT NULL default '',
PRIMARY KEY(cid)
|
replacement text NOT NULL,
active char(3) NOT NULL default '',
PRIMARY KEY(cid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->drop_table("templategroups");
$db->write_query("CREATE TABLE ".TABLE_PREFIX."templategroups (
|
$db->drop_table("templategroups");
$db->write_query("CREATE TABLE ".TABLE_PREFIX."templategroups (
|
| Zeile 206 | Zeile 206 |
|---|
prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default '',
PRIMARY KEY (gid)
|
prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default '',
PRIMARY KEY (gid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("INSERT INTO ".TABLE_PREFIX."templategroups (gid,prefix,title) VALUES ('1','calendar','<lang:group_calendar>');");
$db->write_query("INSERT INTO ".TABLE_PREFIX."templategroups (gid,prefix,title) VALUES ('2','editpost','<lang:group_editpost>');");
|
$db->write_query("INSERT INTO ".TABLE_PREFIX."templategroups (gid,prefix,title) VALUES ('1','calendar','<lang:group_calendar>');");
$db->write_query("INSERT INTO ".TABLE_PREFIX."templategroups (gid,prefix,title) VALUES ('2','editpost','<lang:group_editpost>');");
|
| Zeile 248 | Zeile 248 |
|---|
querycache text NOT NULL,
keywords text NOT NULL,
PRIMARY KEY (sid)
|
querycache text NOT NULL,
keywords text NOT NULL,
PRIMARY KEY (sid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("UPDATE ".TABLE_PREFIX."settings SET name='bannedemails' WHERE name='emailban' LIMIT 1");
$db->write_query("UPDATE ".TABLE_PREFIX."settings SET name='bannedips' WHERE name='ipban' LIMIT 1");
|
$db->write_query("UPDATE ".TABLE_PREFIX."settings SET name='bannedemails' WHERE name='emailban' LIMIT 1");
$db->write_query("UPDATE ".TABLE_PREFIX."settings SET name='bannedips' WHERE name='ipban' LIMIT 1");
|
| Zeile 280 | Zeile 280 |
|---|
dateline bigint(30) NOT NULL default '0',
comments text NOT NULL,
PRIMARY KEY(rid)
|
dateline bigint(30) NOT NULL default '0',
comments text NOT NULL,
PRIMARY KEY(rid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->drop_table("mailqueue");
$db->write_query("CREATE TABLE ".TABLE_PREFIX."mailqueue (
|
$db->drop_table("mailqueue");
$db->write_query("CREATE TABLE ".TABLE_PREFIX."mailqueue (
|
| Zeile 291 | Zeile 291 |
|---|
message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY(mid)
|
message text NOT NULL,
headers text NOT NULL,
PRIMARY KEY(mid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->update_query("users", array('reputation' => 0));
|
$db->update_query("users", array('reputation' => 0));
|
| Zeile 359 | Zeile 359 |
|---|
imagehash varchar(32) NOT NULL default '',
imagestring varchar(8) NOT NULL default '',
dateline bigint(30) NOT NULL default '0'
|
imagehash varchar(32) NOT NULL default '',
imagestring varchar(8) NOT NULL default '',
dateline bigint(30) NOT NULL default '0'
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
if($db->field_exists('data', "moderatorlog"))
{
|
if($db->field_exists('data', "moderatorlog"))
{
|
| Zeile 376 | Zeile 376 |
|---|
ip varchar(40) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0'
|
ip varchar(40) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0'
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->drop_table("modtools");
$db->write_query("CREATE TABLE ".TABLE_PREFIX."modtools (
|
$db->drop_table("modtools");
$db->write_query("CREATE TABLE ".TABLE_PREFIX."modtools (
|
| Zeile 388 | Zeile 388 |
|---|
postoptions text NOT NULL,
threadoptions text NOT NULL,
PRIMARY KEY (tid)
|
postoptions text NOT NULL,
threadoptions text NOT NULL,
PRIMARY KEY (tid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
if($db->field_exists('disporder', "usergroups"))
{
|
if($db->field_exists('disporder', "usergroups"))
{
|