-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcontrollers.js
33 lines (31 loc) · 1.1 KB
/
controllers.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
function login(pg,conString,form,res,req){
pg.connect(conString, function(err, client) {
client.query("SELECT * from users WHERE name=$1 AND password=$2",[form.name,form.password], function(err, result) {
if(result.rows.length >0){
console.log(result.rows.length + result.rows[0].name + result.rows[0].wins);
req.session.name = form.name;
res.render(__dirname + '/game.jade',{name:form.name});
}
else{
delete req.session.name;
res.render(__dirname + '/login.jade',{access:"wrong password"});
}
});
});
}
function register(pg,conString,form,res){
pg.connect(conString, function(err, client) {
client.query("SELECT * from users WHERE name=$1",[form.name], function(err, result) {
if(result.rows.length >0){
console.log(err);
res.render(__dirname + '/login.jade',{access:"username already exist"});
}
else{
client.query("INSERT INTO users(name,password) VALUES($1,$2)",[form.name,form.password]);
res.render(__dirname + '/login.jade',{access:"register complete"});
}
});
});
}
module.exports.login = login;
module.exports.register = register;