var express = require('express');
var app = express();
var bodyParser = require('body-parser')
var url = bodyParser.urlencoded({ extended: false })

// var session = require('express-session');
// app.use(session({secret: 'ssshhh'}));
// var sess;

var cors = require('cors');
app.use(cors());

const mysql = require('mysql');
const crypto = require('crypto');
const secret = 'abcdefg';

const db = mysql.createConnection({
  host : 'localhost',
  port: '3307',
  user : 'root',
  password : 'usbw',
  database : 'user'
});
db.connect();

app.listen(8000);

app.post('/Register', url, (req, res) => {

  // console.log(realname);
  // console.log(username);
  // console.log(username);

  const encpass = crypto.createHash('sha256', secret).update(password).digest('hex');

  var sql = "INSERT INTO newusers (FullName, Username, Email, Password) VALUES ('"+realname+"','"+username+"','"+encpass+"')";
  db.query(sql, (err, result) => {
    if(err) throw err;
    // console.log(result);
  });
})