1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048 |
- /* 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 integer NOT NULL auto_increment,
- id_member integer NOT NULL,
- time integer 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)
- );
- ---#
- ---# 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}settings
- 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 = $smcFunc['db_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;
- }
- }
- }
- ---}
- ---#
- ---# Adding new "topic_move_any" setting
- INSERT INTO {$db_prefix}settings (variable, value) VALUES ('topic_move_any', '1');
- ---#
- /******************************************************************************/
- --- 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);
- $fileHash = '';
- $request = upgrade_query("
- SELECT id_attach, id_folder, filename, file_hash
- FROM {$db_prefix}attachments
- WHERE attachment_type != 1
- 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.
- $currentFolder = !empty($modSettings['currentAttachmentUploadDir']) ? $modSettings['attachmentUploadDir'][$row['id_folder']] : $modSettings['attachmentUploadDir'];
- // Old School?
- if (empty($row['file_hash']))
- {
- // Remove international characters (windows-1252)
- // These lines should never be needed again. Still, behave.
- if (empty($db_character_set) || $db_character_set != 'utf8')
- {
- $row['filename'] = strtr($row['filename'],
- "\x8a\x8e\x9a\x9e\x9f\xc0\xc1\xc2\xc3\xc4\xc5\xc7\xc8\xc9\xca\xcb\xcc\xcd\xce\xcf\xd1\xd2\xd3\xd4\xd5\xd6\xd8\xd9\xda\xdb\xdc\xdd\xe0\xe1\xe2\xe3\xe4\xe5\xe7\xe8\xe9\xea\xeb\xec\xed\xee\xef\xf1\xf2\xf3\xf4\xf5\xf6\xf8\xf9\xfa\xfb\xfc\xfd\xff",
- 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy');
- $row['filename'] = strtr($row['filename'], array("\xde" => 'TH', "\xfe" =>
- 'th', "\xd0" => 'DH', "\xf0" => 'dh', "\xdf" => 'ss', "\x8c" => 'OE',
- "\x9c" => 'oe', "\xc6" => 'AE', "\xe6" => 'ae', "\xb5" => 'u'));
- }
- // Sorry, no spaces, dots, or anything else but letters allowed.
- $row['filename'] = preg_replace(array('/\s/', '/[^\w_\.\-]/'), array('_', ''), $row['filename']);
- // Create a nice hash.
- $fileHash = sha1(md5($row['filename'] . time()) . mt_rand());
- // The old file, we need to know if the filename was encrypted or not.
- if (file_exists($currentFolder . '/' . $row['id_attach']. '_' . strtr($row['filename'], '.', '_') . md5($row['filename'])))
- $oldFile = $currentFolder . '/' . $row['id_attach']. '_' . strtr($row['filename'], '.', '_') . md5($row['filename']);
- else if (file_exists($currentFolder . '/' . $row['filename']));
- $oldFile = $currentFolder . '/' . $row['filename'];
- // Build the new file.
- $newFile = $currentFolder . '/' . $row['id_attach'] . '_' . $fileHash .'.dat';
- }
- // Just rename the file.
- else
- {
- $oldFile = $currentFolder . '/' . $row['id_attach'] . '_' . $row['file_hash'];
- $newFile = $currentFolder . '/' . $row['id_attach'] . '_' . $row['file_hash'] .'.dat';
- }
- // And we try to move it.
- rename($oldFile, $newFile);
- // Only update this if it was successful and the file was using the old system.
- if (empty($row['file_hash']) && !empty($fileHash) && file_exists($newFile) && !file_exists($oldFile))
- upgrade_query("
- UPDATE {$db_prefix}attachments
- SET file_hash = '$fileHash'
- 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 logging who fulfils a group request.
- /******************************************************************************/
- ---# Adding new columns to log_group_requests
- ALTER TABLE {$db_prefix}log_group_requests
- ADD COLUMN status smallint unsigned NOT NULL default '0',
- ADD COLUMN id_member_acted int unsigned NOT NULL default '0',
- ADD COLUMN member_name_acted varchar(255) NOT NULL default '',
- ADD COLUMN time_acted int unsigned NOT NULL default '0',
- ADD COLUMN act_reason text NOT NULL;
- ---#
- ---# Adjusting the indexes for log_group_requests
- DROP INDEX {$db_prefix}log_group_requests_id_member;
- CREATE INDEX {$db_prefix}log_group_requests_id_member ON {$db_prefix}log_group_requests (id_member, id_group);
- ---#
- /******************************************************************************/
- --- Adding support for <credits> 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 new columns for MOVED topic updates
- /******************************************************************************/
- ---# Adding new custom fields columns.
- ---{
- $smcFunc['db_alter_table']('{db_prefix}topics', array(
- 'add' => array(
- 'redirect_expires' => array(
- 'name' => 'redirect_expires',
- 'null' => false,
- 'default' => '0',
- 'type' => 'int',
- 'auto' => false,
- ),
- )
- ));
- $smcFunc['db_alter_table']('{db_prefix}topics', array(
- 'add' => array(
- 'id_redirect_topic' => array(
- 'name' => 'id_redirect_topic',
- 'null' => false,
- 'default' => '0',
- 'type' => 'int',
- 'auto' => false,
- ),
- )
- ));
- ---}
- ---#
- /******************************************************************************/
- --- 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');
- ---#
- /******************************************************************************/
- ---- Adding background tasks support
- /******************************************************************************/
- ---# Adding the new table
- CREATE TABLE IF NOT EXISTS {$db_prefix}background_tasks (
- id_task integer primary key,
- task_file varchar(255) NOT NULL default '',
- task_class varchar(255) NOT NULL default '',
- task_data text NOT NULL,
- claimed_time int NOT NULL default '0',
- PRIMARY KEY (id_task)
- );
- ---#
- /******************************************************************************/
- ---- 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...
- ---{
- $smcFunc['db_alter_table']('{db_prefix}boards', array(
- 'add' => array(
- 'deny_member_groups' => array(
- 'name' => 'deny_member_groups',
- 'null' => false,
- 'default' => '',
- 'type' => varchar,
- 'size' => 255,
- 'auto' => false,
- ),
- )
- ));
- ---}
- ---#
- /******************************************************************************/
- --- Adding support for category descriptions
- /******************************************************************************/
- ---# Adding new columns to categories...
- ---{
- $smcFunc['db_alter_table']('{db_prefix}log_topics', array(
- 'add' => array(
- 'description' => array(
- 'name' => 'description',
- 'null' => false,
- 'type' => 'text',
- 'auto' => false,
- ),
- )
- ));
- ---}
- ---#
- /******************************************************************************/
- --- Adding support for alerts
- /******************************************************************************/
- ---# Adding the count to the members table...
- ---{
- $smcFunc['db_alter_table']('{db_prefix}members', array(
- 'add' => array(
- 'alerts' => array(
- 'name' => 'ualerts',
- 'null' => false,
- 'default' => 0,
- 'type' => 'int',
- 'auto' => false,
- ),
- )
- ));
- ---}
- ---#
- ---# Adding the new table for alerts.
- CREATE TABLE IF NOT EXISTS {$db_prefix}user_alerts (
- id_alert int primary key,
- alert_time int unsigned NOT NULL default '0',
- id_member int unsigned NOT NULL default '0',
- id_member_started int unsigned NOT NULL default '0',
- member_name varchar(255) NOT NULL default '',
- content_type varchar(255) NOT NULL default '',
- content_id int unsigned NOT NULL default '0',
- content_action varchar(255) NOT NULL default '',
- is_read smallint unsigned NOT NULL default '0',
- extra text NOT NULL,
- PRIMARY KEY (id_alert)
- );
- CREATE INDEX {$db_prefix}user_alerts_id_member ON {$db_prefix}user_alerts (id_member);
- CREATE INDEX {$db_prefix}user_alerts_alert_time ON {$db_prefix}user_alerts (alert_time);
- ---#
- ---# Adding alert preferences.
- CREATE TABLE IF NOT EXISTS {$db_prefix}user_alerts_prefs (
- id_member int unsigned NOT NULL default '0',
- alert_pref varchar(32) NOT NULL default '',
- alert_value tinyint(3) NOT NULL default '0',
- PRIMARY KEY (id_member, alert_pref)
- );
- INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'member_group_request', 1);
- INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'member_register', 1);
- INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'msg_like', 1);
- INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'msg_report', 1);
- INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'msg_report_reply', 1);
- ---#
- /******************************************************************************/
- --- Adding support for topic unwatch
- /******************************************************************************/
- ---# Adding new columns to log_topics...
- ---{
- $smcFunc['db_alter_table']('{db_prefix}log_topics', array(
- 'add' => array(
- 'unwatched' => array(
- 'name' => 'unwatched',
- 'null' => false,
- 'default' => 0,
- 'type' => 'int',
- 'auto' => false,
- ),
- )
- ));
- UPDATE {$db_prefix}log_topics
- SET unwatched = 0;
- INSERT INTO {$db_prefix}settings
- (variable, value)
- VALUES
- ('enable_unwatch', 0);
- ---}
- ---#
- ---# Fixing column name change...
- ---{
- $smcFunc['db_alter_table']('{db_prefix}log_topics', array(
- 'change' => array(
- 'disregarded' => array(
- 'name' => 'unwatched',
- 'null' => false,
- 'default' => 0,
- 'type' => 'int',
- 'auto' => false,
- ),
- )
- ));
- ---}
- ---#
- /******************************************************************************/
- --- Name changes
- /******************************************************************************/
- ---# Altering the membergroup stars to icons
- ---{
- upgrade_query("
- 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%';
- ---#
- ---# Adding the enableThemes setting.
- INSERT INTO {$db_prefix}settings
- (variable, value)
- VALUES
- ('enableThemes', '1');
- ---#
- ---# Setting "default" as the default...
- UPDATE {$db_prefix}settings
- SET value = '1'
- WHERE variable = 'theme_guests';
- UPDATE {$db_prefix}boards
- SET id_theme = 0;
- UPDATE {$db_prefix}members
- SET id_theme = 0;
- ---#
- /******************************************************************************/
- --- 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 ($smcFunc['db_num_rows']($theme_request) == 1)
- {
- list($id_theme) = $smcFunc['db_fetch_row']($theme_request, 0);
- $smcFunc['db_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("
- UPDATE {$db_prefix}settings
- SET value = '$known_themes'
- WHERE variable = 'knownThemes'");
- // Delete any info about this theme
- upgrade_query("
- DELETE FROM {$db_prefix}themes
- WHERE id_theme = $id_theme");
- }
- }
- /******************************************************************************/
- --- Adding support for drafts
- /******************************************************************************/
- ---# Creating drafts table.
- CREATE TABLE IF NOT EXISTS {$db_prefix}user_drafts (
- id_draft int unsigned NOT NULL auto_increment,
- id_topic int unsigned NOT NULL default '0',
- id_board smallint unsigned NOT NULL default '0',
- id_reply int unsigned NOT NULL default '0',
- type smallint NOT NULL default '0',
- poster_time int unsigned NOT NULL default '0',
- id_member int unsigned NOT NULL default '0',
- subject varchar(255) NOT NULL default '',
- smileys_enabled smallint NOT NULL default '1',
- body text NOT NULL,
- icon varchar(16) NOT NULL default 'xx',
- locked smallint NOT NULL default '0',
- is_sticky smallint NOT NULL default '0',
- to_list varchar(255) NOT NULL default '',
- PRIMARY KEY (id_draft)
- );
- CREATE UNIQUE INDEX {$db_prefix}user_drafts_id_member ON {$db_prefix}user_drafts (id_member, id_draft, type);
- ---#
- ---# 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 = $smcFunc['db_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])";
- }
- $smcFunc['db_free_result']($request);
- if (!empty($inserts))
- {
- foreach ($inserts AS $insert)
- {
- upgrade_query("
- INSERT INTO {$db_prefix}board_permissions
- (id_group, id_board, permission, add_deny)
- VALUES
- " . $insert);
- }
- }
- // 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 = $smcFunc['db_fetch_assoc']($request))
- {
- $inserts[] = "($row[id_group], 'pm_draft', $row[add_deny])";
- $inserts[] = "($row[id_group], 'pm_autosave_draft', $row[add_deny])";
- }
- $smcFunc['db_free_result']($request);
- if (!empty($inserts))
- {
- foreach ($inserts AS $insert)
- {
- upgrade_query("
- INSERT INTO {$db_prefix}permissions
- (id_group, permission, add_deny)
- VALUES
- " . $insert);
- }
- }
- }
- ---}
- INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_autosave_enabled', '1');
- INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_show_saved_enabled', '1');
- INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_keep_days', '7');
- INSERT INTO {$db_prefix}themes (id_theme, variable, value) VALUES ('1', 'drafts_autosave_enabled', '1');
- INSERT INTO {$db_prefix}themes (id_theme, variable, value) VALUES ('1', 'drafts_show_saved_enabled', '1');
- ---#
- /******************************************************************************/
- --- Adding support for likes
- /******************************************************************************/
- ---# Creating likes table.
- CREATE TABLE IF NOT EXISTS {$db_prefix}user_likes (
- id_member int NOT NULL default '0',
- content_type char(6) default '',
- content_id int NOT NULL default '0',
- like_time int NOT NULL default '0',
- PRIMARY KEY (content_id, content_type, id_member)
- );
- CREATE INDEX {$db_prefix}user_likes_content ON {$db_prefix}user_likes (content_id, content_type);
- CREATE INDEX {$db_prefix}user_likes_liker ON {$db_prefix}user_likes (id_member);
- ---#
- ---# Adding count to the messages table.
- ALTER TABLE {$db_prefix}messages
- ADD COLUMN likes smallint 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 NOT NULL default '0',
- id_group smallint NOT NULL default '0',
- PRIMARY KEY (id_board, id_group)
- );
- ---#
- /******************************************************************************/
- --- Cleaning up 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', 'notify_new_registration', 'attachmentEncryptFilenames');
- ---#
- ---# Cleaning up old theme settings.
- DELETE FROM {$db_prefix}themes
- WHERE variable IN ('show_board_desc', 'no_new_reply_warning', 'display_quick_reply');
- ---#
- /******************************************************************************/
- --- Removing old Simple Machines files we do not need to fetch any more
- /******************************************************************************/
- ---# We no longer call on the latest packages list.
- DELETE FROM {$db_prefix}admin_info_files
- WHERE filename IN ('latest-packages.js', 'latest-support.js', 'latest-themes.js')
- AND path = '/smf/';
- ---#
- /******************************************************************************/
- --- 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)
- );
- ---#
- ---# 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[] = array($language, $row['question'], serialize(array($row['answer'])));
- $smcFunc['db_free_result']($get_questions);
- if (!empty($questions))
- {
- $smcFunc['db_insert']('',
- '{db_prefix}qanda',
- array('lngfile' => 'string', 'question' => 'string', 'answers' => 'string'),
- $questions,
- array('id_question')
- );
- // 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...
- /******************************************************************************/
- ---# Removing the old "view your own profile" permission
- DELETE FROM {$db_prefix}permissions
- WHERE permission = 'profile_view_own';
- ---#
- ---# Updating the old "view any profile" permission
- UPDATE {$db_prefix}permissions
- SET permission = 'profile_view'
- WHERE permission = 'profile_view_any';
- ---#
- ---# Removing the old notification permissions
- DELETE FROM {$db_prefix}board_permissions
- WHERE permission = 'mark_notify' OR permission = 'mark_any_notify';
- ---#
- ---# 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))
- {
- foreach ($inserts as $insert)
- {
- upgrade_query("
- INSERT INTO {$db_prefix}permissions
- (id_group, permission, add_deny)
- VALUES
- " . $insert);
- }
- }
- ---}
- ---#
- ---# 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))
- {
- foreach ($inserts as $insert)
- {
- upgrade_query("
- INSERT INTO {$db_prefix}permissions
- (id_group, permission, add_deny)
- VALUES
- " . $insert);
- }
- }
- ---}
- ---#
- /******************************************************************************/
- --- Upgrading PM labels...
- /******************************************************************************/
- ---# Adding pm_labels table...
- CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labels (
- id_label integer primary key,
- id_member int NOT NULL default '0',
- name varchar(30) NOT NULL default '',
- );
- ---#
- ---# Adding pm_labeled_messages table...
- CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labeled_messages (
- id_label int NOT NULL default '0',
- id_pm int NOT NULL default '0',
- PRIMARY KEY (id_label, id_pm)
- );
- ---#
- ---# Adding "in_inbox" column to pm_recipients
- ALTER TABLE {$db_prefix}pm_recipients
- ADD COLUMN in_inbox tinyint(3) NOT NULL default '1';
- ---#
- ---# Moving label info to new tables and updating rules...
- ---{
- // First see if we still have a message_labels column
- $results = $smcFunc['db_list_columns']('{db_prefix}members');
- if (in_array('message_labels', $results))
- {
- // They've still got it, so pull the label info
- $get_labels = $smcFunc['db_query']('', '
- SELECT id_member, message_labels
- FROM {db_prefix}members
- WHERE message_labels != {string:blank}',
- array(
- 'blank' => '',
- )
- );
- $inserts = array();
- $label_info = array();
- while ($row = $smcFunc['db_fetch_assoc']($get_labels))
- {
- // Stick this in an array
- $labels = explode(',', $row['message_labels']);
- // Build some inserts
- foreach ($labels AS $index => $label)
- {
- // Keep track of the index of this label - we'll need that in a bit...
- $label_info[$row['id_member']][$label] = $index;
- $inserts[] = array($row['id_member'], $label);
- }
- }
- $smcFunc['db_free_result']($get_labels);
- if (!empty($inserts))
- {
- $smcFunc['db_insert']('', '{db_prefix}pm_labels', array('id_member' => 'int', 'name' => 'int'), $inserts, array());
- // Clear this out for our next query below
- $inserts = array();
- }
- // This is the easy part - update the inbox stuff
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}pm_recipients
- SET in_inbox = {int:in_inbox}
- WHERE FIND_IN_SET({int:minus_one}, labels)',
- array(
- 'in_inbox' => 1,
- 'minus_one' => -1,
- )
- );
- // Now we go pull the new IDs for each label
- $get_new_label_ids = $smcFunc['db_query']('', '
- SELECT *
- FROM {db_prefix}pm_labels',
- array(
- )
- );
- $label_info_2 = array();
- while ($label_row = $smcFunc['db_fetch_assoc']($get_new_label_ids))
- {
- // Map the old index values to the new ID values...
- $old_index = $label_info[$row['id_member']][$row['label_name']];
- $label_info_2[$row['id_member']][$old_index] = $row['id_label'];
- }
- $smcFunc['db_free_result']($get_new_label_ids);
- // Pull label info from pm_recipients
- // Ignore any that are only in the inbox
- $get_pm_labels = $smcFunc['db_query']('', '
- SELECT id_pm, id_member, labels
- FROM {db_prefix}pm_recipients
- WHERE deleted = {int:not_deleted}
- AND labels != {string:minus_one}',
- array(
- 'not_deleted' => 0,
- 'minus_one' => -1,
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($get_pm_labels))
- {
- $labels = explode(',', $row['labels']);
- foreach ($labels as $a_label)
- {
- if ($a_label == '-1')
- continue;
- $new_label_info = $label_info_2[$row['id_member']][$a_label];
- $inserts[] = array($row['id_pm'], $new_label_info);
- }
- }
- $smcFunc['db_free_result']($get_pm_labels);
- // Insert the new data
- if (!empty($inserts))
- {
- $smcFunc['db_insert']('', '{db_prefix}pm_labeled_messages', array('id_pm', 'id_label'), $inserts, array());
- }
- // Final step of this ridiculously massive process
- $get_pm_rules = $smcFunc['db_query']('', '
- SELECT id_member, id_rule, actions
- FROM {db_prefix}pm_rules',
- array(
- ),
- );
- // Go through the rules, unserialize the actions, then figure out if there's anything we can use
- while ($row = $smcFunc['db_fetch_assoc']($get_pm_rules))
- {
- // Turn this into an array...
- $actions = unserialize($row['actions']);
- // Loop through the actions and see if we're applying a label anywhere
- foreach ($actions as $index => $action)
- {
- if ($action['t'] == 'lab')
- {
- // Update the value of this label...
- $actions[$index]['v'] = $label_info_2[$row['id_member']][$action['v']];
- }
- }
- // Put this back into a string
- $actions = serialize($actions);
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}pm_rules
- SET actions = {string:actions}
- WHERE id_rule = {int:id_rule}',
- array(
- 'actions' => $actions,
- 'id_rule' => $row['id_rule'],
- )
- );
- }
- $smcFunc['db_free_result']($get_pm_rules);
- // Lastly, we drop the old columns
- $smcFunc['db_remove_column']('{db_prefix}members', 'message_labels');
- $smcFunc['db_remove_column']('{db_prefix}pm_recipients', 'labels');
- }
- }
- ******************************************************************************/
- --- Adding support for edit reasons
- /******************************************************************************/
- ---# Adding "modified_reason" column to messages
- ALTER TABLE {$db_prefix}messages
- ADD COLUMN modified_reason varchar(255) NOT NULL default '';
- ---#
- /******************************************************************************/
- --- Cleaning up guest permissions
- /******************************************************************************/
- ---# Removing permissions guests can no longer have...
- ---{
- $illegal_board_permissions = array(
- 'announce_topic',
- 'delete_any',
- 'lock_any',
- 'make_sticky',
- 'merge_any',
- 'modify_any',
- 'modify_replies',
- 'move_any',
- 'poll_add_any',
- 'poll_edit_any',
- 'poll_lock_any',
- 'poll_remove_any',
- 'remove_any',
- 'report_any',
- 'split_any'
- );
- $illegal_permissions = array('calendar_edit_any', 'moderate_board', 'moderate_forum', 'send_email_to_members');
- $smcFunc['db_query']('', '
- DELETE FROM {db_prefix}board_permissions
- WHERE id_group = {int:guests}
- AND permission IN ({array_string:illegal_board_perms})',
- array(
- 'guests' => -1,
- 'illegal_board_perms' => $illegal_board_permissions,
- )
- );
- $smcFunc['db_query']('', '
- DELETE FROM {db_prefix}permissions
- WHERE id_group = {int:guests}
- AND permission IN ({array_string:illegal_perms})',
- array(
- 'guests' => -1,
- 'illegal_perms' => $illegal_permissions,
- )
- );
- ---}
- ---#
- /******************************************************************************/
- --- Adding mail queue settings
- /******************************************************************************/
- ---#
- ---{
- if (empty($modSettings['mail_limit']))
- {
- $smcFunc['db_insert']('replace',
- '{db_prefix}settings',
- array('variable' => 'string-255', 'value' => 'string'),
- array(
- array('mail_limit', '5'),
- array('mail_quantity', '5'),
- ),
- array('variable')
- );
- }
- ---}
- ---#
|