Show style in profile

[kenny]

Following on from this topic and from a request here, this snippet shows the style a user is currently using on their profile page.

OPEN: memberlist.php
FIND:

Code: Select all

        $template->assign_vars(array(
            'L_POSTS_IN_QUEUE'    => $user->lang('NUM_POSTS_IN_QUEUE', $member['posts_in_queue']), 

BEFORE ADD:

Code: Select all

        // Grab the users style
        $user_style_id = $member['user_style'];
        $style_sql = 'SELECT style_name
            FROM ' . STYLES_TABLE . "
            WHERE style_id = $user_style_id";
        $style_result = $db->sql_query($style_sql);
        while ($style_row = $db->sql_fetchrow($style_result))
        {
            $user_style = $style_row['style_name'];
        }
        $db->sql_freeresult($style_result);   

FIND:

Code: Select all

            'SEARCH_IMG'        => $user->img('icon_user_search', $user->lang['SEARCH']), 

AFTER ADD:

Code: Select all

            'USER_STYLE'            => $user_style, 

OPEN: language/en/memberlist.php
FIND:

Code: Select all

    'SORT_POST_COUNT'        => 'Post count', 

AFTER ADD:

Code: Select all

    'STYLE'        => 'Style', 

OPEN: styles/YOUR_STYLE/templates/memberlist_view.html
FIND:

Code: Select all

      <!-- IF S_GROUP_OPTIONS --><dt>{L_USERGROUPS}:</dt> <dd><select name="g">{S_GROUP_OPTIONS}</select> <input type="submit" name="submit" value="{L_GO}" class="button2" /></dd><!-- ENDIF -->

AFTER ADD:

Code: Select all

      <!-- IF USER_STYLE --><dt>{L_STYLE}:</dt> <dd>{USER_STYLE}</dd><!-- ENDIF -->

[Anyasha]

Code: Select all

'USER_STYLE'            => $user_style

needs to be

Code: Select all

'USER_STYLE'            => $user_style,

[kenny]

Ah, thanks for spotting that. Now updated

[noth]

Joined: 12 May 2010 07:00 pm
Member No: 6093
Template: 5
Last visited: 17 Jun 2010 04:34 pm
Warnings: 0
[ View user notes | Warn user ]
Total posts: 31
[0.05% of all posts / 0.84 posts per day]
Search user’s posts
Most active forum: Applications

oooeeerrr I am getting a NUMBER not a style name

what have I done wrong?

[kenny]

That shouldn't happen. The code specifically picks out the style_name from the database