MySQL DB-Manual for tables (1 Viewer)

Commifreak

New Member
July 28, 2009
4
0
Home Country
Germany Germany
MediaPortal Version: 1.1.0RC1

Exists a short manual for the record and schedule table of MediaPortal MySQL DB Layout? I dont found anything.

Thanks
 

Commifreak

New Member
July 28, 2009
4
0
Home Country
Germany Germany
AW: MySQL DB-Manual for tables

Hm, Ok.

Should the record and schedule table be filled when record a simple movie? Or only record/schedule?

I want to write a simple php-script which add a recording, and i dont know which tables of these 2 are used for this.
 

riksmith

Portal Pro
April 18, 2009
1,856
322
Home Country
Netherlands Netherlands
The schedule entry is used to schedule a recording, so that should be filled. MP will create the recording entry when it starts recording.
 

Commifreak

New Member
July 28, 2009
4
0
Home Country
Germany Germany
AW: MySQL DB-Manual for tables

Hello again,

I hope you can answer this question: What values are valid in these fields?

  • scheduleType
  • maxAirings
  • priority
  • directory (path to *.ts?)
  • quality
  • keepMethod
  • keepDate
  • recommendedCard (Number of card listed in 'card'?)
  • series

Thanks a lot!
 

Users who are viewing this thread


Write your reply...

Similar threads

Hi, I didn't have SQL problems but just wanted to agree that on my Win7 system, a clean install of 1.36 TV server x86 does not work since it won't start the TV server configuration. Installing 1.33 first and upgrading to1.36 fixed the problem. Eggert
Hi, I didn't have SQL problems but just wanted to agree that on my Win7 system, a clean install of 1.36 TV server x86 does not...
Hi, went from a 1.29 install (working, reinstalled for other reasons) on a fairly fresh and fully updated Windows 10 system for a...
Replies
26
Views
5K
I did a check of MP 1.36 x64 on Win11 and I can confirm, that the TV server correctly detects running MediaPortal.exe process.
I did a check of MP 1.36 x64 on Win11 and I can confirm, that the TV server correctly detects running MediaPortal.exe process.
Hi, I am using MP in a client-only setup including DVB-S card for over 10 years now. And regularily scheduling records waking up...
Replies
9
Views
1K
To be fair the normal uninstall is usually more than sufficient. I regularly uninstall and reinstall MP 1 as part of the testing process and only very rarely have I needed to use the manual procedure posted by @CyberSimian to overcome the error you ran into. I also believe there is a procedure to repair the MySQL install in the event...
To be fair the normal uninstall is usually more than sufficient. I regularly uninstall and reinstall MP 1 as part of the testing...
I am trying to install Mediaportal with TV Server. I tried many versions, including current x64 and new prerelease x86, and...
Replies
3
Views
2K
It is present, but not with that name. It is called Scheduler, viz: Interesting. I had never noticed that when the "command" is "ACTION", the "cmdproperty" is the actual window id, but it makes sense that it is. Try this for yourself. First backup your working profile for the remote, then in the "Mapping" panel make a change to...
It is present, but not with that name. It is called Scheduler, viz: Interesting. I had never noticed that when the "command" is...
I would like to be able to go directly to the Scheduled recordings window without having to first go to the home menu. I saw this...
Replies
1
Views
313
20Jun25 : 06:20am :sleep: Unfortunately, now Gracenote is rotating its IP every few seconds daily and also from day-to-day so that you cannot capture it is we did a few days ago. Adding all three visible IP addressess to the 'hosts' file as was suggested no longer works either. Replacing 'zap2it' with 'Gracenote' in the ZAP2XML.PL...
20Jun25 : 06:20am :sleep: Unfortunately, now Gracenote is rotating its IP every few seconds daily and also from day-to-day so...
Please help, It would be a great help to me just to know if people are still getting tvlisting from gracenote.com. When zap2it...
Replies
2
Views
744
Top Bottom