module.exports.login = new LocalStrategy ({
  usernameField : 'email',
  passwordField : 'password',
  passReqToCallback: true
  },
  function(req, email, password, done) {
    db.getConnection(function(err, connection) {
      if(err) {
        return err;
      }
      else {
        connection.query("select * from users where users_email = '"+email+"'",function(err, rows) {
          if (err) {
            return done(err);
          }
          if (!rows.length) {
            return done(null, false, req.flash('loginMessage', 'Email Not Found'));
          }
          if (!(rows[0].users_password == bcrypt.compareSync(password, rows[0].users_password))) {
            return done(null, false, req.flash('loginMessage', 'Incorrect Password'));
            console.log(password);
          }
          return done(null, rows[0]);
        });
      }
    })
  }
);

module.exports.signup = new LocalStrategy ({
  usernameField : 'email',
  passwordField : 'password',
  passReqToCallback: true
  },
  function(req, email, password, done) {
    db.getConnection(function(err, connection) {
      if (err) {
        return err;
      }
      else {
        connection.query("select * from users where users_email = '"+email+"'", function(err, rows) {
          if (err) {
            return done(err);
          }
          if (rows.length) {
            return done(null, false, req.flash('registerMessage', 'That email is already registered'));
          }
          else {
            var newUser = new Object();
            newUser.email = email;
            newUser.firstname = req.body.firstname;
            newUser.lastname = req.body.lastname;
            newUser.password = password;
            var hash = bcrypt.hashSync(password, salt);
            var insertUser = "insert into users ( users_email, users_firstname, users_lastname, users_password) select '"+email+"','"+req.body.firstname+"','"+req.body.lastname+"','"+hash+"'";
            console.log(insertUser);
            connection.query(insertUser,function(err, rows) {
              newUser.users_id = rows.insertId;
              return done(null, newUser);
            });
          }
        });
      }
    });
  }
);