[xquadradpi]

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

[Martijn]

You should be using JSON-RPC just like chorus does.

[xquadradpi]

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

[tuxfuxch]

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.

[xquadradpi]

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 :/