SimpleDesk-AdminCustomField.php

<?php
/**************************************************************
*          Simple Desk Project - www.simpledesk.net           *
***************************************************************
*       An advanced help desk modification built on SMF       *
***************************************************************
*                                                             *
*         * Copyright 2025 - SimpleDesk.net                   *
*                                                             *
*   This file and its contents are subject to the license     *
*   included with this distribution, license.txt, which       *
*   states that this software is New BSD Licensed.            *
*   Any questions, please contact SimpleDesk.net              *
*                                                             *
***************************************************************
* SimpleDesk Version: 2.1.0                                   *
* File Info: SimpleDesk-AdminCustomField.php                  *
**************************************************************/

/**
 *	This file handles the core of SimpleDesk's custom ticket fields interface and code.
 *
 *	@package source
 *	@since 2.0
*/
if (!defined('SMF'))
	die('Hacking attempt...');

/**
 *	The start point for all interaction with the SimpleDesk custom field administration.
 *
 *	Directed here from the main administration centre, after permission checks and a few dependencies loaded, this deals solely with managing custom fields.
 *
 *	@since 2.0
*/
function shd_admin_custom()
{
	global $context, $scripturl, $sourcedir, $settings, $txt, $modSettings;

	loadTemplate('sd_template/SimpleDesk-AdminCustomField');

	$subactions = array(
		'main' => 'shd_admin_custom_main',
		'new' => 'shd_admin_custom_new',
		'edit' => 'shd_admin_custom_edit',
		'move' => 'shd_admin_custom_move',
		'save' => 'shd_admin_custom_save',
	);

	$context['shd_current_subaction'] = isset($_REQUEST['sa']) && isset($subactions[$_REQUEST['sa']]) ? $_REQUEST['sa'] : 'main';

	$context['field_types'] = array(
		CFIELD_TYPE_TEXT => array($txt['shd_admin_custom_fields_ui_text'], 'text'),
		CFIELD_TYPE_LARGETEXT => array($txt['shd_admin_custom_fields_ui_largetext'], 'largetext'),
		CFIELD_TYPE_INT => array($txt['shd_admin_custom_fields_ui_int'], 'int'),
		CFIELD_TYPE_FLOAT => array($txt['shd_admin_custom_fields_ui_float'], 'float'),
		CFIELD_TYPE_SELECT => array($txt['shd_admin_custom_fields_ui_select'], 'select'),
		CFIELD_TYPE_CHECKBOX => array($txt['shd_admin_custom_fields_ui_checkbox'], 'checkbox'),
		CFIELD_TYPE_RADIO => array($txt['shd_admin_custom_fields_ui_radio'], 'radio'),
		CFIELD_TYPE_MULTI => array($txt['shd_admin_custom_fields_ui_multi'], 'multi'),
	);

	$subactions[$context['shd_current_subaction']]();
}

/**
 *	Display all the custom fields, including new/edit/save/delete UI hooks
 *
 *	@since 2.0
*/
function shd_admin_custom_main()
{
	global $context, $smcFunc, $modSettings, $txt;

	$context['custom_fields'] = array();

	$query = shd_db_query('', '
		SELECT id_field, active, field_order, field_name, field_desc, field_loc, icon, field_type, can_see, can_edit
		FROM {db_prefix}helpdesk_custom_fields
		ORDER BY field_order',
		array()
	);

	while ($row = $smcFunc['db_fetch_assoc']($query))
	{
		$row['active_string'] = empty($row['active']) ? 'inactive' : 'active';
		$row['field_type'] = $context['field_types'][$row['field_type']][1]; // convert the integer in the DB into the string for language + image uses
		$row['can_see'] = explode(',', $row['can_see']);
		$row['can_edit'] = explode(',', $row['can_edit']);
		$row['field_desc'] = parse_bbc($row['field_desc'], false);
		$context['custom_fields'][] = $row;
	}

	if (!empty($context['custom_fields']))
	{
		$context['custom_fields'][0]['is_first'] = true;
		$context['custom_fields'][count($context['custom_fields']) - 1]['is_last'] = true;
	}

	// Final stuff before we go.
	$context['page_title'] = $txt['shd_admin_custom_fields'];
	$context['sub_template'] = 'shd_custom_field_home';
}

