2016-06-28, 16:48
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
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
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