|
View previous topic :: View next topic |
|
| Author |
Message |
mpyusko Newbie


Offline Joined: Mar 09, 2007 Posts: 34 Location: USA
|
Posted: Tue Oct 23, 2007 7:25 pm Post subject: Memberlist shows last login dat/time. |
|
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 |
|
 |
Eestlane I18N / L10N Lead Dev


Offline Joined: Apr 06, 2005 Posts: 1404 Location: Estonia
|
Posted: Tue Oct 23, 2007 8:00 pm Post subject: Re: Memberlist shows last login dat/time. |
|
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 |
|
 |
rlgura 1000+ Posts Club


Offline Joined: Mar 27, 2006 Posts: 1146 Location: Cleveland, OH USA
|
|
| Back to top |
|
 |
sultan Nice poster


Offline Joined: Nov 01, 2005 Posts: 68
|
Posted: Wed Oct 24, 2007 1:06 am Post subject: Re: Memberlist shows last login dat/time. |
|
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 |
|
 |
Gallowglas Nice poster


Offline Joined: Nov 13, 2004 Posts: 89 Location: Germany
|
Posted: Wed Oct 24, 2007 4:15 am Post subject: Re: Memberlist shows last login dat/time. |
|
| 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 |
|
 |
rlgura 1000+ Posts Club


Offline Joined: Mar 27, 2006 Posts: 1146 Location: Cleveland, OH USA
|
Posted: Wed Oct 24, 2007 11:10 pm Post subject: Re: Memberlist shows last login dat/time. |
|
username search - an obvious oversight! 
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 |
|
 |
mpyusko Newbie


Offline Joined: Mar 09, 2007 Posts: 34 Location: USA
|
Posted: Thu Oct 25, 2007 12:39 pm Post subject: Re: Memberlist shows last login dat/time. |
|
| 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 |
|
 |
sultan Nice poster


Offline Joined: Nov 01, 2005 Posts: 68
|
Posted: Fri Oct 26, 2007 11:47 pm Post subject: Re: Memberlist shows last login dat/time. |
|
| 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.
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 |
|
 |
pappadee Newbie


Offline Joined: Nov 24, 2004 Posts: 6 Location: London
|
Posted: Fri Nov 23, 2007 12:18 am Post subject: Re: Memberlist shows last login dat/time. |
|
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 |
|
 |
Jeruvy Security Team


Offline Joined: Apr 23, 2004 Posts: 1432 Location: Canada
|
Posted: Fri Nov 23, 2007 3:06 am Post subject: Re: Memberlist shows last login dat/time. |
|
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.
My loonies worth of opinion. Seems to be worth quite a bit these days
_________________ 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 |
|
 |
webhax Newbie


Offline Joined: May 13, 2006 Posts: 26
|
Posted: Fri Nov 23, 2007 2:32 pm Post subject: Re: Memberlist shows last login dat/time. |
|
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 |
|
 |
mpyusko Newbie


Offline Joined: Mar 09, 2007 Posts: 34 Location: USA
|
Posted: Sun Nov 25, 2007 3:37 pm Post subject: Re: Memberlist shows last login dat/time. |
|
| 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 |
|
 |
mpyusko Newbie


Offline Joined: Mar 09, 2007 Posts: 34 Location: USA
|
Posted: Sun Nov 25, 2007 4:10 pm Post subject: Re: Memberlist shows last login dat/time. |
|
| 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 |
|
 |
mpyusko Newbie


Offline Joined: Mar 09, 2007 Posts: 34 Location: USA
|
Posted: Wed Jan 23, 2008 6:05 pm Post subject: Re: Memberlist shows last login dat/time. |
|
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?  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 |
|
 |
Phoenix • Many Posts •


Offline Joined: Apr 19, 2004 Posts: 8799 Location: Netizen
|
Posted: Wed Jan 23, 2008 11:50 pm Post subject: Re: Memberlist shows last login dat/time. |
|
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 |
|
 |
|
|