Opened 14 years ago

Closed 13 years ago

#1930 closed defect (fixed)

mythweb channel list for atsc doesn't sort subchannels

Reported by: p-mtv@… Owned by: xris
Priority: minor Milestone: unknown
Component: mythweb Version:
Severity: low Keywords:
Cc: Ticket locked: no

Description

In the schedule listings displayed by mythweb, if sorting is by channel number, subchannel numbers are not taken into account. This can lead to listings ordered as, e.g., (9-1, 9-5, 9-3, 9-2, etc.)

A small patch is attached for includes/channels.php to take subchannels into account when sorting by channel. I'm not an SQL whiz so it's probably clumsy, but it seems to yield the correct result. Maybe someone who knows SQL better can improve upon it.

The basic idea in the patch is to extract the subchannel number (separators _, -, . are handled) and sort on that after sorting on the primary channel number.

Attachments (1)

patch-mythweb-sort-subchannel (870 bytes) - added by p-mtv@… 14 years ago.
patch for mythweb includes/channels.php to sort on atsc subchannel numbers

Download all attachments as: .zip

Change History (2)

Changed 14 years ago by p-mtv@…

patch for mythweb includes/channels.php to sort on atsc subchannel numbers

comment:1 Changed 13 years ago by xris

Resolution: fixed
Status: newclosed

(In [11111]) db object cleanup, and apply a channel sort fix to close #1930

Note: See TracTickets for help on using tickets.