ElkArte Community Modern, Free, Powerful
Community building forum software

<step>
		<title>Importing attachments</title>
		<detect>{$from_prefix}attachments</detect>
		<destination>{$to_prefix}attachments</destination>
		<presql>TRUNCATE {$to_prefix}attachments;</presql>
		<preparsecode>
			$request = $db->query("
				SELECT value
				FROM {$from_prefix}settings
				WHERE variable='attachmentUploadDir';");
			list ($smf_attachments_dir) = $db->fetch_row($request);

			$smf_attachments_dir =  rtrim($smf_attachments_dir, '/');

			if (empty($row['file_hash']))
			{
				$row['file_hash'] = createAttachmentFileHash($row['filename']);
				$clean_name = $row['filename'];
				$se = array("ä", "ö", "ü", "Ä", "Ö", "Ü", "ß");
				$repl = array("a", "o", "u", "A", "O", "U", "ss");
				$clean_name = str_replace($se, $repl, $clean_name);
				$clean_name = strtr($clean_name, 'ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝàáâãäåçèéêëìíîïñòóôõöøùúûüýÿ', 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy');
				$clean_name = strtr($clean_name, array('Þ' => 'TH', 'þ' => 'th', 'Ð' => 'DH', 'ð' => 'dh', 'ß' => 'ss', 'Œ' => 'OE', 'œ' => 'oe', 'Æ' => 'AE', 'æ' => 'ae', 'µ' => 'u'));
				$clean_name = preg_replace(array('/\s/', '/[^\w_\.\-]/'), array('_', ''), $clean_name);
				$enc_name = $row['id_attach'] . '_' . strtr($clean_name, '.', '_') . md5($clean_name);
				$clean_name = preg_replace('~\.[\.]+~', '.', $clean_name);
				$clean_name = str_replace('.', '_', $clean_name);

				copy_file($smf_attachments_dir . '/' . $enc_name, $attachmentUploadDir . '/'. $row['id_attach'] . '_' . $row['file_hash'] . '.elk');
				copy_file($smf_attachments_dir . '/' . $clean_name, $attachmentUploadDir . '/' . $row['id_attach'] . '_' . $row['file_hash'] . '.elk');
			}
			else
				copy_file($smf_attachments_dir . '/' . $row['id_attach'] . '_' . $row['file_hash'], $attachmentUploadDir . '/'. $row['id_attach'] . '_' . $row['file_hash'] . '.elk');
		</preparsecode>
		<query>
			SELECT
				id_attach, id_thumb, id_msg, id_member, attachment_type, filename, file_hash, size, downloads,
				width, height, fileext, mime_type, id_folder
			FROM {$from_prefix}attachments
			WHERE id_msg != 0;
		</query>
	</step>
	<step>
		<title>Importing avatars</title>
		<detect>{$from_prefix}attachments</detect>
		<destination>{$to_prefix}attachments</destination>
		<options>
			<replace>true</replace>
		</options>
		<preparsecode>		
			// Try custom_avatar_dir first
			$request = $db->query("
				SELECT value
				FROM {$from_prefix}settings
				WHERE variable = 'custom_avatar_dir';");
			list ($smf_attachments_dir) = $db->fetch_row($request);

			if (empty($smf_attachments_dir))
			{
				$request = $db->query("
					SELECT value
					FROM {$from_prefix}settings
					WHERE variable='attachmentUploadDir';");
				list ($smf_attachments_dir) = $db->fetch_row($request);
			}

			if ($avatarUploadDir == $attachmentUploadDir)
				$row['attachment_type'] = 0;

			if (empty($row['file_hash']))
			{
				$row['file_hash'] = createAttachmentFileHash($row['filename']);
				$clean_name = $row['filename'];
				$se = array("ä", "ö", "ü", "Ä", "Ö", "Ü", "ß");
				$repl = array("a", "o", "u", "A", "O", "U", "ss");
				$clean_name = str_replace($se, $repl, $clean_name);
				$clean_name = strtr($clean_name, 'ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝàáâãäåçèéêëìíîïñòóôõöøùúûüýÿ', 'SZszYAAAAAACEEEEIIIINOOOOOOUUUUYaaaaaaceeeeiiiinoooooouuuuyy');
				$clean_name = strtr($clean_name, array('Þ' => 'TH', 'þ' => 'th', 'Ð' => 'DH', 'ð' => 'dh', 'ß' => 'ss', 'Œ' => 'OE', 'œ' => 'oe', 'Æ' => 'AE', 'æ' => 'ae', 'µ' => 'u'));
				$clean_name = preg_replace(array('/\s/', '/[^\w_\.\-]/'), array('_', ''), $clean_name);
				$enc_name = $row['id_attach'] . '_' . strtr($clean_name, '.', '_') . md5($clean_name);
				$clean_name = preg_replace('~\.[\.]+~', '.', $clean_name);

				if(file_exists($smf_attachments_dir . '/' . $row['id_attach'] . '_' . str_replace('.', '_', $clean_name). md5($row['filename'] )))
					copy_file($smf_attachments_dir . '/' . $row['id_attach'] . '_' . str_replace('.', '_', $clean_name) . md5($row['filename']), $avatarUploadDir . '/'. $row['id_attach'] . '_' . $row['file_hash'] . '.elk');

				copy_file($smf_attachments_dir . '/' . $clean_name, $avatarUploadDir . '/' . $row['id_attach'] . '_' . $row['file_hash'] . '.elk');
			}
			else
				copy_file($smf_attachments_dir . '/' . $row['id_attach'] . '_' . $row['file_hash'], $avatarUploadDir . '/'. $row['id_attach'] . '_' . $row['file_hash'] . '.elk');
		</preparsecode>
		<query>
			SELECT
				id_attach, id_thumb, id_msg, id_member, attachment_type, filename, file_hash, size, downloads,
				width, height, fileext, mime_type, id_folder
			FROM {$from_prefix}attachments
			WHERE id_member != 0;
		</query>
	</step>