From 08f341f692688f077e9080bded2b14fdd5979c1e Mon Sep 17 00:00:00 2001
From: Adam Soltys <adam.soltys@pwgsc-tpsgc.gc.ca>
Date: Tue, 6 Nov 2012 20:38:48 -0800
Subject: Read parameters from client account

---
 clients.js | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 clients.js

(limited to 'clients.js')

diff --git a/clients.js b/clients.js
new file mode 100644
index 00000000..f75b5d52
--- /dev/null
+++ b/clients.js
@@ -0,0 +1,22 @@
+var http = require('http');
+var mysql = require('mysql');
+var url = require('url');
+
+http.createServer(function (req, res) {
+  res.writeHead(200, { 'Content-Type': 'text/plain' });
+  var client = url.parse(req.url, true).query.client;
+
+  var connection = mysql.createConnection({
+    host     : 'localhost',
+    user     : 'root',
+    password : 'MPJzfq97',
+    database:  'vanbtc'
+  });
+
+  connection.connect();
+  connection.query("SELECT * FROM users WHERE login = ?", [client], function(err, rows) {
+    res.write(JSON.stringify(rows));
+    connection.end();
+    res.end();
+  });
+}).listen(8000);
-- 
cgit v1.2.3