ERROR: Missing parameters.\n"; return false; } // allow only SELECT, SHOW or DESCRIBE queries $allowed = "^(select|show|describe)"; if (!eregi($allowed, trim($_REQUEST['query']))) { echo "ERROR: Only 'SELECT', 'SHOW', or 'DESCRIBE' queries are allowed.\n"; return false; } $result = sqlquery(MDB_DATA_DSN, $_REQUEST['query']); if (is_object($result) && DB::isError($result)) { echo "ERROR ".$result->getCode().": ".$result->getMessage()."\n"; return false; } $format = isset($_REQUEST['format']) ? strtolower($_REQUEST['format']) : "csv"; switch ($format) { case "wddx" : $out = wddx_serialize_value($result); break; case "serialize" : $out = serialize($result); break; case "table" : $out = toTable($result); break; case "csv" : default : $fields = array_keys($result[0]); $out = toCSV($fields); for ($i=0; $i < count($result); $i++) { $out .= toCSV(array_values($result[$i])); } break; } echo $out; return true; }/*}}}*/ // wrapper function to get PDB ids for a given metal function metallopdb() {/*{{{*/ if (!$_REQUEST['metal']) { echo "ERROR: Missing parameters.\n"; return false; } $metal = strtolower($_REQUEST['metal']); $mode = isset($_REQUEST['mode']) ? strtolower($_REQUEST['mode']) : 'first'; $count = isset($_REQUEST['count']) ? intval($_REQUEST['count']) : 5; $format = isset($_REQUEST['format']) ? strtolower($_REQUEST['format']) : 'csv'; $result = getPDBFromMetal($metal, $mode, $count); if (is_object($result) && DB::isError($result)) { echo "ERROR ".$result->getCode().": ".$result->getMessage()."\n"; return false; } if ($result == false) { echo ""; return false; } switch ($format) { case "wddx" : header("Content-type: text/xml"); echo wddx_serialize_value($result); break; case "serialize" : header("Content-type: text/plain"); echo serialize($result); break; case "rss" : header("Content-type: text/xml"); echo toRSS($result,$GLOBALS['server_remote']); break; case "csv" : default : header("Content-type: text/plain"); $fields = array_keys($result[0]); $out = toCSV($fields); for ($i=0; $i < count($result); $i++) { $out .= toCSV(array_values($result[$i])); } echo $out; break; } return true; }/*}}}*/ // execute the api wrapper function $output = $func(); } else { // show introspection require_once "general.lib"; function get_content_ts() {/*{{{*/ return -1; }/*}}}*/ function get_content() {/*{{{*/ $content = lib_content("__default"); $content['name'] = $_SERVER['PHP_SELF']; $content['title'] = 'MDB - Web API (introspection)'; $content['page_title'] = 'MDB - Web API (introspection)'; $apidesc = "

\n"; $apidesc .= "\n"; foreach ($GLOBALS['apidoc'] as $func=>$doc) { if ($func == "get") continue; $apidesc .= "\n"; } $apidesc .= "

\n"; $apidesc .= "\n"; $apidesc .= "

\n"; $apidesc .= "\n"; $apidesc .= "\n"; $apidesc .= "\n"; $apidesc .= "\n"; $apidesc .= "\n\n\n\n"; $apidesc .= "

Function: $func	\nParameters: \n"; foreach ($GLOBALS['apiparams'][$func] as $param=>$desc) $apidesc .= " $param: $desc \n"; $apidesc .= " \n
"; $apidesc .= " Description: "; $apidesc .= htmlspecialchars($doc)." \n

\n"; $content['body'] = $apidesc; $content['timestamp'] = -1; $content['page_img'] = 'MDB Web API:/images/api.png:/services/api/index.php'; return $content; }/*}}}*/ require_once "dochandler.lib"; } ?>