upgrade_2-1_sqlite.sql 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149
  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 = $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 smallint unsigned NOT NULL default '0',
  168. ADD COLUMN id_member_acted int unsigned NOT NULL default '0',
  169. ADD COLUMN member_name_acted varchar(255) NOT NULL default '',
  170. ADD COLUMN time_acted int unsigned NOT NULL default '0',
  171. ADD COLUMN act_reason text NOT NULL;
  172. ---#
  173. ---# Adjusting the indexes for log_group_requests
  174. DROP INDEX {$db_prefix}log_group_requests_id_member;
  175. CREATE INDEX {$db_prefix}log_group_requests_id_member ON {$db_prefix}log_group_requests (id_member, id_group);
  176. ---#
  177. /******************************************************************************/
  178. --- Adding support for <credits> tag in package manager
  179. /******************************************************************************/
  180. ---# Adding new columns to log_packages ..
  181. ALTER TABLE {$db_prefix}log_packages
  182. ADD COLUMN credits varchar(255) NOT NULL DEFAULT '';
  183. ---#
  184. /******************************************************************************/
  185. --- Adding more space for session ids
  186. /******************************************************************************/
  187. ---# Altering the session_id columns...
  188. ALTER TABLE {$db_prefix}log_online
  189. CHANGE `session` `session` varchar(64) NOT NULL DEFAULT '';
  190. ALTER TABLE {$db_prefix}log_errors
  191. CHANGE `session` `session` char(64) NOT NULL default ' ';
  192. ALTER TABLE {$db_prefix}sessions
  193. CHANGE `session_id` `session_id` char(64) NOT NULL;
  194. ---#
  195. /******************************************************************************/
  196. --- Adding new columns for MOVED topic updates
  197. /******************************************************************************/
  198. ---# Adding new custom fields columns.
  199. ---{
  200. $smcFunc['db_alter_table']('{db_prefix}topics', array(
  201. 'add' => array(
  202. 'redirect_expires' => array(
  203. 'name' => 'redirect_expires',
  204. 'null' => false,
  205. 'default' => '0',
  206. 'type' => 'int',
  207. 'auto' => false,
  208. ),
  209. )
  210. ));
  211. $smcFunc['db_alter_table']('{db_prefix}topics', array(
  212. 'add' => array(
  213. 'id_redirect_topic' => array(
  214. 'name' => 'id_redirect_topic',
  215. 'null' => false,
  216. 'default' => '0',
  217. 'type' => 'int',
  218. 'auto' => false,
  219. ),
  220. )
  221. ));
  222. ---}
  223. ---#
  224. /******************************************************************************/
  225. --- Adding new scheduled tasks
  226. /******************************************************************************/
  227. ---# Adding new scheduled tasks
  228. INSERT INTO {$db_prefix}scheduled_tasks
  229. (next_time, time_offset, time_regularity, time_unit, disabled, task)
  230. VALUES
  231. (0, 120, 1, 'd', 0, 'remove_temp_attachments');
  232. INSERT INTO {$db_prefix}scheduled_tasks
  233. (next_time, time_offset, time_regularity, time_unit, disabled, task)
  234. VALUES
  235. (0, 180, 1, 'd', 0, 'remove_topic_redirect');
  236. INSERT INTO {$db_prefix}scheduled_tasks
  237. (next_time, time_offset, time_regularity, time_unit, disabled, task)
  238. VALUES
  239. (0, 240, 1, 'd', 0, 'remove_old_drafts');
  240. ---#
  241. /******************************************************************************/
  242. ---- Adding background tasks support
  243. /******************************************************************************/
  244. ---# Adding the new table
  245. CREATE TABLE IF NOT EXISTS {$db_prefix}background_tasks (
  246. id_task integer primary key,
  247. task_file varchar(255) NOT NULL default '',
  248. task_class varchar(255) NOT NULL default '',
  249. task_data text NOT NULL,
  250. claimed_time int NOT NULL default '0',
  251. PRIMARY KEY (id_task)
  252. );
  253. ---#
  254. /******************************************************************************/
  255. ---- Replacing MSN with Skype
  256. /******************************************************************************/
  257. ---# Modifying the "msn" column...
  258. ALTER TABLE {$db_prefix}members
  259. CHANGE msn skype varchar(255) NOT NULL DEFAULT '';
  260. ---#
  261. /******************************************************************************/
  262. --- Adding support for deny boards access
  263. /******************************************************************************/
  264. ---# Adding new columns to boards...
  265. ---{
  266. $smcFunc['db_alter_table']('{db_prefix}boards', array(
  267. 'add' => array(
  268. 'deny_member_groups' => array(
  269. 'name' => 'deny_member_groups',
  270. 'null' => false,
  271. 'default' => '',
  272. 'type' => varchar,
  273. 'size' => 255,
  274. 'auto' => false,
  275. ),
  276. )
  277. ));
  278. ---}
  279. ---#
  280. /******************************************************************************/
  281. --- Updating board access rules
  282. /******************************************************************************/
  283. ---# Updating board access rules
  284. ---{
  285. $member_groups = array(
  286. 'allowed' => array(),
  287. 'denied' => array(),
  288. );
  289. $request = $smcFunc['db_query']('', '
  290. SELECT id_group, add_deny
  291. FROM {db_prefix}permissions
  292. WHERE permission = {string:permission}',
  293. array(
  294. 'permission' => 'manage_boards',
  295. )
  296. );
  297. while ($row = $smcFunc['db_fetch_assoc']($request))
  298. $member_groups[$row['add_deny'] === '1' ? 'allowed' : 'denied'][] = $row['id_group'];
  299. $smcFunc['db_free_result']($request);
  300. $member_groups = array_diff($member_groups['allowed'], $member_groups['denied']);
  301. if (!empty($member_groups))
  302. {
  303. $count = count($member_groups);
  304. $changes = array();
  305. $request = $smcFunc['db_query']('', '
  306. SELECT id_board, member_groups
  307. FROM {db_prefix}boards');
  308. while ($row = $smcFunc['db_fetch_assoc']($request))
  309. {
  310. $current_groups = explode(',', $row['member_groups']);
  311. if (count(array_intersect($current_groups, $member_groups)) != $count)
  312. {
  313. $new_groups = array_unique(array_merge($current_groups, $member_groups));
  314. $changes[$row['id_board']] = implode(',', $new_groups);
  315. }
  316. }
  317. $smcFunc['db_free_result']($request);
  318. if (!empty($changes))
  319. {
  320. foreach ($changes as $id_board => $member_groups)
  321. $smcFunc['db_query']('', '
  322. UPDATE {db_prefix}boards
  323. SET member_groups = {string:member_groups}
  324. WHERE id_board = {int:id_board}',
  325. array(
  326. 'member_groups' => $member_groups,
  327. 'id_board' => $id_board,
  328. )
  329. );
  330. }
  331. }
  332. ---}
  333. ---#
  334. /******************************************************************************/
  335. --- Adding support for category descriptions
  336. /******************************************************************************/
  337. ---# Adding new columns to categories...
  338. ---{
  339. $smcFunc['db_alter_table']('{db_prefix}log_topics', array(
  340. 'add' => array(
  341. 'description' => array(
  342. 'name' => 'description',
  343. 'null' => false,
  344. 'type' => 'text',
  345. 'auto' => false,
  346. ),
  347. )
  348. ));
  349. ---}
  350. ---#
  351. /******************************************************************************/
  352. --- Adding support for alerts
  353. /******************************************************************************/
  354. ---# Adding the count to the members table...
  355. ---{
  356. $smcFunc['db_alter_table']('{db_prefix}members', array(
  357. 'add' => array(
  358. 'alerts' => array(
  359. 'name' => 'ualerts',
  360. 'null' => false,
  361. 'default' => 0,
  362. 'type' => 'int',
  363. 'auto' => false,
  364. ),
  365. )
  366. ));
  367. ---}
  368. ---#
  369. ---# Adding the new table for alerts.
  370. CREATE TABLE IF NOT EXISTS {$db_prefix}user_alerts (
  371. id_alert int primary key,
  372. alert_time int unsigned NOT NULL default '0',
  373. id_member int unsigned NOT NULL default '0',
  374. id_member_started int unsigned NOT NULL default '0',
  375. member_name varchar(255) NOT NULL default '',
  376. content_type varchar(255) NOT NULL default '',
  377. content_id int unsigned NOT NULL default '0',
  378. content_action varchar(255) NOT NULL default '',
  379. is_read smallint unsigned NOT NULL default '0',
  380. extra text NOT NULL,
  381. PRIMARY KEY (id_alert)
  382. );
  383. CREATE INDEX {$db_prefix}user_alerts_id_member ON {$db_prefix}user_alerts (id_member);
  384. CREATE INDEX {$db_prefix}user_alerts_alert_time ON {$db_prefix}user_alerts (alert_time);
  385. ---#
  386. ---# Adding alert preferences.
  387. CREATE TABLE IF NOT EXISTS {$db_prefix}user_alerts_prefs (
  388. id_member int unsigned NOT NULL default '0',
  389. alert_pref varchar(32) NOT NULL default '',
  390. alert_value tinyint(3) NOT NULL default '0',
  391. PRIMARY KEY (id_member, alert_pref)
  392. );
  393. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'member_group_request', 1);
  394. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'member_register', 1);
  395. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'msg_like', 1);
  396. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'msg_report', 1);
  397. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'msg_report_reply', 1);
  398. ---#
  399. /******************************************************************************/
  400. --- Adding support for topic unwatch
  401. /******************************************************************************/
  402. ---# Adding new columns to log_topics...
  403. ---{
  404. $smcFunc['db_alter_table']('{db_prefix}log_topics', array(
  405. 'add' => array(
  406. 'unwatched' => array(
  407. 'name' => 'unwatched',
  408. 'null' => false,
  409. 'default' => 0,
  410. 'type' => 'int',
  411. 'auto' => false,
  412. ),
  413. )
  414. ));
  415. UPDATE {$db_prefix}log_topics
  416. SET unwatched = 0;
  417. INSERT INTO {$db_prefix}settings
  418. (variable, value)
  419. VALUES
  420. ('enable_unwatch', 0);
  421. ---}
  422. ---#
  423. ---# Fixing column name change...
  424. ---{
  425. $smcFunc['db_alter_table']('{db_prefix}log_topics', array(
  426. 'change' => array(
  427. 'disregarded' => array(
  428. 'name' => 'unwatched',
  429. 'null' => false,
  430. 'default' => 0,
  431. 'type' => 'int',
  432. 'auto' => false,
  433. ),
  434. )
  435. ));
  436. ---}
  437. ---#
  438. /******************************************************************************/
  439. --- Name changes
  440. /******************************************************************************/
  441. ---# Altering the membergroup stars to icons
  442. ---{
  443. upgrade_query("
  444. ALTER TABLE {$db_prefix}membergroups
  445. CHANGE `stars` `icons` varchar(255) NOT NULL DEFAULT ''");
  446. ---}
  447. ---#
  448. ---# Renaming default theme...
  449. UPDATE {$db_prefix}themes
  450. SET value = 'SMF Default Theme - Curve2'
  451. WHERE value LIKE 'SMF Default Theme%';
  452. ---#
  453. ---# Adding the enableThemes setting.
  454. INSERT INTO {$db_prefix}settings
  455. (variable, value)
  456. VALUES
  457. ('enableThemes', '1');
  458. ---#
  459. ---# Setting "default" as the default...
  460. UPDATE {$db_prefix}settings
  461. SET value = '1'
  462. WHERE variable = 'theme_guests';
  463. UPDATE {$db_prefix}boards
  464. SET id_theme = 0;
  465. UPDATE {$db_prefix}members
  466. SET id_theme = 0;
  467. ---#
  468. /******************************************************************************/
  469. --- Cleaning up after old themes...
  470. /******************************************************************************/
  471. ---# Checking for "core" and removing it if necessary...
  472. ---{
  473. // Do they have "core" installed?
  474. if (file_exists($GLOBALS['boarddir'] . '/Themes/core'))
  475. {
  476. $core_dir = $GLOBALS['boarddir'] . '/Themes/core';
  477. $theme_request = upgrade_query("
  478. SELECT id_theme
  479. FROM {$db_prefix}themes
  480. WHERE variable = 'theme_dir'
  481. AND value ='$core_dir'");
  482. // Don't do anything if this theme is already uninstalled
  483. if ($smcFunc['db_num_rows']($theme_request) == 1)
  484. {
  485. list($id_theme) = $smcFunc['db_fetch_row']($theme_request, 0);
  486. $smcFunc['db_free_result']($theme_request);
  487. $known_themes = explode(', ', $modSettings['knownThemes']);
  488. // Remove this value...
  489. $known_themes = array_diff($known_themes, array($id_theme));
  490. // Change back to a string...
  491. $known_themes = implode(', ', $known_themes);
  492. // Update the database
  493. upgrade_query("
  494. UPDATE {$db_prefix}settings
  495. SET value = '$known_themes'
  496. WHERE variable = 'knownThemes'");
  497. // Delete any info about this theme
  498. upgrade_query("
  499. DELETE FROM {$db_prefix}themes
  500. WHERE id_theme = $id_theme");
  501. }
  502. }
  503. /******************************************************************************/
  504. --- Adding support for drafts
  505. /******************************************************************************/
  506. ---# Creating drafts table.
  507. CREATE TABLE IF NOT EXISTS {$db_prefix}user_drafts (
  508. id_draft int unsigned NOT NULL auto_increment,
  509. id_topic int unsigned NOT NULL default '0',
  510. id_board smallint unsigned NOT NULL default '0',
  511. id_reply int unsigned NOT NULL default '0',
  512. type smallint NOT NULL default '0',
  513. poster_time int unsigned NOT NULL default '0',
  514. id_member int unsigned NOT NULL default '0',
  515. subject varchar(255) NOT NULL default '',
  516. smileys_enabled smallint NOT NULL default '1',
  517. body text NOT NULL,
  518. icon varchar(16) NOT NULL default 'xx',
  519. locked smallint NOT NULL default '0',
  520. is_sticky smallint NOT NULL default '0',
  521. to_list varchar(255) NOT NULL default '',
  522. PRIMARY KEY (id_draft)
  523. );
  524. CREATE UNIQUE INDEX {$db_prefix}user_drafts_id_member ON {$db_prefix}user_drafts (id_member, id_draft, type);
  525. ---#
  526. ---# Adding draft permissions...
  527. ---{
  528. // We cannot do this twice
  529. if (@$modSettings['smfVersion'] < '2.1')
  530. {
  531. // Anyone who can currently post unapproved topics we assume can create drafts as well ...
  532. $request = upgrade_query("
  533. SELECT id_group, id_board, add_deny, permission
  534. FROM {$db_prefix}board_permissions
  535. WHERE permission = 'post_unapproved_topics'");
  536. $inserts = array();
  537. while ($row = $smcFunc['db_fetch_assoc']($request))
  538. {
  539. $inserts[] = "($row[id_group], $row[id_board], 'post_draft', $row[add_deny])";
  540. $inserts[] = "($row[id_group], $row[id_board], 'post_autosave_draft', $row[add_deny])";
  541. }
  542. $smcFunc['db_free_result']($request);
  543. if (!empty($inserts))
  544. {
  545. foreach ($inserts AS $insert)
  546. {
  547. upgrade_query("
  548. INSERT INTO {$db_prefix}board_permissions
  549. (id_group, id_board, permission, add_deny)
  550. VALUES
  551. " . $insert);
  552. }
  553. }
  554. // Next we find people who can send PMs, and assume they can save pm_drafts as well
  555. $request = upgrade_query("
  556. SELECT id_group, add_deny, permission
  557. FROM {$db_prefix}permissions
  558. WHERE permission = 'pm_send'");
  559. $inserts = array();
  560. while ($row = $smcFunc['db_fetch_assoc']($request))
  561. {
  562. $inserts[] = "($row[id_group], 'pm_draft', $row[add_deny])";
  563. $inserts[] = "($row[id_group], 'pm_autosave_draft', $row[add_deny])";
  564. }
  565. $smcFunc['db_free_result']($request);
  566. if (!empty($inserts))
  567. {
  568. foreach ($inserts AS $insert)
  569. {
  570. upgrade_query("
  571. INSERT INTO {$db_prefix}permissions
  572. (id_group, permission, add_deny)
  573. VALUES
  574. " . $insert);
  575. }
  576. }
  577. }
  578. ---}
  579. INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_autosave_enabled', '1');
  580. INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_show_saved_enabled', '1');
  581. INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_keep_days', '7');
  582. INSERT INTO {$db_prefix}themes (id_theme, variable, value) VALUES ('1', 'drafts_autosave_enabled', '1');
  583. INSERT INTO {$db_prefix}themes (id_theme, variable, value) VALUES ('1', 'drafts_show_saved_enabled', '1');
  584. ---#
  585. /******************************************************************************/
  586. --- Adding support for likes
  587. /******************************************************************************/
  588. ---# Creating likes table.
  589. CREATE TABLE IF NOT EXISTS {$db_prefix}user_likes (
  590. id_member int NOT NULL default '0',
  591. content_type char(6) default '',
  592. content_id int NOT NULL default '0',
  593. like_time int NOT NULL default '0',
  594. PRIMARY KEY (content_id, content_type, id_member)
  595. );
  596. CREATE INDEX {$db_prefix}user_likes_content ON {$db_prefix}user_likes (content_id, content_type);
  597. CREATE INDEX {$db_prefix}user_likes_liker ON {$db_prefix}user_likes (id_member);
  598. ---#
  599. ---# Adding count to the messages table.
  600. ALTER TABLE {$db_prefix}messages
  601. ADD COLUMN likes smallint NOT NULL default '0';
  602. ---#
  603. /******************************************************************************/
  604. --- Adding support for group-based board moderation
  605. /******************************************************************************/
  606. ---# Creating moderator_groups table
  607. CREATE TABLE IF NOT EXISTS {$db_prefix}moderator_groups (
  608. id_board smallint NOT NULL default '0',
  609. id_group smallint NOT NULL default '0',
  610. PRIMARY KEY (id_board, id_group)
  611. );
  612. ---#
  613. /******************************************************************************/
  614. --- Cleaning up integration hooks
  615. /******************************************************************************/
  616. ---#
  617. DELETE FROM {$db_prefix}settings
  618. WHERE variable LIKE 'integrate_%';
  619. ---#
  620. /******************************************************************************/
  621. --- Cleaning up old settings
  622. /******************************************************************************/
  623. ---# Updating the default time format
  624. ---{
  625. if (!empty($modSettings['time_format']))
  626. {
  627. // First, use the shortened form of the month in the date.
  628. $time_format = str_replace('%B', '%b', $modSettings['time_format']);
  629. // Second, shorten the time to stop including seconds.
  630. $time_format = str_replace(':%S', '', $time_format);
  631. // Then, update the database.
  632. $smcFunc['db_query']('', '
  633. UPDATE {db_prefix}settings
  634. SET value = {string:new_format}
  635. WHERE variable = {literal:time_format}',
  636. array(
  637. 'new_format' => $time_format,
  638. )
  639. );
  640. }
  641. ---}
  642. ---#
  643. ---# Fixing a deprecated option.
  644. UPDATE {$db_prefix}settings
  645. SET value = 'option_css_resize'
  646. WHERE variable = 'avatar_action_too_large'
  647. AND (value = 'option_html_resize' OR value = 'option_js_resize');
  648. ---#
  649. ---# Cleaning up old settings.
  650. DELETE FROM {$db_prefix}settings
  651. WHERE variable IN ('enableStickyTopics', 'guest_hideContacts', 'notify_new_registration', 'attachmentEncryptFilenames', 'hotTopicPosts', 'hotTopicVeryPosts', 'fixLongWords');
  652. ---#
  653. ---# Cleaning up old theme settings.
  654. DELETE FROM {$db_prefix}themes
  655. WHERE variable IN ('show_board_desc', 'no_new_reply_warning', 'display_quick_reply', 'show_mark_read');
  656. ---#
  657. /******************************************************************************/
  658. --- Updating files that fetched from simplemachines.org
  659. /******************************************************************************/
  660. ---# We no longer call on several files.
  661. DELETE FROM {$db_prefix}admin_info_files
  662. WHERE filename IN ('latest-packages.js', 'latest-support.js', 'latest-themes.js')
  663. AND path = '/smf/';
  664. ---#
  665. ---# But we do need new files.
  666. ---{
  667. $smcFunc['db_insert']('',
  668. '{db_prefix}admin_info_files',
  669. array('filename' => 'string', 'path' => 'string', 'parameters' => 'string', 'data' => 'string', 'filetype' => 'string'),
  670. array('latest-versions.txt', '/smf/', 'version=%3$s', '', 'text/plain'),
  671. array('id_file')
  672. );
  673. ---}
  674. ---#
  675. /******************************************************************************/
  676. --- Upgrading "verification questions" feature
  677. /******************************************************************************/
  678. ---# Creating qanda table
  679. CREATE TABLE IF NOT EXISTS {$db_prefix}qanda (
  680. id_question smallint(5) unsigned NOT NULL auto_increment,
  681. lngfile varchar(255) NOT NULL default '',
  682. question varchar(255) NOT NULL default '',
  683. answers text NOT NULL,
  684. PRIMARY KEY (id_question),
  685. KEY lngfile (lngfile)
  686. );
  687. ---#
  688. ---# Moving questions and answers to the new table
  689. ---{
  690. $questions = array();
  691. $get_questions = upgrade_query("
  692. SELECT body AS question, recipient_name AS answer
  693. FROM {$db_prefix}log_comments
  694. WHERE comment_type = 'ver_test'");
  695. while ($row = $smcFunc['db_fetch_assoc']($get_questions))
  696. $questions[] = array($language, $row['question'], serialize(array($row['answer'])));
  697. $smcFunc['db_free_result']($get_questions);
  698. if (!empty($questions))
  699. {
  700. $smcFunc['db_insert']('',
  701. '{db_prefix}qanda',
  702. array('lngfile' => 'string', 'question' => 'string', 'answers' => 'string'),
  703. $questions,
  704. array('id_question')
  705. );
  706. // Delete the questions from log_comments now
  707. upgrade_query("
  708. DELETE FROM {$db_prefix}log_comments
  709. WHERE comment_type = 'ver_test'
  710. ");
  711. }
  712. ---}
  713. ---#
  714. /******************************************************************************/
  715. --- Marking packages as uninstalled...
  716. /******************************************************************************/
  717. ---# Updating log_packages
  718. UPDATE {$db_prefix}log_packages
  719. SET install_state = 0;
  720. ---#
  721. /******************************************************************************/
  722. --- Updating profile permissions...
  723. /******************************************************************************/
  724. ---# Removing the old "view your own profile" permission
  725. DELETE FROM {$db_prefix}permissions
  726. WHERE permission = 'profile_view_own';
  727. ---#
  728. ---# Updating the old "view any profile" permission
  729. UPDATE {$db_prefix}permissions
  730. SET permission = 'profile_view'
  731. WHERE permission = 'profile_view_any';
  732. ---#
  733. ---# Removing the old notification permissions
  734. DELETE FROM {$db_prefix}board_permissions
  735. WHERE permission = 'mark_notify' OR permission = 'mark_any_notify';
  736. ---#
  737. ---# Adding "profile_password_own"
  738. ---{
  739. $inserts = array();
  740. $request = upgrade_query("
  741. SELECT id_group, add_deny
  742. FROM {$db_prefix}permissions
  743. WHERE permission = 'profile_identity_own'");
  744. while ($row = $smcFunc['db_fetch_assoc']($request))
  745. {
  746. $inserts[] = "($row[id_group], 'profile_password_own', $row[add_deny])";
  747. }
  748. $smcFunc['db_free_result']($request);
  749. if (!empty($inserts))
  750. {
  751. foreach ($inserts as $insert)
  752. {
  753. upgrade_query("
  754. INSERT INTO {$db_prefix}permissions
  755. (id_group, permission, add_deny)
  756. VALUES
  757. " . $insert);
  758. }
  759. }
  760. ---}
  761. ---#
  762. ---# Adding other profile permissions
  763. ---{
  764. $inserts = array();
  765. $request = upgrade_query("
  766. SELECT id_group, add_deny
  767. FROM {$db_prefix}permissions
  768. WHERE permission = 'profile_extra_own'");
  769. while ($row = $smcFunc['db_fetch_assoc']($request))
  770. {
  771. $inserts[] = "($row[id_group], 'profile_blurb_own', $row[add_deny])";
  772. $inserts[] = "($row[id_group], 'profile_displayed_name_own', $row[add_deny])";
  773. $inserts[] = "($row[id_group], 'profile_forum_own', $row[add_deny])";
  774. $inserts[] = "($row[id_group], 'profile_other_own', $row[add_deny])";
  775. $inserts[] = "($row[id_group], 'profile_signature_own', $row[add_deny])";
  776. }
  777. $smcFunc['db_free_result']($request);
  778. if (!empty($inserts))
  779. {
  780. foreach ($inserts as $insert)
  781. {
  782. upgrade_query("
  783. INSERT INTO {$db_prefix}permissions
  784. (id_group, permission, add_deny)
  785. VALUES
  786. " . $insert);
  787. }
  788. }
  789. ---}
  790. ---#
  791. /******************************************************************************/
  792. --- Upgrading PM labels...
  793. /******************************************************************************/
  794. ---# Adding pm_labels table...
  795. CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labels (
  796. id_label integer primary key,
  797. id_member int NOT NULL default '0',
  798. name varchar(30) NOT NULL default '',
  799. );
  800. ---#
  801. ---# Adding pm_labeled_messages table...
  802. CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labeled_messages (
  803. id_label int NOT NULL default '0',
  804. id_pm int NOT NULL default '0',
  805. PRIMARY KEY (id_label, id_pm)
  806. );
  807. ---#
  808. ---# Adding "in_inbox" column to pm_recipients
  809. ALTER TABLE {$db_prefix}pm_recipients
  810. ADD COLUMN in_inbox tinyint(3) NOT NULL default '1';
  811. ---#
  812. ---# Moving label info to new tables and updating rules...
  813. ---{
  814. // First see if we still have a message_labels column
  815. $results = $smcFunc['db_list_columns']('{db_prefix}members');
  816. if (in_array('message_labels', $results))
  817. {
  818. // They've still got it, so pull the label info
  819. $get_labels = $smcFunc['db_query']('', '
  820. SELECT id_member, message_labels
  821. FROM {db_prefix}members
  822. WHERE message_labels != {string:blank}',
  823. array(
  824. 'blank' => '',
  825. )
  826. );
  827. $inserts = array();
  828. $label_info = array();
  829. while ($row = $smcFunc['db_fetch_assoc']($get_labels))
  830. {
  831. // Stick this in an array
  832. $labels = explode(',', $row['message_labels']);
  833. // Build some inserts
  834. foreach ($labels AS $index => $label)
  835. {
  836. // Keep track of the index of this label - we'll need that in a bit...
  837. $label_info[$row['id_member']][$label] = $index;
  838. $inserts[] = array($row['id_member'], $label);
  839. }
  840. }
  841. $smcFunc['db_free_result']($get_labels);
  842. if (!empty($inserts))
  843. {
  844. $smcFunc['db_insert']('', '{db_prefix}pm_labels', array('id_member' => 'int', 'name' => 'int'), $inserts, array());
  845. // Clear this out for our next query below
  846. $inserts = array();
  847. }
  848. // This is the easy part - update the inbox stuff
  849. $smcFunc['db_query']('', '
  850. UPDATE {db_prefix}pm_recipients
  851. SET in_inbox = {int:in_inbox}
  852. WHERE FIND_IN_SET({int:minus_one}, labels)',
  853. array(
  854. 'in_inbox' => 1,
  855. 'minus_one' => -1,
  856. )
  857. );
  858. // Now we go pull the new IDs for each label
  859. $get_new_label_ids = $smcFunc['db_query']('', '
  860. SELECT *
  861. FROM {db_prefix}pm_labels',
  862. array(
  863. )
  864. );
  865. $label_info_2 = array();
  866. while ($label_row = $smcFunc['db_fetch_assoc']($get_new_label_ids))
  867. {
  868. // Map the old index values to the new ID values...
  869. $old_index = $label_info[$row['id_member']][$row['label_name']];
  870. $label_info_2[$row['id_member']][$old_index] = $row['id_label'];
  871. }
  872. $smcFunc['db_free_result']($get_new_label_ids);
  873. // Pull label info from pm_recipients
  874. // Ignore any that are only in the inbox
  875. $get_pm_labels = $smcFunc['db_query']('', '
  876. SELECT id_pm, id_member, labels
  877. FROM {db_prefix}pm_recipients
  878. WHERE deleted = {int:not_deleted}
  879. AND labels != {string:minus_one}',
  880. array(
  881. 'not_deleted' => 0,
  882. 'minus_one' => -1,
  883. )
  884. );
  885. while ($row = $smcFunc['db_fetch_assoc']($get_pm_labels))
  886. {
  887. $labels = explode(',', $row['labels']);
  888. foreach ($labels as $a_label)
  889. {
  890. if ($a_label == '-1')
  891. continue;
  892. $new_label_info = $label_info_2[$row['id_member']][$a_label];
  893. $inserts[] = array($row['id_pm'], $new_label_info);
  894. }
  895. }
  896. $smcFunc['db_free_result']($get_pm_labels);
  897. // Insert the new data
  898. if (!empty($inserts))
  899. {
  900. $smcFunc['db_insert']('', '{db_prefix}pm_labeled_messages', array('id_pm', 'id_label'), $inserts, array());
  901. }
  902. // Final step of this ridiculously massive process
  903. $get_pm_rules = $smcFunc['db_query']('', '
  904. SELECT id_member, id_rule, actions
  905. FROM {db_prefix}pm_rules',
  906. array(
  907. ),
  908. );
  909. // Go through the rules, unserialize the actions, then figure out if there's anything we can use
  910. while ($row = $smcFunc['db_fetch_assoc']($get_pm_rules))
  911. {
  912. // Turn this into an array...
  913. $actions = unserialize($row['actions']);
  914. // Loop through the actions and see if we're applying a label anywhere
  915. foreach ($actions as $index => $action)
  916. {
  917. if ($action['t'] == 'lab')
  918. {
  919. // Update the value of this label...
  920. $actions[$index]['v'] = $label_info_2[$row['id_member']][$action['v']];
  921. }
  922. }
  923. // Put this back into a string
  924. $actions = serialize($actions);
  925. $smcFunc['db_query']('', '
  926. UPDATE {db_prefix}pm_rules
  927. SET actions = {string:actions}
  928. WHERE id_rule = {int:id_rule}',
  929. array(
  930. 'actions' => $actions,
  931. 'id_rule' => $row['id_rule'],
  932. )
  933. );
  934. }
  935. $smcFunc['db_free_result']($get_pm_rules);
  936. // Lastly, we drop the old columns
  937. $smcFunc['db_remove_column']('{db_prefix}members', 'message_labels');
  938. $smcFunc['db_remove_column']('{db_prefix}pm_recipients', 'labels');
  939. }
  940. }
  941. ******************************************************************************/
  942. --- Adding support for edit reasons
  943. /******************************************************************************/
  944. ---# Adding "modified_reason" column to messages
  945. ALTER TABLE {$db_prefix}messages
  946. ADD COLUMN modified_reason varchar(255) NOT NULL default '';
  947. ---#
  948. /******************************************************************************/
  949. --- Cleaning up guest permissions
  950. /******************************************************************************/
  951. ---# Removing permissions guests can no longer have...
  952. ---{
  953. $illegal_board_permissions = array(
  954. 'announce_topic',
  955. 'delete_any',
  956. 'lock_any',
  957. 'make_sticky',
  958. 'merge_any',
  959. 'modify_any',
  960. 'modify_replies',
  961. 'move_any',
  962. 'poll_add_any',
  963. 'poll_edit_any',
  964. 'poll_lock_any',
  965. 'poll_remove_any',
  966. 'remove_any',
  967. 'report_any',
  968. 'split_any'
  969. );
  970. $illegal_permissions = array('calendar_edit_any', 'moderate_board', 'moderate_forum', 'send_email_to_members');
  971. $smcFunc['db_query']('', '
  972. DELETE FROM {db_prefix}board_permissions
  973. WHERE id_group = {int:guests}
  974. AND permission IN ({array_string:illegal_board_perms})',
  975. array(
  976. 'guests' => -1,
  977. 'illegal_board_perms' => $illegal_board_permissions,
  978. )
  979. );
  980. $smcFunc['db_query']('', '
  981. DELETE FROM {db_prefix}permissions
  982. WHERE id_group = {int:guests}
  983. AND permission IN ({array_string:illegal_perms})',
  984. array(
  985. 'guests' => -1,
  986. 'illegal_perms' => $illegal_permissions,
  987. )
  988. );
  989. ---}
  990. ---#
  991. /******************************************************************************/
  992. --- Adding mail queue settings
  993. /******************************************************************************/
  994. ---#
  995. ---{
  996. if (empty($modSettings['mail_limit']))
  997. {
  998. $smcFunc['db_insert']('replace',
  999. '{db_prefix}settings',
  1000. array('variable' => 'string-255', 'value' => 'string'),
  1001. array(
  1002. array('mail_limit', '5'),
  1003. array('mail_quantity', '5'),
  1004. ),
  1005. array('variable')
  1006. );
  1007. }
  1008. ---}
  1009. ---#