/**
 *	Display the new field UI
 *
 *	@since 2.0
*/
function shd_admin_custom_new()
{
	global $context, $smcFunc, $modSettings, $txt, $scripturl;

	$context = array_merge($context, array(
		'sub_template' => 'shd_custom_field_edit',
		'page_title' => $txt['shd_admin_new_custom_field'],
		'section_title' => $txt['shd_admin_new_custom_field'],
		'section_desc' => $txt['shd_admin_new_custom_field_desc'],
		'field_type_value' => CFIELD_TYPE_TEXT,
		'field_icons' => shd_admin_cf_icons(),
		'field_icon_value' => '',
		'new_field' => true,
		'field_loc' => CFIELD_TICKET,
		'field_active' => ' checked="checked"',
		'placement' => CFIELD_PLACE_DETAILS,
	));

	$context['custom_field']['options'] = array(1 => '', '', '', 'inactive' => array(), 'order' => array());
	$context['custom_field']['default_value'] = false;

	// Get the list of departments, and whether a field is required in each department.
	$context['dept_fields'] = array();
	$query = $smcFunc['db_query']('', '
		SELECT hdd.id_dept, hdd.dept_name, 0 AS present, 0 AS required
		FROM {db_prefix}helpdesk_depts AS hdd
		ORDER BY hdd.dept_order',
		array()
	);
	while ($row = $smcFunc['db_fetch_assoc']($query))
		$context['dept_fields'][$row['id_dept']] = $row;
	$smcFunc['db_free_result']($query);

	loadLanguage('ManageSettings');
}

/**
 *	Display the edit field UI
 *
 *	@since 2.0
*/
function shd_admin_custom_edit()
{
	global $context, $smcFunc, $modSettings, $txt;

	$_REQUEST['field'] = isset($_REQUEST['field']) ? (int) $_REQUEST['field'] : 0;

	$query = shd_db_query('', '
		SELECT id_field, active, field_order, field_name, field_desc, field_loc, icon, field_type,
		field_length, field_options, bbc, default_value, can_see, can_edit,
		display_empty, placement
		FROM {db_prefix}helpdesk_custom_fields
		WHERE id_field = {int:field}',
		array(
			'field' => $_REQUEST['field'],
		)
	);

	if ($row = $smcFunc['db_fetch_assoc']($query))
	{
		$smcFunc['db_free_result']($query);
		$context['custom_field'] = $row;
		$context['section_title'] = $txt['shd_admin_edit_custom_field'];
		$context['section_desc'] = $txt['shd_admin_edit_custom_field_desc'];
		$context['page_title'] = $txt['shd_admin_edit_custom_field'];
		$context['sub_template'] = 'shd_custom_field_edit';
		$context['custom_field']['options'] = !empty($row['field_options']) ? smf_json_decode($row['field_options'], true) : array(1 => '', '', '');

		if (empty($context['custom_field']['options']['inactive']))
			$context['custom_field']['options']['inactive'] = array();

		if (!isset($context['custom_field']['options']['order']))
			$context['custom_field']['options']['order'] = array();

		// If this option isn't in the order, make it so!
		foreach ($context['custom_field']['options'] as $key => $val)
			if (!in_array($key, array('inactive', 'order')) && !in_array($key, $context['custom_field']['options']['order']))
				$context['custom_field']['options']['order'][] = $key;

		// Make sure it exists in the order.
		foreach ($context['custom_field']['options']['order'] as $key => $val)
			if (!isset($context['custom_field']['options'][$val]))
				unset($context['custom_field']['options']['order'][$val]);

		// first and last order.
		$context['custom_field']['order_first'] = current($context['custom_field']['options']['order']);
		$context['custom_field']['order_last'] = end($context['custom_field']['options']['order']);

		// If this is a textarea, we need to get its dimensions too.
		if ($context['custom_field']['field_type'] == CFIELD_TYPE_LARGETEXT)
			$context['custom_field']['dimensions'] = explode(',', $context['custom_field']['default_value']);

		$context['custom_field']['can_see'] = explode(',', $context['custom_field']['can_see']);
		$context['custom_field']['can_edit'] = explode(',', $context['custom_field']['can_edit']);

		$context = array_merge($context, array(
			'field_type_value' => $context['custom_field']['field_type'],
			'field_icons' => shd_admin_cf_icons(),
			'field_icon_value' => $context['custom_field']['icon'],
			'field_loc' => $context['custom_field']['field_loc'],
			'field_active' => $context['custom_field']['active'] == 1 ? ' checked="checked"' : '',
			'placement' => $context['custom_field']['placement'],
		));

		// Get the possible field types and exclude types that we can't change it to.
		$types = shd_admin_cf_change_types($context['custom_field']['field_type']);
		foreach ($context['field_types'] as $k => $v)
			if (!in_array($k, $types))
				unset($context['field_types'][$k]);

		// Get the list of departments, and whether a field is required in each department.
		$context['dept_fields'] = array();
		$query = $smcFunc['db_query']('', '
			SELECT hdd.id_dept, hdd.dept_name, cfd.id_dept AS present, cfd.required
			FROM {db_prefix}helpdesk_depts AS hdd
				LEFT JOIN {db_prefix}helpdesk_custom_fields_depts AS cfd ON (cfd.id_field = {int:field} AND hdd.id_dept = cfd.id_dept)
			ORDER BY hdd.dept_order',
			array(
				'field' => $_REQUEST['field'],
			)
		);
		while ($row = $smcFunc['db_fetch_assoc']($query))
			$context['dept_fields'][$row['id_dept']] = $row;
		$smcFunc['db_free_result']($query);
	}
	else
	{
		$smcFunc['db_free_result']($query);
		shd_fatal_lang_error('shd_admin_cannot_edit_custom_field', false);
	}

	loadLanguage('ManageSettings');
}

