/* ATTENTION: You don't need to run or use this file! The upgrade.php script does everything for you! */ /******************************************************************************/ --- Adding new settings... /******************************************************************************/ ---# Adding login history... CREATE TABLE IF NOT EXISTS {$db_prefix}member_logins ( id_login int(10) NOT NULL auto_increment, id_member mediumint(8) NOT NULL, time int(10) NOT NULL, ip varchar(255) NOT NULL default '', ip2 varchar(255) NOT NULL default '', PRIMARY KEY id_login(id_login), KEY id_member (id_member), KEY time (time) ) ENGINE=MyISAM{$db_collation}; ---# ---# Copying the current package backup setting... ---{ if (!isset($modSettings['package_make_full_backups']) && isset($modSettings['package_make_backups'])) upgrade_query(" INSERT INTO {$db_prefix}settings (variable, value) VALUES ('package_make_full_backups', '" . $modSettings['package_make_backups'] . "')"); ---} ---# ---# Copying the current "allow users to disable word censor" setting... ---{ if (!isset($modSettings['allow_no_censored'])) { $request = upgrade_query(" SELECT value FROM {$db_prefix}themes WHERE variable='allow_no_censored' AND id_theme = 1 OR id_theme = '$modSettings[theme_default]' "); // Is it set for either "default" or the one they've set as default? while ($row = mysql_fetch_assoc($request)) { if ($row['value'] == 1) { upgrade_query(" INSERT INTO {$db_prefix}settings VALUES ('allow_no_censored', 1) "); // Don't do this twice... break; } } } ---} ---# /******************************************************************************/ --- Updating legacy attachments... /******************************************************************************/ ---# Converting legacy attachments. ---{ $request = upgrade_query(" SELECT MAX(id_attach) FROM {$db_prefix}attachments"); list ($step_progress['total']) = $smcFunc['db_fetch_row']($request); $smcFunc['db_free_result']($request); $_GET['a'] = isset($_GET['a']) ? (int) $_GET['a'] : 0; $step_progress['name'] = 'Converting legacy attachments'; $step_progress['current'] = $_GET['a']; // We may be using multiple attachment directories. if (!empty($modSettings['currentAttachmentUploadDir']) && !is_array($modSettings['attachmentUploadDir'])) $modSettings['attachmentUploadDir'] = unserialize($modSettings['attachmentUploadDir']); $is_done = false; while (!$is_done) { nextSubStep($substep); $request = upgrade_query(" SELECT id_attach, id_folder, filename, file_hash FROM {$db_prefix}attachments WHERE file_hash = '' LIMIT $_GET[a], 100"); // Finished? if ($smcFunc['db_num_rows']($request) == 0) $is_done = true; while ($row = $smcFunc['db_fetch_assoc']($request)) { // The current folder. $current_folder = !empty($modSettings['currentAttachmentUploadDir']) ? $modSettings['attachmentUploadDir'][$row['id_folder']] : $modSettings['attachmentUploadDir']; // The old location of the file. $old_location = getLegacyAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder']); // The new file name. $file_hash = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], true); // And we try to move it. rename($old_location, $current_folder . '/' . $row['id_attach'] . '_' . $file_hash); // Only update thif if it was successful. if (file_exists($current_folder . '/' . $row['id_attach'] . '_' . $file_hash) && !file_exists($old_location)) upgrade_query(" UPDATE {$db_prefix}attachments SET file_hash = '$file_hash' WHERE id_attach = $row[id_attach]"); } $smcFunc['db_free_result']($request); $_GET['a'] += 100; $step_progress['current'] = $_GET['a']; } unset($_GET['a']); ---} ---# /******************************************************************************/ --- Adding support for IPv6... /******************************************************************************/ ---# Adding new columns to ban items... ALTER TABLE {$db_prefix}ban_items ADD COLUMN ip_low5 smallint(255) unsigned NOT NULL DEFAULT '0', ADD COLUMN ip_high5 smallint(255) unsigned NOT NULL DEFAULT '0', ADD COLUMN ip_low6 smallint(255) unsigned NOT NULL DEFAULT '0', ADD COLUMN ip_high6 smallint(255) unsigned NOT NULL DEFAULT '0', ADD COLUMN ip_low7 smallint(255) unsigned NOT NULL DEFAULT '0', ADD COLUMN ip_high7 smallint(255) unsigned NOT NULL DEFAULT '0', ADD COLUMN ip_low8 smallint(255) unsigned NOT NULL DEFAULT '0', ADD COLUMN ip_high8 smallint(255) unsigned NOT NULL DEFAULT '0'; ---# ---# Changing existing columns to ban items... ALTER TABLE {$db_prefix}ban_items CHANGE ip_low1 ip_low1 smallint(255) unsigned NOT NULL DEFAULT '0', CHANGE ip_high1 ip_high1 smallint(255) unsigned NOT NULL DEFAULT '0', CHANGE ip_low2 ip_low2 smallint(255) unsigned NOT NULL DEFAULT '0', CHANGE ip_high2 ip_high2 smallint(255) unsigned NOT NULL DEFAULT '0', CHANGE ip_low3 ip_low3 smallint(255) unsigned NOT NULL DEFAULT '0', CHANGE ip_high3 ip_high3 smallint(255) unsigned NOT NULL DEFAULT '0', CHANGE ip_low4 ip_low4 smallint(255) unsigned NOT NULL DEFAULT '0', CHANGE ip_high4 ip_high4 smallint(255) unsigned NOT NULL DEFAULT '0'; ---# /******************************************************************************/ --- Adding support for tag in package manager /******************************************************************************/ ---# Adding new columns to log_packages .. ALTER TABLE {$db_prefix}log_packages ADD COLUMN credits varchar(255) NOT NULL DEFAULT ''; ---# /******************************************************************************/ --- Adding more space for session ids /******************************************************************************/ ---# Altering the session_id columns... ALTER TABLE {$db_prefix}log_online CHANGE `session` `session` varchar(64) NOT NULL DEFAULT ''; ALTER TABLE {$db_prefix}log_errors CHANGE `session` `session` char(64) NOT NULL default ' '; ALTER TABLE {$db_prefix}sessions CHANGE `session_id` `session_id` char(64) NOT NULL; ---# /******************************************************************************/ --- Adding support for MOVED topics enhancements /******************************************************************************/ ---# Adding new columns to topics .. ALTER TABLE {$db_prefix}topics ADD COLUMN redirect_expires int(10) unsigned NOT NULL default '0', ADD COLUMN id_redirect_topic mediumint(8) unsigned NOT NULL default '0'; ---# /******************************************************************************/ --- Adding new scheduled tasks /******************************************************************************/ ---# Adding new scheduled tasks INSERT INTO {$db_prefix}scheduled_tasks (next_time, time_offset, time_regularity, time_unit, disabled, task) VALUES (0, 120, 1, 'd', 0, 'remove_temp_attachments'); INSERT INTO {$db_prefix}scheduled_tasks (next_time, time_offset, time_regularity, time_unit, disabled, task) VALUES (0, 180, 1, 'd', 0, 'remove_topic_redirect'); INSERT INTO {$db_prefix}scheduled_tasks (next_time, time_offset, time_regularity, time_unit, disabled, task) VALUES (0, 240, 1, 'd', 0, 'remove_old_drafts'); ---# /******************************************************************************/ ---- Replacing MSN with Skype /******************************************************************************/ ---# Modifying the "msn" column... ALTER TABLE {$db_prefix}members CHANGE msn skype varchar(255) NOT NULL DEFAULT ''; ---# /******************************************************************************/ --- Adding support for deny boards access /******************************************************************************/ ---# Adding new columns to boards... ALTER TABLE {$db_prefix}boards ADD COLUMN deny_member_groups varchar(255) NOT NULL DEFAULT ''; ---# /******************************************************************************/ --- Adding support for topic unwatch /******************************************************************************/ ---# Adding new columns to boards... ALTER TABLE {$db_prefix}log_topics ADD COLUMN unwatched tinyint(3) NOT NULL DEFAULT '0'; UPDATE {$db_prefix}log_topics SET unwatched = 0; INSERT INTO {$db_prefix}settings (variable, value) VALUES ('enable_unwatch', 0); ---# ---# Fixing column name change... ALTER TABLE {$db_prefix}log_topics CHANGE COLUMN disregarded unwatched tinyint(3) NOT NULL DEFAULT '0'; ---# /******************************************************************************/ --- Fixing mail queue for long messages /******************************************************************************/ ---# Altering mil_queue table... ALTER TABLE {$db_prefix}mail_queue CHANGE body body mediumtext NOT NULL; ---# /******************************************************************************/ --- Name changes /******************************************************************************/ ---# Altering the membergroup stars to icons ALTER TABLE {$db_prefix}membergroups CHANGE `stars` `icons` varchar(255) NOT NULL DEFAULT ''; ---# ---# Renaming default theme... UPDATE {$db_prefix}themes SET value = 'SMF Default Theme - Curve2' WHERE value LIKE 'SMF Default Theme%'; ---# /******************************************************************************/ --- Cleaning up after old themes... /******************************************************************************/ ---# Checking for "core" and removing it if necessary... ---{ // Do they have "core" installed? if (file_exists($GLOBALS['boarddir'] . '/Themes/core')) { $core_dir = $GLOBALS['boarddir'] . '/Themes/core'; $theme_request = upgrade_query(" SELECT id_theme FROM {$db_prefix}themes WHERE variable = 'theme_dir' AND value ='$core_dir'"); // Don't do anything if this theme is already uninstalled if (smf_mysql_num_rows($theme_request) == 1) { $id_theme = mysql_result($theme_request, 0); mysql_free_result($theme_request); $known_themes = explode(', ', $modSettings['knownThemes']); // Remove this value... $known_themes = array_diff($known_themes, array($id_theme)); // Change back to a string... $known_themes = implode(', ', $known_themes); // Update the database upgrade_query(" REPLACE INTO {$db_prefix}settings (variable, value) VALUES ('knownThemes', '$known_themes')"); // Delete any info about this theme upgrade_query(" DELETE FROM {$db_prefix}themes WHERE id_theme = $id_theme"); // Set any members or boards using this theme to the default upgrade_query(" UPDATE {$db_prefix}members SET id_theme = 0 WHERE id_theme = $id_theme"); upgrade_query(" UPDATE {$db_prefix}boards SET id_theme = 0 WHERE id_theme = $id_theme"); if ($modSettings['theme_guests'] == $id_theme) { upgrade_query(" REPLACE INTO {$db_prefix}settings (variable, value) VALUES('theme_guests', 0)"); } } } ---} ---# /******************************************************************************/ --- Adding support for drafts /******************************************************************************/ ---# Creating draft table CREATE TABLE IF NOT EXISTS {$db_prefix}user_drafts ( id_draft int(10) unsigned NOT NULL auto_increment, id_topic mediumint(8) unsigned NOT NULL default '0', id_board smallint(5) unsigned NOT NULL default '0', id_reply int(10) unsigned NOT NULL default '0', type tinyint(4) NOT NULL default '0', poster_time int(10) unsigned NOT NULL default '0', id_member mediumint(8) unsigned NOT NULL default '0', subject varchar(255) NOT NULL default '', smileys_enabled tinyint(4) NOT NULL default '1', body mediumtext NOT NULL, icon varchar(16) NOT NULL default 'xx', locked tinyint(4) NOT NULL default '0', is_sticky tinyint(4) NOT NULL default '0', to_list varchar(255) NOT NULL default '', PRIMARY KEY id_draft(id_draft), UNIQUE id_member (id_member, id_draft, type) ) ENGINE=MyISAM{$db_collation}; ---# ---# Adding draft permissions... ---{ // We cannot do this twice if (@$modSettings['smfVersion'] < '2.1') { // Anyone who can currently post unapproved topics we assume can create drafts as well ... $request = upgrade_query(" SELECT id_group, id_board, add_deny, permission FROM {$db_prefix}board_permissions WHERE permission = 'post_unapproved_topics'"); $inserts = array(); while ($row = smf_mysql_fetch_assoc($request)) { $inserts[] = "($row[id_group], $row[id_board], 'post_draft', $row[add_deny])"; $inserts[] = "($row[id_group], $row[id_board], 'post_autosave_draft', $row[add_deny])"; } smf_mysql_free_result($request); if (!empty($inserts)) upgrade_query(" INSERT IGNORE INTO {$db_prefix}board_permissions (id_group, id_board, permission, add_deny) VALUES " . implode(',', $inserts)); // Next we find people who can send PMs, and assume they can save pm_drafts as well $request = upgrade_query(" SELECT id_group, add_deny, permission FROM {$db_prefix}permissions WHERE permission = 'pm_send'"); $inserts = array(); while ($row = smf_mysql_fetch_assoc($request)) { $inserts[] = "($row[id_group], 'pm_draft', $row[add_deny])"; $inserts[] = "($row[id_group], 'pm_autosave_draft', $row[add_deny])"; } smf_mysql_free_result($request); if (!empty($inserts)) upgrade_query(" INSERT IGNORE INTO {$db_prefix}permissions (id_group, permission, add_deny) VALUES " . implode(',', $inserts)); } ---} INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_autosave_enabled', '1'), ('drafts_show_saved_enabled', '1'), ('drafts_keep_days', '7'); INSERT INTO {$db_prefix}themes (id_theme, variable, value) VALUES ('1', 'drafts_autosave_enabled', '1'), ('1', 'drafts_show_saved_enabled', '1'); ---# /******************************************************************************/ --- Adding support for likes /******************************************************************************/ ---# Creating likes table. CREATE TABLE IF NOT EXISTS {$db_prefix}user_likes ( id_member mediumint(8) unsigned NOT NULL default '0', content_type char(6) default '', content_id int(10) unsigned NOT NULL default '0', like_time int(10) unsigned NOT NULL default '0', PRIMARY KEY (content_id, content_type, id_member), INDEX content (content_id, content_type), INDEX liker (id_member) ) ENGINE=MyISAM; ---# ---# Adding count to the messages table. ALTER TABLE {$db_prefix}messages ADD COLUMN likes smallint(5) unsigned NOT NULL DEFAULT '0'; ---# /******************************************************************************/ --- Adding support for group-based board moderation /******************************************************************************/ ---# Creating moderator_groups table CREATE TABLE IF NOT EXISTS {$db_prefix}moderator_groups ( id_board smallint(5) unsigned NOT NULL default '0', id_group smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (id_board, id_group) ) ENGINE=MyISAM{$db_collation}; ---# /******************************************************************************/ --- Cleaning up integration hooks /******************************************************************************/ ---# Deleting integration hooks DELETE FROM {$db_prefix}settings WHERE variable LIKE 'integrate_%'; ---# /******************************************************************************/ --- Cleaning up old settings /******************************************************************************/ ---# Showing contact details to guests should never happen. DELETE FROM {$db_prefix}settings WHERE variable IN ('enableStickyTopics', 'guest_hideContacts'); ---# /******************************************************************************/ --- Upgrading "verification questions" feature /******************************************************************************/ ---# Creating qanda table CREATE TABLE IF NOT EXISTS {$db_prefix}qanda ( id_question smallint(5) unsigned NOT NULL auto_increment, lngfile varchar(255) NOT NULL default '', question varchar(255) NOT NULL default '', answers text NOT NULL, PRIMARY KEY (id_question), KEY lngfile (lngfile) ) ENGINE=MyISAM{$db_collation}; ---# ---# Moving questions and answers to the new table ---{ $questions = array(); $get_questions = upgrade_query(" SELECT body AS question, recipient_name AS answer FROM {$db_prefix}log_comments WHERE comment_type = 'ver_test'"); while ($row = $smcFunc['db_fetch_assoc']($get_questions)) { $questions[] = "($language, $row[question], serialize(array($row[answer])))"; } $smcFunc['db_free_result']($get_questions); if (!empty($questions)) { upgrade_query(" INSERT INTO {$db_prefix}qanda (lngfile, question, answers) VALUES " . implode(',', $questions)); // Delete the questions from log_comments now upgrade_query(" DELETE FROM {$db_prefix}log_comments WHERE comment_type = 'ver_test' "); } ---} ---# /******************************************************************************/ --- Marking packages as uninstalled... /******************************************************************************/ ---# Updating log_packages UPDATE {$db_prefix}log_packages SET install_state = 0; ---# /******************************************************************************/ --- Updating profile permissions... /******************************************************************************/ ---# Adding "profile_password_own" ---{ $inserts = array(); $request = upgrade_query(" SELECT id_group, add_deny FROM {$db_prefix}permissions WHERE permission = 'profile_identity_own'"); while ($row = $smcFunc['db_fetch_assoc']($request)) { $inserts[] = "($row[id_group], 'profile_password_own', $row[add_deny])"; } $smcFunc['db_free_result']($request); if (!empty($inserts)) { upgrade_query(" INSERT INTO {$db_prefix}permissions (id_group, permission, add_deny) VALUES " . implode(',', $inserts)); } } ---} ---# ---# Adding other profile permissions ---{ $inserts = array(); $request = upgrade_query(" SELECT id_group, add_deny FROM {$db_prefix}permissions WHERE permission = 'profile_extra_own'"); while ($row = $smcFunc['db_fetch_assoc']($request)) { $inserts[] = "($row[id_group], 'profile_blurb_own', $row[add_deny])"; $inserts[] = "($row[id_group], 'profile_displayed_name_own', $row[add_deny])"; $inserts[] = "($row[id_group], 'profile_forum_own', $row[add_deny])"; $inserts[] = "($row[id_group], 'profile_other_own', $row[add_deny])"; $inserts[] = "($row[id_group], 'profile_signature_own', $row[add_deny])"; } $smcFunc['db_free_result']($request); if (!empty($inserts)) { upgrade_query(" INSERT INTO {$db_prefix}permissions (id_group, permission, add_deny) VALUES " . implode(',', $inserts)); } ---} ---#