Adding Custom Fields into User Table

[Feanux]

Hi,

I would like any custom profile titles I create to be added to the user table, as it's own category. What is the easiest way I could possibly achieve this?

For example, already in the user table we have columns last_activity, trophy_points, etc. If I created a custom profile field called "Favorite Color", how would I be able to add that as it's own column in the user table, so I can easily sort members/fetch the information?

Thanks!

Ryan

 

[Paul B]

Custom user fields and the values are already automatically added to the database: xf_user_field and xf_user_field_value.

 

[Feanux]

I am using the Sort Member resource: http://xenforo.com/community/resources/raid101-com-member-list-manager.1421/

The way that is setup is that you can create search critiers based on the format: table.column (however you can only grab from user and userprofile).

Instead of reworking database stuff, is there a way I can search members based on keywords in their ABOUT section, or search based on custom fields?

Thanks!

Ryan

 

[Paul B]

Searching member profile content isn't possible.

 

[Feanux]

Is there a way I can break down how the custom_fields are stored in the database?

Instead of having all custom fields in one column, can I change where a new field is stored? For example, if i create the column favcolor on the user_profile table, where can I go to change where that custom field is stored so it goes to favcolor column!

 

[Paul B]

Have a look in \library\XenForo\DataWriter\UserField.php

 

[Jeremy]

If you want to store information in a separate column you will need to write a custom add-on and manage storage of the information yourself. The custom fields are stored as a serialized array (or object, but I'm pretty sure its an array).