PageRenderTime 82ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 1ms

/sources/admin/ManageAttachments.php

https://github.com/Arantor/Elkarte
PHP | 2433 lines | 1859 code | 283 blank | 291 comment | 310 complexity | c1292f73b09bb0efa1251e47c4fc5b5b MD5 | raw file
Possible License(s): BSD-3-Clause, LGPL-3.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. 

  3. /**
    4. 

  4.  * @name      ElkArte Forum
    5. 

  5.  * @copyright ElkArte Forum contributors
    6. 

  6.  * @license   BSD http://opensource.org/licenses/BSD-3-Clause
    7. 

  7.  *
    8. 

  8.  * This software is a derived product, based on:
    9. 

  9.  *
    10. 

  10.  * Simple Machines Forum (SMF)
    11. 

  11.  * copyright:	2011 Simple Machines (http://www.simplemachines.org)
    12. 

  12.  * license:  	BSD, See included LICENSE.TXT for terms and conditions.
    13. 

  13.  *
    14. 

  14.  * @version 1.0 Alpha
    15. 

  15.  *
    16. 

  16.  * This file doing the job of attachments and avatars maintenance and management.
    17. 

  17.  * @todo refactor as controller-model
    18. 

  18.  *
    19. 

  19.  */
    20. 

  20. 

  21. if (!defined('ELKARTE'))
    22. 

  22. 	die('No access...');
    23. 

  23. 

  24. /**
    25. 

  25.  * The main 'Attachments and Avatars' management function.
    26. 

  26.  * This function is the entry point for index.php?action=admin;area=manageattachments
    27. 

  27.  * and it calls a function based on the sub-action.
    28. 

  28.  * It requires the manage_attachments permission.
    29. 

  29.  *
    30. 

  30.  * @uses ManageAttachments template.
    31. 

  31.  * @uses Admin language file.
    32. 

  32.  * @uses template layer 'manage_files' for showing the tab bar.
    33. 

  33.  *
    34. 

  34.  */
    35. 

  35. function ManageAttachments()
    36. 

  36. {
    37. 

  37. 	global $txt, $modSettings, $scripturl, $context, $options;
    38. 

  38. 

  39. 	// You have to be able to moderate the forum to do this.
    40. 

  40. 	isAllowedTo('manage_attachments');
    41. 

  41. 

  42. 	// Setup the template stuff we'll probably need.
    43. 

  43. 	loadTemplate('ManageAttachments');
    44. 

  44. 

  45. 	// If they want to delete attachment(s), delete them. (otherwise fall through..)
    46. 

  46. 	$subActions = array(
    47. 

  47. 		'attachments' => 'action_attachments',
    48. 

  48. 		'attachpaths' => 'action_attachpaths',
    49. 

  49. 		'avatars' => 'action_avatars',
    50. 

  50. 		'browse' => 'action_browse',
    51. 

  51. 		'byAge' => 'action_byAge',
    52. 

  52. 		'bySize' => 'action_bySize',
    53. 

  53. 		'maintenance' => 'action_maintenance',
    54. 

  54. 		'moveAvatars' => 'action_moveAvatars',
    55. 

  55. 		'repair' => 'action_repair',
    56. 

  56. 		'remove' => 'action_remove',
    57. 

  57. 		'removeall' => 'action_removeall',
    58. 

  58. 		'transfer' => 'action_transfer',
    59. 

  59. 	);
    60. 

  60. 

  61. 	call_integration_hook('integrate_manage_attachments', array($subActions));
    62. 

  62. 

  63. 	// Pick the correct sub-action.
    64. 

  64. 	if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]))
    65. 

  65. 		$context['sub_action'] = $_REQUEST['sa'];
    66. 

  66. 	else
    67. 

  67. 		$context['sub_action'] = 'browse';
    68. 

  68. 

  69. 	// Default page title is good.
    70. 

  70. 	$context['page_title'] = $txt['attachments_avatars'];
    71. 

  71. 

  72. 	// This uses admin tabs - as it should!
    73. 

  73. 	$context[$context['admin_menu_name']]['tab_data'] = array(
    74. 

  74. 		'title' => $txt['attachments_avatars'],
    75. 

  75. 		'help' => 'manage_files',
    76. 

  76. 		'description' => $txt['attachments_desc'],
    77. 

  77. 	);
    78. 

  78. 

  79. 	// Finally fall through to what we are doing.
    80. 

  80. 	$subActions[$context['sub_action']]();
    81. 

  81. }
    82. 

  82. 

  83. /**
    84. 

  84.  * Allows to show/change attachment settings.
    85. 

  85.  * This is the default sub-action of the 'Attachments and Avatars' center.
    86. 

  86.  * Called by index.php?action=admin;area=manageattachments;sa=attachments.
    87. 

  87.  *
    88. 

  88.  * @param bool $return_config = false
    89. 

  89.  * @uses 'attachments' sub template.
    90. 

  90.  */
    91. 

  91. 

  92. function action_attachments($return_config = false)
    93. 

  93. {
    94. 

  94. 	global $txt, $modSettings, $scripturl, $context, $options;
    95. 

  95. 

  96. 	require_once(SUBSDIR . '/Attachments.subs.php');
    97. 

  97. 

  98. 	// Get the current attachment directory.
    99. 

  99. 	$modSettings['attachmentUploadDir'] = unserialize($modSettings['attachmentUploadDir']);
    100. 

  100. 	$context['attachmentUploadDir'] = $modSettings['attachmentUploadDir'][$modSettings['currentAttachmentUploadDir']];
    101. 

  101. 

  102. 	// First time here?
    103. 

  103. 	if (empty($modSettings['attachment_basedirectories']) && $modSettings['currentAttachmentUploadDir'] == 1 && count($modSettings['attachmentUploadDir']) == 1)
    104. 

  104. 		$modSettings['attachmentUploadDir'] = $modSettings['attachmentUploadDir'][1];
    105. 

  105. 

  106. 	// If not set, show a default path for the base directory
    107. 

  107. 	if (!isset($_GET['save']) && empty($modSettings['basedirectory_for_attachments']))
    108. 

  108. 		if (is_dir($modSettings['attachmentUploadDir'][1]))
    109. 

  109. 			$modSettings['basedirectory_for_attachments'] = $modSettings['attachmentUploadDir'][1];
    110. 

  110. 		else
    111. 

  111. 			$modSettings['basedirectory_for_attachments'] = $context['attachmentUploadDir'];
    112. 

  112. 

  113. 	$context['valid_upload_dir'] = is_dir($context['attachmentUploadDir']) && is_writable($context['attachmentUploadDir']);
    114. 

  114. 

  115. 	if (!empty($modSettings['automanage_attachments']))
    116. 

  116. 		$context['valid_basedirectory'] =  !empty($modSettings['basedirectory_for_attachments']) && is_writable($modSettings['basedirectory_for_attachments']);
    117. 

  117. 	else
    118. 

  118. 		$context['valid_basedirectory'] = true;
    119. 

  119. 

  120. 	// A bit of razzle dazzle with the $txt strings. :)
    121. 

  121. 	$txt['attachment_path'] = $context['attachmentUploadDir'];
    122. 

  122. 	$txt['basedirectory_for_attachments_path']= isset($modSettings['basedirectory_for_attachments']) ? $modSettings['basedirectory_for_attachments'] : '';
    123. 

  123. 	$txt['use_subdirectories_for_attachments_note'] = empty($modSettings['attachment_basedirectories']) || empty($modSettings['use_subdirectories_for_attachments']) ? $txt['use_subdirectories_for_attachments_note'] : '';
    124. 

  124. 	$txt['attachmentUploadDir_multiple_configure'] = '<a href="' . $scripturl . '?action=admin;area=manageattachments;sa=attachpaths">[' . $txt['attachmentUploadDir_multiple_configure'] . ']</a>';
    125. 

  125. 	$txt['attach_current_dir'] = empty($modSettings['automanage_attachments']) ? $txt['attach_current_dir'] : $txt['attach_last_dir'];
    126. 

  126. 	$txt['attach_current_dir_warning'] = $txt['attach_current_dir'] . $txt['attach_current_dir_warning'];
    127. 

  127. 	$txt['basedirectory_for_attachments_warning'] = $txt['basedirectory_for_attachments_current'] . $txt['basedirectory_for_attachments_warning'];
    128. 

  128. 

  129. 	// Perform a test to see if the GD module or ImageMagick are installed.
    130. 

  130. 	$testImg = get_extension_funcs('gd') || class_exists('Imagick');
    131. 

  131. 

  132. 	// See if we can find if the server is set up to support the attacment limits
    133. 

  133. 	$post_max_size = ini_get('post_max_size');
    134. 

  134. 	$upload_max_filesize = ini_get('upload_max_filesize');
    135. 

  135. 	$testPM = !empty($post_max_size) ? (memoryReturnBytes($post_max_size) >= (isset($modSettings['attachmentPostLimit']) ? $modSettings['attachmentPostLimit'] * 1024 : 0)) : true;
    136. 

  136. 	$testUM = !empty($upload_max_filesize) ? (memoryReturnBytes($upload_max_filesize) >= (isset($modSettings['attachmentSizeLimit']) ? $modSettings['attachmentSizeLimit'] * 1024 : 0)) : true;
    137. 

  137. 

  138. 	$config_vars = array(
    139. 

  139. 		array('title', 'attachment_manager_settings'),
    140. 

  140. 			// Are attachments enabled?
    141. 

  141. 			array('select', 'attachmentEnable', array($txt['attachmentEnable_deactivate'], $txt['attachmentEnable_enable_all'], $txt['attachmentEnable_disable_new'])),
    142. 

  142. 		'',
    143. 

  143. 			// Extension checks etc.
    144. 

  144. 			array('check', 'attachmentRecodeLineEndings'),
    145. 

  145. 		'',
    146. 

  146. 			// Directory and size limits.
    147. 

  147. 			array('select', 'automanage_attachments', array(0 => $txt['attachments_normal'], 1 => $txt['attachments_auto_space'], 2 => $txt['attachments_auto_years'], 3 => $txt['attachments_auto_months'], 4 => $txt['attachments_auto_16'])),
    148. 

  148. 			array('check', 'use_subdirectories_for_attachments', 'subtext' => $txt['use_subdirectories_for_attachments_note']),
    149. 

  149. 			(empty($modSettings['attachment_basedirectories']) ? array('text', 'basedirectory_for_attachments', 40,) : array('var_message', 'basedirectory_for_attachments', 'message' => 'basedirectory_for_attachments_path', 'invalid' => empty($context['valid_basedirectory']), 'text_label' => (!empty($context['valid_basedirectory']) ? $txt['basedirectory_for_attachments_current'] : $txt['basedirectory_for_attachments_warning']))),
    150. 

  150. 			empty($modSettings['attachment_basedirectories']) && $modSettings['currentAttachmentUploadDir'] == 1 && count($modSettings['attachmentUploadDir']) == 1	? array('text', 'attachmentUploadDir', 'subtext' => $txt['attachmentUploadDir_multiple_configure'], 40, 'invalid' => !$context['valid_upload_dir']) : array('var_message', 'attach_current_directory', 'subtext' => $txt['attachmentUploadDir_multiple_configure'], 'message' => 'attachment_path', 'invalid' => empty($context['valid_upload_dir']), 'text_label' => (!empty($context['valid_upload_dir']) ? $txt['attach_current_dir'] : $txt['attach_current_dir_warning'])),
    151. 

  151. 			array('int', 'attachmentDirFileLimit', 'subtext' => $txt['zero_for_no_limit'], 6),
    152. 

  152. 			array('int', 'attachmentDirSizeLimit', 'subtext' => $txt['zero_for_no_limit'], 6, 'postinput' => $txt['kilobyte']),
    153. 

  153. 		'',
    154. 

  154. 			// Posting limits
    155. 

  155. 			array('int', 'attachmentPostLimit', 'subtext' => $txt['zero_for_no_limit'], 6, 'postinput' => $txt['kilobyte']),
    156. 

  156. 			array('warning', empty($testPM) ? 'attachment_postsize_warning' : ''),
    157. 

  157. 			array('int', 'attachmentSizeLimit', 'subtext' => $txt['zero_for_no_limit'], 6, 'postinput' => $txt['kilobyte']),
    158. 

  158. 			array('warning', empty($testUM) ? 'attachment_filesize_warning' : ''),
    159. 

  159. 			array('int', 'attachmentNumPerPostLimit', 'subtext' => $txt['zero_for_no_limit'], 6),
    160. 

  160. 			// Security Items
    161. 

  161. 		array('title', 'attachment_security_settings'),
    162. 

  162. 			// Extension checks etc.
    163. 

  163. 			array('check', 'attachmentCheckExtensions'),
    164. 

  164. 			array('text', 'attachmentExtensions', 40),
    165. 

  165. 		'',
    166. 

  166. 			// Image checks.
    167. 

  167. 			array('warning', empty($testImg) ? 'attachment_img_enc_warning' : ''),
    168. 

  168. 			array('check', 'attachment_image_reencode'),
    169. 

  169. 		'',
    170. 

  170. 			array('warning', 'attachment_image_paranoid_warning'),
    171. 

  171. 			array('check', 'attachment_image_paranoid'),
    172. 

  172. 			// Thumbnail settings.
    173. 

  173. 		array('title', 'attachment_thumbnail_settings'),
    174. 

  174. 			array('check', 'attachmentShowImages'),
    175. 

  175. 			array('check', 'attachmentThumbnails'),
    176. 

  176. 			array('check', 'attachment_thumb_png'),
    177. 

  177. 			array('check', 'attachment_thumb_memory', 'subtext' => $txt['attachment_thumb_memory_note1'], 'postinput' => $txt['attachment_thumb_memory_note2']),
    178. 

  178. 			array('warning', 'attachment_thumb_memory_note'),
    179. 

  179. 			array('text', 'attachmentThumbWidth', 6),
    180. 

  180. 			array('text', 'attachmentThumbHeight', 6),
    181. 

  181. 		'',
    182. 

  182. 			array('int', 'max_image_width', 'subtext' => $txt['zero_for_no_limit']),
    183. 

  183. 			array('int', 'max_image_height', 'subtext' => $txt['zero_for_no_limit']),
    184. 

  184. 	);
    185. 

  185. 

  186. 	$context['settings_post_javascript'] = '
    187. 

  187. 	var storing_type = document.getElementById(\'automanage_attachments\');
    188. 

  188. 	var base_dir = document.getElementById(\'use_subdirectories_for_attachments\');
    189. 

    190. 

  190. 	createEventListener(storing_type)
    191. 

  191. 	storing_type.addEventListener("change", toggleSubDir, false);
    192. 

  192. 	createEventListener(base_dir)
    193. 

  193. 	base_dir.addEventListener("change", toggleSubDir, false);
    194. 

  194. 	toggleSubDir();';
    195. 

    196. 

  196. 	call_integration_hook('integrate_modify_attachment_settings', array($config_vars));
    197. 

  197. 

  198. 	if ($return_config)
    199. 

  199. 		return $config_vars;
    200. 

  200. 

  201. 	// These are very likely to come in handy! (i.e. without them we're doomed!)
    202. 

  202. 	require_once(ADMINDIR . '/ManagePermissions.php');
    203. 

  203. 	require_once(ADMINDIR . '/ManageServer.php');
    204. 

  204. 

  205. 	// Saving settings?
    206. 

  206. 	if (isset($_GET['save']))
    207. 

  207. 	{
    208. 

  208. 		checkSession();
    209. 

  209. 

  210. 		if (isset($_POST['attachmentUploadDir']))
    211. 

  211. 		{
    212. 

  212. 			if (!empty($_POST['attachmentUploadDir']) && $modSettings['attachmentUploadDir'] != $_POST['attachmentUploadDir'])
    213. 

  213. 				rename($modSettings['attachmentUploadDir'], $_POST['attachmentUploadDir']);
    214. 

  214. 

  215. 			$modSettings['attachmentUploadDir'] = array(1 => $_POST['attachmentUploadDir']);
    216. 

  216. 			$_POST['attachmentUploadDir'] = serialize($modSettings['attachmentUploadDir']);
    217. 

  217. 		}
    218. 

  218. 

  219. 		if (!empty($_POST['use_subdirectories_for_attachments']))
    220. 

  220. 		{
    221. 

  221. 			if (isset($_POST['use_subdirectories_for_attachments']) && empty($_POST['basedirectory_for_attachments']))
    222. 

  222. 				$_POST['basedirectory_for_attachments'] = (!empty($modSettings['basedirectory_for_attachments']) ? ($modSettings['basedirectory_for_attachments']) : BOARDDIR);
    223. 

  223. 

  224. 			if (!empty($_POST['use_subdirectories_for_attachments']) && !empty($modSettings['attachment_basedirectories']))
    225. 

  225. 			{
    226. 

  226. 				if (!is_array($modSettings['attachment_basedirectories']))
    227. 

  227. 					$modSettings['attachment_basedirectories'] = unserialize($modSettings['attachment_basedirectories']);
    228. 

  228. 			}
    229. 

  229. 			else
    230. 

  230. 				$modSettings['attachment_basedirectories'] = array();
    231. 

  231. 

  232. 			if (!empty($_POST['use_subdirectories_for_attachments']) && !empty($_POST['basedirectory_for_attachments']) && !in_array($_POST['basedirectory_for_attachments'], $modSettings['attachment_basedirectories']))
    233. 

  233. 			{
    234. 

  234. 				$currentAttachmentUploadDir = $modSettings['currentAttachmentUploadDir'];
    235. 

  235. 

  236. 				if (!in_array($_POST['basedirectory_for_attachments'], $modSettings['attachmentUploadDir']))
    237. 

  237. 				{
    238. 

  238. 					if (!automanage_attachments_create_directory($_POST['basedirectory_for_attachments']))
    239. 

  239. 						$_POST['basedirectory_for_attachments'] = $modSettings['basedirectory_for_attachments'];
    240. 

  240. 				}
    241. 

  241. 

  242. 				if (!in_array($_POST['basedirectory_for_attachments'], $modSettings['attachment_basedirectories']))
    243. 

  243. 				{
    244. 

  244. 					$modSettings['attachment_basedirectories'][$modSettings['currentAttachmentUploadDir']] = $_POST['basedirectory_for_attachments'];
    245. 

  245. 					updateSettings(array(
    246. 

  246. 						'attachment_basedirectories' => serialize($modSettings['attachment_basedirectories']),
    247. 

  247. 						'currentAttachmentUploadDir' => $currentAttachmentUploadDir,
    248. 

  248. 					));
    249. 

  249. 

  250. 					$_POST['use_subdirectories_for_attachments'] = 1;
    251. 

  251. 					$_POST['attachmentUploadDir'] = serialize($modSettings['attachmentUploadDir']);
    252. 

  252. 

  253. 				}
    254. 

  254. 			}
    255. 

  255. 		}
    256. 

  256. 

  257. 		call_integration_hook('integrate_save_attachment_settings');
    258. 

  258. 

  259. 		saveDBSettings($config_vars);
    260. 

  260. 		redirectexit('action=admin;area=manageattachments;sa=attachments');
    261. 

  261. 	}
    262. 

  262. 

  263. 	$context['post_url'] = $scripturl . '?action=admin;area=manageattachments;save;sa=attachments';
    264. 

  264. 	prepareDBSettingContext($config_vars);
    265. 

  265. 

  266. 	$context['sub_template'] = 'show_settings';
    267. 

  267. }
    268. 

  268. 

  269. /**
    270. 

  270.  * This allows to show/change avatar settings.
    271. 

  271.  * Called by index.php?action=admin;area=manageattachments;sa=avatars.
    272. 

  272.  * Show/set permissions for permissions: 'profile_server_avatar',
    273. 

  273.  * 	'profile_upload_avatar' and 'profile_remote_avatar'.
    274. 

  274.  *
    275. 

  275.  * @param bool $return_config = false
    276. 

  276.  * @uses 'avatars' sub template.
    277. 

  277.  */
    278. 

  278. function action_avatars($return_config = false)
    279. 

  279. {
    280. 

  280. 	global $txt, $context, $modSettings, $scripturl;
    281. 

  281. 

  282. 	// Perform a test to see if the GD module or ImageMagick are installed.
    283. 

  283. 	$testImg = get_extension_funcs('gd') || class_exists('Imagick');
    284. 

  284. 

  285. 	$context['valid_avatar_dir'] = is_dir($modSettings['avatar_directory']);
    286. 

  286. 	$context['valid_custom_avatar_dir'] = empty($modSettings['custom_avatar_enabled']) || (!empty($modSettings['custom_avatar_dir']) && is_dir($modSettings['custom_avatar_dir']) && is_writable($modSettings['custom_avatar_dir']));
    287. 

  287. 

  288. 	$config_vars = array(
    289. 

  289. 		array('title', 'avatar_settings'),
    290. 

  290. 			array('check', 'avatar_default'),
    291. 

  291. 		// Server stored avatars!
    292. 

  292. 		array('title', 'avatar_server_stored'),
    293. 

  293. 			array('warning', empty($testImg) ? 'avatar_img_enc_warning' : ''),
    294. 

  294. 			array('permissions', 'profile_server_avatar', 0, $txt['avatar_server_stored_groups']),
    295. 

  295. 			array('text', 'avatar_directory', 40, 'invalid' => !$context['valid_avatar_dir']),
    296. 

  296. 			array('text', 'avatar_url', 40),
    297. 

  297. 		// External avatars?
    298. 

  298. 		array('title', 'avatar_external'),
    299. 

  299. 			array('permissions', 'profile_remote_avatar', 0, $txt['avatar_external_url_groups']),
    300. 

  300. 			array('check', 'avatar_download_external', 0, 'onchange' => 'fUpdateStatus();'),
    301. 

  301. 			array('text', 'avatar_max_width_external', 'subtext' => $txt['zero_for_no_limit'], 6),
    302. 

  302. 			array('text', 'avatar_max_height_external', 'subtext' => $txt['zero_for_no_limit'], 6),
    303. 

  303. 			array('select', 'avatar_action_too_large',
    304. 

  304. 				array(
    305. 

  305. 					'option_refuse' => $txt['option_refuse'],
    306. 

  306. 					'option_html_resize' => $txt['option_html_resize'],
    307. 

  307. 					'option_js_resize' => $txt['option_js_resize'],
    308. 

  308. 					'option_download_and_resize' => $txt['option_download_and_resize'],
    309. 

  309. 				),
    310. 

  310. 			),
    311. 

  311. 		array('title','gravatar'),
    312. 

  312. 			array('permissions', 'profile_gvatar', 0, $txt['gravatar_groups']),
    313. 

  313. 			array('select', 'gravatar_rating',
    314. 

  314. 				array(
    315. 

  315. 					'g' => 'g',
    316. 

  316. 					'pg' => 'pg',
    317. 

  317. 					'r' => 'r',
    318. 

  318. 					'x' => 'x',
    319. 

  319. 				),
    320. 

  320. 			),
    321. 

  321. 		// Uploadable avatars?
    322. 

  322. 		array('title', 'avatar_upload'),
    323. 

  323. 			array('permissions', 'profile_upload_avatar', 0, $txt['avatar_upload_groups']),
    324. 

  324. 			array('text', 'avatar_max_width_upload', 'subtext' => $txt['zero_for_no_limit'], 6),
    325. 

  325. 			array('text', 'avatar_max_height_upload', 'subtext' => $txt['zero_for_no_limit'], 6),
    326. 

  326. 			array('check', 'avatar_resize_upload', 'subtext' => $txt['avatar_resize_upload_note']),
    327. 

  327. 			array('check', 'avatar_reencode'),
    328. 

  328. 		'',
    329. 

  329. 			array('warning', 'avatar_paranoid_warning'),
    330. 

  330. 			array('check', 'avatar_paranoid'),
    331. 

  331. 		'',
    332. 

  332. 			array('check', 'avatar_download_png'),
    333. 

  333. 			array('select', 'custom_avatar_enabled', array($txt['option_attachment_dir'], $txt['option_specified_dir']), 'onchange' => 'fUpdateStatus();'),
    334. 

  334. 			array('text', 'custom_avatar_dir', 40, 'subtext' => $txt['custom_avatar_dir_desc'], 'invalid' => !$context['valid_custom_avatar_dir']),
    335. 

  335. 			array('text', 'custom_avatar_url', 40),
    336. 

  336. 	);
    337. 

  337. 

  338. 	call_integration_hook('integrate_modify_avatar_settings', array($config_vars));
    339. 

  339. 

  340. 	if ($return_config)
    341. 

  341. 		return $config_vars;
    342. 

  342. 

  343. 	// We need this file for the settings template.
    344. 

  344. 	require_once(ADMINDIR . '/ManageServer.php');
    345. 

  345. 

  346. 	// Saving avatar settings?
    347. 

  347. 	if (isset($_GET['save']))
    348. 

  348. 	{
    349. 

  349. 		checkSession();
    350. 

  350. 

  351. 		// Just incase the admin forgot to set both custom avatar values, we disable it to prevent errors.
    352. 

  352. 		if (isset($_POST['custom_avatar_enabled']) && $_POST['custom_avatar_enabled'] == 1 && (empty($_POST['custom_avatar_dir']) || empty($_POST['custom_avatar_url'])))
    353. 

  353. 			$_POST['custom_avatar_enabled'] = 0;
    354. 

  354. 

  355. 		call_integration_hook('integrate_save_avatar_settings');
    356. 

  356. 

  357. 		saveDBSettings($config_vars);
    358. 

  358. 		redirectexit('action=admin;area=manageattachments;sa=avatars');
    359. 

  359. 	}
    360. 

  360. 

  361. 	// Attempt to figure out if the admin is trying to break things.
    362. 

  362. 	$context['settings_save_onclick'] = 'return document.getElementById(\'custom_avatar_enabled\').value == 1 && (document.getElementById(\'custom_avatar_dir\').value == \'\' || document.getElementById(\'custom_avatar_url\').value == \'\') ? confirm(\'' . $txt['custom_avatar_check_empty'] . '\') : true;';
    363. 

  363. 

  364. 	// We need this for the in-line permissions
    365. 

  365. 	createToken('admin-mp');
    366. 

  366. 

  367. 	// Prepare the context.
    368. 

  368. 	$context['post_url'] = $scripturl . '?action=admin;area=manageattachments;save;sa=avatars';
    369. 

  369. 	prepareDBSettingContext($config_vars);
    370. 

  370. 

  371. 	// Add a layer for the javascript.
    372. 

  372. 	$context['template_layers'][] = 'avatar_settings';
    373. 

  373. 	$context['sub_template'] = 'show_settings';
    374. 

  374. }
    375. 

  375. 

  376. /**
    377. 

  377.  * Show a list of attachment or avatar files.
    378. 

  378.  * Called by ?action=admin;area=manageattachments;sa=browse for attachments
    379. 

  379.  *  and ?action=admin;area=manageattachments;sa=browse;avatars for avatars.
    380. 

  380.  * Allows sorting by name, date, size and member.
    381. 

  381.  * Paginates results.
    382. 

  382.  *
    383. 

  383.  *  @uses the 'browse' sub template
    384. 

  384.  */
    385. 

  385. function action_browse()
    386. 

  386. {
    387. 

  387. 	global $context, $txt, $scripturl, $options, $modSettings;
    388. 

  388. 	global $smcFunc;
    389. 

  389. 

  390. 	$context['sub_template'] = 'browse';
    391. 

  391. 

  392. 	// Attachments or avatars?
    393. 

  393. 	$context['browse_type'] = isset($_REQUEST['avatars']) ? 'avatars' : (isset($_REQUEST['thumbs']) ? 'thumbs' : 'attachments');
    394. 

  394. 

  395. 	// Set the options for the list component.
    396. 

  396. 	$listOptions = array(
    397. 

  397. 		'id' => 'file_list',
    398. 

  398. 		'title' => $txt['attachment_manager_' . ($context['browse_type'] === 'avatars' ? 'avatars' : ($context['browse_type'] === 'thumbs' ? 'thumbs' : 'attachments'))],
    399. 

  399. 		'items_per_page' => $modSettings['defaultMaxMessages'],
    400. 

  400. 		'base_href' => $scripturl . '?action=admin;area=manageattachments;sa=browse' . ($context['browse_type'] === 'avatars' ? ';avatars' : ($context['browse_type'] === 'thumbs' ? ';thumbs' : '')),
    401. 

  401. 		'default_sort_col' => 'name',
    402. 

  402. 		'no_items_label' => $txt['attachment_manager_' . ($context['browse_type'] === 'avatars' ? 'avatars' : ( $context['browse_type'] === 'thumbs' ? 'thumbs' : 'attachments')) . '_no_entries'],
    403. 

  403. 		'get_items' => array(
    404. 

  404. 			'function' => 'list_getFiles',
    405. 

  405. 			'params' => array(
    406. 

  406. 				$context['browse_type'],
    407. 

  407. 			),
    408. 

  408. 		),
    409. 

  409. 		'get_count' => array(
    410. 

  410. 			'function' => 'list_getNumFiles',
    411. 

  411. 			'params' => array(
    412. 

  412. 				$context['browse_type'],
    413. 

  413. 			),
    414. 

  414. 		),
    415. 

  415. 		'columns' => array(
    416. 

  416. 			'name' => array(
    417. 

  417. 				'header' => array(
    418. 

  418. 					'value' => $txt['attachment_name'],
    419. 

  419. 				),
    420. 

  420. 				'data' => array(
    421. 

  421. 					'function' => create_function('$rowData', '
    422. 

  422. 						global $modSettings, $context, $scripturl;
    423. 

  423. 

  424. 						$link = \'<a href="\';
    425. 

    426. 

  426. 						// In case of a custom avatar URL attachments have a fixed directory.
    427. 

  427. 						if ($rowData[\'attachment_type\'] == 1)
    428. 

  428. 							$link .= sprintf(\'%1$s/%2$s\', $modSettings[\'custom_avatar_url\'], $rowData[\'filename\']);
    429. 

    430. 

  430. 						// By default avatars are downloaded almost as attachments.
    431. 

  431. 						elseif ($context[\'browse_type\'] == \'avatars\')
    432. 

  432. 							$link .= sprintf(\'%1$s?action=dlattach;type=avatar;attach=%2$d\', $scripturl, $rowData[\'id_attach\']);
    433. 

    434. 

  434. 						// Normal attachments are always linked to a topic ID.
    435. 

  435. 						else
    436. 

  436. 							$link .= sprintf(\'%1$s?action=dlattach;topic=%2$d.0;attach=%3$d\', $scripturl, $rowData[\'id_topic\'], $rowData[\'id_attach\']);
    437. 

    438. 

  438. 						$link .= \'"\';
    439. 

    440. 

  440. 						// Show a popup on click if it\'s a picture and we know its dimensions.
    441. 

  441. 						if (!empty($rowData[\'width\']) && !empty($rowData[\'height\']))
    442. 

  442. 							$link .= sprintf(\' onclick="return reqWin(this.href\' . ($rowData[\'attachment_type\'] == 1 ? \'\' : \' + \\\';image\\\'\') . \', %1$d, %2$d, true);"\', $rowData[\'width\'] + 20, $rowData[\'height\'] + 20);
    443. 

    444. 

  444. 						$link .= sprintf(\'>%1$s</a>\', preg_replace(\'~&amp;#(\\\\d{1,7}|x[0-9a-fA-F]{1,6});~\', \'&#\\\\1;\', htmlspecialchars($rowData[\'filename\'])));
    445. 

    446. 

  446. 						// Show the dimensions.
    447. 

  447. 						if (!empty($rowData[\'width\']) && !empty($rowData[\'height\']))
    448. 

  448. 							$link .= sprintf(\' <span class="smalltext">%1$dx%2$d</span>\', $rowData[\'width\'], $rowData[\'height\']);
    449. 

    450. 

  450. 						return $link;
    451. 

  451. 					'),
    452. 

  452. 				),
    453. 

  453. 				'sort' => array(
    454. 

  454. 					'default' => 'a.filename',
    455. 

  455. 					'reverse' => 'a.filename DESC',
    456. 

  456. 				),
    457. 

  457. 			),
    458. 

  458. 			'filesize' => array(
    459. 

  459. 				'header' => array(
    460. 

  460. 					'value' => $txt['attachment_file_size'],
    461. 

  461. 				),
    462. 

  462. 				'data' => array(
    463. 

  463. 					'function' => create_function('$rowData','
    464. 

  464. 						global $txt;
    465. 

  465. 

  466. 						return sprintf(\'%1$s%2$s\', round($rowData[\'size\'] / 1024, 2), $txt[\'kilobyte\']);
    467. 

  467. 					'),
    468. 

  468. 				),
    469. 

  469. 				'sort' => array(
    470. 

  470. 					'default' => 'a.size',
    471. 

  471. 					'reverse' => 'a.size DESC',
    472. 

  472. 				),
    473. 

  473. 			),
    474. 

  474. 			'member' => array(
    475. 

  475. 				'header' => array(
    476. 

  476. 					'value' => $context['browse_type'] == 'avatars' ? $txt['attachment_manager_member'] : $txt['posted_by'],
    477. 

  477. 				),
    478. 

  478. 				'data' => array(
    479. 

  479. 					'function' => create_function('$rowData', '
    480. 

  480. 						global $scripturl;
    481. 

  481. 

  482. 						// In case of an attachment, return the poster of the attachment.
    483. 

  483. 						if (empty($rowData[\'id_member\']))
    484. 

  484. 							return htmlspecialchars($rowData[\'poster_name\']);
    485. 

    486. 

  486. 						// Otherwise it must be an avatar, return the link to the owner of it.
    487. 

  487. 						else
    488. 

  488. 							return sprintf(\'<a href="%1$s?action=profile;u=%2$d">%3$s</a>\', $scripturl, $rowData[\'id_member\'], $rowData[\'poster_name\']);
    489. 

  489. 					'),
    490. 

  490. 				),
    491. 

  491. 				'sort' => array(
    492. 

  492. 					'default' => 'mem.real_name',
    493. 

  493. 					'reverse' => 'mem.real_name DESC',
    494. 

  494. 				),
    495. 

  495. 			),
    496. 

  496. 			'date' => array(
    497. 

  497. 				'header' => array(
    498. 

  498. 					'value' => $context['browse_type'] == 'avatars' ? $txt['attachment_manager_last_active'] : $txt['date'],
    499. 

  499. 				),
    500. 

  500. 				'data' => array(
    501. 

  501. 					'function' => create_function('$rowData', '
    502. 

  502. 						global $txt, $context, $scripturl;
    503. 

  503. 

  504. 						// The date the message containing the attachment was posted or the owner of the avatar was active.
    505. 

  505. 						$date = empty($rowData[\'poster_time\']) ? $txt[\'never\'] : timeformat($rowData[\'poster_time\']);
    506. 

    507. 

  507. 						// Add a link to the topic in case of an attachment.
    508. 

  508. 						if ($context[\'browse_type\'] !== \'avatars\')
    509. 

  509. 							$date .= sprintf(\'<br />%1$s <a href="%2$s?topic=%3$d.0.msg%4$d#msg%4$d">%5$s</a>\', $txt[\'in\'], $scripturl, $rowData[\'id_topic\'], $rowData[\'id_msg\'], $rowData[\'subject\']);
    510. 

    511. 

  511. 						return $date;
    512. 

  512. 						'),
    513. 

  513. 				),
    514. 

  514. 				'sort' => array(
    515. 

  515. 					'default' => $context['browse_type'] === 'avatars' ? 'mem.last_login' : 'm.id_msg',
    516. 

  516. 					'reverse' => $context['browse_type'] === 'avatars' ? 'mem.last_login DESC' : 'm.id_msg DESC',
    517. 

  517. 				),
    518. 

  518. 			),
    519. 

  519. 			'downloads' => array(
    520. 

  520. 				'header' => array(
    521. 

  521. 					'value' => $txt['downloads'],
    522. 

  522. 				),
    523. 

  523. 				'data' => array(
    524. 

  524. 					'db' => 'downloads',
    525. 

  525. 					'comma_format' => true,
    526. 

  526. 				),
    527. 

  527. 				'sort' => array(
    528. 

  528. 					'default' => 'a.downloads',
    529. 

  529. 					'reverse' => 'a.downloads DESC',
    530. 

  530. 				),
    531. 

  531. 			),
    532. 

  532. 			'check' => array(
    533. 

  533. 				'header' => array(
    534. 

  534. 					'value' => '<input type="checkbox" onclick="invertAll(this, this.form);" class="input_check" />',
    535. 

  535. 					'class' => 'centercol',
    536. 

  536. 				),
    537. 

  537. 				'data' => array(
    538. 

  538. 					'sprintf' => array(
    539. 

  539. 						'format' => '<input type="checkbox" name="remove[%1$d]" class="input_check" />',
    540. 

  540. 						'params' => array(
    541. 

  541. 							'id_attach' => false,
    542. 

  542. 						),
    543. 

  543. 					),
    544. 

  544. 					'class' => 'centercol',
    545. 

  545. 				),
    546. 

  546. 			),
    547. 

  547. 		),
    548. 

  548. 		'form' => array(
    549. 

  549. 			'href' => $scripturl . '?action=admin;area=manageattachments;sa=remove' . ($context['browse_type'] === 'avatars' ? ';avatars' : ($context['browse_type'] === 'thumbs' ? ';thumbs' : '')),
    550. 

  550. 			'include_sort' => true,
    551. 

  551. 			'include_start' => true,
    552. 

  552. 			'hidden_fields' => array(
    553. 

  553. 				'type' => $context['browse_type'],
    554. 

  554. 			),
    555. 

  555. 		),
    556. 

  556. 		'additional_rows' => array(
    557. 

  557. 			array(
    558. 

  558. 				'position' => 'below_table_data',
    559. 

  559. 				'value' => '<input type="submit" name="remove_submit" class="button_submit" value="' . $txt['quickmod_delete_selected'] . '" onclick="return confirm(\'' . $txt['confirm_delete_attachments'] . '\');" />',
    560. 

  560. 			),
    561. 

  561. 		),
    562. 

  562. 	);
    563. 

  563. 

  564. 	// Create the list.
    565. 

  565. 	require_once(SUBSDIR . '/List.subs.php');
    566. 

  566. 	createList($listOptions);
    567. 

  567. }
    568. 

  568. 

  569. /**
    570. 

  570.  * Returns the list of attachments files (avatars or not), recorded
    571. 

  571.  * in the database, per the parameters received.
    572. 

  572.  *
    573. 

  573.  * @param int $start
    574. 

  574.  * @param int $items_per_page
    575. 

  575.  * @param string $sort
    576. 

  576.  * @param string $browse_type can be on eof 'avatars' or ... not. :P
    577. 

  577.  */
    578. 

  578. function list_getFiles($start, $items_per_page, $sort, $browse_type)
    579. 

  579. {
    580. 

  580. 	global $smcFunc, $txt;
    581. 

  581. 

  582. 	// Choose a query depending on what we are viewing.
    583. 

  583. 	if ($browse_type === 'avatars')
    584. 

  584. 		$request = $smcFunc['db_query']('', '
    585. 

  585. 			SELECT
    586. 

  586. 				{string:blank_text} AS id_msg, IFNULL(mem.real_name, {string:not_applicable_text}) AS poster_name,
    587. 

  587. 				mem.last_login AS poster_time, 0 AS id_topic, a.id_member, a.id_attach, a.filename, a.file_hash, a.attachment_type,
    588. 

  588. 				a.size, a.width, a.height, a.downloads, {string:blank_text} AS subject, 0 AS id_board
    589. 

  589. 			FROM {db_prefix}attachments AS a
    590. 

  590. 				LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = a.id_member)
    591. 

  591. 			WHERE a.id_member != {int:guest_id}
    592. 

  592. 			ORDER BY {raw:sort}
    593. 

  593. 			LIMIT {int:start}, {int:per_page}',
    594. 

  594. 			array(
    595. 

  595. 				'guest_id' => 0,
    596. 

  596. 				'blank_text' => '',
    597. 

  597. 				'not_applicable_text' => $txt['not_applicable'],
    598. 

  598. 				'sort' => $sort,
    599. 

  599. 				'start' => $start,
    600. 

  600. 				'per_page' => $items_per_page,
    601. 

  601. 			)
    602. 

  602. 		);
    603. 

  603. 	else
    604. 

  604. 		$request = $smcFunc['db_query']('', '
    605. 

  605. 			SELECT
    606. 

  606. 				m.id_msg, IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.id_topic, m.id_member,
    607. 

  607. 				a.id_attach, a.filename, a.file_hash, a.attachment_type, a.size, a.width, a.height, a.downloads, mf.subject, t.id_board
    608. 

  608. 			FROM {db_prefix}attachments AS a
    609. 

  609. 				INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
    610. 

  610. 				INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
    611. 

  611. 				INNER JOIN {db_prefix}messages AS mf ON (mf.id_msg = t.id_first_msg)
    612. 

  612. 				LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
    613. 

  613. 			WHERE a.attachment_type = {int:attachment_type}
    614. 

  614. 			ORDER BY {raw:sort}
    615. 

  615. 			LIMIT {int:start}, {int:per_page}',
    616. 

  616. 			array(
    617. 

  617. 				'attachment_type' => $browse_type == 'thumbs' ? '3' : '0',
    618. 

  618. 				'sort' => $sort,
    619. 

  619. 				'start' => $start,
    620. 

  620. 				'per_page' => $items_per_page,
    621. 

  621. 			)
    622. 

  622. 		);
    623. 

  623. 	$files = array();
    624. 

  624. 	while ($row = $smcFunc['db_fetch_assoc']($request))
    625. 

  625. 		$files[] = $row;
    626. 

  626. 	$smcFunc['db_free_result']($request);
    627. 

  627. 

  628. 	return $files;
    629. 

  629. }
    630. 

  630. 

  631. /**
    632. 

  632.  * Return the number of files of the specified type recorded in the database.
    633. 

  633.  * (the specified type being attachments or avatars).
    634. 

  634.  *
    635. 

  635.  * @param string $browse_type can be one of 'avatars' or not. (in which case they're attachments)
    636. 

  636.  */
    637. 

  637. function list_getNumFiles($browse_type)
    638. 

  638. {
    639. 

  639. 	global $smcFunc;
    640. 

  640. 

  641. 	// Depending on the type of file, different queries are used.
    642. 

  642. 	if ($browse_type === 'avatars')
    643. 

  643. 		$request = $smcFunc['db_query']('', '
    644. 

  644. 		SELECT COUNT(*)
    645. 

  645. 		FROM {db_prefix}attachments
    646. 

  646. 		WHERE id_member != {int:guest_id_member}',
    647. 

  647. 		array(
    648. 

  648. 			'guest_id_member' => 0,
    649. 

  649. 		)
    650. 

  650. 	);
    651. 

  651. 	else
    652. 

  652. 		$request = $smcFunc['db_query']('', '
    653. 

  653. 			SELECT COUNT(*) AS num_attach
    654. 

  654. 			FROM {db_prefix}attachments AS a
    655. 

  655. 				INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
    656. 

  656. 				INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
    657. 

  657. 				INNER JOIN {db_prefix}messages AS mf ON (mf.id_msg = t.id_first_msg)
    658. 

  658. 			WHERE a.attachment_type = {int:attachment_type}
    659. 

  659. 				AND a.id_member = {int:guest_id_member}',
    660. 

  660. 			array(
    661. 

  661. 				'attachment_type' => $browse_type === 'thumbs' ? '3' : '0',
    662. 

  662. 				'guest_id_member' => 0,
    663. 

  663. 			)
    664. 

  664. 		);
    665. 

  665. 

  666. 	list ($num_files) = $smcFunc['db_fetch_row']($request);
    667. 

  667. 	$smcFunc['db_free_result']($request);
    668. 

  668. 

  669. 	return $num_files;
    670. 

  670. }
    671. 

  671. 

  672. /**
    673. 

  673.  * Show several file maintenance options.
    674. 

  674.  * Called by ?action=admin;area=manageattachments;sa=maintain.
    675. 

  675.  * Calculates file statistics (total file size, number of attachments,
    676. 

  676.  * number of avatars, attachment space available).
    677. 

  677.  *
    678. 

  678.  * @uses the 'maintain' sub template.
    679. 

  679.  */
    680. 

  680. function action_maintenance()
    681. 

  681. {
    682. 

  682. 	global $context, $modSettings, $txt, $smcFunc;
    683. 

  683. 

  684. 	$context['sub_template'] = 'maintenance';
    685. 

  685. 

  686. 	// We're working with them attachments here!
    687. 

  687. 	require_once(SUBSDIR . '/Attachments.subs.php');
    688. 

  688. 

  689. 	// we need our attachments directories...
    690. 

  690. 	$attach_dirs = getAttachmentDirs();
    691. 

  691. 

  692. 	// Get the number of attachments...
    693. 

  693. 	$context['num_attachments'] = comma_format(getAttachmentCount(), 0);
    694. 

  694. 

  695. 	// Also get the avatar amount...
    696. 

  696. 	$context['num_avatars'] = comma_format(getAvatarCount(), 0);
    697. 

  697. 

  698. 	// Check the size of all the directories.
    699. 

  699. 	$request = $smcFunc['db_query']('', '
    700. 

  700. 		SELECT SUM(size)
    701. 

  701. 		FROM {db_prefix}attachments
    702. 

  702. 		WHERE attachment_type != {int:type}',
    703. 

  703. 		array(
    704. 

  704. 			'type' => 1,
    705. 

  705. 		)
    706. 

  706. 	);
    707. 

  707. 	list ($attachmentDirSize) = $smcFunc['db_fetch_row']($request);
    708. 

  708. 	$smcFunc['db_free_result']($request);
    709. 

  709. 

  710. 	// Divide it into kilobytes.
    711. 

  711. 	$attachmentDirSize /= 1024;
    712. 

  712. 	$context['attachment_total_size'] = comma_format($attachmentDirSize, 2);
    713. 

  713. 

  714. 	$request = $smcFunc['db_query']('', '
    715. 

  715. 		SELECT COUNT(*), SUM(size)
    716. 

  716. 		FROM {db_prefix}attachments
    717. 

  717. 		WHERE id_folder = {int:folder_id}
    718. 

  718. 			AND attachment_type != {int:type}',
    719. 

  719. 		array(
    720. 

  720. 			'folder_id' => $modSettings['currentAttachmentUploadDir'],
    721. 

  721. 			'type' => 1,
    722. 

  722. 		)
    723. 

  723. 	);
    724. 

  724. 	list ($current_dir_files, $current_dir_size) = $smcFunc['db_fetch_row']($request);
    725. 

  725. 	$smcFunc['db_free_result']($request);
    726. 

  726. 	$current_dir_size /= 1024;
    727. 

  727. 

  728. 	// If they specified a limit only....
    729. 

  729. 	if (!empty($modSettings['attachmentDirSizeLimit']))
    730. 

  730. 		$context['attachment_space'] = comma_format(max($modSettings['attachmentDirSizeLimit'] - $current_dir_size, 0), 2);
    731. 

  731. 	$context['attachment_current_size'] = comma_format($current_dir_size, 2);
    732. 

  732. 

  733. 	if (!empty($modSettings['attachmentDirFileLimit']))
    734. 

  734. 		$context['attachment_files'] = comma_format(max($modSettings['attachmentDirFileLimit'] - $current_dir_files, 0), 0);
    735. 

  735. 	$context['attachment_current_files'] = comma_format($current_dir_files, 0);
    736. 

  736. 

  737. 	$context['attach_multiple_dirs'] = count($attach_dirs) > 1 ? true : false;
    738. 

  738. 	$context['attach_dirs'] = $attach_dirs;
    739. 

  739. 	$context['base_dirs'] = !empty($modSettings['attachment_basedirectories']) ? unserialize($modSettings['attachment_basedirectories']) : array();
    740. 

  740. 	$context['checked'] = isset($_SESSION['checked']) ? $_SESSION['checked'] : true;
    741. 

  741. 	if (!empty($_SESSION['results']))
    742. 

  742. 	{
    743. 

  743. 		$context['results'] = implode('<br />', $_SESSION['results']);
    744. 

  744. 		unset($_SESSION['results']);
    745. 

  745. 	}
    746. 

  746. }
    747. 

  747. 

  748. /**
    749. 

  749.  * Move avatars from their current location, to the custom_avatar_dir folder.
    750. 

  750.  * Called from the maintenance screen by ?action=admin;area=manageattachments;sa=action_moveAvatars.
    751. 

  751.  */
    752. 

  752. function action_moveAvatars()
    753. 

  753. {
    754. 

  754. 	global $modSettings, $smcFunc;
    755. 

  755. 

  756. 	// First make sure the custom avatar dir is writable.
    757. 

  757. 	if (!is_writable($modSettings['custom_avatar_dir']))
    758. 

  758. 	{
    759. 

  759. 		// Try to fix it.
    760. 

  760. 		@chmod($modSettings['custom_avatar_dir'], 0777);
    761. 

  761. 

  762. 		// Guess that didn't work?
    763. 

  763. 		if (!is_writable($modSettings['custom_avatar_dir']))
    764. 

  764. 			fatal_lang_error('attachments_no_write', 'critical');
    765. 

  765. 	}
    766. 

  766. 

  767. 	$request = $smcFunc['db_query']('', '
    768. 

  768. 		SELECT id_attach, id_folder, id_member, filename, file_hash
    769. 

  769. 		FROM {db_prefix}attachments
    770. 

  770. 		WHERE attachment_type = {int:attachment_type}
    771. 

  771. 			AND id_member > {int:guest_id_member}',
    772. 

  772. 		array(
    773. 

  773. 			'attachment_type' => 0,
    774. 

  774. 			'guest_id_member' => 0,
    775. 

  775. 		)
    776. 

  776. 	);
    777. 

  777. 	$updatedAvatars = array();
    778. 

  778. 	while ($row = $smcFunc['db_fetch_assoc']($request))
    779. 

  779. 	{
    780. 

  780. 		$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
    781. 

  781. 

  782. 		if (rename($filename, $modSettings['custom_avatar_dir'] . '/' . $row['filename']))
    783. 

  783. 			$updatedAvatars[] = $row['id_attach'];
    784. 

  784. 	}
    785. 

  785. 	$smcFunc['db_free_result']($request);
    786. 

  786. 

  787. 	if (!empty($updatedAvatars))
    788. 

  788. 		$smcFunc['db_query']('', '
    789. 

  789. 			UPDATE {db_prefix}attachments
    790. 

  790. 			SET attachment_type = {int:attachment_type}
    791. 

  791. 			WHERE id_attach IN ({array_int:updated_avatars})',
    792. 

  792. 			array(
    793. 

  793. 				'updated_avatars' => $updatedAvatars,
    794. 

  794. 				'attachment_type' => 1,
    795. 

  795. 			)
    796. 

  796. 		);
    797. 

  797. 

  798. 	redirectexit('action=admin;area=manageattachments;sa=maintenance');
    799. 

  799. }
    800. 

  800. 

  801. /**
    802. 

  802.  * Remove attachments older than a given age.
    803. 

  803.  * Called from the maintenance screen by
    804. 

  804.  *   ?action=admin;area=manageattachments;sa=byAge.
    805. 

  805.  * It optionally adds a certain text to the messages the attachments
    806. 

  806.  *  were removed from.
    807. 

  807.  *  @todo refactor this silly superglobals use...
    808. 

  808.  */
    809. 

  809. function action_byAge()
    810. 

  810. {
    811. 

  811. 	global $modSettings, $smcFunc;
    812. 

  812. 

  813. 	checkSession('post', 'admin');
    814. 

  814. 

  815. 	// @todo Ignore messages in topics that are stickied?
    816. 

  816. 

  817. 	// someone has to do the dirty work
    818. 

  818. 	require_once(SUBSDIR . '/Attachments.subs.php');
    819. 

  819. 

  820. 	// Deleting an attachment?
    821. 

  821. 	if ($_REQUEST['type'] != 'avatars')
    822. 

  822. 	{
    823. 

  823. 		// Get rid of all the old attachments.
    824. 

  824. 		$messages = removeAttachments(array('attachment_type' => 0, 'poster_time' => (time() - 24 * 60 * 60 * $_POST['age'])), 'messages', true);
    825. 

  825. 

  826. 		// Update the messages to reflect the change.
    827. 

  827. 		if (!empty($messages) && !empty($_POST['notice']))
    828. 

  828. 			$smcFunc['db_query']('', '
    829. 

  829. 				UPDATE {db_prefix}messages
    830. 

  830. 				SET body = CONCAT(body, {string:notice})
    831. 

  831. 				WHERE id_msg IN ({array_int:messages})',
    832. 

  832. 				array(
    833. 

  833. 					'messages' => $messages,
    834. 

  834. 					'notice' => '<br /><br />' . $_POST['notice'],
    835. 

  835. 				)
    836. 

  836. 			);
    837. 

  837. 	}
    838. 

  838. 	else
    839. 

  839. 	{
    840. 

  840. 		// Remove all the old avatars.
    841. 

  841. 		removeAttachments(array('not_id_member' => 0, 'last_login' => (time() - 24 * 60 * 60 * $_POST['age'])), 'members');
    842. 

  842. 	}
    843. 

  843. 	redirectexit('action=admin;area=manageattachments' . (empty($_REQUEST['avatars']) ? ';sa=maintenance' : ';avatars'));
    844. 

  844. }
    845. 

  845. 

  846. /**
    847. 

  847.  * Remove attachments larger than a given size.
    848. 

  848.  * Called from the maintenance screen by
    849. 

  849.  *  ?action=admin;area=manageattachments;sa=bySize.
    850. 

  850.  * Optionally adds a certain text to the messages the attachments were
    851. 

  851.  * 	removed from.
    852. 

  852.  */
    853. 

  853. function action_bySize()
    854. 

  854. {
    855. 

  855. 	global $modSettings, $smcFunc;
    856. 

  856. 

  857. 	checkSession('post', 'admin');
    858. 

  858. 

  859. 	// we'll need this
    860. 

  860. 	require_once(SUBSDIR . '/Attachments.subs.php');
    861. 

  861. 

  862. 	// Find humungous attachments.
    863. 

  863. 	$messages = removeAttachments(array('attachment_type' => 0, 'size' => 1024 * $_POST['size']), 'messages', true);
    864. 

  864. 

  865. 	// And make a note on the post.
    866. 

  866. 	if (!empty($messages) && !empty($_POST['notice']))
    867. 

  867. 		$smcFunc['db_query']('', '
    868. 

  868. 			UPDATE {db_prefix}messages
    869. 

  869. 			SET body = CONCAT(body, {string:notice})
    870. 

  870. 			WHERE id_msg IN ({array_int:messages})',
    871. 

  871. 			array(
    872. 

  872. 				'messages' => $messages,
    873. 

  873. 				'notice' => '<br /><br />' . $_POST['notice'],
    874. 

  874. 			)
    875. 

  875. 		);
    876. 

  876. 

  877. 	redirectexit('action=admin;area=manageattachments;sa=maintenance');
    878. 

  878. }
    879. 

  879. 

  880. /**
    881. 

  881.  * Remove a selection of attachments or avatars.
    882. 

  882.  * Called from the browse screen as submitted form by
    883. 

  883.  *  ?action=admin;area=manageattachments;sa=remove
    884. 

  884.  */
    885. 

  885. function action_remove()
    886. 

  886. {
    887. 

  887. 	global $txt, $smcFunc, $language;
    888. 

  888. 

  889. 	checkSession('post');
    890. 

  890. 

  891. 	if (!empty($_POST['remove']))
    892. 

  892. 	{
    893. 

  893. 		// we'll need this
    894. 

  894. 		require_once(SUBSDIR . '/Attachments.subs.php');
    895. 

  895. 

  896. 		$attachments = array();
    897. 

  897. 		// There must be a quicker way to pass this safety test??
    898. 

  898. 		foreach ($_POST['remove'] as $removeID => $dummy)
    899. 

  899. 			$attachments[] = (int) $removeID;
    900. 

  900. 

  901. 		if ($_REQUEST['type'] == 'avatars' && !empty($attachments))
    902. 

  902. 			removeAttachments(array('id_attach' => $attachments));
    903. 

  903. 		else if (!empty($attachments))
    904. 

  904. 		{
    905. 

  905. 			$messages = removeAttachments(array('id_attach' => $attachments), 'messages', true);
    906. 

  906. 

  907. 			// And change the message to reflect this.
    908. 

  908. 			if (!empty($messages))
    909. 

  909. 			{
    910. 

  910. 				loadLanguage('index', $language, true);
    911. 

  911. 				$smcFunc['db_query']('', '
    912. 

  912. 					UPDATE {db_prefix}messages
    913. 

  913. 					SET body = CONCAT(body, {string:deleted_message})
    914. 

  914. 					WHERE id_msg IN ({array_int:messages_affected})',
    915. 

  915. 					array(
    916. 

  916. 						'messages_affected' => $messages,
    917. 

  917. 						'deleted_message' => '<br /><br />' . $txt['attachment_delete_admin'],
    918. 

  918. 					)
    919. 

  919. 				);
    920. 

  920. 				loadLanguage('index', $user_info['language'], true);
    921. 

  921. 			}
    922. 

  922. 		}
    923. 

  923. 	}
    924. 

  924. 

  925. 	$_GET['sort'] = isset($_GET['sort']) ? $_GET['sort'] : 'date';
    926. 

  926. 	redirectexit('action=admin;area=manageattachments;sa=browse;' . $_REQUEST['type'] . ';sort=' . $_GET['sort'] . (isset($_GET['desc']) ? ';desc' : '') . ';start=' . $_REQUEST['start']);
    927. 

  927. }
    928. 

  928. 

  929. /**
    930. 

  930.  * Removes all attachments in a single click
    931. 

  931.  * Called from the maintenance screen by
    932. 

  932.  *  ?action=admin;area=manageattachments;sa=removeall.
    933. 

  933.  */
    934. 

  934. function action_removeall()
    935. 

  935. {
    936. 

  936. 	global $txt, $smcFunc;
    937. 

  937. 

  938. 	checkSession('get', 'admin');
    939. 

  939. 

  940. 	// lots of work to do
    941. 

  941. 	require_once(SUBSDIR . '/Attachments.subs.php');
    942. 

  942. 

  943. 	$messages = removeAttachments(array('attachment_type' => 0), '', true);
    944. 

  944. 

  945. 	if (!isset($_POST['notice']))
    946. 

  946. 		$_POST['notice'] = $txt['attachment_delete_admin'];
    947. 

  947. 

  948. 	// Add the notice on the end of the changed messages.
    949. 

  949. 	if (!empty($messages))
    950. 

  950. 		$smcFunc['db_query']('', '
    951. 

  951. 			UPDATE {db_prefix}messages
    952. 

  952. 			SET body = CONCAT(body, {string:deleted_message})
    953. 

  953. 			WHERE id_msg IN ({array_int:messages})',
    954. 

  954. 			array(
    955. 

  955. 				'messages' => $messages,
    956. 

  956. 				'deleted_message' => '<br /><br />' . $_POST['notice'],
    957. 

  957. 			)
    958. 

  958. 		);
    959. 

  959. 

  960. 	redirectexit('action=admin;area=manageattachments;sa=maintenance');
    961. 

  961. }
    962. 

  962. 

  963. /**
    964. 

  964.  * This function should find attachments in the database that no longer exist and clear them, and fix filesize issues.
    965. 

  965.  */
    966. 

  966. function action_repair()
    967. 

  967. {
    968. 

  968. 	global $modSettings, $context, $txt, $smcFunc;
    969. 

  969. 

  970. 	checkSession('get');
    971. 

  971. 

  972. 	// If we choose cancel, redirect right back.
    973. 

  973. 	if (isset($_POST['cancel']))
    974. 

  974. 		redirectexit('action=admin;area=manageattachments;sa=maintenance');
    975. 

  975. 

  976. 	// Try give us a while to sort this out...
    977. 

  977. 	@set_time_limit(600);
    978. 

  978. 

  979. 	$_GET['step'] = empty($_GET['step']) ? 0 : (int) $_GET['step'];
    980. 

  980. 	$context['starting_substep'] = $_GET['substep'] = empty($_GET['substep']) ? 0 : (int) $_GET['substep'];
    981. 

  981. 

  982. 	// Don't recall the session just in case.
    983. 

  983. 	if ($_GET['step'] == 0 && $_GET['substep'] == 0)
    984. 

  984. 	{
    985. 

  985. 		unset($_SESSION['attachments_to_fix'], $_SESSION['attachments_to_fix2']);
    986. 

  986. 

  987. 		// If we're actually fixing stuff - work out what.
    988. 

  988. 		if (isset($_GET['fixErrors']))
    989. 

  989. 		{
    990. 

  990. 			// Nothing?
    991. 

  991. 			if (empty($_POST['to_fix']))
    992. 

  992. 				redirectexit('action=admin;area=manageattachments;sa=maintenance');
    993. 

  993. 

  994. 			$_SESSION['attachments_to_fix'] = array();
    995. 

  995. 			// @todo No need to do this I think.
    996. 

  996. 			foreach ($_POST['to_fix'] as $key => $value)
    997. 

  997. 				$_SESSION['attachments_to_fix'][] = $value;
    998. 

  998. 		}
    999. 

  999. 	}
    1000. 

  1000. 

  1001. 	// We will work hard with attachments.
    1002. 

  1002. 	require_once(SUBSDIR . '/Attachments.subs.php');
    1003. 

  1003. 

  1004. 	// All the valid problems are here:
    1005. 

  1005. 	$context['repair_errors'] = array(
    1006. 

  1006. 		'missing_thumbnail_parent' => 0,
    1007. 

  1007. 		'parent_missing_thumbnail' => 0,
    1008. 

  1008. 		'file_missing_on_disk' => 0,
    1009. 

  1009. 		'file_wrong_size' => 0,
    1010. 

  1010. 		'file_size_of_zero' => 0,
    1011. 

  1011. 		'attachment_no_msg' => 0,
    1012. 

  1012. 		'avatar_no_member' => 0,
    1013. 

  1013. 		'wrong_folder' => 0,
    1014. 

  1014. 		'files_without_attachment' => 0,
    1015. 

  1015. 	);
    1016. 

  1016. 

  1017. 	$to_fix = !empty($_SESSION['attachments_to_fix']) ? $_SESSION['attachments_to_fix'] : array();
    1018. 

  1018. 	$context['repair_errors'] = isset($_SESSION['attachments_to_fix2']) ? $_SESSION['attachments_to_fix2'] : $context['repair_errors'];
    1019. 

  1019. 	$fix_errors = isset($_GET['fixErrors']) ? true : false;
    1020. 

  1020. 

  1021. 	// Get stranded thumbnails.
    1022. 

  1022. 	if ($_GET['step'] <= 0)
    1023. 

  1023. 	{
    1024. 

  1024. 		$result = $smcFunc['db_query']('', '
    1025. 

  1025. 			SELECT MAX(id_attach)
    1026. 

  1026. 			FROM {db_prefix}attachments
    1027. 

  1027. 			WHERE attachment_type = {int:thumbnail}',
    1028. 

  1028. 			array(
    1029. 

  1029. 				'thumbnail' => 3,
    1030. 

  1030. 			)
    1031. 

  1031. 		);
    1032. 

  1032. 		list ($thumbnails) = $smcFunc['db_fetch_row']($result);
    1033. 

  1033. 		$smcFunc['db_free_result']($result);
    1034. 

  1034. 

  1035. 		for (; $_GET['substep'] < $thumbnails; $_GET['substep'] += 500)
    1036. 

  1036. 		{
    1037. 

  1037. 			$to_remove = array();
    1038. 

  1038. 

  1039. 			$result = $smcFunc['db_query']('', '
    1040. 

  1040. 				SELECT thumb.id_attach, thumb.id_folder, thumb.filename, thumb.file_hash
    1041. 

  1041. 				FROM {db_prefix}attachments AS thumb
    1042. 

  1042. 					LEFT JOIN {db_prefix}attachments AS tparent ON (tparent.id_thumb = thumb.id_attach)
    1043. 

  1043. 				WHERE thumb.id_attach BETWEEN {int:substep} AND {int:substep} + 499
    1044. 

  1044. 					AND thumb.attachment_type = {int:thumbnail}
    1045. 

  1045. 					AND tparent.id_attach IS NULL',
    1046. 

  1046. 				array(
    1047. 

  1047. 					'thumbnail' => 3,
    1048. 

  1048. 					'substep' => $_GET['substep'],
    1049. 

  1049. 				)
    1050. 

  1050. 			);
    1051. 

  1051. 			while ($row = $smcFunc['db_fetch_assoc']($result))
    1052. 

  1052. 			{
    1053. 

  1053. 				// Only do anything once... just in case
    1054. 

  1054. 				if (!isset($to_remove[$row['id_attach']]))
    1055. 

  1055. 				{
    1056. 

  1056. 					$to_remove[$row['id_attach']] = $row['id_attach'];
    1057. 

  1057. 					$context['repair_errors']['missing_thumbnail_parent']++;
    1058. 

  1058. 

  1059. 					// If we are repairing remove the file from disk now.
    1060. 

  1060. 					if ($fix_errors && in_array('missing_thumbnail_parent', $to_fix))
    1061. 

  1061. 					{
    1062. 

  1062. 						$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
    1063. 

  1063. 						@unlink($filename);
    1064. 

  1064. 					}
    1065. 

  1065. 				}
    1066. 

  1066. 			}
    1067. 

  1067. 			if ($smcFunc['db_num_rows']($result) != 0)
    1068. 

  1068. 				$to_fix[] = 'missing_thumbnail_parent';
    1069. 

  1069. 			$smcFunc['db_free_result']($result);
    1070. 

  1070. 

  1071. 			// Do we need to delete what we have?
    1072. 

  1072. 			if ($fix_errors && !empty($to_remove) && in_array('missing_thumbnail_parent', $to_fix))
    1073. 

  1073. 				$smcFunc['db_query']('', '
    1074. 

  1074. 					DELETE FROM {db_prefix}attachments
    1075. 

  1075. 					WHERE id_attach IN ({array_int:to_remove})
    1076. 

  1076. 						AND attachment_type = {int:attachment_type}',
    1077. 

  1077. 					array(
    1078. 

  1078. 						'to_remove' => $to_remove,
    1079. 

  1079. 						'attachment_type' => 3,
    1080. 

  1080. 					)
    1081. 

  1081. 				);
    1082. 

  1082. 

  1083. 			pauseAttachmentMaintenance($to_fix, $thumbnails);
    1084. 

  1084. 		}
    1085. 

  1085. 

  1086. 		$_GET['step'] = 1;
    1087. 

  1087. 		$_GET['substep'] = 0;
    1088. 

  1088. 		pauseAttachmentMaintenance($to_fix);
    1089. 

  1089. 	}
    1090. 

  1090. 

  1091. 	// Find parents which think they have thumbnails, but actually, don't.
    1092. 

  1092. 	if ($_GET['step'] <= 1)
    1093. 

  1093. 	{
    1094. 

  1094. 		$thumbnails = maxThumbnails();
    1095. 

  1095. 

  1096. 		for (; $_GET['substep'] < $thumbnails; $_GET['substep'] += 500)
    1097. 

  1097. 		{
    1098. 

  1098. 			$to_update = array();
    1099. 

  1099. 

  1100. 			$result = $smcFunc['db_query']('', '
    1101. 

  1101. 				SELECT a.id_attach
    1102. 

  1102. 				FROM {db_prefix}attachments AS a
    1103. 

  1103. 					LEFT JOIN {db_prefix}attachments AS thumb ON (thumb.id_attach = a.id_thumb)
    1104. 

  1104. 				WHERE a.id_attach BETWEEN {int:substep} AND {int:substep} + 499
    1105. 

  1105. 					AND a.id_thumb != {int:no_thumb}
    1106. 

  1106. 					AND thumb.id_attach IS NULL',
    1107. 

  1107. 				array(
    1108. 

  1108. 					'no_thumb' => 0,
    1109. 

  1109. 					'substep' => $_GET['substep'],
    1110. 

  1110. 				)
    1111. 

  1111. 			);
    1112. 

  1112. 			while ($row = $smcFunc['db_fetch_assoc']($result))
    1113. 

  1113. 			{
    1114. 

  1114. 				$to_update[] = $row['id_attach'];
    1115. 

  1115. 				$context['repair_errors']['parent_missing_thumbnail']++;
    1116. 

  1116. 			}
    1117. 

  1117. 			if ($smcFunc['db_num_rows']($result) != 0)
    1118. 

  1118. 				$to_fix[] = 'parent_missing_thumbnail';
    1119. 

  1119. 			$smcFunc['db_free_result']($result);
    1120. 

  1120. 

  1121. 			// Do we need to delete what we have?
    1122. 

  1122. 			if ($fix_errors && !empty($to_update) && in_array('parent_missing_thumbnail', $to_fix))
    1123. 

  1123. 				$smcFunc['db_query']('', '
    1124. 

  1124. 					UPDATE {db_prefix}attachments
    1125. 

  1125. 					SET id_thumb = {int:no_thumb}
    1126. 

  1126. 					WHERE id_attach IN ({array_int:to_update})',
    1127. 

  1127. 					array(
    1128. 

  1128. 						'to_update' => $to_update,
    1129. 

  1129. 						'no_thumb' => 0,
    1130. 

  1130. 					)
    1131. 

  1131. 				);
    1132. 

  1132. 

  1133. 			pauseAttachmentMaintenance($to_fix, $thumbnails);
    1134. 

  1134. 		}
    1135. 

  1135. 

  1136. 		$_GET['step'] = 2;
    1137. 

  1137. 		$_GET['substep'] = 0;
    1138. 

  1138. 		pauseAttachmentMaintenance($to_fix);
    1139. 

  1139. 	}
    1140. 

  1140. 

  1141. 	// This may take forever I'm afraid, but life sucks... recount EVERY attachments!
    1142. 

  1142. 	if ($_GET['step'] <= 2)
    1143. 

  1143. 	{
    1144. 

  1144. 		$result = $smcFunc['db_query']('', '
    1145. 

  1145. 			SELECT MAX(id_attach)
    1146. 

  1146. 			FROM {db_prefix}attachments',
    1147. 

  1147. 			array(
    1148. 

  1148. 			)
    1149. 

  1149. 		);
    1150. 

  1150. 		list ($thumbnails) = $smcFunc['db_fetch_row']($result);
    1151. 

  1151. 		$smcFunc['db_free_result']($result);
    1152. 

  1152. 

  1153. 		for (; $_GET['substep'] < $thumbnails; $_GET['substep'] += 250)
    1154. 

  1154. 		{
    1155. 

  1155. 			$to_remove = array();
    1156. 

  1156. 			$errors_found = array();
    1157. 

  1157. 

  1158. 			$result = $smcFunc['db_query']('', '
    1159. 

  1159. 				SELECT id_attach, id_folder, filename, file_hash, size, attachment_type
    1160. 

  1160. 				FROM {db_prefix}attachments
    1161. 

  1161. 				WHERE id_attach BETWEEN {int:substep} AND {int:substep} + 249',
    1162. 

  1162. 				array(
    1163. 

  1163. 					'substep' => $_GET['substep'],
    1164. 

  1164. 				)
    1165. 

  1165. 			);
    1166. 

  1166. 			while ($row = $smcFunc['db_fetch_assoc']($result))
    1167. 

  1167. 			{
    1168. 

  1168. 				// Get the filename.
    1169. 

  1169. 				if ($row['attachment_type'] == 1)
    1170. 

  1170. 					$filename = $modSettings['custom_avatar_dir'] . '/' . $row['filename'];
    1171. 

  1171. 				else
    1172. 

  1172. 					$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
    1173. 

  1173. 

  1174. 				// File doesn't exist?
    1175. 

  1175. 				if (!file_exists($filename))
    1176. 

  1176. 				{
    1177. 

  1177. 					// If we're lucky it might just be in a different folder.
    1178. 

  1178. 					if (!empty($modSettings['currentAttachmentUploadDir']))
    1179. 

  1179. 					{
    1180. 

  1180. 						// Get the attachment name with out the folder.
    1181. 

  1181. 						$attachment_name = !empty($row['file_hash']) ? $row['id_attach'] . '_' . $row['file_hash'] : getLegacyAttachmentFilename($row['filename'], $row['id_attach'], null, true);
    1182. 

  1182. 

  1183. 						if (!is_array($modSettings['attachmentUploadDir']))
    1184. 

  1184. 							$modSettings['attachmentUploadDir'] = unserialize($modSettings['attachmentUploadDir']);
    1185. 

  1185. 

  1186. 						// Loop through the other folders.
    1187. 

  1187. 						foreach ($modSettings['attachmentUploadDir'] as $id => $dir)
    1188. 

  1188. 							if (file_exists($dir . '/' . $attachment_name))
    1189. 

  1189. 							{
    1190. 

  1190. 								$context['repair_errors']['wrong_folder']++;
    1191. 

  1191. 								$errors_found[] = 'wrong_folder';
    1192. 

  1192. 

  1193. 								// Are we going to fix this now?
    1194. 

  1194. 								if ($fix_errors && in_array('wrong_folder', $to_fix))
    1195. 

  1195. 									attachment_folder($row['id_attach'], $id);
    1196. 

  1196. 

  1197. 								continue 2;
    1198. 

  1198. 							}
    1199. 

  1199. 					}
    1200. 

  1200. 

  1201. 					$to_remove[] = $row['id_attach'];
    1202. 

  1202. 					$context['repair_errors']['file_missing_on_disk']++;
    1203. 

  1203. 					$errors_found[] = 'file_missing_on_disk';
    1204. 

  1204. 				}
    1205. 

  1205. 				elseif (filesize($filename) == 0)
    1206. 

  1206. 				{
    1207. 

  1207. 					$context['repair_errors']['file_size_of_zero']++;
    1208. 

  1208. 					$errors_found[] = 'file_size_of_zero';
    1209. 

  1209. 

  1210. 					// Fixing?
    1211. 

  1211. 					if ($fix_errors && in_array('file_size_of_zero', $to_fix))
    1212. 

  1212. 					{
    1213. 

  1213. 						$to_remove[] = $row['id_attach'];
    1214. 

  1214. 						@unlink($filename);
    1215. 

  1215. 					}
    1216. 

  1216. 				}
    1217. 

  1217. 				elseif (filesize($filename) != $row['size'])
    1218. 

  1218. 				{
    1219. 

  1219. 					$context['repair_errors']['file_wrong_size']++;
    1220. 

  1220. 					$errors_found[] = 'file_wrong_size';
    1221. 

  1221. 

  1222. 					// Fix it here?
    1223. 

  1223. 					if ($fix_errors && in_array('file_wrong_size', $to_fix))
    1224. 

  1224. 						attachment_filesize($row['id_attach'], filesize($filename));
    1225. 

  1225. 				}
    1226. 

  1226. 			}
    1227. 

  1227. 

  1228. 			if (in_array('file_missing_on_disk', $errors_found))
    1229. 

  1229. 				$to_fix[] = 'file_missing_on_disk';
    1230. 

  1230. 			if (in_array('file_size_of_zero', $errors_found))
    1231. 

  1231. 				$to_fix[] = 'file_size_of_zero';
    1232. 

  1232. 			if (in_array('file_wrong_size', $errors_found))
    1233. 

  1233. 				$to_fix[] = 'file_wrong_size';
    1234. 

  1234. 			if (in_array('wrong_folder', $errors_found))
    1235. 

  1235. 				$to_fix[] = 'wrong_folder';
    1236. 

  1236. 			$smcFunc['db_free_result']($result);
    1237. 

  1237. 

  1238. 			// Do we need to delete what we have?
    1239. 

  1239. 			if ($fix_errors && !empty($to_remove))
    1240. 

  1240. 				removeOrphanAttachments($to_remove);
    1241. 

  1241. 

  1242. 			pauseAttachmentMaintenance($to_fix, $thumbnails);
    1243. 

  1243. 		}
    1244. 

  1244. 

  1245. 		$_GET['step'] = 3;
    1246. 

  1246. 		$_GET['substep'] = 0;
    1247. 

  1247. 		pauseAttachmentMaintenance($to_fix);
    1248. 

  1248. 	}
    1249. 

  1249. 

  1250. 	// Get avatars with no members associated with them.
    1251. 

  1251. 	if ($_GET['step'] <= 3)
    1252. 

  1252. 	{
    1253. 

  1253. 		$result = $smcFunc['db_query']('', '
    1254. 

  1254. 			SELECT MAX(id_attach)
    1255. 

  1255. 			FROM {db_prefix}attachments',
    1256. 

  1256. 			array(
    1257. 

  1257. 			)
    1258. 

  1258. 		);
    1259. 

  1259. 		list ($thumbnails) = $smcFunc['db_fetch_row']($result);
    1260. 

  1260. 		$smcFunc['db_free_result']($result);
    1261. 

  1261. 

  1262. 		for (; $_GET['substep'] < $thumbnails; $_GET['substep'] += 500)
    1263. 

  1263. 		{
    1264. 

  1264. 			$to_remove = array();
    1265. 

  1265. 

  1266. 			$result = $smcFunc['db_query']('', '
    1267. 

  1267. 				SELECT a.id_attach, a.id_folder, a.filename, a.file_hash, a.attachment_type
    1268. 

  1268. 				FROM {db_prefix}attachments AS a
    1269. 

  1269. 					LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = a.id_member)
    1270. 

  1270. 				WHERE a.id_attach BETWEEN {int:substep} AND {int:substep} + 499
    1271. 

  1271. 					AND a.id_member != {int:no_member}
    1272. 

  1272. 					AND a.id_msg = {int:no_msg}
    1273. 

  1273. 					AND mem.id_member IS NULL',
    1274. 

  1274. 				array(
    1275. 

  1275. 					'no_member' => 0,
    1276. 

  1276. 					'no_msg' => 0,
    1277. 

  1277. 					'substep' => $_GET['substep'],
    1278. 

  1278. 				)
    1279. 

  1279. 			);
    1280. 

  1280. 			while ($row = $smcFunc['db_fetch_assoc']($result))
    1281. 

  1281. 			{
    1282. 

  1282. 				$to_remove[] = $row['id_attach'];
    1283. 

  1283. 				$context['repair_errors']['avatar_no_member']++;
    1284. 

  1284. 

  1285. 				// If we are repairing remove the file from disk now.
    1286. 

  1286. 				if ($fix_errors && in_array('avatar_no_member', $to_fix))
    1287. 

  1287. 				{
    1288. 

  1288. 					if ($row['attachment_type'] == 1)
    1289. 

  1289. 						$filename = $modSettings['custom_avatar_dir'] . '/' . $row['filename'];
    1290. 

  1290. 					else
    1291. 

  1291. 						$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
    1292. 

  1292. 					@unlink($filename);
    1293. 

  1293. 				}
    1294. 

  1294. 			}
    1295. 

  1295. 			if ($smcFunc['db_num_rows']($result) != 0)
    1296. 

  1296. 				$to_fix[] = 'avatar_no_member';
    1297. 

  1297. 			$smcFunc['db_free_result']($result);
    1298. 

  1298. 

  1299. 			// Do we need to delete what we have?
    1300. 

  1300. 			if ($fix_errors && !empty($to_remove) && in_array('avatar_no_member', $to_fix))
    1301. 

  1301. 				$smcFunc['db_query']('', '
    1302. 

  1302. 					DELETE FROM {db_prefix}attachments
    1303. 

  1303. 					WHERE id_attach IN ({array_int:to_remove})
    1304. 

  1304. 						AND id_member != {int:no_member}
    1305. 

  1305. 						AND id_msg = {int:no_msg}',
    1306. 

  1306. 					array(
    1307. 

  1307. 						'to_remove' => $to_remove,
    1308. 

  1308. 						'no_member' => 0,
    1309. 

  1309. 						'no_msg' => 0,
    1310. 

  1310. 					)
    1311. 

  1311. 				);
    1312. 

  1312. 

  1313. 			pauseAttachmentMaintenance($to_fix, $thumbnails);
    1314. 

  1314. 		}
    1315. 

  1315. 

  1316. 		$_GET['step'] = 4;
    1317. 

  1317. 		$_GET['substep'] = 0;
    1318. 

  1318. 		pauseAttachmentMaintenance($to_fix);
    1319. 

  1319. 	}
    1320. 

  1320. 

  1321. 	// What about attachments, who are missing a message :'(
    1322. 

  1322. 	if ($_GET['step'] <= 4)
    1323. 

  1323. 	{
    1324. 

  1324. 		$result = $smcFunc['db_query']('', '
    1325. 

  1325. 			SELECT MAX(id_attach)
    1326. 

  1326. 			FROM {db_prefix}attachments',
    1327. 

  1327. 			array(
    1328. 

  1328. 			)
    1329. 

  1329. 		);
    1330. 

  1330. 		list ($thumbnails) = $smcFunc['db_fetch_row']($result);
    1331. 

  1331. 		$smcFunc['db_free_result']($result);
    1332. 

  1332. 

  1333. 		for (; $_GET['substep'] < $thumbnails; $_GET['substep'] += 500)
    1334. 

  1334. 		{
    1335. 

  1335. 			$to_remove = array();
    1336. 

  1336. 

  1337. 			$result = $smcFunc['db_query']('', '
    1338. 

  1338. 				SELECT a.id_attach, a.id_folder, a.filename, a.file_hash
    1339. 

  1339. 				FROM {db_prefix}attachments AS a
    1340. 

  1340. 					LEFT JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
    1341. 

  1341. 				WHERE a.id_attach BETWEEN {int:substep} AND {int:substep} + 499
    1342. 

  1342. 					AND a.id_member = {int:no_member}
    1343. 

  1343. 					AND a.id_msg != {int:no_msg}
    1344. 

  1344. 					AND m.id_msg IS NULL',
    1345. 

  1345. 				array(
    1346. 

  1346. 					'no_member' => 0,
    1347. 

  1347. 					'no_msg' => 0,
    1348. 

  1348. 					'substep' => $_GET['substep'],
    1349. 

  1349. 				)
    1350. 

  1350. 			);
    1351. 

  1351. 			while ($row = $smcFunc['db_fetch_assoc']($result))
    1352. 

  1352. 			{
    1353. 

  1353. 				$to_remove[] = $row['id_attach'];
    1354. 

  1354. 				$context['repair_errors']['attachment_no_msg']++;
    1355. 

  1355. 

  1356. 				// If we are repairing remove the file from disk now.
    1357. 

  1357. 				if ($fix_errors && in_array('attachment_no_msg', $to_fix))
    1358. 

  1358. 				{
    1359. 

  1359. 					$filename = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);
    1360. 

  1360. 					@unlink($filename);
    1361. 

  1361. 				}
    1362. 

  1362. 			}
    1363. 

  1363. 			if ($smcFunc['db_num_rows']($result) != 0)
    1364. 

  1364. 				$to_fix[] = 'attachment_no_msg';
    1365. 

  1365. 			$smcFunc['db_free_result']($result);
    1366. 

  1366. 

  1367. 			// Do we need to delete what we have?
    1368. 

  1368. 			if ($fix_errors && !empty($to_remove) && in_array('a…
    1369.

Large files files are truncated, but you can click here to view the full file