Our Fotos
Doro's Welt
About Us
Copyright & Impressum Birthday Wishlist

Last Comments

PomTom (Database backends…): Doesn’t work for me. Cyrm…
ManagementBoy (Säkulare Werbung …): Hallo Sarah, ich freue mi…
Sarah (Säkulare Werbung …): Ich habe nicht gesagt, da…
ManagementBoy (Säkulare Werbung …): Hallo Sarah, habe ich Dei…
Sarah (Säkulare Werbung …): ... Weil die Kirche in De…
Rob Clark (blootube-wide upd…): Thanks very much for brin…
Jesse (blootube-wide upd…): Very nice. The lack of ni…
ich (Ach du lieber Got…): Bei Nationalsozialismus u…
Hernan Benitez (About Us): Hola viejo….en “other stu…
alberto (The root of all E…): Hola tío! Sabes… me parec…

Archives

01 Jan - 31 Dec 1994
01 Jan - 31 Dec 1995
01 Jan - 31 Dec 1997
01 Jan - 31 Dec 1998
01 Jan - 31 Dec 2006
01 Jan - 31 Dec 2007
01 Jan - 31 Dec 2008
01 Jan - 31 Dec 2009
01 Jan - 31 Dec 2010

Miscellany

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

« Server crashed breaki… | Home | Cool your Athlon (old… »

Fix bad xmltv entries

I noticed that some channels that get populated using xmltv tend to have a generic title and the actual title of the show shows only in the subtitle. I needed to fix this, so I wrote a small SQL statement to do it.

UPDATE `program` SET `title` = `subtitle` WHERE `title` = 'Cine'

for example writes the subtitle into the title anywhere where "Cine" is in the title. You can change this to any string that gets used as placeholder.

Rate this article:

12345678910
8 rating from 1 votes

This article has been viewed approximately 77 times.



No comments:


No trackback:

Trackback link:

Please enable javascript to generate a trackback url


  
Remember personal info?

Emoticons / Textile

Comment moderation is enabled on this site. This means that your comment will not be visible on this site until it has been approved by an editor.

SPAM is making everyones live hard. As SPAMers don't know how to answer the most easy questions, this helps us keep them away.
 

  (Register your username / Log in)

Notify:
Hide email:

Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.