setMenuStructureString($menuString); $mid->parseStructureForMenu('treemenu1'); $tmpTable = "t".date('YmdHis'); $mid->setTableName($tmpTable); $sqlDump = $mid->getSQLDump('treemenu1'); $sqlCreate = "CREATE TEMPORARY TABLE ".$tmpTable." ( ". " ".implode(" varchar(255), ", $mid->tableFields)." varchar(255) ". " )"; //$adodb->debug = 1; $adodb->Execute($sqlCreate); $pie = explode(";", $sqlDump); foreach ($pie as $k => $v) $adodb->Execute($v); if (isset($_GET['id'])) { $rs = $adodb->Execute("SELECT * FROM ".$tmpTable. " WHERE parent_id = ? ", array($_GET['id'])); header("Content-Type: text/xml"); header("Cache-Control: no-cache"); echo "\n"; echo "\n"; while (!$rs->EOF) { $rs2 = $adodb->Execute("SELECT COUNT(*) as cnt FROM ".$tmpTable. " WHERE parent_id = ? ", array($rs->fields['id'])); echo "fields['text'])."\" "; if ($rs2->fields['cnt']>0) { echo " src=\"".htmlspecialchars($_SERVER['PHP_SELF']."?id=".$rs->fields['id'])."\" "; } echo " action=\"".htmlspecialchars($rs->fields['href'])."\" ". " target=\"".htmlspecialchars($rs->fields['target'])."\" ". " />\n"; $rs->MoveNext(); } echo "\n"; exit; } ?>