Recording schedule statuses?

[cginzel]

I'm wondering if sub or anyone can tell me what the status column values in RECORDING_SCHEDULE mean?

Based on what I see I think the following is true (correct me if I'm wrong):

1 = Recording
2 = Recorded
3 = Failed
5 = Conflict

But what does a status of 0 & 4 mean?

Sub, when does GB-PVR determine the next show to record? GB-PVR obviously determines which shows are in conflict, but does it set a timer when the next show is to be recorded, or does it poll the database?

I'm running GB-PVR on a MSDE database and I've put in an update trigger on RECORDING_SCHEDULE when the status is changed to 2, I queue the unique_identifier from PROGRAMME...

This allows me to collect a list of recorded shows. The next step I want to take is to add a trigger to remove repeat shows.

-Charles

[normanr]

these are the constants from GBPVR.Public.ScheduledRecording:

public const int GROUP_ALLOCATE = -1;
public const int GROUP_NONE = 0;

public const int QUALITY_HIGH = 0;
public const int QUALITY_MEDIUM = 1;
public const int QUALITY_LOW = 2;
public const int QUALITY_CUSTOM1 = 3;
public const int QUALITY_CUSTOM2 = 4;
public const int QUALITY_LIVETV = 5;

public const int STATUS_PENDING = 0;
public const int STATUS_IN_PROGRESS = 1;
public const int STATUS_COMPLETED = 2;
public const int STATUS_COMPLETED_WITH_ERROR = 3;
public const int STATUS_PLACE_HOLDER = 4;
public const int STATUS_CONFLICT = 5;

public const int TYPE_RECORD_ONCE = 0;
public const int TYPE_RECORD_DAILY = 1;
public const int TYPE_RECORD_WEEKLY = 2;
public const int TYPE_RECORD_WEEK_DAYS = 3;
public const int TYPE_RECORD_WEEKEND_DAYS = 4;
public const int TYPE_RECORD_SEASON = 5;

[cginzel]

I see a status of 6 in the RECORDING_SCHEDULE... what does that status mean?

[sub]

Status_deleted=6