<?xml version="1.0" encoding="ISO-8859-1" ?><rss version="2.0">
<channel>
<title>JEMS - Journal and Event Management System</title>
<link>https://jems.sbc.org.br</link>
<description>List of conferences that are currently accepting submission.</description>
<language>en-US</language>
<webMaster>crpsantos@inf.ufrgs.br</webMaster>
<?

$sql = "SELECT c.conference, c.name, c.fullname, c.url, t.trackname, c.conference_begin, c.conference_end,
	date_format(t.submit_from,'%a, %b %e %H:%i') as submit_from, 
	date_format(t.register_by,'%a, %b %e %H:%i') as register_by, 
	date_format(t.submit_by,'%a, %b %e %H:%i') as submit_by 
	FROM  track t , conference c 
	WHERE c.conference = t.conference AND ((submit_by >= NOW() AND register_by < NOW()) OR (register_by >= NOW() and submit_from <= NOW()))";

$resultado = mysql_query($sql) or die (mysql_error());

$xml = "";

while ($linha=mysql_fetch_array($resultado)) {
	$c = $linha[0];
       	$titulo = $linha[1];
	$fullname = $linha[2];
	$url = $linha[3];
	$trackname = $linha[4];
	$begin = $linha[5];
	$end = $linha[6];
	$subfrom = $linha[7];
	$regby = $linha[8];
	$subby = $linha[9];

	$xml = $xml."<item>";
       	$xml = $xml."<title>$titulo";
	if ($trackname != "") $xml = $xml." - $trackname";
	$xml = $xml."</title>";
       	$xml = $xml."<link>https://submissoes.sbc.org.br/home.cgi?c=$c</link>";
       	$xml = $xml."<description>";
	if ($fullname != "") {
		$xml = $xml."$fullname ";
	} else {
		$xml = $xml."$titulo ";	
	}
	if ($url != "") {
		$xml = $xml."($url) ";
	}
	$xml = $xml."will be held in $begin to $end. Constributions can be submitted starting on $subfrom. Paper registration deadline is $regby. Manuscript submission deadline is $subby.";
	$xml = $xml."</description>";
       	$xml = $xml."</item>";

}
echo $xml;
?>
</channel>
</rss>

