"); mysql_select_db($database) or die(errorMessage() . "Error selecting database.

"); $query = "SELECT filename,url,size,pubDate FROM ".$prefix."namemap ORDER BY pubDate DESC"; $results = mysql_query($query) or die(errorMessage() . "Can't do SQL query - " . mysql_error() . "

"); //if there are no entries in database or RSS feed is disabled in config.php file, delete rss.xml file if (mysql_num_rows($results) == 0 || $enablerss == false) { if (file_exists("rss/rss.xml")) //make sure file exists before trying to delete unlink("rss/rss.xml") or die ("Can't delete rss.xml file using unlink(). Are you running the server under Windows?"); } else //otherwise, generate new rss.xml file { $fd = fopen("rss/rss.xml", "w") or die(errorMessage() . "Error: Unable to write to rss.xml file!

"); $start_text = "\n" . "\n" . "\n" . "\n" . "" . $rss_link . "\n" . "" . clean($rss_description) . "\n" . "" . date('D, j M Y h:i:s') . " " . $timezone . "\n"; $middle_text = ""; while ($row = mysql_fetch_row($results)) { //figure out full torrent URL $url = $website_url . $_SERVER['REQUEST_URI']; $url = str_replace("newtorrents.php", "", $url); $url = str_replace("editconfig.php", "", $url); $url = str_replace("deleter.php", "", $url); $url = $url . "torrents/" . $row[0] . ".torrent"; $url = str_replace(" ", "%20", $url); //figure out file(s) size $file_size = bytesToString($row[2]); //go through each entry in database $middle_text = $middle_text . "\n" . "\n" . "" . $row[0] . " (" . $file_size . ") " . $row[1] . "\n" . "" . $row[3] . " " . $timezone . "\n" . "" . $url . "\n" . "" . $url . "\n" . "\n" . "\n"; } $end_text = "\n"; fwrite($fd, $start_text . $middle_text . $end_text); fclose($fd); } ?>