Opened 14 years ago
Closed 14 years ago
#8786 closed enhancement (fixed)
Mythweb video sorting
Reported by: | Owned by: | Rob Smith | |
---|---|---|---|
Priority: | trivial | Milestone: | 0.24 |
Component: | Plugin - MythWeb | Version: | Master Head |
Severity: | low | Keywords: | mythweb sort episode |
Cc: | Ticket locked: | no |
Description
I don't get why you have the database sort, then call a php function to sort it, seems like a duplicate of effort. It also causes tv episodes to be really out of order. I am not sure how you want to handle this officially, but just commenting out the php sort function, and adding season and episode below to mysql sort causes it to be fixed and works nice for me.
Changed: ORDER BY title
to: ORDER BY title,season,episode
$sh = $db->query('
SELECT videometadata.intid FROM videometadata LEFT JOIN videometadatagenre
ON videometadata.intid = videometadatagenre.idvideo
' . $where . ' GROUP BY intid ORDER BY title,season,episode');
while ($intid = $sh->fetch_col()) {
$All_Videos[] = new Video($intid);
} $sh->finish();
if (count($All_Videos)) sort_programs($All_Videos, 'video_sortby');
Oh sorry, this is in the end of mythweb/modules/video/handler.php