Thanks for the compliments OMGZilla - it's very much appreciated
Thanks for the suggestion as well. I did look at the data that I get from TheTVDB, here an example with episode info:
{
"id": 85751,
"airedSeason": 1,
"airedSeasonID": 4147,
"airedEpisodeNumber": 2,
"episodeName": "Children of the Gods (2)",
"firstAired": "1997-07-27",
"guestStars": [
"Brent Stait",
"Robert Wisden",
"Jay Acov"
],
"director": "|Mario Azzopardi|",
"directors": [
"Mario Azzopardi"
],
"writers": [
"Jonathan Glassner",
"Brad Wright"
],
"overview": "Colonel O'Neill, leading the new SG-1, track Apophis back to the planet Chulak to rescue Sha're and Skaara, and befriend one of Apophis' Jaffa guards.",
"language": {
"episodeName": "en",
"overview": "en"
},
"productionCode": "",
"showUrl": "",
"lastUpdated": 1310860983,
"dvdDiscid": "",
"dvdSeason": 1,
"dvdEpisodeNumber": 1.2,
"dvdChapter": null,
"absoluteNumber": null,
"filename": "episodes/72449/85751.jpg",
"seriesId": 72449,
"lastUpdatedBy": 20141,
"airsAfterSeason": null,
"airsBeforeSeason": null,
"airsBeforeEpisode": null,
"thumbAuthor": 959,
"thumbAdded": "",
"thumbWidth": "300",
"thumbHeight": "167",
"imdbId": "",
"siteRating": 7.6,
"siteRatingCount": 38
}
As you can see there is a field for an absolute number, but ... most shows have that field value as "null".
A null value is a problem - I would not know how to sort that if each episode has the absolute number "null".
In the future I could try adding that though and show a checkbox for absolute sorting if the show does have values here. It would take remodeling of the database and a bunch of procedures though. They all rely on either aired or dvd order.
I'll add it to my "ToDo" list for when I have time to make significant changes like that.