/**
 *	Handle saving a field
 *
 *	@since 2.0
*/
function shd_admin_custom_save()
{
	global $context, $smcFunc, $modSettings, $sourcedir;

	checkSession('request');

	// Deletifyingistuffithingi?
	if (isset($_REQUEST['delete']) && !empty($_REQUEST['field']))
	{
		$_REQUEST['field'] = (int) $_REQUEST['field'];
		// We actually have to get the current position, because we need to shove everything else up one after.
		$query = $smcFunc['db_query']('', '
			SELECT field_order
			FROM {db_prefix}helpdesk_custom_fields
			WHERE id_field = {int:field}',
			array(
				'field' => $_REQUEST['field'],
			)
		);
		if ($smcFunc['db_num_rows']($query) == 0)
		{
			$smcFunc['db_free_result']($query);
			redirectexit('action=admin;area=helpdesk_customfield;' . $context['session_var'] . '=' . $context['session_id']);
		}

		list($current_pos) = $smcFunc['db_fetch_row']($query);
		$smcFunc['db_free_result']($query);

		$smcFunc['db_query']('', '
			DELETE FROM {db_prefix}helpdesk_custom_fields
			WHERE id_field = {int:field}',
			array(
				'field' => $_REQUEST['field'],
			)
		);

		$smcFunc['db_query']('', '
			UPDATE {db_prefix}helpdesk_custom_fields
			SET field_order = field_order - 1
			WHERE field_order > {int:current_pos}',
			array(
				'current_pos' => $current_pos,
			)
		);

		$smcFunc['db_query']('', '
			DELETE FROM {db_prefix}helpdesk_custom_fields_values
			WHERE id_field = {int:field}',
			array(
				'field' => $_REQUEST['field'],
			)
		);

		$smcFunc['db_query']('', '
			DELETE FROM {db_prefix}helpdesk_custom_fields_depts
			WHERE id_field = {int:field}',
			array(
				'field' => $_REQUEST['field'],
			)
		);

		// Do the needfull.
		shd_admin_log('admin_customfield', array(
			'action' => 'delete',
			'id' => $_REQUEST['field'],
		));

		// End of the road
		redirectexit('action=admin;area=helpdesk_customfield;' . $context['session_var'] . '=' . $context['session_id']);
	}

	// Aborting mission!
	if (isset($_POST['cancel']))
		redirectexit('action=admin;area=helpdesk_customfield;' . $context['session_var'] . '=' . $context['session_id']);

	// OK, we're going to need this
	require_once($sourcedir . '/Subs-Post.php');

	// Fix all the input
	if (trim($_POST['field_name']) == '')
		shd_fatal_lang_error('shd_admin_no_fieldname', false);
	$_POST['field_name'] = $smcFunc['htmlspecialchars']($_POST['field_name']);
	$_POST['description'] = $smcFunc['htmlspecialchars'](isset($_POST['description']) ? $_POST['description'] : '');
	preparsecode($_POST['description']);
	$_POST['bbc'] = isset($_POST['bbc']) && in_array($_POST['field_type'], array(CFIELD_TYPE_TEXT, CFIELD_TYPE_LARGETEXT)) ? 1 : 0;
	$_POST['display_empty'] = isset($_POST['display_empty']) ? 1 : 0;

	$_POST['field_type'] == isset($_POST['field_type']) ? (int) $_POST['field_type'] : 0;

	$_POST['active'] = isset($_POST['active']) ? 1 : 0;
	$_POST['field_length'] = isset($_POST['field_length']) ? (int) $_POST['field_length'] : 0;
	if ($_POST['field_length'] < 0)
		$_POST['field_length'] = 0;
	elseif ($_POST['field_length'] > 32000)
		$_POST['field_length'] = 32000;
	$_POST['default_check'] = isset($_POST['default_check']) && $_POST['field_type'] == CFIELD_TYPE_CHECKBOX ? 1 : '';

	if ($_POST['field_type'] == CFIELD_TYPE_LARGETEXT)
		$_POST['default_check'] = (int) $_POST['rows'] . ',' . (int) $_POST['cols'];
	if (!isset($_POST['placement']) || !in_array($_POST['placement'], array(CFIELD_PLACE_DETAILS, CFIELD_PLACE_INFO, CFIELD_PLACE_PREFIX, CFIELD_PLACE_PREFIXFILTER)))
		$_POST['placement'] = CFIELD_PLACE_DETAILS;
	if ($_POST['placement'] == CFIELD_PLACE_PREFIXFILTER && !in_array($_POST['field_type'], array(CFIELD_TYPE_SELECT, CFIELD_TYPE_RADIO)))
		$_POST['placement'] = CFIELD_PLACE_PREFIX;
	$_POST['field_icon'] = isset($_POST['field_icon']) && preg_match('~^[A-Za-z0-9.\-_]+$~', $_POST['field_icon']) ? $_POST['field_icon'] : '';
	$options = '';

	$users_see = !empty($_POST['see_users']) ? '1' : '0';
	$users_edit = $users_see == '1' && !empty($_POST['edit_users']) ? '1' : '0';

	$staff_see = !empty($_POST['see_staff']) ? '1' : '0';
	$staff_edit = $staff_see == '1' && !empty($_POST['edit_staff']) ? '1' : '0';

	$can_see = $users_see . ',' . $staff_see;
	$can_edit = $users_edit . ',' . $staff_edit;

	// Get the list of departments, and whether a field is required in each department.
	$context['dept_fields'] = array();
	$query = $smcFunc['db_query']('', '
		SELECT hdd.id_dept, hdd.dept_name
		FROM {db_prefix}helpdesk_depts AS hdd
		ORDER BY hdd.dept_order',
		array(
			'field' => $_REQUEST['field'],
		)
	);
	while ($row = $smcFunc['db_fetch_assoc']($query))
	{
		// Is the field meant to be in this department?
		if (empty($_POST['present_dept' . $row['id_dept']]))
			continue;
		$context['dept_fields'][$row['id_dept']] = $row;
		if ($_POST['field_type'] == CFIELD_TYPE_MULTI)
		{
			$required = isset($_POST['required_dept_multi_' . $row['id_dept']]) ? (int) $_POST['required_dept_multi_' . $row['id_dept']] : 0;
			if ($required < 0)
				$required = 0;
			elseif ($required > 100)
				$required = 100;
			$context['dept_fields'][$row['id_dept']]['required'] = $required;
		}
		else
			$context['dept_fields'][$row['id_dept']]['required'] = isset($_POST['required_dept' . $row['id_dept']]) ? 1 : 0;
	}
	$smcFunc['db_free_result']($query);

	// Select options?
	$newOptions = $defaultOptions = $optionsOrder = array();
	if (!empty($_POST['select_option']) && ($_POST['field_type'] == CFIELD_TYPE_SELECT || $_POST['field_type'] == CFIELD_TYPE_RADIO || $_POST['field_type'] == CFIELD_TYPE_MULTI))
	{
		foreach ($_POST['select_option'] as $k => $v)
		{
			// Clean, clean, clean...
			$v = $smcFunc['htmlspecialchars']($v);
			preparsecode($v);

			// Nada, zip, etc...
			if (trim($v) == '' || !is_numeric($k))
				continue;

			// This is just for working out what happened with old options...
			$newOptions[$k] = $v;
			if (!empty($_POST['default_select_multi'][$k]))
				$defaultOptions[] = $k;

			// Is it default?
			if (isset($_POST['default_select']) && $_POST['default_select'] == $k)
				$_POST['default_check'] = $k;

			// Our order.
			$optionsOrder[$_POST['order'][$k]] = $k;
		}

		$newOptions['order'] = $optionsOrder;
		$options = json_encode($newOptions);
	}

	// Sort out the default selection if it's a multi-select, as well as required amounts
	if ($_POST['field_type'] == CFIELD_TYPE_MULTI)
	{
		$_POST['default_check'] = implode(',', $defaultOptions);
		$max = count($newOptions);
		foreach ($context['dept_fields'] as $dept => $field)
			if ($field['required'] > $max)
				$context['dept_fields'][$dept]['required'] = $max;
	}

	// Do I feel a new field being born?
	if (isset($_REQUEST['new']))
	{
		$types = shd_admin_cf_change_types(false);
		if (!in_array($_POST['field_type'], $types))
			shd_fatal_lang_error('shd_admin_custom_field_invalid', false);

		// Order??
		$count_query = shd_db_query('', '
			SELECT COUNT(id_field) AS count
			FROM {db_prefix}helpdesk_custom_fields',
			array()
		);

		$row = $smcFunc['db_fetch_assoc']($count_query);

		$new_field = $smcFunc['db_insert']('insert',
			'{db_prefix}helpdesk_custom_fields',
			array(
				'active' => 'int', 'field_order' => 'int', 'field_name' => 'string', 'field_desc' => 'string',
				'field_loc' => 'int', 'icon' => 'string', 'field_type' => 'int', 'field_length' => 'int',
				'field_options' => 'string', 'bbc' => 'int', 'default_value' => 'string', 'can_see' => 'string',
				'can_edit' => 'string', 'display_empty' => 'int', 'placement' => 'int',
			),
			array(
				$_POST['active'], $row['count'], $_POST['field_name'], $_POST['description'],
				$_POST['field_visible'], $_POST['field_icon'], $_POST['field_type'], $_POST['field_length'],
				$options, $_POST['bbc'], $_POST['default_check'], $can_see,
				$can_edit, $_POST['display_empty'], $_POST['placement'],
			),
			array(
				'id_field',
			),
			1
		);

		if (empty($new_field))
			shd_fatal_lang_error('shd_admin_could_not_create_field', false);

		// Also update fields
		$smcFunc['db_query']('', '
			DELETE FROM {db_prefix}helpdesk_custom_fields_depts
			WHERE id_field = {int:field}',
			array(
				'field' => $new_field,
			)
		);
		$fields = array();
		foreach ($context['dept_fields'] as $id => $row)
			$fields[] = array($new_field, $id, $row['required']);

		$smcFunc['db_insert']('replace',
			'{db_prefix}helpdesk_custom_fields_depts',
			array(
				'id_field' => 'int', 'id_dept' => 'int', 'required' => 'int',
			),
			$fields,
			array(
				'id_field', 'id_dept',
			)
		);

		// Log this action.
		shd_admin_log('admin_customfield', array(
			'action' => 'add',
			'id' => $new_field,
		));

		redirectexit('action=admin;area=helpdesk_customfield;' . $context['session_var'] . '=' . $context['session_id']);
	}
	// No? Meh. Update it is then.
	else
	{
		// Before we do, just double check the type of data in the field.
		$query = shd_db_query('', '
			SELECT field_type, field_options
			FROM {db_prefix}helpdesk_custom_fields
			WHERE id_field = {int:id_field}',
			array(
				'id_field' => $_REQUEST['field'],
			)
		);
		if ($row = $smcFunc['db_fetch_assoc']($query))
		{
			$smcFunc['db_free_result']($query);
			$types = shd_admin_cf_change_types($row['field_type']);
			if (!in_array($_POST['field_type'], $types))
				shd_fatal_lang_error('shd_admin_custom_field_reselect_invalid', false);
		}
		else
		{
			$smcFunc['db_free_result']($query);
			shd_fatal_lang_error('shd_admin_cannot_edit_custom_field', false);
		}

		// Depending on the field type, we may need to be funky about overlaying things, hence grabbing the old options.
		if (!empty($row['field_options']) && in_array($row['field_type'], array(CFIELD_TYPE_SELECT, CFIELD_TYPE_RADIO, CFIELD_TYPE_MULTI)))
		{
			$row['field_options'] = smf_json_decode($row['field_options'], true);
			ksort($row['field_options']);
			ksort($newOptions);
			$inactive = array();
			$new_fields = array();
			// First, figure out what fields we had before.
			foreach ($row['field_options'] as $k => $v)
			{
				if ($k == 'inactive' || $k == 'order')
					continue;
				if (!isset($newOptions[$k]))
					$inactive[] = $k;
				$new_fields[$k] = $v;
			}
			// Now, take any of the new stuff and overwrite the old.
			foreach ($newOptions as $k => $v)
				$new_fields[$k] = $v;
			$new_fields['inactive'] = $inactive;
			$new_fields['order'] = $optionsOrder;
			$options = json_encode($new_fields);
		}

		shd_db_query('', '
			UPDATE {db_prefix}helpdesk_custom_fields
			SET
				active = {int:active}, field_name = {string:field_name},
				field_desc = {string:field_desc}, field_loc = {int:field_visible},
				icon = {string:field_icon}, field_type = {int:field_type},
				field_length = {int:field_length}, field_options = {string:field_options},
				bbc = {int:bbc}, default_value = {string:default_value}, can_see = {string:can_see},
				can_edit = {string:can_edit}, display_empty = {int:display_empty}, placement = {int:placement}
			WHERE id_field = {int:id_field}',
			array(
				'id_field' => $_REQUEST['field'],
				'active' => $_POST['active'],
				'field_name' => $_POST['field_name'],
				'field_desc' => $_POST['description'],
				'field_visible' => $_POST['field_visible'],
				'field_icon' => $_POST['field_icon'],
				'field_type' => $_POST['field_type'],
				'field_length' => $_POST['field_length'],
				'field_options' => $options,
				'bbc' => $_POST['bbc'],
				'default_value' => $_POST['default_check'],
				'can_see' => $can_see,
				'can_edit' => $can_edit,
				'display_empty' => $_POST['display_empty'],
				'placement' => $_POST['placement'],
			)
		);

		// Also update fields
		$smcFunc['db_query']('', '
			DELETE FROM {db_prefix}helpdesk_custom_fields_depts
			WHERE id_field = {int:field}',
			array(
				'field' => $_REQUEST['field'],
			)
		);
		$fields = array();
		foreach ($context['dept_fields'] as $id => $row)
			$fields[] = array($_REQUEST['field'], $id, $row['required']);

		$smcFunc['db_insert']('replace',
			'{db_prefix}helpdesk_custom_fields_depts',
			array(
				'id_field' => 'int', 'id_dept' => 'int', 'required' => 'int',
			),
			$fields,
			array(
				'id_field', 'id_dept',
			)
		);

		// Log this action.
		shd_admin_log('admin_customfield', array(
			'action' => 'update',
			'id' => $_REQUEST['field'],
		));

		redirectexit('action=admin;area=helpdesk_customfield;' . $context['session_var'] . '=' . $context['session_id']);
	}
}

