Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Sender Avatar In Private Message List Details »
Sender Avatar In Private Message List
Mod Version: 1.00, by .Tim (Member) .Tim is offline
Developer Last Online: Mar 2013 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.4 Rating: (3 votes - 4.33 average) Installs: 85
Released: 24 Sep 2006 Last Update: 25 Sep 2006 Downloads: 325
Not Supported Uses Plugins Template Edits  

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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

And replace it with:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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:
http://www.vbulletin.org/forum/showp...1&postcount=26

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

PS This hack is compatible with 3.7

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	pmavexample.jpg
Views:	1479
Size:	27.8 KB
ID:	53845  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #61  
Old 13 Mar 2007, 00:46
TruthElixirX's Avatar
TruthElixirX TruthElixirX is offline
 
Join Date: Sep 2004
Me and Tralala fixed the problem we were having.

We changed



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


to


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #62  
Old 13 Mar 2007, 00:51
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn
Originally Posted by TruthElixirX View Post
Me and Tralala fixed the problem we were having.

We changed



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


to


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

What does this fix?
Reply With Quote
  #63  
Old 13 Mar 2007, 01:38
Tralala's Avatar
Tralala Tralala is offline
 
Join Date: Jan 2006
Originally Posted by Shazz View Post
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.
Reply With Quote
  #64  
Old 13 Mar 2007, 01:39
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn
Oh, I had that fixed a long time ago lol.
But nice info to know
Reply With Quote
  #65  
Old 13 Mar 2007, 04:40
Tralala's Avatar
Tralala Tralala is offline
 
Join Date: Jan 2006
Originally Posted by Shazz View Post
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.
Reply With Quote
  #66  
Old 15 Mar 2007, 01:03
.Tim's Avatar
.Tim .Tim is offline
 
Join Date: Jan 2005
Real name: Tim
Originally Posted by TruthElixirX View Post
Me and Tralala fixed the problem we were having.

We changed



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


to


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
Glad you were able to find a fix, instructions have been updated with the new code. Thanks for your help.
Reply With Quote
  #67  
Old 23 Mar 2007, 23:04
Trana Trana is offline
 
Join Date: Apr 2005
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'
Reply With Quote
  #68  
Old 24 Mar 2007, 21:28
DiSpy's Avatar
DiSpy DiSpy is offline
 
Join Date: Feb 2007
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!) --;;

Last edited by DiSpy; 24 Mar 2007 at 21:33.
Reply With Quote
  #69  
Old 25 Mar 2007, 01:17
.Tim's Avatar
.Tim .Tim is offline
 
Join Date: Jan 2005
Real name: Tim
Originally Posted by Trana View Post
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.
Reply With Quote
  #70  
Old 25 Mar 2007, 03:30
Tralala's Avatar
Tralala Tralala is offline
 
Join Date: Jan 2006
Originally Posted by DiSpy View Post
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.)
Reply With Quote
  #71  
Old 29 Mar 2007, 14:12
DiSpy's Avatar
DiSpy DiSpy is offline
 
Join Date: Feb 2007
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.
Reply With Quote
  #72  
Old 07 Sep 2007, 18:13
Trana Trana is offline
 
Join Date: Apr 2005
Originally Posted by Trana View Post
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.
Reply With Quote
  #73  
Old 11 Sep 2007, 23:16
Trana Trana is offline
 
Join Date: Apr 2005
Can anyone confirm that they have this working on 3.6.8 with cc:ed users?
Reply With Quote
  #74  
Old 12 Sep 2007, 01:48
.Tim's Avatar
.Tim .Tim is offline
 
Join Date: Jan 2005
Real name: Tim
I have 3.6.8 and am using it and I can't duplicate your problem. Sorry.
Reply With Quote
  #75  
Old 19 Sep 2007, 22:37
JadedSouls's Avatar
JadedSouls JadedSouls is offline
 
Join Date: May 2007
Real name: Jolene | JoJo
Love it!! Great hack
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:25.

Layout Options | Width: Wide Color: