create .ram files from database

[edspace]

I run a website with about 650 real player songs. I have a database for them and everything. If u dont know how real player works it has two files.

file.ram ---which is just a notepad file with the link to file.rm

file.rm--- the actual song.

right now when i play a song i call the .ram file which then calls the .rm file. The thing is that real player shows the location of the .ram file. People can then open the file and look at the .rm link.

What i want to do is generate the .ram file automatically from the database and then delete it about five minutes later or so.

The second option is to just move the .ram file from a secret folder to a temporary folder. After five minutes or so i can delete the file.

Since i dont have much experience with php i want to know what is the easiest way to do this, is it fast, and will it slow down the server?

Any other suggestions are welcomed.

Thanks for the help.

[Anon]

how about making a page called:

redirect.php?lid=###

that actually query's the db and prints out content type and also the url of the rm.

do this:

<?php
// redirect.php?lid=####

require_once "db.class.php";

$db = new DB("login","pass","dbname");
$db->query("SELECT url,clickthru FROM rm_links WHERE lid = '$lid'");
if( $db->fetchRow() )
{
    $clickthru = intval($db->record["clickthru"]) + 1;
    $url = $db->record["url"];
    $db->query("UPDATE rm_links SET clickthru='$clickthru' WHERE lid = '$lid'");
    Header("Location: $url");
}

$db->disconnect();
?>

now what that file does is that it opens the db and looks for the link id (lid), and selects the url and clickthru (for keeping track of number of times a link has been hit), anyways it increments that value and redirects. But according to what you said, it might be beneficial to actually make that:

//change the line:
    Header("Location: $url");
//to the following two lines
    Header("Content-type: audio/x-pn-realaudio");
    print $url;

also, you can put in code that checks to see where the referer is coming from and block them out or take them back to the main page or whatever.

and thats it. you're done.

oh by the way, the db.class.php file is just a db wrapper class the i downloaded from the PHP classes repository, http://phpclasses.upperdesign.com/browse.html go into Databases > DB > download

but you do not need it to do anything, you can just use mysql_connect(), mysql_fetchrow(), mysql_query(), ... instead.

I hope that helped you.