upgrade_2-1_sqlite.sql 25 KB

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