"express": "~4.9.0",
"ejs": "~0.8.5",
"socket.io":"~1.3.3"

// loading modules
var express = require('express');
var http = require('http');
var app = express();
var server = http.createServer(app);
var io = require('socket.io').listen(server);

//routers
var secretRouter = require('./routes/secret');

// Setup serving static assets
app.use(express.static('public'));

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'ejs');


// Setup initial routing - index
app.use('/', secretRouter);


// Start the server
server.listen(3000, function(){
 console.log('App listening at http://localhost:3000');
});

var express = require('express');
var router = express.Router();

// Show the login form
router.get('/login', function(req, res, next) {
  res.locals.req = req;
  res.render('secret/login');
});

// If someone tries to login
router.post('/login', function(req, res, next) {
username = req.body.username;
password = req.body.password;
req.getConnection(function(err, connection){
connection.query('SELECT * FROM users WHERE name = ? AND password = ?',[username, password], function(err, results) {
  res.locals.data = results;
  if (results.length > 0){
    req.session.regenerate(function(){
    req.session.login = true;
    req.session.username = req.body.username;
    res.redirect(req.baseUrl);
    });
  }else {
console.log('wachtwoord of naam is fout');
res.redirect(req.baseUrl);
}
});
});
});

module.exports = router;

io.on('connection', function(socket){
  console.log('a user connected');
});