Miscellaneous Hacks - Smush.it Attachment & Avatar

This sends your image attachments and avatars to smush.it for compression, if the image can be compressed it will download the newly compressed one and replace the attachment or avatar with it.

If you would like features added to it or you find any bugs or problems please let me know.

ACP->Settings->Options->Smush.it Attachment & Avatar Options

[Requirements]
You need to be using PHP 5.2.0 or greater.
You must be storing attachments and avatars in the filesystem.

3.8.x Version: https://vborg.vbsupport.ru/showthread.php?t=275577

http://www.smushit.com/ysmush.it/

[Updates]
16/12/11:
Fixed settings options not being added.

30/12/11:
Added option to smush user uploaded avatars.
Smarter way of fetching avatars and attachments.

24/3/12:
Added TABLE_PREFIX to install and uninstall code.
Fixed typo in uninstall code.

Remember to select "Allow Overwrite" when importing the product.

[jimsflies]

Does this work with 4.2.2? Or can it be updated to work?

I installed but get an error when uploading an attachment...I get a pop up that has this on it:

The following errors occurred:

<p>Database Error</p>

[ozzy47]

Check your server error logs for the error, or perhaps the email you set up in config.php to get technical emails.

[jimsflies]

Here's the error:

			SELECT attachment.*, filedata.* 
			FROM vb_attachment
			LEFT JOIN vb_filedata AS filedata ON (attachment.filedataid = filedata.filedataid)
			WHERE posthash = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';

MySQL Error   : Unknown table 'attachment'

I see there is some discussion about database prefixes, it does have the prefix in the FROM line.

[Kolbi]

Can someone confirm it on vB 4.2.2?

[jimsflies]

I did get it to work on 4.2.2 after paying to have it fixed. However, for some odd reason, the images do not show up on Internet Explorer...they did work on other browsers. Not sure if anyone else has seen this issue with images processed by smush.it?