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

Edit birthday?

Discussion in 'XenForo Questions and Support' started by steven s, Dec 5, 2011.

  1. steven s

    steven s Well-Known Member

    Is there a setting to allow members to edit their birthday?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. steven s

    steven s Well-Known Member

    That kinda sucks.
    I was hoping I had missed a checkbox in the admin section.
    I imported users from vB that I'm finding have incorrect birthdays.
    I'll admit GI=GO but now I have members looking to update them correctly without me being involved.
     
  4. Can this please be reconsidered? I have 3,000 users who all have incorrect birthdays as a result of a forum conversion. Can't fathom why this isn't an option in the ACP.
     
  5. Digital Doctor

    Digital Doctor Well-Known Member

    Was there a systematic birthday date problem ?
    I remember someone thought the Xenforo Birthday date was weird.
    hmmmmm.
     
  6. steven s

    steven s Well-Known Member

    If you want to have your members reset them all, then you need a query to set the birthdate to 0/0/0.
    I used an update because I had many users with the same birthdate that someone coded in their by default.
     
  7. not that familiar with queries. could someone help me out with this?
     
  8. steven s

    steven s Well-Known Member

    Did you want to reset all of them?

    Add: If you want to reset all birthdates so members can set themselves.
    BACKUP YOUR DATABASE FIRST!
    Code:
    UPDATE xf_user_profile
    SET dob_day=0, dob_month=0, dob_year=0
    Did I mention, BACKUP YOUR DATABASE FIRST?
     
  9. if we reset them, will that allow them to at least go back in and set them?
     
  10. steven s

    steven s Well-Known Member

    Yes, although you may way someone else to verify that.
    It worked for me but I'd feel terrible if I wrecked your forum.
     
    steel_curtain likes this.
  11. steel_curtain

    steel_curtain Well-Known Member

    I just tested on my dev site and it worked fine.

    If you want to test yourself create a new user to test on, and then update for only that user_id.

    Code:
    UPDATE xf_user_profile
    SET dob_day=0, dob_month=0, dob_year=0
    WHERE user_id = X
    Change X to the user_id of the newly created member and execute. Then log in as that member and go into personal details and update birthday.
     
    StarArmy and steven s like this.
  12. steven s

    steven s Well-Known Member

    Worked on my test site too. I just don't trust myself giving advice that can self destruct. :)
    Thanks for verifying.

    Good idea. Or he can just use his own member number.
     
  13. So the X simply gets replaced by a number, correct? what would the query look like if I wanted to do it to everyone?
     
  14. steel_curtain

    steel_curtain Well-Known Member

    Correct it gets replaced by the user_id from the xf_user_profile table you want to update. If you run the original query by steven s without the WHERE clause I added it'll update all user_id's in the table.
     
  15. dethfire

    dethfire Well-Known Member

    bumping this. I have many users who make a mistake on registration
     
  16. Amaury

    Amaury Well-Known Member

    They can easily send an admin a message to fix it. Other than that, though, people's birthdays do not change.
     
  17. dethfire

    dethfire Well-Known Member

    Why punish the admin for the user's mistakes. I got better things to do :)
     
    mikie likes this.
  18. Amaury

    Amaury Well-Known Member

    The staff is there to help out users. If they can't do that, then they shouldn't be staff.
     
  19. dethfire

    dethfire Well-Known Member

    Of course, but in this case when you have 150k users you'll think different ;)
     
    mikie likes this.
  20. JanHoos

    JanHoos Member

    Worked for me as well! Had mybb forum imported and somehow, everyone got a weird birthday. I reset everything and now people can fill them in themselves :)
     

Share This Page