Skip Intro DB location

General Discussions
1

Where in the DB are the time stamps stored for the Skip Intros?

2

They are actually stored in the XML file

3

What are you trying to do with it?

If you just want to see what media has Intro markers … ExportTools or WebTools-NG can dump it.

It’s encoded as the intros element in media_parts.extra_data.

It’s stored URLencoded in the DB, here it’s decoded for visibility. I’d love to hear if this is a standard format, but I think it’s unique-to-Plex internal thing.

ma:container=mkv&ma:deepAnalysisVersion=6&ma:requiredBandwidths=2545,2545,2545,2545,2545,2545,2545,2545&ma:videoProfile=main 10&mi:indexes=sd&pv:chapters={"Chapters":{"Chapter":[{"name":"","start":0.0,"end":39.406033333},{"name":"","start":39.406033333,"end":404.237166666},{"name":"","start":404.237166666,"end":888.888},{"name":"","start":888.888,"end":1314.479833333},{"name":"","start":1314.479833333,"end":1352.864}]}}&pv:deepAnalysisDate=1610267166&pv:intros={"MediaPartMarkersArray":{"attributeName":"intros","version":5,"MediaPartMarker":[{"startTimeOffset":8170,"endTimeOffset":35497}]}}

I’m not aware of an API to programmatically interact with this.

–

@CostaHT there’s no stored XML file. The View XML button extracts data from all over the database and formats it for presentation or API use.

4

The XML doesn’t exist. It is generated in real time from the various places where Plex is storing metadata.

5

That doesnt seem to be the case. I found a show/episode that I know has a working “skip intros” the etra_data doesnt show it. The 4 chapters do align though.

ma:audioProfile=dts&ma:container=mkv&ma:videoProfile=advanced&pv:chapters={"Chapters":{"Chapter":[{"name":"","start":"0","end":"112.57700000000001"},{"name":"","start":"112.57700000000001","end":"709.86300000000006"},{"name":"","start":"709.86300000000006","end":"1280.73"},{"name":"","start":"1280.73","end":"1384.4340000000002"}]}}```
6

What is the problem you are trying to solve?

7

Maybe I want to write my own/edit values here using SQLLiteDB. Maybe I want to run a report to see what shows are missing them. There are lots of valid use cases. Can I put them in a NFO file or the new .plex file?

8

I don’t think there are multiple mechanisms. On that episode, is there a marker with type="intro" in the XML?

no

9

You can use them, you can’t create and/or modify them.

And that’s obvious since it’s a Plex Pass feature