Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const app = require('express')();
- const server = require('http').createServer(app);
- const io = require('socket.io').listen(server)
- const msql = require("mysql2");
- const bodyParser = require('body-parser')
- const urlencodedParser = bodyParser.urlencoded({extended: false});
- const conn = msql.createConnection({
- host: "localhost",
- user: "root",
- database: "usersdb",
- password: "pass"
- });
- conn.connect(function(err){
- if (err) {
- return console.error("Ошибка: " + err.message);
- }
- else{
- console.log("Подключение к серверу MySQL успешно установлено");
- }
- });
- app.engine('html', require('ejs').renderFile)
- app.get('/', (req, res) => {
- res.sendFile(__dirname + '/loginPage.html')
- })
- app.post("/main", urlencodedParser, (request, response) => {
- // if(!request.body) return response.sendStatus(400);
- // if(conn){
- // conn.query(`SELECT * FROM Users WHERE Nickname LIKE '${request.body.log}' AND Password LIKE '${request.body.pass}'`, (err, results) => {
- // console.log(results)
- // console.log(err)
- // app.get('/main', (req,res) => {
- // if(results.length > 0) {
- // res.render(__dirname + '/index.html')
- // }
- // else res.send('<h1>Вы ввели неверные данные, попробуйте ввести еще раз</h1>')
- // })
- // return results
- // });
- // }else{
- // console.log('База не подключена');
- // return null;
- // }
- console.log(request.body.log)
- console.log(request.body.pass)
- });
- server.listen(3000, () => {
- console.log('Server has been started on port 3000...')
- })
- let users = []
- let connections = []
- io.sockets.on('connection', socket => {
- console.log("You are successfully connected!");
- connections.push(socket);
- socket.on("disconnect", data => {
- connections.slice(connections.indexOf(socket), 1);
- console.log("You were disconnected");
- });
- // socket.on('enter chat', data => {
- // if(conn){
- // conn.query(`SELECT * FROM Users WHERE Nickname LIKE '${data.log}' AND Password LIKE '${data.pass}'`, (err, results) => {
- // console.log(results)
- // console.log(err)
- // app.get('/main', (req,res) => {
- // if(results.length > 0) {
- // res.render(__dirname + '/index.html')
- // }
- // else res.send('<h1>Вы ввели неверные данные, попробуйте ввести еще раз</h1>')
- // })
- // return results
- // });
- // }else{
- // console.log('База не подключена');
- // return null;
- // }
- // })
- io.sockets.on('add mess', data => {
- socket.emit('send mess',{ mess: data.mess, name: data.name })
- })
- })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement