<?php
require_once 'globals.inc';
require_once 'api/api_functions.php';
if (isset($func) && !empty($func)) {
if (!in_array($func, array_keys($api))) {
echo "Unknown function";
exit;
}
// include the appropriate function
require_once "{$api[$func]}";
require_once "api/util_convert.php";
// SQL query wrapper function
function sql() {/*{{{*/
if (!$_REQUEST['query']) {
echo "<b>ERROR: Missing parameters.</b>\n";
return false;
}
// allow only SELECT, SHOW or DESCRIBE queries
$allowed = "^(select|show|describe)";
if (!eregi($allowed, trim($_REQUEST['query']))) {
echo "<b>ERROR: Only 'SELECT', 'SHOW', or 'DESCRIBE' queries are allowed.</b>\n";
return false;
}
$result = sqlquery(MDB_DATA_DSN, $_REQUEST['query']);
if (is_object($result) && DB::isError($result)) {
echo "<b>ERROR ".$result->getCode().": ".$result->getMessage()."</b>\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 "<b>ERROR: Missing parameters.</b>\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 "<b>ERROR ".$result->getCode().": ".$result->getMessage()."</b>\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 = "<div align='center'>\n";
$apidesc .= "<table width='90%' border='0' cellpadding='5'>\n";
foreach ($GLOBALS['apidoc'] as $func=>$doc) {
if ($func == "get")
continue;
$apidesc .= "<tr><td>\n";
$apidesc .= "<table border='0' width='100%' cellpadding='0' cellspacing='0'>\n";
$apidesc .= "<tr><td bgcolor='#000000'>\n";
$apidesc .= "<table border='0' width='100%' cellspacing='1' cellpadding='5'>\n";
$apidesc .= "<tr bgcolor='#eeeeee'>\n";
$apidesc .= "<th align='center'><i>Function</i>:<br /> $func</th>\n";
$apidesc .= "<th align='left'>\n<i>Parameters</i>:<ul>\n";
foreach ($GLOBALS['apiparams'][$func] as $param=>$desc)
$apidesc .= "<li>$param: $desc</li>\n";
$apidesc .= "</ul>\n</th>\n";
$apidesc .= "</tr>\n<tr bgcolor='#ddffff'>\n<td colspan='2'>";
$apidesc .= "<p><b>Description:</b><br />";
$apidesc .= htmlspecialchars($doc)."</p>\n</td>\n</tr>\n";
$apidesc .= "</table>\n</td></tr></table>\n</td></tr>\n";
}
$apidesc .= "</table></div>\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";
}
?>
