XF 2.2 How to search for oldest members?

[Punt Road End]

Hi,

I've installed Simple Stats and doesn't really do what I want. I am searching for a way to find the oldest member on our forum.

Any help would be great!

PRE.

 

[Paul B]

You will need to post in the resource thread for assistance with it.

 

[Punt Road End]

Tha

You will need to post in the resource thread for assistance with it.

Thanks, please delete it from here.

 

[Punt Road End]

You will need to post in the resource thread for assistance with it.

I’m not sure where you want me to post after locking my post in resources.

 

[whynot]

I’m not sure where you want me to post after locking my post in resources.

[OzzModz] Simple Stats [Paid]

Painbaker submitted a new resource: [PB] Simple Stats - Grab common statistics by date range A collection of useful common statistics by date range. Features: ACP page that displays table of common statistics for certain content and actions (View statistic ACP permission required) Date range...

xenforo.com

 

[Paul B]

I’m not sure where you want me to post after locking my post in resources.

I linked to the thread which explains what you need to do.

 

[Jake B.]

I don't think they're looking for support for that add-on, I think they're saying that add-on doesn't do what they're looking for and are looking for a recommendation on how to find what they are looking for?

 

[briansol]

oldest, meaning age?
or oldest meaning, joined your forum first?

age, only possible if you required birthday. And spammers tend to bloat it out with 100 year olds, so you'll need to de-dupe those folks out (perhaps with post count > 10 ?)
something like:

SELECT user_id, dob_month, dob_day, dob_year FROM `xf_user_profile` where dob_year > 0 order by dob_year asc, dob_month asc, dob_day ASC

could get you started

oldest member, well, you're probably member 1, find member id 2.