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

[TruthElixirX]

Me and Tralala fixed the problem we were having.

We changed

<td class="alt2"><img src="$sk_avurl[0]" width="80" /></td>

to

<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>

[Shazz]

Originally Posted by TruthElixirX

Me and Tralala fixed the problem we were having.

We changed

<td class="alt2"><img src="$sk_avurl[0]" width="80" /></td>

to

<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>

What does this fix?

[Tralala]

Originally Posted by Shazz

What does this fix?

Read above... the avatar wasn't showing up properly in the private message bit of the UserCP (where a PM section shows up inside the UserCP page when a PM is brand new and unread.)

It either showed an empty square, or "noavatar.gif" (when the sender did in fact have an avatar,) ...and with an attempt at a plug-in tweak, showed the wrong avatar. We couldn't get it to just show the correct avatar in that spot.

The "fix" above removes the graphic entirely from that private message bit inside the UserCP. So while it's not a perfect fix, at least the bug doesn't stand out with an incorrect graphic.

Good enough for me.

[Shazz]

Oh, I had that fixed a long time ago lol.
But nice info to know

[Tralala]

Originally Posted by Shazz

Oh, I had that fixed a long time ago lol.
But nice info to know

Fixed how? To show the accurate avatar? Or to remove it entirely from that bit in the UserCP? Just curious to know how you went about it.

[.Tim]

Originally Posted by TruthElixirX

Me and Tralala fixed the problem we were having.

We changed

<td class="alt2"><img src="$sk_avurl[0]" width="80" /></td>

to

<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>

Glad you were able to find a fix, instructions have been updated with the new code. Thanks for your help.:up:

[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'

[DiSpy]

I fixed the problem I was having...

You have to goto "vBulletin Options -> Private Messaging Options" and make sure "Allow Message Icons for Private Messages" is set to "yes".

(DUH!) --;;

[.Tim]

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'

I wish I could help but mysql is not my strong point.

[Tralala]

Originally Posted by DiSpy

I fixed the problem I was having...

You have to goto "vBulletin Options -> Private Messaging Options" and make sure "Allow Message Icons for Private Messages" is set to "yes".

(DUH!) --;;

I see this is your first post in the thread.

What is the problem you were having? (Just in case it may help future readers.)