MLDVDQuery 2.0.1 Released!

[davevans]

Here is the new MLDVDQuery plugin. Please Read Below before installing.


After you download and unzip the files, try and install the MLDVDQuery.msi first. If it installs you are all set, if not, you probably do not have msxml installed. It is the second file included in the zip file.
After msxml is installed, try installing the MLDVDQuery again.

There are a few files that are also included with the install. A demo for the new netflix fixture will be installed in your c:\Program Files\Cinemar directory. Also, an image not found graphic is included in your c:\Program Files\Cinemar\Images directory. Finally, full documentation can be found in your C:\Program Files\MLServer\Documentation folder.

This plugin includes a fully licensed version of a 3rd party control that I have paid the fee for. If you find the product useful, please make a donation to help continue future development. Donations can be made through paypal to davidcevansjr@yahoo.com. Thanks in advance to all those who contribute!

The installer is rather large so you can download it here:

http://www.pinnaclehomemedia.webhop.net/plugins


Dave

[gregoryx]

Thanks, Dave!

[Guest]

Thank You for your hardwork! Works Great!

Thanks Again!
Todd

[Guest]

Thank You for your hardwork! Works Great!

Thanks Again!
Todd

[mosleyh]

Yes, thanks Dave!

I'm a little confused about the use of the lookup parameters. Here's one thing I'd like to do:

Part of my default play command populates the variable {{nowplaying}} with the result of <<CHANGERLOCATION>> and the variable {{nowplayingchanger}} with the result of <<CHANGERNUMBER>>. I'd like to look up the overview for that DVD and push it into the variable {{npoverview}}

but when I test the command

Code: Select all

MLServeCmd.MLDVDQuery|Location~Overview~npoverview~{{nowplayingchanger}}~{{nowplaying}}

I get a Type Mismatch error. When I use numbers instead of the variables, it works fine. This seems to track perfectly with some of the issues the earlier beta had.What am I missing?

[mosleyh]

BTW, in the pdf docs, you list this command as an example:

Code: Select all

MLServeCmd.MLDVDQuery|Location~title~dvd_title~{{changer_location}}~{{changer_Number}}

have you got the variables transposed?

[davevans]

You are correct that the help doc has the variables transposed. I will have to update. Can you please show me what the log says in from the plugin settings page. Also, what are the values of the variables you are using (when you press "view in window" from mlserver)

Thanks,
Dave

[mosleyh]

{{nowplaying}} = 121
{{nowplayingchanger}} = 1

When I test:

Code: Select all

Location~Overview~npoverview~{{nowplayingchanger}}~{{nowplaying}}

I get:

Code: Select all

9/19/2005 8:37:35 AM
Error:
Type mismatch

Source:
MLDVDQuery

but when I test:

Code: Select all

Location~Overview~npoverview~1~121

it creates and populates {{npoverview}} correctly

thanks. . .

[davevans]

any chance you could zip up your dvdlobby database and send it to me so I can debug through it. I can not recreate locally. My email is in the plugin help.

Thanks,
Dave

[davevans]

When you say test command, are you doing in on the test command settings page? If so, I found the bug. It should still work fine when intiated from ML. Its actually a bug in the settings screen (which processes things independently of the actual plugin logic.

Dave

[mosleyh]

Yup, I've been using the test command settings page. I'll try the commands "live" and let you know what happens.

Thanks again

[mosleyh]

This is beginning to make my brain hurt. . .

Code: Select all

MLServeCmd.MLDVDQuery|Location~Overview~npoverview~{{nowplayingchanger}}~{{nowplaying}}

Works when sent from the server command window.

BUT. . .

I restarted MLS to clear everything out, then I sent

Code: Select all

MLServeCmd.Macro|SetVariable|nowplaying~111!SetVariable|nowplayingchanger~1

Then I sent:

Code: Select all

MLServeCmd.MLDVDQuery|LastAdded~ChangerLocation~recent~10

and got this:

9/19/2005 3:36:53 PM
Error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(ChangerLocation) ORDER BY TblDVD.dvdNumber DESC'.
Source:
Microsoft OLE DB Provider for ODBC Drivers.

just to make sure something else hadn't broken, I sent this again:

Code: Select all

MLServeCmd.MLDVDQuery|Location~Overview~npoverview~{{nowplayingchanger}}~{{nowplaying}}

and got this:

9/19/2005 3:39:02 PM
Lookup by Location:
Command: Location~Overview~npoverview~1~111
Output Variable: npoverview
Field: (Overview)
Changer Number: 1
Changer Location: 111

THEN, just to be sure I wasn't imagining it, I tried this again:

Code: Select all

MLServeCmd.MLDVDQuery|LastAdded~ChangerLocation~recent~10

and got:

9/19/2005 3:40:12 PM
Looking Up Last Added:
Command: LastAdded~ChangerLocation~recent~10
Output Variable: npoverview
Field:
Number of Records: 10

But it didn't change the value of {{npoverview}}.

I also tried

Code: Select all

MLServeCmd.MLDVDQuery|LastAdded~title~10

after restarting MLS and got:

9/19/2005 3:50:12 PM
Error:
Subscript out of range

Source:
MLDVDQuery

Last but not least, what do you have to do to make the plugin save the choice of Sequential or delimiter? The only thing I can find that will do it is to quit and restart MLS

Sorry to be so much trouble. . .

[mosleyh]

If you still want my DVDL database, it's here:

http://library.thehardyfamily.net/files/dvd.zip

[davevans]

Thanks, I will try to resolve the issues ASAP

Dave

[dbarker]

still trying to get a grip on how to use this plugin
i am fairly clear on what the possibilities are but
don't seem to be able to get it to do much.

i have tried the following commands

MLServeCmd.MLDVDQuery|LastAdded~title~dvdnumber~10

i have a button in dvdlobby labled {{dvdnumber}}
the log shows
Looking Up Last Added:
Command: LastAdded~title~dvdnumber~10
Output Variable: dvdnumber
Field:
Number of Records: 10

but i see nothing else happen
if i put this command in
MLServeCmd.MLDVDQuery|Location~Title~dvdnumber~
{{dvd_changerNumber}}~{{dvd_changerLocation}}

nothing happens

if i change it to

MLServeCmd.MLDVDQuery|Location~Title~dvdnumber~1~220
then the title of the movie in that slot shows up

am i just not understanding how to use variables? or some other
command structure?

i have tried the random trivia command also but i get nothing
do i need to assign a variable to this command and if so ,
how do i go about doing it.

guess i need some spoon feeding