Get value of custom profile field in profile

[mabley]

I'd like my users to be able to choose from a list of colors to accent their profiles, so I made a custom profile field.

In Profile.template.php how do I get the value of that custom profile field? I was thinking of using it as a CSS class or html data-attribute on the profile's wrapping div.

[Kindred]

You would have to query the database

[GL700Wing]

I'd like my users to be able to choose from a list of colors to accent their profiles, so I made a custom profile field.

In Profile.template.php how do I get the value of that custom profile field? I was thinking of using it as a CSS class or html data-attribute on the profile's wrapping div.

Custom field definitions/values are stored in the {db_prefix}custom_fields table and if a member has saved a custom field it's name and value are stored in the {db_prefix}themes table.

Use the following query to get the value of the custom field named 'color' for an individual member (assumes member ID is available as $context['id_member']):
(Note: $profileColor will be empty/blank if the member has not saved the 'color' custom profile field)

Code Select Expand

$request = $smcFunc['db_query']('', '
SELECT value FROM {db_prefix}themes
WHERE id_theme = 1 AND id_member = {int:id_member} AND variable = {string:variable}',
array(
'id_member' => $context['id_member'],
'variable' => 'cust_color',
)
);
$profileColor = $smcFunc['db_fetch_assoc']($request);
$smcFunc['db_free_result']($request);

The following is an example of a query to get the member ID and custom field value of all the members who have saved the custom field named 'color'.

Code Select Expand

$request = $smcFunc['db_query']('', '
SELECT id_member, value FROM {db_prefix}themes
WHERE id_theme = 1 AND variable = {string:variable} ',
array(
'variable' => 'cust_color',
)
);
$allMembers_profileColors = $smcFunc['db_fetch_assoc']($request);
$smcFunc['db_free_result']($request);


[mabley]

Thank you for your help.

I added $smcFunc to the global variables for function template_summary() in Profile.template.php.

I added $profileColor down below in the HTML like ' . $profileColor . '

This prints just the word Array in the HTML.

How do I get the value to show up? The field is a select/dropdown if that matters.

EDIT: Figured it out. I did ' . $profileColor['value'] . '