Previous Thread
Next Thread
Print Thread
Hop To
#209727 04/03/2008 8:22 AM
Joined: Oct 2006
Posts: 128
member
member
Joined: Oct 2006
Posts: 128
The custom avatars on my forum are 48 x 48 pixels. I have the maximum dimensions set up to 80 x 80 pixels. For some reason when users select one of the stock avatars for their profile the avatar expands to 80 x 80 even though it is 48 x 48 in the control panel.

How can I fix this? Thanks.

tonto69 #209736 04/03/2008 12:48 PM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
May be a Bug?


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Mark S #209742 04/03/2008 1:20 PM
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
I had the same problem and ended up editing the templates and such.

The post is located here:
https://www.ubbcentral.com/forums/ubbthreads.php/topics/206521/Avatar_Problems.html#Post206521

JAISP #209743 04/03/2008 5:16 PM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

Check the dimensions in your database. I had a problem when I imported 64x64 avatars after increasing my max to 72x72 for 7.0. I had to run a SQL command to change the sizes or whatnot, some even showed 0x0 in the database after the import... so look in there to see if things look right or not...


GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #209744 04/03/2008 7:13 PM
Joined: Oct 2006
Posts: 128
member
member
Joined: Oct 2006
Posts: 128
Thanks for the help. I'm just a novice though and I'm not sure how to check the database. I checked out the templates that 'thelockman's post referred to but I'm not sure how to hack them to fix the problem.

tonto69 #209780 04/04/2008 1:24 PM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

If you have access to phpMyAdmin through your host's control panel, you can access the database directly. Just be careful... wink

You want to Browse the table ubbt_USER_PROFILE and check the values for USER_AVATAR_WIDTH and USER_AVATAR_HEIGHT to see if things look right or not...


GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #210025 04/08/2008 8:40 PM
Joined: Oct 2006
Posts: 128
member
member
Joined: Oct 2006
Posts: 128
I just checked and both showed length/values of 4

tonto69 #210026 04/09/2008 2:52 AM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

4 pixels??? So not 48x48 but tiny little 4x4?? confused


GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #210031 04/09/2008 9:04 AM
Joined: Oct 2006
Posts: 128
member
member
Joined: Oct 2006
Posts: 128
I'm not sure I'm viewing it right but I've attached a screenshot below. I don't know why it would expand to 80x80 if it shows 4.

[Linked Image from i298.photobucket.com]

tonto69 #210032 04/09/2008 9:35 AM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
4 is the max digits

1234 = int (4) (So that's Fine)

You need to view the table now.
I think you can click on the USER_AVATAR_HEIGHT

I haven't been there for a while. you see


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Mark S #210035 04/09/2008 12:40 PM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

Click on the BROWSE tab on top of that page in phpMyAdmin, and then you can see a bunch of profiles at once. Scroll to check the USER_AVATAR_HEIGHT and USER_AVATAR_WIDTH columns to see if things look right or not...


GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #210037 04/09/2008 2:48 PM
Joined: Oct 2006
Posts: 128
member
member
Joined: Oct 2006
Posts: 128
jgeoff, I see what you're saying now. I checked that out and it looks like for all users who are using stock avatars the height and width are showing up as 80x80 even though they shouldn't. Users uploading their own avatars are showing up OK.

Mark S #210053 04/09/2008 7:19 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
There should be a "browse" tab at thwe top of that page. You're simply viewing the table schematics on the initial page.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #210070 04/09/2008 9:28 PM
Joined: Oct 2006
Posts: 128
member
member
Joined: Oct 2006
Posts: 128
Thanks, I've since clicked on the browse tab. The width and height are showing up as 80 pixels for all profiles using stock avatars even though the stock avatars are not 80x80. How can I fix this?

tonto69 #210076 04/10/2008 1:49 AM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1
Originally Posted by Gizmo
There should be a "browse" tab at thwe top of that page. You're simply viewing the table schematics on the initial page.
It's not your birthday anymore, so no more redundant answers 7 hours too late. tongue laugh

Originally Posted by tonto69
The width and height are showing up as 80 pixels for all profiles using stock avatars even though the stock avatars are not 80x80. How can I fix this?

It's probably something like this, which you can run under Control Panel » Database Tools » SQL Command. I'm no expert, so perhaps confirmation from someone else would be wise before doing this...:
Code

update ubbt_USER_PROFILE set USER_AVATAR_WIDTH='48',USER_AVATAR_HEIGHT='48' where USER_AVATAR_WIDTH='80' and USER_AVATAR_HEIGHT='80'

Note: The above should change ALL 80x80 avatars to 48x48.


GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #210083 04/10/2008 6:23 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Psh, it's not redundant, it's dummied down wink...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #210093 04/10/2008 1:07 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
or gizmoed for short..

SD #210134 04/10/2008 7:37 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Originally Posted by Sirdude
or gizmoed for short..
tongue


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #210161 04/11/2008 12:06 AM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

You guys can't just confirm my SQL statement for this poor chap?? lol


GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #210193 04/11/2008 2:36 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
they look good to me! tongue

SD #210341 04/15/2008 7:55 PM
Joined: Oct 2006
Posts: 128
member
member
Joined: Oct 2006
Posts: 128
Thanks for the help jgeoff. Rather than taking a chance with the database I adjusted the stock avatars to 80x80 so they show up right now.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)