Database Question

[centuryx476 9]

Hello,

What table contains the runtimes(Duration) of your movies/shows etc ?

 

IS it "RunTimeTicks" ?

Edited March 6, 2020 by centuryx476

[Happy2Play 9783]

Looks like MediaItems table (RunTimeTicks)

[centuryx476 9]

Looks like MediaItems table (RunTimeTicks)

What value is the tick ? MIlliseconds ?

Do I divide it by a certain number or convert it to another format ?

[Luke 42085]

ms / 10000

[centuryx476 9]

ms / 10000

Here is one value:

54189979999

 

So it will be

54189979999 / 10000 ?

I know that this movie is 1hr 30m

Edited March 6, 2020 by centuryx476

[Luke 42085]

I'm sorry, ms * 10000. It's .net ticks.

[Happy2Play 9783]

What are you trying to do?

 

ticks to seconds to minutes

54189979999/10,000,000/60=90.31663333166667

 

 

https://www.venea.net/web/net_ticks_timespan_converter#net_ticks_to_time_span_conversion

0 Days + 1 Hour + 30 Minutes + 18.9979999 Seconds

Edited March 6, 2020 by Happy2Play

[centuryx476 9]

What are you trying to do?

 

ticks to seconds to minutes

54189979999/10,000,000/60=90.31663333166667

 

 

https://www.venea.net/web/net_ticks_timespan_converter#net_ticks_to_time_span_conversion

0 Days + 1 Hour + 30 Minutes + 18.9979999 Seconds

This is exactly what I am trying to do.

Once @@Luke said they are .net ticks I knew what path to take to get the actual time.

Only little issue is the "RuntimeTick" column also contains a shows "RunTime".

For example a show metadata run time would say its a 45 minute show but the individual episodes are 47, 54, 44 minutes, etc.

I need to think of a way to filter out these entries.

 

[Happy2Play 9783]

This is exactly what I am trying to do.

Once @@Luke said they are .net ticks I knew what path to take to get the actual time.

Only little issue is the "RuntimeTick" column also contains a shows "RunTime".

For example a show metadata run time would say its a 45 minute show but the individual episodes are 47, 54, 44 minutes, etc.

I need to think of a way to filter out these entries.

 

Are you looking for a specific content type?

 

                    Type column

Movies        Type 5

Episodes     Type 8

[centuryx476 9]

Are you looking for a specific content type?

 

                    Type column

Movies        Type 5

Episodes     Type 8

AHHH

Perfect.

That will do just nicely. THANK you very much

 

I am building an internal app for the household that is basically a workFlow engine for converting my media but it will also show different types of information of the media that I currently have.

I know embyStat server is a work in progress but the info I am after is much more simpler.