Statistics: Active Users in Past 30 Days?

[nogerorob]

Is there a way to list the number of active users in the past 30 days, i.e. they logged in at least once? I need this information to begin a fundraising campaign.

rob

Thanks

[Lats]

Try this query...

SELECT 
    username
FROM 
    user
WHERE 
    lastactivity > unix_timestamp(now()) - 2592000

[Lats]

After re-reading this thread...
http://www.vbulletin.com/forum/showt...light=activity

If may be better to use lastvisit instead...

SELECT 
    username
FROM 
    user
WHERE 
    lastvisit > unix_timestamp(now()) - 2592000

[nogerorob]

Right on. Thanks.

Is there any way to have it spit out an actual number, instead of a list?

i'm not versed in structuring mysql commands.

rob

[Lats]

Ah, I saw the word 'list' ...

SELECT 
    COUNT(username)
FROM 
    user
WHERE 
    lastvisit > unix_timestamp(now()) - 2592000

[nogerorob]

Rightly so. Thanks for both answers. Much appreciated.

How is 2592000 calculated, say i wanted to do jan1 to feb 1 06?

Rob

[Lats]

2592000 is the number of seconds in 30 days: 60 * 60 * 24 * 30 = 2592000. Change the 30 to however many days ago you need.

To get a range, try this...

SELECT 
    COUNT(username)
FROM 
    user
WHERE 
    lastvisit > unix_timestamp(now()) - 5184000
AND
    lastvisit < unix_timestamp(now()) - 2592000