[Gforge-devel] [gforge-Patches][2567] Screenshot / Multimedia data

[gforge-patches at gforge.org]

Patches item #2567, was opened at 2006-06-25 13:26
You can respond by visiting: 
http://gforge.org/tracker/?func=detail&atid=106&aid=2567&group_id=1
Or by replying to this e-mail entering your response between the following markers: 
#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+
(enter your response here)
#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+

Status: Open
Priority: 3
Submitted By: Mat - (mat)
Assigned to: Nobody (None)
Summary: Screenshot / Multimedia data 
Category: Project Admin
Group: None
Resolution: None
Written For: v4.5.6


Initial Comment:
I needed this functionality on my Gforge installation, so I developed
the front-end part. The backend has bee modified to only accept images files (which mime-type starts with "image/"): bmp, png, jpg and gif (the only types that are understood by the PHP GD library).
I also added thumbnails generation, and they are also stored in the
database, but in another table (db_images_thumb).
The appearance has been copied on the SF site. There are no i18n, all the texts are in english. It just lacks a text when a project has no screenshot.

Some sql queries of the backend part wasn't valid: it missed the "FROM table" condition.

The database need to be modified:
* table db_images: a new field is added: thumb_id
* table db_images_thumb: the table which stores the thumbnail of all the screenshots.

It has been written for the 4.5.11 release, but it should work with all 4.5.* versions.


----------------------------------------------------------------------

You can respond by visiting: 
http://gforge.org/tracker/?func=detail&atid=106&aid=2567&group_id=1