Kodi Community Forum
MySQL TV Show season locations - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Development (https://forum.kodi.tv/forumdisplay.php?fid=32)
+--- Forum: Kodi Application (https://forum.kodi.tv/forumdisplay.php?fid=93)
+--- Thread: MySQL TV Show season locations (/showthread.php?tid=174295)

MySQL TV Show season locations - darksheep - 2013-09-25

Hi

I was wondering if any one could help me write a MySql query to return all the Shows and their individual season locations .

I just cant seem to get it right.

This is what I am trying to get from the MySql query

Image


Thank you for your time

Edit

Ok I got it right may be this will help some one else.

Code:
SELECT tvshow.idShow,tvshow.c00 as 'ShowName',episode.c12 as 'Season',episode.c18 as 'Path'
FROM myvideos75.episode
join tvshow on tvshow.idShow = episode.idShow
group by episode .idShow,episode.c12


The only problem I then had was that Path returns some thing like this

"smb://10.0.0.3/tv/2 Broke Girls/Season1/2 Broke Girls.S01E01.Pilot.avi"

I wrote a simple function to change it to this "\\10.0.0.3\tv\2 Broke Girls\Season1\"

Let me know if you would like the function.