Last online in users profile

This is a hack i created after installing the "User has started X threads" hack by tube dog.

This is my first hack and im so proud i just had to share it with you all.

I will say that im new to vbb and PHP & MySQL so the code may not be the best.

Version of vbb: RC2

Files needed: getinfo.txt & lastonline.txt See zip file below

Files to modify: member.php

Template to modify: getinfo

Please reply with likes/dislikes/modifications.


The way to install it as as in tubedogs hack

1) Open lastonline.txt
2) Find this code in members.php

[QUOTE] // get last post
$totalposts=$userinfo[posts];
if ($userinfo[posts]!=0 and $userinfo[lastpost]!=0) {
$lastpostdate=vbdate($dateformat,$userinfo[lastpost]);
$lastposttime=vbdate($timeformat,$userinfo[lastpost]);

$getlastposts=$DB_site->query("SELECT thread.title,thread.threadid,thread.forumid,postid ,post.dateline FROM post,thread WHERE thread.threadid=post.threadid AND thread.visible = 1 AND post.userid='$userid' ORDER BY post.dateline DESC LIMIT 20");

while ($getlastpost=$DB_site->fetch_array($getlastposts)) {

$getperms=getpermissions($getlastpost[forumid]);
if ($getperms[canview]) {
$lastposttitle=$getlastpost[title];
$lastposturl="showthread.php?s=$session[sessionhash]&postid=$getlastpost[postid]#post$getlastpost[postid]";
break;
}
}
} else {
$lastpostdate="Never";
}

[mondaynightmike]

Really good hack, well done.

[nafae]

some ppl say it works, some say it doesn't work, so, does it work!?

[Austin Dea]

erm...you could use $bbuserinfo[lastvisitdate], no?

[Tok Muda]

I tried using Austin method.. it works without the hack..

[ExAvIoUr]

Added it only in the template like Austin Dea mentioned ... works great.

[Austin Dea]

I think that var was a new addition since version 2.0.0/2.0.1

[N9ne]

What's Austin's method?

[Austin Dea]

Find in template 'getinfo':

PHP Code:

<tr>
    <td bgcolor="#13486D"><normalfont><b>Last Post:</b></normalfont></td>
    <td bgcolor="#13486D"><normalfont>$lastpostdate $lastposttime<br><a href="$lastposturl">$lastposttitle</a>$nolastpost</normalfont></td>
</tr> 


Under that add:

PHP Code:

<tr><td valign="top"><smallfont><b>Last Visit:</b></smallfont></td><td valign="top"><smallfont>$bbuserinfo[lastvisitdate]</smallfont></td></tr> 


[N9ne]

Thanks

[Chris M]

Cool

Satan