--- a/displayroutes.kml.php
+++ b/displayroutes.kml.php
@@ -1,1 +1,65 @@
+<?php

+header('Content-Type: application/vnd.google-earth.kml+xml');

+echo '<?xml version="1.0" encoding="UTF-8"?>

+<kml xmlns="http://www.opengis.net/kml/2.2"><Document>';

+echo '

+    <Style id="yellowLineGreenPoly">

+      <LineStyle>

+        <color>7f00ff00</color>

+        <width>4</width>

+      </LineStyle>

+      <PolyStyle>

+        <color>7f00ffff</color>

+      </PolyStyle>

+	</Style>';

+$conn = pg_connect("dbname=openstreetmap user=postgres password=snmc");

+if (!$conn) {

+  echo "An error occured.\n";

+  exit;

+}

+

+$result_route = pg_query($conn, "SELECT * from current_relation_tags, (Select id FROM current_relation_tags WHERE k = 'route' AND v = 'bus') as a 

+where a.id = current_relation_tags.id and k = 'ref';");

+if (!$result_route) {

+  echo "An route retirieve error occured.\n";

+  exit;

+}

+

+while ($route = pg_fetch_assoc($result_route)) {

+ echo "\n<Placemark>\n";

+ echo "<name>".$route['v']." position at ".$route['id']."</name>";

+ echo "<description>".$route['v']." position at ".$route['id']."</description>";

+echo "<styleUrl>#yellowLineGreenPoly</styleUrl>";

+echo "      <LineString>

+        <extrude>1</extrude>

+        <coordinates> ";

+$result_way = pg_query($conn, 'SELECT member_id, sequence_id FROM "current_relation_members" WHERE "id" = '.$route['id'].' order by "sequence_id" 

+ASC');

+if (!$result_way) {

+  echo "An way retirieve error occured.\n";

+  exit;

+}

+  $count = 0;

+

+while ($way = pg_fetch_assoc($result_way)) {

+	$result_node = pg_query($conn, 'SELECT * FROM current_nodes INNER JOIN current_way_nodes ON current_way_nodes.node_id=current_nodes.id WHERE 

+current_way_nodes.id = '.$way['member_id'].' order by "sequence_id" ASC');

+	if (!$result_node) {

+	  echo "An node retirieve error occured.\n";

+	  exit;

+	}

+

+	while ($node = pg_fetch_assoc($result_node)) {

+   $count++;

+		echo ($node['longitude']/10000000).",".($node['latitude']/10000000).",600 \n";

+	}

+}

+	if ($count == 0) echo (0).",".(0).",600 \n";

+echo "        </coordinates>

+      </LineString>";

+echo '</Placemark>';

+}

+

+echo "\n</Document></kml>\n";

+?>