Making Private Messages Show on Forum Home...
 

here's my forum...
Forum2kTree

i'm just learning how to hack up vbulletin. as you can see in the private messages inbox category is some blank cells. i'm trying to add the date sent and who in the the "last post" cell...like how it is with the forums.

i tried $privatemessage[datesent], and $privatemessage[displayusername] which i took from the official private message page code...but no luck.

could somebody help me?

-Chief Corn

*update* i just realized that you would have to be register to see the private message category...but to give you a visual: it would look like the next main forum category but it says Private Messages and the "sub-forum" is called Inbox. the cells next to it are blank...

setting up a test account for us would help more i think ;)

also du you just copy the vars into forumhome template, or have you modified index.php (you have to or it cannot work ;))

here's a test account...

username: vbhelp
password: vbhelp

...no i didn't edit the index.php. don't know what to put.

ahh, that helps :)

well you have to edit index.php

find this code:
below add:
now you can use the vars...

entered it exactly as you typed it...but i get a error page that says:

----------------------------------------
Invalid SQL: SELECT privatemessage.*, user.username FROM privatemessage LEFT JOIN user ON (user.userid=privatemessage.fromuserid) WHERE userid=1 LIMIT 1 ORDER BY privatemessageid DESC
mysql error: You have an error in your SQL syntax near 'ORDER BY privatemessageid DESC' at line 1

mysql error number: 1064
-----------------------------------------

tried it twice...once below that line, and once above it. i'm pretty sure this can be done...and you have it....but possibly a typo somewhere?

-Chief Corn

Try changing the end of that PHP code from

to:

this is the new error... :confused:

---------------------------------
Invalid SQL: SELECT privatemessage.*, user.username FROM privatemessage LEFT JOIN user ON (user.userid=privatemessage.fromuserid) WHERE userid=1 ORDER BY privatemessageid DESC LIMIT 1
mysql error: Column: 'userid' in where clause is ambiguous

mysql error number: 1052
----------------------------------

-Chief Corn

Try this:

damn, what hav i done ;)

hmm erwin i think asuming userid to PM-table would be better:

i tried both of those lines and i get:

-----------------------------
Invalid SQL: SELECT privatemessage.*, user.username FROM privatemessage LEFT JOIN user ON (user.userid=privatemessage.fromuserid) WHERE user.userid=1 LIMIT 1 ORDER BY privatemessageid DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY privatemessageid DESC LIMIT 1' at line 1

mysql error number: 1064
------------------------------

http://forum.2ktree.com doesn't work anymore...but http://www.2ktree.com/forum does which is strange.

-Chief Corn