vdb:contrib
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
vdb:contrib [2007/04/14 02:55] – 203.214.12.235 | vdb:contrib [2007/04/14 07:59] (current) – old revision restored andi | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Additional Scripts ====== | ||
+ | |||
+ | [[vdb: | ||
+ | |||
+ | 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 the [[vdb: | ||
+ | |||
+ | ===== 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 [[http:// | ||
+ | |||
+ | ===== direxport.pl ===== | ||
+ | |||
+ | This creates single html pages from the movies in the database. It allows me to browse the database content with my [[http:// | ||
+ | |||
+ | ===== 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: '' | ||
+ | |||
+ | ===== tvtome.php ===== | ||
+ | |||
+ | To use this PHP tool call it from your webbrowser like this: '' | ||
+ | |||
+ | You need to enter the complete URL to the TV shows episode guide at tvtome (eg. http:// | ||
+ | |||
+ | After you press the " | ||
+ | |||
+ | You need log in with administrator rights to use this tool in [[vdb: | ||
+ | |||
+ | ===== dvdadd.pl ===== | ||
+ | Use this Perl script to read data from your DVD drive and create an entry in videoDB from it. | ||
+ | |||
+ | Supports: language, video width and height, dvd title, audio format and channels. Newer versions support subtitles. The lsdvd Unix tool is required to read the DVD. | ||
+ | |||
+ | ===== lookupbarcode.php ===== | ||
+ | This script is very handy for people with barcode readers, and a large DVD/VHS collection. Just call it from your webbrowser like this: '' | ||
+ | |||
+ | If you are in [[vdb: | ||
+ | |||
+ | ===== mklist.php ===== | ||
+ | |||
+ | //note: this isn't part of the official ditribution and only added here// | ||
+ | |||
+ | replacement for the mklist.pl if you like to prefer php. | ||
+ | |||
+ | <code php> | ||
+ | <? | ||
+ | |||
+ | //csv dump file (with tabs) . | ||
+ | header(" | ||
+ | header(" | ||
+ | header(" | ||
+ | header(" | ||
+ | |||
+ | $user = ""; | ||
+ | $password = ""; | ||
+ | $dbname= " | ||
+ | $tablename =" | ||
+ | |||
+ | // localhost is the default database for most servers, you might need to change yours if it doesn' | ||
+ | $global_dbh = mysql_connect(" | ||
+ | |||
+ | mysql_select_db($dbname, | ||
+ | |||
+ | // you do not need to change the function | ||
+ | function display_db_table($tablename, | ||
+ | { | ||
+ | $query_string = " | ||
+ | $result_id = mysql_query($query_string, | ||
+ | $column_count = mysql_num_fields($result_id); | ||
+ | echo " | ||
+ | while ($row = mysql_fetch_row($result_id)) | ||
+ | { | ||
+ | for ($column_num = 0; | ||
+ | { | ||
+ | echo " | ||
+ | } | ||
+ | echo " | ||
+ | } | ||
+ | /*echo " | ||
+ | } | ||
+ | |||
+ | display_db_table($tablename, | ||
+ | |||
+ | ?> | ||
+ | </ | ||