[TV] Be able to select preferred card when scheduling a recording (1 Viewer)

[pnyberg]

Hi,

This is an old request but since the forum has been redesigned I decided to submit again.

I want to be able to select the preferred card when scheduling a recording. I know it is already implemented in the DB - but it is not available in the GUI when scheduling a recording.

See my signature for a workaround - but it is only useful for recurring recordings...

Thanks

 

[kkendall]

Man, it's been ages since this was proposed/ requested/ begged for for the first time
I've seen it come by again and again, but no final solution yet I guess...

For what I can read they are almost there...but forgot to finish it up.
I really hope they can finish up the last bit so everybody can use this usefull feature!

 

[pnyberg]

Came to think about triggers in MS SQL... I just added a trigger to my schedule table which enables me to set "recommendedcard" to what I want. Used this simple SQL statement:

USE [MpTvDb]
GO
/****** Object: Trigger [dbo].[recommendedcard] Script Date: 07/26/2009 22:27:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Patrik
-- Create date: 2009-07-26
-- Description: Trigger to update recommended.card
-- =============================================
ALTER TRIGGER [dbo].[recommendedcard]
ON [dbo].[Schedule]
AFTER INSERT,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for trigger here
Update dbo.schedule set recommendedcard=2
END

I'm not sure if MySQL have triggers? Otherwise this should be fairly simple for the devs to incorporate in MP...?
You need to add a setting in the configuration program of the tvservice where you can set your recommendedcard and then create/alter the trigger?

Just a thought. But in the meantime this works for me.

Keep up the good work devs!