Featured Movie / Recommended Movie

jitterjames · May 28, 2012, 11:53:50 AM

Quote from: thesystemera on May 28, 2012, 01:33:38 AM
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 · May 28, 2012, 01:01:29 PM

Sorry I have not notice that either.

Quote from: thesystemera on May 28, 2012, 07:16:47 AM
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 · May 28, 2012, 01:13:53 PM

Quote from: thesystemera on May 28, 2012, 07:16:47 AM
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 · May 28, 2012, 02:42:56 PM

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 · May 28, 2012, 03:35:36 PM

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 · May 28, 2012, 08:47:58 PM

Quote from: bp_pbs on May 28, 2012, 03:35:36 PM
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 · May 28, 2012, 08:54:19 PM

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 · May 28, 2012, 10:56:31 PM

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 · May 29, 2012, 06:13:14 AM

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 · May 29, 2012, 06:34:57 PM

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 · May 29, 2012, 07:13:57 PM

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 · May 30, 2012, 01:49:43 AM

Quote from: jitterjames on May 29, 2012, 07:13:57 PM
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 · May 31, 2012, 01:01:43 AM

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 · May 31, 2012, 05:01:39 AM

Quote from: thesystemera on May 31, 2012, 01:01:43 AM
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 · May 31, 2012, 06:32:58 AM

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

News:

Featured Movie / Recommended Movie