$DB->commit();
$_POST['item']['id'] = $id;
}
}
}
} catch (Exception $e) {
$DB->rollBack();
addMessage($e->getMessage());
}
} else {
$_POST['item'] = array();
if ($id) {
$_POST['item'] = fetchItem($id);
} else {
if (@$_GET['clone']) {
$_POST['item'] = fetchItem($_GET['clone']);
unset($_POST['item']['id']);
// very important!
} else {
$_POST['item']['sql'] = "SELECT COUNT(*)\nFROM some_table\nWHERE created BETWEEN \$FROM AND \$TO\n";
}
}
}
}
$SELECT_DSNS = array();
foreach ($DB->select("SELECT id, name FROM dsn ORDER BY name") as $row) {
$SELECT_DSNS[$row['id']] = $row['name'];
}
$SELECT_ITEMS = array();
$seenArchived = 0;
foreach ($DB->select("SELECT id, name, archived FROM item ORDER BY archived, name") as $row) {
$res = dbQuery("insert into queries (name, description, query, created) values({$_POST['name']}, {$_POST['description']}, {$_POST['query']}, NOW())");
$query_id = $db->insert_id;
}
if ($db->affected_rows >= 1) {
$info = "Query saved";
}
} else {
if ($action == 'runquery') {
$query = fetchItem("select query from queries where query_id=" . $_POST['query_id']);
$res = dbQuery($query);
if ($res) {
$info = 'Query successfully returned ' . $res->num_rows . ' rows.';
$output = exportTSV($res);
#$info.= "<pre>".str_replace("\n", '<br/>', $output)."</pre>";
$res = dbQuery('update queries set executed=NOW() where query_id=' . $_POST[query_id]);
$executed = fetchItem('select executed from queries where query_id = ' . $_POST[query_id]);
}
echo "error = \"{$error}\"; info=\"{$info}\"; executed=\"" . str_replace(' ', '<br/>', $executed) . "\";";
exit;
}
}
}
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Minerva Project Query Manager</title>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
