[S474N]

Takze zase trosicku vrtani v DB s kamaradem a vysledky:

select * from path where strPath LIKE '%Sklad%13%'
nalezena slozka se serialem a v ni 5 slozek se sezonami

Kód:

idPath = 1854, strPath = special://profile/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/, idParentPath = 1
idPath = 1855, strPath = special://profile/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 1/, idParentPath = 1854
idPath = 1856, strPath = special://profile/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 2/, idParentPath = 1854
idPath = 1857, strPath = special://profile/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 3/, idParentPath = 1854
idPath = 1858, strPath = special://profile/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 4/, idParentPath = 1854
idPath = 1859, strPath = special://profile/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 5/, idParentPath = 1854

select * from tvshow where c00 LIKE 'Sklad%13'

Kód:

idShow = 459

select * from seasons where idShow = 459
v tabulce seasons jsou pro  where idShow = 459 tyto zaznamy

Kód:

saeson = -1, idSeason = 2404
saeson = 0, idSeason = 2405
saeson = 1, idSeason = 2406
saeson = 2, idSeason = 2407
saeson = 3, idSeason = 2408
saeson = 4, idSeason = 2409
saeson = 5, idSeason = 2410

select * from episode where idShow = 459
v tabulce episode jsou zaznamy jen pro 11 dilu z prvni serie

Tedy z tohoto je patrno, ze primo v DB jsou ulozeny sice odkazy na vsech pet serii, ale jenom ta prvni ma i navazujici zaznamy v alsich tabulkach.

---

Mimochodem je take zajimave podivat se do /storage/.kodi/temp/kodi.log

Kód:

09:05:33 609.210327 T:1739617344  NOTICE: ('item: ', 'plugin://plugin.video.sosac.ph/?play=687474703a2f2f74762e7072656872616a2e6d652f63732f64657461696c2f736b6c6164697374652d3133&cp=736f7361632e7068&title=536b6c61646974203133&', {'url': 'http://tv.prehraj.me/cs/detail/skladiste-13', 'action': 'add-to-library', 'notify': True, 'name': 'Skladi\xc5\xa1t\xc4\x9b 13', 'update': True})
09:05:34 609.662903 T:1739617344  NOTICE: ('Failed to create directory 2', '/storage/.kodi/userdata/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 1')
09:05:34 609.687866 T:1739617344  NOTICE: Previous line repeats 11 times.
09:05:34 609.687988 T:1739617344  NOTICE: ('Failed to create directory 2', '/storage/.kodi/userdata/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 2')
09:05:34 609.715332 T:1739617344  NOTICE: Previous line repeats 12 times.
09:05:34 609.715515 T:1739617344  NOTICE: ('Failed to create directory 2', '/storage/.kodi/userdata/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 3')
09:05:34 609.742737 T:1739617344  NOTICE: Previous line repeats 12 times.
09:05:34 609.742920 T:1739617344  NOTICE: ('Failed to create directory 2', '/storage/.kodi/userdata/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 4')
09:05:34 609.782104 T:1739617344  NOTICE: Previous line repeats 19 times.
09:05:34 609.782288 T:1739617344  NOTICE: ('Failed to create directory 2', '/storage/.kodi/userdata/addon_data/plugin.video.sosac.ph/TVShows/Skladiste 13/Season 5')
09:05:34 609.796326 T:1739617344  NOTICE: Previous line repeats 5 times.

Nejak se mi to cele nezda, jestli nebude problem v kodovani cestiny.