MLDVDQuery 2.0.1 Released!

Repository of MainLobby Server plug-ins and updates not available in the current installation.

MLDVDQuery 2.0.1 Released!

Postby davevans » Sun Sep 18, 2005 8:04 pm

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
User avatar
davevans
Intermediate
Intermediate
 
Posts: 452
Joined: Mon Aug 04, 2003 2:36 am
Location: Tampa, FL

Postby gregoryx » Sun Sep 18, 2005 9:49 pm

=D>

Thanks, Dave! :mrgreen:
User avatar
gregoryx
Simply Incredible
Simply Incredible
 
Posts: 6592
Joined: Tue Sep 30, 2003 10:15 pm
Location: Newport Beach, CA

Postby Guest » Sun Sep 18, 2005 10:10 pm

Thank You for your hardwork! Works Great!

Thanks Again!
Todd
Guest
 

Postby Guest » Sun Sep 18, 2005 10:11 pm

Thank You for your hardwork! Works Great!

Thanks Again!
Todd
Guest
 

Postby mosleyh » Sun Sep 18, 2005 11:31 pm

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?
Last edited by mosleyh on Sun Sep 18, 2005 11:36 pm, edited 2 times in total.
User avatar
mosleyh
Intermediate
Intermediate
 
Posts: 413
Joined: Tue Jul 12, 2005 11:55 am
Location: Charlotte, NC

Postby mosleyh » Sun Sep 18, 2005 11:34 pm

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?
User avatar
mosleyh
Intermediate
Intermediate
 
Posts: 413
Joined: Tue Jul 12, 2005 11:55 am
Location: Charlotte, NC

Postby davevans » Mon Sep 19, 2005 5:54 am

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
User avatar
davevans
Intermediate
Intermediate
 
Posts: 452
Joined: Mon Aug 04, 2003 2:36 am
Location: Tampa, FL

Postby mosleyh » Mon Sep 19, 2005 7:43 am

{{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. . .
User avatar
mosleyh
Intermediate
Intermediate
 
Posts: 413
Joined: Tue Jul 12, 2005 11:55 am
Location: Charlotte, NC

Postby davevans » Mon Sep 19, 2005 9:17 am

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
User avatar
davevans
Intermediate
Intermediate
 
Posts: 452
Joined: Mon Aug 04, 2003 2:36 am
Location: Tampa, FL

Postby davevans » Mon Sep 19, 2005 9:40 am

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
User avatar
davevans
Intermediate
Intermediate
 
Posts: 452
Joined: Mon Aug 04, 2003 2:36 am
Location: Tampa, FL

Postby mosleyh » Mon Sep 19, 2005 11:19 am

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

Thanks again
User avatar
mosleyh
Intermediate
Intermediate
 
Posts: 413
Joined: Tue Jul 12, 2005 11:55 am
Location: Charlotte, NC

Postby mosleyh » Mon Sep 19, 2005 3:02 pm

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. . .
User avatar
mosleyh
Intermediate
Intermediate
 
Posts: 413
Joined: Tue Jul 12, 2005 11:55 am
Location: Charlotte, NC

Postby mosleyh » Mon Sep 19, 2005 11:31 pm

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

http://library.thehardyfamily.net/files/dvd.zip
User avatar
mosleyh
Intermediate
Intermediate
 
Posts: 413
Joined: Tue Jul 12, 2005 11:55 am
Location: Charlotte, NC

Postby davevans » Tue Sep 20, 2005 11:37 am

Thanks, I will try to resolve the issues ASAP

Dave
User avatar
davevans
Intermediate
Intermediate
 
Posts: 452
Joined: Mon Aug 04, 2003 2:36 am
Location: Tampa, FL

Postby dbarker » Thu Sep 22, 2005 4:27 pm

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 :(
dbarker
Senior Member
Senior Member
 
Posts: 183
Joined: Sat Jun 19, 2004 1:07 pm

Next

Return to MLServer Plug-Ins

Who is online

Users browsing this forum: No registered users and 0 guests