upgrade_2-1_sqlite.sql 37 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222
  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. // Need to know a few things first.
  62. $custom_av_dir = !empty($modSettings['custom_avatar_dir']) ? $modSettings['custom_avatar_dir'] : $GLOBALS['boarddir'] .'/custom_avatar';
  63. // This little fellow has to cooperate...
  64. if (!is_writable($custom_av_dir))
  65. @chmod($custom_av_dir, 0777);
  66. $request = upgrade_query("
  67. SELECT MAX(id_attach)
  68. FROM {$db_prefix}attachments");
  69. list ($step_progress['total']) = $smcFunc['db_fetch_row']($request);
  70. $smcFunc['db_free_result']($request);
  71. $_GET['a'] = isset($_GET['a']) ? (int) $_GET['a'] : 0;
  72. $step_progress['name'] = 'Converting legacy attachments';
  73. $step_progress['current'] = $_GET['a'];
  74. // We may be using multiple attachment directories.
  75. if (!empty($modSettings['currentAttachmentUploadDir']) && !is_array($modSettings['attachmentUploadDir']))
  76. $modSettings['attachmentUploadDir'] = unserialize($modSettings['attachmentUploadDir']);
  77. $is_done = false;
  78. while (!$is_done)
  79. {
  80. nextSubStep($substep);
  81. $fileHash = '';
  82. $request = upgrade_query("
  83. SELECT id_attach, id_folder, filename, file_hash
  84. FROM {$db_prefix}attachments
  85. WHERE attachment_type != 1
  86. LIMIT $_GET[a], 100");
  87. // Finished?
  88. if ($smcFunc['db_num_rows']($request) == 0)
  89. $is_done = true;
  90. while ($row = $smcFunc['db_fetch_assoc']($request))
  91. {
  92. // The current folder.
  93. $currentFolder = !empty($modSettings['currentAttachmentUploadDir']) ? $modSettings['attachmentUploadDir'][$row['id_folder']] : $modSettings['attachmentUploadDir'];
  94. // Old School?
  95. if (empty($row['file_hash']))
  96. {
  97. // Remove international characters (windows-1252)
  98. // These lines should never be needed again. Still, behave.
  99. if (empty($db_character_set) || $db_character_set != 'utf8')
  100. {
  101. $row['filename'] = strtr($row['filename'],
  102. "\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",
  103. 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy');
  104. $row['filename'] = strtr($row['filename'], array("\xde" => 'TH', "\xfe" =>
  105. 'th', "\xd0" => 'DH', "\xf0" => 'dh', "\xdf" => 'ss', "\x8c" => 'OE',
  106. "\x9c" => 'oe', "\xc6" => 'AE', "\xe6" => 'ae', "\xb5" => 'u'));
  107. }
  108. // Sorry, no spaces, dots, or anything else but letters allowed.
  109. $row['filename'] = preg_replace(array('/\s/', '/[^\w_\.\-]/'), array('_', ''), $row['filename']);
  110. // Create a nice hash.
  111. $fileHash = sha1(md5($row['filename'] . time()) . mt_rand());
  112. // The old file, we need to know if the filename was encrypted or not.
  113. if (file_exists($currentFolder . '/' . $row['id_attach']. '_' . strtr($row['filename'], '.', '_') . md5($row['filename'])))
  114. $oldFile = $currentFolder . '/' . $row['id_attach']. '_' . strtr($row['filename'], '.', '_') . md5($row['filename']);
  115. else if (file_exists($currentFolder . '/' . $row['filename']));
  116. $oldFile = $currentFolder . '/' . $row['filename'];
  117. // Build the new file.
  118. $newFile = $currentFolder . '/' . $row['id_attach'] . '_' . $fileHash .'.dat';
  119. }
  120. // Just rename the file.
  121. else
  122. {
  123. $oldFile = $currentFolder . '/' . $row['id_attach'] . '_' . $row['file_hash'];
  124. $newFile = $currentFolder . '/' . $row['id_attach'] . '_' . $row['file_hash'] .'.dat';
  125. }
  126. // Check if the av is an attachment
  127. if ($row['id_member'] != 0)
  128. if (rename($oldFile, $custom_av_dir . '/' . $row['filename']))
  129. upgrade_query("
  130. UPDATE {$db_prefix}attachments
  131. SET file_hash = '', attachment_type = 1
  132. WHERE id_attach = $row[id_attach]");
  133. // Just a regular attachment.
  134. else
  135. rename($oldFile, $newFile);
  136. // Only update this if it was successful and the file was using the old system.
  137. if (empty($row['file_hash']) && !empty($fileHash) && file_exists($newFile) && !file_exists($oldFile))
  138. upgrade_query("
  139. UPDATE {$db_prefix}attachments
  140. SET file_hash = '$fileHash'
  141. WHERE id_attach = $row[id_attach]");
  142. }
  143. $smcFunc['db_free_result']($request);
  144. $_GET['a'] += 100;
  145. $step_progress['current'] = $_GET['a'];
  146. }
  147. unset($_GET['a']);
  148. ---}
  149. ---#
  150. /******************************************************************************/
  151. --- Adding support for IPv6...
  152. /******************************************************************************/
  153. ---# Adding new columns to ban items...
  154. ALTER TABLE {$db_prefix}ban_items
  155. ADD COLUMN ip_low5 smallint(255) unsigned NOT NULL DEFAULT '0',
  156. ADD COLUMN ip_high5 smallint(255) unsigned NOT NULL DEFAULT '0',
  157. ADD COLUMN ip_low6 smallint(255) unsigned NOT NULL DEFAULT '0',
  158. ADD COLUMN ip_high6 smallint(255) unsigned NOT NULL DEFAULT '0',
  159. ADD COLUMN ip_low7 smallint(255) unsigned NOT NULL DEFAULT '0',
  160. ADD COLUMN ip_high7 smallint(255) unsigned NOT NULL DEFAULT '0',
  161. ADD COLUMN ip_low8 smallint(255) unsigned NOT NULL DEFAULT '0',
  162. ADD COLUMN ip_high8 smallint(255) unsigned NOT NULL DEFAULT '0';
  163. ---#
  164. ---# Changing existing columns to ban items...
  165. ALTER TABLE {$db_prefix}ban_items
  166. CHANGE ip_low1 ip_low1 smallint(255) unsigned NOT NULL DEFAULT '0',
  167. CHANGE ip_high1 ip_high1 smallint(255) unsigned NOT NULL DEFAULT '0',
  168. CHANGE ip_low2 ip_low2 smallint(255) unsigned NOT NULL DEFAULT '0',
  169. CHANGE ip_high2 ip_high2 smallint(255) unsigned NOT NULL DEFAULT '0',
  170. CHANGE ip_low3 ip_low3 smallint(255) unsigned NOT NULL DEFAULT '0',
  171. CHANGE ip_high3 ip_high3 smallint(255) unsigned NOT NULL DEFAULT '0',
  172. CHANGE ip_low4 ip_low4 smallint(255) unsigned NOT NULL DEFAULT '0',
  173. CHANGE ip_high4 ip_high4 smallint(255) unsigned NOT NULL DEFAULT '0';
  174. ---#
  175. /******************************************************************************/
  176. --- Adding support for logging who fulfils a group request.
  177. /******************************************************************************/
  178. ---# Adding new columns to log_group_requests
  179. ALTER TABLE {$db_prefix}log_group_requests
  180. ADD COLUMN status smallint unsigned NOT NULL default '0',
  181. ADD COLUMN id_member_acted int unsigned NOT NULL default '0',
  182. ADD COLUMN member_name_acted varchar(255) NOT NULL default '',
  183. ADD COLUMN time_acted int unsigned NOT NULL default '0',
  184. ADD COLUMN act_reason text NOT NULL;
  185. ---#
  186. ---# Adjusting the indexes for log_group_requests
  187. DROP INDEX {$db_prefix}log_group_requests_id_member;
  188. CREATE INDEX {$db_prefix}log_group_requests_id_member ON {$db_prefix}log_group_requests (id_member, id_group);
  189. ---#
  190. /******************************************************************************/
  191. --- Adding support for <credits> tag in package manager
  192. /******************************************************************************/
  193. ---# Adding new columns to log_packages ..
  194. ALTER TABLE {$db_prefix}log_packages
  195. ADD COLUMN credits varchar(255) NOT NULL DEFAULT '';
  196. ---#
  197. /******************************************************************************/
  198. --- Adding more space for session ids
  199. /******************************************************************************/
  200. ---# Altering the session_id columns...
  201. ALTER TABLE {$db_prefix}log_online
  202. CHANGE `session` `session` varchar(64) NOT NULL DEFAULT '';
  203. ALTER TABLE {$db_prefix}log_errors
  204. CHANGE `session` `session` char(64) NOT NULL default ' ';
  205. ALTER TABLE {$db_prefix}sessions
  206. CHANGE `session_id` `session_id` char(64) NOT NULL;
  207. ---#
  208. /******************************************************************************/
  209. --- Adding new columns for MOVED topic updates
  210. /******************************************************************************/
  211. ---# Adding new custom fields columns.
  212. ---{
  213. $smcFunc['db_alter_table']('{db_prefix}topics', array(
  214. 'add' => array(
  215. 'redirect_expires' => array(
  216. 'name' => 'redirect_expires',
  217. 'null' => false,
  218. 'default' => '0',
  219. 'type' => 'int',
  220. 'auto' => false,
  221. ),
  222. )
  223. ));
  224. $smcFunc['db_alter_table']('{db_prefix}topics', array(
  225. 'add' => array(
  226. 'id_redirect_topic' => array(
  227. 'name' => 'id_redirect_topic',
  228. 'null' => false,
  229. 'default' => '0',
  230. 'type' => 'int',
  231. 'auto' => false,
  232. ),
  233. )
  234. ));
  235. ---}
  236. ---#
  237. /******************************************************************************/
  238. --- Adding new scheduled tasks
  239. /******************************************************************************/
  240. ---# Adding new scheduled tasks
  241. INSERT INTO {$db_prefix}scheduled_tasks
  242. (next_time, time_offset, time_regularity, time_unit, disabled, task)
  243. VALUES
  244. (0, 120, 1, 'd', 0, 'remove_temp_attachments');
  245. INSERT INTO {$db_prefix}scheduled_tasks
  246. (next_time, time_offset, time_regularity, time_unit, disabled, task)
  247. VALUES
  248. (0, 180, 1, 'd', 0, 'remove_topic_redirect');
  249. INSERT INTO {$db_prefix}scheduled_tasks
  250. (next_time, time_offset, time_regularity, time_unit, disabled, task)
  251. VALUES
  252. (0, 240, 1, 'd', 0, 'remove_old_drafts');
  253. ---#
  254. /******************************************************************************/
  255. ---- Adding background tasks support
  256. /******************************************************************************/
  257. ---# Adding the new table
  258. CREATE TABLE IF NOT EXISTS {$db_prefix}background_tasks (
  259. id_task integer primary key,
  260. task_file varchar(255) NOT NULL default '',
  261. task_class varchar(255) NOT NULL default '',
  262. task_data text NOT NULL,
  263. claimed_time int NOT NULL default '0',
  264. PRIMARY KEY (id_task)
  265. );
  266. ---#
  267. /******************************************************************************/
  268. ---- Replacing MSN with Skype
  269. /******************************************************************************/
  270. ---# Modifying the "msn" column...
  271. ALTER TABLE {$db_prefix}members
  272. CHANGE msn skype varchar(255) NOT NULL DEFAULT '';
  273. ---#
  274. /******************************************************************************/
  275. --- Adding support for deny boards access
  276. /******************************************************************************/
  277. ---# Adding new columns to boards...
  278. ---{
  279. $smcFunc['db_alter_table']('{db_prefix}boards', array(
  280. 'add' => array(
  281. 'deny_member_groups' => array(
  282. 'name' => 'deny_member_groups',
  283. 'null' => false,
  284. 'default' => '',
  285. 'type' => varchar,
  286. 'size' => 255,
  287. 'auto' => false,
  288. ),
  289. )
  290. ));
  291. ---}
  292. ---#
  293. /******************************************************************************/
  294. --- Updating board access rules
  295. /******************************************************************************/
  296. ---# Updating board access rules
  297. ---{
  298. $member_groups = array(
  299. 'allowed' => array(),
  300. 'denied' => array(),
  301. );
  302. $request = $smcFunc['db_query']('', '
  303. SELECT id_group, add_deny
  304. FROM {db_prefix}permissions
  305. WHERE permission = {string:permission}',
  306. array(
  307. 'permission' => 'manage_boards',
  308. )
  309. );
  310. while ($row = $smcFunc['db_fetch_assoc']($request))
  311. $member_groups[$row['add_deny'] === '1' ? 'allowed' : 'denied'][] = $row['id_group'];
  312. $smcFunc['db_free_result']($request);
  313. $member_groups = array_diff($member_groups['allowed'], $member_groups['denied']);
  314. if (!empty($member_groups))
  315. {
  316. $count = count($member_groups);
  317. $changes = array();
  318. $request = $smcFunc['db_query']('', '
  319. SELECT id_board, member_groups
  320. FROM {db_prefix}boards');
  321. while ($row = $smcFunc['db_fetch_assoc']($request))
  322. {
  323. $current_groups = explode(',', $row['member_groups']);
  324. if (count(array_intersect($current_groups, $member_groups)) != $count)
  325. {
  326. $new_groups = array_unique(array_merge($current_groups, $member_groups));
  327. $changes[$row['id_board']] = implode(',', $new_groups);
  328. }
  329. }
  330. $smcFunc['db_free_result']($request);
  331. if (!empty($changes))
  332. {
  333. foreach ($changes as $id_board => $member_groups)
  334. $smcFunc['db_query']('', '
  335. UPDATE {db_prefix}boards
  336. SET member_groups = {string:member_groups}
  337. WHERE id_board = {int:id_board}',
  338. array(
  339. 'member_groups' => $member_groups,
  340. 'id_board' => $id_board,
  341. )
  342. );
  343. }
  344. }
  345. ---}
  346. ---#
  347. /******************************************************************************/
  348. --- Adding support for category descriptions
  349. /******************************************************************************/
  350. ---# Adding new columns to categories...
  351. ---{
  352. $smcFunc['db_alter_table']('{db_prefix}log_topics', array(
  353. 'add' => array(
  354. 'description' => array(
  355. 'name' => 'description',
  356. 'null' => false,
  357. 'type' => 'text',
  358. 'auto' => false,
  359. ),
  360. )
  361. ));
  362. ---}
  363. ---#
  364. /******************************************************************************/
  365. --- Adding support for alerts
  366. /******************************************************************************/
  367. ---# Adding the count to the members table...
  368. ---{
  369. $smcFunc['db_alter_table']('{db_prefix}members', array(
  370. 'add' => array(
  371. 'alerts' => array(
  372. 'name' => 'ualerts',
  373. 'null' => false,
  374. 'default' => 0,
  375. 'type' => 'int',
  376. 'auto' => false,
  377. ),
  378. )
  379. ));
  380. ---}
  381. ---#
  382. ---# Adding the new table for alerts.
  383. CREATE TABLE IF NOT EXISTS {$db_prefix}user_alerts (
  384. id_alert int primary key,
  385. alert_time int unsigned NOT NULL default '0',
  386. id_member int unsigned NOT NULL default '0',
  387. id_member_started int unsigned NOT NULL default '0',
  388. member_name varchar(255) NOT NULL default '',
  389. content_type varchar(255) NOT NULL default '',
  390. content_id int unsigned NOT NULL default '0',
  391. content_action varchar(255) NOT NULL default '',
  392. is_read smallint unsigned NOT NULL default '0',
  393. extra text NOT NULL,
  394. PRIMARY KEY (id_alert)
  395. );
  396. CREATE INDEX {$db_prefix}user_alerts_id_member ON {$db_prefix}user_alerts (id_member);
  397. CREATE INDEX {$db_prefix}user_alerts_alert_time ON {$db_prefix}user_alerts (alert_time);
  398. ---#
  399. ---# Adding alert preferences.
  400. CREATE TABLE IF NOT EXISTS {$db_prefix}user_alerts_prefs (
  401. id_member int unsigned NOT NULL default '0',
  402. alert_pref varchar(32) NOT NULL default '',
  403. alert_value tinyint(3) NOT NULL default '0',
  404. PRIMARY KEY (id_member, alert_pref)
  405. );
  406. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'member_group_request', 1);
  407. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'member_register', 1);
  408. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'msg_like', 1);
  409. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'msg_report', 1);
  410. INSERT INTO {$db_prefix}user_alerts_prefs (id_member, alert_pref, alert_value) VALUES (0, 'msg_report_reply', 1);
  411. ---#
  412. /******************************************************************************/
  413. --- Adding support for topic unwatch
  414. /******************************************************************************/
  415. ---# Adding new columns to log_topics...
  416. ---{
  417. $smcFunc['db_alter_table']('{db_prefix}log_topics', array(
  418. 'add' => array(
  419. 'unwatched' => array(
  420. 'name' => 'unwatched',
  421. 'null' => false,
  422. 'default' => 0,
  423. 'type' => 'int',
  424. 'auto' => false,
  425. ),
  426. )
  427. ));
  428. UPDATE {$db_prefix}log_topics
  429. SET unwatched = 0;
  430. INSERT INTO {$db_prefix}settings
  431. (variable, value)
  432. VALUES
  433. ('enable_unwatch', 0);
  434. ---}
  435. ---#
  436. ---# Fixing column name change...
  437. ---{
  438. $smcFunc['db_alter_table']('{db_prefix}log_topics', array(
  439. 'change' => array(
  440. 'disregarded' => array(
  441. 'name' => 'unwatched',
  442. 'null' => false,
  443. 'default' => 0,
  444. 'type' => 'int',
  445. 'auto' => false,
  446. ),
  447. )
  448. ));
  449. ---}
  450. ---#
  451. /******************************************************************************/
  452. --- Name changes
  453. /******************************************************************************/
  454. ---# Altering the membergroup stars to icons
  455. ---{
  456. upgrade_query("
  457. ALTER TABLE {$db_prefix}membergroups
  458. CHANGE `stars` `icons` varchar(255) NOT NULL DEFAULT ''");
  459. ---}
  460. ---#
  461. ---# Renaming default theme...
  462. UPDATE {$db_prefix}themes
  463. SET value = 'SMF Default Theme - Curve2'
  464. WHERE value LIKE 'SMF Default Theme%';
  465. ---#
  466. ---# Adding the enableThemes setting.
  467. INSERT INTO {$db_prefix}settings
  468. (variable, value)
  469. VALUES
  470. ('enableThemes', '1');
  471. ---#
  472. ---# Setting "default" as the default...
  473. UPDATE {$db_prefix}settings
  474. SET value = '1'
  475. WHERE variable = 'theme_guests';
  476. UPDATE {$db_prefix}boards
  477. SET id_theme = 0;
  478. UPDATE {$db_prefix}members
  479. SET id_theme = 0;
  480. ---#
  481. /******************************************************************************/
  482. --- Cleaning up after old themes...
  483. /******************************************************************************/
  484. ---# Checking for "core" and removing it if necessary...
  485. ---{
  486. // Do they have "core" installed?
  487. if (file_exists($GLOBALS['boarddir'] . '/Themes/core'))
  488. {
  489. $core_dir = $GLOBALS['boarddir'] . '/Themes/core';
  490. $theme_request = upgrade_query("
  491. SELECT id_theme
  492. FROM {$db_prefix}themes
  493. WHERE variable = 'theme_dir'
  494. AND value ='$core_dir'");
  495. // Don't do anything if this theme is already uninstalled
  496. if ($smcFunc['db_num_rows']($theme_request) == 1)
  497. {
  498. list($id_theme) = $smcFunc['db_fetch_row']($theme_request, 0);
  499. $smcFunc['db_free_result']($theme_request);
  500. $known_themes = explode(', ', $modSettings['knownThemes']);
  501. // Remove this value...
  502. $known_themes = array_diff($known_themes, array($id_theme));
  503. // Change back to a string...
  504. $known_themes = implode(', ', $known_themes);
  505. // Update the database
  506. upgrade_query("
  507. UPDATE {$db_prefix}settings
  508. SET value = '$known_themes'
  509. WHERE variable = 'knownThemes'");
  510. // Delete any info about this theme
  511. upgrade_query("
  512. DELETE FROM {$db_prefix}themes
  513. WHERE id_theme = $id_theme");
  514. }
  515. }
  516. /******************************************************************************/
  517. --- Adding support for drafts
  518. /******************************************************************************/
  519. ---# Creating drafts table.
  520. CREATE TABLE IF NOT EXISTS {$db_prefix}user_drafts (
  521. id_draft int unsigned NOT NULL auto_increment,
  522. id_topic int unsigned NOT NULL default '0',
  523. id_board smallint unsigned NOT NULL default '0',
  524. id_reply int unsigned NOT NULL default '0',
  525. type smallint NOT NULL default '0',
  526. poster_time int unsigned NOT NULL default '0',
  527. id_member int unsigned NOT NULL default '0',
  528. subject varchar(255) NOT NULL default '',
  529. smileys_enabled smallint NOT NULL default '1',
  530. body text NOT NULL,
  531. icon varchar(16) NOT NULL default 'xx',
  532. locked smallint NOT NULL default '0',
  533. is_sticky smallint NOT NULL default '0',
  534. to_list varchar(255) NOT NULL default '',
  535. PRIMARY KEY (id_draft)
  536. );
  537. CREATE UNIQUE INDEX {$db_prefix}user_drafts_id_member ON {$db_prefix}user_drafts (id_member, id_draft, type);
  538. ---#
  539. ---# Adding draft permissions...
  540. ---{
  541. // We cannot do this twice
  542. if (@$modSettings['smfVersion'] < '2.1')
  543. {
  544. // Anyone who can currently post unapproved topics we assume can create drafts as well ...
  545. $request = upgrade_query("
  546. SELECT id_group, id_board, add_deny, permission
  547. FROM {$db_prefix}board_permissions
  548. WHERE permission = 'post_unapproved_topics'");
  549. $inserts = array();
  550. while ($row = $smcFunc['db_fetch_assoc']($request))
  551. {
  552. $inserts[] = "($row[id_group], $row[id_board], 'post_draft', $row[add_deny])";
  553. $inserts[] = "($row[id_group], $row[id_board], 'post_autosave_draft', $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}board_permissions
  562. (id_group, id_board, permission, add_deny)
  563. VALUES
  564. " . $insert);
  565. }
  566. }
  567. // Next we find people who can send PMs, and assume they can save pm_drafts as well
  568. $request = upgrade_query("
  569. SELECT id_group, add_deny, permission
  570. FROM {$db_prefix}permissions
  571. WHERE permission = 'pm_send'");
  572. $inserts = array();
  573. while ($row = $smcFunc['db_fetch_assoc']($request))
  574. {
  575. $inserts[] = "($row[id_group], 'pm_draft', $row[add_deny])";
  576. $inserts[] = "($row[id_group], 'pm_autosave_draft', $row[add_deny])";
  577. }
  578. $smcFunc['db_free_result']($request);
  579. if (!empty($inserts))
  580. {
  581. foreach ($inserts AS $insert)
  582. {
  583. upgrade_query("
  584. INSERT INTO {$db_prefix}permissions
  585. (id_group, permission, add_deny)
  586. VALUES
  587. " . $insert);
  588. }
  589. }
  590. }
  591. ---}
  592. INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_autosave_enabled', '1');
  593. INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_show_saved_enabled', '1');
  594. INSERT INTO {$db_prefix}settings (variable, value) VALUES ('drafts_keep_days', '7');
  595. INSERT INTO {$db_prefix}themes (id_theme, variable, value) VALUES ('1', 'drafts_autosave_enabled', '1');
  596. INSERT INTO {$db_prefix}themes (id_theme, variable, value) VALUES ('1', 'drafts_show_saved_enabled', '1');
  597. ---#
  598. /******************************************************************************/
  599. --- Adding support for likes
  600. /******************************************************************************/
  601. ---# Creating likes table.
  602. CREATE TABLE IF NOT EXISTS {$db_prefix}user_likes (
  603. id_member int NOT NULL default '0',
  604. content_type char(6) default '',
  605. content_id int NOT NULL default '0',
  606. like_time int NOT NULL default '0',
  607. PRIMARY KEY (content_id, content_type, id_member)
  608. );
  609. CREATE INDEX {$db_prefix}user_likes_content ON {$db_prefix}user_likes (content_id, content_type);
  610. CREATE INDEX {$db_prefix}user_likes_liker ON {$db_prefix}user_likes (id_member);
  611. ---#
  612. ---# Adding count to the messages table.
  613. ALTER TABLE {$db_prefix}messages
  614. ADD COLUMN likes smallint NOT NULL default '0';
  615. ---#
  616. /******************************************************************************/
  617. --- Adding support for group-based board moderation
  618. /******************************************************************************/
  619. ---# Creating moderator_groups table
  620. CREATE TABLE IF NOT EXISTS {$db_prefix}moderator_groups (
  621. id_board smallint NOT NULL default '0',
  622. id_group smallint NOT NULL default '0',
  623. PRIMARY KEY (id_board, id_group)
  624. );
  625. ---#
  626. /******************************************************************************/
  627. --- Cleaning up integration hooks
  628. /******************************************************************************/
  629. ---#
  630. DELETE FROM {$db_prefix}settings
  631. WHERE variable LIKE 'integrate_%';
  632. ---#
  633. /******************************************************************************/
  634. --- Cleaning up old settings
  635. /******************************************************************************/
  636. ---# Updating the default time format
  637. ---{
  638. if (!empty($modSettings['time_format']))
  639. {
  640. // First, use the shortened form of the month in the date.
  641. $time_format = str_replace('%B', '%b', $modSettings['time_format']);
  642. // Second, shorten the time to stop including seconds.
  643. $time_format = str_replace(':%S', '', $time_format);
  644. // Then, update the database.
  645. $smcFunc['db_query']('', '
  646. UPDATE {db_prefix}settings
  647. SET value = {string:new_format}
  648. WHERE variable = {literal:time_format}',
  649. array(
  650. 'new_format' => $time_format,
  651. )
  652. );
  653. }
  654. ---}
  655. ---#
  656. ---# Fixing a deprecated option.
  657. UPDATE {$db_prefix}settings
  658. SET value = 'option_css_resize'
  659. WHERE variable = 'avatar_action_too_large'
  660. AND (value = 'option_html_resize' OR value = 'option_js_resize');
  661. ---#
  662. ---# Cleaning up the old Core Features page.
  663. ---{
  664. // First get the original value
  665. $request = $smcFunc['db_query']('', '
  666. SELECT value
  667. FROM {db_prefix}settings
  668. WHERE variable = {literal:admin_features}');
  669. if ($smcFunc['db_num_rows']($request) > 0 && $row = $smcFunc['db_fetch_assoc']($request))
  670. {
  671. // Some of these *should* already be set but you never know.
  672. $new_settings = array();
  673. $admin_features = explode(',', $row['value']);
  674. // Now, let's just recap something.
  675. // cd = calendar, should also have set cal_enabled already
  676. // cp = custom profile fields, which already has several fields that cover tracking
  677. // k = karma, should also have set karmaMode already
  678. // ps = paid subs, should also have set paid_enabled already
  679. // rg = reports generation, which is now permanently on
  680. // sp = spider tracking, should also have set spider_mode already
  681. // w = warning system, which will be covered with warning_settings
  682. // The rest we have to deal with manually.
  683. // Moderation log - modlog_enabled itself should be set but we have others now
  684. if (in_array('ml', $admin_features))
  685. {
  686. $new_settings[] = array('adminlog_enabled', '1');
  687. $new_settings[] = array('userlog_enabled', '1');
  688. }
  689. // Post moderation
  690. if (in_array('pm', $admin_features))
  691. {
  692. $new_settings[] = array('postmod_active', '1');
  693. }
  694. // And now actually apply it.
  695. if (!empty($new_settings))
  696. {
  697. $smcFunc['db_insert']('replace',
  698. '{db_prefix}settings',
  699. array('variable' => 'string', 'value' => 'string'),
  700. $new_settings,
  701. array('variable')
  702. );
  703. }
  704. }
  705. $smcFunc['db_free_result']($request);
  706. ---}
  707. ---#
  708. ---# Cleaning up old settings.
  709. DELETE FROM {$db_prefix}settings
  710. WHERE variable IN ('enableStickyTopics', 'guest_hideContacts', 'notify_new_registration', 'attachmentEncryptFilenames', 'hotTopicPosts', 'hotTopicVeryPosts', 'fixLongWords', 'admin_features', 'topbottomEnable');
  711. ---#
  712. ---# Cleaning up old theme settings.
  713. DELETE FROM {$db_prefix}themes
  714. WHERE variable IN ('show_board_desc', 'no_new_reply_warning', 'display_quick_reply', 'show_mark_read', 'show_member_bar', 'linktree_link');
  715. ---#
  716. /******************************************************************************/
  717. --- Updating files that fetched from simplemachines.org
  718. /******************************************************************************/
  719. ---# We no longer call on several files.
  720. DELETE FROM {$db_prefix}admin_info_files
  721. WHERE filename IN ('latest-packages.js', 'latest-support.js', 'latest-themes.js')
  722. AND path = '/smf/';
  723. ---#
  724. ---# But we do need new files.
  725. ---{
  726. $smcFunc['db_insert']('',
  727. '{db_prefix}admin_info_files',
  728. array('filename' => 'string', 'path' => 'string', 'parameters' => 'string', 'data' => 'string', 'filetype' => 'string'),
  729. array('latest-versions.txt', '/smf/', 'version=%3$s', '', 'text/plain'),
  730. array('id_file')
  731. );
  732. ---}
  733. ---#
  734. /******************************************************************************/
  735. --- Upgrading "verification questions" feature
  736. /******************************************************************************/
  737. ---# Creating qanda table
  738. CREATE TABLE IF NOT EXISTS {$db_prefix}qanda (
  739. id_question smallint(5) unsigned NOT NULL auto_increment,
  740. lngfile varchar(255) NOT NULL default '',
  741. question varchar(255) NOT NULL default '',
  742. answers text NOT NULL,
  743. PRIMARY KEY (id_question),
  744. KEY lngfile (lngfile)
  745. );
  746. ---#
  747. ---# Moving questions and answers to the new table
  748. ---{
  749. $questions = array();
  750. $get_questions = upgrade_query("
  751. SELECT body AS question, recipient_name AS answer
  752. FROM {$db_prefix}log_comments
  753. WHERE comment_type = 'ver_test'");
  754. while ($row = $smcFunc['db_fetch_assoc']($get_questions))
  755. $questions[] = array($language, $row['question'], serialize(array($row['answer'])));
  756. $smcFunc['db_free_result']($get_questions);
  757. if (!empty($questions))
  758. {
  759. $smcFunc['db_insert']('',
  760. '{db_prefix}qanda',
  761. array('lngfile' => 'string', 'question' => 'string', 'answers' => 'string'),
  762. $questions,
  763. array('id_question')
  764. );
  765. // Delete the questions from log_comments now
  766. upgrade_query("
  767. DELETE FROM {$db_prefix}log_comments
  768. WHERE comment_type = 'ver_test'
  769. ");
  770. }
  771. ---}
  772. ---#
  773. /******************************************************************************/
  774. --- Marking packages as uninstalled...
  775. /******************************************************************************/
  776. ---# Updating log_packages
  777. UPDATE {$db_prefix}log_packages
  778. SET install_state = 0;
  779. ---#
  780. /******************************************************************************/
  781. --- Updating profile permissions...
  782. /******************************************************************************/
  783. ---# Removing the old "view your own profile" permission
  784. DELETE FROM {$db_prefix}permissions
  785. WHERE permission = 'profile_view_own';
  786. ---#
  787. ---# Updating the old "view any profile" permission
  788. UPDATE {$db_prefix}permissions
  789. SET permission = 'profile_view'
  790. WHERE permission = 'profile_view_any';
  791. ---#
  792. ---# Removing the old notification permissions
  793. DELETE FROM {$db_prefix}board_permissions
  794. WHERE permission = 'mark_notify' OR permission = 'mark_any_notify';
  795. ---#
  796. ---# Removing the send-topic permission
  797. DELETE FROM {$db_prefix}board_permissions
  798. WHERE permission = 'send_topic';
  799. ---#
  800. ---# Adding "profile_password_own"
  801. ---{
  802. $inserts = array();
  803. $request = upgrade_query("
  804. SELECT id_group, add_deny
  805. FROM {$db_prefix}permissions
  806. WHERE permission = 'profile_identity_own'");
  807. while ($row = $smcFunc['db_fetch_assoc']($request))
  808. {
  809. $inserts[] = "($row[id_group], 'profile_password_own', $row[add_deny])";
  810. }
  811. $smcFunc['db_free_result']($request);
  812. if (!empty($inserts))
  813. {
  814. foreach ($inserts as $insert)
  815. {
  816. upgrade_query("
  817. INSERT INTO {$db_prefix}permissions
  818. (id_group, permission, add_deny)
  819. VALUES
  820. " . $insert);
  821. }
  822. }
  823. ---}
  824. ---#
  825. ---# Adding other profile permissions
  826. ---{
  827. $inserts = array();
  828. $request = upgrade_query("
  829. SELECT id_group, add_deny
  830. FROM {$db_prefix}permissions
  831. WHERE permission = 'profile_extra_own'");
  832. while ($row = $smcFunc['db_fetch_assoc']($request))
  833. {
  834. $inserts[] = "($row[id_group], 'profile_blurb_own', $row[add_deny])";
  835. $inserts[] = "($row[id_group], 'profile_displayed_name_own', $row[add_deny])";
  836. $inserts[] = "($row[id_group], 'profile_forum_own', $row[add_deny])";
  837. $inserts[] = "($row[id_group], 'profile_other_own', $row[add_deny])";
  838. $inserts[] = "($row[id_group], 'profile_signature_own', $row[add_deny])";
  839. }
  840. $smcFunc['db_free_result']($request);
  841. if (!empty($inserts))
  842. {
  843. foreach ($inserts as $insert)
  844. {
  845. upgrade_query("
  846. INSERT INTO {$db_prefix}permissions
  847. (id_group, permission, add_deny)
  848. VALUES
  849. " . $insert);
  850. }
  851. }
  852. ---}
  853. ---#
  854. /******************************************************************************/
  855. --- Upgrading PM labels...
  856. /******************************************************************************/
  857. ---# Adding pm_labels table...
  858. CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labels (
  859. id_label integer primary key,
  860. id_member int NOT NULL default '0',
  861. name varchar(30) NOT NULL default '',
  862. );
  863. ---#
  864. ---# Adding pm_labeled_messages table...
  865. CREATE TABLE IF NOT EXISTS {$db_prefix}pm_labeled_messages (
  866. id_label int NOT NULL default '0',
  867. id_pm int NOT NULL default '0',
  868. PRIMARY KEY (id_label, id_pm)
  869. );
  870. ---#
  871. ---# Adding "in_inbox" column to pm_recipients
  872. ALTER TABLE {$db_prefix}pm_recipients
  873. ADD COLUMN in_inbox tinyint(3) NOT NULL default '1';
  874. ---#
  875. ---# Moving label info to new tables and updating rules...
  876. ---{
  877. // First see if we still have a message_labels column
  878. $results = $smcFunc['db_list_columns']('{db_prefix}members');
  879. if (in_array('message_labels', $results))
  880. {
  881. // They've still got it, so pull the label info
  882. $get_labels = $smcFunc['db_query']('', '
  883. SELECT id_member, message_labels
  884. FROM {db_prefix}members
  885. WHERE message_labels != {string:blank}',
  886. array(
  887. 'blank' => '',
  888. )
  889. );
  890. $inserts = array();
  891. $label_info = array();
  892. while ($row = $smcFunc['db_fetch_assoc']($get_labels))
  893. {
  894. // Stick this in an array
  895. $labels = explode(',', $row['message_labels']);
  896. // Build some inserts
  897. foreach ($labels AS $index => $label)
  898. {
  899. // Keep track of the index of this label - we'll need that in a bit...
  900. $label_info[$row['id_member']][$label] = $index;
  901. $inserts[] = array($row['id_member'], $label);
  902. }
  903. }
  904. $smcFunc['db_free_result']($get_labels);
  905. if (!empty($inserts))
  906. {
  907. $smcFunc['db_insert']('', '{db_prefix}pm_labels', array('id_member' => 'int', 'name' => 'int'), $inserts, array());
  908. // Clear this out for our next query below
  909. $inserts = array();
  910. }
  911. // This is the easy part - update the inbox stuff
  912. $smcFunc['db_query']('', '
  913. UPDATE {db_prefix}pm_recipients
  914. SET in_inbox = {int:in_inbox}
  915. WHERE FIND_IN_SET({int:minus_one}, labels)',
  916. array(
  917. 'in_inbox' => 1,
  918. 'minus_one' => -1,
  919. )
  920. );
  921. // Now we go pull the new IDs for each label
  922. $get_new_label_ids = $smcFunc['db_query']('', '
  923. SELECT *
  924. FROM {db_prefix}pm_labels',
  925. array(
  926. )
  927. );
  928. $label_info_2 = array();
  929. while ($label_row = $smcFunc['db_fetch_assoc']($get_new_label_ids))
  930. {
  931. // Map the old index values to the new ID values...
  932. $old_index = $label_info[$row['id_member']][$row['label_name']];
  933. $label_info_2[$row['id_member']][$old_index] = $row['id_label'];
  934. }
  935. $smcFunc['db_free_result']($get_new_label_ids);
  936. // Pull label info from pm_recipients
  937. // Ignore any that are only in the inbox
  938. $get_pm_labels = $smcFunc['db_query']('', '
  939. SELECT id_pm, id_member, labels
  940. FROM {db_prefix}pm_recipients
  941. WHERE deleted = {int:not_deleted}
  942. AND labels != {string:minus_one}',
  943. array(
  944. 'not_deleted' => 0,
  945. 'minus_one' => -1,
  946. )
  947. );
  948. while ($row = $smcFunc['db_fetch_assoc']($get_pm_labels))
  949. {
  950. $labels = explode(',', $row['labels']);
  951. foreach ($labels as $a_label)
  952. {
  953. if ($a_label == '-1')
  954. continue;
  955. $new_label_info = $label_info_2[$row['id_member']][$a_label];
  956. $inserts[] = array($row['id_pm'], $new_label_info);
  957. }
  958. }
  959. $smcFunc['db_free_result']($get_pm_labels);
  960. // Insert the new data
  961. if (!empty($inserts))
  962. {
  963. $smcFunc['db_insert']('', '{db_prefix}pm_labeled_messages', array('id_pm', 'id_label'), $inserts, array());
  964. }
  965. // Final step of this ridiculously massive process
  966. $get_pm_rules = $smcFunc['db_query']('', '
  967. SELECT id_member, id_rule, actions
  968. FROM {db_prefix}pm_rules',
  969. array(
  970. ),
  971. );
  972. // Go through the rules, unserialize the actions, then figure out if there's anything we can use
  973. while ($row = $smcFunc['db_fetch_assoc']($get_pm_rules))
  974. {
  975. // Turn this into an array...
  976. $actions = unserialize($row['actions']);
  977. // Loop through the actions and see if we're applying a label anywhere
  978. foreach ($actions as $index => $action)
  979. {
  980. if ($action['t'] == 'lab')
  981. {
  982. // Update the value of this label...
  983. $actions[$index]['v'] = $label_info_2[$row['id_member']][$action['v']];
  984. }
  985. }
  986. // Put this back into a string
  987. $actions = serialize($actions);
  988. $smcFunc['db_query']('', '
  989. UPDATE {db_prefix}pm_rules
  990. SET actions = {string:actions}
  991. WHERE id_rule = {int:id_rule}',
  992. array(
  993. 'actions' => $actions,
  994. 'id_rule' => $row['id_rule'],
  995. )
  996. );
  997. }
  998. $smcFunc['db_free_result']($get_pm_rules);
  999. // Lastly, we drop the old columns
  1000. $smcFunc['db_remove_column']('{db_prefix}members', 'message_labels');
  1001. $smcFunc['db_remove_column']('{db_prefix}pm_recipients', 'labels');
  1002. }
  1003. }
  1004. ******************************************************************************/
  1005. --- Adding support for edit reasons
  1006. /******************************************************************************/
  1007. ---# Adding "modified_reason" column to messages
  1008. ALTER TABLE {$db_prefix}messages
  1009. ADD COLUMN modified_reason varchar(255) NOT NULL default '';
  1010. ---#
  1011. /******************************************************************************/
  1012. --- Cleaning up guest permissions
  1013. /******************************************************************************/
  1014. ---# Removing permissions guests can no longer have...
  1015. ---{
  1016. $illegal_board_permissions = array(
  1017. 'announce_topic',
  1018. 'delete_any',
  1019. 'lock_any',
  1020. 'make_sticky',
  1021. 'merge_any',
  1022. 'modify_any',
  1023. 'modify_replies',
  1024. 'move_any',
  1025. 'poll_add_any',
  1026. 'poll_edit_any',
  1027. 'poll_lock_any',
  1028. 'poll_remove_any',
  1029. 'remove_any',
  1030. 'report_any',
  1031. 'split_any'
  1032. );
  1033. $illegal_permissions = array('calendar_edit_any', 'moderate_board', 'moderate_forum', 'send_email_to_members');
  1034. $smcFunc['db_query']('', '
  1035. DELETE FROM {db_prefix}board_permissions
  1036. WHERE id_group = {int:guests}
  1037. AND permission IN ({array_string:illegal_board_perms})',
  1038. array(
  1039. 'guests' => -1,
  1040. 'illegal_board_perms' => $illegal_board_permissions,
  1041. )
  1042. );
  1043. $smcFunc['db_query']('', '
  1044. DELETE FROM {db_prefix}permissions
  1045. WHERE id_group = {int:guests}
  1046. AND permission IN ({array_string:illegal_perms})',
  1047. array(
  1048. 'guests' => -1,
  1049. 'illegal_perms' => $illegal_permissions,
  1050. )
  1051. );
  1052. ---}
  1053. ---#
  1054. /******************************************************************************/
  1055. --- Adding mail queue settings
  1056. /******************************************************************************/
  1057. ---#
  1058. ---{
  1059. if (empty($modSettings['mail_limit']))
  1060. {
  1061. $smcFunc['db_insert']('replace',
  1062. '{db_prefix}settings',
  1063. array('variable' => 'string-255', 'value' => 'string'),
  1064. array(
  1065. array('mail_limit', '5'),
  1066. array('mail_quantity', '5'),
  1067. ),
  1068. array('variable')
  1069. );
  1070. }
  1071. ---}
  1072. ---#