require("rssfeed.php"); require ("sqlconnect.php"); $myfeed = new RSSFeed(); //$u = $_GET["u"]; if (!is_numeric($u)) unset($u); $feedTitle = "BJS Calendar RSS Feed"; $myfeed->SetChannel('http://steadfastLutherans.org/cal/rss.php', $feedTitle, "Lutheran Events from SteadfastLutherans.org", 'en-us', 'Publicize freely', 'SteadfastLutherans.org', 'Lutheran Seminars'); $myfeed->SetImage('http://www.lcmssermons.com/images/lutherRose172.gif'); $yesterday = date("Y-m-d", strtotime("today - 7 days")); $qstrpage = "SELECT * FROM calendar WHERE date>'$yesterday' ORDER BY date LIMIT 10"; $checkAudio = mysql_query($qstrpage . $qstr); if (!$checkAudio) { print "
ERROR -- BAD SQL?
$qstr
".mysql_error()."";
exit;
}
while ($line = mysql_fetch_row($checkAudio)) {
list($formNum,$formDate,$formLocation,$formPresenters,$formInfo,$formTitle) = $line;
$smText = htmlspecialchars(substr(strip_tags($formInfo),0,1024));
$smText = substr($smText, 0, strrpos($smText, ' '));
$formLocation = htmlspecialchars($formLocation);
$myfeed->SetItem("http://www.steadfastLutherans.org/cal.php?n=$formNum",
htmlspecialchars($formTitle),
"$formDate - $formLocation - $smText...", $formDate,$linkMP3,$contentLength);
}
echo $myfeed->output();
?>