';
Chris@76:
Chris@76: prepareDBSettingContext($config_vars);
Chris@76: }
Chris@76:
Chris@76: // Just pause the signature applying thing.
Chris@76: function pauseSignatureApplySettings()
Chris@76: {
Chris@76: global $context, $txt, $sig_start;
Chris@76:
Chris@76: // Try get more time...
Chris@76: @set_time_limit(600);
Chris@76: if (function_exists('apache_reset_timeout'))
Chris@76: @apache_reset_timeout();
Chris@76:
Chris@76: // Have we exhausted all the time we allowed?
Chris@76: if (time() - array_sum(explode(' ', $sig_start)) < 3)
Chris@76: return;
Chris@76:
Chris@76: $context['continue_get_data'] = '?action=admin;area=featuresettings;sa=sig;apply;step=' . $_GET['step'] . ';' . $context['session_var'] . '=' . $context['session_id'];
Chris@76: $context['page_title'] = $txt['not_done_title'];
Chris@76: $context['continue_post_data'] = '';
Chris@76: $context['continue_countdown'] = '2';
Chris@76: $context['sub_template'] = 'not_done';
Chris@76:
Chris@76: // Specific stuff to not break this template!
Chris@76: $context[$context['admin_menu_name']]['current_subsection'] = 'sig';
Chris@76:
Chris@76: // Get the right percent.
Chris@76: $context['continue_percent'] = round(($_GET['step'] / $context['max_member']) * 100);
Chris@76:
Chris@76: // Never more than 100%!
Chris@76: $context['continue_percent'] = min($context['continue_percent'], 100);
Chris@76:
Chris@76: obExit();
Chris@76: }
Chris@76:
Chris@76: // Show all the custom profile fields available to the user.
Chris@76: function ShowCustomProfiles()
Chris@76: {
Chris@76: global $txt, $scripturl, $context, $settings, $sc, $smcFunc;
Chris@76: global $modSettings, $sourcedir;
Chris@76:
Chris@76: $context['page_title'] = $txt['custom_profile_title'];
Chris@76: $context['sub_template'] = 'show_custom_profile';
Chris@76:
Chris@76: // What about standard fields they can tweak?
Chris@76: $standard_fields = array('icq', 'msn', 'aim', 'yim', 'location', 'gender', 'website', 'posts', 'warning_status');
Chris@76: // What fields can't you put on the registration page?
Chris@76: $context['fields_no_registration'] = array('posts', 'warning_status');
Chris@76:
Chris@76: // Are we saving any standard field changes?
Chris@76: if (isset($_POST['save']))
Chris@76: {
Chris@76: checkSession();
Chris@76:
Chris@76: // Do the active ones first.
Chris@76: $disable_fields = array_flip($standard_fields);
Chris@76: if (!empty($_POST['active']))
Chris@76: {
Chris@76: foreach ($_POST['active'] as $value)
Chris@76: if (isset($disable_fields[$value]))
Chris@76: unset($disable_fields[$value]);
Chris@76: }
Chris@76: // What we have left!
Chris@76: $changes['disabled_profile_fields'] = empty($disable_fields) ? '' : implode(',', array_keys($disable_fields));
Chris@76:
Chris@76: // Things we want to show on registration?
Chris@76: $reg_fields = array();
Chris@76: if (!empty($_POST['reg']))
Chris@76: {
Chris@76: foreach ($_POST['reg'] as $value)
Chris@76: if (in_array($value, $standard_fields) && !isset($disable_fields[$value]))
Chris@76: $reg_fields[] = $value;
Chris@76: }
Chris@76: // What we have left!
Chris@76: $changes['registration_fields'] = empty($reg_fields) ? '' : implode(',', $reg_fields);
Chris@76:
Chris@76: if (!empty($changes))
Chris@76: updateSettings($changes);
Chris@76: }
Chris@76:
Chris@76: require_once($sourcedir . '/Subs-List.php');
Chris@76:
Chris@76: $listOptions = array(
Chris@76: 'id' => 'standard_profile_fields',
Chris@76: 'title' => $txt['standard_profile_title'],
Chris@76: 'base_href' => $scripturl . '?action=admin;area=featuresettings;sa=profile',
Chris@76: 'get_items' => array(
Chris@76: 'function' => 'list_getProfileFields',
Chris@76: 'params' => array(
Chris@76: true,
Chris@76: ),
Chris@76: ),
Chris@76: 'columns' => array(
Chris@76: 'field' => array(
Chris@76: 'header' => array(
Chris@76: 'value' => $txt['standard_profile_field'],
Chris@76: 'style' => 'text-align: left;',
Chris@76: ),
Chris@76: 'data' => array(
Chris@76: 'db' => 'label',
Chris@76: 'style' => 'width: 60%;',
Chris@76: ),
Chris@76: ),
Chris@76: 'active' => array(
Chris@76: 'header' => array(
Chris@76: 'value' => $txt['custom_edit_active'],
Chris@76: ),
Chris@76: 'data' => array(
Chris@76: 'function' => create_function('$rowData', '
Chris@76: $isChecked = $rowData[\'disabled\'] ? \'\' : \' checked="checked"\';
Chris@76: $onClickHandler = $rowData[\'can_show_register\'] ? sprintf(\'onclick="document.getElementById(\\\'reg_%1$s\\\').disabled = !this.checked;"\', $rowData[\'id\']) : \'\';
Chris@76: return sprintf(\'\', $rowData[\'id\'], $isChecked, $onClickHandler);
Chris@76: '),
Chris@76: 'style' => 'width: 20%; text-align: center;',
Chris@76: ),
Chris@76: ),
Chris@76: 'show_on_registration' => array(
Chris@76: 'header' => array(
Chris@76: 'value' => $txt['custom_edit_registration'],
Chris@76: ),
Chris@76: 'data' => array(
Chris@76: 'function' => create_function('$rowData', '
Chris@76: $isChecked = $rowData[\'on_register\'] && !$rowData[\'disabled\'] ? \' checked="checked"\' : \'\';
Chris@76: $isDisabled = $rowData[\'can_show_register\'] ? \'\' : \' disabled="disabled"\';
Chris@76: return sprintf(\'\', $rowData[\'id\'], $isChecked, $isDisabled);
Chris@76: '),
Chris@76: 'style' => 'width: 20%; text-align: center;',
Chris@76: ),
Chris@76: ),
Chris@76: ),
Chris@76: 'form' => array(
Chris@76: 'href' => $scripturl . '?action=admin;area=featuresettings;sa=profile',
Chris@76: 'name' => 'standardProfileFields',
Chris@76: ),
Chris@76: 'additional_rows' => array(
Chris@76: array(
Chris@76: 'position' => 'below_table_data',
Chris@76: 'value' => '',
Chris@76: 'style' => 'text-align: right;',
Chris@76: ),
Chris@76: ),
Chris@76: );
Chris@76: createList($listOptions);
Chris@76:
Chris@76: $listOptions = array(
Chris@76: 'id' => 'custom_profile_fields',
Chris@76: 'title' => $txt['custom_profile_title'],
Chris@76: 'base_href' => $scripturl . '?action=admin;area=featuresettings;sa=profile',
Chris@76: 'default_sort_col' => 'field_name',
Chris@76: 'no_items_label' => $txt['custom_profile_none'],
Chris@76: 'items_per_page' => 25,
Chris@76: 'get_items' => array(
Chris@76: 'function' => 'list_getProfileFields',
Chris@76: 'params' => array(
Chris@76: false,
Chris@76: ),
Chris@76: ),
Chris@76: 'get_count' => array(
Chris@76: 'function' => 'list_getProfileFieldSize',
Chris@76: ),
Chris@76: 'columns' => array(
Chris@76: 'field_name' => array(
Chris@76: 'header' => array(
Chris@76: 'value' => $txt['custom_profile_fieldname'],
Chris@76: 'style' => 'text-align: left;',
Chris@76: ),
Chris@76: 'data' => array(
Chris@76: 'function' => create_function('$rowData', '
Chris@76: global $scripturl;
Chris@76:
Chris@76: return sprintf(\'%3$s
%4$s
\', $scripturl, $rowData[\'id_field\'], $rowData[\'field_name\'], $rowData[\'field_desc\']);
Chris@76: '),
Chris@76: 'style' => 'width: 62%;',
Chris@76: ),
Chris@76: 'sort' => array(
Chris@76: 'default' => 'field_name',
Chris@76: 'reverse' => 'field_name DESC',
Chris@76: ),
Chris@76: ),
Chris@76: 'field_type' => array(
Chris@76: 'header' => array(
Chris@76: 'value' => $txt['custom_profile_fieldtype'],
Chris@76: 'style' => 'text-align: left;',
Chris@76: ),
Chris@76: 'data' => array(
Chris@76: 'function' => create_function('$rowData', '
Chris@76: global $txt;
Chris@76:
Chris@76: $textKey = sprintf(\'custom_profile_type_%1$s\', $rowData[\'field_type\']);
Chris@76: return isset($txt[$textKey]) ? $txt[$textKey] : $textKey;
Chris@76: '),
Chris@76: 'style' => 'width: 15%;',
Chris@76: ),
Chris@76: 'sort' => array(
Chris@76: 'default' => 'field_type',
Chris@76: 'reverse' => 'field_type DESC',
Chris@76: ),
Chris@76: ),
Chris@76: 'active' => array(
Chris@76: 'header' => array(
Chris@76: 'value' => $txt['custom_profile_active'],
Chris@76: ),
Chris@76: 'data' => array(
Chris@76: 'function' => create_function('$rowData', '
Chris@76: global $txt;
Chris@76:
Chris@76: return $rowData[\'active\'] ? $txt[\'yes\'] : $txt[\'no\'];
Chris@76: '),
Chris@76: 'style' => 'width: 8%; text-align: center;',
Chris@76: ),
Chris@76: 'sort' => array(
Chris@76: 'default' => 'active DESC',
Chris@76: 'reverse' => 'active',
Chris@76: ),
Chris@76: ),
Chris@76: 'placement' => array(
Chris@76: 'header' => array(
Chris@76: 'value' => $txt['custom_profile_placement'],
Chris@76: ),
Chris@76: 'data' => array(
Chris@76: 'function' => create_function('$rowData', '
Chris@76: global $txt;
Chris@76:
Chris@76: return $txt[\'custom_profile_placement_\' . (empty($rowData[\'placement\']) ? \'standard\' : ($rowData[\'placement\'] == 1 ? \'withicons\' : \'abovesignature\'))];
Chris@76: '),
Chris@76: 'style' => 'width: 8%; text-align: center;',
Chris@76: ),
Chris@76: 'sort' => array(
Chris@76: 'default' => 'placement DESC',
Chris@76: 'reverse' => 'placement',
Chris@76: ),
Chris@76: ),
Chris@76: 'show_on_registration' => array(
Chris@76: 'header' => array(
Chris@76: 'value' => $txt['modify'],
Chris@76: ),
Chris@76: 'data' => array(
Chris@76: 'sprintf' => array(
Chris@76: 'format' => '' . $txt['modify'] . '',
Chris@76: 'params' => array(
Chris@76: 'id_field' => false,
Chris@76: ),
Chris@76: ),
Chris@76: 'style' => 'width: 15%; text-align: center;',
Chris@76: ),
Chris@76: ),
Chris@76: ),
Chris@76: 'form' => array(
Chris@76: 'href' => $scripturl . '?action=admin;area=featuresettings;sa=profileedit',
Chris@76: 'name' => 'customProfileFields',
Chris@76: ),
Chris@76: 'additional_rows' => array(
Chris@76: array(
Chris@76: 'position' => 'below_table_data',
Chris@76: 'value' => '',
Chris@76: 'style' => 'text-align: right;',
Chris@76: ),
Chris@76: ),
Chris@76: );
Chris@76: createList($listOptions);
Chris@76: }
Chris@76:
Chris@76: function list_getProfileFields($start, $items_per_page, $sort, $standardFields)
Chris@76: {
Chris@76: global $txt, $modSettings, $smcFunc;
Chris@76:
Chris@76: $list = array();
Chris@76:
Chris@76: if ($standardFields)
Chris@76: {
Chris@76: $standard_fields = array('icq', 'msn', 'aim', 'yim', 'location', 'gender', 'website', 'posts', 'warning_status');
Chris@76: $fields_no_registration = array('posts', 'warning_status');
Chris@76: $disabled_fields = isset($modSettings['disabled_profile_fields']) ? explode(',', $modSettings['disabled_profile_fields']) : array();
Chris@76: $registration_fields = isset($modSettings['registration_fields']) ? explode(',', $modSettings['registration_fields']) : array();
Chris@76:
Chris@76: foreach ($standard_fields as $field)
Chris@76: $list[] = array(
Chris@76: 'id' => $field,
Chris@76: 'label' => isset($txt['standard_profile_field_' . $field]) ? $txt['standard_profile_field_' . $field] : (isset($txt[$field]) ? $txt[$field] : $field),
Chris@76: 'disabled' => in_array($field, $disabled_fields),
Chris@76: 'on_register' => in_array($field, $registration_fields) && !in_array($field, $fields_no_registration),
Chris@76: 'can_show_register' => !in_array($field, $fields_no_registration),
Chris@76: );
Chris@76: }
Chris@76: else
Chris@76: {
Chris@76: // Load all the fields.
Chris@76: $request = $smcFunc['db_query']('', '
Chris@76: SELECT id_field, col_name, field_name, field_desc, field_type, active, placement
Chris@76: FROM {db_prefix}custom_fields
Chris@76: ORDER BY {raw:sort}
Chris@76: LIMIT {int:start}, {int:items_per_page}',
Chris@76: array(
Chris@76: 'sort' => $sort,
Chris@76: 'start' => $start,
Chris@76: 'items_per_page' => $items_per_page,
Chris@76: )
Chris@76: );
Chris@76: while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: $list[] = $row;
Chris@76: $smcFunc['db_free_result']($request);
Chris@76: }
Chris@76:
Chris@76: return $list;
Chris@76: }
Chris@76:
Chris@76: function list_getProfileFieldSize()
Chris@76: {
Chris@76: global $smcFunc;
Chris@76:
Chris@76: $request = $smcFunc['db_query']('', '
Chris@76: SELECT COUNT(*)
Chris@76: FROM {db_prefix}custom_fields',
Chris@76: array(
Chris@76: )
Chris@76: );
Chris@76:
Chris@76: list ($numProfileFields) = $smcFunc['db_fetch_row']($request);
Chris@76: $smcFunc['db_free_result']($request);
Chris@76:
Chris@76: return $numProfileFields;
Chris@76: }
Chris@76:
Chris@76: // Edit some profile fields?
Chris@76: function EditCustomProfiles()
Chris@76: {
Chris@76: global $txt, $scripturl, $context, $settings, $sc, $smcFunc;
Chris@76:
Chris@76: // Sort out the context!
Chris@76: $context['fid'] = isset($_GET['fid']) ? (int) $_GET['fid'] : 0;
Chris@76: $context[$context['admin_menu_name']]['current_subsection'] = 'profile';
Chris@76: $context['page_title'] = $context['fid'] ? $txt['custom_edit_title'] : $txt['custom_add_title'];
Chris@76: $context['sub_template'] = 'edit_profile_field';
Chris@76:
Chris@76: // Load the profile language for section names.
Chris@76: loadLanguage('Profile');
Chris@76:
Chris@76: if ($context['fid'])
Chris@76: {
Chris@76: $request = $smcFunc['db_query']('', '
Chris@76: SELECT
Chris@76: id_field, col_name, field_name, field_desc, field_type, field_length, field_options,
Chris@76: show_reg, show_display, show_profile, private, active, default_value, can_search,
Chris@76: bbc, mask, enclose, placement
Chris@76: FROM {db_prefix}custom_fields
Chris@76: WHERE id_field = {int:current_field}',
Chris@76: array(
Chris@76: 'current_field' => $context['fid'],
Chris@76: )
Chris@76: );
Chris@76: $context['field'] = array();
Chris@76: while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: {
Chris@76: if ($row['field_type'] == 'textarea')
Chris@76: @list ($rows, $cols) = @explode(',', $row['default_value']);
Chris@76: else
Chris@76: {
Chris@76: $rows = 3;
Chris@76: $cols = 30;
Chris@76: }
Chris@76:
Chris@76: $context['field'] = array(
Chris@76: 'name' => $row['field_name'],
Chris@76: 'desc' => $row['field_desc'],
Chris@76: 'colname' => $row['col_name'],
Chris@76: 'profile_area' => $row['show_profile'],
Chris@76: 'reg' => $row['show_reg'],
Chris@76: 'display' => $row['show_display'],
Chris@76: 'type' => $row['field_type'],
Chris@76: 'max_length' => $row['field_length'],
Chris@76: 'rows' => $rows,
Chris@76: 'cols' => $cols,
Chris@76: 'bbc' => $row['bbc'] ? true : false,
Chris@76: 'default_check' => $row['field_type'] == 'check' && $row['default_value'] ? true : false,
Chris@76: 'default_select' => $row['field_type'] == 'select' || $row['field_type'] == 'radio' ? $row['default_value'] : '',
Chris@76: 'options' => strlen($row['field_options']) > 1 ? explode(',', $row['field_options']) : array('', '', ''),
Chris@76: 'active' => $row['active'],
Chris@76: 'private' => $row['private'],
Chris@76: 'can_search' => $row['can_search'],
Chris@76: 'mask' => $row['mask'],
Chris@76: 'regex' => substr($row['mask'], 0, 5) == 'regex' ? substr($row['mask'], 5) : '',
Chris@76: 'enclose' => $row['enclose'],
Chris@76: 'placement' => $row['placement'],
Chris@76: );
Chris@76: }
Chris@76: $smcFunc['db_free_result']($request);
Chris@76: }
Chris@76:
Chris@76: // Setup the default values as needed.
Chris@76: if (empty($context['field']))
Chris@76: $context['field'] = array(
Chris@76: 'name' => '',
Chris@76: 'colname' => '???',
Chris@76: 'desc' => '',
Chris@76: 'profile_area' => 'forumprofile',
Chris@76: 'reg' => false,
Chris@76: 'display' => false,
Chris@76: 'type' => 'text',
Chris@76: 'max_length' => 255,
Chris@76: 'rows' => 4,
Chris@76: 'cols' => 30,
Chris@76: 'bbc' => false,
Chris@76: 'default_check' => false,
Chris@76: 'default_select' => '',
Chris@76: 'options' => array('', '', ''),
Chris@76: 'active' => true,
Chris@76: 'private' => false,
Chris@76: 'can_search' => false,
Chris@76: 'mask' => 'nohtml',
Chris@76: 'regex' => '',
Chris@76: 'enclose' => '',
Chris@76: 'placement' => 0,
Chris@76: );
Chris@76:
Chris@76: // Are we saving?
Chris@76: if (isset($_POST['save']))
Chris@76: {
Chris@76: checkSession();
Chris@76:
Chris@76: // Everyone needs a name - even the (bracket) unknown...
Chris@76: if (trim($_POST['field_name']) == '')
Chris@76: fatal_lang_error('custom_option_need_name');
Chris@76: $_POST['field_name'] = $smcFunc['htmlspecialchars']($_POST['field_name']);
Chris@76: $_POST['field_desc'] = $smcFunc['htmlspecialchars']($_POST['field_desc']);
Chris@76:
Chris@76: // Checkboxes...
Chris@76: $show_reg = isset($_POST['reg']) ? (int) $_POST['reg'] : 0;
Chris@76: $show_display = isset($_POST['display']) ? 1 : 0;
Chris@76: $bbc = isset($_POST['bbc']) ? 1 : 0;
Chris@76: $show_profile = $_POST['profile_area'];
Chris@76: $active = isset($_POST['active']) ? 1 : 0;
Chris@76: $private = isset($_POST['private']) ? (int) $_POST['private'] : 0;
Chris@76: $can_search = isset($_POST['can_search']) ? 1 : 0;
Chris@76:
Chris@76: // Some masking stuff...
Chris@76: $mask = isset($_POST['mask']) ? $_POST['mask'] : '';
Chris@76: if ($mask == 'regex' && isset($_POST['regex']))
Chris@76: $mask .= $_POST['regex'];
Chris@76:
Chris@76: $field_length = isset($_POST['max_length']) ? (int) $_POST['max_length'] : 255;
Chris@76: $enclose = isset($_POST['enclose']) ? $_POST['enclose'] : '';
Chris@76: $placement = isset($_POST['placement']) ? (int) $_POST['placement'] : 0;
Chris@76:
Chris@76: // Select options?
Chris@76: $field_options = '';
Chris@76: $newOptions = array();
Chris@76: $default = isset($_POST['default_check']) && $_POST['field_type'] == 'check' ? 1 : '';
Chris@76: if (!empty($_POST['select_option']) && ($_POST['field_type'] == 'select' || $_POST['field_type'] == 'radio'))
Chris@76: {
Chris@76: foreach ($_POST['select_option'] as $k => $v)
Chris@76: {
Chris@76: // Clean, clean, clean...
Chris@76: $v = $smcFunc['htmlspecialchars']($v);
Chris@76: $v = strtr($v, array(',' => ''));
Chris@76:
Chris@76: // Nada, zip, etc...
Chris@76: if (trim($v) == '')
Chris@76: continue;
Chris@76:
Chris@76: // Otherwise, save it boy.
Chris@76: $field_options .= $v . ',';
Chris@76: // This is just for working out what happened with old options...
Chris@76: $newOptions[$k] = $v;
Chris@76:
Chris@76: // Is it default?
Chris@76: if (isset($_POST['default_select']) && $_POST['default_select'] == $k)
Chris@76: $default = $v;
Chris@76: }
Chris@76: $field_options = substr($field_options, 0, -1);
Chris@76: }
Chris@76:
Chris@76: // Text area has default has dimensions
Chris@76: if ($_POST['field_type'] == 'textarea')
Chris@76: $default = (int) $_POST['rows'] . ',' . (int) $_POST['cols'];
Chris@76:
Chris@76: // Come up with the unique name?
Chris@76: if (empty($context['fid']))
Chris@76: {
Chris@76: $colname = $smcFunc['substr'](strtr($_POST['field_name'], array(' ' => '')), 0, 6);
Chris@76: preg_match('~([\w\d_-]+)~', $colname, $matches);
Chris@76:
Chris@76: // If there is nothing to the name, then let's start out own - for foreign languages etc.
Chris@76: if (isset($matches[1]))
Chris@76: $colname = $initial_colname = 'cust_' . strtolower($matches[1]);
Chris@76: else
Chris@76: $colname = $initial_colname = 'cust_' . mt_rand(1, 999);
Chris@76:
Chris@76: // Make sure this is unique.
Chris@76: // !!! This may not be the most efficient way to do this.
Chris@76: $unique = false;
Chris@76: for ($i = 0; !$unique && $i < 9; $i ++)
Chris@76: {
Chris@76: $request = $smcFunc['db_query']('', '
Chris@76: SELECT id_field
Chris@76: FROM {db_prefix}custom_fields
Chris@76: WHERE col_name = {string:current_column}',
Chris@76: array(
Chris@76: 'current_column' => $colname,
Chris@76: )
Chris@76: );
Chris@76: if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: $unique = true;
Chris@76: else
Chris@76: $colname = $initial_colname . $i;
Chris@76: $smcFunc['db_free_result']($request);
Chris@76: }
Chris@76:
Chris@76: // Still not a unique colum name? Leave it up to the user, then.
Chris@76: if (!$unique)
Chris@76: fatal_lang_error('custom_option_not_unique');
Chris@76: }
Chris@76: // Work out what to do with the user data otherwise...
Chris@76: else
Chris@76: {
Chris@76: // Anything going to check or select is pointless keeping - as is anything coming from check!
Chris@76: if (($_POST['field_type'] == 'check' && $context['field']['type'] != 'check')
Chris@76: || (($_POST['field_type'] == 'select' || $_POST['field_type'] == 'radio') && $context['field']['type'] != 'select' && $context['field']['type'] != 'radio')
Chris@76: || ($context['field']['type'] == 'check' && $_POST['field_type'] != 'check'))
Chris@76: {
Chris@76: $smcFunc['db_query']('', '
Chris@76: DELETE FROM {db_prefix}themes
Chris@76: WHERE variable = {string:current_column}
Chris@76: AND id_member > {int:no_member}',
Chris@76: array(
Chris@76: 'no_member' => 0,
Chris@76: 'current_column' => $context['field']['colname'],
Chris@76: )
Chris@76: );
Chris@76: }
Chris@76: // Otherwise - if the select is edited may need to adjust!
Chris@76: elseif ($_POST['field_type'] == 'select' || $_POST['field_type'] == 'radio')
Chris@76: {
Chris@76: $optionChanges = array();
Chris@76: $takenKeys = array();
Chris@76: // Work out what's changed!
Chris@76: foreach ($context['field']['options'] as $k => $option)
Chris@76: {
Chris@76: if (trim($option) == '')
Chris@76: continue;
Chris@76:
Chris@76: // Still exists?
Chris@76: if (in_array($option, $newOptions))
Chris@76: {
Chris@76: $takenKeys[] = $k;
Chris@76: continue;
Chris@76: }
Chris@76: }
Chris@76:
Chris@76: // Finally - have we renamed it - or is it really gone?
Chris@76: foreach ($optionChanges as $k => $option)
Chris@76: {
Chris@76: // Just been renamed?
Chris@76: if (!in_array($k, $takenKeys) && !empty($newOptions[$k]))
Chris@76: $smcFunc['db_query']('', '
Chris@76: UPDATE {db_prefix}themes
Chris@76: SET value = {string:new_value}
Chris@76: WHERE variable = {string:current_column}
Chris@76: AND value = {string:old_value}
Chris@76: AND id_member > {int:no_member}',
Chris@76: array(
Chris@76: 'no_member' => 0,
Chris@76: 'new_value' => $newOptions[$k],
Chris@76: 'current_column' => $context['field']['colname'],
Chris@76: 'old_value' => $option,
Chris@76: )
Chris@76: );
Chris@76: }
Chris@76: }
Chris@76: //!!! Maybe we should adjust based on new text length limits?
Chris@76: }
Chris@76:
Chris@76: // Do the insertion/updates.
Chris@76: if ($context['fid'])
Chris@76: {
Chris@76: $smcFunc['db_query']('', '
Chris@76: UPDATE {db_prefix}custom_fields
Chris@76: SET
Chris@76: field_name = {string:field_name}, field_desc = {string:field_desc},
Chris@76: field_type = {string:field_type}, field_length = {int:field_length},
Chris@76: field_options = {string:field_options}, show_reg = {int:show_reg},
Chris@76: show_display = {int:show_display}, show_profile = {string:show_profile},
Chris@76: private = {int:private}, active = {int:active}, default_value = {string:default_value},
Chris@76: can_search = {int:can_search}, bbc = {int:bbc}, mask = {string:mask},
Chris@76: enclose = {string:enclose}, placement = {int:placement}
Chris@76: WHERE id_field = {int:current_field}',
Chris@76: array(
Chris@76: 'field_length' => $field_length,
Chris@76: 'show_reg' => $show_reg,
Chris@76: 'show_display' => $show_display,
Chris@76: 'private' => $private,
Chris@76: 'active' => $active,
Chris@76: 'can_search' => $can_search,
Chris@76: 'bbc' => $bbc,
Chris@76: 'current_field' => $context['fid'],
Chris@76: 'field_name' => $_POST['field_name'],
Chris@76: 'field_desc' => $_POST['field_desc'],
Chris@76: 'field_type' => $_POST['field_type'],
Chris@76: 'field_options' => $field_options,
Chris@76: 'show_profile' => $show_profile,
Chris@76: 'default_value' => $default,
Chris@76: 'mask' => $mask,
Chris@76: 'enclose' => $enclose,
Chris@76: 'placement' => $placement,
Chris@76: )
Chris@76: );
Chris@76:
Chris@76: // Just clean up any old selects - these are a pain!
Chris@76: if (($_POST['field_type'] == 'select' || $_POST['field_type'] == 'radio') && !empty($newOptions))
Chris@76: $smcFunc['db_query']('', '
Chris@76: DELETE FROM {db_prefix}themes
Chris@76: WHERE variable = {string:current_column}
Chris@76: AND value NOT IN ({array_string:new_option_values})
Chris@76: AND id_member > {int:no_member}',
Chris@76: array(
Chris@76: 'no_member' => 0,
Chris@76: 'new_option_values' => $newOptions,
Chris@76: 'current_column' => $context['field']['colname'],
Chris@76: )
Chris@76: );
Chris@76: }
Chris@76: else
Chris@76: {
Chris@76: $smcFunc['db_insert']('',
Chris@76: '{db_prefix}custom_fields',
Chris@76: array(
Chris@76: 'col_name' => 'string', 'field_name' => 'string', 'field_desc' => 'string',
Chris@76: 'field_type' => 'string', 'field_length' => 'string', 'field_options' => 'string',
Chris@76: 'show_reg' => 'int', 'show_display' => 'int', 'show_profile' => 'string',
Chris@76: 'private' => 'int', 'active' => 'int', 'default_value' => 'string', 'can_search' => 'int',
Chris@76: 'bbc' => 'int', 'mask' => 'string', 'enclose' => 'string', 'placement' => 'int',
Chris@76: ),
Chris@76: array(
Chris@76: $colname, $_POST['field_name'], $_POST['field_desc'],
Chris@76: $_POST['field_type'], $field_length, $field_options,
Chris@76: $show_reg, $show_display, $show_profile,
Chris@76: $private, $active, $default, $can_search,
Chris@76: $bbc, $mask, $enclose, $placement,
Chris@76: ),
Chris@76: array('id_field')
Chris@76: );
Chris@76: }
Chris@76:
Chris@76: // As there's currently no option to priorize certain fields over others, let's order them alphabetically.
Chris@76: $smcFunc['db_query']('alter_table_boards', '
Chris@76: ALTER TABLE {db_prefix}custom_fields
Chris@76: ORDER BY field_name',
Chris@76: array(
Chris@76: 'db_error_skip' => true,
Chris@76: )
Chris@76: );
Chris@76: }
Chris@76: // Deleting?
Chris@76: elseif (isset($_POST['delete']) && $context['field']['colname'])
Chris@76: {
Chris@76: checkSession();
Chris@76:
Chris@76: // Delete the user data first.
Chris@76: $smcFunc['db_query']('', '
Chris@76: DELETE FROM {db_prefix}themes
Chris@76: WHERE variable = {string:current_column}
Chris@76: AND id_member > {int:no_member}',
Chris@76: array(
Chris@76: 'no_member' => 0,
Chris@76: 'current_column' => $context['field']['colname'],
Chris@76: )
Chris@76: );
Chris@76: // Finally - the field itself is gone!
Chris@76: $smcFunc['db_query']('', '
Chris@76: DELETE FROM {db_prefix}custom_fields
Chris@76: WHERE id_field = {int:current_field}',
Chris@76: array(
Chris@76: 'current_field' => $context['fid'],
Chris@76: )
Chris@76: );
Chris@76: }
Chris@76:
Chris@76: // Rebuild display cache etc.
Chris@76: if (isset($_POST['delete']) || isset($_POST['save']))
Chris@76: {
Chris@76: checkSession();
Chris@76:
Chris@76: $request = $smcFunc['db_query']('', '
Chris@76: SELECT col_name, field_name, field_type, bbc, enclose, placement
Chris@76: FROM {db_prefix}custom_fields
Chris@76: WHERE show_display = {int:is_displayed}
Chris@76: AND active = {int:active}
Chris@76: AND private != {int:not_owner_only}
Chris@76: AND private != {int:not_admin_only}',
Chris@76: array(
Chris@76: 'is_displayed' => 1,
Chris@76: 'active' => 1,
Chris@76: 'not_owner_only' => 2,
Chris@76: 'not_admin_only' => 3,
Chris@76: )
Chris@76: );
Chris@76:
Chris@76: $fields = array();
Chris@76: while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: {
Chris@76: $fields[] = array(
Chris@76: 'colname' => strtr($row['col_name'], array('|' => '', ';' => '')),
Chris@76: 'title' => strtr($row['field_name'], array('|' => '', ';' => '')),
Chris@76: 'type' => $row['field_type'],
Chris@76: 'bbc' => $row['bbc'] ? '1' : '0',
Chris@76: 'placement' => !empty($row['placement']) ? $row['placement'] : '0',
Chris@76: 'enclose' => !empty($row['enclose']) ? $row['enclose'] : '',
Chris@76: );
Chris@76: }
Chris@76: $smcFunc['db_free_result']($request);
Chris@76:
Chris@76: updateSettings(array('displayFields' => serialize($fields)));
Chris@76: redirectexit('action=admin;area=featuresettings;sa=profile');
Chris@76: }
Chris@76: }
Chris@76:
Chris@76: function ModifyPruningSettings($return_config = false)
Chris@76: {
Chris@76: global $txt, $scripturl, $sourcedir, $context, $settings, $sc, $modSettings;
Chris@76:
Chris@76: // Make sure we understand what's going on.
Chris@76: loadLanguage('ManageSettings');
Chris@76:
Chris@76: $context['page_title'] = $txt['pruning_title'];
Chris@76:
Chris@76: $config_vars = array(
Chris@76: // Even do the pruning?
Chris@76: // The array indexes are there so we can remove/change them before saving.
Chris@76: 'pruningOptions' => array('check', 'pruningOptions'),
Chris@76: '',
Chris@76: // Various logs that could be pruned.
Chris@76: array('int', 'pruneErrorLog', 'postinput' => $txt['days_word']), // Error log.
Chris@76: array('int', 'pruneModLog', 'postinput' => $txt['days_word']), // Moderation log.
Chris@76: array('int', 'pruneBanLog', 'postinput' => $txt['days_word']), // Ban hit log.
Chris@76: array('int', 'pruneReportLog', 'postinput' => $txt['days_word']), // Report to moderator log.
Chris@76: array('int', 'pruneScheduledTaskLog', 'postinput' => $txt['days_word']), // Log of the scheduled tasks and how long they ran.
Chris@76: array('int', 'pruneSpiderHitLog', 'postinput' => $txt['days_word']), // Log of the scheduled tasks and how long they ran.
Chris@76: // If you add any additional logs make sure to add them after this point. Additionally, make sure you add them to the weekly scheduled task.
Chris@76: // Mod Developers: Do NOT use the pruningOptions master variable for this as SMF Core may overwrite your setting in the future!
Chris@76: );
Chris@76:
Chris@76: if ($return_config)
Chris@76: return $config_vars;
Chris@76:
Chris@76: // We'll need this in a bit.
Chris@76: require_once($sourcedir . '/ManageServer.php');
Chris@76:
Chris@76: // Saving?
Chris@76: if (isset($_GET['save']))
Chris@76: {
Chris@76: checkSession();
Chris@76:
Chris@76: $savevar = array(
Chris@76: array('text', 'pruningOptions')
Chris@76: );
Chris@76:
Chris@76: if (!empty($_POST['pruningOptions']))
Chris@76: {
Chris@76: $vals = array();
Chris@76: foreach ($config_vars as $index => $dummy)
Chris@76: {
Chris@76: if (!is_array($dummy) || $index == 'pruningOptions')
Chris@76: continue;
Chris@76:
Chris@76: $vals[] = empty($_POST[$dummy[1]]) || $_POST[$dummy[1]] < 0 ? 0 : (int) $_POST[$dummy[1]];
Chris@76: }
Chris@76: $_POST['pruningOptions'] = implode(',', $vals);
Chris@76: }
Chris@76: else
Chris@76: $_POST['pruningOptions'] = '';
Chris@76:
Chris@76: saveDBSettings($savevar);
Chris@76: redirectexit('action=admin;area=logs;sa=pruning');
Chris@76: }
Chris@76:
Chris@76: $context['post_url'] = $scripturl . '?action=admin;area=logs;save;sa=pruning';
Chris@76: $context['settings_title'] = $txt['pruning_title'];
Chris@76: $context['sub_template'] = 'show_settings';
Chris@76:
Chris@76: // Get the actual values
Chris@76: if (!empty($modSettings['pruningOptions']))
Chris@76: @list ($modSettings['pruneErrorLog'], $modSettings['pruneModLog'], $modSettings['pruneBanLog'], $modSettings['pruneReportLog'], $modSettings['pruneScheduledTaskLog'], $modSettings['pruneSpiderHitLog']) = explode(',', $modSettings['pruningOptions']);
Chris@76: else
Chris@76: $modSettings['pruneErrorLog'] = $modSettings['pruneModLog'] = $modSettings['pruneBanLog'] = $modSettings['pruneReportLog'] = $modSettings['pruneScheduledTaskLog'] = $modSettings['pruneSpiderHitLog'] = 0;
Chris@76:
Chris@76: prepareDBSettingContext($config_vars);
Chris@76: }
Chris@76:
Chris@76: // If you have a general mod setting to add stick it here.
Chris@76: function ModifyGeneralModSettings($return_config = false)
Chris@76: {
Chris@76: global $txt, $scripturl, $context, $settings, $sc, $modSettings;
Chris@76:
Chris@76: $config_vars = array(
Chris@76: // Mod authors, add any settings UNDER this line. Include a comma at the end of the line and don't remove this statement!!
Chris@76: );
Chris@76:
Chris@76: // Make it even easier to add new settings.
Chris@76: call_integration_hook('integrate_general_mod_settings', array(&$config_vars));
Chris@76:
Chris@76: if ($return_config)
Chris@76: return $config_vars;
Chris@76:
Chris@76: $context['post_url'] = $scripturl . '?action=admin;area=modsettings;save;sa=general';
Chris@76: $context['settings_title'] = $txt['mods_cat_modifications_misc'];
Chris@76:
Chris@76: // No removing this line you, dirty unwashed mod authors. :p
Chris@76: if (empty($config_vars))
Chris@76: {
Chris@76: $context['settings_save_dont_show'] = true;
Chris@76: $context['settings_message'] = '
' . $txt['modification_no_misc_settings'] . '
';
Chris@76:
Chris@76: return prepareDBSettingContext($config_vars);
Chris@76: }
Chris@76:
Chris@76: // Saving?
Chris@76: if (isset($_GET['save']))
Chris@76: {
Chris@76: checkSession();
Chris@76:
Chris@76: $save_vars = $config_vars;
Chris@76:
Chris@76: // This line is to help mod authors do a search/add after if you want to add something here. Keyword: FOOT TAPPING SUCKS!
Chris@76: saveDBSettings($save_vars);
Chris@76:
Chris@76: // This line is to help mod authors do a search/add after if you want to add something here. Keyword: I LOVE TEA!
Chris@76: redirectexit('action=admin;area=modsettings;sa=general');
Chris@76: }
Chris@76:
Chris@76: // This line is to help mod authors do a search/add after if you want to add something here. Keyword: RED INK IS FOR TEACHERS AND THOSE WHO LIKE PAIN!
Chris@76: prepareDBSettingContext($config_vars);
Chris@76: }
Chris@76:
Chris@76: ?>