[Pikok]

04-24-03 at 10:01 AM Boofo said this in Post #12
Chris, I added this hack but the

Maximum Dimensions
Maximum width and height (in pixels) that the custom avatar image can be.

is still in the options. Do I need to remove this or is it used somewhere else that it needs to stay there for?

The query should've been:

PHP Code:

UPDATE setting SET settinggroupid='26',title='Maximum Width',varname='avatarmaxwidth',value='80',description='Maximum width (in pixels) that the custom avatar image can be.',optioncode='',displayorder='5' WHERE settingid='137' 


Rather than:

PHP Code:

UPDATE setting SET settinggroupid=26,title='Maximum Width',varname='avatarmaxwidth',value='80',description='Maximum width (in pixels) that the custom avatar image can be.',optioncode='',displayorder='5' WHERE settingid='139' 


Setting 139 (at least in my database is Display Height (columns of avatars to display). So, when I ran the query as instructed in the install doc, I replace the Display Height setting with the Max Width setting. This resulted in the Max Dimensions still showing (as did with you), but also removed the Display Height setting from the control panel (as it was overwritten in the database).

I always backup the database before doing any hacks though, so I just dropped and restored row 139 and dropped the new row created for the Maximum Height setting, then ran the following queries and everything's fine now..

PHP Code:

UPDATE setting SET settinggroupid=26,title='Maximum Width',varname='avatarmaxwidth',value='80',description='Maximum width (in pixels) that the custom avatar image can be.',optioncode='',displayorder='5' WHERE varname='avatarmaxdimension' 


PHP Code:

UPDATE setting SET displayorder='7' WHERE varname='avatarmaxsize' 


PHP Code:

UPDATE setting SET displayorder='8' WHERE varname='numavatarshigh' 


PHP Code:

UPDATE setting SET displayorder='9' WHERE varname='numavatarswide' 


PHP Code:

INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displayorder) VALUES (NULL,26,'Maximum Height','avatarmaxheight','150','Maximum height (in pixels) that the custom avatar image can be.','','6'); 


You don't really have to run the 3 queries that change the display order, but I did just to be sure they showed up in the cPanel in the order I want.