Track User Logins

[br360]

Thanks Margarett. The recorded IP address each time a member logs in will definitely help track some of the more problem members (trolls/sock puppets,etc.).

Awesome indeed.

[Ninja ZX-10RR]

Plus, it could be *extremely* useful to detect shared accounts

[margarett]

So, I updated the MOD. Please let me know if you have any suggestions

[br360]

Works great margarett-awesome job.

I did notice though that on the first page of this support topic it says that it prunes the logs every 30 days- but when going into the task scheduler, it has it pruning every day by default. No biggie as obviously one can just change the time to run the task.

This will come in handy, so thanks again.

[margarett]

No... The task runs daily. But it removes any records older than 30 days

[Ninja ZX-10RR]

YEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEAAAAAAAAAAAAH you just made my day
Just a suggestion... Would it be possible to get rid of the Cloudflare logins? See attached image to have an idea. I have a CF mod working on my forum and also Bad Behaviour with reverse IP enabled to get the real IP addresses.

That pruning is just.. *-* ... ♥_♥ can I just stare at it?
Is it configurable then? I set it to run every week thinking it would have been deleting all entries older than one week XD

Ah don't try to edit that big red text as it expresses my happyness

[br360]

No... The task runs daily. But it removes any records older than 30 days

Ah, good to know. LOL, I just ran the scheduled task, and the records still showed in the profile. At least now I know why.

[margarett]

Would it be possible to get rid of the Cloudflare logins?

You mean don't record when there's a certain IP? Or to get the real IP behind CF?

Is it configurable then? I set it to run every week thinking it would have been deleting all entries older than one week XD

ATM not. The task runs once a day. Every day it removes entries older than 30 days (relating to each day it runs, of course ) and that's it. If you want to change the 30 days, it has to be done in ScheduledTasks.php:

Code Select Expand

//limit date to remove. 30 days for now, maybe next version has a setting for it ;)
$limit_date = time() - 30 * 86400;
That "30" is the number of days

[Ninja ZX-10RR]

I already get the IP behind CF (as shown in the pic) I would just like to get completely rid of the line telling me that my cookie logged in behind CF since it only spams the list.

[margarett]

So you don't want to record ANY cookie login? Or just don't want to record a cookie login that comes from a certain IP? I'm sorry, I've never used CF so I don't really understand how it works.

[Ninja ZX-10RR]

No I want to record cookie logins but with the correct forwarded IP, and it doesn't happen :/ it shows CF IP in that case, dunno why.

[margarett]

Ah, ok. I'll see if I can check where that mod puts the real IP

[Ninja ZX-10RR]

Take your time, no rush as it's already awesome like this thanks anyway

[Chalky]

Margarett, since I installed the latest version of this mod yesterday I keep getting this error generated by all members:

Unknown column 'ip' in 'field list'
File: /home/..../Sources/Subs-TrackLogins.php
Line: 39

To the user it delivers a blank white screen with the error "Unknown column 'ip' in 'field list'"in the top corner.  Refreshing the page the forum comes back and acts normally.  I did have the first version of the mod installed to begin with, with no problem, but I uninstalled it yesterday, did not opt to delete the associated data and installed the new version.

Edit:  Actually, it's worse than that.  See attached.  I'm going to try uninstalling the mod again and let it delete the data this time, then try installing it again....

[margarett]

Ups I forgot to add that detail... It is necessary to delete associated data at uninstall or else the new column in log_logins table isn't created...
Anyway you can fix that now by going to phpmyadmin, forum database, SQL tab and run this query:

Code Select Expand

ALTER TABLE smf_log_logins ADD ip VARCHAR( 20 ) NULL DEFAULT NULL ;
(of course, check for correct prefix )

[Chalky]

Wow, that was super-quick!!!  I was still backing everything up before I tried anything so hadn't had chance to break anything yet     Fix works perfectly, thanks margarett 

[Arantor]

Yeah, this has been an issue since 2.0 RC3 or 4 if I remember rightly.

Take a look at SimpleDesk's installer sometime, it might be useful; all the tables are declared in an array and then the array is shoved at add-column too just in case.

[Debbie3]

Hi
I just installed the mod Track User Logins  I am using Vertex Theme. I can't seem to find where it installed to and where the logs are.

Please advise.
Thank you

[-Rock Lee-]

@margarett Very good here I leave the translation to the Latin Spanish so can be appreciated by more languages: D

Profile.spanish_latin-utf8.php

Code Select Expand

$txt['trackLogins'] = 'Inicio de sesión/Cierre de sesión de usuarios';
$txt['trackLogins_by'] = 'Compruebe los registros de conexión/desconexión por';
$txt['trackLogins_nodata'] = 'No hay nombres de usuarios / cierres de sesión se registraron para este usuario';
$txt['trackLogins_login'] = 'Manual de Inicio de sesión';
$txt['trackLogins_cookie'] = 'Auto (cookie) de sesión';
$txt['trackLogins_logout'] = 'Cerrar sesión';
$txt['trackLogins_action'] = 'Acción';

and Profile.spanish_latin.php

Code Select Expand

$txt['trackLogins'] = 'Inicio de sesión/Cierre de sesión de usuarios';
$txt['trackLogins_by'] = 'Compruebe los registros de conexión/desconexión por';
$txt['trackLogins_nodata'] = 'No hay nombres de usuarios/Cierres de sesión se registraron para este usuario';
$txt['trackLogins_login'] = 'Manual de inicio de sesión';
$txt['trackLogins_cookie'] = 'Auto (cookie) de sesión';
$txt['trackLogins_logout'] = 'Cerrar sesión';
$txt['trackLogins_action'] = 'Acción';

ManageScheduledTasks.spanish_latin-utf8.php

Code Select Expand

$txt['scheduled_task_pruneTrackLogins'] = 'Borrar pista de inicio de sesión/Cierre de sesión de usuarios';
$txt['scheduled_task_desc_pruneTrackLogins'] = 'Elimina los registros antiguos de la tabla de MODificación';

ManageScheduledTasks.spanish_latin.php

Code Select Expand

$txt['scheduled_task_pruneTrackLogins'] = 'Borrar pista de inicio de sesiión/Cierre de sesiión de usuarios';
$txt['scheduled_task_desc_pruneTrackLogins'] = 'Elimina los registros antiguos de la tabla de MODificaciión';


Regards!

PD: Whatever you need, call me

[aegersz]

I have checked my Task Log and the Prune Track User Logins/Logouts is not being logged yet i have it set to run daily - what could be wrong ? I have the 1.1 version installed.

I have even tried to run it manually but it still doesn't appear in the log.

However, my Logins/Logouts list does goes back less than 30 days so i guess it's working ok.