--- trunk/tntnet/dynamic/critical.ecpp	2007/11/27 14:28:59	68
+++ trunk/tntnet/dynamic/critical.ecpp	2007/11/29 17:06:38	104
@@ -1,11 +1,46 @@
+<%pre>
+#include <tntdb/connect.h>
+#include <tntdb/connection.h>
+#include <tntdb/result.h>
+#include <tntdb/row.h>
+
+#include <vector>
+
+
+
+class CriticalInstallation
+{
+public:
+	CriticalInstallation() {}
+	CriticalInstallation(int i, std::string m) : id(i), message(m) {}
+	int id;
+	std::string message;
+};
+
+</%pre>
+
 <%config>
 dburl;
 </%config>
 
 <&header title="Critical systems">
 </&header>
+<h2>Critical systems</h2>
+
+<{
+
+
+std::vector<CriticalInstallation> criticals;
+
+tntdb::Connection conn = tntdb::connect(dburl); 
+
+tntdb::Result res = conn.select("SELECT id FROM installation WHERE commerror = true");
+for (int i=0; i<res.size(); ++i)
+{
+	criticals.push_back(CriticalInstallation(res[i].getInt(0), std::string("Communication Error")));
+}
 
-<$ dburl $>
+}>
 
 <&footer>
 </&footer>