Some developement info

[Pekka]

Hi,

Now I'm back to work at full speed for EE 1.5.

I have found a cure for problem where list page was slow when there were only couple of photos. I also have achieved a great speed increase when MySQL 4 is used (takes only 12-20ms for list page main query).

The fix posted for spaces in filenames and thumbnails size for Imagemagick works for Windows, but both refuse to co-operate in UNIX. I'll look into that.

Currently I'm fighting to increase speed of "all exhibitions combined" under mysql 3.23. Combined exhibition opens in my test gallery under MySQL 4 in 85ms, but in server with older MySQL it takes 7000ms or even more, even after careful code optimizing. I hope some hack can be found - the ways old MySQL 3 works are sometimes really odd.

Other bugs fixed now are...

- date sorting did not take clock into account
- view all, go to photo page, return to list: wrong pagination
- settings: order setting did not hold
- index page counter init missing

...among others.

The speed increase and IM filesize issue are main priority now and as soon as solutions to those are out with full translation pages, beta 2 will be too.

[iceman]

Great Job Pekka!!!

Another small thing:
On the "Set Default Photo Data" page, the drop down boxes for "Flash" and "Camera Support", do not seem to have selections available!

Thanks

[chriz]

I wouldn't spend too much time in coding for older PHP/mySQL combinations. I think it's the responsibility of the hoster to update serversoftware on a regular basis.

I could be wrong,

Chriz
BTW: I'm using www.opensourcehost.com and they are really great.

[gait]

This is a very great job Pekka! Keep on this good working! I like this script so much..

I am very curious for the final version, if I find also bugs, I will report them in the forum.

[Pekka]

More done:

- fixed a bug in photo move when thumb dirs are same between target and source exhibition.

- added: browser timeout counteraction added to ftp and copy/move/delete and export. I'm also thinking of adding a PHP timeout sniffer during execution, too so that it would not try to do more than it has time for in one go.

- fixed 'find size paths' sql bug in photo editor'.

- fixed a bug in 'show search, sorting and perpage' text in photo browser.

- "I don't know why, no matter what I tried, I cannot embed link in html format in the News." bug. Fixed.

- one click to "backup now" did file backup twice (interlaced data) when javascript was on. Fixed.

- empty upload temp from ALL files. Fixed.

- added: delete used files option to upload page

- added: mark clearer what photos are already in EE in upload page

-added a new concept: "lazy language". When a language is set as "lazy" it means all public interfaces are translated, but the database texts and info are taken from primary language. This lets you offer several user interface languages when you do not want or can not update all database data in those languages (i.e. when your Klingon has gotten tad rusty). Lazy languages can be edited normally in editors (this feature can be also used as hiding a language when inputting the database). Language menu will show text "UI only"(in english!) for lazy languages.

- EE Backup: an error message occurred when database name contained odd characters (e.g. "test_-_1"). Fixed.

[Pekka]

More done:

- a bug where uploaded photos were not marked as "in EE" right after upload. Fixed.

- added: previous/next buttons to photo editor photo selection list.

- added: filenames to photo editor photo selection list.

- missing flash and camera support dropdowns on default photodata editor. Fixed.

- added a keyboard shortcut ALT+S to access the language menu. This means you can use e.g. ALT+S and arrow up/down to change between two languages, or ALT+S and H to pick up hungarian language and ALT+S and F to pick up finnish language.

- added color coding to resize methods so that path editor and upload page match.

- removed tests.php completely. Built a new system for setting and storing graphics/php module status as on/off. This includes interactive test page for each module/library with inbuilt test image which contains exif and iptc. You can't miss with this one.

- unavailable resize methods are hidden in path editor.

- fixed a problem in html export page sorting by author.

- added slash info to path and ftp editors.

[chriz]

Are the changed files available for download ?

Chriz
http://ee.photoplus.nu

[Pekka]

chriz wrote:
Are the changed files available for download ?

Chriz
http://ee.photoplus.nu

No, I'm hoping to upload them on Wednesday.

More done:

-bug in "all exhibitions combined"- when clicking a photo is set to jump to next image: navigation errors. Fixed.

- added "guess" feature to camera, lens, owner, country, location in upload page. This 'guessing' is based on available EXIF and IPTC data, and EE rates the available database items for those found in photo data, with predefined emphasis on certain values. For example, EE guesses correct lens in database by comparing focal lenght and aperture to lenses on database; camera manufacturer and lens displayname are also used. But emphasis is put on focal lenght, where I have set prime lenses to override zoom lenses (e.g. 50mm is primarily guessed to be 50mm prime if available). A useful feature in location guessing is that EE will add the location if it is not found from db. All this data is retrieved from EXIF and IPTC, so basically you can type in all the needed data in Photoshop "file info" from header, description text and copyright data to location info and EE will apply the data to database during upload.

