Private Messages Enhancements - Sender Avatar In Private Message List

I've seen a few requests for it and wanted it myself, I spent a lot of time on it and then realized I wasted a lot of time and it was actually quite simple. Now this works whether you store your avatars in the filesystem or database.

Upload the plugin. Then:

In your pm_messagelistbit template find:

<if condition="$show['pmicons']"><td class="alt2"><if condition="$show['pmicon']"><img src="$pm[iconpath]" alt="$pm[icontitle]" /><else />&nbsp;</if></td></if>

And replace it with:

<if condition="THIS_SCRIPT!='usercp'"> <if condition="$sk_avurl"><td class="alt2" width="80"><img src="$sk_avurl[0]" width="60" /></td><else /><td class="alt2" width="60"><img src="images/misc/noavatar.gif" width="60" border="0" /></if></td></if> </if>

You'll be replacing the post icon that shows up between the status icon and the message itself.

If your board allows users to not have an avatar and you're getting red x's on some, do this:
https://vborg.vbsupport.ru/showpost....1&postcount=26

Credit to:
TruthElixirX, Tralala, nevetS and Lionel
For their help. Thanks.

PS This hack is compatible with 3.7

[DiSpy]

The columns were breaking. It turned out to be just a matter of the fact that I didn't have that column turned on in the options.

[Trana]

Originally Posted by Trana

Did anyone ever fix this problem:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
customavatar.width, customavatar.height
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = cc;

MySQL Error : Unknown column 'cc' in 'where clause'

Can anyone help me fix this issue? I think it started when I upgraded to 3.6x and VB included the option to cc people. It happens to random users based on them receiving or sending a message. The only way I can seem to fix it is by clearing all their PMs, which is really a pain!

Please let me know if you can help.

Thanks.

[Trana]

Can anyone confirm that they have this working on 3.6.8 with cc:ed users?

[.Tim]

I have 3.6.8 and am using it and I can't duplicate your problem. Sorry.

[JadedSouls]

Love it!! Great hack

[yoyoyoyo]

I can't get this to work - I started at the beginning of the thread and worked my way through and no luck at all

[TheMilkCarton]

1) Add $sk_avurl = fetch_avatar_url($userid); to a plugin at private_messagelist_messagebit. OR just install the XML.

2) Add

<if condition="THIS_SCRIPT!='usercp'"> <if condition="$sk_avurl"><td class="alt2" width="80"><img src="$sk_avurl[0]" width="60" /></td><else /><td class="alt2" width="60"><img src="images/misc/noavatar.gif" width="60" border="0" /></if></td></if> </if>

Where the directions tell you to.

Not very hard at all.....

You must be doing something very very wrong.

[yoyoyoyo]

I did that - not working - maybe I have a conflicting mod???

[TheMilkCarton]

Just highlight the HTML in the PM list and View Selection Source (if you use FF). Look for the HTML that you added, maybe it's not grabbing the avatar's location correctly.

[Borden]

My avatar limits are 250 by 250. Does this mean, this is how big they will be in the private message list?