blob: 9f425e352d614fb27909756244888441935884f8 [file] [log] [blame]
<?php
header("Cache-control: no-cache");
header('Content-type: application/xml;charset=iso-8859-1;',true);
include ($_SERVER['DOCUMENT_ROOT'] . '/eclipse.org-common/system/smartconnection.class.php');
$dbc = new DBConnection();
$dbh = $dbc->connect();
$query = "SELECT * from ganymede_spots as GS INNER JOIN ganymede_content as GC on GS.id = GC.id";
$result = mysql_query ($query) or die ($query . mysql_error());
ob_start();
?>
<markers>
<?
while ($rr = mysql_fetch_array($result))
{
$name = $rr['name'];
$location_city = $rr['location_city'];
$location_state = $rr['location_state'];
$location_country = $rr['location_country'];
$randLat = rand (-99, 99) / 1000;
$randLng = rand (-99, 99) / 1000;
$location_lat = $rr['location_lat'] + $randLat;
$location_lng = $rr['location_lng'] + $randLng;
$location = $location_city . ', ' . $location_country;
$email = $rr['email'];
$title = htmlspecialchars($rr['title']);
$url = htmlspecialchars($rr['url']);
$type = ucfirst($rr['type']);
if (strpos($url, "http://") === FALSE)
{
$url = "http://" . $url;
}
if ($url == "http://")
{
$url = "";
}
$content = $rr['content'];
?><marker lat="<?=$location_lat;?>" lng="<?=$location_lng;?>" location="<?=$location;?>" author="<?=$name;?>" title="<?=$title;?>" type="<?=$type;?>" url="<?=$url;?>"><? if ($content != "") {?><![CDATA[<?=$content;?>]]><? } ?></marker>
<?
} ?>
</markers>
<? $xml = ob_get_clean();
//echo mb_detect_encoding($xml);
mb_convert_encoding($xml, "HTML-ENTITIES", "UTF-8");
echo $xml;
?>