1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 Costum Fields

Discussion in 'XenForo Questions and Support' started by XiOn, Oct 23, 2011.

  1. XiOn

    XiOn Member

    I just bought my license and I want to know if xenforo with custom fields afterwhat I think I can go to phpmyadmin and I can draw on the information tables in this way username, custum field with the option the user selects all in the same table? is it possible?

    Because im interested in download the table with de username and answer of the custum field

  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query on your database:

    SELECT u.username, ufv.field_value
    FROM xf_user_field_value AS ufv
    LEFT JOIN xf_user AS u ON (u.user_id = ufv.user_id)
    WHERE ufv.field_id = 'my_identifier';
    You need to specify the field_id of the custom field you want to select. You will get results like this:

    Screen shot 2011-10-23 at 3.26.02 PM.png

    If you want to save the results then click Export at the bottom of the page in phpmyadmin after you run the query.

    Note that some users might not show up in this list if they have never edited their profile.
    Sekonda likes this.
  3. XiOn

    XiOn Member

    I do not understand yet, no other example I can give more simple? I'd appreciate knowing that I urge
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Screen shot 2011-10-28 at 3.56.57 PM.png

    Screen shot 2011-10-28 at 3.46.52 PM2.png

    Screen shot 2011-10-28 at 4.01.46 PM.png
    gordy likes this.
  5. XiOn

    XiOn Member

    Perfect thank you and if he wanted to leave out an additional example thatinstead of the value of a custom field to leave two custom fields instead of twoas I do?
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Sorry I don't understand the question.
  7. EasyTarget

    EasyTarget Well-Known Member

    My guess is that XiOn is looking to do a cross-tab query
    userid, field_value1, field_value2 in one row. Sadly MySql still doesn't have a built in function to do this.

Share This Page