[mythtv-users] mysql stuff

[John Pilkington]

On 01/05/2025 14:38, James Linder wrote:
> I used to extract fps
> 
> fps=$(echo "scale=10;`echo "select data from recordedmarkup where chanid=$chanid AND starttime='$starttime' and type=32" | $mysqlconnect` / 1000.0" | bc)
> 
> fps has now moved to recordedfile
> 
> I see nothing that links recordedfile and recordedprogram. starttime is a lousy unique filter for a recording, can anyone suggest a better filter for fps.
> 
> Thanks
> James

I have never triedto do this, but ISTR that fps may vary during a recording.

John P