[ Solved ] Convert timestamp to total seconds?

kevinpotts · 2022-05-30 19:21:34

Hi fam. Building a new project in TXP and it requires a podcast RSS feed. One of my last missing links is the time length of the MP3 file which is represented in total seconds. While I could use a custom field and dump a dumb integer in there, I like the idea of proper content storage better. It occurred to me that I could use the article’s publishing timestamp to capture the minutes:seconds of the episode, but I cannot figure out how to use the format attribute of <txp:posted /> to convert the minutes and seconds of the timestamp into a total number of seconds. (For example, 1:00:00 would convert to 3600.) Any ideas?

Last edited by kevinpotts (2022-05-31 23:36:45)

etc · 2022-05-30 19:48:27

Hi Kevin, here is a weird solution (but you know your idea is weird as well):

<txp:evaluate query='3600*<txp:posted format="%H" /> + 60*<txp:posted format="%M" /> + <txp:posted format="%S" />' />

Or even easier:

<txp:evaluate query='<txp:posted format="3600*%H + 60*%M + %S" />' />

Last edited by etc (2022-05-30 20:35:03)

kevinpotts · 2022-05-30 20:05:40

Intriguing. I am a stranger to the evaluate tag. I’ll try this. Thanks for the zippy response.

kevinpotts · 2022-05-31 23:36:15

<txp:evaluate query='<txp:posted format="3600*%H + 60*%M + %S" />' />

This worked perfectly. Thank you very much. It’s been a solid 7-8 years since I’ve built anything in Textpattern. Feels good to return home, even if someone’s moved the furniture around a bit.

Bloke · 2022-06-01 06:00:59

Great to see you, Mr Potts. Welcome back.

The tag suite is so much more powerful now that you can get away with way fewer plugins than in previous years. Anything you want to know, give us a shout here and we’ll show you the new carpet and sofa.

etc · 2022-06-01 08:16:18

kevinpotts wrote #333483:

This worked perfectly. Thank you very much. It’s been a solid 7-8 years since I’ve built anything in Textpattern. Feels good to return home, even if someone’s moved the furniture around a bit.

Nice to hear it works. We are strongly committed to preserve the foundations, so I hope you will quickly feel home again.

kevinpotts · 2022-06-01 12:11:57

Thanks both. I built the entire site without a single plugin in a week. I may have squeed in joy when I discovered <txp:header />. Exactly the sort of thing that eases the road of doing the hard work of rolling a custom RSS feed.

gaekwad · 2022-06-01 13:51:43

kevinpotts wrote #333496:

I may have squeed in joy when I discovered <txp:header />.

You and me both, sir.

Textpattern CMS

Textpattern CMS support forum

#1 2022-05-30 19:21:34