I have over 100 custom field options that are not listed alphabetically. I'd like to list them alphabetically, from a-z, so users can select the proper field more easily (without thinking it's not an option). When I entered them I assumed it'd be alphabetical but it's not.
Is there anything I can do aside from re-entering them manually, which would be time-consuming? Perhaps a database query?
You can run these queries to set all display orders on custom fields according to the alphabetical orders of the field_ids:
CREATE TABLE xf_user_field_order (
`order` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
field_id VARCHAR(25) NOT NULL
INSERT INTO xf_user_field_order (field_id)
FROM xf_user_field AS uf
ORDER BY uf.field_id
UPDATE xf_user_field AS uf, xf_user_field_order AS ufo
SET uf.display_order = ufo.order
WHERE uf.field_id = ufo.field_id;
DROP TABLE xf_user_field_order;