| 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: upgrade12.php 5016 2010-06-12 00:24:02Z RyanGordon $
| * $Id: upgrade12.php 5440 2011-04-15 10:18:35Z Tomm $
|
*/
/**
| */
/**
|
| Zeile 443 | Zeile 443 |
|---|
conditions text NOT NULL,
perpage smallint(4) NOT NULL default '50',
PRIMARY KEY(mid)
|
conditions text NOT NULL,
perpage smallint(4) NOT NULL default '50',
PRIMARY KEY(mid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."maillogs (
mid int unsigned NOT NULL auto_increment,
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."maillogs (
mid int unsigned NOT NULL auto_increment,
|
| Zeile 457 | Zeile 457 |
|---|
tid int unsigned NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY(mid)
|
tid int unsigned NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY(mid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."mailerrors(
eid int unsigned NOT NULL auto_increment,
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."mailerrors(
eid int unsigned NOT NULL auto_increment,
|
| Zeile 470 | Zeile 470 |
|---|
smtperror varchar(200) NOT NULL default '',
smtpcode int(5) NOT NULL default '0',
PRIMARY KEY(eid)
|
smtperror varchar(200) NOT NULL default '',
smtpcode int(5) NOT NULL default '0',
PRIMARY KEY(eid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."promotions (
pid int unsigned NOT NULL auto_increment,
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."promotions (
pid int unsigned NOT NULL auto_increment,
|
| Zeile 489 | Zeile 489 |
|---|
newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)
|
newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."promotionlogs(
plid int unsigned NOT NULL auto_increment,
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."promotionlogs(
plid int unsigned NOT NULL auto_increment,
|
| Zeile 500 | Zeile 500 |
|---|
dateline bigint(30) NOT NULL default '0',
type varchar(9) NOT NULL default 'primary',
PRIMARY KEY(plid)
|
dateline bigint(30) NOT NULL default '0',
type varchar(9) NOT NULL default 'primary',
PRIMARY KEY(plid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
if($db->field_exists('maxemails', "usergroups"))
{
|
if($db->field_exists('maxemails', "usergroups"))
{
|
| Zeile 544 | Zeile 544 |
|---|
logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0',
PRIMARY KEY(tid)
|
logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0',
PRIMARY KEY(tid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."tasklog (
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."tasklog (
|
| Zeile 553 | Zeile 553 |
|---|
dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY(lid)
|
dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY(lid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
include_once MYBB_ROOT."inc/functions_task.php";
|
include_once MYBB_ROOT."inc/functions_task.php";
|
| Zeile 630 | Zeile 630 |
|---|
percentage int(3) NOT NULL default '0',
action text NOT NULL,
PRIMARY KEY(lid)
|
percentage int(3) NOT NULL default '0',
action text NOT NULL,
PRIMARY KEY(lid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."warningtypes (
tid int unsigned NOT NULL auto_increment,
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."warningtypes (
tid int unsigned NOT NULL auto_increment,
|
| Zeile 638 | Zeile 638 |
|---|
points int unsigned NOT NULL default '0',
expirationtime bigint(30) NOT NULL default '0',
PRIMARY KEY(tid)
|
points int unsigned NOT NULL default '0',
expirationtime bigint(30) NOT NULL default '0',
PRIMARY KEY(tid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."warnings (
wid int unsigned NOT NULL auto_increment,
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."warnings (
wid int unsigned NOT NULL auto_increment,
|
| Zeile 656 | Zeile 656 |
|---|
revokereason text NOT NULL,
notes text NOT NULL,
PRIMARY KEY(wid)
|
revokereason text NOT NULL,
notes text NOT NULL,
PRIMARY KEY(wid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
if($db->field_exists('warningpoints', "users"))
{
|
if($db->field_exists('warningpoints', "users"))
{
|
| Zeile 729 | Zeile 729 |
|---|
action varchar(50) NOT NULL default '',
data text NOT NULL,
KEY module (module, action)
|
action varchar(50) NOT NULL default '',
data text NOT NULL,
KEY module (module, action)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
if($db->field_exists('data', "adminsessions"))
{
|
if($db->field_exists('data', "adminsessions"))
{
|
| Zeile 795 | Zeile 795 |
|---|
lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (fid)
|
lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (fid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
// Now we convert all of the old bans in to the new system!
$ban_types = array('bannedips', 'bannedemails', 'bannedusernames');
|
// Now we convert all of the old bans in to the new system!
$ban_types = array('bannedips', 'bannedemails', 'bannedusernames');
|
| Zeile 874 | Zeile 874 |
|---|
useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)
|
useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."stats (
dateline bigint(30) NOT NULL default '0',
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."stats (
dateline bigint(30) NOT NULL default '0',
|
| Zeile 882 | Zeile 882 |
|---|
numthreads int unsigned NOT NULL default '0',
numposts int unsigned NOT NULL default '0',
PRIMARY KEY(dateline)
|
numthreads int unsigned NOT NULL default '0',
numposts int unsigned NOT NULL default '0',
PRIMARY KEY(dateline)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->insert_query("spiders", array('name' => 'GoogleBot', 'useragent' => 'google'));
$db->insert_query("spiders", array('name' => 'Lycos', 'useragent' => 'lycos'));
|
$db->insert_query("spiders", array('name' => 'GoogleBot', 'useragent' => 'google'));
$db->insert_query("spiders", array('name' => 'Lycos', 'useragent' => 'lycos'));
|
| Zeile 1092 | Zeile 1092 |
|---|
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 1165 | Zeile 1165 |
|---|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."threadviews (
tid int unsigned NOT NULL default '0'
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."threadviews (
tid int unsigned NOT NULL default '0'
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."calendars (
cid int unsigned NOT NULL auto_increment,
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."calendars (
cid int unsigned NOT NULL auto_increment,
|
| Zeile 1180 | Zeile 1180 |
|---|
allowimgcode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0',
PRIMARY KEY(cid)
|
allowimgcode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0',
PRIMARY KEY(cid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$calendar_array = array(
'name' => 'Default Calendar',
|
$calendar_array = array(
'name' => 'Default Calendar',
|
| Zeile 1203 | Zeile 1203 |
|---|
canaddevents int(1) NOT NULL default '0',
canbypasseventmod int(1) NOT NULL default '0',
canmoderateevents int(1) NOT NULL default '0'
|
canaddevents int(1) NOT NULL default '0',
canbypasseventmod int(1) NOT NULL default '0',
canmoderateevents int(1) NOT NULL default '0'
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."forumsread (
fid int unsigned NOT NULL default '0',
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."forumsread (
fid int unsigned NOT NULL default '0',
|
| Zeile 1211 | Zeile 1211 |
|---|
dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY fid (fid,uid)
|
dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY fid (fid,uid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
if($db->field_exists('dateuploaded', "attachments"))
{
|
if($db->field_exists('dateuploaded', "attachments"))
{
|
| Zeile 1232 | Zeile 1232 |
|---|
perpage int(4) NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)
|
perpage int(4) NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
$views = file_get_contents(INSTALL_ROOT.'resources/adminviews.xml');
$parser = new XMLParser($views);
|
$views = file_get_contents(INSTALL_ROOT.'resources/adminviews.xml');
$parser = new XMLParser($views);
|
| Zeile 1873 | Zeile 1873 |
|---|
cachefile varchar(100) NOT NULL default '',
lastmodified bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)
|
cachefile varchar(100) NOT NULL default '',
lastmodified bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)
|
) TYPE=MyISAM{$collation};");
| ) ENGINE=MyISAM{$collation};");
|
// Define our default stylesheets - MyBB 1.4 contains additional stylesheets that our converted themes will also need
$contents = @file_get_contents(INSTALL_ROOT.'resources/mybb_theme.xml');
|
// Define our default stylesheets - MyBB 1.4 contains additional stylesheets that our converted themes will also need
$contents = @file_get_contents(INSTALL_ROOT.'resources/mybb_theme.xml');
|