Author Topic: Version 0.903 (Read 8995 times)

jitterjames · « **on:** September 06, 2011, 02:14:18 PM »

Major changes have been made to the command builder, and parameter helpers.

Before using this, BACKUP BACKUP BACKUP BACKUP

There are surely still bugs, and possibly ones that could mess up your configuration files, so create a new folder for this one before testing!

thanks. I will continue to test and debug on my own, but if you notice any bugs please let me know.

Edit: updated to 0.902
fixed a bug in the command builder
fixed "find movie" command in XBMC for movie titles containing apostrophes

Edit: updated to 0.903
fixed a bug in the logic builder, where 2nd parameter was not being saved

Wanilton · « **Reply #1 on:** September 06, 2011, 02:45:19 PM »

Thanks James..

Kalle · « **Reply #2 on:** September 06, 2011, 03:13:31 PM »

Quote from: jitterjames on September 06, 2011, 02:14:18 PM

Major changes have been made to the command builder, and parameter helpers.

Before using this, BACKUP BACKUP BACKUP BACKUP

There are surely still bugs, and possibly ones that could mess up your configuration files, so create a new folder for this one before testing!

thanks. I will continue to test and debug on my own, but if you notice any bugs please let me know.

Thanks James,
very good work, the Logic Command Builder looks like perfect

I have install blank and import my old voicecommands.xml - no problems

All my commands for MM and Eventghost work fine. For XBMC I have not testet yet.

I have found one "bug" see attach pic.

Q: The Commands in CommandSelectionTree with no parameters are in red, is this correct?

Kalle

jitterjames · « **Reply #3 on:** September 06, 2011, 04:59:22 PM »

Quote from: Kalle on September 06, 2011, 03:13:31 PM

I have found one "bug" see attach pic.

Q: The Commands in CommandSelectionTree with no parameters are in red, is this correct?

Good catch. I think I've got that one fixed.

Any actions with 1 or more parameters should be shown in red. This is only temporary so that I can find the ones that I still need to edit, more easily.

jitterjames · « **Reply #4 on:** September 06, 2011, 07:06:36 PM »

I updated the first post with a new version (0.901b)

it should fix the error Kalle got.

also I have added something new to the GenXML for XBMC for "power users"...

Wanilton · « **Reply #5 on:** September 06, 2011, 08:03:33 PM »

WOWWWWWWW...this is great...hidden the game...

I need see SQL commands again...

Kalle · « **Reply #6 on:** September 07, 2011, 05:08:39 AM »

Quote from: jitterjames on September 06, 2011, 07:06:36 PM

I updated the first post with a new version (0.901b)

it should fix the error Kalle got.

also I have added something new to the GenXML for XBMC for "power users"...

good job James,
everthing works fine.

Kalle

jitterjames · « **Reply #7 on:** September 07, 2011, 07:41:16 AM »

Quote from: Wanilton on September 06, 2011, 08:03:33 PM

WOWWWWWWW...this is great...hidden the game... I need see SQL commands again...

The main thing is to make sure that you are selecting 2 columns. The first column will go into the value field and the second into the phrase.

Here are the existing ones for reference:

xbmcTvShowTitles.xml		queryvideodatabase(select idshow,c00 from tvshow)
xbmcMusicVideos.xml		queryvideodatabase(select idMVideo,c00 from musicvideo)
xbmcGenres.xml		querymusicdatabase(select idGenre, strGenre from genre)
xbmcVideoGenres.xml		queryvideodatabase(select idGenre, strGenre from genre)

to browse your xbmc database and see all the columns and what they contain I recommend sqlitespy
http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

this is a pretty good reference but not 100% complete and accurate: http://wiki.xbmc.org/index.php?title=The_XBMC_Database

jitterjames · « **Reply #8 on:** September 10, 2011, 10:44:52 AM »

updated first post to 0.902

Kickers56 · « **Reply #9 on:** September 12, 2011, 04:54:20 AM »

Not a needed feature really, just trying to think of extra things to do. Does anyone know of a command for xbmc via voxcommando to lookup and say how many movies, how many tv shows, how many albums you have when asked?

Might be a cool little feature. Maybe you guys are already doing it I dont know. I did a search but couldnt find anything.

Thanks

kicker56

Kalle · « **Reply #10 on:** September 12, 2011, 05:32:22 AM »

Quote from: Kickers56 on September 12, 2011, 04:54:20 AM

Not a needed feature really, just trying to think of extra things to do. Does anyone know of a command for xbmc via voxcommando to lookup and say how many movies, how many tv shows, how many albums you have when asked?

Might be a cool little feature. Maybe you guys are already doing it I dont know. I did a search but couldnt find anything.

Thanks

kicker56

Hi Kicker56,
I'm not sure, with GenXML you can see the data, but then ...?

jitterjames · « **Reply #11 on:** September 12, 2011, 09:08:08 AM »

Quote from: Kalle on September 12, 2011, 05:32:22 AM

Hi Kicker56,
I'm not sure, with GenXML you can see the data, but then ...?

Well, Aeon shows these stats so maybe by looking at how this is done a better way can be found.

Still, you can get the info by querying the xbmc database like this:

queryvideodatabase(select count(*) from movie)

you'll get this back, which you can send directly to TTS.speak if you want:

Code: [Select]

<html> 
<field>40</field> 
</html>

you could use regex and {match.1}

for regex use this parameter:

<field>(.*)</field>

since you're looking for something to do, I'll let you figure out the rest of the queries...

jitterjames · « **Reply #12 on:** September 12, 2011, 09:43:53 AM »

Try this for video. I'll let someone else modify this to work with audio. Please upload the xml for music stats if it works.

Wanilton · « **Reply #13 on:** September 12, 2011, 10:51:44 AM »

For stats video it´s ok...

Kickers56 · « **Reply #14 on:** September 12, 2011, 11:46:39 AM »

I have built it with video and a separate one for music and both are great, although for some reason my xbmc music database put in a 'various artists' for one of the artists which doesn't show up in xbmc but gets counted so I wrote this...

querymusicdatabase(select COUNT(idArtist) from artist where strArtist!='Various artists')

Of course if you want 'various artists' as an artist dont do that.

Great little addon I think, I have this coming on when I ask and also when I ask to browse artists/albums or movies.

thanks James.