changelog +--------------------+ | + new | | * changed/improved | | - bugfix | +--------------------+ 0.1 [??.12.03] everything quite experimental... yet mostly working and already good-looking :) 0.2 [27.12.03] + advanced search function added + info screen added + now picture and not only pict url is inserted into db, since imdb does not allow direct linking to its pages; script to fetch pic from imdb pages added. (for preview and db insert) + comment field added for movies * sort-function (javascript on main page) improved, now doesn't sort by same column more than once * filter improved, changing sort order does not clear filter and vice versa - lots of small bugs fixed, lots of small face-liftings, lots of small improvements 0.21 [02.01.04] * imdb has a new search method! :( movies are no longer listed by categories, but by 'exact match','partial match', 'approximate matches'. search-urls changed as well. imdb-files(fetch_movie, fetch_person, fetch) updated. + 'aka' variable added to fetch_movie, is inserted into comment field. when searching for titles no search is done for a.k.a. titles, for efficiency reasons. maybe a separate field 'aka' in db would be appropriate. - some minor fixes in html output. 0.3 [13.01.04] + pdf export of movie list added! 0.31 [17.01.04] + 'print movie' dialogue added; media to be printed, sort order can now be selected in a form. * insert/change movie form: now uses javascript/DOM to add extra fields; no reload needed 0.32 [11.02.04] + 'overall db size' field in info screen added (MySQL >=4.xx only) + alt=".." tags added to images * main page buttons: transparency added where necessary - 'no picture' problem with older php versions solved - mysql error msg when deleting movie - problem fixed - php warning when inserting/updating movie with no director/writer/actor fixed - some mysql compatibility issues solved 0.33 [22.03.04] + edit/insert mode: change poster by clicking on it (url or file-upload) + last search results and poster image are now cached for faster navigation. also, added possibility to cache imdb-pages for faster retrieval. * script for getting images rewritten * folder structure changed; password protected files are now in 'members' folder, so they can additionally be protected by a .htaccess file or similar * all configurations (except for db connection) now in one file: config/config.php - a few javascript bugs and 'undefined variable'-warnings patched 0.33.1 [05.04.04] + favicon added - poster deleted on update: bug fixed 0.33.2 [21.04.04] * people/movie keys changed from VARCHAR to MEDIUMINT, since this saves a few bytes - problems with chunked html data: fetching improved - title or year sometimes not fetched - patched 0.33.3 [18.05.04] - script hangs when getting movie info from imdb-problem fixed - errors when fetching persons from imdb fixed - errors in search function corrected - image: MIME type is now outputted correctly 0.33.4 [04.06.04] * tweaked some javascript of the search function - fetch error on 'direct hits' on imdb fixed - ONCE AGAIN, imdb had to change their pages... poster was not fetched anymore, fixed this one too. they're really giving me a hard time :( 0.4 [13.10.04] + genre support added, search/browse functionality for genres + full-text search for titles + movies are now stored with own (not imdb) key as pk, so the same movie can be inserted several times (e.g., for series) + search function rewritten, search now more powerful and much faster for some queries * lots of changes to the database, new column 'a.k.a. title' added, several column types changed * config file reorganized - display: footer now stays where it is supposed to (even for that piece of shit internet explorer) - html output: (almost?) everything should now be as defined in w3c standards - and lots of other small improvements and fixes 0.4.1 MU [02.01.05] * database movie table split into movies_d and movies_u to take up less space + transaction table added to track movies that are loaned out to another user + buddies table added to store people as your buddies + cities table added to have lat long info for city codes to be able to develop distance info for users who loan videos out (US cities provided, others to come) + logins table added to allow user accounts for the multi-user environment + # lines to display per page setting is now controlled at the user level + rating system to rate a user on the transaction (both ways) + tooltip display of user ratings, msgrs used, and number of videos loaned/borrowed total + tooltip display of movie cover (enabled or disabled in user settings) + email system that will not divulge user email address's unless they desire it. + email system to send emails to buddies when users add movies + email system also tracks transactions so status is always known + email system with html or text emails (enabled or disabled in user settings) + users can enable / disable the email notificfation + video loan system has shipping costs which include refundable amount, base amount (all videos charged), and per mile amount + added ability to limit the distance for video loaning - if you set 20 miles no one 20 miles or greater from you can borrow your videos + privacy setting: [public] all can see collection, [users] all users logged in can see collection, [buddies] only buddies can see your collection + ability to share your collection using a single hyperlink (collection must be public) + comm panel allows emails, shows status of msgrs, allows people to invite others by email address + paypal system used to charge people for video shipping costs or you can allow a free transaction for close friends + User levels: [1] new user, view only his/her collection, no buddy system, no email, no video borrowing or lending. [2] added ability to see others movies [3] adds ability to have Buddies and use Comm Panel [4] [future use] [5] admin user adds ability to manage user accounts. 0.4.1a MU [30.01.05] - missing files added to /docs/ folder 0.4.1b MU [02.02.05] - imdb support updated. 0.4.1c MU [02.02.05] - '*** currently in development...' message removed 0.4.1d MU [14.03.05] - added code to config.php and global.php to fix the email problem. 0.4.1e MU [20.03.05] - added code to update.php to fix the non updating issue. 0.4.1f MU [09.05.05] - changed code in several files to fix the editing of video titles (and more) - added config item for security level allowed to edit titles (and more) 0.4.1g MU [17.05.05] - fixed update.php so that updates are correct and do not give the error: "duplicate '000000' for key 1" More to come: 1. Fix Email issues 2. I am developing a user interface that allows users to synchronize a collection and manage it offline if necessary. 3. Multi-Language version