Code:
<?php
$dbc = mysql_connect("localhost", "antiphishing_org_uk", "9a9ca65a") or die ('could not connect:'. Mysql_error());
mysql_select_db("antiphishing_org_uk_1");
$file="news.xml";
$jsfile="news.js";
//ftruncate($file,0);
$fp = fopen ($file, "w") or die("can't open/create file");
$fjs = fopen ($jsfile, "w") or die ("can't open/create js file");
//write rss file header
if (!fwrite($fp,"<?xml version=\"1.0\" ?>\n")) {echo ("cant write"); }
fwrite($fp,"<rss version=\"2.0\">\n");
fwrite($fp,"<channel>\n");\
fwrite($fp,"<title>Antiphishing Crusade</title>\n");
fwrite($fp,"<link>http://www.antiphishing.org.uk</link>\n");
fwrite($fp,"<description>\nKeeping tabs on those trying to defraud us\n</description>\n");
fwrite($fp,"<language>en-us</language>\n");
fwrite($fp,"<webMaster>webmaster@antiphishing.org.uk</webMaster>\n");
//write js file header
fwrite($fjs,"document.write(\"<div class='js_news'>\");\n");
if (!fwrite($fjs, "document.write(\"<font face='verdana' size='2'>Antiphishing Crusade</font>
<font face='arial' size='2'>Latest Phishing News</font>
\");\n")) {echo ("cant write js"); }
$query= "SELECT address,title,quote,DATE_FORMAT(adddate,'%e %M') FROM news ORDER BY adddate desc LIMIT 10";
$result=@mysql_query($query);
if ($result){
while ($row = mysql_fetch_array($result,MYSQL_NUM)) {
//write rss feed
$row1 = htmlspecialchars($row[1]);
$row2 = htmlspecialchars($row[2]);
$row0 = htmlspecialchars($row[0]);
fwrite($fp,"<item>\n");
fwrite($fp,"<title>$row[3] $row1</title>\n");
fwrite($fp,"<link>$row0</link>\n");
fwrite($fp,"<description>$row2</description>\n");
fwrite($fp,"</item>\n");
//write js feed
fwrite($fjs,"document.write(\"<font face='arial' size='2'>$row[3]</font>
<font face='arial' size='1'>$row[1]</font>
\");\n");
}
mysql_free_result($result);
}
fwrite($fp,"</channel>\n");
fwrite($fp,"</rss>\n");
fwrite($fjs,"document.write(\"</div>\");");
fclose($fp);
fclose($fjs);
?>