Table of Contents

Additional Scripts

General

VideoDB comes with some additional Scripts to do certain tasks, using them is completely optional and not needed for a functional VideoDB. All these files are stored in the contrib directory.
Some of them are written in Perl and you have to edit them to match your database auth options. Some knowledge of Perl and SQL may be helpful.

If you wrote something you think others could find useful just send it to me (andi@splitbrain.org) or join the Developer Mailinglist and post it there.

mklist.pl

This generates a plaintextlist of all files in the database. Edit the variables at the top

setGenre.pl

This script is useful to set the same genres for a bunch of entries based on their title. For example setting all Simpsons episodes to Animation and Comedy. You have to edit some variables at top of the file to make it do what you want.

videoadd.pl

This tool is very useful to automatically add some videofiles to the database. It mounts your CD-ROM drive, searches for video files, tries to guess the title and some other infos from the filename and adds them to the database. It uses mPlayer to extract video informations from the file. It accepts the path to your CD-ROM drive as argument.

direxport.pl

This creates single html pages from the movies in the database. It allows me to browse the database content with my IR File Chooser tool.

langcheck.php

This PHP tool checks all language files for missing translations and displays the missing keys. This is useful for Translators. Just call it from your webbrowser like this: http://myserver.com/videodb/contrib/langcheck.php

tvtome.php

To use this PHP tool call it from your webbrowser like this: http://myserver.com/videodb/contrib/twtome.php. This tool can fetch episode infos from www.tvtome.com and add the data to the episodes in your VideoDB.

You need to enter the complete URL to the TV shows episode guide at tvtome (eg. http://www.tvtome.com/Futurama/guide.html for Futurama) and some Searchstring to select the episodes of this show stored in your VideoDB (eg. Futurama* to find all movies with their titles beginning with Futurama)

After you press the "submit query" button the tool fetches the episode guide and lists all episodes. For each episode you have to choose the matching movie in your VideoDB. The tool tries to suggest the matching title based upon an similarity comparison. For each episodes data you want to import you need to check the checkbox. Then pressing thefinal submit button the selected data is imported.

You need to have Admin rights to use this tool in multiuser mode.