Hello, Steve: I haven't seen you writing responses for far too long a time. I'm delighted to see you back onboard. We need your experience.
Quick question, if you don't mind. I have SamPHP wehpages working on my local server (which uses MySQL). But, I've also got a remote server using MS SQL ... and I would like to have similar SamPHP page showing the remote server's playlist. What changes would I need to make in the code, as well as, on the SAM4 being used on the remote server? I know that the Help pages recommend using a local server, but is there a way to create the webpages? If you have the time to look at my current webpage: http;//www.acappellaradio.net Thanks! Merry Christmas & Happy New Year Loran Partigianoni ----- 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' >
