Version 0.903

[jitterjames]

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]

Thanks James..

[Kalle]

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]

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]

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]

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

[Kalle]

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]

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]

updated first post to 0.902

[Kickers56]

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]

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]

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 Expand

<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]

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]

For stats video it´s ok...

[Kickers56]

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.