server.js

let express = require("express"),
  session = require("express-session"),
  passport = require("passport"),
  DiscordStrategy = require("passport-discord"),
  EVEStrategy = require("passport-eveonline"),
  request = require("request"),
  esi = require('eve-swagger'),
  cookieParser = require("cookie-parser"),
  time = require("moment"),
  app = express(),
  config = require("./config.json");

passport.serializeUser(function (user, done) {
  done(null, user);
});
passport.deserializeUser(function (obj, done) {
  done(null, obj);
});

let discordScopes = ["identify", "guilds.join"];
passport.use(new DiscordStrategy({
  clientID: config.discordClientID,
  clientSecret: config.discordSecret,
  callbackURL: config.discordCallBack,
  scope: discordScopes
}, function (accessToken, refreshToken, profile, done) {
  process.nextTick(function () {
    return done(null, profile, accessToken);
  });
}));
passport.use(new EVEStrategy({
  clientID: config.eveClientID,
  clientSecret: config.eveSecret,
  callbackURL: config.eveCallBack
}, function (characterInformation, done) {
  return done(null, characterInformation);
}));

app.use(session({
  secret: config.sessionSecret,
  resave: false,
  saveUninitialized: false
}));
app.use(passport.initialize());
app.use(passport.session());
app.use(cookieParser());

app.get("/", passport.authenticate("discord", {scope: discordScopes}), function (req, res) {
});
app.get("/auth/discord", passport.authenticate("discord", {failureRedirect: "/fail"}), function (req, res) {
  // Join user to guild..
  console.log("Joining user to guild..");
  let authorizationToken = "Bearer " + req.authInfo;
  request({
    headers: {
      "Authorization": authorizationToken,
      "User-Agent": "EVE Discord Authenticator"
    },
    uri: "https://discordapp.com/api/invites/" + config.discordInviteID,
    method: "POST"
  }, function (err, ret, body) {
    if (err) {
      res.redirect("/error");
    }
    else {
      let options = {maxAge: 1000 * 60 * 15, httpOnly: false, signed: false};
      res.cookie("did", req.user.id, options);
      res.redirect("/eve");
    }
  });
});
app.get("/eve", passport.authenticate("eveonline"));
app.get('/auth/eve', passport.authenticate('eveonline', {failureRedirect: '/error'}), function (req, res) {
  // Get user information from CCPs API server (the characterAffiliate endpoint)
  let characterID = req.user.CharacterID;
  esi.characters(characterID).info().then(function (result) {
    console.log(result);
    let corporationID = result.corporation_id;
    let allianceID = result.alliance_id;
    let discordID = req.cookies.did;
    esi.corporations(corporationID).info().then(function (result2) {
       console.log(result2);
       request({
          headers: {
            "Authorization": "Bot " + config.discordBotToken,
            "User-Agent": "EVE Discord Authenticator"
          },
          uri: "https://discordapp.com/api/guilds/" + config.guildID + "/members/" + discordID,
          method: "PATCH",
          json: {"nick": "[" + result2.ticker + "] " + result.name}
       }, function (err, ret, body) {
         console.log("Nickname Update: " + err + " " + ret + " " + body);
         if (config.corporationIDs.includes(corporationID) || config.allianceIDs.includes(allianceID)) {
          request({
            headers: {
              "Authorization": "Bot " + config.discordBotToken,
              "User-Agent": "EVE Discord Authenticator"
            },
            uri: "https://discordapp.com/api/guilds/" + config.guildID + "/members/" + discordID + "/roles/" + config.roleID,
            method: "PUT"
          }, function (err, ret, body) {
            if (err) {
              res.redirect("/error");
            }
            console.log("Member Update: " + ret + " " + body);
            console.log("Discord ID: " + discordID);
            console.log(result.name + " is now authed and can use discord");
            addUserToSQLite(result.name, characterID, corporationID, allianceID, discordID, config.roleID, config.guildID);
            res.send('{"success": "You are now authenticated, close this window and use Discord like a champion!"}');
          });
        } else {
          res.redirect("/error");
        }
      });
    });
  });
});

// Error handler.. lulz?!!?
app.get("/error", function (req, res) {
  res.send('{"error": "Either you are not in the correct corporation/alliance to get roles, or something fucked up.. Noone knows :("}');
});

app.listen(config.listenPort, config.listenIP, function (err) {
  if (err) return console.log(err);
  console.log("Listening at " + config.listenIP + " on port " + config.listenPort);
});

function addUserToSQLite(characterName, characterID, corporationID, allianceID, discordID, roleID, guildID) {
  let sqlite3 = require("sqlite3").verbose();
  let db = new sqlite3.Database("./database.sqlite");

  // Check if the table exists
  db.serialize(function () {
    db.run("CREATE TABLE IF NOT EXISTS users (characterName TEXT, characterID TEXT, corporationID TEXT, allianceID TEXT, discordID TEXT, roleID TEXT, guildID TEXT, lastChecked TEXT)");
    db.run("CREATE UNIQUE INDEX IF NOT EXISTS user ON users(characterName)");
    try {
      let stmt = db.prepare("REPLACE INTO users VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
      stmt.run(characterName, characterID, corporationID, allianceID, discordID, roleID, guildID, time().unix());
      stmt.finalize();

      db.each("SELECT * FROM users WHERE characterID = " + characterID, function (err, row) {
        console.log(row);
      });
    } catch (err) {
      console.log(err);
    }
  });
  db.close();
}