Select Channels and start/end time from SQL Database

Tauren · 2006-03-01, 17:56

Hi, i want to set up a plugin for media portal that will connect to an SQL database, take a channel value, start time and end time values, and set media portal to record the selected channel for the specified time. Is this possible? Has it been done? Can anyone point me in the right direction for how to do it if possible?

Tauren · 2006-03-02, 10:35

Bump - any help on this?

Maschine · 2006-03-02, 11:18

Hi!

Please explain further! Do you want an MP-internal Plugin to connect to an external (My)SQL-Server? Or do you want to write an external prog to read/write from/to MP's databases?

Maschine

Tauren · 2006-03-02, 14:19

Which ever is easiest to be honest.

I want to create a program (plugin or otherwise) that will hook up to a SQL database i have, which will take values for Channel, Start Time and End Time. These values will be entered into the database via a wap page. Basically, the system will allow users to enter the required info via their mobile phone (wap), the program will then periodically (5/10mins) check the database for the information regarding the user, and set Media Portal to record the specified channel.

The goal is to allow someone down the pub or what ever to set Media Portal to record a program, if they forgot to set it before they went out.

Maschine · 2006-03-02, 14:23

Why not having a look at MPW, the webinterface for MP, which also includes a WAP interface. Your described scenario is already possible there ;-)

Maschine

Tauren · 2006-03-02, 14:37

ah but i need to develop one for college!

Maschine · 2006-03-02, 14:43

Look at the sources then. You'll find some ideas there.

Tauren · 2006-03-02, 15:11

cheers for the help

2006-03-01, 17:56	#1 (permalink)
Tauren Portal Member Join Date: Feb 2006 Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts	Select Channels and start/end time from SQL Database Hi, i want to set up a plugin for media portal that will connect to an SQL database, take a channel value, start time and end time values, and set media portal to record the selected channel for the specified time. Is this possible? Has it been done? Can anyone point me in the right direction for how to do it if possible?

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

2006-03-02, 10:35	#2 (permalink)
Tauren Portal Member Join Date: Feb 2006 Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts	Bump - any help on this?

2006-03-02, 11:18	#3 (permalink)
Maschine Portal Developer Join Date: Jun 2004 Location: Germany Posts: 514 Thanks: 13 Thanked 5 Times in 5 Posts Country:	Hi! Please explain further! Do you want an MP-internal Plugin to connect to an external (My)SQL-Server? Or do you want to write an external prog to read/write from/to MP's databases? Maschine

2006-03-02, 14:19	#4 (permalink)
Tauren Portal Member Join Date: Feb 2006 Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts	Which ever is easiest to be honest. I want to create a program (plugin or otherwise) that will hook up to a SQL database i have, which will take values for Channel, Start Time and End Time. These values will be entered into the database via a wap page. Basically, the system will allow users to enter the required info via their mobile phone (wap), the program will then periodically (5/10mins) check the database for the information regarding the user, and set Media Portal to record the specified channel. The goal is to allow someone down the pub or what ever to set Media Portal to record a program, if they forgot to set it before they went out.

2006-03-02, 14:23	#5 (permalink)
Maschine Portal Developer Join Date: Jun 2004 Location: Germany Posts: 514 Thanks: 13 Thanked 5 Times in 5 Posts Country:	Why not having a look at MPW, the webinterface for MP, which also includes a WAP interface. Your described scenario is already possible there ;-) Maschine

2006-03-02, 14:37	#6 (permalink)
Tauren Portal Member Join Date: Feb 2006 Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts	ah but i need to develop one for college!

2006-03-02, 14:43	#7 (permalink)
Maschine Portal Developer Join Date: Jun 2004 Location: Germany Posts: 514 Thanks: 13 Thanked 5 Times in 5 Posts Country:	Look at the sources then. You'll find some ideas there.

2006-03-02, 15:11	#8 (permalink)
Tauren Portal Member Join Date: Feb 2006 Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts	cheers for the help