Add support for users to rate movies they've borrowed (or own).

Currently the reservation system could use some improvement.

Users can resevere a movie that is currently out. However, there is no notification of when the movie they reserved comes back in so they can actually borrow it. Additionally, without manual checks there is no way for an administrator to know that a recently returned movie is requested/reserved by another user.

Beyond all of this, the system does not allow multiple people to reserve the movie. If it is already reserved there is nothing you can do. Perhaps some sort of FIFO reservation system. So multiple people can request the same movie and notifications for them will trigger in order.

These notifications need to be automated. There are several potential hook points that can be used. For instance when a movie is returned an immediate check can be made to see if anyone has the movie reserved. If they do, display a notice to the user returning the movie (if they are an administrator) and/or send an e-mail to the admin/user that the movie is now available (possibly include a link to the movie).

When an administrator logs in, alert them of any pending reservations where the movies are currently available. This list should be grouped by reserving user. As should any reservation listing.

Add some means of linking movies together within a collection. For example some DVD's will contain two different movies on them. Or, perhaps we are dealing with an entire season of a show in one case/box. Additionally, it's becoming increasingly common to find bargian packages with several loosely related movies in a single case.

Add a link to list X most recent movie additions. This can be accomplished with the current DB scheme:

select movie_id, movie_title from movies_list order by movie_id desc limit 10;

Add a version variable to the database that can be checked by the scripts to detect if a database upgrade is necessary. This can then be used to automate the upgrades for users.

Implement some means of automatically checking for required capabilities. For the core this would be things like the presence of the adodb library. However, this should also include some mechanism for triggering and reporting on a module based check. For instance the movies module needs the coverart directory to be writable.