List of features I have already implemented in AMCphp SQL Edition:
- Web-server doesn't save all movie-catalog in "php-sessions" - it's useless with SQL-database, which outputs data faster than PHP loads from its sessions
- Almost all data-fields (not only actors/directors/categories) have internal, correctly parsed, data-separators: e.g. "-" for countries, "/" for languages, subtitles, audio/video-formats, etc...
- "Combined search" works also by translated titles, countries, categories, languages, years & optionally by comments, descriptions
- 6 new types of reports: by countries, languages, categories, adding dates, video- & audio-formats
- More information in reports and all movies linked with their descriptions
- 6 new types of diagrams: by languages, adding dates, runtime, filesize, video- & audio-formats (each diagram at different page)
- More intensive content-linking - added: by years, countries, categories, languages, subtitles, adding dates, video- & audio-formats
- Modified "letters-frame" contains 2 strings of letters: for native and original alphabet (customizable in language-files)
- In "categories-frame" number of movies in every category shown
- Highlighting java-script in movie list works much faster and cursors's style changed to "hand" (typical for links)
- Special arrows in header of movie list show order and field of sorting
- AMC doesn't export picture names to SQL... so they are generated automatically by template according to customizable picture prefix and extension (all pictures may be even on another web-host)
- Empty fields don't showed in movie's detailed view
- Some bugs fixed: no warnings anymore even with error-checking enabled
And about size...
Main goal was not to reduce size of code, but to make it more modular: repeating code moved to functions, repeating files combined, etc... So, it is easier to modify.
Some of extra features I'm planning to implement in the future:
- Customizable lists of shown fields in "movie list" and in "detailed view"
- Optional features for registered users: personal list of favorite movies, list of seen/not seen movies, comments and ratings for each movie, possibility to add extra URLs for movies (e.g. "mirrors")
- Tool for automatical screenshots-making and adding to movie descriptions
PS: Release (without extra features) will be in 2 days...