<?php
session_start();
if (session_is_registered("user"))
{
  require("db_credentials.php");

  $db = @mysql_connect($db_host, $db_name,$db_passwd) or die ("MySQL error");
  @mysql_select_db($db_database, $db) or die ("MySQL error");

  $username = $_SESSION["user"];
  
  $result = mysql_query("select id from users where login='$username'", $db);
  if ($result !== FALSE) {
    $data = @mysql_fetch_assoc($result);
    $id = $data["id"];

    $result = mysql_query("select markers.*,users.login from markers left join users on markers.ownerid=users.id where public=0 and ownerid=$id", $db);
    if ($result !== FALSE) {
      while ($data = @mysql_fetch_assoc($result))
        $res[] = $data;
    }
    echo json_encode($res);
  }
}
?>