var express = require('express');
var router = express.Router();
var session = require('express-session');
var bodyParser = require('body-parser');
var app = express();

//init seesion
app.set('trust proxy', 1) ;
app.use(session({
  secret: 'My Secret Key',
  resave: false,
  saveUninitialized: true,
  cookie: { id: 60000 }
}));

//init connection
var conn = require('./cfg');
conn = conn.connection;

//init player

module.exports = player;
var player = { init:function init(id){
	app.use(function (req, res, next) {
	var sess = req.session;
	  if(sess.cookie.id)
		console.log('user logged in');
	req.session.cookie.id = id;
	});

}
};

//page request TODO POST  at the moment put 'real' username and password
router.get('/', function(req, res) {
	conn.query('SELECT * FROM users WHERE username=? AND password=?',["admin", "123"], function(err, rows, fields) {
	if (err) throw err;
	if(rows.length)
		var id = rows[0].password;
		player.init(id);
	});
	if(req.session.cookie.id)
		res.write('Hello User! ');
  res.send('HomePage');
});

module.exports = router;