+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: PVR & Live TV Support (https://forum.kodi.tv/forumdisplay.php?fid=167)
+---- Forum: MythTV (https://forum.kodi.tv/forumdisplay.php?fid=170)
+---- Thread: Your MythTV categories needed! (/showthread.php?tid=104075)
Your MythTV categories needed! - dteirney - 2011-06-23
I need some lists of categories that are in peoples mythconverg database. As best I can tell the category is completely defined by the EPG service that is used so there's a really good chance mapping everything to the Genres that XBMC expects will be impossible.
Below is the list of categories in my database...
mysql> select distinct(category) from program order by category ASC;
+-----------------+
| category |
+-----------------+
| |
| action |
| adult |
| adventure |
| animals |
| animated |
| cartoon |
| childrens |
| comedy |
| cooking |
| crime |
| current affairs |
| documentary |
| drama |
| educational |
| entertainment |
| fantasy |
| fishing |
| food |
| game show |
| garden |
| home |
| horror |
| motoring |
| movie |
| music |
| news |
| reality |
| religious |
| science fiction |
| series |
| shopping |
| soaps |
| sport |
| talk show |
| travel |
+-----------------+
36 rows in set
What does your database have
- .luke - 2011-06-23
mysql> select distinct(category) from program order by category ASC;
+----------------------+
| category |
+----------------------+
| action and adventure |
| action/adventure |
| adventure |
| animated |
| arts |
| awards/event |
| baseball |
| biography |
| boxing |
| business |
| children |
| comedy |
| cooking |
| current events |
| documentary |
| drama |
| educational |
| episodic |
| exercise |
| fantasy |
| game show |
| golf |
| health |
| home and garden |
| horror |
| interview |
| kids |
| lifestyle |
| movies |
| music |
| news |
| other |
| outdoor |
| paid programming |
| racing |
| reality |
| series |
| soap opera |
| soccer |
| sports |
| talk show |
| travel |
+----------------------+
- dakota34 - 2011-06-24
mysql> select distinct(category) from program order by category ASC;
+--------------------+
| category |
+--------------------+
| |
| Action |
| Adults only |
| Adventure |
| Agriculture |
| Animals |
| Animated |
| Anthology |
| Art |
| Auto |
| Auto racing |
| Aviation |
| Awards |
| Baseball |
| Biography |
| Bus./financial |
| Card games |
| Children |
| Children-special |
| Collectibles |
| Comedy |
| Comedy-drama |
| Community |
| Computers |
| Consumer |
| Cooking |
| Crime |
| Crime drama |
| Dance |
| Docudrama |
| Documentary |
| Drama |
| Educational |
| Entertainment |
| Environment |
| Equestrian |
| Exercise |
| Fantasy |
| Fashion |
| Fishing |
| Football |
| French |
| Fundraiser |
| Game show |
| Gaming |
| Gay/lesbian |
| Golf |
| Health |
| Historical drama |
| History |
| Hockey |
| Holiday |
| Holiday special |
| Holiday-children |
| Home improvement |
| Horror |
| House/garden |
| How-to |
| Hunting |
| Interview |
| Law |
| Martial arts |
| Medical |
| Military |
| Miniseries |
| Mixed martial arts |
| Music |
| Music special |
| Musical |
| Musical comedy |
| Mystery |
| Nature |
| News |
| Newsmagazine |
| Outdoors |
| Parade |
| Paranormal |
| Parenting |
| Poker |
| Politics |
| Public affairs |
| Reality |
| Religious |
| Rodeo |
| Romance |
| Romance-comedy |
| Science |
| Science fiction |
| Self improvement |
| Shopping |
| Sitcom |
| Soap |
| Soccer |
| Spanish |
| Special |
| Sports event |
| Sports non-event |
| Sports talk |
| Standup |
| Suspense |
| Talk |
| Technology |
| Tennis |
| Travel |
| Variety |
| War |
| Weather |
| Western |
| Wrestling |
+--------------------+
109 rows in set
- jms-xbmc - 2011-06-25
Code:
+------------------------------------------------------------+
| category |
+------------------------------------------------------------+
| |
| Arts/Culture |
| dokumentit |
| draama |
| Education/Science/Factual |
| Entertainment |
| Film/Cinema |
| Football (Soccer) |
| Kids |
| Leisure/Hobbies |
| Martial Sports |
| Misc. Team Sports |
| Motor Sport |
| Movie |
| Movie - Adult |
| Movie - Adventure/Western/War |
| Movie - Comedy |
| Movie - Detective/Thriller |
| Movie - Science Fiction/Fantasy/Horror |
| Movie - Serious/Classical/Religious/Historical Movie/Drama |
| Music/Ballet/Dance |
| News |
| Original Language |
| Social/Policical/Economics |
| Special Events (World Cup, World Series, etc) |
| Sports |
| Sports Magazines |
| urheilu |
| uutiset |
| vapaa aika |
| Water Sport |
+------------------------------------------------------------+
31 rows in set (0.11 sec)