/**
 *	Handle moving a custom field up or down
 *
 *	@since 2.0
*/
function shd_admin_custom_move()
{
	global $context, $smcFunc, $modSettings;

	checkSession('get');

	$_REQUEST['field'] = isset($_REQUEST['field']) ? (int) $_REQUEST['field'] : 0;
	$_REQUEST['direction'] = isset($_REQUEST['direction']) && in_array($_REQUEST['direction'], array('up', 'down')) ? $_REQUEST['direction'] : '';

	$query = shd_db_query('', '
		SELECT id_field, field_order
		FROM {db_prefix}helpdesk_custom_fields',
		array()
	);

	if ($smcFunc['db_num_rows']($query) == 0 || empty($_REQUEST['direction']))
	{
		$smcFunc['db_free_result']($query);
		shd_fatal_lang_error('shd_admin_cannot_move_custom_field', false);
	}

	$fields = array();
	$fields_map = array();
	while ($row = $smcFunc['db_fetch_assoc']($query))
	{
		$fields[$row['field_order']] = $row['id_field'];
		$fields_map[$row['id_field']] = $row['field_order'];
	}

	ksort($fields);

	if (!isset($fields_map[$_REQUEST['field']]))
		shd_fatal_lang_error('shd_admin_cannot_move_custom_field', false);

	$current_pos = $fields_map[$_REQUEST['field']];
	$destination = $current_pos + ($_REQUEST['direction'] == 'up' ? -1 : 1);

	if (empty($fields[$destination]))
		shd_fatal_lang_error('shd_admin_cannot_move_custom_field_' . $_REQUEST['direction'], false);

	$other_field = $fields[$destination];

	shd_db_query('', '
		UPDATE {db_prefix}helpdesk_custom_fields
		SET field_order = {int:new_pos}
		WHERE id_field = {int:field}',
		array(
			'new_pos' => $destination,
			'field' => $_REQUEST['field'],
		)
	);

	shd_db_query('', '
		UPDATE {db_prefix}helpdesk_custom_fields
		SET field_order = {int:old_pos}
		WHERE id_field = {int:other_field}',
		array(
			'old_pos' => $current_pos,
			'other_field' => $other_field,
		)
	);

	// Log this as well.
	shd_admin_log('admin_customfield', array(
		'action' => 'move',
		'id' => $_REQUEST['field'],
		'direction' => $_REQUEST['direction']
	));

	redirectexit('action=admin;area=helpdesk_customfield;' . $context['session_var'] . '=' . $context['session_id']);
}

