+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Add-on Support (https://forum.kodi.tv/forumdisplay.php?fid=27)
+---- Forum: Web Interfaces (https://forum.kodi.tv/forumdisplay.php?fid=156)
+----- Forum: Chorus (https://forum.kodi.tv/forumdisplay.php?fid=269)
+----- Thread: Kodi/Chorus Searching for Cast? (/showthread.php?tid=280974)
Kodi/Chorus Searching for Cast? - xquadradpi - 2016-06-28
Hey Guys,
im new to this, but i have some knowledge in Programming with CSS/PHP/C#/SQL...
but i couldnt find what i was looking for
The Chorus Web Interface search function.
Why?
Because i would like to add the cast to the result.
I tryed to add the "movie_view" within the MyVideos99.db
PHP Code:
CREATE VIEW movie_view AS
SELECT movie.*
, sets.strSet AS strSet
, sets.strOverview AS strSetOverview
, files.strFileName AS strFileName
, path.strPath AS strPath
, files.playCount AS playCount
, files.lastPlayed AS lastPlayed
, files.dateAdded AS dateAdded
, bookmark.timeInSeconds AS resumeTimeInSeconds
, bookmark.totalTimeInSeconds AS totalTimeInSeconds
, actor.name AS actor
FROM movie
LEFT JOIN sets ON sets.idSet = movie.idSet
JOIN files ON files.idFile=movie.idFile
JOIN path ON path.idPath=files.idPath
JOIN actor_link AS al ON al.media_id = movie.idMovie
JOIN actor ON actor.actor_id = al.actor_id
LEFT JOIN bookmark ON bookmark.idFile=movie.idFile AND bookmark.type=1
GROUP BY c00
As you can See i added some LEFT JOINS to add the actors and actor_link table
but it had not the effect i was hoping
The Problem is, i cant find the "Trigger" where the SQL Statements where activated when im typing into the search bar.
Can anyone Help me?
Thx so far
greetings
xquadradpi
RE: Kodi/Chorus Searching for Cast? - Martijn - 2016-06-28
You should be using JSON-RPC just like chorus does.
RE: Kodi/Chorus Searching for Cast? - xquadradpi - 2016-06-28
I would,
if i would know where to change/to use it
How i said i could not find the Files where to change the search statement
RE: Kodi/Chorus Searching for Cast? - tuxfuxch - 2016-06-29
Here the documentation of the API for JSON-RPC: http://kodi.wiki/view/JSON-RPC_API/v6
Here the source of chorus2: https://github.com/jez500/chorus2
you need to know at least a litte javascipt and maybe jquery.
RE: Kodi/Chorus Searching for Cast? - xquadradpi - 2016-06-29
i have some good basics in js and jquery
i was using Chorus 1
was checking the Chorus.js but could not find the way how to change the "search filters" so that actors will be included to the search results :/