[mythtv] upnp sort order - proposed patch

[Bob Arendt]

Using the UPNP feature on a stock TV, I found the sort
"By Title" feature much more usable when if the folder
contents were sorted by "programid".  This resulted in
the shows associated with a title being sorted into
episode order, rather than title, subtitle, or the
happenstance of airdate.  If episodes are recorded
out-of-order, they end up presented in correct order.
I'm currently using mythtv on Fedora 20.

I think others may find this patch useful.  Here's the
quick hack I applied to mythtv.  Though 0.27, it looks
like it should apply directly to mythtv in git:

--------------
--- mythtv-0.27/mythtv/programs/mythbackend/upnpcdstv.cpp	2013-09-18 13:06:08.000000000 -0700
+++ mythtv-0.27/mythtv/programs/mythbackend/upnpcdstv.cpp_new	2013-12-01 14:12:22.044382110 -0700
@@ -46,8 +46,8 @@
            "1 as children "
              "FROM recorded "
              "%1 "
-            "ORDER BY starttime DESC",
-        "", "starttime DESC" },
+            "ORDER BY title,programid",
+        "", "programid" }, // "", "starttime DESC" },

      {   "By Title",
          "title",
@@ -58,7 +58,7 @@
              "%1 "
              "GROUP BY title "
              "ORDER BY title",
-        "WHERE title=:KEY", "title" },
+        "WHERE title=:KEY", "programid" },

      {   "By Genre",
          "category",
--------------

Thanks for providing a great product - I've been using it for years.

Cheers,
-Bob Arendt