You know, along similar lines, I was thinking of writing a program that would have a list of all of my videos and movies, in sort of a database arrangement, then you could search by title ot some sort of tagging, and then have it kick off VLC to play the movie. Any thoughts? Mike
Ideas? I would divide it into three sections. First - find and describe. The program goes through individual subfolders (or the whole disk, but there will be complications with access rights to some folders), so I would rather choose to browse the subfolders of the specified folder, we can read ID3 (this would of course adapt), we can write in the field the path to it specific file and if there is a photo in that folder, it is possible to take its path and binary content. So if somewhere in the subfolder there will be MP3 files (for example), it will be specified that the folder name is the name of the album, mp3 files will contain an ID3 tag, all this data can be collected in a huge database. In this case, it is very easy to assign a time to each track, for which there is a built-in function directly in the QB64. Same with movies. For detailed information on all film formats, it would be necessary to study the way of writing the heads of these film formats, then it would be possible to obtain both the resolution of the films, perhaps the type of soundtrack inside, but mainly the total length of the film. I haven't done this before.
This is the first part. How to get information, what information and from what sources.
The second part - how to save this information. Is enough a huge text file, which is full of links to specific files on disk? Or rather a binary file where photos (photos from individual albums or movies) will be stored? Or save it as a database? Some programmers talked about mySQL here, could it be used? (I have no experience with that).
The third part - how to view it. Should it be a line list where, after pressing enter, a specific movie/music starts immediately, or should each item be in the whole window, with a photo, with a sample and with the option to insert a description? All this can be written with QB64. Depending on the complexity, it will also take so much time.
What I would be most interested in personally is the way how convert
text database to Excel and how to set the borders of individual cells there. Also, how to lock the header, or which external library use for this convert.
And finally. Updates. Printing. Options to sort by file date, or alphabetically in descending or ascending order. There are many things that can be implanted in this.
I will try to write a program that will create a list of movies and music. When it's done, I'll add it to the forum to own thread.
