Welcome, this is the space where you can find all the MythTV themes I have created. I also post some of the stuff I do around MythTV and Linux in general.

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 - §

MythTV official homepage
MythTV forum
MythTV source code
MythTV Mailinglists


Last Comments

Leon (Update for the Bl…): Hallo ManagementBoy, th…
PomTom (Database backends…): Doesn’t work for me. Cyrm…
tob (A fair amout of W…): this theme is looking awe…
Elkin (BandO some more u…): Hi Peter, thanks for the …
Peter F-B (BandO some more u…): Thanks for you great them…
Elkin (BandO Theme now i…): Hi Jarett! Thanks for rep…
A Fan (BandO Theme now i…): The link doesn’t work.
jarett (BandO Theme now i…): your download link is bro…
Rob Clark (blootube-wide upd…): Thanks very much for brin…
Jesse (blootube-wide upd…): Very nice. The lack of ni…


Top 10

1. (1634) YouTube like flash video player…
2. (1220) BandO Theme for MythTV
3. (849) blootube-wide updated for mytht…
4. (712) BandO Theme now in blue
5. (708) blootube-ng gets some fixes
6. (638) Long overdue bando-blue update
7. (627) blootube-wide for MythTV 0.24
8. (593) Database backends mismatch!
9. (567) Getting LIRC to comile with the…
10. (499) Laima theme got some love



Archives

01 Jul - 31 Jul 2006
01 Aug - 31 Aug 2006
01 Sep - 30 Sep 2006
01 Oct - 31 Oct 2006
01 Nov - 30 Nov 2006
01 Dec - 31 Dec 2006
01 Jan - 31 Jan 2007
01 Feb - 28 Feb 2007
01 Apr - 30 Apr 2007
01 May - 31 May 2007
01 Aug - 31 Aug 2007
01 Dec - 31 Dec 2007
01 Jan - 31 Jan 2008
01 Mar - 31 Mar 2008
01 Apr - 30 Apr 2008
01 Jun - 30 Jun 2008
01 Jul - 31 Jul 2008
01 Aug - 31 Aug 2008
01 Sep - 30 Sep 2008
01 Oct - 31 Oct 2008
01 Dec - 31 Dec 2008
01 Jan - 31 Jan 2009
01 Feb - 28 Feb 2009
01 Mar - 31 Mar 2009
01 Apr - 30 Apr 2009
01 Aug - 31 Aug 2009
01 Oct - 31 Oct 2009
01 Nov - 30 Nov 2009
01 Jan - 31 Jan 2010
01 Feb - 28 Feb 2010
01 Mar - 31 Mar 2010
01 Apr - 30 Apr 2010
01 May - 31 May 2010
01 Jun - 30 Jun 2010
01 Aug - 31 Aug 2010


Miscellany

Powered by Pivot - 1.40.7: 'Dreadwind' 
XML: RSS Feed 
XML: Atom Feed