7W37YWh5

1var express = require("express");
2var bodyParser = require("body-parser");
3var http = require("http");
4var app = express();
5const url = require('url');
6
7
8
9var port = 3000;
10var mysql = require('mysql');
11
12var dataBaseScript = "" +
13    "CREATE TABLE IF NOT EXISTS " +
14    "`events`.`users` " +
15    "(" +
16    "`userId` INT UNSIGNED AUTO_INCREMENT ," +
17    "`name` VARCHAR(32)  DEFAULT NULL ," +
18    "`password` VARCHAR(32)  DEFAULT NULL ," +
19    "`shown_name` VARCHAR(32)  DEFAULT NULL ," +
20    "`token` VARCHAR(64)  DEFAULT NULL ," +
21    "PRIMARY KEY (`userId`), " +
22    "UNIQUE `name` (`name`)" +
23    ");";
24var insertScript = "INSERT INTO `users` (`userId`, `name`, `password`, `shown_name`, `token`) VALUES (NULL, '_NAME_', '_PASS_', NULL, NULL);"
25var connection = mysql.createConnection({
26    host: 'localhost',
27    user: 'root',
28    password: '',
29    database: 'events'
30});
31connection.query(dataBaseScript, function (err, res, fields) {
32    console.log(err);
33});
34
35
36app.use(bodyParser.urlencoded({extended: false}));
37app.use(bodyParser.json());
38app.listen(port, function () {
39    console.log("Started on PORT " + port);
40});
41app.get('/', function (req, res) {
42    console.log("index");
43    res.sendfile("index.html");
44});
45app.get('/login', function (req, res) {
46    console.log("login");
47    res.sendfile("login.html");
48});
49app.get('/register', function (req, res) {
50    console.log("register");
51    res.sendfile("register.html");
52});
53
54
55app.get('/sendNamePassword', function (req, res) {
56    req.on('data', function () {
57        // console.log(e);
58    });
59
60    req.on('end', function () {
61        // console.log(req.query);
62        name = req.query.name;
63        pass = req.query.pass;
64
65        var sqlScript = 'select password from users where ?';
66        connection.query(sqlScript, {name: name}, function (err, sqlRes) {
67            var result = {};
68            // console.log(err);
69            // console.log(res);
70            if (sqlRes.length == 0) {
71                result.status = 'error';
72                result.reason = 'userNotFound';
73            } else if (pass == sqlRes[0].password) {
74                result.status = 'ok';
75                result.reason = 'passwordConfirmed';
76            } else {
77                result.status = 'error';
78                result.reason = 'userAndPasswordNotMatches';
79            }
80            res.end(JSON.stringify(result));
81        });
82        // res.end(JSON.stringify(result));
83        // console.log(dbPass);
84        // console.log(pass);
85        // console.log(query);
86    });
87});