Personal Video Database alternate Forum

Quote from: VVV_Easy_Programing« on: 28 January 2017, 20:10:45 »

Hello,
there are sometimes that the script is not a good tool for arrange PVD. Happily we have the possibility of use SQL scripts.

First you must start  PVD in Debug Mode (viddb.exe -debug) and then you have in Menu->Help->SQL where you can run a SQL Script (tick the box if the script have several lines).

I publish two examples easy to understand:
1) Now I have problems with IMDB[EN] and the original title (give me a false string 'var ....'). I can solve easily the problem running:
                  update MOVIES set "origtitle"="title" where "origtitle"='var ue_t0=window.ue_t0||+new Date();';
or
                  update MOVIES set "origtitle"="title" where SUBSTR("origtitle",1,3) = 'var';

2) Some strange chars appears in the people IMDB url. I use:
                  update PEOPLE set "url"=replace("url",'?ref_=tt_ov_dr', '/');
                  update PEOPLE set "url"=replace("url",'?ref_=tt_ov_wr', '/');

I anime to all to publish here their own SQL scripts for PVD.

Quote from: pra15« on: 06 November 2020, 00:25:55 »

A variant, a small script to import several images from a local specific folder.
You can choose, change the extensions and the filenames in the options, see the script.

Quote from: Einar« on: 11 April 2011, 19:57:53 »

Hello.

On the basis of the script that imports movie information from a text file I wrote a little script to automatically import posters from movie folders, but with the following restrictions. The poster file has to be within the same folder as the movie and the filename needs to be the same as the movie filename.

So here it is (see attachment), just for the case that it might be helpful to anyone.

Greetings,
Einar

Quote from: pra15« on: 11 November 2020, 17:27:03 »

If you use different urls for the same movie the script returns the list of the different sites.

Options :
IF_XML :    If True :The script use AddFielValueXml to return the value.
         If False : The Script use AddFieldValue to return the value.
         
USUALS_SITES :    Adapt to your choices. It's the list of site you often use. Keep always Others at the end of the list.
            The script search values in this list for the left to right, so the result return always a left value first if found.
            If the site is not found in the list he is put at the end of the result.
            ex : http://www.imdb.com.aaaaaa https://www.blabla.ru.fgfgfg https://www.filmaffinity.com.ttttt
               -give : Imdb / FilmAffinity / Blabla if the list is 'imdb,filmaffinity,others'
               -give : FilmAffinity / Imdb / Blabla if the list is 'filmaffinity,imdb,others'
               
KEEP_DUPLICATES :   - If true The result contain several value of the same site.
               - If false only one is present on thr result.
               ex: http://www.imdb.com.aaaaaa http://www.filmaffinity.com.fffff http://www.imdb.com.bbbbb
                  - give : Imdb / Imdb / FilmAffinity if true (with imdb at left of filmaffinity in list)
                  - give : Imdb / FilmAffinity if false.
               To Keep true can be useful to find duplicate or ancient urls no longer use.
               
DESTINATION_XML & DESTINATION_INT : You can choose the destination field of the result with the name or integer value.
[/quote]