Reply to thread

Message

<blockquote data-quote="Inker" data-source="post: 23672" data-attributes="member: 10541">hi clodo,depends on what you mean by &quot;retrieving this kind of information&quot;. 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, channelwhere recording.iStartTime &gt; &quot;right now&quot; // have to create that stringand channel.idChannel = recording.idChannelorder by recording.iStartTimelimit 1;[/code]yeah, that works <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />so that gives you back a resultset with the next recording.would be glad to see this improve <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></blockquote>

[QUOTE="Inker, post: 23672, member: 10541"] 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: [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;[/code] yeah, that works :-) so that gives you back a resultset with the next recording. would be glad to see this improve :-) [/QUOTE]

Verification