Memberlist shows last login dat/time.
Post new topic   Reply to topic   Printer Friendly Page     Forum IndexAdd-Ons & Blocks

Do you think last login would help you monitor your site's traffic?
Yes
80%
 80%  [ 17 ]
No
19%
 19%  [ 4 ]
Total Votes : 21

Author Message
mpyusko
Newbie


Joined: Mar 09, 2007
Posts: 35
Location: USA

PostPost subject: Memberlist shows last login dat/time.
Posted: Tue Oct 23, 2007 7:25 pm
Reply with quote

It would be nice if the Member List could show the last login date/time for each user. At least in Admin mode if there are privacy concerns. This would help to better monitor site user activity. ie, How many users visit per day. The information is already logged in the database.

An alternative would be to have a block or module to pull the last login date/times and list then next to username and joined date. It would be accessible only from the Admin mode.

_________________
-mpyusko

mpyusko's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
Eestlane
I18N / L10N Lead Dev


Joined: Apr 06, 2005
Posts: 1406
Location: Estonia

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Tue Oct 23, 2007 8:00 pm
Reply with quote

Yeah, I wanted to add it someday to member profile and members_list but had it forgotten. Could be in core in my opinion aswell.

Eestlane's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.0.63/5.0.67/5.2.8/9.2.1
Back to top
View user's profile Send e-mail Visit poster's website
rlgura
1000+ Posts Club


Joined: Mar 27, 2006
Posts: 1148
Location: Cleveland, OH USA

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Tue Oct 23, 2007 9:19 pm
Reply with quote

I've made a couple blocks that show who logged in today (and who's currently on)
dragonfly.wsgdesigns.c...ails&id=57

Also, there's a "Last Seen" block that lists the last x members and how long it's been since they've logged in.
www.cmsall.com/Downloa...d=204.html

_________________
Admin - Great Lakes Web Designs
Theme Designer - WebSite Guru Designs
Site Admin - Families with Food Allergies

rlgura's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.27-grsec/Apache 2.2.11/MySQL 5.0.67-community-log/PHP 5.2.8/DF 9.2.1
Back to top
View user's profile Visit poster's website
sultan
Nice poster


Joined: Nov 01, 2005
Posts: 68

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Wed Oct 24, 2007 1:06 am
Reply with quote

I have implemented this at my site memberlist and it does come in handy. Sort feature is also available just like any other area of the Dragonfly memberlist.

Here is what it looks like.


