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

[.Tim]

I need to see a screenshot of a larger area.

[apdcanari]

3.5 please ?

[.Tim]

It should work for 3.5 if not I'll mess around with it later.

[.Tim]

Okay, just tested it and the plugin does NOT work in 3.5, I'll mess around with it and see if I can get something working.

[G_Man]

Works a Treat. Thanks .Tim!

I changed the template edit to limit the height and center the Avatars, since I allow some of my users to have 150px+ avatars.

Love it though.

[Trana]

Anybody else getting this error message:

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'

[G_Man]

Originally Posted by Trana

Anybody else getting this error message:

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'

Yep. I had one user get this. Had to empty her Sent Messages and have not had a problem since. Didn't say anything here as I could not pinpoint the problem.

[Shazz]

Never got it =\

[Trana]

Originally Posted by G_Man

Yep. I had one user get this. Had to empty her Sent Messages and have not had a problem since. Didn't say anything here as I could not pinpoint the problem.

I think I pinned this down. This error seems to appear every time a user goes to the second page of their PM inbox.

I don't know how to fix it at the moment, but it does seem to be repeatable.

[G_Man]

Originally Posted by Trana

I think I pinned this down. This error seems to appear every time a user goes to the second page of their PM inbox.

I don't know how to fix it at the moment, but it does seem to be repeatable.

Well, I am curious about what you come up with.

I suppose I could just limit everyone to 5 PMs!! LOL

Seriously though, I haven't had it happen again, but a fix would be greatly appreciated.