upgrade_2-1_sqlite.sql 43 KB

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