sultan's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
[CentOS release 4.6 (Final)] | [Apache 1.3.37] | [MySQL 4.1.21-standard-log (client: 4.1.21) | [PHP 4.4.7] | [DF 9.2.1] | [FPro 2.0.2]
Back to top
View user's profile Visit poster's website
Gallowglas
Nice poster


Joined: Nov 13, 2004
Posts: 89
Location: Germany

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Wed Oct 24, 2007 4:15 am
Reply with quote

mpyusko wrote:
It would be nice if the Member List could show the last login date/time for each user. At least in Admin mode if there are privacy concerns. This would help to better monitor site user activity. ie, How many users visit per day. The information is already logged in the database.

An alternative would be to have a block or module to pull the last login date/times and list then next to username and joined date. It would be accessible only from the Admin mode.

I did something like that, you can download it from the german DF-site : www.cpgnuke.de/Downloa...id=98.html
It's for 9.0.6.1 and german only. it's a beta ... I haven't had the time to do an english lang-file, or a version for 9.1.x, but I promise to complete it (my personal Beta (@green-dragon.de) also has a username-search option and some more ... )

_________________
>>> German Dragonfly - Team

Gallowglas's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.37/4.0.25-5.0.18/4.4.7-5.2.1/9.0.6.1-9.1.2.5
Back to top
View user's profile Visit poster's website
rlgura
1000+ Posts Club


Joined: Mar 27, 2006
Posts: 1148
Location: Cleveland, OH USA

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Wed Oct 24, 2007 11:10 pm
Reply with quote

username search - an obvious oversight! Smile
I usually resort to searching the forums for a post by someone to look up their profile!
I like the sort by last visit option in Sultan's too!

_________________
Admin - Great Lakes Web Designs
Theme Designer - WebSite Guru Designs
Site Admin - Families with Food Allergies

rlgura's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.27-grsec/Apache 2.2.11/MySQL 5.0.67-community-log/PHP 5.2.8/DF 9.2.1
Back to top
View user's profile Visit poster's website
mpyusko
Newbie


Joined: Mar 09, 2007
Posts: 35
Location: USA

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Thu Oct 25, 2007 12:39 pm
Reply with quote

sultan wrote:
I have implemented this at my site memberlist and it does come in handy. Sort feature is also available just like any other area of the Dragonfly memberlist.

Here is what it looks like.

So where can I get your code? Maybe you could submit it to be included in the next DF release.

_________________
-mpyusko

mpyusko's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
sultan
Nice poster


Joined: Nov 01, 2005
Posts: 68

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Fri Oct 26, 2007 11:47 pm
Reply with quote

mpyusko wrote:
sultan wrote:
I have implemented this at my site memberlist and it does come in handy. Sort feature is also available just like any other area of the Dragonfly memberlist.

Here is what it looks like.

So where can I get your code? Maybe you could submit it to be included in the next DF release.
Let me see what I can do.
Implemented it a few months ago and need to recoupe how in the heck I even did it. Shocked
Was simpiler than I imagined, except for those who registered and haven't been back to the site.


sultan's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
[CentOS release 4.6 (Final)] | [Apache 1.3.37] | [MySQL 4.1.21-standard-log (client: 4.1.21) | [PHP 4.4.7] | [DF 9.2.1] | [FPro 2.0.2]
Back to top
View user's profile Visit poster's website
pappadee
Newbie


Joined: Nov 24, 2004
Posts: 6
Location: London

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Fri Nov 23, 2007 12:18 am
Reply with quote

i would also be very keen to add your code sultan m8, please. As a gaming guild I need to see who is and who isnt viewing the web site for updated news and important info re the guild.

Your example is exactly what I would like to be able to implement.

Any further updates please sultan?


pappadee's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.9-42.0.10.ELsmp/1.3.37/4.1.20-standard/4.4.3/9.1.2.1
Back to top
View user's profile Visit poster's website
Jeruvy
Security Team


Joined: Apr 23, 2004
Posts: 1433
Location: Canada

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Fri Nov 23, 2007 3:06 am
Reply with quote

Well I prefer using accurate user behaviour to analyze the apache logs directly. This allows me to quickly determine bot-like behaviour vs. Real people.

I'm writing an article about this which will probably be very technical, and not as simple as this solution but for me this solution doesn't tell me much.

However little be it for me to tell you this is a bad idea since it's really not. But I prefer more detail and I'm more interested in bots than users. Very Happy

My loonies worth of opinion. Seems to be worth quite a bit these days Wink

_________________
J.
j e r u v y a t y a h o o d o t c o m

Need help? Look here: www.dragonflycms.org/W...d=112.html
Need to chat? Look for me on irc.freenode.net

Jeruvy's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Ubuntu7.10/Debian3.1 - 2.2.3/1.3.37 - 5.0.38/4.0.27 - 5.2.1/4.4.7 - CVS/9.1.2}
Back to top
View user's profile ICQ Number Yahoo Messenger
webhax
Newbie


Joined: May 13, 2006
Posts: 26

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Fri Nov 23, 2007 2:32 pm
Reply with quote

Well that is quite simple to do actually.

I have attached a small package which has all the edits placed properly.

Note: Rename the yourtheme folder with the folder name of your theme.

_________________
{ Oversize Sig }

webhax's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.33/5.0.45/5.1.4/9.1.2.1
Back to top
View user's profile Visit poster's website
mpyusko
Newbie


Joined: Mar 09, 2007
Posts: 35
Location: USA

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Sun Nov 25, 2007 3:37 pm
Reply with quote

Jeruvy wrote:
...I'm writing an article about this which will probably be very technical, and not as simple as this solution but for me this solution doesn't tell me much.

However little be it for me to tell you this is a bad idea since it's really not. ....

I don't run a site with hundred or thousands of members. My daily visitors only average one page. I'm also only concerned what members do as they are the ones I cater too. Visitors are nice...

One site I run is only for family communication. Another is for a local Rocket Club. (for those of you who think it's a hobby for nerds, you should feel the ground shake when a 160lb rocket lifts off) To this end, all the users are physically known, so I can tell who's a bot and who's not just with a quick glance at the memberlist. A "Last Visited" tells me a lot for what I need to know. I can then take that date and time and apply it to the Apache logs and see Who did what when. (Like when my mother complains she hasn't seen any new pictures of the baby and I look and see she hasn't logged in for over 3 months.)

_________________
-mpyusko

mpyusko's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
mpyusko
Newbie


Joined: Mar 09, 2007
Posts: 35
Location: USA

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Sun Nov 25, 2007 4:10 pm
Reply with quote

webhax wrote:
Well that is quite simple to do actually.

I have attached a small package which has all the edits placed properly.

Note: Rename the yourtheme folder with the folder name of your theme.

Works Great! This is perfect. Thank you. Maybe this could be included in the next release?

_________________
-mpyusko

mpyusko's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
mpyusko
Newbie


Joined: Mar 09, 2007
Posts: 35
Location: USA

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Wed Jan 23, 2008 6:05 pm
Reply with quote

so I had this working great in 9.1.x but when I upgraded to 9.2.0 RC2, it overwrote the memberlist. The memberlist has code changes since the previous release, so now what? Confused is there anyway someone could do a "find line xxxx, then paste xxxx below it" kind of thing? I would much appreciate it.

Another question.... The login date/times are stored in the database in numerical form.... what conversion do I do to come up with a human readable format?

_________________
-mpyusko

mpyusko's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
Phoenix
Site Admin


Joined: Apr 19, 2004
Posts: 8729
Location: Netizen

PostPost subject: Re: Memberlist shows last login dat/time.
Posted: Wed Jan 23, 2008 11:50 pm
Reply with quote

For dates, they are stored as unixtime which is why you see integers.

Conversion is by using something like this,

formatDateTime($row['date'], _DATESTRING)
(_DATESTRING is one of the choices in your language main.php file)


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   Printer Friendly Page     Forum IndexAdd-Ons & Blocks All times are GMT
Page 1 of 1


Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

stopsoftwarepatents.eu petition banner
User Info [x]

Welcome Anonymous

Nickname
Password
(Register)

Last CVS commits [x]

Languages [x]

Community [x]

Support for DragonflyCMS in a other languages:

Deutsch
Español

X-links [x]
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

Preview theme [x]
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.


You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
This page generated in 0.6068 seconds with 21 DB Queries in 0.2291 seconds
Memory Usage: 3.04 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy