I like to make a list of most resent loggedin members.
Is there a way to do this?
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
January 10, 2010 10:59am
Subscribe [2]#1 / Jan 10, 2010 10:59am
I like to make a list of most resent loggedin members.
Is there a way to do this?
#2 / Jan 10, 2010 12:15pm
I don’t know if anyone has built a plug-in or module to handle this; however, there is a field in the exp_members table called last_visit. You could use the query module to extract the information. Something like:
{exp:query sql="SELECT screen_name, last_visit FROM exp_members ORDER BY last_visit DESC LIMIT 10"}
//encase tags in appropriate html
{screen_name}
{last_visit format="%Y %m %d"}
{/exp:query}#3 / Jan 10, 2010 12:58pm
@Herb
Thanks! Your solution works perfect for me.
I searched for an add-on to do this but i found nothing.