_________________
Park Magic Radio
http://parkmagicradio.ca

Since you are displaying the currently playing song info, date_played is updated in the songlist table immediately upon playing, you will have to search the historylist (the song ID) table to get the last time it played before the current playing (offset the results by 1 to eliminate the current playing date).

_________________
- Rob Oyler, SVS

Hi DJ Cassio, I can get it to pull the date from the historylist's date_played table, but when I offset it with -1 as you suggest, it takes an entire year off the last played date. Here is my PHP:

Last Played: <?php echo $currentSong->date_played -date()-1; ?>

If it was played today on March 2, 2020, it would say "2019".

Any ideas?

_________________
Park Magic Radio
http://parkmagicradio.ca

Take a step back and reread the post by DJ Cassio.
There's no mentioning of offsetting the date_played field.

You take the songID from the current song, query the historylist for that song and pick the second to last entry (when ordered by date descending).

There is no field in the songlist table (or the latest historylist entry for that matter) telling you the second to last time a track has played.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode

_________________
- Rob Oyler, SVS

_________________
Park Magic Radio
http://parkmagicradio.ca

_________________
- Rob Oyler, SVS

_________________
Park Magic Radio
http://parkmagicradio.ca

I have read the whole post and I still do not understand where exactly you want to have placed the last date played info. I took a look into your website: Do you want to add last played info into "Recently Played" section ? or somewhere ?
Find attached a screenshot with my current played info and history - as example. I didn't use SAM page templates, the page is my own creation - but all the information displayed is used and generated with SAM tools available. My page is created as html and not php. But I think there is no difference in SAM html / php output reference. I may be corrected if I'm wrong.

Hello rolandwelker, thanks for your reply. Yes, you are exactly right, I wish to display the last date and time a song played in my "Currently Playing" section adjacent to the album art, alongside all the other info displayed. How did you accomplish this?

_________________
Park Magic Radio
http://parkmagicradio.ca

Hi dan40, as I wrote before - I am using html output tools from SAM (Not using SAM php templates). All those info in my screenshot, last played, Info generated etc. have been generated from SAM by using the tag types and variables in SAM "Help" section, => html output section, => html output, =>Overview. As I am not familiar the way you create your output it may differ from php page generation. Initially I was in the same situation as you roughly 12 years ago, it was a mess to modify SAMs existing web templates, so I decided to create my web pages of my own using all that stuff from html output section which was much easier to create and to control. Find attached screenshots for more info. Find below objects inserted to create my history file as displayed in my pevious post:
<!--history.songtype="S"--> [Only displaying Song info - no jingles or whatever]
<!--LOOP(history,1,5)--> [Number of songs displayed]
<!--LOOP_ROW--> [Followed by Loop end]
$history.buycd$
$history.no$
$history.picture$
$history.artist$
$history.title$
$history.album$
$history.albumyear$
$history.date_played$

But as I wrote: I am not sure if these commands work within the php templates supplied with SAM. I am using those commands inside my own php or html templates created from SAM and uploaded to my my webspace.

_________________
Park Magic Radio
http://parkmagicradio.ca

_________________
Park Magic Radio
http://parkmagicradio.ca

Yeah, I think the magic ist the word "history": => history.date_played <=, as everything regarding history like "history.artist" etc. (View my listing in my post above). You can find additional info at the buttom of the help section from SAM how to use.