commit d1ab840c8d44ca5f0faa8c93854f48c027a86c05
Author: Joel Smith <jsf-lists.gtk...@jk1.net>
Date: Wed Apr 14 21:36:42 2010 -0600
Fix for video_info table to sort by TV Show title
Fixes for 959928ee72bb1073982f72574e8bbe2fd3f1389f.
If sort_tvshow isn't present, use the TV Show Title for sorting instead.
Additionally, create an episode sort value by combining the season
number and the episode number.
src/itdb_sqlite.c | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/src/itdb_sqlite.c b/src/itdb_sqlite.c
index 69d8550..5ca4858 100644
--- a/src/itdb_sqlite.c
+++ b/src/itdb_sqlite.c
@@ -1296,11 +1296,11 @@ static int mk_Library(Itdb_iTunesDB *itdb,
/* series_name TEXT */
sqlite3_bind_text(stmt_video_info, ++idx, track->tvshow, -1,
SQLITE_STATIC);
/* sort_series_name TEXT */
- sqlite3_bind_text(stmt_video_info, ++idx, track->sort_tvshow, -1,
SQLITE_STATIC);
+ bind_first_text(stmt_item, ++idx, 2, track->sort_tvshow,
track->tvshow);
/* episode_id TEXT */
sqlite3_bind_text(stmt_video_info, ++idx, track->tvepisode, -1,
SQLITE_STATIC);
/* episode_sort_id INTEGER */
- sqlite3_bind_int(stmt_video_info, ++idx, track->episode_nr);
+ sqlite3_bind_int(stmt_video_info, ++idx, track->season_nr << 16 |
track->episode_nr);
/* network_name TEXT */
sqlite3_bind_text(stmt_video_info, ++idx, track->tvnetwork, -1,
SQLITE_STATIC);
/* extended_content_rating TEXT */
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
gtkpod-cvs2 mailing list
gtkpod-cvs2@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gtkpod-cvs2
