What's wrong with using the historylist? Here's some SQL to return "around midnite" (+/- 30 minutes) select artist, album, title, date_played from historylist where date_played > '2008-12-21 23:30' and date_played < '2008-12-22 00:30'
Here is a sample comma separated result: 'Widespread Panic', '?ber Cobra', 'Expiration Day', '2008-12-21 23:30:37' 'Led Zeppelin', 'How the West Was Won', 'Immigrant Song', '2008-12-21 23:36:01' 'Eleven', 'Avantgardedog', 'Untitled #1', '2008-12-21 23:39:41' 'Rufus Wainwright', 'Poses', 'Rebel Prince', '2008-12-21 23:40:44' 'Queen', 'Jazz', 'Bicycle Race [1991 Bonus Remix by Junior Vasquez]', '2008-12-21 23:44:27' 'Rush', 'Gold', 'Xanadu', '2008-12-21 23:49:33' 'The Moody Blues', 'Time Traveller', 'Saved by the Music', '2008-12-22 00:00:26' 'Van Halen', 'OU812', 'Finish What Ya Started', '2008-12-22 00:06:33' 'Tom Petty and the Heartbreakers', 'Playback', 'Jammin' Me', '2008-12-22 00:10:56' 'Guns N' Roses', 'Live Era: '87-'93', 'Dust N' Bones', '2008-12-22 00:15:02' 'The Who', 'Live at the Isle of Wight Festival 1970', 'Fiddle About', '2008-12-22 00:20:06' 'Queen', 'A Night at the Opera', 'Love of My Life', '2008-12-22 00:21:20' 'Phish', 'Farmhouse', 'The Inlaw Josie Wales', '2008-12-22 00:24:57' 'Rolling Stones', 'Forty Licks', 'Beast of Burden', '2008-12-22 00:27:51' Steve Kunitzer http://www.festerhead.com Michael Hughes wrote: > Ok, then I can not do what I wanted to do. Thank you. I am having > issues with getting requests through the IP Phone router and the > network routers. So I simply wanted to publish a list of tracks > played. Many listeners will say "It was around midnite" and it would > have been nice to supply them with a playlist. > > Thanks Steve. > > > ----- Original Message ----- From: "Steve Kunitzer" > <[email protected]> > To: <[email protected]> > Sent: Monday, December 22, 2008 12:04 PM > Subject: Re: [General-discussion] Code > > >> The time a track has played is in the historylist table. >> >> If by "transfer to a file the time a track was played" means to >> update the source metadata then no, SAM does not do this. >> >> >> Steve Kunitzer >> http://www.festerhead.com >> >> >> >> Michael Hughes wrote: >>> Is there a code for SAm to transfer to a file the time a track was >>> played? I see that SAM already will list a history, but I would like >>> to add the time the track was played. >>> >>> >>> Michael Hughes >>> Christian Mix Inet >>> www.christianmixinet.net >>> 785-209-3249 >>> > From [email protected] Mon Dec 22 14:13:12 2008 From: [email protected] (Michael Hughes) Date: Mon Dec 22 15:35:25 2008 Subject: [General-discussion] Code In-Reply-To: <[email protected]> References: <1d9697edffe14730bea374dc13de9...@voice23pc><[email protected]><5a9325d247f849a3b78db6688ddc3...@voice23pc> <[email protected]> Message-ID: <de15329cabbf4bb1825f2ca5b1863...@voice23pc> Thank you Steve. First, I am not a programmer, let alone SQL. Next, I just thought it would be easy to print the time played on the list that SAM generates. I would not have to do anything. The listener could see what had played during that time. ----- Original Message ----- From: "Steve Kunitzer" <[email protected]> To: <[email protected]> Sent: Monday, December 22, 2008 12:30 PM Subject: Re: [General-discussion] Code What's wrong with using the historylist? Here's some SQL to return "around midnite" (+/- 30 minutes) select artist, album, title, date_played from historylist where date_played > '2008-12-21 23:30' and date_played < '2008-12-22 00:30' Here is a sample comma separated result: 'Widespread Panic', '?ber Cobra', 'Expiration Day', '2008-12-21 23:30:37' 'Led Zeppelin', 'How the West Was Won', 'Immigrant Song', '2008-12-21 23:36:01' 'Eleven', 'Avantgardedog', 'Untitled #1', '2008-12-21 23:39:41' 'Rufus Wainwright', 'Poses', 'Rebel Prince', '2008-12-21 23:40:44' 'Queen', 'Jazz', 'Bicycle Race [1991 Bonus Remix by Junior Vasquez]', '2008-12-21 23:44:27' 'Rush', 'Gold', 'Xanadu', '2008-12-21 23:49:33' 'The Moody Blues', 'Time Traveller', 'Saved by the Music', '2008-12-22 00:00:26' 'Van Halen', 'OU812', 'Finish What Ya Started', '2008-12-22 00:06:33' 'Tom Petty and the Heartbreakers', 'Playback', 'Jammin' Me', '2008-12-22 00:10:56' 'Guns N' Roses', 'Live Era: '87-'93', 'Dust N' Bones', '2008-12-22 00:15:02' 'The Who', 'Live at the Isle of Wight Festival 1970', 'Fiddle About', '2008-12-22 00:20:06' 'Queen', 'A Night at the Opera', 'Love of My Life', '2008-12-22 00:21:20' 'Phish', 'Farmhouse', 'The Inlaw Josie Wales', '2008-12-22 00:24:57' 'Rolling Stones', 'Forty Licks', 'Beast of Burden', '2008-12-22 00:27:51' Steve Kunitzer http://www.festerhead.com Michael Hughes wrote: > Ok, then I can not do what I wanted to do. Thank you. I am having issues > with getting requests through the IP Phone router and the network routers. > So I simply wanted to publish a list of tracks played. Many listeners will > say "It was around midnite" and it would have been nice to supply them > with a playlist. > > Thanks Steve. > > > ----- Original Message ----- From: "Steve Kunitzer" > <[email protected]> > To: <[email protected]> > Sent: Monday, December 22, 2008 12:04 PM > Subject: Re: [General-discussion] Code > > >> The time a track has played is in the historylist table. >> >> If by "transfer to a file the time a track was played" means to update >> the source metadata then no, SAM does not do this. >> >> >> Steve Kunitzer >> http://www.festerhead.com >> >> >> >> Michael Hughes wrote: >>> Is there a code for SAm to transfer to a file the time a track was >>> played? I see that SAM already will list a history, but I would like to >>> add the time the track was played. >>> >>> >>> Michael Hughes >>> Christian Mix Inet >>> www.christianmixinet.net >>> 785-209-3249 >>> > _______________________________________________ General-discussion mailing list [email protected] http://mailman.spacialaudio.com/mailman/listinfo/general-discussion TO unsubscribe to this list, simply send a blank email to [email protected] with the subject 'unsubscribe'
