How do I expire file download links based on date?

arkham · 2006-01-09 17:38:43

I assume I’ll be using PHP for this one. I want my file downloads to show as expired and no longer be active links after the article they’re associated with are a month old.

arkham · 2006-01-09 21:35:54

anyone? or even some instruction as to how to access the date posted of an article via php so i can do some comparing….

wet · 2006-01-10 08:06:40

Select id and posting time of articles posted after a certain date:

$mydate = [...];
$rs = safe_row ('id','textpattern', 'posted >' . doSlash($mydate) );

or

$mydate = [...];
$rs = safe_rows_start ('id, posted','textpattern', ' posted >' . doSlash($mydate) ;
if ($rs) {
 while ($r = nextRow($rs)) {
[...]

See lib/txp_db.php for other db related stuff.

hth,
Robert

Last edited by wet (2006-01-10 08:07:26)

nardo · 2006-01-10 08:58:09

would be interested in this one, arkham, for an mp3 blog … I assume you’re using upm_file_packets to associate files with an article?

arkham · 2006-01-11 05:42:40

Hey wet, thanks for the suggestions. Nardo, yes I’m using upm_file_packets

I found a plugin that for some reason I don’t think ever made it to the plugin forum which can handle this situation. You’ll probably find it useful for your mp3’s. I just got it working perfectly for my needs.

http://forum.textpattern.com/viewtopic.php?id=12087

In that thread is a textfile for the plugin ras_if_expired. It takes a parameter for number of days.

You can put this in an article form but since I wanted to show the names of the expired MP3’s i put it right in my files form and this worked perfectly:

<code>
<txp:ras_if_expired offset=“30”>
<txp:file_download_description /> (Link Expired)
<br />
<txp:else />
<a href=“http://www.ohword.com.nyud.net:8090/files/<txp:file_download_name />”><txp:file_download_description /></a> [<txp:file_download_size format=“auto” decimals=“2” />]
<br />
</txp:ras_if_expired>
</code>

Last edited by arkham (2006-01-11 05:43:19)

nardo · 2006-01-11 06:04:33

good one

Textpattern CMS

Textpattern CMS support forum

#1 2006-01-09 17:38:43

How do I expire file download links based on date?

#2 2006-01-09 21:35:54

Re: How do I expire file download links based on date?

#3 2006-01-10 08:06:40

Re: How do I expire file download links based on date?

#4 2006-01-10 08:58:09

Re: How do I expire file download links based on date?

#5 2006-01-11 05:42:40

Re: How do I expire file download links based on date?

#6 2006-01-11 06:04:33

Re: How do I expire file download links based on date?

Board footer