Self Contained Web Server / Interface - Page 40

groovyclam · 2008-04-13, 13:11

Kev - can you help me please!

I'm trying to write a plugin that is triggered by a TVSchedule app we have in the UK called DigiGuide.

I want the plugin to take data that is sent by DigiGuide and shedule a recording in the TVServer.

Your Web Scheduler seems a similar way into this. I have some questions that I hope you can help me with.

1. Is scheduling a recording as simple as writing an appropriate line into the "schedule" table ?
I tried doing this manually using MYSQL GUI database browser but the TVServer didn't pick it up and start the recording.

2. Is there another table that needs updating as well as the schedule table ? Or something else that need doing after writing the line to the schedule table ?

If you prefer to keep this thread solely for discussing your Web Scheduler support then you can contact me directly at:

g r o o v y c l a m _at_ hotmail.com

gunck4 · 2008-04-13, 18:54

Hi Big_Kev,

I'm running my TvLibrary database on a linux machine and as you probably know table names are case sensitive there. That causes troubles for the WebInterface that queries the database using only lower case characters in the table names.

"MP Web Server Error 500
The Web Server has encountered the following error:

[AnyDAC][Phys][MySQL][LIBMYSQL] Table 'TvLibrary.channelgroup' doesn't exist"

The table should for example be queried with 'TvLibrary.ChannelGroup' instead of 'TvLibrary.channelgroup'.

Is it possible to change the database operations so they also would work in linux users environments?

EDIT: By setting lower_case_table_names=1 in my.cnf it is possible to make MySQL on linux case insesitive to, so I think I can live with that.

Thank you anyway!

-gunck4

erosco · 2008-04-18, 08:57

Knock Knock - Is Big Kev still around? :-)

Marcusb · 2008-04-18, 14:29

Quote:

Originally Posted by erosco

Knock Knock - Is Big Kev still around? :-)

He did say he was going away camping until just over a week ago.
The weather in Australia has been pretty great lately so maybe he stayed longer?

cheezey · 2008-04-19, 11:43

A quick heads up for ipod touch / iphone users, add the following to the headers of the HTML files used by the web interface to get the pages showing better in Safari..

HTML Code:

<meta name = "viewport" content = "width = device-width">

You can see the difference in the screenshots below for the main menu & main guide with & without the meta tag.

Just saves a bit of zooming

TranceManNZ · 2008-04-20, 08:21

Quote:

Originally Posted by cheezey

A quick heads up for ipod touch / iphone users, add the following to the headers of the HTML files used by the web interface to get the pages showing better in Safari..

HTML Code:

<meta name = "viewport" content = "width = device-width">

You can see the difference in the screenshots below for the main menu & main guide with & without the meta tag.

Just saves a bit of zooming

Sounds good to me. Can you give a little more instructions for us dumbass's that have no idea?

Kev, i love this server.

cheezey · 2008-04-20, 09:41

Locate the .htm files in C:\Program Files\MP Web Interface or C:\Program Files\MP Web Interface\PDA

Open each one and add the line

<meta name = "viewport" content = "width = device-width">

immediately after the

<head>

then close & save the file.

TranceManNZ · 2008-04-21, 09:50

Thanks cheezey!!! works mint.
All we need now is someone to make us a good itouch remote app to control MP

stefan04 · 2008-04-23, 08:51

Hi,

First of all - Thanks for a great piece of software!! Just installed it and had it running in minutes!
I am running the MySQL server on a linux box and the webserver itself is running on a windows workstation in vmware. My Mediaportal pc is not on all day, so my question is, is it possible that when a recording has been scheduled via the webserver, and the Mediaportal pc is not aware of it (yet) because it hasn't been on since the recording has been scheduled, that the webservice on my vmware machine boots up my Mediaportal pc (via wake on lan e.g) ??

Stefan

jabaah · 2008-04-23, 10:43

Hi,

first of all a big THANKS for this Webcontrol, its perfect!!!
Is it possible to make a rangebox for selecting the TV-Card, when add an record from epg??

Many thanks for resolve this!

2008-04-13, 18:54	#392 (permalink)
gunck4 Portal Member Join Date: Dec 2007 Posts: 11 Thanks: 0 Thanked 0 Times in 0 Posts Country:	Problem with database on linux Hi Big_Kev, I'm running my TvLibrary database on a linux machine and as you probably know table names are case sensitive there. That causes troubles for the WebInterface that queries the database using only lower case characters in the table names. "MP Web Server Error 500 The Web Server has encountered the following error: [AnyDAC][Phys][MySQL][LIBMYSQL] Table 'TvLibrary.channelgroup' doesn't exist" The table should for example be queried with 'TvLibrary.ChannelGroup' instead of 'TvLibrary.channelgroup'. Is it possible to change the database operations so they also would work in linux users environments? EDIT: By setting lower_case_table_names=1 in my.cnf it is possible to make MySQL on linux case insesitive to, so I think I can live with that. Thank you anyway! -gunck4 Last edited by gunck4; 2008-04-13 at 19:30. Reason: Found a solution myself.

