Webinterface plugin (1 Viewer)

[LordMessi]

I am new to Media Portal, but I'd like remote (web) access to the tv schedule. So I was playing around with apache/php/sqlite3 to gain access to the db.

But I'm kinda lost right now since apache won't load the pdo modules. Apache gives a warning saying:

"PHP Startup: Unable to load dynamic library 'c:\wamp\php5\ext\php_pdo.dll' - The specified procedure could not be found."

and

"PHP Startup: Unable to load dynamic library 'c:\wamp\php5\ext\php_pdo_sqlite.dll'- The specified procedure could not be found."

The required dll's (php_pdo.dll and php_pdo_sqlite.dll) are to be found in the correct directory (c:\wamp\php5\ext). And I have no problem loading non-pdo modules (no extensive testing though).

Apache: 2.0.44 (win32)
PHP: 5.1.0b3 (win32)

httpd.conf
---------
LoadModule php5_module "c:/wamp/php5/php5apache2.dll"
AddType application/x-httpd-php .php
PHPIniDir "c:/wamp/php5"

php.ini
--------
extension_dir = c:\wamp\php5\ext
extension=php_pdo.dll
extension=php_pdo_sqlite.dll

Furthermore I've tried removing all access restrictions from relevant directories and changing "\" to "/" in various paths.

Used script below to access the db:

<?php
//Check pdo drivers
print_r(pdo_drivers());

// Open database
$db = sqlite_open("TVDatabaseV21.db3");

// simple select
$result = sqlite_query($db, "select strChannel from channel");

// grab each row as an array
while ($row = sqlite_fetch_array($result)) {
print_r($row); }

// close the database
sqlite_close($db);
?>

print_r(pdo_drivers()); returns "Array ( [0] => sqlite2 ) ". Using TVDatabaseV18.db from MP releae 1.2.0 works ok.

Never meant this to be such an extensive post, but anybody out there who can point me in the right direction? Doesn't have to be apache + php, other websolutions are ok with me.

We are currently developing a version which will work with sqllite v3 / mediaportal 0.1.3.0 - to answer your question, contact me on MSN

sqlite_* does'nt work with version 3 of sqllite.....I'm home tonight.

//Thomas

 

[LordMessi]

Hi there...

As a new MP user i'm closely looking at the development of this plugin.
Is there a place to put requests/suggestions for your plugin?

If it is here i have a suggestion:
Put a onClick event in your <TD> This way it's also possible to click on the bar of the program instead of just the title.

Greetings

Gerwin

Hi Gerwin,

Suggestions/Requests/Bugs can be reported here for now, but in the future http://www.mediaportal.dk will be used as the official page. As of your suggestion, I will incorporate this in to the new version.

Thank you for your suggestion, keep em' coming.

//Thomas

 

[gdekeijzer]

Thank you for your suggestion, keep em' coming.

//Thomas

No problem... here are few more:
GUIDE:
- on same <TD> tag add the onmousover feature for lighting up de box of the program in bright color.
- when implementing onclick (previous suggestion) remove <A> tag. This might remove the flicker when hovering over programtitle
- reduce size of your JPG's there too big. Maybe (in the open source mind) convert them to PNG
- Add browse arrows on top and bottom (show next 2 or 3 hours)
C_DETAIL
- remove the hoverscreen at bottom (upcoming episodes). Info is already there

Ok.. so far my 2 cents...

Hope i can help in this way (or any other).

Gerwin

 

[LordMessi]

Thank you for your suggestion, keep em' coming.

//Thomas

No problem... here are few more:
GUIDE:
- on same <TD> tag add the onmousover feature for lighting up de box of the program in bright color.
- when implementing onclick (previous suggestion) remove <A> tag. This might remove the flicker when hovering over programtitle
- reduce size of your JPG's there too big. Maybe (in the open source mind) convert them to PNG
- Add browse arrows on top and bottom (show next 2 or 3 hours)
C_DETAIL
- remove the hoverscreen at bottom (upcoming episodes). Info is already there

Ok.. so far my 2 cents...

Hope i can help in this way (or any other).

Gerwin

Nice ones!!! I will put em on paper.....Is there any way that I can contact you besides PM and email? MSN? ICQ? AIM? soooo on....

 

[cedriclocqueneux]

No news about the new MPW ?

 

[gdekeijzer]

One of the developers is on holiday but should return today

Hopefully they will continue this plugin.

 

[LordMessi]

One of the developers is on holiday but should return today

Hopefully they will continue this plugin.

Yes, I've returned today.....man I'm beat! I've been driving for hours to get home.....

//Thomas

 

[cedriclocqueneux]

Great !

 

[LordMessi]

Webinterface - BETA

Hi all,

A BETA version of the next Webinteface is aval. on http://www.mediaportal.dk

Remember that you need to Apache, PHP 5.0+ and MP 0.1.X running on the same machine.

If you have any problems, don't hesitate to contact me.

Yes, this version will work with MP 0.1.3 , but remember that's still a BETA...

 

[infinite.loop]

great!
i will have a look