vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Private Messages Enhancements - Sender Avatar In Private Message List (https://vborg.vbsupport.ru/showthread.php?t=127414)

TruthElixirX 03-12-2007 11:46 PM

Me and Tralala fixed the problem we were having.

We changed


Code:

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

to

Code:

<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 03-12-2007 11:51 PM

Quote:

Originally Posted by TruthElixirX (Post 1202088)
Me and Tralala fixed the problem we were having.

We changed


Code:

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

to

Code:

<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 03-13-2007 12:38 AM

Quote:

Originally Posted by Shazz (Post 1202094)
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 03-13-2007 12:39 AM

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

Tralala 03-13-2007 03:40 AM

Quote:

Originally Posted by Shazz (Post 1202121)
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 03-15-2007 12:03 AM

Quote:

Originally Posted by TruthElixirX (Post 1202088)
Me and Tralala fixed the problem we were having.

We changed


Code:

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

to

Code:

<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 03-23-2007 10:04 PM

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 03-24-2007 08:28 PM

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 03-25-2007 12:17 AM

Quote:

Originally Posted by Trana (Post 1210666)
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 03-25-2007 01:30 AM

Quote:

Originally Posted by DiSpy (Post 1211300)
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.)


All times are GMT. The time now is 05:15 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01349 seconds
  • Memory Usage 1,749KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete