Please could someone give me the correct/list of values for the video resolution and duration fields.
For video I would like to group as:
4k
1080p
720p
576p
540p
480p
For duration, there doesn't appear to be a between option, so will I need a series of rules? E.g. between 3 to 3 and a half hours, rule # 1 would be greater than 3:00:00 and rule #2 would be less than 3:30:00
(2020-04-21, 18:49)Hairy Hippy Wrote: [ -> ]For video I would like to group as:
4k
1080p
720p
576p
540p
480p
The values have to match what is in your database. From my database the values are
2160
1080
576
480
But there are also values that are slightly different to them such as - 576, 574, 572, 568, 566, 562, 558, 556, 554 etc
So setting a single value may not pick up every movie for that resolution. You will have to use a range of rules. Best to open your MyVideosxx database and check the
iVideoHeight field of the
streamdetails table.
(2020-04-21, 18:49)Hairy Hippy Wrote: [ -> ]For duration, there doesn't appear to be a between option, so will I need a series of rules? E.g. between 3 to 3 and a half hours, rule # 1 would be greater than 3:00:00 and rule #2 would be less than 3:30:00
Yes.
(2020-04-21, 21:39)Karellen Wrote: [ -> ]Best to open your MyVideosxx database and check theP iVideoHeight field of the streamdetails table.
Perfect! Thank you. Is there a height range that would match the following:
Standard Definition
High Definition 720p
High Definition 1080p
Ultra High Definition (4k+)
(2020-04-22, 12:23)Hairy Hippy Wrote: [ -> ] (2020-04-21, 21:39)Karellen Wrote: [ -> ]Perfect! Thank you. Is there a height range that would match the following:
Standard Definition
High Definition 720p
High Definition 1080p
Ultra High Definition (4k+)
I am asking this as I checked my database and seem to gave 133 differing video heights!
I am therefore wondering given that it seems everything up to 576 height would be considered standard definition, so am wondering if the following would be considered SD or HD 720p. I appreciate that this might be a personal preference however am wondering if there is actual an "industry standard":
608
656
686
688
690
692
694
696
704
706
718
Similarly, would these be HD 720p or HD 1080p:
750
752
772
784
792
796
798
800
802
804
808
810
812
816
820
824
872
876
1010
1012
1028
1032
1036
1038
1040
1072
1074
1076
1078