Messages

1

XBMC (Old board see 'KODI' above) / Re: temp split

« on: March 01, 2011, 02:40:42 PM »

Hi Giftie.  I am experimenting with this right now and so far so good.  Just one question.  Would it not be safer if our sql queries generated movie ids instead of titles?  Or would that be a lot of work to modify the plugin?

Not a lot of work.  Though I can't see it being any safer.  I would need to add another SQL query internally to change idMovie to Movie Title...  - I see in my own Db, I have two movies that don't seem to have Movie Titles(I know the script will skip these by default) 

quick link to XBMC's wiki page - http://wiki.xbmc.org/index.php?title=The_XBMC_Database#view

2

XBMC (Old board see 'KODI' above) / Re: temp split

« on: March 01, 2011, 02:16:46 PM »

I would like to see someone come up with a join to let us queue random movies by Actor name... 

In my long winded, round about way, here you go...
SELECT movieview.c00 FROM movieview JOIN actorlinkmovie ON actorlinkmovie.idMovie=movieview.idMovie JOIN actors ON actorlinkmovie.idActor=actors.idActor WHERE strActor="Adam Sandler" ORDER BY RANDOM() LIMIT 10


For those who haven't figured out the movieviewView:

c00 = Movie Title
c01 = Movie Plot
c02 = Plot Outline
c03 = Tag Line
c04 = # of Voters(IMDb)
c05 = Vote Rating(IMDb)
c06 = Writer
c07 = Year
c08 = thumbnail url
c09 = IMDb #
c10 = ? not sure ? -
c11 = Runtime
c12 = MPAA Rating
c13 = IMDb Top 250 placement
c14 = Genre
c15 = Director
c16 = Original Title - I think
c17 = ? Not Sure ? - Empty in my Db
c18 = Studio

3

XBMC (Old board see 'KODI' above) / Re: Speak/say selecteed movie name

« on: February 28, 2011, 09:25:48 PM »

As long as you SQL queries would would return movie titles it should be simple to add. 
For instance:

"SELECT movieview.c00 FROM movieview JOIN genrelinkmovie ON genrelinkmovie.idMovie=movieview.idMovie JOIN genre ON genrelinkmovie.idGenre=genre.idGenre WHERE strGenre="Action" ORDER BY RANDOM() LIMIT 10"

returns 10 random movie titles that match the Genre of Action.

I know this works with SQLite(XBMC's native Database), a MySQL query probably would be quite similar.   
I'm glad I went with putting 'command' before the movietitle option...  Some how I knew more would come up... 
I don't see a problem putting 'command<li>sqlquery' in... 



30mins since this posted I already have working code(well it works with the query above) 

Supply me with some queries to test...

4

XBMC (Old board see 'KODI' above) / Re: Speak/say selecteed movie name

« on: February 28, 2011, 02:10:34 AM »

Hey giftie,

big thanks  for this perfect plugin 

Kalle

It's not perfect yet....    Probably never will be...   

I felt like I needed to make it up to those that use VoxCommando, I got the feeling that I stepped on your toes the most with the update last Tuesday.... 

5

XBMC (Old board see 'KODI' above) / Re: Speak/say selecteed movie name

« on: February 28, 2011, 02:06:56 AM »

is there any point in making a triple feature command?

Actually I think it might be nice if we could have a command to just set up X number of random movies with intros and intermission...  like party mode.  Or possibly with some kind of criteria like genre, so we could have a command like "entertain the kids for 8 hours" and have it go into Cinema Experience with random movies from the "Family" genre.

lol.  Maybe 8 hours is too much... but we could make them do exercises during intermission!

Always can be added..  Features for VoxCommando and other HTTP API apps are fairly easy to add, just need to get the syntax right... And HTTP API will still be around for at least another year, probably longer.

Random movies, Rating limits, by Year, by genre, by set.....   If it's in the database, it can be matched..

and I don't have to make GUI...  


Sorry Auri for taking so long to get your request done..