Vergleich install/resources/upgrade5.php - 1.6.1 - 1.6.8

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 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 5683 2011-11-29 15:02:41Z Tomm $

 */

/**

 */

/**

Zeile 198Zeile 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 206Zeile 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 248Zeile 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 280Zeile 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 291Zeile 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 359Zeile 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 376Zeile 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 388Zeile 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"))
{

Zeile 612Zeile 612
			$db->create_fulltext_index("posts", "message");
}
}

			$db->create_fulltext_index("posts", "message");
}
}


// Register a shutdown function which actually tests if this functionality is working
add_shutdown('test_shutdown_function');

 

$contents .= "Click next to continue with the upgrade process.</p>";
$output->print_contents($contents);
$output->print_footer("5_done");


$contents .= "Click next to continue with the upgrade process.</p>";
$output->print_contents($contents);
$output->print_footer("5_done");

}



function test_shutdown_function()
{
global $db;
$db->update_query("settings", array('value' => 'yes'), "name='useshutdownfunc'");
write_settings();

 
}
?>

}
?>