function getReportArray($name)
{
$arr = array();
$xml = new xml();
$rpt_strXML = LoadSelectedReport($name);
$arr = $xml->xml_to_array($rpt_strXML);
if (count($arr)) {
$_SESSION["webobject"]["table_type"] = $arr["table_type"];
$_SESSION["object_sql"] = $arr["sql"];
if ($arr["table_type"] == "custom") {
$connection = getWebreportConnection();
// #9875
$tables_query = $arr["tables"][0];
$strSQL = "SELECT " . $connection->addFieldWrappers("sqlcontent") . " FROM " . $connection->addTableWrappers("webreport_sql") . " WHERE " . $connection->addFieldWrappers("sqlname") . "='" . $tables_query . "'";
$row = $connection->query($strSQL)->fetchNumeric();
if ($row) {
$_SESSION["object_sql"] = $row[0];
}
}
}
return $arr;
}
function getReportArray($name)
{
$arr = array();
$xml = new xml();
$rpt_strXML = LoadSelectedReport($name);
$arr=$xml->xml_to_array($rpt_strXML);
if(count($arr))
{
$_SESSION["webobject"]["table_type"]=$arr["table_type"];
$_SESSION["object_sql"]=$arr["sql"];
if($arr["table_type"]=="custom")
{
global $conn;
$tables_query=$arr["tables"][0];
$strSQL = "SELECT ".AddFieldWrappers("sqlcontent")." FROM ".AddTableWrappers("webreport_sql")." WHERE ".AddFieldWrappers("sqlname")."='".$tables_query."'";
$rs = db_query($strSQL,$conn);
if($row = db_fetch_numarray($rs))
$_SESSION["object_sql"]=$row[0];
}
}
return $arr;
}
