Get audio quality out of SQL DB
#1
Hi guys,

I hope that this is the right place for my question.
I developed a PHP overview of the movies und tv shows which gets the information out of the mysql database.
After showing the video quality (SD, 720p, 1080p) I would like to implement the quality of the audio stream.

How does Kodi know if the audio stream is dolby digital, trueHD and so on?

I only found the audio codec and the number of audio channels in the table streamdetails.

Does anybody know how to get the audio information which you can see in Kodi?
Reply
#2
why don't you use JSON-RPC ?
Read/follow the forum rules.
For troubleshooting and bug reporting, read this first
Interested in seeing some YouTube videos about Kodi? Go here and subscribe
Reply
#3
(2015-09-17, 09:35)Martijn Wrote: why don't you use JSON-RPC ?

Because of two things. First I am not familiar with json Big Grin und second because I have one sql query which gives me all movies as an array which I use to show the list in php.

How can I get the information with json? Do you have an example for me?
Reply
#4
(2015-09-17, 11:18)eag1e Wrote:
(2015-09-17, 09:35)Martijn Wrote: why don't you use JSON-RPC ?

Because of two things. First I am not familiar with json Big Grin und second because I have one sql query which gives me all movies as an array which I use to show the list in php.

How can I get the information with json? Do you have an example for me?

I just posted about it
http://forum.kodi.tv/showthread.php?tid=238825

In fact Json rpc has an entire subforum
http://forum.kodi.tv/forumdisplay.php?fid=174
Reply
#5
But with json I can only get the current audiostream details can´t I?
I want to have the information for every movie for my PHP overview.

My only question is, if the information is saved in the sql db. Smile
Reply
#6
You can get that with JSON-RPC as well (because it's stored in the database once a video has been properly scanned).
Always read the online manual (wiki), FAQ (wiki) and search the forum before posting.
Do not e-mail Team Kodi members directly asking for support. Read/follow the forum rules (wiki).
Please read the pages on troubleshooting (wiki) and bug reporting (wiki) before reporting issues.
Reply
#7
(2015-09-18, 11:49)Montellese Wrote: You can get that with JSON-RPC as well (because it's stored in the database once a video has been properly scanned).

But when it is stored in the DB, I could get the information with sql also.
I only need to know where to find it.
Reply

Logout Mark Read Team Forum Stats Members Help
Get audio quality out of SQL DB0