13 June 10 - 23:16Gallery and OSD for Willi

Update: New version available.

While watching some of the Word Cup games I worked on theming the Gallery screens and created a new OSD theme to match Willi. Enjoy. This version is only compatible with development builds of MythTV aiming for version 0.24, as font definitions and the OSD have changed from 0.23.

popup

popup

popup

managementboy - elkin-wide - No comments - § ¶

09 June 10 - 19:35Changing title of many recordings in MythTV

Sometimes I record something that has a way to general title, but I don't want to have to go through 10 instances of it manually. I use the following SQL statement to change the title based on the subtitle:

UPDATE `mythconverg`.`recorded` SET `title` = 'For Queen and Country' WHERE `subtitle` LIKE '%For Queen and Country%';

managementboy - elkin-wide - No comments - § ¶

18 June 10 - 19:59Remove HTML tags in MythTV fields

If for any reason you end up with HTML tags in your descriptions of MythTV recordings, the following SQL statement will remove them for you.

SET GLOBAL log_bin_trust_function_creators=1;
DROP FUNCTION IF EXISTS fnStripTags;
DELIMITER |
CREATE FUNCTION fnStripTags( Dirty varchar(4000) )
RETURNS varchar(4000)
DETERMINISTIC 
BEGIN
  DECLARE iStart, iEnd, iLength int;
    WHILE Locate( '<', Dirty ) > 0 And Locate( '>', Dirty, Locate( '<', Dirty )) > 0 DO
      BEGIN
        SET iStart = Locate( '<', Dirty ), iEnd = Locate( '>', Dirty, Locate('<', Dirty ));
        SET iLength = ( iEnd - iStart) + 1;
        IF iLength > 0 THEN
          BEGIN
            SET Dirty = Insert( Dirty, iStart, iLength, '');
          END;
        END IF;
      END;
    END WHILE;
    RETURN Dirty;
END;
|
DELIMITER ;
UPDATE `mythconverg`.`recorded` SET `description` = fnStripTags(`description`); 

managementboy - Linux - No comments - § ¶