[论坛社区]vBulletin v3.5.2_vbulletin35.rar

<?php /*======================================================================*\ || #################################################################### || || # vBulletin 3.5.2 - Licence Number $sm_lickey || # ---------------------------------------------------------------- # || || # Copyright �2000-2005 Jelsoft Enterprises Ltd. All Rights Reserved. || || # This file may not be redistributed in whole or significant part. # || || # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # || || # http://www.vbulletin.com | http://www.vbulletin.com/license.html # || || #################################################################### || \*======================================================================*/ error_reporting(E_ALL & ~E_NOTICE); define('THIS_SCRIPT', 'upgrade_300b3.php'); define('VERSION', '3.0.0 Beta 3'); // ############################################################################# // array of titles for each step - alter this if you change the contents of a step // just temporary for my testing purposes - KD define('VB3UPGRADE', 1); // require the code that makes it all work... require_once('./upgradecore.php'); if (TABLE_PREFIX != '') { ?> <blockquote> <p style="font-size:10pt; color: red;"><b><?php echo $upgrade_phrases['upgrade_300b3.php']['tableprefix_not_empty']; ?></b></p> <p><?php echo $upgrade_phrases['upgrade_300b3.php']['tableprefix_not_empty_fix']; ?></p> </blockquote> <?php print_upgrade_footer(); exit; } // we need all the new table data require_once(DIR . '/install/mysql-schema.php'); // ############################################################################# // introduction if ($vbulletin->GPC['step'] === 'welcome') { echo "<blockquote>\n"; echo sprintf($upgrade_phrases['upgrade_300b3.php']['welcome'], htmlspecialchars_uni($vbulletin->config['Database']['dbname'])); echo "</blockquote>\n"; if (get_cfg_var('safe_mode') == 1) { // Use ini_set here instead? echo "<p><i>{$upgrade_phrases['upgrade_300b3.php']['safe_mode_warning']}</i></p>"; } // turn the board off $db->query_write("UPDATE setting SET value = 0 WHERE varname = 'bbactive'"); $db->query_write("UPDATE template SET template = CONCAT(template,'\n\$bbactive = 0;\n') WHERE title = 'options'"); // create the upgradelog table - don't worry if this table has already been created $db->hide_errors(); $db->query_write(" CREATE TABLE upgradelog( upgradelogid int unsigned NOT NULL AUTO_INCREMENT, script varchar(50) NOT NULL default '', steptitle varchar(250) NOT NULL default '', step smallint unsigned NOT NULL default 0, startat int unsigned NOT NULL default 0, perpage smallint unsigned NOT NULL default 0, dateline int unsigned NOT NULL default 0, PRIMARY KEY (upgradelogid) ) "); $db->show_errors(); } // ############################################################################# // Create New vBulletin 3 Tables if ($vbulletin->GPC['step'] == 1) { $db->hide_errors(); $db->query_read("SELECT COUNT(*) AS count FROM calendar"); $db->show_errors(); $errno = $db->errno; if (!$errno) { $errno = 0; } if ($errno == 0) { echo "<blockquote>{$upgrade_phrases['upgrade_300b3.php']['upgrade_already_run']}</blockquote>"; print_upgrade_footer(); } $year = date('Y'); $query[] = " CREATE TABLE " . TABLE_PREFIX . "calendar ( calendarid int unsigned NOT NULL auto_increment, title varchar(255) NOT NULL DEFAULT '', description varchar(100) NOT NULL DEFAULT '', displayorder smallint NOT NULL DEFAULT '0', neweventemail varchar(255) NOT NULL DEFAULT '', moderatenew smallint NOT NULL DEFAULT '0', startofweek smallint NOT NULL DEFAULT '0', options int unsigned NOT NULL DEFAULT '0', cutoff smallint unsigned NOT NULL DEFAULT '0', eventcount smallint unsigned NOT NULL DEFAULT '0', birthdaycount smallint unsigned NOT NULL DEFAULT '0', startyear smallint unsigned NOT NULL DEFAULT '2000', endyear smallint unsigned NOT NULL DEFAULT '2006', PRIMARY KEY (calendarid), KEY displayorder (displayorder) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "calendar"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "calendarmoderator ( calendarmoderatorid int unsigned NOT NULL auto_increment, userid int unsigned NOT NULL DEFAULT '0', calendarid int unsigned NOT NULL DEFAULT '0', neweventemail smallint NOT NULL DEFAULT '0', permissions int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (calendarmoderatorid), KEY userid (userid, calendarid) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "calendarmoderator"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "calendarpermission ( calendarpermissionid int unsigned NOT NULL auto_increment, calendarid int unsigned NOT NULL DEFAULT '0', usergroupid smallint unsigned NOT NULL DEFAULT '0', calendarpermissions int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (calendarpermissionid), KEY calendarid (calendarid), KEY usergroupid (usergroupid) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "calendarpermission"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "calendarcustomfield ( calendarcustomfieldid int unsigned NOT NULL auto_increment, calendarid int unsigned NOT NULL DEFAULT '0', title varchar(255) NOT NULL DEFAULT '', options mediumtext, allowentry smallint NOT NULL DEFAULT '1', required smallint NOT NULL DEFAULT '0', length smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (calendarcustomfieldid), KEY calendarid (calendarid) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "calendarcustomfield"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "holiday ( holidayid int unsigned NOT NULL auto_increment, varname varchar(100) NOT NULL DEFAULT '', recurring smallint unsigned NOT NULL DEFAULT '0', recuroption char(6) NOT NULL DEFAULT '', allowsmilies smallint NOT NULL DEFAULT '1', PRIMARY KEY (holidayid), KEY varname (varname) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "holiday"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "subscribeevent ( userid int unsigned NOT NULL DEFAULT '0', eventid int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (userid,eventid), KEY eventid (eventid) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "subscribeevent"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "ranks ( rankid smallint unsigned NOT NULL auto_increment, minposts smallint unsigned NOT NULL DEFAULT '0', ranklevel smallint unsigned NOT NULL DEFAULT '0', rankimg varchar(255) NOT NULL DEFAULT '', usergroupid smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (rankid), KEY grouprank (usergroupid, minposts) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "ranks"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "usertextfield ( userid int unsigned NOT NULL DEFAULT '0', subfolders mediumtext, pmfolders mediumtext, buddylist mediumtext, ignorelist mediumtext, signature mediumtext, searchprefs mediumtext, PRIMARY KEY (userid) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "usertextfield"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "imagecategory ( imagecategoryid smallint unsigned NOT NULL auto_increment, title varchar(255) NOT NULL DEFAULT '', imagetype smallint unsigned NOT NULL DEFAULT '0', displayorder smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (imagecategoryid) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "imagecategory"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "imagecategorypermission ( imagecategoryid smallint unsigned NOT NULL DEFAULT '0', usergroupid smallint unsigned NOT NULL DEFAULT '0', KEY imagecategoryid (imagecategoryid, usergroupid) ) "; $explain[] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "imagecategorypermission"); $query[] = " CREATE TABLE " . TABLE_PREFIX . "post_parsed ( postid int unsigned NOT NULL DEFAULT '0', dateline int unsigned NOT NULL DEFAULT '0', hasimages smallint