Featured Movie / Recommended Movie

[jitterjames]

Have you guys noticed it doesn't allways select the movie but rather the dirback button ".."

Is there any way to make the system go straight to the movie info page...  the one you activate by pressing 'I" on the keyboard...

Cheers all..

no.

but I always disable "show parent items" in xbmc settings:

http://wiki.xbmc.org/index.php?title=Settings/Appearance#File_lists

I dont' know of a way to make it go "straight" to the info page, but you can send a keypress.  Timing may be an issue.  Depending which method you use to send the keypress, you may need to make sure that the page has fully loaded first.

[bp_pbs]

Sorry I have not notice that either.

Also one more thing, would it be at all possible to include Genre in this...  It would be great if Anika [my four year old] and I could just say....  "Hey Brian, could you recommend us a 'family' movie". 

Neat idea....  I was showing it off earlier to her and it popped up with "Saw 5" oh on that note, can you tell Brian to shut up or something while reading the synopsis LOL...

Um...The Genre part I will have to work on. There should be a way.

For Brian to stop talking use "TTS.Stop" .

[jitterjames]

Also one more thing, would it be at all possible to include Genre in this...  It would be great if Anika [my four year old] and I could just say....  "Hey Brian, could you recommend us a 'family' movie". 

Neat idea....  I was showing it off earlier to her and it popped up with "Saw 5" oh on that note, can you tell Brian to shut up or something while reading the synopsis LOL...

you can add a genre clause to the sql.  something like  and genre = '{1}'.  You need to consult the xbmc database specs to make sure you use a valid column name.

You can use TTS.Stop to make Brian "shut up" but I'm not sure you want your daughter to hear you using that command.  This will not work if you are using TTS.SpeakSync

[bp_pbs]

This should work for you...Pretty much the same as James said using the genre = '{1}.


Oh yeah and forgot to mention if you are going to use the the TTS.Stop. You should adjust the command to TTS.Speak {match.2}. Like James stated using TTS.SpeakSync wont work.


Hope this helps

[bp_pbs]

I did find one problem, James hopefully you can help me out. Since c14 consist of all the genres for a particular movie if we use c14='{1}'...(let say genre Action). It only pulls movies that have only Action as their Genre. Movies that have multiple genres such as Action/Adventure etc are not being used.
I have at least 40 children movies but since all have multiple genres none are being pulled.

[jitterjames]

I did find one problem, James hopefully you can help me out. Since c14 consist of all the genres for a particular movie if we use c14='{1}'...(let say genre Action). It only pulls movies that have only Action as their Genre. Movies that have multiple genres such as Action/Adventure etc are not being used.
I have at least 40 children movies but since all have multiple genres none are being pulled.

You should be able to use something like this then:

 c14 like '%{1}%'

which basically treats the % symbols as wildcards.  I think using Like also causes it to ignore case.

of course you might occasionally get extra stuff if one genre string is a subset of another genre string, but I don't think it is very likely.  There is probably another way to do it with a more complex sql statement but it would be tricky and probably not really necessary.

[thesystemera]

good work guys...  Very impressed with the fast response...  Am about to give it a try..  Thank you all.. And yes I am sing speaksync.    Wil revert back to speak...  Thanks again..

[thesystemera]

Okay, gave it a try, but I'm just getting the whole... 

How about "Match .1" "Match .2"

Any idea's..  Tried adding the "Like" option suggested by James but no difference???

Thanks...

[bp_pbs]

Ok reconfigured it. Try this one for now ( will work on it more ). I had to use an IF ELSE statement since Action didn't like % before it. Still not working properly because I'm still having trouble with certain Genres like Family...maybe the way it's stored in the database.

Also I changed the Results.RegEx to Results.RegExSingle. Seems to work better for me so that I wouldn't keep getting that match.2 a lot.

[jitterjames]

interesting.  I'm wondering why it doesn't work with Action and Family.  Can you be a bit more precise about how it's not working?

Maybe also send me your genre payload xml file?

[jitterjames]

I have kind of figured out what is happening.  the way the url is being encoded varies and it seems that %F and %A are getting changed to some strange characters.

I have found a sort of solution, without having to resort to logic blocks, that seems to work with everything:

queryvideodatabase(select c00,c01 from movie where c14 LIKE '{1}%%' or c14 LIKE '%% {1}%%' order by random() Limit 1)

it is important to note that there is a space after %% in the second like, and this is what prevents %A or %F from being turned into weird characters...

[bp_pbs]

I have kind of figured out what is happening.  the way the url is being encoded varies and it seems that %F and %A are getting changed to some strange characters.

I have found a sort of solution, without having to resort to logic blocks, that seems to work with everything:

queryvideodatabase(select c00,c01 from movie where c14 LIKE '{1}%%' or c14 LIKE '%% {1}%%' order by random() Limit 1)

it is important to note that there is a space after %% in the second like, and this is what prevents %A or %F from being turned into weird characters...

That's weird. I tested your solution and it worked for me as well...like i said before I knew you would find a way...

[thesystemera]

For me the system is not responding to 'Family' it seems..

Otherwise all is rather good.  I know I suck at this but seeing I have 600 films or so, would there be a way to also filter for only movies with a rating higher than a certain amount.  I'm just one demanding user I know...

I might make some dedicated playlists and use an alternate command to pick out of a playlist with a high rating threshold.  Though it would be cool to introduce both in to the one command. 

Good work all... 

[Kalle]

For me the system is not responding to 'Family' it seems..

Otherwise all is rather good.  I know I suck at this but seeing I have 600 films or so, would there be a way to also filter for only movies with a rating higher than a certain amount.  I'm just one demanding user I know...

I might make some dedicated playlists and use an alternate command to pick out of a playlist with a high rating threshold.  Though it would be cool to introduce both in to the one command. 

Good work all... 

I'm not really firm in XBMC, but you can take a look here: http://wiki.xbmc.org/index.php?title=XBMC_databases#Building_SQL_Queries and here http://wiki.xbmc.org/index.php?title=XBMC_databases#movie
You can modify a exist XBMC command ( I think so)

[thesystemera]

Thanks... That is exactly what I'm looking for...