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

One year anniversary for members

Discussion in 'XenForo Questions and Support' started by Morgain, Nov 8, 2012.

  1. Morgain

    Morgain Well-Known Member

    HM is both an offline and online community. At present we're creatinjg three types of members.
    A small group of Elders I can handle manually as it's very small.
    Newcomer members of a year or less, and the "middles"
    Each to have its own title.

    I don't see how to make the user title change to reflect that change around the one year membership completion. I thought Upgrades did that kind of thing but on closer inspection they don't.
    Nor can I manually search on members on length of membership which seems strange.

    What I'd really like is a notification that someone is completing their 1st year in the coming month. Then I could review them manually and decide if they have been active enough to upgrade them.

    Any ideas on doing searches or getting notifications on this important anniversary?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Use this query to select all users who registered between the two specified dates:

    SELECT user_id, username
    FROM xf_user
    WHERE register_date BETWEEN UNIX_TIMESTAMP('2011-11-06 00:00:00') AND UNIX_TIMESTAMP('2011-12-06 00:00:00')
    Morgain likes this.

Share This Page