Connexion.js

var express = require('express');
var app = express();
var bodyParser = require('body-parser')
app.use( bodyParser.json() );       // to support JSON-encoded bodies
app.use(bodyParser.urlencoded({     // to support URL-encoded bodies
  extended: true
}));
var crypto = require('crypto');
var mysql      = require('mysql');
var exec = require('child_process').exec;
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : '***',
  database : 'battlecityalpha'
});
app.use(express.static('public'));

app.get('/', function (req, res) {
  res.send('Battle City Alpha\'s WebServer.');
});
app.get('/RestartBot', function (req, res) {
  if (req.query['Password'] == "aY6urh9afnceAGhe0oTa3vGdt") {
LaunchBot();
res.send("Nous allons tenter de relancer le bot.");
}
else
{
res.send("Erreur.");
}
});
app.get('/RestartServer', function (req, res) {
  if (req.query['Password'] == "aY6urh9afnceAGhe0oTa3vGdt") {
LaunchServer();
res.send("Nous allons tenter de relancer le Serveur.");
}
else
{
res.send("Erreur.");
}
});

app.get('/CalculateGain', function (req, res) {
var YourLevel = req.query['Level1'];
var OpponentLevel = req.query['Level2'];
var BaseSingle = 60;
var BaseMatch = 120;
var BaseTag = 80;
var WinSingle = OpponentLevel * 2 - YourLevel + BaseSingle;
var LoseSingle = WinSingle/2;
var WinMatch = OpponentLevel * 2 - YourLevel + BaseMatch;
var LoseMatch = WinMatch/2;
var WinTag = OpponentLevel * 2 - YourLevel + BaseTag;
var LoseTag = WinTag/2;
  res.send('En cas de Single, Victoire : ' + Math.round(WinSingle) + ' Défaite : ' + Math.round(LoseSingle) + '</br>' + 'En cas de Match, Victoire : ' + Math.round(WinMatch) + ' Défaite : ' + Math.round(LoseMatch) + '</br>' + 'En cas de Tag, Victoire : ' + Math.round(WinTag) + ' Défaite : ' + Math.round(LoseTag));
});


app.post('/Connect', function (req, res) {
 var name = req.body.pseudo,
        PasswordUser = req.body.password;

var sql    = 'SELECT * FROM users WHERE pseudo = ' + connection.escape(name);
connection.query(sql, function(err, results) {
   if (err) {
res.send("Error during MySql command : " + err);
  } else {
var PasswordDtb = results[0].Mdp;
var sha256 = crypto.createHash("sha256");
sha256.update(PasswordUser, "utf8");//utf8 here
var result = sha256.digest("hex");
if (result == PasswordDtb)
{
  if (results[0].Rang > 1)
  {
var PasswordRestart = "aY6urh9afnceAGhe0oTa3vGdt";
res.send("<a href=\"/RestartServer?Password=" + PasswordRestart + "\" ><button> Restart Server </button></a></br></br></br><a href=\"/RestartBot?Password=" + PasswordRestart + "\" ><button onClick=\"LaunchBot();\"> Restart Bot </button></a>");
}
else
{
res.send("Fonction à venir..");
}
}
else
{
res.send("Bad Password");
}
}
});
});

var server = app.listen(9002, function () {
  var host = server.address().address;
  var port = server.address().port;

  console.log('WebServer listening at http://%s:%s', host, port);
});
function LaunchBot() {
exec('sh ~/RestartBot.sh', function (err, stdout, stderr) {
console.log('Restart Bot.');
});
}
function LaunchServer() {
exec('sh ~/RestartServer.sh', function (err, stdout, stderr) {
console.log('Restart Server.');
});
}