upgrade_2-1_mysql.sql 29 KB

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