Kroozbox - PVD to media theatre solution

[Nono]

Hello Gang,

New version of Kroozbox available at:

http://www.mediaplayersite.com/Kroozbox

Modification done to accomodate new Syabas flash based templates (for Popcorn hour C-300, Popbox ,etc) and LG Smart TV template.

The LG template requires download from the LG market - search for 'Kroozbox' on the LG TV. Note that, at this time, the app is not yet available. Still under review by LG staff - hopefully available soon. In the mean time, connection can still be made using LG browser.

Enjoy,
Nono

[fabs]

First of all I wanted to say that this is an amazing piece of code.

I've been able to slightly modify the templates to my liking, but I'd like the possibility to filter by number as first character in title. Is there an easy way to add that option?

Also, is there a way to add more info to the movie details (i.e., a link to imdb)?

[Nono]

Hello,

Thanks for the nice words.

If you choose the # sorting you should see the listing with the titles with numbers at first location (might depends on the template you are using).
As for adding more details, I would need to know what template you are using (LG, Popcorn, Music, or.... ).. detailsdetails!??

Thanks,
Nono

[fabs]

I downloaded the latest version of PVDTemplate-HD that appears in the website and it doesn't have filtering by #. If there's another one that has it, let me know and I'll just copy the code.

I found how to add the links or extra info. Is there a way to make the changes to all the corresponding files (for example, when editing the listings) at the same time or do I have to go one by one?

Thanks!

[Nono]

You do have the number listing (kind of). If you select "all" entries at the top, the listing will be sorted alphabetically starting with the movies having their titles starting with space, numbers and none-English characters. Make sense?

As for you second question, I'm not sure to understand. Are you asking if there is a way to edit the movies in batch in PVD? or if a change to an sql request within the DBINFO header in the template can be easily change in all the necessary template files?

PVDTemplate was the first template I made, it is tedious to change something because it has a lot of files but its a much simpler template (to understand) then the LG template for instance.

What is your rendering engine? using a PC, a Porcorn hour (which model?) or ...?

Nono

[fabs]

Nono,

I'm rendering using a browser in a PC, as I want it mostly as movie catalogue. The main problem is that changing the HTML in the template requires going through many similar files to do the same change.

Additionaly, I cannot seem to find the way to use custom fields in Kroozbox. Are they stored under a special name in the DB?

[Nono]

yes, many files... simplicity but redundancy. With the new version of Kroozbox engine, I should be able to simplify a lot but not enough time to do it. You also have the flash version that you can access with :
http://your server address:9009/debug.html (called PVD Syabas flash template or something like that).
But I don't think you will like it - need to move with keyboard.

Yes, you can have access to custom PVD field... There were some posts about this. I'll dig tomorrow and let you know how to do it. (remind me if I forget).

Nono

[Nono]

For the custom field:
There are 4 SQL tables that store the data. They are:
CUSTOM_VALUES_DATE - for date custom fields
CUSTOM_VALUES_INT - for?? custom fields
CUSTOM_VALUES_LONGSTR - for long text fields (memo I guess as well)
CUSTOM_VALUES_REAL
CUSTOM_VALUES_SHORSTR - for short text fields.

You will have to choose the proper table for the type of data you store.
The CUSTOM_FIELDS_MOVIES holds the reference of the fields display value and types.

To add a custom field to your Movie details for instance. You would insert a new file into the MovieDetail-x sequence. Rename all the MovieDetail-*.html from 8 to 10 with an increment of 1 making them 9 to 11. So you can now create a file called MovieDetail-8.html.

Put this content in the -8.html file:

Code: [Select]

<!--DBINFO
REQUEST=SELECT FIRST 1 "value" FROM "CUSTOM_VALUES_SHORTSTR" INNER JOIN "MOVIES" ON "MOVIES"."mid" = "CUSTOM_VALUES_SHORTSTR"."mid" INNER JOIN "CUSTOM_FIELDS_MOVIES" ON "CUSTOM_FIELDS_MOVIES"."cmfid" = "CUSTOM_VALUES_SHORTSTR"."cmfid" WHERE "CUSTOM_FIELDS_MOVIES"."dispname" = 'My custom display' AND "MOVIES"."mid"=[parentref]
MYCUSTOMFIELD-S=value
RECORDCHARSET=UTF-8
-->

<tr>
           <td class="title3" colspan="1">My field</td>
     <td class="normal" colspan="3"><!--MYCUSTOMFIELD-S--></td>
</tr>

Replace all occurrence of CUSTOM_VALUES_SHORTSTR with the proper table name for the type of custom field you use.
Replace the 'My custom display' value with want you see in PVD for your custom field.
We could use the globalParam file to store table names or what not and/or other SQL request but I think this is the simplest way.

Make sense?