PHP script for searching thru a MovieTrack database or a Ant Movie Catalog XML database and list the results nice and neat on the web. :)

WebTrack supports BOTH MovieTrack database 3.2, 3.3.x formats and Ant Movie Catalog 3.5.x.

For details how to install, read Here!

Just type the URL in a web browser and search away. :) * = List ALL entry's! Note: Listing all movies in a large database may take some time. The average "time out" in a PHP environment is usually 30 seconds. Therefore the listing can sometimes not be completed. Limit your search to get a smaller number of hits.

Search from left only - Checkbox
To search anywhere in the field just uncheck the "Search from left only:" checkbox. When the checkbox is unchecked the program takes your keyword and compares it to the complete field instead of only from left to right. Ex: if you search for "aran" in the actors field with the box checked. You will get back all movies with an actor that stands in the most left position of the field and have the string "aran" in the beginning of he's name (most certainly none. :). But if you uncheck the box you will get all the movies with an actors name anywhere in the field containing the string "aran". Ex: Quentin T->aran<-tino. Are you with me? :)

Search in last results - Checkbox
If you check the "Search in last results:" checkbox, the next search you do will be done in current displayed results from last search.

The "view" selections - Selector
There are 3 different views you can use to show your movies in.
1. "Full view": When you select that one all your titles in your search result will be displayed with full details.
2. "List view": Select this one and your titles from your search will be listed with one title on each row, showing just some information and there by making the list quite compact. Hovering over the titles picture, name, grade will show a small popup with some more information. Clicking the title will bring up the full view of the clicked title.
3. "Covers view": When this is selected your titles covers from your search gets listed only and also here a "popup" shows a bit more details when hovering over the picture. Click to get full view of the clicked title.

AND - OR
You can also use "AND" or "OR" in search field.
For example search for actor Pitt AND Norton and you will get all titles containing both the actors. If you use the OR option instead you get all titles containing one or both actors.
You can add as many ANDs in each search as you want. And the same goes for ORs of course. :)
You have to type the operands in CAPITAL letters for it to work. I made it that way because titles and other things may contain the words.
Note: It is not possible to use both operands in the same search.

Too many hits...
If the maximum number of results is hit, just press "search" again and the next maximum numbers of results will be displayed and so on.
However, if you use the AND function, the first search will limit to the maximal number off hits to do the AND search in. This means that if you search for something and that first search gives more then the defined number of hits, the next "search" in your AND chain will only search in the first maximum result.

The loan list
The loan list function is for your friends that want to borrow titles from you. Remember to make the titles "Absent" when you have lent them to someone. If a title status are set to "Absent" it is not possible to add it to a loan list until its "Present" again. A mail will be auto generated with an URL inside that lists the titles someone have selected. The mail will be sent to your pre defined e-mail address.

Make DOS-backup script
The "Make DOS-backup script" function is for you to be able to make backups of selected titles. What you need to know is that the titles have to have the "file path" defined in the database, still be located at the same place on the harddisk or at the same UNC path as they where when you added them (or an up to date path of course). I most definitely recommend you all to use UNC paths and that the server has access to the actual files for this to work the best. If your server don’t have access to your files, the making of the DOS-backup script is a little bit of ”guessing”. The script have to look at the path and se if the 4rht character from end is a "." and if that’s the case the scripts assumes that it is a file. If its not it assumes it is a directory. When the server have access to the files it “reads” the path and checks if it exists and then makes the script based on that fact. When adding paths to you database, it’s definitely a good idea to use UNC paths Ex: \\Server\share\movie folder\movie.avi This is because all PHP scripts "runs" on the server and there by may not have the same "paths" as the client have when you are adding movies. Then again. If you have MovieTrack installed on the same machine that you use as webserver, this is not a problem. :)

Tips
Due to different character setups in Windows and DOS environment I recommend to ONLY use "normal" characters in filenames and folder names. If you use "special" characters in filenames and folders you will get an error when running the DOS-Backup script.

In the search field you can type the following shortcuts:
Readme = To display the Readme.htm help file (this file).
Help = To display the Readme.htm help file (this file).
Install = To display the How-to-Install.htm help file.
Localinstall = To display the How-to-install-a-local-web-server-and-WebTrack.htm help file.
Skinhelp = To display the How-to-create-your-own-style-profile.htm help file.
Titleshelp = To display the Manage-titles.htm help file.
Usershelp = To display the Manage-users.htm help file.
Hist = To display the History.htm file.
Stats = You can select any field except "Movie title", "AKA Title" or "MTDB Number" (theses fields are unique for each movie and there by no meaning of generating statistics by) then type "stats" in the search field and hit search. For example, select "genre". A statistic list (by percent) will be displayed with how many titles containing different types of genres. Very nice.
Latest #(-#) = To display the latest added titles. If you only type "latest" you will get the default number of latest added titles, this value is defined in the config.php file. But, you can also use any value you want ex: "latest 100". You will then get the 100 latest added titles, type "latest 6-10" and you will get the latest 6th to latest 10th titles listed...
Listnr #(-#) = To display the title with that mt number or those numbers.
Random (1-200) = Will randomize movie titles from your database. If you only type "random" one title will be displayed, if you add a number after like this: "random 10", 10 titles will be randomized and displayed. Maximum 200 titles can be randomized at once.
Version = To display all file versions of all files in WebTrack (Profile files NOT included)

To fit the DVD or CD cover in to one paper you have to go in to "Page setup..." in IE and change the margins to as little as possible (just type 0 in all the margin parameters) and change the orientation to "Landscape". Another thing that is good to know is that to be able to keep the size of the covers. I cut some of the Title, Plot and Actors list if necessary. That's why it sometimes changes to "..." in the end of one of these. If I don't cut them, the table will stretch and the cover will not physically fit anymore. :)

Use this “tutorial” if you want to make your own skin profile with your own personal look. This is how you do it from scratch (almost). Some basic HTML knowledge is a good help here... :)

To edit the language file, just surf to the webtrack/language page and star translateing When done press "Create / Update" and your current style profiles language file is updated. If you want to download the new language file, tag the checkbox and your file will be downloaded instead. If the default language file is not found in current style profile, the default english language file will be used instead. Remember, all style profiles have it's own language file. So, each time you change style profile, it is that language file you update if you then go to the webtrack/language page. You can change the name of the default language file in the update page. But then you have to change the names on all the style profiles language files. Otherwise WebTrack will not find the language file for the current profile and will use the default english one instead. When translating to a new language, it is a good thing to translate not only the text in the language file, also translate all the text in the templates. Then you have made a complete translation of a style profile. :)

You can add whatever file you want in each "trailer dir" and you will automatically get a link to it. Trailers or any other files you want each movie to link to. :)

External Trailer-link-file support:
Save a file in the trailer dir containing URLs to any trailer or whatever you want. Every link in the file will then show up as a link in the "trailer list". Default filename for the url file is "externurl.txt".

In the test version the link to "www.snille.net" under the movie "2 fast 2 furious" is is extracted from the externurl.txt file in the trailer dir. With in the externurl.txt file you could point to a place containing the complete move, just enter the URL or UNC path. Or if you want both trailers and other files just add all the URLs and/or UNC paths in the file. :)

You can now "Export" your database. Just go to webtrack/export.php and select what format you would like to export to. The export function is not yet complete. Later on a possibility to select what fields go where in the exported file will be possible.