Last login and member since mod

This mod will add these 2 stats to your members profile

add the following sql code to your members_profile table

ALTER TABLE `member_profile` ADD `lastlog` VARCHAR( 255 ) NOT NULL

Backup and open memberprofile.php

find

$current_city = wordwrap($result["current_city"],15," ",true);

on the next line add

$lastlog = $result["lastlog"];
$date_created = $result["date_created"];

Save and close memberprofile.php

Backup and open login.php

find

//success login - checkinng if user has confirmed email

add this before that

$lastlog = date('j, n, Y');
$sql = "UPDATE member_profile SET lastlog = '$lastlog' WHERE user_name = '$user_name_login'";
@mysql_query($sql);

Save and close login.php

Backup and open inner_members_profile.htm

Use these 2 variables to add them where you want them

[var.lastlog]
[var.date_created]

Then save inner_members_profile.htm

Congratulations its complete.

One Response to “Last login and member since mod”

  1. jamie says:

    This never worked for me either. Not sure where i’m going wrong, I really want this mod as well

Leave a Reply

Listed on BlogShares