SickGear/SickGear — pull request #48 by Prinz23 (2014-11-22 17:36:06+00:00)
Title: Change SQL for Coming Episodes Page to include +/- 1 day, ...

for timezone corrections, since the db has dates/times without timezone correction we need to include for the current week the time from yesterday until 1 week + 1 day. Also we need to include tomorrow for the wanted episode search, since the db episode date could be tomorrow for a show in a different timezone, that is already the past in the users timezone. Same for the missed episode range, here we have to take an extra day in the past (to compensate timezone differences).

All this has to be done regardless of the users displaying setting (local or network), since this setting doesn't change the fact when the episode really airs.

I also fixed a bug that $cur_ep_endate variable on the Coming Episodes wasn't set for every episode resulting in all episodes in banner view had the same background color even if some already aired and some still air later that day.