[dteirney]

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]

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]

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]

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)