<?php
  global $HTTP\_RAW\_POST\_DATA;\; if\; (!isset($HTTP_RAW_POST_DATA))
     $HTTP\_RAW\_POST\_DATA\; =\; file\_get\_contents("php:$//input");
  
  require_once ('db.inc');
  require_once ('watch.inc');
  
  function write() {
    global HTTP_RAW_POST_DATA;
    $db=openDb();$dom = new DOMDocument();
    $dom->loadXML($HTTP_RAW_POST_DATA);
    if (!$dom->relaxNGValidate\; (\; \text{'}watch.rng\text{'}))\; \{\; die("unvalid\; document");\; \}$xml = simplexml_import_dom($dom);\; foreach\; ($xml->children() as $element)\; \{$element['escaped'] = sqlite_escape_string(trim($element));\; \}$//echo xml->asXML();
    $query\; =$db->query(
      "SELECT symbol from watches where symbol='".
        $xml->symbol[\text{'}escaped\text{'}].\; "\text{'}",\; SQLITE\_NUM);$req = "";
    if ($query->fetch())\; \{$req="update watches set ";
      $req\; .=\; "tag=\text{'}".$xml->tag['escaped']."', ";
      $req\; .=\; "title=\text{'}".$xml->title['escaped']."', ";
      $req\; .=\; "description=\text{'}".$xml->description['escaped']."' ";
      $req\; .=\; "where\; symbol=\text{'}".$xml->symbol['escaped']."'";
    } else {
      $req="insert\; into\; watches\; (symbol,\; tag,\; title,\; description)\; values\; (";$req .= "'".$xml->symbol[\text{'}escaped\text{'}]."\text{'},\; ";$req .= "'".$xml->tag[\text{'}escaped\text{'}]."\text{'},\; ";$req .= "'".$xml->title[\text{'}escaped\text{'}]."\text{'},\; ";$req .= "'".$xml->description[\text{'}escaped\text{'}]."\text{'})";\; \}$//echo req;
    $db->queryExec($req);
    echo "<ok/>";
  }
  
   header("Cache-Control: max-age=60");
   header("Content-type: application/xml");
   $db=openDb();\; if\; (strlen($HTTP_RAW_POST_DATA)>0) {
     print write($db);\; \}\; else\; if\; ($_GET['name']) {
     print getAWatch($db,$_GET['name']);
   } else {
     print getAllWatches($db);\; \}\; ?>$