English > Support
Personal Video Database 1.0.2.7 MOD
VVV_Easy_Programing:
I have found different url formats versions in my PVD too?
Can we write a fast url standards?
My proposal is (remember that we cann't use httpS):
IMDB Movie (finish with '/'=Slash):
* Movie=http://www.imdb.com/title/ttxxxxxxx/
* Person=http://www.imdb.com/name/nmxxxxxxx/TMDB (NO finish with '/'=Slash):
* Movie=http://www.themoviedb.org/movie/xxxxxxx
* Person=http://www.themoviedb.org/person/xxxxxxxFilmAffinity (finish with '.html', maybe spanish (several countries) or english):
* Movie Spanish= http://www.filmaffinity.com/es/filmxxxxxxx.html
* Movie English= http://www.filmaffinity.com/en/filmxxxxxxx.htmlBTW, in the last times of imdb.dll pluging it retrived bad movie and people url (for instance for directors with URL+'?ref_=tt_ov_dr' and writers URL+'?ref_=tt_ov_wr'). In that moment I wrote a little SQL script (you can use it in debug PVD mode in one hidden option of Help menu) in order to correct the database:
update PEOPLE set "url"=replace("url",'?ref_=tt_ov_dr', '/');
update PEOPLE set "url"=replace("url",'?ref_=tt_ov_wr', '/');
perhaps it may help to correct something.
--- Quote from: afrocuban on October 01, 2018, 11:59:10 pm ---I just wanted to ask if it's possible FA to have it's own rating custom field?
--- End quote ---
In the next MOD version I will include the solution that Ivek was advancing
AddCustomFieldValueByName('FilmAffinity_Rating',ItemValue);
because it doesn't nothing bad for the "normal" users but you need add by yourself this Custom field.
BTW, I have included several 'hidden' Custom Fields of Ivek23 in the scripts.
Ivek23, perhaps can be useful for other users open a new Thread with the information "Possibles improving Custom Fields" working in MOD version, how is the information and how add in the PVD database.
afrocuban:
Thank you for your feedback, guys. Good to know that I'm not the one who messed up database, since you two have also people duplicates. Thanks for FA rating and all "hidden" custom fields.
I tried your SQL script in debug mode, cause I also notice mistakes in imported urls. Thank you for that. It didn't want to run with "As script" unchecked (some dynamic error...) so I ran it "As script", and although my database is which is over 15GB, with posters it finished in 3-4 minutes claiming "Script successfully executed"
After that I tried to update movies I stated above, but no luck. But, for example, I just repeated update for "All About Eve" which didn't succeed at first, and now it succeeded?! It never happened in original PVD, and the only conclusion I can make is that if some field isn't rewritable (for God knows what reason) the record cannot be updated.
I'd appreciate any further help on this and am more than grateful for your tremendous work and efforts to make PVD alive!
My best regards to you two.
VVV_Easy_Programing:
Have you used the Tools/Optimize database ... ?
Perhaps it solved your "write protected" records but I warm you that it spend a lot, a lot of time.
With a 7.000 movies you must have more of 200.000 persons!
Perhaps you will spent one or two days with PVD working and the PC un-responding.
afrocuban:
Thanks for your idea, VVV. I remember I used that option at the very beginning, and that then as I can remember it deleted some records I didn't want to. Do you by any chance know what exactly optimizing will do to my database? I hae never ever had some problem with PVD database speed, but whatever - I'll do it if my records will not be deleted or database corrupted.
Kind regards
afrocuban:
Dear VVV and Ivek,
Meanwhile, I have experienced another strange issue. While updating some movies, it asks me to confirm the movie, although IMDb urls are already in database, and for for twice!. You can check comparing offered url on the first screenshot (question marks), with the url already in database in the second screenshot (red arrow) - they are the same.
Also, for some movies I get infobox "Movie not found :)" although IMDb url exists - please see third screenshot?!
It didn't happen earlier.
It's like script doesn't use existing urls. Why is that?
Any idea? Thank you in advance.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version