upgrade_2-1_mysql.sql 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975
  1. /* ATTENTION: You don't need to run or use this file! The upgrade.php script does everything for you! */
  2. /******************************************************************************/
  3. --- Adding new settings...
  4. /******************************************************************************/
  5. ---# Adding login history...
  6. CREATE TABLE IF NOT EXISTS {$db_prefix}member_logins (
  7. id_login int(10) NOT NULL auto_increment,
  8. id_member mediumint(8) NOT NULL,
  9. time int(10) NOT NULL,
  10. ip varchar(255) NOT NULL default '',
  11. ip2 varchar(255) NOT NULL default '',
  12. PRIMARY KEY id_login(id_login),
  13. KEY id_member (id_member),
  14. KEY time (time)
  15. ) ENGINE=MyISAM{$db_collation};
  16. ---#
  17. ---# Copying the current package backup setting...
  18. ---{
  19. if (!isset($modSettings['package_make_full_backups']) && isset($modSettings['package_make_backups']))
  20. upgrade_query("
  21. INSERT INTO {$db_prefix}settings
  22. (variable, value)
  23. VALUES
  24. ('package_make_full_backups', '" . $modSettings['package_make_backups'] . "')");
  25. ---}
  26. ---#
  27. ---# Copying the current "allow users to disable word censor" setting...
  28. ---{
  29. if (!isset($modSettings['allow_no_censored']))
  30. {
  31. $request = upgrade_query("
  32. SELECT value
  33. FROM {$db_prefix}themes
  34. WHERE variable='allow_no_censored'
  35. AND id_theme = 1 OR id_theme = '$modSettings[theme_default]'
  36. ");
  37. // Is it set for either "default" or the one they've set as default?
  38. while ($row = $smcFunc['db_fetch_assoc']($request))
  39. {
  40. if ($row['value'] == 1)
  41. {
  42. upgrade_query("
  43. INSERT INTO {$db_prefix}settings
  44. VALUES ('allow_no_censored', 1)
  45. ");
  46. // Don't do this twice...
  47. break;
  48. }
  49. }
  50. }
  51. ---}
  52. ---#
  53. ---# Adding new "topic_move_any" setting
  54. INSERT INTO {$db_prefix}settings (variable, value) VALUES ('topic_move_any', '1');
  55. ---#
  56. /******************************************************************************/
  57. --- Updating legacy attachments...
  58. /******************************************************************************/
  59. ---# Converting legacy attachments.
  60. ---{
  61. $request = upgrade_query("
  62. SELECT MAX(id_attach)
  63. FROM {$db_prefix}attachments");
  64. list ($step_progress['total']) = $smcFunc['db_fetch_row']($request);
  65. $smcFunc['db_free_result']($request);
  66. $_GET['a'] = isset($_GET['a']) ? (int) $_GET['a'] : 0;
  67. $step_progress['name'] = 'Converting legacy attachments';
  68. $step_progress['current'] = $_GET['a'];
  69. // We may be using multiple attachment directories.
  70. if (!empty($modSettings['currentAttachmentUploadDir']) && !is_array($modSettings['attachmentUploadDir']))
  71. $modSettings['attachmentUploadDir'] = unserialize($modSettings['attachmentUploadDir']);
  72. $is_done = false;
  73. while (!$is_done)
  74. {
  75. nextSubStep($substep);
  76. $fileHash = '';
  77. $request = upgrade_query("
  78. SELECT id_attach, id_folder, filename, file_hash
  79. FROM {$db_prefix}attachments
  80. WHERE attachment_type != 1
  81. LIMIT $_GET[a], 100");
  82. // Finished?
  83. if ($smcFunc['db_num_rows']($request) == 0)
  84. $is_done = true;
  85. while ($row = $smcFunc['db_fetch_assoc']($request))
  86. {
  87. // The current folder.
  88. $currentFolder = !empty($modSettings['currentAttachmentUploadDir']) ? $modSettings['attachmentUploadDir'][$row['id_folder']] : $modSettings['attachmentUploadDir'];
  89. // Old School?
  90. if (empty($row['file_hash']))
  91. {
  92. // Remove international characters (windows-1252)
  93. // These lines should never be needed again. Still, behave.
  94. if (empty($db_character_set) || $db_character_set != 'utf8')
  95. {
  96. $row['filename'] = strtr($row['filename'],
  97. "\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",
  98. 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy');
  99. $row['filename'] = strtr($row['filename'], array("\xde" => 'TH', "\xfe" =>
  100. 'th', "\xd0" => 'DH', "\xf0" => 'dh', "\xdf" => 'ss', "\x8c" => 'OE',
  101. "\x9c" => 'oe', "\xc6" => 'AE', "\xe6" => 'ae', "\xb5" => 'u'));
  102. }
  103. // Sorry, no spaces, dots, or anything else but letters allowed.
  104. $row['filename'] = preg_replace(array('/\s/', '/[^\w_\.\-]/'), array('_', ''), $row['filename']);
  105. // Create a nice hash.
  106. $fileHash = sha1(md5($row['filename'] . time()) . mt_rand());
  107. // The old file, we need to know if the filename was encrypted or not.
  108. if (file_exists($currentFolder . '/' . $row['id_attach']. '_' . strtr($row['filename'], '.', '_') . md5($row['filename'])))
  109. $oldFile = $currentFolder . '/' . $row['id_attach']. '_' . strtr($row['filename'], '.', '_') . md5($row['filename']);
  110. else if (file_exists($currentFolder . '/' . $row['filename']));
  111. $oldFile = $currentFolder . '/' . $row['filename'];
  112. // Build the new file.
  113. $newFile = $currentFolder . '/' . $row['id_attach'] . '_' . $fileHash .'.dat';
  114. }
  115. // Just rename the file.
  116. else
  117. {
  118. $oldFile = $currentFolder . '/' . $row['id_attach'] . '_' . $row['file_hash'];
  119. $newFile = $currentFolder . '/' . $row['id_attach'] . '_' . $row['file_hash'] .'.dat';
  120. }
  121. // And we try to move it.
  122. rename($oldFile, $newFile);
  123. // Only update this if it was successful and the file was using the old system.
  124. if (empty($row['file_hash']) && !empty($fileHash) && file_exists($newFile) && !file_exists($oldFile))
  125. upgrade_query("
  126. UPDATE {$db_prefix}attachments
  127. SET file_hash = '$fileHash'
  128. WHERE id_attach = $row[id_attach]");
  129. }
  130. $smcFunc['db_free_result']($request);
  131. $_GET['a'] += 100;
  132. $step_progress['current'] = $_GET['a'];
  133. }
  134. unset($_GET['a']);
  135. ---}
  136. ---#
  137. /******************************************************************************/
  138. --- Adding support for IPv6...
  139. /******************************************************************************/
  140. ---# Adding new columns to ban items...
  141. ALTER TABLE {$db_prefix}ban_items
  142. ADD COLUMN ip_low5 smallint(255) unsigned NOT NULL DEFAULT '0',
  143. ADD COLUMN ip_high5 smallint(255) unsigned NOT NULL DEFAULT '0',
  144. ADD COLUMN ip_low6 smallint(255) unsigned NOT NULL DEFAULT '0',
  145. ADD COLUMN ip_high6 smallint(255) unsigned NOT NULL DEFAULT '0',
  146. ADD COLUMN ip_low7 smallint(255) unsigned NOT NULL DEFAULT '0',
  147. ADD COLUMN ip_high7 smallint(255) unsigned NOT NULL DEFAULT '0',
  148. ADD COLUMN ip_low8 smallint(255) unsigned NOT NULL DEFAULT '0',
  149. ADD COLUMN ip_high8 smallint(255) unsigned NOT NULL DEFAULT '0';
  150. ---#
  151. ---# Changing existing columns to ban items...
  152. ALTER TABLE {$db_prefix}ban_items
  153. CHANGE ip_low1 ip_low1 smallint(255) unsigned NOT NULL DEFAULT '0',
  154. CHANGE ip_high1 ip_high1 smallint(255) unsigned NOT NULL DEFAULT '0',
  155. CHANGE ip_low2 ip_low2 smallint(255) unsigned NOT NULL DEFAULT '0',
  156. CHANGE ip_high2 ip_high2 smallint(255) unsigned NOT NULL DEFAULT '0',
  157. CHANGE ip_low3 ip_low3 smallint(255) unsigned NOT NULL DEFAULT '0',
  158. CHANGE ip_high3 ip_high3 smallint(255) unsigned NOT NULL DEFAULT '0',
  159. CHANGE ip_low4 ip_low4 smallint(255) unsigned NOT NULL DEFAULT '0',
  160. CHANGE ip_high4 ip_high4 smallint(255) unsigned NOT NULL DEFAULT '0';
  161. ---#
  162. /******************************************************************************/
  163. --- Adding support for logging who fulfils a group request.
  164. /******************************************************************************/
  165. ---# Adding new columns to log_group_requests
  166. ALTER TABLE {$db_prefix}log_group_requests
  167. ADD COLUMN status tinyint(3) unsigned NOT NULL default '0',
  168. ADD COLUMN id_member_acted mediumint(8) unsigned NOT NULL default '0',
  169. ADD COLUMN member_name_acted varchar(255) NOT NULL default '',
  170. ADD COLUMN time_acted int(10) unsigned NOT NULL default '0',
  171. ADD COLUMN act_reason text NOT NULL;
  172. ---#
  173. ---# Adjusting the indexes for log_group_requests
  174. ALTER TABLE {$db_prefix}log_group_requests
  175. DROP INDEX `id_member`,
  176. ADD INDEX `id_member` (`id_member`, `id_group`);
  177. ---#
  178. /******************************************************************************/
  179. --- Adding support for <credits> tag in package manager
  180. /******************************************************************************/
  181. ---# Adding new columns to log_packages ..
  182. ALTER TABLE {$db_prefix}log_packages
  183. ADD COLUMN credits varchar(255) NOT NULL DEFAULT '';
  184. ---#
  185. /******************************************************************************/
  186. --- Adding more space for session ids
  187. /******************************************************************************/
  188. ---# Altering the session_id columns...
  189. ALTER TABLE {$db_prefix}log_online
  190. CHANGE `session` `session` varchar(64) NOT NULL DEFAULT '';
  191. ALTER TABLE {$db_prefix}log_errors
  192. CHANGE `session` `session` char(64) NOT NULL default ' ';
  193. ALTER TABLE {$db_prefix}sessions
  194. CHANGE `session_id` `session_id` char(64) NOT NULL;
  195. ---#
  196. /******************************************************************************/
  197. --- Adding support for MOVED topics enhancements
  198. /******************************************************************************/
  199. ---# Adding new columns to topics ..
  200. ALTER TABLE {$db_prefix}topics
  201. ADD COLUMN redirect_expires int(10) unsigned NOT NULL default '0',
  202. ADD COLUMN id_redirect_topic mediumint(8) unsigned NOT NULL default '0';
  203. ---#
  204. /******************************************************************************/
  205. --- Adding new scheduled tasks
  206. /******************************************************************************/
  207. ---# Adding new scheduled tasks
  208. INSERT INTO {$db_prefix}scheduled_tasks
  209. (next_time, time_offset, time_regularity, time_unit, disabled, task)
  210. VALUES
  211. (0, 120, 1, 'd', 0, 'remove_temp_attachments');
  212. INSERT INTO {$db_prefix}scheduled_tasks
  213. (next_time, time_offset, time_regularity, time_unit, disabled, task)
  214. VALUES
  215. (0, 180, 1, 'd', 0, 'remove_topic_redirect');
  216. INSERT INTO {$db_prefix}scheduled_tasks
  217. (next_time, time_offset, time_regularity, time_unit, disabled, task)
  218. VALUES
  219. (0, 240, 1, 'd', 0, 'remove_old_drafts');
  220. ---#
  221. /******************************************************************************/
  222. ---- Adding background tasks support
  223. /******************************************************************************/
  224. ---# Adding the new table
  225. CREATE TABLE IF NOT EXISTS {$db_prefix}background_tasks (
  226. id_task int(10) unsigned NOT NULL auto_increment,
  227. task_file varchar(255) NOT NULL default '',
  228. task_class varchar(255) NOT NULL default '',
  229. task_data mediumtext NOT NULL,
  230. claimed_time int(10) unsigned NOT NULL default '0',
  231. PRIMARY KEY (id_task)
  232. ) ENGINE=MyISAM;
  233. ---#
  234. /******************************************************************************/
  235. ---- Replacing MSN with Skype
  236. /******************************************************************************/
  237. ---# Modifying the "msn" column...
  238. ALTER TABLE {$db_prefix}members
  239. CHANGE msn skype varchar(255) NOT NULL DEFAULT '';
  240. ---#
  241. /******************************************************************************/
  242. --- Adding support for deny boards access
  243. /******************************************************************************/
  244. ---# Adding new columns to boards...
  245. ALTER TABLE {$db_prefix}boards
  246. ADD COLUMN deny_member_groups varchar(255) NOT NULL DEFAULT '';
  247. ---#
  248. /******************************************************************************/
  249. --- Adding support for category descriptions
  250. /******************************************************************************/
  251. ---# Adding new columns to categories...
  252. ALTER TABLE {$db_prefix}categories
  253. ADD COLUMN description text NOT NULL;
  254. ---#
  255. /******************************************************************************/
  256. --- Adding support for alerts
  257. /******************************************************************************/
  258. ---# Adding the count to the members table...
  259. ALTER TABLE {$db_prefix}members
  260. ADD COLUMN alerts int(10) unsigned NOT NULL default '0';
  261. ---#
  262. ---# Adding the new table for alerts.
  263. CREATE TABLE IF NOT EXISTS {$db_prefix}user_alerts (
  264. id_alert int(10) unsigned NOT NULL auto_increment,
  265. alert_time int(10) unsigned NOT NULL default '0',
  266. id_member mediumint(10) unsigned NOT NULL default '0',
  267. id_member_started mediumint(10) unsigned NOT NULL default '0',
  268. member_name varchar(255) NOT NULL default '',
  269. content_type varchar(255) NOT NULL default '',
  270. content_id int(10) unsigned NOT NULL default '0',
  271. content_action varchar(255) NOT NULL default '',
  272. is_read tinyint(3) unsigned NOT NULL default '0',
  273. extra text NOT NULL,
  274. PRIMARY KEY (id_alert),
  275. KEY id_member (id_member),
  276. KEY alert_time (alert_time)
  277. ) ENGINE=MyISAM;
  278. ---#
  279. ---# Adding alert preferences.
  280. CREATE TABLE IF NOT EXISTS {$db_prefix}user_alerts_prefs (
  281. id_member mediumint(8) unsigned NOT NULL default '0',
  282. alert_pref varchar(32) NOT NULL default '',
  283. alert_value tinyint(3) NOT NULL default '0',
  284. PRIMARY KEY (id_member, alert_pref)
  285. ) ENGINE=MyISAM;
  286. INSERT INTO {$db_prefix}user_alerts_prefs
  287. (id_member, alert_pref, alert_value)
  288. VALUES (0, 'member_group_request', 1),
  289. (0, 'member_register', 1),
  290. (0, 'msg_like', 1),
  291. (0, 'msg_report', 1),
  292. (0, 'msg_report_reply', 1);
  293. ---#
  294. /******************************************************************************/
  295. --- Adding support for topic unwatch
  296. /******************************************************************************/
  297. ---# Adding new columns to boards...
  298. ALTER TABLE {$db_prefix}log_topics
  299. ADD COLUMN unwatched tinyint(3) NOT NULL DEFAULT '0';
  300. UPDATE {$db_prefix}log_topics
  301. SET unwatched = 0;
  302. INSERT INTO {$db_prefix}settings
  303. (variable, value)
  304. VALUES
  305. ('enable_unwatch', 0);
  306. ---#
  307. ---# Fixing column name change...
  308. ALTER TABLE {$db_prefix}log_topics
  309. CHANGE COLUMN disregarded unwatched tinyint(3) NOT NULL DEFAULT '0';
  310. ---#
  311. /******************************************************************************/
  312. --- Fixing mail queue for long messages
  313. /******************************************************************************/
  314. ---# Altering mil_queue table...
  315. ALTER TABLE {$db_prefix}mail_queue
  316. CHANGE body body mediumtext NOT NULL;
  317. ---#
  318. /******************************************************************************/
  319. --- Name changes
  320. /******************************************************************************/
  321. ---# Altering the membergroup stars to icons
  322. ALTER TABLE {$db_prefix}membergroups
  323. CHANGE `stars` `icons` varchar(255) NOT NULL DEFAULT '';
  324. ---#
  325. ---# Renaming default theme...
  326. UPDATE {$db_prefix}themes
  327. SET value = 'SMF Default Theme - Curve2'
  328. WHERE value LIKE 'SMF Default Theme%';
  329. ---#
  330. ---# Adding the enableThemes setting.
  331. INSERT INTO {$db_prefix}settings
  332. (variable, value)
  333. VALUES
  334. ('enableThemes', '1');
  335. ---#
  336. ---# Setting "default" as the default...
  337. UPDATE {$db_prefix}settings
  338. SET value = '1'
  339. WHERE variable = 'theme_guests';
  340. UPDATE {$db_prefix}boards
  341. SET id_theme = 0;
  342. UPDATE {$db_prefix}members
  343. SET id_theme = 0;
  344. ---#
  345. /******************************************************************************/
  346. --- Cleaning up after old themes...
  347. /******************************************************************************/
  348. ---# Checking for "core" and removing it if necessary...
  349. ---{
  350. // Do they have "core" installed?
  351. if (file_exists($GLOBALS['boarddir'] . '/Themes/core'))
  352. {
  353. $core_dir = $GLOBALS['boarddir'] . '/Themes/core';
  354. $theme_request = upgrade_query("
  355. SELECT id_theme
  356. FROM {$db_prefix}themes
  357. WHERE variable = 'theme_dir'
  358. AND value ='$core_dir'");
  359. // Don't do anything if this theme is already uninstalled
  360. if ($smcFunc['db_num_rows']($theme_request) == 1)
  361. {
  362. // Only one row, so no loop needed
  363. $row = $smcFunc['db_fetch_array']($theme_request);
  364. $id_theme = $row[0];
  365. $smcFunc['db_free_result']($theme_request);
  366. $known_themes = explode(', ', $modSettings['knownThemes']);
  367. // Remove this value...
  368. $known_themes = array_diff($known_themes, array($id_theme));
  369. // Change back to a string...
  370. $known_themes = implode(', ', $known_themes);
  371. // Update the database
  372. upgrade_query("
  373. REPLACE INTO {$db_prefix}settings (variable, value)
  374. VALUES ('knownThemes', '$known_themes')");
  375. // Delete any info about this theme
  376. upgrade_query("
  377. DELETE FROM {$db_prefix}themes
  378. WHERE id_theme = $id_theme");
  379. }
  380. }
  381. ---}
  382. ---#
  383. /******************************************************************************/
  384. --- Adding support for drafts
  385. /******************************************************************************/
  386. ---# Creating draft table
  387. CREATE TABLE IF NOT EXISTS {$db_prefix}user_drafts (
  388. id_draft int(10) unsigned NOT NULL auto_increment,
  389. id_topic mediumint(8) unsigned NOT NULL default '0',
  390. id_board smallint(5) unsigned NOT NULL default '0',
  391. id_reply int(10) unsigned NOT NULL default '0',
  392. type tinyint(4) NOT NULL default '0',
  393. poster_time int(10) unsigned NOT NULL default '0',
  394. id_member mediumint(8) unsigned NOT NULL default '0',
  395. subject varchar(255) NOT NULL default '',
  396. smileys_enabled tinyint(4) NOT NULL default '1',
  397. body mediumtext NOT NULL,
  398. icon varchar(16) NOT NULL default 'xx',
  399. locked tinyint(4) NOT NULL default '0',
  400. is_sticky tinyint(4) NOT NULL default '0',
  401. to_list varchar(255) NOT NULL default '',
  402. PRIMARY KEY id_draft(id_draft),
  403. UNIQUE id_member (id_member, id_draft, type)
  404. ) ENGINE=MyISAM{$db_collation};
  405. ---#
  406. ---# Adding draft permissions...
  407. ---{
  408. // We cannot do this twice
  409. if (@$modSettings['smfVersion'] < '2.1')
  410. {
  411. // Anyone who can currently post unapproved topics we assume can create drafts as well ...
  412. $request = upgrade_query("
  413. SELECT id_group, id_board, add_deny, permission
  414. FROM {$db_prefix}board_permissions
  415. WHERE permission = 'post_unapproved_topics'");
  416. $inserts = array();
  417. while ($row = $smcFunc['db_fetch_assoc']($request))
  418. {
  419. $inserts[] = "($row[id_group], $row[id_board], 'post_draft', $row[add_deny])";
  420. $inserts[] = "($row[id_group], $row[id_board], 'post_autosave_draft', $row[add_deny])";
  421. }
  422. $smcFunc['db_free_result']($request);
  423. if (!empty($inserts))
  424. upgrade_query("
  425. INSERT IGNORE INTO {$db_prefix}board_permissions
  426. (id_group, id_board, permission, add_deny)
  427. VALUES
  428. " . implode(',', $inserts));
  429. // Next we find people who can send PMs, and assume they can save pm_drafts as well
  430. $request = upgrade_query("
  431. SELECT id_group, add_deny, permission
  432. FROM {$db_prefix}permissions
  433. WHERE permission = 'pm_send'");
  434. $inserts = array();
  435. while ($row = $smcFunc['db_fetch_assoc']($request))
  436. {
  437. $inserts[] = "($row[id_group], 'pm_draft', $row[add_deny])";
  438. $inserts[] = "($row[id_group], 'pm_autosave_draft', $row[add_deny])";
  439. }
  440. $smcFunc['db_free_result']($request);
  441. if (!empty($inserts))
  442. upgrade_query("
  443. INSERT IGNORE INTO {$db_prefix}permissions
  444. (id_group, permission, add_deny)
  445. VALUES
  446. " . implode(',', $inserts));
  447. }
  448. ---}
  449. INSERT INTO {$db_prefix}settings
  450. (variable, value)
  451. VALUES
  452. ('drafts_autosave_enabled', '1'),
  453. ('drafts_show_saved_enabled', '1'),
  454. ('drafts_keep_days', '7');
  455. INSERT INTO {$db_prefix}themes
  456. (id_theme, variable, value)
  457. VALUES
  458. ('1', 'drafts_autosave_enabled', '1'),
  459. ('1', 'drafts_show_saved_enabled', '1');
  460. ---#
  461. /******************************************************************************/
  462. --- Adding support for likes
  463. /******************************************************************************/
  464. ---# Creating likes table.
  465. CREATE TABLE IF NOT EXISTS {$db_prefix}user_likes (
  466. id_member mediumint(8) unsigned NOT NULL default '0',
  467. content_type char(6) default '',
  468. content_id int(10) unsigned NOT NULL default '0',
  469. like_time int(10) unsigned NOT NULL default '0',
  470. PRIMARY KEY (content_id, content_type, id_member),
  471. INDEX content (content_id, content_type),
  472. INDEX liker (id_member)
  473. ) ENGINE=MyISAM;
  474. ---#
  475. ---# Adding count to the messages table.
  476. ALTER TABLE {$db_prefix}messages
  477. ADD COLUMN likes smallint(5) unsigned NOT NULL DEFAULT '0';
  478. ---#
  479. /******************************************************************************/
  480. --- Adding support for group-based board moderation
  481. /******************************************************************************/
  482. ---# Creating moderator_groups table
  483. CREATE TABLE IF NOT EXISTS {$db_prefix}moderator_groups (
  484. id_board smallint(5) unsigned NOT NULL default '0',
  485. id_group smallint(5) unsigned NOT NULL default '0',
  486. PRIMARY KEY (id_board, id_group)
  487. ) ENGINE=MyISAM{$db_collation};
  488. ---#
  489. /******************************************************************************/
  490. --- Cleaning up integration hooks
  491. /******************************************************************************/
  492. ---# Deleting integration hooks
  493. DELETE FROM {$db_prefix}settings
  494. WHERE variable LIKE 'integrate_%';
  495. ---#
  496. /******************************************************************************/
  497. --- Cleaning up old settings
  498. /******************************************************************************/
  499. ---# Showing contact details to guests should never happen.
  500. DELETE FROM {$db_prefix}settings
  501. WHERE variable IN ('enableStickyTopics', 'guest_hideContacts', 'notify_new_registration', 'attachmentEncryptFilenames');
  502. ---#
  503. ---# Cleaning up old theme settings.
  504. DELETE FROM {$db_prefix}themes
  505. WHERE variable IN ('show_board_desc', 'no_new_reply_warning', 'display_quick_reply');
  506. ---#
  507. /******************************************************************************/
  508. --- Removing old Simple Machines files we do not need to fetch any more
  509. /******************************************************************************/
  510. ---# We no longer call on the latest packages list.
  511. DELETE FROM {$db_prefix}admin_info_files
  512. WHERE filename IN ('latest-packages.js', 'latest-support.js', 'latest-themes.js')
  513. AND path = '/smf/';
  514. ---#
  515. /******************************************************************************/
  516. --- Upgrading "verification questions" feature
  517. /******************************************************************************/
  518. ---# Creating qanda table
  519. CREATE TABLE IF NOT EXISTS {$db_prefix}qanda (
  520. id_question smallint(5) unsigned NOT NULL auto_increment,
  521. lngfile varchar(255) NOT NULL default '',
  522. question varchar(255) NOT NULL default '',
  523. answers text NOT NULL,
  524. PRIMARY KEY (id_question),
  525. KEY lngfile (lngfile)
  526. ) ENGINE=MyISAM{$db_collation};
  527. ---#
  528. ---# Moving questions and answers to the new table
  529. ---{
  530. $questions = array();
  531. $get_questions = upgrade_query("
  532. SELECT body AS question, recipient_name AS answer
  533. FROM {$db_prefix}log_comments
  534. WHERE comment_type = 'ver_test'");
  535. while ($row = $smcFunc['db_fetch_assoc']($get_questions))
  536. $questions[] = array($language, $row['question'], serialize(array($row['answer'])));
  537. $smcFunc['db_free_result']($get_questions);
  538. if (!empty($questions))
  539. {
  540. $smcFunc['db_insert']('',
  541. '{db_prefix}qanda',
  542. array('lngfile' => 'string', 'question' => 'string', 'answers' => 'string'),
  543. $questions,
  544. array('id_question')
  545. );
  546. // Delete the questions from log_comments now
  547. upgrade_query("
  548. DELETE FROM {$db_prefix}log_comments
  549. WHERE comment_type = 'ver_test'
  550. ");
  551. }
  552. ---}
  553. ---#
  554. /******************************************************************************/
  555. --- Marking packages as uninstalled...
  556. /******************************************************************************/
  557. ---# Updating log_packages
  558. UPDATE {$db_prefix}log_packages
  559. SET install_state = 0;
  560. ---#
  561. /******************************************************************************/
  562. --- Updating profile permissions...
  563. /******************************************************************************/
  564. ---# Removing the old "view your own profile" permission
  565. DELETE FROM {$db_prefix}permissions
  566. WHERE permission = 'profile_view_own';
  567. ---#
  568. ---# Updating the old "view any profile" permission
  569. UPDATE {$db_prefix}permissions
  570. SET permission = 'profile_view'
  571. WHERE permission = 'profile_view_any';
  572. ---#
  573. ---# Removing the old notification permissions
  574. DELETE FROM {$db_prefix}board_permissions
  575. WHERE permission = 'mark_notify' OR permission = 'mark_any_notify';
  576. ---#
  577. ---# Adding "profile_password_own"
  578. ---{
  579. $inserts = array();
  580. $request = upgrade_query("
  581. SELECT id_group, add_deny
  582. FROM {$db_prefix}permissions
  583. WHERE permission = 'profile_identity_own'");
  584. while ($row = $smcFunc['db_fetch_assoc']($request))
  585. {
  586. $inserts[] = "($row[id_group], 'profile_password_own', $row[add_deny])";
  587. }
  588. $smcFunc['db_free_result']($request);
  589. if (!empty($inserts))
  590. {
  591. upgrade_query("
  592. INSERT INTO {$db_prefix}permissions
  593. (id_group, permission, add_deny)
  594. VALUES
  595. " . implode(',', $inserts)
  596. );
  597. }
  598. ---}
  599. ---#
  600. ---# Adding other profile permissions
  601. ---{
  602. $inserts = array();
  603. $request = upgrade_query("
  604. SELECT id_group, add_deny
  605. FROM {$db_prefix}permissions
  606. WHERE permission = 'profile_extra_own'");
  607. while ($row = $smcFunc['db_fetch_assoc']($request))
  608. {
  609. $inserts[] = "($row[id_group], 'profile_blurb_own', $row[add_deny])";
  610. $inserts[] = "($row[id_group], 'profile_displayed_name_own', $row[add_deny])";
  611. $inserts[] = "($row[id_group], 'profile_forum_own', $row[add_deny])";
  612. $inserts[] = "($row[id_group], 'profile_other_own', $row[add_deny])";
  613. $inserts[] = "($row[id_group], 'profile_signature_own', $row[add_deny])";
  614. }
  615. $smcFunc['db_free_result']($request);
  616. if (!empty($inserts))
  617. {
  618. upgrade_query("
  619. INSERT INTO {$db_prefix}permissions
  620. (id_group, permission, add_deny)
  621. VALUES
  622. " . implode(',', $inserts)
  623. );
  624. }
  625. ---}
  626. ---#
  627. /******************************************************************************/
  628. --- Upgrading PM labels...
  629. /******************************************************************************/
  630. ---# Adding pm_labels table...
  631. CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labels (
  632. id_label int(10) unsigned NOT NULL auto_increment,
  633. id_member mediumint(8) unsigned NOT NULL default '0',
  634. name varchar(30) NOT NULL default '',
  635. PRIMARY KEY (id_label)
  636. ) ENGINE=MyISAM;
  637. ---#
  638. ---# Adding pm_labeled_messages table...
  639. CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labeled_messages (
  640. id_label int(10) unsigned NOT NULL default '0',
  641. id_pm int(10) unsigned NOT NULL default '0',
  642. PRIMARY KEY (id_label, id_pm)
  643. ) ENGINE=MyISAM;
  644. ---#
  645. ---# Adding "in_inbox" column to pm_recipients
  646. ALTER TABLE {$db_prefix}pm_recipients
  647. ADD COLUMN in_inbox tinyint(3) NOT NULL default '1';
  648. ---#
  649. ---# Moving label info to new tables and updating rules...
  650. ---{
  651. // First see if we still have a message_labels column
  652. $results = $smcFunc['db_list_columns']('{db_prefix}members');
  653. if (in_array('message_labels', $results))
  654. {
  655. // They've still got it, so pull the label info
  656. $get_labels = $smcFunc['db_query']('', '
  657. SELECT id_member, message_labels
  658. FROM {db_prefix}members
  659. WHERE message_labels != {string:blank}',
  660. array(
  661. 'blank' => '',
  662. )
  663. );
  664. $inserts = array();
  665. $label_info = array();
  666. while ($row = $smcFunc['db_fetch_assoc']($get_labels))
  667. {
  668. // Stick this in an array
  669. $labels = explode(',', $row['message_labels']);
  670. // Build some inserts
  671. foreach ($labels AS $index => $label)
  672. {
  673. // Keep track of the index of this label - we'll need that in a bit...
  674. $label_info[$row['id_member']][$label] = $index;
  675. $inserts[] = array($row['id_member'], $label);
  676. }
  677. }
  678. $smcFunc['db_free_result']($get_labels);
  679. if (!empty($inserts))
  680. {
  681. $smcFunc['db_insert']('', '{db_prefix}pm_labels', array('id_member' => 'int', 'name' => 'string-30'), $inserts, array());
  682. // Clear this out for our next query below
  683. $inserts = array();
  684. }
  685. // This is the easy part - update the inbox stuff
  686. $smcFunc['db_query']('', '
  687. UPDATE {db_prefix}pm_recipients
  688. SET in_inbox = {int:in_inbox}
  689. WHERE FIND_IN_SET({int:minusone}, labels)',
  690. array(
  691. 'in_inbox' => 1,
  692. 'minusone' => -1,
  693. )
  694. );
  695. // Now we go pull the new IDs for each label
  696. $get_new_label_ids = $smcFunc['db_query']('', '
  697. SELECT *
  698. FROM {db_prefix}pm_labels',
  699. array(
  700. )
  701. );
  702. $label_info_2 = array();
  703. while ($label_row = $smcFunc['db_fetch_assoc']($get_new_label_ids))
  704. {
  705. // Map the old index values to the new ID values...
  706. $old_index = $label_info[$row['id_member']][$row['label_name']];
  707. $label_info_2[$row['id_member']][$old_index] = $row['id_label'];
  708. }
  709. $smcFunc['db_free_result']($get_new_label_ids);
  710. // Pull label info from pm_recipients
  711. // Ignore any that are only in the inbox
  712. $get_pm_labels = $smcFunc['db_query']('', '
  713. SELECT id_pm, id_member, labels
  714. FROM {db_prefix}pm_recipients
  715. WHERE deleted = {int:not_deleted}
  716. AND labels != {string:minus_one}',
  717. array(
  718. 'not_deleted' => 0,
  719. 'minus_one' => -1,
  720. )
  721. );
  722. while ($row = $smcFunc['db_fetch_assoc']($get_pm_labels))
  723. {
  724. $labels = explode(',', $row['labels']);
  725. foreach ($labels as $a_label)
  726. {
  727. if ($a_label == '-1')
  728. continue;
  729. $new_label_info = $label_info_2[$row['id_member']][$a_label];
  730. $inserts[] = array($row['id_pm'], $new_label_info);
  731. }
  732. }
  733. $smcFunc['db_free_result']($get_pm_labels);
  734. // Insert the new data
  735. if (!empty($inserts))
  736. {
  737. $smcFunc['db_insert']('', '{db_prefix}pm_labeled_messages', array('id_pm' => 'int', 'id_label' => 'int'), $inserts, array());
  738. }
  739. // Final step of this ridiculously massive process
  740. $get_pm_rules = $smcFunc['db_query']('', '
  741. SELECT id_member, id_rule, actions
  742. FROM {db_prefix}pm_rules',
  743. array(
  744. )
  745. );
  746. // Go through the rules, unserialize the actions, then figure out if there's anything we can use
  747. while ($row = $smcFunc['db_fetch_assoc']($get_pm_rules))
  748. {
  749. // Turn this into an array...
  750. $actions = unserialize($row['actions']);
  751. // Loop through the actions and see if we're applying a label anywhere
  752. foreach ($actions as $index => $action)
  753. {
  754. if ($action['t'] == 'lab')
  755. {
  756. // Update the value of this label...
  757. $actions[$index]['v'] = $label_info_2[$row['id_member']][$action['v']];
  758. }
  759. }
  760. // Put this back into a string
  761. $actions = serialize($actions);
  762. $smcFunc['db_query']('', '
  763. UPDATE {db_prefix}pm_rules
  764. SET actions = {string:actions}
  765. WHERE id_rule = {int:id_rule}',
  766. array(
  767. 'actions' => $actions,
  768. 'id_rule' => $row['id_rule'],
  769. )
  770. );
  771. }
  772. $smcFunc['db_free_result']($get_pm_rules);
  773. // Lastly, we drop the old columns
  774. $smcFunc['db_remove_column']('{db_prefix}members', 'message_labels');
  775. $smcFunc['db_remove_column']('{db_prefix}pm_recipients', 'labels');
  776. }
  777. ---}
  778. ---#
  779. /******************************************************************************/
  780. --- Adding support for edit reasons
  781. /******************************************************************************/
  782. ---# Adding "modified_reason" column to messages
  783. ALTER TABLE {$db_prefix}messages
  784. ADD COLUMN modified_reason varchar(255) NOT NULL;
  785. ---#
  786. /******************************************************************************/
  787. --- Cleaning up guest permissions
  788. /******************************************************************************/
  789. ---# Removing permissions guests can no longer have...
  790. ---{
  791. $illegal_board_permissions = array(
  792. 'announce_topic',
  793. 'delete_any',
  794. 'lock_any',
  795. 'make_sticky',
  796. 'merge_any',
  797. 'modify_any',
  798. 'modify_replies',
  799. 'move_any',
  800. 'poll_add_any',
  801. 'poll_edit_any',
  802. 'poll_lock_any',
  803. 'poll_remove_any',
  804. 'remove_any',
  805. 'report_any',
  806. 'split_any'
  807. );
  808. $illegal_permissions = array('calendar_edit_any', 'moderate_board', 'moderate_forum', 'send_email_to_members');
  809. $smcFunc['db_query']('', '
  810. DELETE FROM {db_prefix}board_permissions
  811. WHERE id_group = {int:guests}
  812. AND permission IN ({array_string:illegal_board_perms})',
  813. array(
  814. 'guests' => -1,
  815. 'illegal_board_perms' => $illegal_board_permissions,
  816. )
  817. );
  818. $smcFunc['db_query']('', '
  819. DELETE FROM {db_prefix}permissions
  820. WHERE id_group = {int:guests}
  821. AND permission IN ({array_string:illegal_perms})',
  822. array(
  823. 'guests' => -1,
  824. 'illegal_perms' => $illegal_permissions,
  825. )
  826. );
  827. ---}
  828. ---#
  829. /******************************************************************************/
  830. --- Adding mail queue settings
  831. /******************************************************************************/
  832. ---#
  833. ---{
  834. if (empty($modSettings['mail_limit']))
  835. {
  836. $smcFunc['db_insert']('replace',
  837. '{db_prefix}settings',
  838. array('variable' => 'string-255', 'value' => 'string'),
  839. array(
  840. array('mail_limit', '5'),
  841. array('mail_quantity', '5'),
  842. ),
  843. array('variable')
  844. );
  845. }
  846. ---}
  847. ---#