Recorded table

From MythTV

The recorded table, lists programs which have already been recorded (or recorded and then transcoded) and are still available for viewing, translating the Internal Filenames into something safe for human consumption.

Table Description

Fields

• bookmark=1 indicates that there is a 'Position Saved' for this recording (ie: user pressed space during playback, or exited playback early).

• commflagged contains status of the commercial flagging, values are defined in programinfo.h:
  • 0 = not flagged
  • 1 = flagging done
  • 2 = processing
  • 3 = commfree (channel)

• recgroup is the name of the recording group this recording belongs to. This relates to the recgroup field of the recgrouppassword table.

Hacks

If you want all bookmarked recordings to show up in the "Recording List" in their own category (say, '_Bookmarked'), you can use these mysql commands:

To update any shows already bookmarked:

UPDATE recorded
SET category = '_Bookmarked'
WHERE bookmark = 1;

and then, for all future bookmarks:

CREATE TRIGGER recorded_category BEFORE UPDATE ON recorded
FOR EACH ROW BEGIN
	IF NEW.bookmark = 1 THEN
		SET NEW.category = '_Bookmarked';
	END IF;
END;

You then need to press M in Recording List, and Change Group View to show categories.

Or, if you dont like to use categories, then you might prefer prefixing the subtitle:

DELIMITER //

DROP TRIGGER recorded_subtitle
//

--execute this step multiple times to strip of existing prefixes:
UPDATE recorded
SET subtitle = RIGHT(subtitle,LENGTH(subtitle)-1)
WHERE LEFT(subtitle,1)='!' 
//

UPDATE recorded
SET subtitle = CONCAT('!',subtitle)
WHERE bookmark = 1
//

UPDATE recorded
SET subtitle = CONCAT('!',title)
WHERE subtitle = '!'
//

CREATE TRIGGER recorded_subtitle BEFORE UPDATE ON recorded
FOR EACH ROW BEGIN
	IF NEW.bookmark = 1 AND LEFT(NEW.subtitle,1)<>'!' THEN
		IF LENGTH(NEW.subtitle) = 0 THEN
			SET NEW.subtitle = CONCAT('!',NEW.title);
		ELSE
			SET NEW.subtitle = CONCAT('!',NEW.subtitle);
		END IF;
	END IF;
END
//

DELIMITER ;

-- by harvest316