Last PM on Forumhome

This hack will show you last PM you recieved on the forumhome.

[Kratheous]

Screenshot:

[Disturbed]

nice, thanks for sharing ^^

[Sebastian]

it doen't work for me.. no errors, just says i have no new pms when i do. v229

[Floris]

Great, I will install it right away, nice little hack! simple/easy/effective

[Floris]

floris - You have 1 new message(s) since your last visit.
(You have 1 unread messages and 42 total messages in all your folders.)
You have no Private Messages in your inbox at the moment.

Uhm, doesn't seem to be working though :> vB 2.2.9

[Floris]

inph from the irc informed me to also add the templates that are used into the $templatesused=' bit.

So, find:

$templatesused=' (in the top of index.php)

and at the end of the line, replace:
';
with:
,forumhome_pmlastno,forumhome_pmlast';

[Boofo]

Well, it works for me, almost. It says the last message title correct but is has ARRAY as the user the message is from (and there is no such user on my board). Also, the message it is picking up was moved out of the Inbox into another folder. Is it supposed to show only pms in your inbox?

[inphinity]

i think $lastpmuser should be referenced as:

PHP Code:

<br><br><b>Latest Private Message:</b> $lastpmstuff[title] by $lastpmuser['username'] 

also it is the last pm recieved in all folders

you could limit it to inbox by adding folderid = 0 after WHERE in the $lastpmstuff query

[Boofo]

Should it look like this?

PHP Code:

$lastpmstuff=$DB_site->query_first("SELECT * FROM privatemessage WHERE folderid = 0 userid=$bbuserinfo[userid] and fromuserid!=$bbuserinfo[userid] $ignoreusers ORDER BY dateline DESC LIMIT 1");