Quote from: abubin on  8 06 October, 2026, 08:07:37 AMNothing can be as good as PVD.

Literally.

Thanks for your kind words.

You can also use my thread on the Doom9 forum (link below):

https://forum.doom9.org/showthread.php?t=186971

Posting on Reddit and Discord isn't a bad idea either; a long-time user of the original PVD forum might come across it there and then register on this new PVD forum. You can share specific details found in my posts on the Doom9 forum. I would be grateful for such help.

Quote from: abubin on  8 06 October, 2026, 08:07:37 AMAlso, thanks for Ivek23, meriator and afrocuban for continuing PVD legacy. Sorry if I missed anyone else.

Thanks.

Since you updated to the latest PVD version (1.0.2.7), only the TMDB plugin works for you, while all the scripts are non-functional. A download link for the PVD 1.0.2.7 MOD version is provided below. This is a modified (MOD) version of PVD 1.0.2.7; you should extract it into a new folder.

http://vvveasy.altervista.org/wp-content/uploads/2019/10/PVD_1.0.2.7_MOD-V20191020.zip

Once you have done that, look for my updated TMDB scripts on this forum. As for the IMDb plugins and scripts, they no longer work. To use IMDb scripts, you need to have Python installed on your PC. You now need Python + Selenium scripts and modified .psf IMDb scripts, because IMDb uses only HTTPS connections. You can also find some instructions on using Python on this forum. I highly recommend using AI-assisted help and instructions for installing and using Python, as well as for setting up the Python + Selenium and .psf IMDb scripts. Personally, I have relied heavily—and continue to rely—on AI advice for using Python and various matters related to using PVD and Python together. I am also available on the forum to provide help and advice.

Throughout the years, I have been updating PVD using various methods and I do not remember what frankenstein version I am having now. However, it shows PVD 1.0.2.7 which is the last working version.

It is still working fine especially the plugins still able to get movies from themoviedb. It is showing version 0.1.1.3.

So I want to install the latest version of PVD packaged with latest plugins. Downloaded PVD and the links and got it running. Showing same version of PVD 1.0.2.7. However, the plugins are newer version. themoviedb [EN] 1.0.0.3. Thing is, it doesn't work in getting movie information. Says no movie found. Tried IMDB and so on and non works. Just wondering what did I miss. Appreciate any help.

I have been using PVD for more than 10 years now. Never stopped using. Just was inactive in the forum. Found this new shiny forum for PVD.

It's crazy after so many years of it being abandoned by dev, it is still running great! Throughout the years, I have tried many other alternatives. Nothing can be as good as PVD.

So I was thinking, should we have a reddit sub for PVD? I mean forum is really a dying breed, many things has moved on to reddit and discord.

Also, thanks for Ivek23, meriator and afrocuban for continuing PVD legacy. Sorry if I missed anyone else.

Maybe you would want to check this file to get an idea what I am doing, and where am I at this point and how the script can be pretty reliably updated.

There is also the same page, but with expanded reasoning, so you could inspect what is actually happening "behind the scene".

What do you think once you read them?

Of course there is so much more to do. I have many functionalites on my mind in addition to that too, hahaha.

I will be away for sometime from updating the scripts.

Namely I am currently training my own LLM so I could ingest and store all the scripts (and other useful resources such as manuals etc) into my knowledge base, so I could later easier maintain scripts.

Other then http://mailmirdoch.net/index.php?topic=57.0 if you have other help resources saved somehow from the old forum NOT in pdf, please upload them here so I could import them to my LLM.

Thank you in advance.

Wow. This is way out of my league, and I admit I jsut have to wait for the final dll and how it applies on the outcome, preferably through some example.

Thanks for your commitment, though!

And now I have successfuly compilered a 64bit dll as UDF module which does the resize action automaticly

the function it self requieres
IMAGE_RESIZE("imgdata", 500, "imgformat", 78)
where
1. "imgdata" = our Blob field
2. 500 = max. desired size here: 500px (on the bigger side height or width)
3. "imgformat" = ('.jpg' or '.png') this makes diffrence
            (to find out the images format makes via the function makes it much slower so, as we got it allready, we send it as parameter)
4. 78 = compresion ratio (.jpg  only)

this dll has a view exceptions which satisfy my needs
... so do nothing if ...
1. ... the height = 700 px (this is the height of back covers to be readable)
2. ... the width = 970 px & height = 231 px (this is the width of banners)
   with on exepetion here (970:231 = an aspect ratio to approximately 4.2:1, so if width > 970 or <= 930 with equal aspect, then change it to width = 970 px)
3. ... the width = 500 px & height < 500 px
4. ... the height = 500 px & width < 500 px

currently i not made a Trigger for this resizing, in cause of testing with GET_IMAGE_WIDTH & GET_IMAGE_HEIGHT functions
may i have to put all together in 1 single UDF module

I will see

if every thing works as expected I will publish the moduls here

sty tuned meriator

hey afrocuban
I think you miss understood me
"connecting to a fbserver" makes the cominication between PVD an the DB faster. AT this point it has nothing to do with the images. fbserver (64 bit) runs faster then the embebed fb (32 bit) dill's.

the image problem is solved (in my case) in an other way

first i gave them names by setting the "imgpath"
with
SQL

UPDATE IMAGES i
SET "imgpath" = (
    SELECT m."title"
    FROM MOVIES m
    WHERE m."mid" = i."mid"
) || '_' || i."mid" || '_' || i."imgid" || i."imgformat"
WHERE EXISTS (
    SELECT 1
    FROM MOVIES m
    WHERE m."mid" = i."mid"
      AND i."imgpath" IS DISTINCT FROM (m."title" || '_' || i."mid" || '_' || i."imgid" || i."imgformat")
)
ROWS 10;

(you can set the ROWS 10 to ROWS 1000 or more)

I made a (64 bit) dll-file named 'image_udf.dll'
which is an UDF module and has to be placed in the
Firebird-Server->UDF(folder)
the two function of the module GET_IMAGE_WIDTH & GET_IMAGE_HEIGHT has to be declared via a Statement so that the FB-server gets aware of them

The task of the module is to read image-height and image-width from the blob-field "imgdata"

this is realized via a Trigger withhin the FB-server
on Inserts or Updates
so i have changed the old Trigger which only affected imgsize via OCTET_LENGTH (r. "Imgdata")
to also get "imgwidth"= GET_IMAGE_WIDTH(r."imgdata") & "imgheight" = GET_IMAGE_HEIGHT(r."imgdata")

a simple SQL-Statement like

Update IMAGES i set i."caption" = i."caption"
where i."imgheight" is NULL;

will update all data rows

and now i can easy find all images which are to big
except Back-Covers which are 700px in height
and banners  which are 970px in width
all my images should not exceed 500 px in height or  width


SELECT  m."mid", m."title", m."year",m."size", m."series",m."epid",m."wish",m."visible",
       i."imgid", i."imgformat",i."imgheight", i."imgwidth", i."imgsize", i."imgpath"
FROM IMAGES i
left join MOVIES m on (m."mid" = i."mid")
where  (i."imgheight" > 500 or i."imgwidth" > 500) and NOT (i."imgheight" = 700 or i."imgwidth" = 970)
ROWS 1000;


but still the image must be resized manualy

curently this is done automaticly (for new images) by php, as all my script run via a local proxy to my local server an back
the local server resizes each image to size configered in it's config file.
the local server and it's local proxy helps me a lot in managing the PVD-DB.

by the way a little schematic view on whats going on my PC using PVD-scripts