<?php
    $DBHOST='localhost';
    $DBNAME='crossspider';
    $DBAUTHUSER='robot';
    $DBAUTHPW='01001';
    

#------ END of settings -------------
    
    $connstring="host='$DBHOST' dbname='$DBNAME' user='$DBAUTHUSER' password='$DBAUTHPW'";

    header("Content-type: text/plain");
    header("Cache-Control: no-cache, no-store, must-revalidate");
    header("Expires: -1");
  
    #echo $connstring."\n";
    $db = Pg_Connect($connstring);
    if (!$db) {
        echo("Can't connect to database.");
        exit;
    }                 

    if (isset($_GET['id']) && $_GET['id']!=''){
        $q="select * ".
           "from lines ".
           "where id > '".qs($_GET['id'])."' ".
           "order by id ".
           "limit 30";
    }else{
        $q="select * ".
           "from lines ".
           "where id > (select max(id)-30 from lines) ".
           "order by id ";
    }

    $ret=Pg_Exec($db,$q);

    if (pg_numrows($ret) == 0 && isset($_GET['id'])){          
        print ("i|".$_GET['id']);
    }

    for ($i=0; $i < pg_numrows($ret); $i++){
        $row = Pg_Fetch_Array($ret,$i);
        //print ("s".qh($row["spot"])."\n");
        print ("s|".$row['id']."|".qh($row["spot"])."\n");
        if ($i + 1 == pg_numrows($ret)) print ("i|".$row['id']);
    }


function qh($a){
  $a=HtmlSpecialCHars("".$a);
  $a=str_replace("'","&#39;",$a);
  return $a;
}

function qs($a){
  $a = pg_escape_string($a);
  return $a;
}
    
?>