/**
 *	Get possible icons
 *
 *	@return array A list of possible images for the icon selector (everything in Themes/default/images/simpledesk/cf/ that's an image). Each item in the principle array is an array of value/caption pairs.
 *	@since 2.0
*/
function shd_admin_cf_icons()
{
	global $context, $settings, $txt;

	static $iconlist = array();

	if (!empty($iconlist))
		return $iconlist;

	$iconlist = array(
		array('', $txt['shd_admin_custom_fields_none']),
	);

	// Open the directory..
	$dir = dir($settings['default_theme_dir'] . '/images/simpledesk/cf/');
	$files = array();

	if (!is_object($dir) || is_null($dir))
		return $iconlist;

	while ($line = $dir->read())
		$files[] = $line;
	$dir->close();

	// Sort the results...
	natcasesort($files);

	foreach ($files as $line)
	{
		$filename = substr($line, 0, (strlen($line) - strlen(strrchr($line, '.'))));
		$extension = substr(strrchr($line, '.'), 1);

		// Make sure it is an image.
		if (strcasecmp($extension, 'gif') != 0 && strcasecmp($extension, 'jpg') != 0 && strcasecmp($extension, 'jpeg') != 0 && strcasecmp($extension, 'png') != 0 && strcasecmp($extension, 'bmp') != 0)
			continue;

		$iconlist[] = array(htmlspecialchars($filename . '.' . $extension), htmlspecialchars(str_replace('_', ' ', $filename)));
	}

	return $iconlist;
}

