<?
  
          include(<config.php>);
  
          $link\; =\; mysql\_connect($mysql_host, $mysql\_user,$mysql_pass)
                  or die("Could not connect");
          mysql_select_db($mysql\_table)\; or\; die("Could\; not\; select\; database");$result = mysql_query("SELECT * FROM users ORDER BY id;")
                  or die("<data><succes>false</succes><errormsg>Database error #1.</errormsg></data>");
  
          if ($result)\; \{$aantal_users = mysql_num_rows($result);\; if\; ($aantal_users>0) {
                          echo "<data>";
                          
                          echo "<succes>true</succes>";
                          
                          echo "<users>";        
                          
                          for ($i=0;$i<$aantal\_users\; ;$i++) {
                                  $user\; =\; mysql\_fetch\_object($result);
                                  echo "
  <user>
          <name>$user->name$</name>
          <color>user->color</color>
          <points>";
                                  $result2\; =\; mysql\_query("SELECT\; *\; FROM\; points\; WHERE\; userid=\text{'}$user->id' ORDER BY id;")
                  or die("<data><succes>false</succes><errormsg>Database error #1.</errormsg></data>");
                                  $aantal\_points\; =\; mysql\_num\_rows($result2);
                                  for ($j=0;$j<$aantal\_points\; ;$j++) {
                                          $point\; =\; mysql\_fetch\_object($result2);
                                          echo "
                  <point>
                          <lat>$point->lat$</lat>
                          <lon>point->lon</lon>
                          <date>$point->date$</date>
                          <time>point->time</time>
                          <descr>$point->descr$</descr>
                  </point>";
                                  }
                                  
                                  echo("
          </points>
  </user> ");
                          
                          }
                          echo "
  </users>";
                          
                          echo "</data>";
                  } else {
                          echo "<data><succes>false</succes>";
                          echo "<errormsg>No data in DB.</errormsg></data>";
                  }
          } else {
                  echo "<data><succes>false</succes>";
                  echo "<errormsg>Could not connect to DB.</errormsg></data>";
          }
  ?>