PageRenderTime 83ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 0ms

/Sources/ManageAttachments.php

https://github.com/smf-portal/SMF2.1
PHP | 2804 lines | 2156 code | 317 blank | 331 comment | 354 complexity | bdad0f490f02cff1e33eca646315cf8b MD5 | raw file

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

    

  1. <?php
    2. 

  2. 

  3. /**
    4. 

  4.  * This file doing the job of attachments and avatars maintenance and management.
    5. 

  5.  * @todo refactor as controller-model
    6. 

  6.  *
    7. 

  7.  * Simple Machines Forum (SMF)
    8. 

  8.  *
    9. 

  9.  * @package SMF
    10. 

  10.  * @author Simple Machines http://www.simplemachines.org
    11. 

  11.  * @copyright 2012 Simple Machines
    12. 

  12.  * @license http://www.simplemachines.org/about/smf/license.php BSD
    13. 

  13.  *
    14. 

  14.  * @version 2.1 Alpha 1
    15. 

  15.  */
    16. 

  16. 

  17. if (!defined('SMF'))
    18. 

  18. 	die('Hacking attempt...');
    19. 

  19. 

  20. /**
    21. 

  21.  * The main 'Attachments and Avatars' management function.
    22. 

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

  23.  * and it calls a function based on the sub-action.
    24. 

  24.  * It requires the manage_attachments permission.
    25. 

  25.  *
    26. 

  26.  * @uses ManageAttachments template.
    27. 

  27.  * @uses Admin language file.
    28. 

  28.  * @uses template layer 'manage_files' for showing the tab bar.
    29. 

  29.  *
    30. 

  30.  */
    31. 

  31. function ManageAttachments()
    32. 

  32. {
    33. 

  33. 	global $txt, $modSettings, $scripturl, $context, $options;
    34. 

  34. 

  35. 	// You have to be able to moderate the forum to do this.
    36. 

  36. 	isAllowedTo('manage_attachments');
    37. 

  37. 

  38. 	// Setup the template stuff we'll probably need.
    39. 

  39. 	loadTemplate('ManageAttachments');
    40. 

  40. 

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

  42. 	$subActions = array(
    43. 

  43. 		'attachments' => 'ManageAttachmentSettings',
    44. 

  44. 		'attachpaths' => 'ManageAttachmentPaths',
    45. 

  45. 		'avatars' => 'ManageAvatarSettings',
    46. 

  46. 		'browse' => 'BrowseFiles',
    47. 

  47. 		'byAge' => 'RemoveAttachmentByAge',
    48. 

  48. 		'bySize' => 'RemoveAttachmentBySize',
    49. 

  49. 		'maintenance' => 'MaintainFiles',
    50. 

  50. 		'moveAvatars' => 'MoveAvatars',
    51. 

  51. 		'repair' => 'RepairAttachments',
    52. 

  52. 		'remove' => 'RemoveAttachment',
    53. 

  53. 		'removeall' => 'RemoveAllAttachments',
    54. 

  54. 		'transfer' => 'TransferAttachments',
    55. 

  55. 	);
    56. 

  56. 

  57. 	call_integration_hook('integrate_manage_attachments', array($subActions));
    58. 

  58. 

  59. 	// Pick the correct sub-action.
    60. 

  60. 	if (isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]))
    61. 

  61. 		$context['sub_action'] = $_REQUEST['sa'];
    62. 

  62. 	else
    63. 

  63. 		$context['sub_action'] = 'browse';
    64. 

  64. 

  65. 	// Default page title is good.
    66. 

  66. 	$context['page_title'] = $txt['attachments_avatars'];
    67. 

  67. 

  68. 	// This uses admin tabs - as it should!
    69. 

  69. 	$context[$context['admin_menu_name']]['tab_data'] = array(
    70. 

  70. 		'title' => $txt['attachments_avatars'],
    71. 

  71. 		'help' => 'manage_files',
    72. 

  72. 		'description' => $txt['attachments_desc'],
    73. 

  73. 	);
    74. 

  74. 

  75. 	// Finally fall through to what we are doing.
    76. 

  76. 	$subActions[$context['sub_action']]();
    77. 

  77. }
    78. 

  78. 

  79. /**
    80. 

  80.  * Allows to show/change attachment settings.
    81. 

  81.  * This is the default sub-action of the 'Attachments and Avatars' center.
    82. 

  82.  * Called by index.php?action=admin;area=manageattachments;sa=attachments.
    83. 

  83.  *
    84. 

  84.  * @param bool $return_config = false
    85. 

  85.  * @uses 'attachments' sub template.
    86. 

  86.  */
    87. 

  87. 

  88. function ManageAttachmentSettings($return_config = false)
    89. 

  89. {
    90. 

  90. 	global $txt, $modSettings, $scripturl, $context, $options, $sourcedir, $boarddir;
    91. 

  91. 

  92. 	require_once($sourcedir . '/Subs-Attachments.php');
    93. 

  93. 

  94. 	// Get the current attachment directory.
    95. 

  95. 	$modSettings['attachmentUploadDir'] = unserialize($modSettings['attachmentUploadDir']);
    96. 

  96. 	$context['attachmentUploadDir'] = $modSettings['attachmentUploadDir'][$modSettings['currentAttachmentUploadDir']];
    97. 

  97. 

  98. 	// First time here?
    99. 

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

  100. 		$modSettings['attachmentUploadDir'] = $modSettings['attachmentUploadDir'][1];
    101. 

  101. 

  102. 	// If not set, show a default path for the base directory
    103. 

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

  104. 		if (is_dir($modSettings['attachmentUploadDir'][1]))
    105. 

  105. 			$modSettings['basedirectory_for_attachments'] = $modSettings['attachmentUploadDir'][1];		
    106. 

  106. 		else
    107. 

  107. 			$modSettings['basedirectory_for_attachments'] = $context['attachmentUploadDir'];
    108. 

  108. 

  109. 	$context['valid_upload_dir'] = is_dir($context['attachmentUploadDir']) && is_writable($context['attachmentUploadDir']);
    110. 

  110. 

  111. 	if (!empty($modSettings['automanage_attachments']))
    112. 

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

  113. 	else
    114. 

  114. 		$context['valid_basedirectory'] = true;
    115. 

  115. 

  116. 	// A bit of razzle dazzle with the $txt strings. :)
    117. 

  117. 	$txt['attachment_path'] = $context['attachmentUploadDir'];
    118. 

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

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

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

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

  122. 	$txt['attach_current_dir_warning'] = $txt['attach_current_dir'] . $txt['attach_current_dir_warning'];
    123. 

  123. 	$txt['basedirectory_for_attachments_warning'] = $txt['basedirectory_for_attachments_current'] . $txt['basedirectory_for_attachments_warning'];
    124. 

  124. 

  125. 	// Perform a test to see if the GD module or ImageMagick are installed.
    126. 

  126. 	$testImg = get_extension_funcs('gd') || class_exists('Imagick');
    127. 

  127. 

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

  129. 	$post_max_size = ini_get('post_max_size');
    130. 

  130. 	$upload_max_filesize = ini_get('upload_max_filesize');
    131. 

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

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

  133. 

  134. 	$config_vars = array(
    135. 

  135. 		array('title', 'attachment_manager_settings'),
    136. 

  136. 			// Are attachments enabled?
    137. 

  137. 			array('select', 'attachmentEnable', array($txt['attachmentEnable_deactivate'], $txt['attachmentEnable_enable_all'], $txt['attachmentEnable_disable_new'])),
    138. 

  138. 		'',
    139. 

  139. 			// Extension checks etc.
    140. 

  140. 			array('check', 'attachmentRecodeLineEndings'),
    141. 

  141. 		'',
    142. 

  142. 			// Directory and size limits.
    143. 

  143. 			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'])),
    144. 

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

  145. 			(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']))),
    146. 

  146. 			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'])),
    147. 

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

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

  149. 		'',
    150. 

  150. 			// Posting limits
    151. 

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

  152. 			array('warning', empty($testPM) ? 'attachment_postsize_warning' : ''),
    153. 

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

  154. 			array('warning', empty($testUM) ? 'attachment_filesize_warning' : ''),
    155. 

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

  156. 			// Security Items
    157. 

  157. 		array('title', 'attachment_security_settings'),
    158. 

  158. 			// Extension checks etc.
    159. 

  159. 			array('check', 'attachmentCheckExtensions'),
    160. 

  160. 			array('text', 'attachmentExtensions', 40),
    161. 

  161. 		'',
    162. 

  162. 			// Image checks.
    163. 

  163. 			array('warning', empty($testImg) ? 'attachment_img_enc_warning' : ''),
    164. 

  164. 			array('check', 'attachment_image_reencode'),
    165. 

  165. 		'',
    166. 

  166. 			array('warning', 'attachment_image_paranoid_warning'),
    167. 

  167. 			array('check', 'attachment_image_paranoid'),
    168. 

  168. 			// Thumbnail settings.
    169. 

  169. 		array('title', 'attachment_thumbnail_settings'),
    170. 

  170. 			array('check', 'attachmentShowImages'),
    171. 

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

  172. 			array('check', 'attachment_thumb_png'),
    173. 

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

  174. 			array('warning', 'attachment_thumb_memory_note'),
    175. 

  175. 			array('text', 'attachmentThumbWidth', 6),
    176. 

  176. 			array('text', 'attachmentThumbHeight', 6),
    177. 

  177. 		'',
    178. 

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

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

  180. 	);
    181. 

  181. 

  182. 	$context['settings_post_javascript'] = '
    183. 

  183. 	var storing_type = document.getElementById(\'automanage_attachments\');
    184. 

  184. 	var base_dir = document.getElementById(\'use_subdirectories_for_attachments\');
    185. 

    186. 

  186. 	createEventListener(storing_type)
    187. 

  187. 	storing_type.addEventListener("change", toggleSubDir, false);
    188. 

  188. 	createEventListener(base_dir)
    189. 

  189. 	base_dir.addEventListener("change", toggleSubDir, false);
    190. 

  190. 	toggleSubDir();';
    191. 

    192. 

  192. 	call_integration_hook('integrate_modify_attachment_settings', array($config_vars));
    193. 

  193. 

  194. 	if ($return_config)
    195. 

  195. 		return $config_vars;
    196. 

  196. 

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

  198. 	require_once($sourcedir . '/ManagePermissions.php');
    199. 

  199. 	require_once($sourcedir . '/ManageServer.php');
    200. 

  200. 

  201. 	// Saving settings?
    202. 

  202. 	if (isset($_GET['save']))
    203. 

  203. 	{
    204. 

  204. 		checkSession();
    205. 

  205. 

  206. 		if (isset($_POST['attachmentUploadDir']))
    207. 

  207. 		{
    208. 

  208. 			if (!empty($_POST['attachmentUploadDir']) && $modSettings['attachmentUploadDir'] != $_POST['attachmentUploadDir'])
    209. 

  209. 				rename($modSettings['attachmentUploadDir'], $_POST['attachmentUploadDir']);
    210. 

  210. 

  211. 			$modSettings['attachmentUploadDir'] = array(1 => $_POST['attachmentUploadDir']);
    212. 

  212. 			$_POST['attachmentUploadDir'] = serialize($modSettings['attachmentUploadDir']);
    213. 

  213. 		}
    214. 

  214. 

  215. 		if (!empty($_POST['use_subdirectories_for_attachments']))
    216. 

  216. 		{
    217. 

  217. 			if(isset($_POST['use_subdirectories_for_attachments']) && empty($_POST['basedirectory_for_attachments']))
    218. 

  218. 				$_POST['basedirectory_for_attachments'] = (!empty($modSettings['basedirectory_for_attachments']) ? ($modSettings['basedirectory_for_attachments']) : $boarddir);
    219. 

  219. 

  220. 			if (!empty($_POST['use_subdirectories_for_attachments']) && !empty($modSettings['attachment_basedirectories']))
    221. 

  221. 			{
    222. 

  222. 				if (!is_array($modSettings['attachment_basedirectories']))
    223. 

  223. 					$modSettings['attachment_basedirectories'] = unserialize($modSettings['attachment_basedirectories']);
    224. 

  224. 			}
    225. 

  225. 			else
    226. 

  226. 				$modSettings['attachment_basedirectories'] = array();
    227. 

  227. 

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

  229. 			{
    230. 

  230. 				$currentAttachmentUploadDir = $modSettings['currentAttachmentUploadDir'];
    231. 

  231. 

  232. 				if (!in_array($_POST['basedirectory_for_attachments'], $modSettings['attachmentUploadDir']))
    233. 

  233. 				{
    234. 

  234. 					if (!automanage_attachments_create_directory($_POST['basedirectory_for_attachments']))
    235. 

  235. 						$_POST['basedirectory_for_attachments'] = $modSettings['basedirectory_for_attachments'];
    236. 

  236. 				}
    237. 

  237. 

  238. 				if (!in_array($_POST['basedirectory_for_attachments'], $modSettings['attachment_basedirectories']))
    239. 

  239. 				{
    240. 

  240. 					$modSettings['attachment_basedirectories'][$modSettings['currentAttachmentUploadDir']] = $_POST['basedirectory_for_attachments'];
    241. 

  241. 					updateSettings(array(
    242. 

  242. 						'attachment_basedirectories' => serialize($modSettings['attachment_basedirectories']),
    243. 

  243. 						'currentAttachmentUploadDir' => $currentAttachmentUploadDir,
    244. 

  244. 					));
    245. 

  245. 

  246. 					$_POST['use_subdirectories_for_attachments'] = 1;
    247. 

  247. 					$_POST['attachmentUploadDir'] = serialize($modSettings['attachmentUploadDir']);	
    248. 

  248. 

  249. 				}
    250. 

  250. 			}
    251. 

  251. 		}
    252. 

  252. 

  253. 		call_integration_hook('integrate_save_attachment_settings');
    254. 

  254. 

  255. 		saveDBSettings($config_vars);
    256. 

  256. 		redirectexit('action=admin;area=manageattachments;sa=attachments');
    257. 

  257. 	}
    258. 

  258. 

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

  260. 	prepareDBSettingContext($config_vars);
    261. 

  261. 

  262. 	$context['sub_template'] = 'show_settings';
    263. 

  263. }
    264. 

  264. 

  265. /**
    266. 

  266.  * This allows to show/change avatar settings.
    267. 

  267.  * Called by index.php?action=admin;area=manageattachments;sa=avatars.
    268. 

  268.  * Show/set permissions for permissions: 'profile_server_avatar',
    269. 

  269.  * 	'profile_upload_avatar' and 'profile_remote_avatar'.
    270. 

  270.  *
    271. 

  271.  * @param bool $return_config = false
    272. 

  272.  * @uses 'avatars' sub template.
    273. 

  273.  */
    274. 

  274. function ManageAvatarSettings($return_config = false)
    275. 

  275. {
    276. 

  276. 	global $txt, $context, $modSettings, $sourcedir, $scripturl;
    277. 

  277. 

  278. 	// Perform a test to see if the GD module or ImageMagick are installed.
    279. 

  279. 	$testImg = get_extension_funcs('gd') || class_exists('Imagick');
    280. 

  280. 

  281. 	$context['valid_avatar_dir'] = is_dir($modSettings['avatar_directory']);
    282. 

  282. 	$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']));
    283. 

  283. 

  284. 	$config_vars = array(
    285. 

  285. 		// Server stored avatars!
    286. 

  286. 		array('title', 'avatar_server_stored'),
    287. 

  287. 			array('warning', empty($testImg) ? 'avatar_img_enc_warning' : ''),
    288. 

  288. 			array('permissions', 'profile_server_avatar', 0, $txt['avatar_server_stored_groups']),
    289. 

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

  290. 			array('text', 'avatar_url', 40),
    291. 

  291. 		// External avatars?
    292. 

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

  293. 			array('permissions', 'profile_remote_avatar', 0, $txt['avatar_external_url_groups']),
    294. 

  294. 			array('check', 'avatar_download_external', 0, 'onchange' => 'fUpdateStatus();'),
    295. 

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

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

  297. 			array('select', 'avatar_action_too_large',
    298. 

  298. 				array(
    299. 

  299. 					'option_refuse' => $txt['option_refuse'],
    300. 

  300. 					'option_html_resize' => $txt['option_html_resize'],
    301. 

  301. 					'option_js_resize' => $txt['option_js_resize'],
    302. 

  302. 					'option_download_and_resize' => $txt['option_download_and_resize'],
    303. 

  303. 				),
    304. 

  304. 			),
    305. 

  305. 		// Uploadable avatars?
    306. 

  306. 		array('title', 'avatar_upload'),
    307. 

  307. 			array('permissions', 'profile_upload_avatar', 0, $txt['avatar_upload_groups']),
    308. 

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

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

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

  311. 			array('check', 'avatar_reencode'),
    312. 

  312. 		'',
    313. 

  313. 			array('warning', 'avatar_paranoid_warning'),
    314. 

  314. 			array('check', 'avatar_paranoid'),
    315. 

  315. 		'',
    316. 

  316. 			array('check', 'avatar_download_png'),
    317. 

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

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

  319. 			array('text', 'custom_avatar_url', 40),
    320. 

  320. 	);
    321. 

  321. 

  322. 	call_integration_hook('integrate_modify_avatar_settings', array($config_vars));
    323. 

  323. 

  324. 	if ($return_config)
    325. 

  325. 		return $config_vars;
    326. 

  326. 

  327. 	// We need this file for the settings template.
    328. 

  328. 	require_once($sourcedir . '/ManageServer.php');
    329. 

  329. 

  330. 	// Saving avatar settings?
    331. 

  331. 	if (isset($_GET['save']))
    332. 

  332. 	{
    333. 

  333. 		checkSession();
    334. 

  334. 

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

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

  337. 			$_POST['custom_avatar_enabled'] = 0;
    338. 

  338. 

  339. 		call_integration_hook('integrate_save_avatar_settings');
    340. 

  340. 

  341. 		saveDBSettings($config_vars);
    342. 

  342. 		redirectexit('action=admin;area=manageattachments;sa=avatars');
    343. 

  343. 	}
    344. 

  344. 

  345. 	// Attempt to figure out if the admin is trying to break things.
    346. 

  346. 	$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;';
    347. 

  347. 

  348. 	// We need this for the in-line permissions
    349. 

  349. 	createToken('admin-mp');
    350. 

  350. 

  351. 	// Prepare the context.
    352. 

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

  353. 	prepareDBSettingContext($config_vars);
    354. 

  354. 

  355. 	// Add a layer for the javascript.
    356. 

  356. 	$context['template_layers'][] = 'avatar_settings';
    357. 

  357. 	$context['sub_template'] = 'show_settings';
    358. 

  358. }
    359. 

  359. 

  360. /**
    361. 

  361.  * Show a list of attachment or avatar files.
    362. 

  362.  * Called by ?action=admin;area=manageattachments;sa=browse for attachments
    363. 

  363.  *  and ?action=admin;area=manageattachments;sa=browse;avatars for avatars.
    364. 

  364.  * Allows sorting by name, date, size and member.
    365. 

  365.  * Paginates results.
    366. 

  366.  *
    367. 

  367.  *  @uses the 'browse' sub template
    368. 

  368.  */
    369. 

  369. function BrowseFiles()
    370. 

  370. {
    371. 

  371. 	global $context, $txt, $scripturl, $options, $modSettings;
    372. 

  372. 	global $smcFunc, $sourcedir;
    373. 

  373. 

  374. 	$context['sub_template'] = 'browse';
    375. 

  375. 

  376. 	// Attachments or avatars?
    377. 

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

  378. 

  379. 	// Set the options for the list component.
    380. 

  380. 	$listOptions = array(
    381. 

  381. 		'id' => 'file_list',
    382. 

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

  383. 		'items_per_page' => $modSettings['defaultMaxMessages'],
    384. 

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

  385. 		'default_sort_col' => 'name',
    386. 

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

  387. 		'get_items' => array(
    388. 

  388. 			'function' => 'list_getFiles',
    389. 

  389. 			'params' => array(
    390. 

  390. 				$context['browse_type'],
    391. 

  391. 			),
    392. 

  392. 		),
    393. 

  393. 		'get_count' => array(
    394. 

  394. 			'function' => 'list_getNumFiles',
    395. 

  395. 			'params' => array(
    396. 

  396. 				$context['browse_type'],
    397. 

  397. 			),
    398. 

  398. 		),
    399. 

  399. 		'columns' => array(
    400. 

  400. 			'name' => array(
    401. 

  401. 				'header' => array(
    402. 

  402. 					'value' => $txt['attachment_name'],
    403. 

  403. 				),
    404. 

  404. 				'data' => array(
    405. 

  405. 					'function' => create_function('$rowData', '
    406. 

  406. 						global $modSettings, $context, $scripturl;
    407. 

  407. 

  408. 						$link = \'<a href="\';
    409. 

    410. 

  410. 						// In case of a custom avatar URL attachments have a fixed directory.
    411. 

  411. 						if ($rowData[\'attachment_type\'] == 1)
    412. 

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

    414. 

  414. 						// By default avatars are downloaded almost as attachments.
    415. 

  415. 						elseif ($context[\'browse_type\'] == \'avatars\')
    416. 

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

    418. 

  418. 						// Normal attachments are always linked to a topic ID.
    419. 

  419. 						else
    420. 

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

    422. 

  422. 						$link .= \'"\';
    423. 

    424. 

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

  425. 						if (!empty($rowData[\'width\']) && !empty($rowData[\'height\']))
    426. 

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

    428. 

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

    430. 

  430. 						// Show the dimensions.
    431. 

  431. 						if (!empty($rowData[\'width\']) && !empty($rowData[\'height\']))
    432. 

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

    434. 

  434. 						return $link;
    435. 

  435. 					'),
    436. 

  436. 				),
    437. 

  437. 				'sort' => array(
    438. 

  438. 					'default' => 'a.filename',
    439. 

  439. 					'reverse' => 'a.filename DESC',
    440. 

  440. 				),
    441. 

  441. 			),
    442. 

  442. 			'filesize' => array(
    443. 

  443. 				'header' => array(
    444. 

  444. 					'value' => $txt['attachment_file_size'],
    445. 

  445. 				),
    446. 

  446. 				'data' => array(
    447. 

  447. 					'function' => create_function('$rowData','
    448. 

  448. 						global $txt;
    449. 

  449. 

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

  451. 					'),
    452. 

  452. 				),
    453. 

  453. 				'sort' => array(
    454. 

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

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

  456. 				),
    457. 

  457. 			),
    458. 

  458. 			'member' => array(
    459. 

  459. 				'header' => array(
    460. 

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

  461. 				),
    462. 

  462. 				'data' => array(
    463. 

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

  464. 						global $scripturl;
    465. 

  465. 

  466. 						// In case of an attachment, return the poster of the attachment.
    467. 

  467. 						if (empty($rowData[\'id_member\']))
    468. 

  468. 							return htmlspecialchars($rowData[\'poster_name\']);
    469. 

    470. 

  470. 						// Otherwise it must be an avatar, return the link to the owner of it.
    471. 

  471. 						else
    472. 

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

  473. 					'),
    474. 

  474. 				),
    475. 

  475. 				'sort' => array(
    476. 

  476. 					'default' => 'mem.real_name',
    477. 

  477. 					'reverse' => 'mem.real_name DESC',
    478. 

  478. 				),
    479. 

  479. 			),
    480. 

  480. 			'date' => array(
    481. 

  481. 				'header' => array(
    482. 

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

  483. 				),
    484. 

  484. 				'data' => array(
    485. 

  485. 					'function' => create_function('$rowData', '
    486. 

  486. 						global $txt, $context, $scripturl;
    487. 

  487. 

  488. 						// The date the message containing the attachment was posted or the owner of the avatar was active.
    489. 

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

    491. 

  491. 						// Add a link to the topic in case of an attachment.
    492. 

  492. 						if ($context[\'browse_type\'] !== \'avatars\')
    493. 

  493. 							$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\']);
    494. 

    495. 

  495. 						return $date;
    496. 

  496. 						'),
    497. 

  497. 				),
    498. 

  498. 				'sort' => array(
    499. 

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

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

  501. 				),
    502. 

  502. 			),
    503. 

  503. 			'downloads' => array(
    504. 

  504. 				'header' => array(
    505. 

  505. 					'value' => $txt['downloads'],
    506. 

  506. 				),
    507. 

  507. 				'data' => array(
    508. 

  508. 					'db' => 'downloads',
    509. 

  509. 					'comma_format' => true,
    510. 

  510. 				),
    511. 

  511. 				'sort' => array(
    512. 

  512. 					'default' => 'a.downloads',
    513. 

  513. 					'reverse' => 'a.downloads DESC',
    514. 

  514. 				),
    515. 

  515. 			),
    516. 

  516. 			'check' => array(
    517. 

  517. 				'header' => array(
    518. 

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

  519. 					'class' => 'centercol',
    520. 

  520. 				),
    521. 

  521. 				'data' => array(
    522. 

  522. 					'sprintf' => array(
    523. 

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

  524. 						'params' => array(
    525. 

  525. 							'id_attach' => false,
    526. 

  526. 						),
    527. 

  527. 					),
    528. 

  528. 					'class' => 'centercol',
    529. 

  529. 				),
    530. 

  530. 			),
    531. 

  531. 		),
    532. 

  532. 		'form' => array(
    533. 

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

  534. 			'include_sort' => true,
    535. 

  535. 			'include_start' => true,
    536. 

  536. 			'hidden_fields' => array(
    537. 

  537. 				'type' => $context['browse_type'],
    538. 

  538. 			),
    539. 

  539. 		),
    540. 

  540. 		'additional_rows' => array(
    541. 

  541. 			array(
    542. 

  542. 				'position' => 'below_table_data',
    543. 

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

  544. 			),
    545. 

  545. 		),
    546. 

  546. 	);
    547. 

  547. 

  548. 	// Create the list.
    549. 

  549. 	require_once($sourcedir . '/Subs-List.php');
    550. 

  550. 	createList($listOptions);
    551. 

  551. }
    552. 

  552. 

  553. /**
    554. 

  554.  * Returns the list of attachments files (avatars or not), recorded
    555. 

  555.  * in the database, per the parameters received.
    556. 

  556.  *
    557. 

  557.  * @param int $start
    558. 

  558.  * @param int $items_per_page
    559. 

  559.  * @param string $sort
    560. 

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

  561.  */
    562. 

  562. function list_getFiles($start, $items_per_page, $sort, $browse_type)
    563. 

  563. {
    564. 

  564. 	global $smcFunc, $txt;
    565. 

  565. 

  566. 	// Choose a query depending on what we are viewing.
    567. 

  567. 	if ($browse_type === 'avatars')
    568. 

  568. 		$request = $smcFunc['db_query']('', '
    569. 

  569. 			SELECT
    570. 

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

  571. 				mem.last_login AS poster_time, 0 AS id_topic, a.id_member, a.id_attach, a.filename, a.file_hash, a.attachment_type,
    572. 

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

  573. 			FROM {db_prefix}attachments AS a
    574. 

  574. 				LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = a.id_member)
    575. 

  575. 			WHERE a.id_member != {int:guest_id}
    576. 

  576. 			ORDER BY {raw:sort}
    577. 

  577. 			LIMIT {int:start}, {int:per_page}',
    578. 

  578. 			array(
    579. 

  579. 				'guest_id' => 0,
    580. 

  580. 				'blank_text' => '',
    581. 

  581. 				'not_applicable_text' => $txt['not_applicable'],
    582. 

  582. 				'sort' => $sort,
    583. 

  583. 				'start' => $start,
    584. 

  584. 				'per_page' => $items_per_page,
    585. 

  585. 			)
    586. 

  586. 		);
    587. 

  587. 	else
    588. 

  588. 		$request = $smcFunc['db_query']('', '
    589. 

  589. 			SELECT
    590. 

  590. 				m.id_msg, IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.id_topic, m.id_member,
    591. 

  591. 				a.id_attach, a.filename, a.file_hash, a.attachment_type, a.size, a.width, a.height, a.downloads, mf.subject, t.id_board
    592. 

  592. 			FROM {db_prefix}attachments AS a
    593. 

  593. 				INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
    594. 

  594. 				INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
    595. 

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

  596. 				LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
    597. 

  597. 			WHERE a.attachment_type = {int:attachment_type}
    598. 

  598. 			ORDER BY {raw:sort}
    599. 

  599. 			LIMIT {int:start}, {int:per_page}',
    600. 

  600. 			array(
    601. 

  601. 				'attachment_type' => $browse_type == 'thumbs' ? '3' : '0',
    602. 

  602. 				'sort' => $sort,
    603. 

  603. 				'start' => $start,
    604. 

  604. 				'per_page' => $items_per_page,
    605. 

  605. 			)
    606. 

  606. 		);
    607. 

  607. 	$files = array();
    608. 

  608. 	while ($row = $smcFunc['db_fetch_assoc']($request))
    609. 

  609. 		$files[] = $row;
    610. 

  610. 	$smcFunc['db_free_result']($request);
    611. 

  611. 

  612. 	return $files;
    613. 

  613. }
    614. 

  614. 

  615. /**
    616. 

  616.  * Return the number of files of the specified type recorded in the database.
    617. 

  617.  * (the specified type being attachments or avatars).
    618. 

  618.  *
    619. 

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

  620.  */
    621. 

  621. function list_getNumFiles($browse_type)
    622. 

  622. {
    623. 

  623. 	global $smcFunc;
    624. 

  624. 

  625. 	// Depending on the type of file, different queries are used.
    626. 

  626. 	if ($browse_type === 'avatars')
    627. 

  627. 		$request = $smcFunc['db_query']('', '
    628. 

  628. 		SELECT COUNT(*)
    629. 

  629. 		FROM {db_prefix}attachments
    630. 

  630. 		WHERE id_member != {int:guest_id_member}',
    631. 

  631. 		array(
    632. 

  632. 			'guest_id_member' => 0,
    633. 

  633. 		)
    634. 

  634. 	);
    635. 

  635. 	else
    636. 

  636. 		$request = $smcFunc['db_query']('', '
    637. 

  637. 			SELECT COUNT(*) AS num_attach
    638. 

  638. 			FROM {db_prefix}attachments AS a
    639. 

  639. 				INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
    640. 

  640. 				INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
    641. 

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

  642. 			WHERE a.attachment_type = {int:attachment_type}
    643. 

  643. 				AND a.id_member = {int:guest_id_member}',
    644. 

  644. 			array(
    645. 

  645. 				'attachment_type' => $browse_type === 'thumbs' ? '3' : '0',
    646. 

  646. 				'guest_id_member' => 0,
    647. 

  647. 			)
    648. 

  648. 		);
    649. 

  649. 

  650. 	list ($num_files) = $smcFunc['db_fetch_row']($request);
    651. 

  651. 	$smcFunc['db_free_result']($request);
    652. 

  652. 

  653. 	return $num_files;
    654. 

  654. }
    655. 

  655. 

  656. /**
    657. 

  657.  * Show several file maintenance options.
    658. 

  658.  * Called by ?action=admin;area=manageattachments;sa=maintain.
    659. 

  659.  * Calculates file statistics (total file size, number of attachments,
    660. 

  660.  * number of avatars, attachment space available).
    661. 

  661.  *
    662. 

  662.  * @uses the 'maintain' sub template.
    663. 

  663.  */
    664. 

  664. function MaintainFiles()
    665. 

  665. {
    666. 

  666. 	global $context, $modSettings, $txt, $smcFunc;
    667. 

  667. 

  668. 	$context['sub_template'] = 'maintenance';
    669. 

  669. 

  670. 	if (!empty($modSettings['currentAttachmentUploadDir']))
    671. 

  671. 		$attach_dirs = unserialize($modSettings['attachmentUploadDir']);
    672. 

  672. 	else
    673. 

  673. 		$attach_dirs = array($modSettings['attachmentUploadDir']);
    674. 

  674. 

  675. 	// Get the number of attachments....
    676. 

  676. 	$request = $smcFunc['db_query']('', '
    677. 

  677. 		SELECT COUNT(*)
    678. 

  678. 		FROM {db_prefix}attachments
    679. 

  679. 		WHERE attachment_type = {int:attachment_type}
    680. 

  680. 			AND id_member = {int:guest_id_member}',
    681. 

  681. 		array(
    682. 

  682. 			'attachment_type' => 0,
    683. 

  683. 			'guest_id_member' => 0,
    684. 

  684. 		)
    685. 

  685. 	);
    686. 

  686. 	list ($context['num_attachments']) = $smcFunc['db_fetch_row']($request);
    687. 

  687. 	$smcFunc['db_free_result']($request);
    688. 

  688. 	$context['num_attachments'] = comma_format($context['num_attachments'], 0);
    689. 

  689. 

  690. 	// Also get the avatar amount....
    691. 

  691. 	$request = $smcFunc['db_query']('', '
    692. 

  692. 		SELECT COUNT(*)
    693. 

  693. 		FROM {db_prefix}attachments
    694. 

  694. 		WHERE id_member != {int:guest_id_member}',
    695. 

  695. 		array(
    696. 

  696. 			'guest_id_member' => 0,
    697. 

  697. 		)
    698. 

  698. 	);
    699. 

  699. 	list ($context['num_avatars']) = $smcFunc['db_fetch_row']($request);
    700. 

  700. 	$smcFunc['db_free_result']($request);
    701. 

  701. 	$context['num_avatars'] = comma_format($context['num_avatars'], 0);
    702. 

  702. 

  703. 	// Check the size of all the directories.
    704. 

  704. 	$request = $smcFunc['db_query']('', '
    705. 

  705. 		SELECT SUM(size)
    706. 

  706. 		FROM {db_prefix}attachments
    707. 

  707. 		WHERE attachment_type != {int:type}',
    708. 

  708. 		array(
    709. 

  709. 			'type' => 1,
    710. 

  710. 		)
    711. 

  711. 	);
    712. 

  712. 	list ($attachmentDirSize) = $smcFunc['db_fetch_row']($request);
    713. 

  713. 	$smcFunc['db_free_result']($request);
    714. 

  714. 

  715. 	// Divide it into kilobytes.
    716. 

  716. 	$attachmentDirSize /= 1024;
    717. 

  717. 	$context['attachment_total_size'] = comma_format($attachmentDirSize, 2);
    718. 

  718. 

  719. 	$request = $smcFunc['db_query']('', '
    720. 

  720. 		SELECT COUNT(*), SUM(size)
    721. 

  721. 		FROM {db_prefix}attachments
    722. 

  722. 		WHERE id_folder = {int:folder_id}
    723. 

  723. 			AND attachment_type != {int:type}',
    724. 

  724. 		array(
    725. 

  725. 			'folder_id' => $modSettings['currentAttachmentUploadDir'],
    726. 

  726. 			'type' => 1,
    727. 

  727. 		)
    728. 

  728. 	);
    729. 

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

  730. 	$smcFunc['db_free_result']($request);
    731. 

  731. 	$current_dir_size /= 1024;
    732. 

  732. 

  733. 	// If they specified a limit only....
    734. 

  734. 	if (!empty($modSettings['attachmentDirSizeLimit']))
    735. 

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

  736. 	$context['attachment_current_size'] = comma_format($current_dir_size, 2);
    737. 

  737. 

  738. 	if (!empty($modSettings['attachmentDirFileLimit']))
    739. 

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

  740. 	$context['attachment_current_files'] = comma_format($current_dir_files, 0);
    741. 

  741. 	
    742. 

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

  743. 	$context['attach_dirs'] = $attach_dirs;
    744. 

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

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

  746. 	if (!empty($_SESSION['results']))
    747. 

  747. 	{
    748. 

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

  749. 		unset($_SESSION['results']);
    750. 

  750. 	}
    751. 

  751. }
    752. 

  752. 

  753. /**
    754. 

  754.  * Move avatars from their current location, to the custom_avatar_dir folder.
    755. 

  755.  * Called from the maintenance screen by ?action=admin;area=manageattachments;sa=moveAvatars.
    756. 

  756.  */
    757. 

  757. function MoveAvatars()
    758. 

  758. {
    759. 

  759. 	global $modSettings, $smcFunc;
    760. 

  760. 

  761. 	// First make sure the custom avatar dir is writable.
    762. 

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

  763. 	{
    764. 

  764. 		// Try to fix it.
    765. 

  765. 		@chmod($modSettings['custom_avatar_dir'], 0777);
    766. 

  766. 

  767. 		// Guess that didn't work?
    768. 

  768. 		if (!is_writable($modSettings['custom_avatar_dir']))
    769. 

  769. 			fatal_lang_error('attachments_no_write', 'critical');
    770. 

  770. 	}
    771. 

  771. 

  772. 	$request = $smcFunc['db_query']('', '
    773. 

  773. 		SELECT id_attach, id_folder, id_member, filename, file_hash
    774. 

  774. 		FROM {db_prefix}attachments
    775. 

  775. 		WHERE attachment_type = {int:attachment_type}
    776. 

  776. 			AND id_member > {int:guest_id_member}',
    777. 

  777. 		array(
    778. 

  778. 			'attachment_type' => 0,
    779. 

  779. 			'guest_id_member' => 0,
    780. 

  780. 		)
    781. 

  781. 	);
    782. 

  782. 	$updatedAvatars = array();
    783. 

  783. 	while ($row = $smcFunc['db_fetch_assoc']($request))
    784. 

  784. 	{
    785. 

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

  786. 

  787. 		if (rename($filename, $modSettings['custom_avatar_dir'] . '/' . $row['filename']))
    788. 

  788. 			$updatedAvatars[] = $row['id_attach'];
    789. 

  789. 	}
    790. 

  790. 	$smcFunc['db_free_result']($request);
    791. 

  791. 

  792. 	if (!empty($updatedAvatars))
    793. 

  793. 		$smcFunc['db_query']('', '
    794. 

  794. 			UPDATE {db_prefix}attachments
    795. 

  795. 			SET attachment_type = {int:attachment_type}
    796. 

  796. 			WHERE id_attach IN ({array_int:updated_avatars})',
    797. 

  797. 			array(
    798. 

  798. 				'updated_avatars' => $updatedAvatars,
    799. 

  799. 				'attachment_type' => 1,
    800. 

  800. 			)
    801. 

  801. 		);
    802. 

  802. 

  803. 	redirectexit('action=admin;area=manageattachments;sa=maintenance');
    804. 

  804. }
    805. 

  805. 

  806. /**
    807. 

  807.  * Remove attachments older than a given age.
    808. 

  808.  * Called from the maintenance screen by
    809. 

  809.  *   ?action=admin;area=manageattachments;sa=byAge.
    810. 

  810.  * It optionally adds a certain text to the messages the attachments
    811. 

  811.  *  were removed from.
    812. 

  812.  *  @todo refactor this silly superglobals use...
    813. 

  813.  */
    814. 

  814. function RemoveAttachmentByAge()
    815. 

  815. {
    816. 

  816. 	global $modSettings, $smcFunc;
    817. 

  817. 

  818. 	checkSession('post', 'admin');
    819. 

  819. 

  820. 	// @todo Ignore messages in topics that are stickied?
    821. 

  821. 

  822. 	// Deleting an attachment?
    823. 

  823. 	if ($_REQUEST['type'] != 'avatars')
    824. 

  824. 	{
    825. 

  825. 		// Get rid of all the old attachments.
    826. 

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

  827. 

  828. 		// Update the messages to reflect the change.
    829. 

  829. 		if (!empty($messages) && !empty($_POST['notice']))
    830. 

  830. 			$smcFunc['db_query']('', '
    831. 

  831. 				UPDATE {db_prefix}messages
    832. 

  832. 				SET body = CONCAT(body, {string:notice})
    833. 

  833. 				WHERE id_msg IN ({array_int:messages})',
    834. 

  834. 				array(
    835. 

  835. 					'messages' => $messages,
    836. 

  836. 					'notice' => '<br /><br />' . $_POST['notice'],
    837. 

  837. 				)
    838. 

  838. 			);
    839. 

  839. 	}
    840. 

  840. 	else
    841. 

  841. 	{
    842. 

  842. 		// Remove all the old avatars.
    843. 

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

  844. 	}
    845. 

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

  846. }
    847. 

  847. 

  848. /**
    849. 

  849.  * Remove attachments larger than a given size.
    850. 

  850.  * Called from the maintenance screen by
    851. 

  851.  *  ?action=admin;area=manageattachments;sa=bySize.
    852. 

  852.  * Optionally adds a certain text to the messages the attachments were
    853. 

  853.  * 	removed from.
    854. 

  854.  */
    855. 

  855. function RemoveAttachmentBySize()
    856. 

  856. {
    857. 

  857. 	global $modSettings, $smcFunc;
    858. 

  858. 

  859. 	checkSession('post', 'admin');
    860. 

  860. 

  861. 	// Find humungous attachments.
    862. 

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

  863. 

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

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

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

  867. 			UPDATE {db_prefix}messages
    868. 

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

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

  870. 			array(
    871. 

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

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

  873. 			)
    874. 

  874. 		);
    875. 

  875. 

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

  877. }
    878. 

  878. 

  879. /**
    880. 

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

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

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

  883.  */
    884. 

  884. function RemoveAttachment()
    885. 

  885. {
    886. 

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

  887. 

  888. 	checkSession('post');
    889. 

  889. 

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

  891. 	{
    892. 

  892. 		$attachments = array();
    893. 

  893. 		// There must be a quicker way to pass this safety test??
    894. 

  894. 		foreach ($_POST['remove'] as $removeID => $dummy)
    895. 

  895. 			$attachments[] = (int) $removeID;
    896. 

  896. 

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

  898. 			removeAttachments(array('id_attach' => $attachments));
    899. 

  899. 		else if (!empty($attachments))
    900. 

  900. 		{
    901. 

  901. 			$messages = removeAttachments(array('id_attach' => $attachments), 'messages', true);
    902. 

  902. 

  903. 			// And change the message to reflect this.
    904. 

  904. 			if (!empty($messages))
    905. 

  905. 			{
    906. 

  906. 				loadLanguage('index', $language, true);
    907. 

  907. 				$smcFunc['db_query']('', '
    908. 

  908. 					UPDATE {db_prefix}messages
    909. 

  909. 					SET body = CONCAT(body, {string:deleted_message})
    910. 

  910. 					WHERE id_msg IN ({array_int:messages_affected})',
    911. 

  911. 					array(
    912. 

  912. 						'messages_affected' => $messages,
    913. 

  913. 						'deleted_message' => '<br /><br />' . $txt['attachment_delete_admin'],
    914. 

  914. 					)
    915. 

  915. 				);
    916. 

  916. 				loadLanguage('index', $user_info['language'], true);
    917. 

  917. 			}
    918. 

  918. 		}
    919. 

  919. 	}
    920. 

  920. 

  921. 	$_GET['sort'] = isset($_GET['sort']) ? $_GET['sort'] : 'date';
    922. 

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

  923. }
    924. 

  924. 

  925. /**
    926. 

  926.  * Removes all attachments in a single click
    927. 

  927.  * Called from the maintenance screen by
    928. 

  928.  *  ?action=admin;area=manageattachments;sa=removeall.
    929. 

  929.  */
    930. 

  930. function RemoveAllAttachments()
    931. 

  931. {
    932. 

  932. 	global $txt, $smcFunc;
    933. 

  933. 

  934. 	checkSession('get', 'admin');
    935. 

  935. 

  936. 	$messages = removeAttachments(array('attachment_type' => 0), '', true);
    937. 

  937. 

  938. 	if (!isset($_POST['notice']))
    939. 

  939. 		$_POST['notice'] = $txt['attachment_delete_admin'];
    940. 

  940. 

  941. 	// Add the notice on the end of the changed messages.
    942. 

  942. 	if (!empty($messages))
    943. 

  943. 		$smcFunc['db_query']('', '
    944. 

  944. 			UPDATE {db_prefix}messages
    945. 

  945. 			SET body = CONCAT(body, {string:deleted_message})
    946. 

  946. 			WHERE id_msg IN ({array_int:messages})',
    947. 

  947. 			array(
    948. 

  948. 				'messages' => $messages,
    949. 

  949. 				'deleted_message' => '<br /><br />' . $_POST['notice'],
    950. 

  950. 			)
    951. 

  951. 		);
    952. 

  952. 

  953. 	redirectexit('action=admin;area=manageattachments;sa=maintenance');
    954. 

  954. }
    955. 

  955. 

  956. /**
    957. 

  957.  * Removes attachments or avatars based on a given query condition.
    958. 

  958.  * Called by several remove avatar/attachment functions in this file.
    959. 

  959.  * It removes attachments based that match the $condition.
    960. 

  960.  * It allows query_types 'messages' and 'members', whichever is need by the
    961. 

  961.  * $condition parameter.
    962. 

  962.  * It does no permissions check.
    963. 

  963.  * @internal
    964. 

  964.  *
    965. 

  965.  * @param array $condition
    966. 

  966.  * @param string $query_type
    967. 

  967.  * @param bool $return_affected_messages = false
    968. 

  968.  * @param bool $autoThumbRemoval = true
    969. 

  969.  */
    970. 

  970. function removeAttachments($condition, $query_type = '', $return_affected_messages = false, $autoThumbRemoval = true)
    971. 

  971. {
    972. 

  972. 	global $modSettings, $smcFunc;
    973. 

  973. 

  974. 	// @todo This might need more work!
    975. 

  975. 	$new_condition = array();
    976. 

  976. 	$query_parameter = array(
    977. 

  977. 		'thumb_attachment_type' => 3,
    978. 

  978. 	);
    979. 

  979. 	$do_logging = array();
    980. 

  980. 

  981. 	if (is_array($condition))
    982. 

  982. 	{
    983. 

  983. 		foreach ($condition as $real_type => $restriction)
    984. 

  984. 		{
    985. 

  985. 			// Doing a NOT?
    986. 

  986. 			$is_not = substr($real_type, 0, 4) == 'not_';
    987. 

  987. 			$type = $is_not ? substr($real_type, 4) : $real_type;
    988. 

  988. 

  989. 			if (in_array($type, array('id_member', 'id_attach', 'id_msg')))
    990. 

  990. 				$new_condition[] = 'a.' . $type . ($is_not ? ' NOT' : '') . ' IN (' . (is_array($restriction) ? '{array_int:' . $real_type . '}' : '{int:' . $real_type . '}') . ')';
    991. 

  991. 			elseif ($type == 'attachment_type')
    992. 

  992. 				$new_condition[] = 'a.attachment_type = {int:' . $real_type . '}';
    993. 

  993. 			elseif ($type == 'poster_time')
    994. 

  994. 				$new_condition[] = 'm.poster_time < {int:' . $real_type . '}';
    995. 

  995. 			elseif ($type == 'last_login')
    996. 

  996. 				$new_condition[] = 'mem.last_login < {int:' . $real_type . '}';
    997. 

  997. 			elseif ($type == 'size')
    998. 

  998. 				$new_condition[] = 'a.size > {int:' . $real_type . '}';
    999. 

  999. 			elseif ($type == 'id_topic')
    1000. 

  1000. 				$new_condition[] = 'm.id_topic IN (' . (is_array($restriction) ? '{array_int:' . $real_type . '}' : '{int:' . $real_type . '}') . ')';
    1001. 

  1001. 

  1002. 			// Add the parameter!
    1003. 

  1003. 			$query_parameter[$real_type] = $restriction;
    1004. 

  1004. 

  1005. 			if ($type == 'do_logging')
    1006. 

  1006. 				$do_logging = $condition['id_attach'];
    1007. 

  1007. 		}
    1008. 

  1008. 		$condition = implode(' AND ', $new_condition);
    1009. 

  1009. 	}
    1010. 

  1010. 

  1011. 	// Delete it only if it exists...
    1012. 

  1012. 	$msgs = array();
    1013. 

  1013. 	$attach = array();
    1014. 

  1014. 	$parents = array();
    1015. 

  1015. 

  1016. 	// Get all the attachment names and id_msg's.
    1017. 

  1017. 	$request = $smcFunc['db_query']('', '
    1018. 

  1018. 		SELECT
    1019. 

  1019. 			a.id_folder, a.filename, a.file_hash, a.attachment_type, a.id_attach, a.id_member' . ($query_type == 'messages' ? ', m.id_msg' : ', a.id_msg') . ',
    1020. 

  1020. 			thumb.id_folder AS thumb_folder, IFNULL(thumb.id_attach, 0) AS id_thumb, thumb.filename AS thumb_filename, thumb.file_hash AS thumb_file_hash, thumb_parent.id_attach AS id_parent
    1021. 

  1021. 		FROM {db_prefix}attachments AS a' .($query_type == 'members' ? '
    1022. 

  1022. 			INNER JOIN {db_prefix}members AS mem ON (mem.id_member = a.id_member)' : ($query_type == 'messages' ? '
    1023. 

  1023. 			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)' : '')) . '
    1024. 

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

  1025. 			LEFT JOIN {db_prefix}attachments AS thumb_parent ON (thumb.attachment_type = {int:thumb_attachment_type} AND thumb_parent.id_thumb = a.id_attach)
    1026. 

  1026. 		WHERE ' . $condition,
    1027. 

  1027. 		$query_parameter
    1028. 

  1028. 	);
    1029. 

  1029. 	while ($row = $smcFunc['db_fetch_assoc']($request))
    1030. 

  1030. 	{
    1031. 

  1031. 		// Figure out the "encrypted" filename and unlink it ;).
    1032. 

  1032. 		if ($row['attachment_type'] == 1)
    1033. 

  1033. 		{
    1034. 

  1034. 			// if attachment_type = 1, it's... an avatar in a custom avatar directory.
    1035. 

  1035. 			// wasn't it obvious? :P
    1036. 

  1036. 			// @todo look again at this.
    1037. 

  1037. 			@unlink($modSettings['custom_avatar_dir'] . '/' . $row['filename']);
    1038. 

  1038. 		}
    1039. 

  1039. 		else
    1040. 

  1040. 		{
    1041. 

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

  1042. 			@unlink($filename);
    1043. 

  1043. 

  1044. 			// If this was a thumb, the parent attachment should know about it.
    1045. 

  1045. 			if (!empty($row['id_parent']))
    1046. 

  1046. 				$parents[] = $row['id_parent'];
    1047. 

  1047. 

  1048. 			// If this attachments has a thumb, remove it as well.
    1049. 

  1049. 			if (!empty($row['id_thumb']) && $autoThumbRemoval)
    1050. 

  1050. 			{
    1051. 

  1051. 				$thumb_filename = getAttachmentFilename($row['thumb_filename'], $row['id_thumb'], $row['thumb_folder'], false, $row['thumb_file_hash']);
    1052. 

  1052. 				@unlink($thumb_filename);
    1053. 

  1053. 				$attach[] = $row['id_thumb'];
    1054. 

  1054. 			}
    1055. 

  1055. 		}
    1056. 

  1056. 

  1057. 		// Make a list.
    1058. 

  1058. 		if ($return_affected_messages && empty($row['attachment_type']))
    1059. 

  1059. 			$msgs[] = $row['id_msg'];
    1060. 

  1060. 		$attach[] = $row['id_attach'];
    1061. 

  1061. 	}
    1062. 

  1062. 	$smcFunc['db_free_result']($request);
    1063. 

  1063. 

  1064. 	// Removed attachments don't have to be updated anymore.
    1065. 

  1065. 	$parents = array_diff($parents, $attach);
    1066. 

  1066. 	if (!empty($parents))
    1067. 

  1067. 		$smcFunc['db_query']('', '
    1068. 

  1068. 			UPDATE {db_prefix}attachments
    1069. 

  1069. 			SET id_thumb = {int:no_thumb}
    1070. 

  1070. 			WHERE id_attach IN ({array_int:parent_attachments})',
    1071. 

  1071. 			array(
    1072. 

  1072. 				'parent_attachments' => $parents,
    1073. 

  1073. 				'no_thumb' => 0,
    1074. 

  1074. 			)
    1075. 

  1075. 		);
    1076. 

  1076. 

  1077. 	if (!empty($do_logging))
    1078. 

  1078. 	{
    1079. 

  1079. 		// In order to log the attachments, we really need their message and filename
    1080. 

  1080. 		$request = $smcFunc['db_query']('', '
    1081. 

  1081. 			SELECT m.id_msg, a.filename
    1082. 

  1082. 			FROM {db_prefix}attachments AS a
    1083. 

  1083. 				INNER JOIN {db_prefix}messages AS m ON (a.id_msg = m.id_msg)
    1084. 

  1084. 			WHERE a.id_attach IN ({array_int:attachments})
    1085. 

  1085. 				AND a.attachment_type = {int:attachment_type}',
    1086. 

  1086. 			array(
    1087. 

  1087. 				'attachments' => $do_logging,
    1088. 

  1088. 				'attachment_type' => 0,
    1089. 

  1089. 			)
    1090. 

  1090. 		);
    1091. 

  1091. 

  1092. 		while ($row = $smcFunc['db_fetch_assoc']($request))
    1093. 

  1093. 			logAction(
    1094. 

  1094. 				'remove_attach',
    1095. 

  1095. 				array(
    1096. 

  1096. 					'message' => $row['id_msg'],
    1097. 

  1097. 					'filename' => preg_replace('~&amp;#(\\d{1,7}|x[0-9a-fA-F]{1,6});~', '&#\\1;', $smcFunc['htmlspecialchars']($row['filename'])),
    1098. 

  1098. 				)
    1099. 

  1099. 			);
    1100. 

  1100. 		$smcFunc['db_free_result']($request);
    1101. 

  1101. 	}
    1102. 

  1102. 

  1103. 	if (!empty($attach))
    1104. 

  1104. 		$smcFunc['db_query']('', '
    1105. 

  1105. 			DELETE FROM {db_prefix}attachments
    1106. 

  1106. 			WHERE id_attach IN ({array_int:attachment_list})',
    1107. 

  1107. 			array(
    1108. 

  1108. 				'attachment_list' => $attach,
    1109. 

  1109. 			)
    1110. 

  1110. 		);
    1111. 

  1111. 

  1112. 	call_integration_hook('integrate_remove_attachments', array($attach));
    1113. 

  1113. 

  1114. 	if ($return_affected_messages)
    1115. 

  1115. 		return array_unique($msgs);
    1116. 

  1116. }
    1117. 

  1117. 

  1118. /**
    1119. 

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

  1120.  */
    1121. 

  1121. function RepairAttachments()
    1122. 

  1122. {
    1123. 

  1123. 	global $modSettings, $context, $txt, $smcFunc;
    1124. 

  1124. 

  1125. 	checkSession('get');
    1126. 

  1126. 

  1127. 	// If we choose cancel, redirect right back.
    1128. 

  1128. 	if (isset($_POST['cancel']))
    1129. 

  1129. 		redirectexit('action=admin;area=manageattachments;sa=maintenance');
    1130. 

  1130. 

  1131. 	// Try give us a while to sort this out...
    1132. 

  1132. 	@set_time_limit(600);
    1133. 

  1133. 

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

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

  1136. 

  1137. 	// Don't recall the session just in case.
    1138. 

  1138. 	if ($_GET['step'] == 0 && $_GET['substep'] == 0)
    1139. 

  1139. 	{
    1140. 

  1140. 		unset($_SESSION['attachments_to_fix'], $_SESSION['attachments_to_fix2']);
    1141. 

  1141. 

  1142. 		// If we're actually fixing stuff - work out what.
    1143. 

  1143. 		if (isset($_GET['fixErrors']))
    1144. 

  1144. 		{
    1145. 

  1145. 			// Nothing?
    1146. 

  1146. 			if (empty($_POST['to_fix']))
    1147. 

  1147. 				redirectexit('action=admin;area=manageattachments;sa=maintenance');
    1148. 

  1148. 

  1149. 			$_SESSION['attachments_to_fix'] = array();
    1150. 

  1150. 			// @todo No need to do this I think.
    1151. 

  1151. 			foreach ($_POST['to_fix'] as $key => $value)
    1152. 

  1152. 				$_SESSION['attachments_to_fix'][] = $value;
    1153. 

  1153. 		}
    1154. 

  1154. 	}
    1155. 

  1155. 

  1156. 	// All the valid problems are here:
    1157. 

  1157. 	$context['repair_errors'] = array(
    1158. 

  1158. 		'missing_thumbnail_parent' => 0,
    1159. 

  1159. 		'parent_missing_thumbnail' => 0,
    1160. 

  1160. 		'file_missing_on_disk' => 0,
    1161. 

  1161. 		'file_wrong_size' => 0,
    1162. 

  1162. 		'file_size_of_zero' => 0,
    1163. 

  1163. 		'attachment_no_msg' => 0,
    1164. 

  1164. 		'avatar_no_member' => 0,
    1165. 

  1165. 		'wrong_folder' => 0,
    1166. 

  1166. 		'files_without_attachment' => 0,
    1167. 

  1167. 	);
    1168. 

  1168. 

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

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

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

  1172. 

  1173. 	// Get stranded thumbnails.
    1174. 

  1174. 	if ($_GET['step'] <= 0)
    1175. 

  1175. 	{
    1176. 

  1176. 		$result = $smcFunc['db_query']('', '
    1177. 

  1177. 			SELECT MAX(id_attach)
    1178. 

  1178. 			FROM {db_prefix}attachments
    1179. 

  1179. 			WHERE attachment_type = {int:thumbnail}',
    1180. 

  1180. 			array(
    1181. 

  1181. 				'thumbnail' => 3,
    1182. 

  1182. 			)
    1183. 

  1183. 		);
    1184. 

  1184. 		list ($thumbnails) = $smcFunc['db_fetch_row']($result);
    1185. 

  1185. 		$smcFunc['db_free_result']($result);
    1186. 

  1186. 

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

  1188. 		{
    1189. 

  1189. 			$to_remove = array();
    1190. 

  1190. 

  1191. 			$result = $smcFunc['db_query']('', '
    1192. 

  1192. 				SELECT thumb.id_attach, thumb.id_folder, thumb.filename, thumb.file_hash
    1193. 

  1193. 				FROM {db_prefix}attachments AS thumb
    1194. 

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

  1195. 				WHERE thumb.id_attach BETWEEN {int:substep} AND {int:substep} + 499
    1196. 

  1196. 					AND thumb.attachment_type = {int:thumbnail}
    1197. 

  1197. 					AND tparent.id_attach IS NULL',
    1198. 

  1198. 				array(
    1199. 

  1199. 					'thumbnail' => 3,
    1200. 

  1200. 					'substep' => $_GET['substep'],
    1201. 

  1201. 				)
    1202. 

  1202. 			);
    1203. 

  1203. 			while ($row = $smcFunc['db_fetch_assoc']($result))
    1204. 

  1204. 			{
    1205. 

  1205. 				// Only do anything once... just in case
    1206. 

  1206. 				if (!isset($to_remove[$row['id_attach']]))
    1207. 

  1207. 				{
    1208. 

  1208. 					$to_remove[$row['id_attach']] = $row['id_attach'];
    1209. 

  1209. 					$context['repair_errors']['missing_thumbnail_parent']++;
    1210. 

  1210. 

  1211. 					// If we are repairing remove the file from disk now.
    1212. 

  1212. 					if ($fix_errors && in_array('missing_thumbnail_parent', $to_fix))
    1213. 

  1213. 					{
    1214. 

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

  1215. 						@unlink($filename);
    1216. 

  1216. 					}
    1217. 

  1217. 				}
    1218. 

  1218. 			}
    1219. 

  1219. 			if ($smcFunc['db_num_rows']($result) != 0)
    1220. 

  1220. 				$to_fix[] = 'missing_thumbnail_parent';
    1221. 

  1221. 			$smcFunc['db_free_result']($result);
    1222. 

  1222. 

  1223. 			// Do we need to delete what we have?
    1224. 

  1224. 			if ($fix_errors && !empty($to_remove) && in_array('missing_thumbnail_parent', $to_fix))
    1225. 

  1225. 				$smcFunc['db_query']('', '
    1226. 

  1226. 					DELETE FROM {db_prefix}attachments
    1227. 

  1227. 					WHERE id_attach IN ({array_int:to_remove})
    1228. 

  1228. 						AND attachment_type = {int:attachment_type}',
    1229. 

  1229. 					array(
    1230. 

  1230. 						'to_remove' => $to_remove,
    1231. 

  1231. 						'attachment_type' => 3,
    1232. 

  1232. 					)
    1233. 

  1233. 				);
    1234. 

  1234. 

  1235. 			pauseAttachmentMaintenance($to_fix, $thumbnails);
    1236. 

  1236. 		}
    1237. 

  1237. 

  1238. 		$_GET['step'] = 1;
    1239. 

  1239. 		$_GET['substep'] = 0;
    1240. 

  1240. 		pauseAttachmentMaintenance($to_fix);
    1241. 

  1241. 	}
    1242. 

  1242. 

  1243. 	// Find parents which think they have thumbnails, but actually, don't.
    1244. 

  1244. 	if ($_GET['step'] <= 1)
    1245. 

  1245. 	{
    1246. 

  1246. 		$result = $smcFunc['db_query']('', '
    1247. 

  1247. 			SELECT MAX(id_attach)
    1248. 

  1248. 			FROM {db_prefix}attachments
    1249. 

  1249. 			WHERE id_thumb != {int:no_thumb}',
    1250. 

  1250. 			array(
    1251. 

  1251. 				'no_thumb' => 0,
    1252. 

  1252. 			)
    1253. 

  1253. 		);
    1254. 

  1254. 		list ($thumbnails) = $smcFunc['db_fetch_row']($result);
    1255. 

  1255. 		$smcFunc['db_free_result']($result);
    1256. 

  1256. 

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

  1258. 		{
    1259. 

  1259. 			$to_update = array();
    1260. 

  1260. 

  1261. 			$result = $smcFunc['db_query']('', '
    1262. 

  1262. 				SELECT a.id_attach
    1263. 

  1263. 				FROM {db_prefix}attachments AS a
    1264. 

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

  1265. 				WHERE a.id_attach BETWEEN {int:substep} AND {int:substep} + 499
    1266. 

  1266. 					AND a.id_thumb != {int:no_thumb}
    1267. 

  1267. 					AND thumb.id_attach IS NULL',
    1268. 

  1268. 				array(
    1269. 

  1269. 					'no_thumb' => 0,
    1270. 

  1270. 					'substep' => $_GET['substep'],
    1271. 

  1271. 				)
    1272. 

  1272. 			);
    1273. 

  1273. 			while ($row = $smcFunc['db_fetch_assoc']($result))
    1274. 

  1274. 			{
    1275. 

  1275. 				$to_update[] = $row['id_attach'];
    1276. 

  1276. 				$context['repair_errors']['parent_missing_thumbnail']++;
    1277. 

  1277. 			}
    1278. 

  1278. 			if ($smcFunc['db_num_rows']($result) != 0)
    1279. 

  1279. 				$to_fix[] = 'parent_missing_thumbnail';
    1280. 

  1280. 			$smcFunc['db_free_result']($result);
    1281. 

  1281. 

  1282. 			// Do we need to delete what we have?
    1283. 

  1283. 			if ($fix_errors && !empty($to_update) && in_array('parent_missing_thumbnail', $to_fix))
    1284. 

  1284. 				$smcFunc['db_query']('', '
    1285. 

  1285. 					UPDATE {db_prefix}attachments
    1286. 

  1286. 					SET id_thumb = {int:no_thumb}
    1287. 

  1287. 					WHERE id_attach IN ({array_int:to_update})',
    1288. 

  1288. 					array(
    1289. 

  1289. 						'to_update' => $to_update,
    1290. 

  1290. 						'no_thumb' => 0,
    1291. 

  1291. 					)
    1292. 

  1292. 				);
    1293. 

  1293. 

  1294. 			pauseAttachmentMaintenance($to_fix, $thumbnails);
    1295. 

  1295. 		}
    1296. 

  1296. 

  1297. 		$_GET['step'] = 2;
    1298. 

  1298. 		$_GET['substep'] = 0;
    1299. 

  1299. 		pauseAttachmentMaintenance($to_fix);
    1300. 

  1300. 	}
    1301. 

  1301. 

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

  1303. 	if ($_GET['step'] <= 2)
    1304. 

  1304. 	{
    1305. 

  1305. 		$result = $smcFunc['db_query']('', '
    1306. 

  1306. 			SELECT MAX(id_attach)
    1307. 

  1307. 			FROM {db_prefix}attachments',
    1308. 

  1308. 			array(
    1309. 

  1309. 			)
    1310. 

  1310. 		);
    1311. 

  1311. 		list ($thumbnails) = $smcFunc['db_fetch_row']($result);
    1312. 

  1312. 		$smcFunc['db_free_result']($result);
    1313. 

  1313. 

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

  1315. 		{
    1316. 

  1316. 			$to_remove = array();
    1317. 

  1317. 			$errors_found = array();
    1318. 

  1318. 

  1319. 			$result = $smcFunc['db_query']('', '
    1320. 

  1320. 				SELECT id_attach, id_folder, filename, file_hash, size, attachment_type
    1321. 

  1321. 				FROM {db_prefix}attachments
    1322. 

  1322. 				WHERE id_attach BETWEEN {int:substep} AND {int:substep} + 249',
    1323. 

  1323. 				array(
    1324. 

  1324. 					'substep' => $_GET['substep'],
    1325. 

  1325. 				)
    1326. 

  1326. 			);
    1327. 

  1327. 			while ($row = $smcFunc['db_fetch_assoc']($result))
    1328. 

  1328. 			{
    1329. 

  1329. 				// Get the filename.
    1330. 

  1330. 				if ($row['attachment_type'] == 1)
    1331. 

  1331. 					$filename = $modSettings['custom_avatar_dir'] . '/' . $row['filename'];
    1332. 

  1332. 				else
    1333. 

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

  1334. 

  1335. 				// File doesn't exist?
    1336. 

  1336. 				if (!file_exists($filename))
    1337. 

  1337. 				{
    1338. 

  1338. 					// If we're lucky it might just be in a different folder.
    1339. 

  1339. 					if (!empty($modSettings['currentAttachmentUploadDir']))
    1340. 

  1340. 					{
    1341. 

  1341. 						// Get the attachment na…
    1342.

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