- December 6, 2004
- 2,055
- 318
- Thread starter
- #31
hi clodo,
depends on what you mean by "retrieving this kind of information". obviosly you can just get the current time and date with .net datetime.now methods.
as for upcoming recordings, its all saved in the TVDatabaseV21.db3. take a look at the database methods in the source. should be very easy to find out the next recordings. as im sure you know, you can just pass in an sql query and get back a result set. so just order the recordings by startime (which also includes the date (format is like this: 20051025175900) and then limit the results to be greater than the current date time.
actually, the sql should look something like this:
yeah, that works
so that gives you back a resultset with the next recording.
would be glad to see this improve
depends on what you mean by "retrieving this kind of information". obviosly you can just get the current time and date with .net datetime.now methods.
as for upcoming recordings, its all saved in the TVDatabaseV21.db3. take a look at the database methods in the source. should be very easy to find out the next recordings. as im sure you know, you can just pass in an sql query and get back a result set. so just order the recordings by startime (which also includes the date (format is like this: 20051025175900) and then limit the results to be greater than the current date time.
actually, the sql should look something like this:
Code:
select recording.strProgram, recording.iStartTime, channel.strChannel
from recording, channel
where recording.iStartTime > "right now" // have to create that string
and channel.idChannel = recording.idChannel
order by recording.iStartTime
limit 1;
yeah, that works
so that gives you back a resultset with the next recording.
would be glad to see this improve