vb.org Archive - Private Messages Enhancements - Sender Avatar In Private Message List

Page 8 of 11

Show 40 post(s) from this thread on one page

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)

DiSpy

03-29-2007 01:12 PM

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

09-07-2007 05:13 PM

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'

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

09-11-2007 10:16 PM

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

.Tim	09-12-2007 12:48 AM

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

JadedSouls

09-19-2007 09:37 PM

Love it!! Great hack :)

yoyoyoyo

10-30-2007 04:35 AM

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

10-30-2007 09:20 AM

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

2) Add

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>

Where the directions tell you to.

Not very hard at all.....

You must be doing something very very wrong. :)

yoyoyoyo

11-01-2007 03:40 AM

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

TheMilkCarton

11-01-2007 04:09 PM

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

11-01-2007 04:48 PM

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

All times are GMT. The time now is 07:35 PM.

Page 8 of 11

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01566 seconds Memory Usage 1,735KB 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 (1)bbcode_code_printable (1)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
Messages: