[MOD] Last Visit 3.0

Just wondering if anyone has any further ideas on the problem with the display date? I'm still not sure what to tinker with to make it come correct, and apparently all of my users last logins were way back in 1970 😛

Is this officially working with 3.3 yet? If so, what are the variables that needed changing? Is it the things like isAdmin?
Also, where does it display? Only on profiles, or on the Members list, or perhaps in the Action Log, or the Members admin panel? Being able to see all members from one place, rather than searching via profile would be especially handy for this, and/or perhaps a way to only display members who meet X criteria (like "Have not signed on within the past year").

Lastly, did any/everyone figure out the "wrong date" associated with login error, for those that had dates from 1960-70?

No one is answering in the thread of the eFic 2.x version of this mod, so hopefully it's okay if I ask here. What and where do I put the ALTER TABLE if I am not using phpmyadmin (it's not working for me for some reason)? This is what I currently have in my Update-tables-step6.sql:

ALTER TABLE `fanfiction_authors`
ADD `Yahoo` VARCHAR( 40 ) DEFAULT '0' NOT NULL ,
ADD `ICQ` VARCHAR( 40 ) DEFAULT '0' NOT NULL ,
ADD `MSN` VARCHAR( 40 ) DEFAULT '0' NOT NULL ,
ADD `betareader` CHAR( 1 ) DEFAULT '0' NOT NULL ,
ADD `ageconsent` CHAR( 1 ) DEFAULT '0' NOT NULL ,
ADD `alertson` CHAR( 1 ) DEFAULT '0' NOT NULL,
ADD `lastlog` DATETIME NOT NULL ,
CHANGE `newreviews` `newreviews` CHAR( 1 ) DEFAULT '0' NOT NULL ,
CHANGE `admincreated` `admincreated` CHAR( 1 ) DEFAULT '0' NOT NULL ,
ADD `lastlog` DATETIME NOT NULL ;
ALTER TABLE `fanfiction_characters` ADD `bio` TEXT NOT NULL, ADD `image` VARCHAR( 200 ) NOT NULL;
ALTER TABLE `fanfiction_categories` CHANGE `locked` `locked` CHAR( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE `fanfiction_ratings` CHANGE `ratingwarning` `ratingwarning` CHAR( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE `fanfiction_reviews` CHANGE `sid` `chapid` INT( 11 ) DEFAULT '0' NOT NULL ,
CHANGE `psid` `sid` INT( 11 ) DEFAULT '0' NOT NULL, ADD `respond` CHAR( 1 ) DEFAULT '0' NOT NULL ,
ADD `seriesid` INT( 11 ) DEFAULT '0' NOT NULL;

I didn't put it in twice; this just shows the position I've put that code two separate times.

I then followed the instructions for the eFic 2.x thread.

Pretty much the same people who read the 2.x boards read the 3.x boards too.

The second one is definitely wrong.  You probably want to remove that completely.  I'm not sure what you're doing with it though. If you're updating a 2.0 archive to a 3.3 archive and the 2.0 already has this mod there is no need to add this.

Nope, I'm not updating (yet). What I'm trying to do is add a field in fanfiction_authors as specified in this and the 2.0 mod thread. And I was merely showing the two places I put the line; I didn't put both at the same time.

Here's my code:

ALTER TABLE `fanfiction_authors`
ADD `Yahoo` VARCHAR( 40 ) DEFAULT '0' NOT NULL ,
ADD `ICQ` VARCHAR( 40 ) DEFAULT '0' NOT NULL ,
ADD `MSN` VARCHAR( 40 ) DEFAULT '0' NOT NULL ,
ADD `betareader` CHAR( 1 ) DEFAULT '0' NOT NULL ,
ADD `ageconsent` CHAR( 1 ) DEFAULT '0' NOT NULL ,
ADD `alertson` CHAR( 1 ) DEFAULT '0' NOT NULL,
ADD `lastlog` DATETIME NOT NULL ;
CHANGE `newreviews` `newreviews` CHAR( 1 ) DEFAULT '0' NOT NULL ,
CHANGE `admincreated` `admincreated` CHAR( 1 ) DEFAULT '0' NOT NULL ,
ALTER TABLE `fanfiction_characters` ADD `bio` TEXT NOT NULL, ADD `image` VARCHAR( 200 ) NOT NULL;
ALTER TABLE `fanfiction_categories` CHANGE `locked` `locked` CHAR( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE `fanfiction_ratings` CHANGE `ratingwarning` `ratingwarning` CHAR( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE `fanfiction_reviews` CHANGE `sid` `chapid` INT( 11 ) DEFAULT '0' NOT NULL ,
CHANGE `psid` `sid` INT( 11 ) DEFAULT '0' NOT NULL, ADD `respond` CHAR( 1 ) DEFAULT '0' NOT NULL ,
ADD `seriesid` INT( 11 ) DEFAULT '0' NOT NULL;

Not related to the previous posts at hand, but this mod begins the 31st December 1969 activity after upgrading to PHP 5.2.5

Yo o

Well, I updated my MOD for eFiction 3.X and it's working fine here. What I did:

On profile.php, added to $result2 :  DATE_FORMAT(lastlog, '%d/%m/%Y -  %H:%i')

This will display the date like: "27/02/2008 - 22:15"  (dd/mm/yyyy - 24 hour format)
If you want to change it, take a look at mysql reference manual:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

Those lines will check if user updated lastlog, if so, it will show last time user was online. If not, displays "Unavailable"

if  (ereg("00/00/0000", $userinfo['lastlog'])) {
  $tpl->assign("lastlog", "Unavailable");
}
else {
    $tpl->assign("lastlog", $userinfo['lastlog']); 
}

Hope it helps.

Thanks Seiji. That worked wonders!

Wow. I love this mod. I've just installed it on my eFiction site... so far everything works fine 😉
Thank you very much for this great mod.

Would be interesting to have the last login showing up in the members list in the admin area. Would that be possible somehow?

Hmm I got this to work when I changed $tableprefix to .TABLEPREFIX.

Nice Marauder 😀

Amancham, we can do it, it's easy. I have to go to university right now, but I'll try to help you when I come back.

Thanks, Seiji. Would be lovely!

I am installing this to efiction 3.5 and I'm seeing this getting a version update. Seiji provided the code, but I'm not entirely sure how to input it into the profile.php page Thanks

^ Which part?

If it's the part where it defines the variable, you could theoretically put that anywhere. For example, some place after a similar bit of coding? ($tpl->assign ...)