I have the same field in my own tables outside of XenForo keeping track of this particular setting for the users. I've just added in the function for them to change this option in the main site and I am having issues manually updating the value in the xf_user_field_value table. This is my SQL
INSERT IGNORE INTO xf_user_field_value (user_id, field_id, field_value) SELECT xf_id, 'necromunda_ruleset', ruleset FROM necro_profile WHERE id = 1 ON DUPLICATE KEY UPDATE field_value = 3
Am I missing something obvious?