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

XF 1.5 Search users by birth date?

Discussion in 'XenForo Questions and Support' started by empire, Aug 30, 2015.

  1. empire

    empire Well-Known Member

    One of our admins noticed that there's no field for birth date on the admin panel 'Search for Users' page. Is there a way to add that?

    Or might I have hidden it by accident? It seems like every other field is there but that one.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    It would require custom development.
     
  3. empire

    empire Well-Known Member

    Is there a reason it's not included (that would make custom development difficult) or is it just a random exclusion?
     
  4. Mike

    Mike XenForo Developer Staff Member

    I don't think I've seen a request for searching by birth date before. It's not particularly clear how exactly it would work (especially with optional birth years).
     
  5. empire

    empire Well-Known Member

    Birthdate is required to register, so it would work the same as the other search fields.

    It's helpful for finding duplicate accounts.
     
    Vilandra likes this.
  6. Bumping for relevance. We have a rather large community and being able to search for members by birth date criteria would be immensely useful in recognizing Birthdays in our monthly newsletter. Any word on a development?

    Thanks!
     
    Mouth likes this.
  7. empire

    empire Well-Known Member

    We had @Yoskaldyr add this very inexpensively – you could contact him about it.
     
  8. Mouth

    Mouth Well-Known Member

    In case anyone else might be looking, here's the SQL;
    Code:
    select * from xf_user_profile where dob_month = 12 and dob_day = 01;
    
    or
    Code:
    select username, dob_day from xf_user 
      inner join xf_user_profile on xf_user_profile.user_id = xf_user.user_id 
      inner join xf_user_option on xf_user_option.user_id = xf_user.user_id 
    where dob_month = 10 and is_banned = 0 and user_state = 'valid' and show_dob_year = 1 
    order by dob_day asc;
    
     
    Last edited: Oct 2, 2016

Share This Page