• 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

Morgain

Well-known member
#1
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?
 

Jake Bunce

XenForo moderator
Staff member
#2
Use this query to select all users who registered between the two specified dates:

Code:
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')