Beiträge von Marschl

alt.onClient('Account:CheckRegister', (player, username, password) => {
    pool.getConnection(function(error, con) {
        if(error) throw error;
        pool.query('SELECT * FROM `accounts` WHERE `AccountName` = ?',[username] , function(err, rows, fields) {
            if(err) throw err;
            if(rows[0] === undefined) {
                console.log("Username frei!")
                if(username.length < 4 && username.length > 100) {
                    console.log("Username zu kurz")
                    alt.emitClient(player, 'notification:username:toshort');
                    alt.emitClient(player, 'webview:register:load');
                } else {
                    alt.emitClient(player, 'notification:username:isfree');
                    if(password.length < 4 && password.length > 100) {
                        console.log("Passwort zu kurz")
                        alt.emitClient(player, 'notification:password:toshort');
                        alt.emitClient(player, 'webview:register:load');
                    } else {
                        pool.query('INSERT INTO `accounts` (`AccountName`, `Passwort`, `SocialClubID`) VALUES (?, ?, ?)', [username, password, player.socialId], function(err2, rows2, fields2) {
                            if(err2) throw err2;
                            console.log(rows2);
                            alt.emitClient(player, 'notification:register:complete');
                            con.release();
                        });
                    }
                }
            } else if(rows[0].AccountName == username) {
                console.log("Username nicht frei!");
                alt.emitClient(player, 'notification:username:exist');
                alt.emitClient(player, 'webview:register:load');
            }
            con.release();
        });
    });
});

        if(err) throw err;
                ^

Error: connect ETIMEDOUT
    at PoolConnection.Connection._handleConnectTimeout (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:412:13)
    at Object.onceWrapper (events.js:288:20)
    at Socket.emit (events.js:200:13)
    at Socket._onTimeout (net.js:432:8)
    at listOnTimeout (internal/timers.js:531:17)
    at processTimers (internal/timers.js:475:7)
    --------------------
    at Protocol._enqueue (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Protocol.handshake (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:51:23)
    at PoolConnection.connect (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:119:18)
    at Pool.getConnection (D:\workspace\statelife-server\node_modules\mysql\lib\Pool.js:48:16)
    at file:///D:/workspace/statelife-server/resources/statelife/server/AccountSystem/AccountVerify.mjs:7:10 {
  errorno: 'ETIMEDOUT',
  code: 'ETIMEDOUT',
  syscall: 'connect',
  fatal: true
}

import * as alt from 'alt';
import * as chat from 'chat';
import mysql from 'mysql';
import {pool} from '../database/database.mjs';

alt.onClient('AccountVerify', (player) => {
    pool.getConnection(function(err, con) {
        if(err) throw err;
        var sql = mysql.format('SELECT * from accounts WHERE SocialClub=' + player.socialId);
        con.query(sql, function(error, results, fields) {
            if(results[0] === undefined) {
                alt.emitClient(player, 'AccountSystemRegister');
            } else if(results[0].SocialClub == player.socialId) {
                alt.emitClient(player, 'AccountSystemLogin');
            }
            if(error) throw error;
        });
        con.release();
    });
});