/**
 *	This function takes a given type of field and indicates what possible types it could be changed to afterwards.
 *
 *	@param mixed $from_type One of the CFIELD_TYPE constants to indicate the type of field. Alternatively, can be boolean false to return a list of all known types.
 *	@return array An array of CFIELD_TYPE constants indicating the possible field types it can be turned into.
 */
function shd_admin_cf_change_types($from_type)
{
	switch ($from_type)
	{
		case false: // All known types.
			return array(CFIELD_TYPE_TEXT, CFIELD_TYPE_LARGETEXT, CFIELD_TYPE_INT, CFIELD_TYPE_FLOAT, CFIELD_TYPE_SELECT, CFIELD_TYPE_CHECKBOX, CFIELD_TYPE_RADIO, CFIELD_TYPE_MULTI);
		case CFIELD_TYPE_TEXT: // Textbox and large textbox are interchangeable in all practical respects.
		case CFIELD_TYPE_LARGETEXT:
			return array(CFIELD_TYPE_TEXT, CFIELD_TYPE_LARGETEXT);
		case CFIELD_TYPE_INT: // Can always convert an int to a float
			return array(CFIELD_TYPE_INT, CFIELD_TYPE_FLOAT);
		case CFIELD_TYPE_FLOAT: // But you can't safely go back the other way
			return array(CFIELD_TYPE_FLOAT);
		case CFIELD_TYPE_SELECT: // Different ways of showing/selecting the same thing, really - and multiselect is a superset of these.
		case CFIELD_TYPE_RADIO:
			return array(CFIELD_TYPE_SELECT, CFIELD_TYPE_RADIO, CFIELD_TYPE_MULTI);
		case CFIELD_TYPE_CHECKBOX: // And, well, this is all you can do.
			return array(CFIELD_TYPE_CHECKBOX);
		case CFIELD_TYPE_MULTI: // Multiselectors can't become anything else, because you're implicitly holding multiple values.
			return array(CFIELD_TYPE_MULTI);
		default:
			return array();
	}
}