To further make lens guesses _very_ accurate I've been thinking of adding a tick mark: "preferred choice" to lens editor, this would give EE a hint of correct solution when several similar are found (e.g. IS and non IS variations of a same lens).

Next I'll add some switches:

- password dialog on/off.
- COMMENTS AND RATINGS ON/OFF GLOBALLY
- COMMENTS AND RATINGS ON/OFF PER EXHIBITION
- ALL EXHIBITIONS COMBINED: on/off switch
- auto refresh on/off by default

...and then complete language translations...
...and then add some listing items (best ratings, 10 latest in all...)

[Pekka]

- impossible resize method means now 'no image' (not source image as in beta 1).

- I would like to have ONLY Thumbnails and Microthumbnails be removed on EXIF info, is this possible? FIXED.

- as an extra security step because of more intelligent email viruses out there, photographer email is now confuscated by replacing @ and . with words.

- guess switches in upload page reflect to available modules

- added sorting info to list page when sort dropdown is hidden.

- improved style code functions a little (slight speed increase)

- as side effect of resolving the cause for speed problem of combined exhibitions overall speed is faster and also more stable. MySQL 4 gains most from new code.

- fixed translation functions for escaped characters in traslation arrays, as in "Harry's" - also improved translation code a bit.

- new translation feature: every translation item can have two choices, standard & image+text. This setting is used in following way:
when you want just the text you can use the old way:
$translated["featured_exhibitions"] = "featured exhibitions";
when you want to replace text with an image do
$translated["featured_exhibitions"]["image"] = "http://www.mysite.com/featured_exhibitions.gif";
$translated["featured_exhibitions"]["text"] = "featured exhibitions";
leaving image url empty will make EE use the text. The text part is used as mouseover for the image.

- removed analyze/repair link in editor - will be added again in release version.

- new string lenght truncate code to detail listing

- RATING OUPUT: new listing style for list.php for ratings - it reflects changes in category and exhibition. Three best of each category are displayed with thumb and info, and also 3 best of combined averages.

- editor title bar gives a wrong version... FIXED

- 'ee_camera_type' table is removed from database

- coded a simple solution for request: "Some visitors want to see the detail camera data and others don't, it would be nice to have an option on each individual image display to either hold a mouse over the image or select a button to see a popup of this info."

- multiarea navigation problems fixed (BY PROPER REMOVAL OF PROFILES IN IMAGEMAGICK AND SOME CODE FIXES)

- upload: spaces, quotes and hyphens in filenames converted to _ before upload

- upload: conflicting filenames renamed before upload, automatically

- editor index page has now commands to defragment database, and also optimize it (optimizes indexes to full speed)

- upload, photo input: filenames in headers: underscores are automatically converted to spaces.(does anyone need this to be optional?)

- in photo editor you can set default header (according to current default photodata settings) by emptying header and then pressing return (update).

- fixed some table border html problems in Opera and Mozilla

- some manufacturer-specific EXIF parsing, mainly for Canon in the beginning but all will be supported later.

- comment and rating editor: photo id link to photo editor does not work. Fixed.

- ee backup: added gzip online compression to file downloads when compress=1 (needs browser support - most of them do). This means at least 3 times faster downloads. Side effects are: download progress display in windows does not have correct time and size displayed, and start of download has a slight delay as server must pack the file first.

- EE has now a new html output system. You can now build your own layouts and "call" snippets of html to other pages. This change has been competed for list.php and photo.php, all other pages will follow. The method of building e.g. your own photo page from ee html components is done by a simple template php file, where you insert EE html components as php variables. This template method makes also possible to use conditions (if next button is not displayed, then place this image) and any other php code needed. Photo and list pages uses a separate template for NS 4.7x, and one template for export function. One template demonstrates how to a selection of thumbs from two exhibitions can be embedded into a external php page.

- The resize system is now fully editable, database-based. Thumb resize parameters can also be edited. Sharpening settings are editable, along with JPEG quality and profile removal. Imagemagick sizes can have user defined parameters. Imagemagick size preview.

- did couple of new styles and all old ones are updated.

- added translation items and made new translation functions

[gait]

Where can I download the newest version?