<?php

require_once('../init.php');

header("Cache-Control: no-cache");
header("Pragma: no-cache");
header("Expires: ".gmdate("D, d M Y H:i:s",time()+(-1*60))." GMT");
header("Content-type: text/xml");

require_once('../lib/dbase.php');
require_once('../lib/dbClass.php');
require_once('../lib/rico3/plugins/php/ricoResponse.php');

$id=isset($_GET["id"]) ? $_GET["id"] : "";
$filters=isset($_SESSION[$id . ".filters"]) ? $_SESSION[$id . ".filters"] : array();
$oXmlResp= new ricoXmlResponse();
$errmsg='';
$query='';

if (!isset($_SESSION[$id])) {
  $errmsg="Your connection with the server was idle for too long and timed out. Please refresh this page and try again.";
} elseif (!OpenDB()) {
  $errmsg=$oDB->LastErrorMsg;
} else {
  $query=$_SESSION[$id];
  if (isset($_SESSION[$id . ".filters"])) $filters=$_SESSION[$id . ".filters"];
  $oXmlResp->SetDbConn($oDB);
  $oXmlResp->sendDebugMsgs=true;
  $oXmlResp->convertCharSet=false;
}

if (isset($_GET['second_id']))
  $query = str_replace('{id}', $_GET['second_id'], $_SESSION[$id]);
else
  $query = $_SESSION[$id];

$distinctquery = false;
$distinct = isset($_GET["distinct"]) ? $_GET["distinct"] : false;
if ($distinct !== false && isset($_SESSION[$id.'_distinct_'.$distinct]))
  $distinctquery = $_SESSION[$id.'_distinct_'.$distinct];

$oXmlResp->SetGridDefinition(grid_definition($id));
$oXmlResp->ProcessQuery($id, $query, $filters, $errmsg, $distinctquery);
$oXmlResp=NULL;