Recent Posts

Pages: 1 ... 4 5 6 7 8 [9] 10
81
Scripts and Templates / Re: Some usefull SQL scripts in PVD
« Last post by Ivek23 on December 23, 2023, 08:29:08 am »
Quote from: afrocuban on December 22, 2023, 11:20:10 pm
Related to http://www.videodb.info/forum_en/index.php/topic,4134.msg21969.html#msg21969

The query has to be
Code: [Select]
update PEOPLE set "url"=replace("url",'http://imdb', 'http://www.imdb');

Of course, I just gave the movies as an example, but you can decide for yourself what you need it for.
82
Support / Re: .BATCH files
« Last post by afrocuban on December 23, 2023, 01:58:30 am »
Instead of using two scripts manually in the context of recent IMDb search and IMDb _2b scripts, You can consider using batch plugin while scanning file. Since I'm using AllMovie and FilmAffinity as well, this is how my batch looks like:

Code: [Select]
NAME=Imdb_Search+AllMovie+FA+IMDb
DESC= Imdb_Search+AllMovie+FA+IMDb
TYPE=2
EXECUTE=Imdb.com[EN][HTTPS]_Search.psf|AllMovie.com[EN][HTTPS]_ b.psf||FilmAffinity_[EN][HTTPS].psf|IMDB_[EN][HTTPS]_TEST_2b.psf|
Running IMDb search first is crucial since at the moment it doesn't work if any other link is found in the URL field prior to script running.


This way you run all the scripts in one take, instead of 4 takes for each script.
83
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by afrocuban on December 22, 2023, 11:36:59 pm »
Update:

it works with only http and not https url?! How come _2b works with https in the url?
84
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by afrocuban on December 22, 2023, 11:32:06 pm »
Quote from: Ivek23 on December 22, 2023, 09:04:14 pm
Use SQL script if you are missing this part in the url: www.

More at the link below.

http://www.videodb.info/forum_en/index.php/topic,4087.msg21968.html#msg21968

It updates links with http://www.videodb.info/forum_en/index.php/topic,4087.msg21971.html#msg21971
but still



Quote from: Ivek23 on December 22, 2023, 08:21:20 pm
Change this part of the code, maybe the script will work with the url, but the search results will still not work.
Code: [Select]
  SEARCH_ENGINE  = True ;  //If there isn't provider search results, try with Bing search engine
  //SEARCH_ENGINE  = False ;  //If there isn't provider search results, try with Bing search engine
But now I know what's wrong and why can't stand anything. You are missing http://www.imdb.com/name/nm0000080/ in the url address. I will fix this in the new script version


gives nothing, although now link is "proper", with www. Same log as above, now with Stored URL is:https://www.imdb.com/name/nm0000080/||. To remind, _2b works flawlessly with url provided.
85
Scripts and Templates / Re: Some usefull SQL scripts in PVD
« Last post by afrocuban on December 22, 2023, 11:20:10 pm »
Related to http://www.videodb.info/forum_en/index.php/topic,4134.msg21969.html#msg21969

The query has to be
Code: [Select]
update PEOPLE set "url"=replace("url",'http://imdb', 'http://www.imdb');
86
Scripts and Templates / Re: Some usefull SQL scripts in PVD
« Last post by afrocuban on December 22, 2023, 11:03:00 pm »
I have this problem with some urls from the times IMDb script wasn't updated for a long time before _2b:


Code: [Select]
http://www.imdb.comhttps://www.imdb.com

So I guess this should help?


Code: [Select]
update MOVIES set "url"=replace("url",'http://www.imdb.comhttps://www.imdb.com', 'https://www.imdb.com');
87
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by Ivek23 on December 22, 2023, 09:04:14 pm »
Use SQL script if you are missing this part in the url: www.

More at the link below.

http://www.videodb.info/forum_en/index.php/topic,4087.msg21968.html#msg21968
88
Scripts and Templates / Re: Some usefull SQL scripts in PVD
« Last post by Ivek23 on December 22, 2023, 09:00:47 pm »
Use this SQL script if you are missing this part in the imdb url: www.

Quote
update MOVIES set "url"=replace("url",'http://imdb', 'http://www.imdb');

Instructions on how to use the SQL script are in the first post.

Here you have some more similar SQL scripts.

Quote
update MOVIES set "url"=replace("url",'http://httpbin.org/response-headers?key=http://www.imdb', 'http://www.imdb');

Quote
update MOVIES set "url"=replace("url",'http://httpbin.org/response-headers?key=https://', 'http://');

Quote
update MOVIES set "url"=replace("url",'http://httpbin.org/response-headers?key=', '');
89
Support / Re: Personal Video Database 1.0.2.7 MOD
« Last post by Ivek23 on December 22, 2023, 08:21:20 pm »
Change this part of the code, maybe the script will work with the url, but the search results will still not work.
Code: [Select]
  SEARCH_ENGINE  = True ;  //If there isn't provider search results, try with Bing search engine
  //SEARCH_ENGINE  = False ;  //If there isn't provider search results, try with Bing search engine
But now I know what's wrong and why can't stand anything. You are missing http://www.imdb.com/name/nm0000080/ in the url address. I will fix this in the new script version
90
Support / Re: IMDb
« Last post by afrocuban on December 22, 2023, 08:17:14 pm »
I got some diagnose. Please check what is happening if any url is stored in the url field and running IMDb search after that:


Code: [Select]
(12/22/2023 8:19:44 PM) Compiling script: Imdb.com[EN][HTTPS]_Search_adv.psf
(12/22/2023 8:19:44 PM) Script compiled successfully: Imdb.com[EN][HTTPS]_Search_adv.psf
[Hint] (501:2): Variable 'CURPOS' never used
[Hint] (501:2): Variable 'ENDPOS' never used
[Hint] (502:2): Variable 'TMP' never used
[Hint] (502:2): Variable 'SEARCHSTR' never used
[Hint] (499:10): Variable 'Result' never used
[Hint] (594:2): Variable 'DEBUG_POS1' never used
(12/22/2023 8:19:44 PM) Executing script binary
(12/22/2023 8:19:44 PM) Logging in...
(12/22/2023 8:19:44 PM) Called GetCodePage
(12/22/2023 8:19:44 PM) Called GetCurrentMode
(12/22/2023 8:19:44 PM) GetCurrentMode: Search
(12/22/2023 8:19:44 PM) Called GetDownloadURL - Mode: 0
(12/22/2023 8:19:44 PM)  * DownloadURL:
http://www.filmaffinity.com/en/film220449.html || * Mode: 1
(12/22/2023 8:19:44 PM) Called GetBaseURL
(12/22/2023 8:19:44 PM) Searching movie information for: Luxembourg, Luxembourg
(12/22/2023 8:19:44 PM) Called GetCurrentMode
(12/22/2023 8:19:44 PM) GetCurrentMode: Normal
(12/22/2023 8:19:44 PM) Called ParsePage - Normal Mode
(12/22/2023 8:19:44 PM) Called ParseMoviePage
(12/22/2023 8:19:44 PM) Called GetMovieTitle
(12/22/2023 8:19:44 PM) GetMovieTitle:
(12/22/2023 8:19:44 PM) GetMovieTitle =>
(12/22/2023 8:19:44 PM) Called GetMovieYear
(12/22/2023 8:19:44 PM) GetMovieYear =>
(12/22/2023 8:19:44 PM)  * Provider data info retreived Ok in 2023-12-22 20:19:44| (~Updated~)
(12/22/2023 8:19:44 PM) Finish
Pages: 1 ... 4 5 6 7 8 [9] 10
anything