Where does nextpvr save the number of recordings?

[Sheik Yerbouti]

I want to modify the number of recordings for the "keep"-functionality in Recurring Recordings, but I can't find it in the database. Can someone tell me what table and field it's in? I have some recurring recordings where "keep" was not set, and when I set it now, it starts counting with new recordings, not taking the current set of recordings in account.

Chris

[johnsonx42]

the number of recordings to be kept per recurring recording is in the match_rules field of the RECURRING_RECORDING table. The actual field is <Keep>x</Keep>; 0 means keep all.

there's no running total of the number of completed recordings. instead it tallies it on-the-fly by looking at the SCHEDULED_RECORDING table for the recordings with status=2 (completed) and recurrence_oid=oid from the RECURRING_RECORDING table. If you delete and re-create a recurring recording, or schedule any single recordings, those recording will not have the matching recurrence_oid and therefore won't be included in the tally.

(also note that any recordings created by the "alternative airing on conflict" logic will be single recordings with recurrence_oid=0)

[BrettB]

I believe that I recall sub recently said that if you use the Archive function to move a recording to a different drive/folder, it will also set the recurrence_oid to 0.

[johnsonx42]

Correct. In fact that was my request, as the original archive function did not, which meant you could archive a recording and then it would still get auto-deleted which seemed to defeat the purpose of archiving it.

[Sheik Yerbouti]

Thanks for explaning this, guys!

Chris