[Done 1.4.x/1.5.x - UPDATE] LastLogin Profile V1.1

[MC600]

Unfortunately, I don't speak English.

LastLogin Profile V1.1 by MC600

This modification show the last UserLogin on the user profile - for YaBB SE 1.4.x and 1.5.x german/english - Backup: german.lng / english.lng und Profile.php

To this downloads here click: LastLogin Profile V1.0 for YaBB SE 1.4.x
To this downloads here click: LastLogin Profile V1.1 for YaBB SE 1.5.x

Here one Screenshot (V1.5.x): User Profil

The MOD shows the last Login, not the last visit!

[Zombie]

Thanks, I was looking for a mod like this.

[Joseph Fung]

Did you update the way the lastlogin value was updated?

There is a problem with that part of the code.  If not, it's a crucial part of the mod you're missing.

[MC600]

Did you update the way the lastlogin value was updated?

No.

The MOD shows the last Login, not the last visit.

[Joseph Fung]

Hmmm - does it take into account "logins" when someone has a cookie stored?

Eg. I log in in January, but my cookie keeps me logged in till May.  Even though I visit in May, does my last logged in still see January?

[MC600]

e.g. with the MOD I can see whether a new user - login could...

[PioneeR]

I have installed Show LastLogin in Profile... and if a user is 'forever logged in' the last login doesnt change.

[MC600]

The MOD shows the last Login, not the last visit!

[edi67]

I installed it but


this mod return me back always this data:  Tuesday  01 January 1970, 01:03

[Shadow's Pawn]

I installed it but


this mod return me back always this data:  Tuesday  01 January 1970, 01:03

You probably had to install it manually because the mod was trying to replace a query.  Is that right?

Here is what I did, and it works on my board though it might not be the best way.  I had no idea how to format the time, so I just copied the dateRegistered time formatting, and changed it to the last login.

Code Select Expand


   if ($memsettings['lastLogin'] && $memsettings['lastLogin'] != '0000-00-00')
   {
      $fmt = '%d %b %Y ' . (substr_count($settings[17], '%H') == 0 ? '%I:%M:%S %p' : '%T');
      $lastlog = strftime($fmt, $memsettings['lastLogin'] + $timeadjust);
   }
   else
      $lastlog = $txt[470];


Just above this code, there is the query, the beginning looks like this, except the SELECT line is a lot longer.

Code Select Expand


   $yytitle = $txt[79];
   $request = mysql_query("
      SELECT passwd, realName, emailAddress,


just add lastLogin at the end.  Make sure the second L is capitalized and the rest is lowercase.

Now look for another query.  Again, this is just the beginning of it, the SELECT line is much longer than this.

Code Select Expand


   # get the member's info
   $request = mysql_query("
      SELECT passwd, realName,

Just like last time, add Lastlogin at the end.

Now look for this:

Code Select Expand


                     <td><font size="2"><b>' . $txt[233] . ': </b></font></td>
                     <td><font size="2">' . $dr . '</font></td>
                  </tr><tr>

And add this after that:

Code Select Expand


                     <td><font size="2"><b>Last Login: </b></font></td>
                     <td><font size="2">' . $lastlog . '</font></td>
                  </tr><tr>


You can change Last Login to put it in the language file, but I just hardcoded the text in for simplicity, since everyone on my site reads English...


This still has the problem with last login not showing their last visit...  I'll post a fix for that later when I get home from work.

[Shadow's Pawn]

Nevermind, I just looked at it and the fix is simple.

Open up index.php and look for

Code Select Expand


 $chklngfile = $chklngfile2 = $settings[23];


add after:

Code Select Expand


    $lastLog = time();
    $memIP = $REMOTE_ADDR;
    $result =  mysql_query("UPDATE {$db_prefix}members SET lastLogin='$lastLog',memberIP='$memIP' WHERE memberName='$user'") or database_error(__FILE__, __LINE__);