function getLink($cid)
{
global $config;
foreach ($config['hosts'] as $o) {
if ($o['cid'] == $cid) {
break;
}
$o = NULL;
}
if (!$o) {
return;
}
$link = GetMySQLLink($o['host'], $o['uname'], $o['passwd'] === NULL ? $o['tempPasswd'] : $o['passwd'], $o['port']);
if (is_string($link)) {
respondError($link, TRUE);
}
return $link;
}
}
if (!$task) {
exit("Task #{$req['task']} was not found");
}
$host = NULL;
foreach ($conf['hosts'] as $h) {
if ($h['cid'] == $task['cid']) {
$host = $h;
break;
}
}
if (!$host) {
exit("Connection with ID {$task['cid']} was not found");
}
require __INC__ . '/mysql.php';
$link = GetMySQLLink($host['host'], $host['uname'], $host['passwd'], $host['port'], $task['db']);
if (is_string($link)) {
exit($link);
}
$res = MySQLQuery($link, $task['sql'], NULL, 0, -1, 1024);
if (is_string($res)) {
exit($res);
}
echo '<div>' . $task['title'] . '</div>';
$cnt = count($res['fields']);
for ($i = 0; $i < $cnt; $i++) {
echo '<div class="t"><div class="r header">';
foreach ($res['fields'][$i] as $f) {
echo '<div class="c">' . $f['fieldAlias'] . '</div>';
}
echo '</div>';
