Update attachment size (height/width) in DB

[kokett]

Hello,

is there a tool or mod to update resolutions of attached images saved in database? I've manually resized images but with maintenance in ACP only filesize will be corrected, but I need to update resolution too.

Thanks and greetings

kokett

[Kays]

Hi, welcome to SMF.

See if this tool will do what you want.

http://www.simplemachines.org/community/index.php?topic=274252.msg1797296#msg1797296

[kokett]

Hi,

great, I've searched a lot without a result. But that is what I'm looking for. Thank you very much.

[Kays]

It's a big forum and search returns too many results at times.

If this does resolve your issue. Could you mark it as solved by clicking on the green "Mark Topic Solved" button below.

[kokett]

Hi,

I would like to say that in my case I had to adjust the script a bit. Between line 78 and 85 I changed the query as follows:

Code Select Expand


// Get the attachments w/o a width and height.
$request = db_query("
SELECT ID_ATTACH, filename, width, height
FROM {$db_prefix}attachments
WHERE $extensions
AND height > 1280
AND ID_MEMBER = 0
LIMIT $_GET[start], 100", __FILE__, __LINE__);


and in the second case:

Code Select Expand


// Get the attachments w/o a width and height.
$request = db_query("
SELECT ID_ATTACH, filename, width, height
FROM {$db_prefix}attachments
WHERE $extensions
AND width > 1280
AND ID_MEMBER = 0
LIMIT $_GET[start], 100", __FILE__, __LINE__);


I've manually reduced the max dimensions of all images to 1280 proportionally and uploaded them back. Then I ran the script as described.

[Kays]

I'm glad that worked out for your.