| View previous topic :: View next topic |
| Author |
Message |
Mnc
Posts: 20
|
 Posted: Sat May 14, 2011 2:26 pm Post subject: Episodes list, next new episode |
 |
|
Hi there,
Must a show's next episode come within a certain timeframe for it to appear on the Private Show List?
I'm thinking specifically about Futurama. They are having a break in season 6 at the moment, but MyEps does(!) have information on the next episode, it just doesn't show up in the Episodes List yet. I can only see it in the per-show-list.
The next episode is due June 23rd, so it's almost 6 weeks away.
I'm just wondering if the next episode needs to come within the next, say, month(?) to show up.
I hope my question made sense. 
Mnc |
|
| Back to top |
|
|
dutchi
Posts: 119
Location: The Kingdom of the Netherlands
|
| Posted: Mon May 16, 2011 12:18 pm Post subject: |
|
|
Go to http://www.myepisodes.com/cp.php
Then select: Days forward should be shown in my list:
Make sure you select a value of 5000 or less (higher values may cause errors, and the effect of that would be an empty episode list).
^^^^click to enlarge^^^^
p.s. Works fine for me:
17-May-2011 02:00 90210 03x22 To the Future!
17-May-2011 02:00 How I Met Your Mother 06x24 Challenge Accepted
17-May-2011 03:00 Gossip Girl 04x22 The Wrong Goodbye
17-May-2011 03:00 Make It or Break It 02x18 Dog Eat Dog
17-May-2011 03:00 The Event 01x21 The Beginning of the End
17-May-2011 04:00 Hawaii Five-0 (2010) 01x24 Oia'i'o (Trust)
17-May-2011 04:00 The Hard Times of RJ Berger 02x09 Hunkeez
18-May-2011 02:00 Glee 02x21 Funeral
18-May-2011 02:00 One Tree Hill 08x22 This Is My House, This Is My Home
18-May-2011 03:00 Hellcats 01x22 I'm Sick Y'all
18-May-2011 03:00 Raising Hope 01x22 Don�t Vote for this Episode
18-May-2011 04:00 Body Of Proof 01x09 Broken Home
19-May-2011 04:00 Happy Endings 01x10 Bo Fight
19-May-2011 04:00 Happy Endings 01x11 Barefoot Pedaler
19-May-2011 20:30 Echte meisjes in de jungle 01x09 Season 1, Episode 9
20-May-2011 03:00 Grey's Anatomy 07x22 Unaccompanied Minor
21-May-2011 04:00 Camelot 01x08 Igraine
23-May-2011 02:00 The Simpsons 22x22 The Ned-Liest Catch
23-May-2011 02:30 Bob's Burgers 01x13 Torpedo
23-May-2011 03:00 Army Wives 05x11 Drop Zone
23-May-2011 03:00 Game of Thrones 01x06 A Golden Crown
23-May-2011 04:00 The Borgias 01x09 Nessuno (Nobody)
23-May-2011 04:00 The Killing 01x09 Undertow
23-May-2011 04:00 Treme 02x05 Slip Away
24-May-2011 03:00 Make It or Break It 02x19 TBA
24-May-2011 03:00 The Event 01x22 Arrival
24-May-2011 04:00 The Hard Times of RJ Berger 02x10 Sex. Teen. Candles.
25-May-2011 02:00 Glee 02x22 New York
26-May-2011 04:00 Happy Endings 01x12 The Shershow Redemption
30-May-2011 03:00 Game of Thrones 01x07 You Win or You Die
30-May-2011 04:00 The Killing 01x10 I'll Let You When I Get There
30-May-2011 04:00 Treme 02x06 Feels Like Rain
31-May-2011 03:00 Make It or Break It 02x20 TBA
02-Jun-2011 04:00 Men of a Certain Age 02x07 Season 2, Episode 7
03-Jun-2011 04:00 Love Bites 01x01 Pilot
04-Jun-2011 04:00 Camelot 01x09 The Battle of Bardon Pass
06-Jun-2011 03:00 Game of Thrones 01x08 The Pointy End
06-Jun-2011 04:00 The Killing 01x11 Missing
06-Jun-2011 04:00 The Real L Word 02x01 Season 2 Premiere
09-Jun-2011 04:00 Men of a Certain Age 02x08 TBA
11-Jun-2011 04:00 Camelot 01x10 Reckoning
13-Jun-2011 03:00 Game of Thrones 01x09 Baelor
13-Jun-2011 04:00 The Killing 01x12 Season 1, Episode 12
13-Jun-2011 04:00 The Real L Word 02x02 Season 2, Episode 2
15-Jun-2011 02:00 Pretty Little Liars 02x01 It's Alive
16-Jun-2011 04:00 Men of a Certain Age 02x09 TBA
17-Jun-2011 04:00 Rookie Blue 02x01 Season 2, Episode 1
20-Jun-2011 03:00 Game of Thrones 01x10 Fire and Blood
20-Jun-2011 04:00 The Killing 01x13 Season 1, Episode 13
23-Jun-2011 04:00 Men of a Certain Age 02x10 TBA
24-Jun-2011 04:30 Louie 02x01 Season 2, Episode 1
27-Jun-2011 03:00 True Blood 04x01 She's Not There
28-Jun-2011 04:00 Weeds 07x01 Season 7, Episode 1
28-Jun-2011 04:30 The Big C 02x01 Season 2, Episode 1
30-Jun-2011 04:00 Men of a Certain Age 02x11 TBA
04-Jul-2011 03:00 True Blood 04x02 You Smell Like Dinner
07-Jul-2011 04:00 Men of a Certain Age 02x12 TBA
11-Jul-2011 03:00 True Blood 04x03 Season 4, Episode 3
13-Jul-2011 04:00 Rescue Me 07x01 Season 7, Episode 1
18-Jul-2011 03:00 True Blood 04x04 Season 4, Episode 4
20-Jul-2011 04:00 Rescue Me 07x02 Season 7, Episode 2
25-Jul-2011 03:00 True Blood 04x05 Season 4, Episode 5
25-Jul-2011 04:30 Entourage 08x01 Season 8, Episode 1
27-Jul-2011 04:00 Rescue Me 07x03 Season 7, Episode 3
01-Aug-2011 03:00 True Blood 04x06 Season 4, Episode 6
03-Aug-2011 04:00 Rescue Me 07x04 Season 7, Episode 4
08-Aug-2011 03:00 True Blood 04x07 Season 4, Episode 7
10-Aug-2011 04:00 Rescue Me 07x05 Season 7, Episode 5
15-Aug-2011 03:00 True Blood 04x08 Season 4, Episode 8
17-Aug-2011 04:00 Rescue Me 07x06 Season 7, Episode 6
22-Aug-2011 03:00 True Blood 04x09 Season 4, Episode 9
24-Aug-2011 04:00 Rescue Me 07x07 Season 7, Episode 7
29-Aug-2011 03:00 True Blood 04x10 Season 4, Episode 10
31-Aug-2011 04:00 Rescue Me 07x08 Season 7, Episode 8
01-Sep-2011 18:00 Terra Nova 01x01 Pilot Part One
05-Sep-2011 03:00 True Blood 04x11 Season 4, Episode 11
07-Sep-2011 04:00 Rescue Me 07x09 Season 7, Episode 9
12-Sep-2011 03:00 True Blood 04x12 Season 4, Episode 12
26-Sep-2011 03:00 Dexter 06x01 Season 6, Episode 1
01-Nov-2011 03:00 The Walking Dead 02x01 Season 2, Episode 1 |
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Mon May 16, 2011 10:22 pm Post subject: |
|
|
| dutchi wrote: | Go to http://www.myepisodes.com/cp.php
Then select: Days forward should be shown in my list:
Make sure you select a value of 5000 or less (higher values may cause errors, and the effect of that would be an empty episode list). |
Ah yes. I've played around with it for a minute or two now.
I - for whatever reason - didn't notice this until now. I usually play about with profile settings of this sort before asking silly questions, but, this one I missed.
In any case.
The golden number, I've found, is 9744.
9744 is 26,6958 (when divided by a flat 365) years. The only number I can 'get close to', is 1392 weeks.
As far as "dates back" goes, anything above 32767 will default to the aforementioned number.
Note, a higher number in 'dates forward' will NOT revert to any 'acceptable number', but result in the empty episode list, that Dutchi was talking about.
So, the two input fields will 'want' 9744/32767, or
00001000010001
111111111111111
- for whatever reason.
Cheers for the pointer, though. Thanks a lot, really.
My episode list is a lot nicer now - I can start looking forward to new episodes/seasons a lot sooner! |
|
| Back to top |
|
|
dutchi
Posts: 119
Location: The Kingdom of the Netherlands
|
| Posted: Mon May 16, 2011 10:33 pm Post subject: |
|
|
Yea uhm...... ok 
And everyone else can just set the "Days forward should be shown in my list:" value to 5000 or lower.
The value will decrease everyday by 1 day, so at 5000 or lower you will be fine for a couple years. |
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Tue May 17, 2011 12:07 am Post subject: |
|
|
| dutchi wrote: | | Yea uhm...... ok |
Well the "date backwards" is simple binary (15 full bits). (link if your a geek and really wants to know)
For example, if you've ever noticed the numbers "16 bit", "32 bit" (etc) for color depth on your monitor, all it means is that you get:
8 bit:
256 colors
16 bit:
65536 colors
24 bit:
16777216 colors
But the only reason I can think of, for choosing "9744" as your max days forward, is possibly that the numbers for "9745" lies somewhat nicely for typing:
2-1
34-
- - -
(Typing sequence on the numpad...)
And the reason for the website to then accept 9744 instead of 9745 is simply "if release date is less than, Date Entered As Max Future Date then show content".
I hope that made at least some sense.
| dutchi wrote: | | And everyone else can just set the "Days forward should be shown in my list:" value to 5000 or lower. |
I will keep my eye on this. If 9744 gets me in trouble (stops showing my Episodes List), I shall let you know! |
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Tue May 17, 2011 6:40 am Post subject: |
|
|
| dutchi wrote: | | The value will decrease everyday by 1 day, |
I have no idea why he/she/they would make the system decrease the accepted "Date Forward" by 1 every day, but it does indeed seem like it does. Odd.
I lost my episodes list this morning, but when I entered 9743 instead, it worked again.
| dutchi wrote: | | so at 5000 or lower you will be fine for a couple years. |
I think I'll just take 5000. 
I guess 13,7 years into the future is "fair warning", for new episodes.
And as you say, it gives almost 13 years of foresight, assuming they don't bump the accepted value. |
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
| Posted: Tue May 17, 2011 12:26 pm Post subject: |
|
|
I suggest 1000 as a maximum value, 3 years is more than enough.
_________________
Filter Settings
| Code: | Unacquired Unwatched Result
off off Shows all
off on Shows unwatched
on off Shows unacquired
on on Shows unacquired and unwatched
|
|
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
| Posted: Wed May 18, 2011 12:29 am Post subject: |
|
|
| Mnc wrote: | | I have no idea why he/she/they would make the system decrease the accepted "Date Forward" by 1 every day, but it does indeed seem like it does. |
I think you will find that the maximum forward value equates to a fixed date, most likely due to the way the database handles date ranges.
_________________
Filter Settings
| Code: | Unacquired Unwatched Result
off off Shows all
off on Shows unwatched
on off Shows unacquired
on on Shows unacquired and unwatched
|
|
|
| Back to top |
|
|
dutchi
Posts: 119
Location: The Kingdom of the Netherlands
|
| Posted: Wed May 18, 2011 1:05 am Post subject: |
|
|
Or somebody is manual decreasing the value everyday by 1 just because he can
p.s. go to bed , it's 2am |
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Wed May 18, 2011 6:18 pm Post subject: |
|
|
| facedancer wrote: | | Mnc wrote: | | I have no idea why he/she/they would make the system decrease the accepted "Date Forward" by 1 every day, but it does indeed seem like it does. |
I think you will find that the maximum forward value equates to a fixed date, most likely due to the way the database handles date ranges. |
Hmm, a static date.
I didn't think of that, as it's not a very 'pretty' way to do it.
"if the entered number is greater than 5 years into the future, set the value to 5 years, otherwise proceed with the entered value."
It's a simple one-liner in the code.
But yeah, as you said earlier, 3 years should be plenty. In fact, I've set it to 400. It's a year and a month, even that should be more than enough.
My guess on the limit to 32767 'days backward', is that the database is probably using a smallint to store the entered amount of days. A small int can't hold numbers above 32767, and it will fail to save any bigger numbers.
Since it doesn't actually show any error messages, but automatically takes the maximum value, I guess the coder has added an error check for that.
if number is greater than max then set number to max.
I'm rambling again. |
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Wed May 18, 2011 7:40 pm Post subject: |
|
|
I don't really see what your point is, when all you give me is a link...
| facedancer wrote: | | http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html |
But sure, let's exchange links.
http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html... |
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
| Posted: Wed May 18, 2011 8:02 pm Post subject: |
|
|
I could not be arced to write a wall of text
But create a table with some test dates in it and try a select statement of the form:-
| Code: | | select * from table where airdate between (now()-backdays) and (now()+forwarddays) |
Let me know what limits you find
_________________
Filter Settings
| Code: | Unacquired Unwatched Result
off off Shows all
off on Shows unwatched
on off Shows unacquired
on on Shows unacquired and unwatched
|
|
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Wed May 18, 2011 8:07 pm Post subject: |
|
|
It's been too long since I've messed about with databases...
I'm still not entirely sure what you're getting at.
My guess is that you're trying to infer, that what I said a few posts back, can't be done?
I don't actually know off the top of my head, if your [ code ] would work or not, but what I meant further up was that it's easily doable in the backend code - before asking the DB. |
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
| Posted: Wed May 18, 2011 8:41 pm Post subject: |
|
|
What I was trying to get at is the date math overflow is happening in the db engine. It would be nice to see some documentation on how in-line calculations are handled, but I guess the only way to know is to study the mysql source.
I think the quickest fix would be to cap the forwards and back values.
Also that code snip is simplified, since we to the time zone conversion in sql.
_________________
Filter Settings
| Code: | Unacquired Unwatched Result
off off Shows all
off on Shows unwatched
on off Shows unacquired
on on Shows unacquired and unwatched
|
|
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Wed May 18, 2011 8:43 pm Post subject: |
|
|
Again, what I meant further up, is really that you could just have a
daysIntoTheFuture = (inputDaysForward > limit) ? limit : inputDaysForward;
before making any DB calls. Purely for the sake of removing the static date.
|
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
| Posted: Wed May 18, 2011 8:50 pm Post subject: |
|
|
We are not storing a static date. That is just how you interpreted what I said.
_________________
Filter Settings
| Code: | Unacquired Unwatched Result
off off Shows all
off on Shows unwatched
on off Shows unacquired
on on Shows unacquired and unwatched
|
|
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Wed May 18, 2011 8:54 pm Post subject: |
|
|
| Then where is the fixed date? In a database call? |
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
| Posted: Wed May 18, 2011 9:02 pm Post subject: |
|
|
From the in-line sql construct "now()+x days". If x is too big the math must be overflowing, and god knows what date value it becomes when it overflows.
So when it overflows the query is then asking for all dates between low date and what ever the overflow value is, that is why it comes back with an empty result set.
_________________
Filter Settings
| Code: | Unacquired Unwatched Result
off off Shows all
off on Shows unwatched
on off Shows unacquired
on on Shows unacquired and unwatched
|
|
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Wed May 18, 2011 9:08 pm Post subject: |
|
|
So it's nothing written, it's just the point where the inline calcs start failing? Odd that it decrements daily then.
What's even weirder is that it's not even a logical date where it cuts off, it's January 18th 2038.
Maybe you should indeed cap the input. |
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
| Posted: Wed May 18, 2011 9:16 pm Post subject: |
|
|
My wild guess would be, it is decimal days held in a float.
_________________
Filter Settings
| Code: | Unacquired Unwatched Result
off off Shows all
off on Shows unwatched
on off Shows unacquired
on on Shows unacquired and unwatched
|
|
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
| Posted: Wed May 18, 2011 9:20 pm Post subject: |
|
|
Or it is like a timestamp.
| Quote: | | TIMESTAMP: A four-byte integer representing seconds UTC since the epoch ('1970-01-01 00:00:00' UTC) |
_________________
Filter Settings
| Code: | Unacquired Unwatched Result
off off Shows all
off on Shows unwatched
on off Shows unacquired
on on Shows unacquired and unwatched
|
|
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Wed May 18, 2011 9:29 pm Post subject: |
|
|
| facedancer wrote: | Or it is like a timestamp.
| Quote: | | TIMESTAMP: A four-byte integer representing seconds UTC since the epoch ('1970-01-01 00:00:00' UTC) |
|
Aah, there's the pot of gold.
4 bytes. Same size as a signed integer.
Signed integer maximum size (as seconds) equals 24855(.134) days.
| Code: | | Console.WriteLine(new DateTime(1970,1,1,0,0,0,0).AddDays(24855).ToString()); |
gives me
| Code: | 19-01-2038 00:00:00
Press any key to continue . . . |
|
|
| Back to top |
|
|
Mnc
Posts: 20
|
| Posted: Wed May 18, 2011 9:32 pm Post subject: |
|
|
| Mnc wrote: | | 4 bytes. Same size as a signed integer. |
| facedancer wrote: | | TIMESTAMP: A four-byte integer |
Just shoot me now.
I just read "four-byte", and immediately saw a lightbulb go on, and launched Visual Studio. |
|
| Back to top |
|
|
facedancer
Moderator
Posts: 476
|
| Posted: Wed May 18, 2011 10:44 pm Post subject: |
|
|
I guess now you see where the fixed date is.
At some point in the next decade or two the reference epoch will need to change, or it will be the millennium all over again.
_________________
Filter Settings
| Code: | Unacquired Unwatched Result
off off Shows all
off on Shows unwatched
on off Shows unacquired
on on Shows unacquired and unwatched
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
