Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2010-05-05 17:38:53
- mapu
- Member
- From: Munich, Germany
- Registered: 2004-03-16
- Posts: 141
[request] Batch thumbnail resize
Let’s say I have 200 images in TXP all with thumbnails cropped 200×200 px.
For a new layout I need a different size of the thumbnails, I even want to remove the cropping.
Dynamic resizing is no (perfect) solution because of the server stress. Downloading the original images, resizing them locally and uploading them as new thumbnails seem also not to be a good way because the thumbnail size etc. is stored in the database.
An admin plugin for that purpose would be wonderful (Example for WordPress), but I’m grateful for every hint for a nice approach to this task.
Offline
Re: [request] Batch thumbnail resize
mapu wrote:
Downloading the original images, resizing them locally and uploading them as new thumbnails seem also not to be a good way because the thumbnail size etc. is stored in the database.
Thumbnail size not stored in database. Only original images store size in DB.
Simple download original images and make new thumbnail uses XnView or macros in Photoshop
Last edited by makss (2010-05-06 20:56:08)
aks_cron : Cron inside Textpattern | aks_article : extended article_custom tag
aks_cache : cache for TxP | aks_dragdrop : Drag&Drop categories (article, link, image, file)
Offline
Re: [request] Batch thumbnail resize
Offline
Re: [request] Batch thumbnail resize
wet wrote:
Thumbnail size not stored in database.
Actually, it is since 4.2.0.
Thank you for a correction.
Step2: Backup database and update txp_image. Run query in phpMyAdmin:
update prefix_txp_image set thumb_w= 300, thumb_h= 300 where thumbnail=1
300 – new thumbnail size
prefix_ – your table prefix
aks_cron : Cron inside Textpattern | aks_article : extended article_custom tag
aks_cache : cache for TxP | aks_dragdrop : Drag&Drop categories (article, link, image, file)
Offline
#5 2010-05-07 08:50:43
- mapu
- Member
- From: Munich, Germany
- Registered: 2004-03-16
- Posts: 141
Re: [request] Batch thumbnail resize
makss wrote:
Step2: Backup database and update txp_image. Run query in phpMyAdmin:
update
prefix_txp_image set thumb_w=300, thumb_h=300where thumbnail=1
300– new thumbnail size
prefix_– your table prefix
Thanks, I’ll give this a try!
Offline
#6 2010-05-07 20:11:11
- masa
- Member
- From: Asturias, Spain
- Registered: 2005-11-25
- Posts: 1,091
Re: [request] Batch thumbnail resize
If you’re using an earlier version, 4.0.8 and older, you can use the method I described here
Offline
#7 2010-05-07 20:15:36
- mapu
- Member
- From: Munich, Germany
- Registered: 2004-03-16
- Posts: 141
Re: [request] Batch thumbnail resize
masa wrote:
If you’re using an earlier version, 4.0.8 and older, you can use the method I described here
My TXP installs are always up to date! ;)
Offline
#8 2010-05-07 21:05:39
- masa
- Member
- From: Asturias, Spain
- Registered: 2005-11-25
- Posts: 1,091
Re: [request] Batch thumbnail resize
mapu wrote:
My TXP installs are always up to date! ;)
In that case it’s more complicated unfortunately.
Offline