2008-04-19, 11:43	#395 (permalink)
cheezey Portal Member Join Date: Aug 2004 Location: West Yorks Age: 40 Posts: 395 Thanks: 3 Thanked 4 Times in 4 Posts Country: My System	A quick heads up for ipod touch / iphone users, add the following to the headers of the HTML files used by the web interface to get the pages showing better in Safari.. HTML Code: <meta name = "viewport" content = "width = device-width"> You can see the difference in the screenshots below for the main menu & main guide with & without the meta tag. Just saves a bit of zooming Attached Thumbnails

2008-04-23, 08:51	#399 (permalink)
stefan04 Portal Member Join Date: Oct 2007 Posts: 7 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	Wake up Mediaportal Server when recording scheduled Hi, First of all - Thanks for a great piece of software!! Just installed it and had it running in minutes! I am running the MySQL server on a linux box and the webserver itself is running on a windows workstation in vmware. My Mediaportal pc is not on all day, so my question is, is it possible that when a recording has been scheduled via the webserver, and the Mediaportal pc is not aware of it (yet) because it hasn't been on since the recording has been scheduled, that the webservice on my vmware machine boots up my Mediaportal pc (via wake on lan e.g) ?? Stefan

2008-04-23, 10:43	#400 (permalink)
jabaah Portal User Join Date: Aug 2004 Posts: 4 Thanks: 0 Thanked 0 Times in 0 Posts	Rangebox fpr TV-Card Hi, first of all a big THANKS for this Webcontrol, its perfect!!! Is it possible to make a rangebox for selecting the TV-Card, when add an record from epg?? Many thanks for resolve this!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2008-04-13, 13:11	#391 (permalink)
groovyclam Portal User Join Date: Apr 2008 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts	Kev - can you help me please! I'm trying to write a plugin that is triggered by a TVSchedule app we have in the UK called DigiGuide. I want the plugin to take data that is sent by DigiGuide and shedule a recording in the TVServer. Your Web Scheduler seems a similar way into this. I have some questions that I hope you can help me with. 1. Is scheduling a recording as simple as writing an appropriate line into the "schedule" table ? I tried doing this manually using MYSQL GUI database browser but the TVServer didn't pick it up and start the recording. 2. Is there another table that needs updating as well as the schedule table ? Or something else that need doing after writing the line to the schedule table ? If you prefer to keep this thread solely for discussing your Web Scheduler support then you can contact me directly at: g r o o v y c l a m _at_ hotmail.com

2008-04-18, 08:57	#393 (permalink)
erosco Portal Member Join Date: Jun 2007 Age: 40 Posts: 53 Thanks: 11 Thanked 2 Times in 2 Posts Country: My System	Knock Knock - Is Big Kev still around? :-)

2008-04-20, 09:41	#397 (permalink)
cheezey Portal Member Join Date: Aug 2004 Location: West Yorks Age: 40 Posts: 395 Thanks: 3 Thanked 4 Times in 4 Posts Country: My System	Locate the .htm files in C:\Program Files\MP Web Interface or C:\Program Files\MP Web Interface\PDA Open each one and add the line <meta name = "viewport" content = "width = device-width"> immediately after the <head> then close & save the file.

2008-04-21, 09:50	#398 (permalink)
TranceManNZ Portal Member Join Date: Jul 2006 Posts: 48 Thanks: 1 Thanked 1 Time in 1 Post	Thanks cheezey!!! works mint. All we need now is someone to make us a good itouch remote app to control MP

LinkBacks (?) LinkBack to this Thread: http://forum.team-mediaportal.com/development-91/self-contained-web-server-interface-27320/
Posted By	For	Type	Date
HTPC, MediaPortal [35] - iXBT.com	This thread	Refback	Yesterday 17:50
Tekniska tankar Saker jag tänkt testa (när jag får tid…)	This thread	Refback	2008-08-20 15:21
Tekniska tankar Mediaportal	This thread	Refback	2008-08-05 20:45
Extensions-TV-Server-Plugins - MediaPortal Documentation	This thread	Refback	2008-07-21 09:37
Tekniska tankar	This thread	Refback	2008-07-09 14:52

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
TVE3 Web User Interface	goatse	Development	29	2008-05-12 17:14
Web Interface	tucholka	MediaPortal 1 Talk	1	2007-04-16 14:44
Updated interface for MP Web Controller	quiller	Skins	0	2007-01-21 07:14
Web Interface like xbmc?	brandenpro	Plugins	1	2005-09-05 08:19
Web Interface......	spo	General Development (no feature request here!)	24	2004-11-07 11:33