Rob's Film Database

http://www.click-profits.com/code/filmdb

This is the second film management system I've built for a home media server.
The first one was very basic and you had to enter the film into the database manually each time you wanted to add a film.
It worked for a while, but in the end became a pain in the ass to update, and the IMDB lookup stuff broke because IMDB changed their site.

So, now in this new version I've started with a fresh slate, and brought in quite a few additions:

• Automatic Folder scanning
• Improved IMDB lookup including image downloading
• Built in divx web player
• More easily customisable
• Supports FTP for file access

Please note that this system was designed on and built for windows servers. On a linux server it may not work correctly.
I hope you enjoy using it, but remember that this is free software and is not supported or guaranteed whatsoever.
I have tried to ensure it is free from errors, but use it at your own risk.

If you have any comments or suggestions you can get in touch through my website here.

Rob

======= Download  ========

Current version: 2.03 - 28/04/09

Robs_Film_Database_v2.03.zip

Changelog:

• Added poster file caching system to increase speed
• Modified search to seperate exact and partial matches
• Removed poster thumbnails from search results
• Fixed a layout bug for films with long plots
• Added Category system for genre keywords/tags

Previous versions

Robs_Film_Database_v2.02.zip

• Added manual update for incorrectly tagged films
• Added browse by posters function
• Added page number system for film list
• Added poster thumbnails to search results

Robs_Film_Database_v2.01.zip 30/12/08

• Fixed IMDB lookup function which was not returning poster images after an IMDB update.
• Upgraded IMDB class to deal with movies that previously weren't found because IMDB directly transfered the search query to the movie page.
• Dealt with movies using ampersands in the title.
• Updated no-poster image.
• Modified year Lookup for titles where imdb has quirky additions, eg (2008)/I.
• Added list order-by functions.
• Added "I can't decide" random poster browser.
• Expanded search function.

Robs_Film_Database_v2.0.zip

======= Demo ========

There is a demo online here which is running on linux. Linux servers appear to be fine except for being able to read the filesize & modified dates correctly. Bear in mind the video names don't line up the the actual video. I wasn't going to upload whole films just to test it.

Demo

======= Installation Guide ========

1. Unpack the contents of this zip file to a temporary location.

2. Check you have the following files:

• index.php - main database manager
• config.php - system configuration settings
• poster.php - displays film artwork images
• update.php - scans film directory to add/remove films from the database
• install.php - sets up the required mysql database
• style.css - website layout stylesheet
• /img/ - folder containing site images:
• /img/bg.jpg
• /img/bgfooter.gif
• /img/bgmain.gif
• /img/dwp-l-s.gif
• /img/header.jpg
• /img/noposter.gif

3. Edit configuration file

• Open config.php in a text editor like notepad, (or notepad++ is much better)
• Enter your MySQL server details
  You have to enter your server address, username & password.
  If you have already got a database ready, enter that as well.
  If you have not got a database ready, enter the name you would like to give it.
• Enter your film directory location.
• Set $split appropriately for your film filenames.
• Edit other details if required.

4. Upload the files to your server

5. Browse to /upload directory/install.php

• This will set up the database with the appropriate tables.
  If any errors are shown, check your config file.

6. Delete install.php

• For security reasons.

7. Browse to /upload directory/update.php

• This will allow you to scan your film directory for files.
• It is suggested that you test this on a small number of files initially
  to make sure your settings for $split and $filmdir are correct.
  Once you are happy with the config, you can use it on your whole collection.

8. That should be about it! Browse to the /upload directory/ to view the DB.

===================================

http://www.click-profits.com/code/filmdb

===================================