Beiträge von Marschl

        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();
    });
});

Datenbankverbindng aufgebaut!
Connection 966 released
SQL: SELECT * FROM accounts WHERE `Username`=Test
Connection 966 released
undefined
Datenbankverbindng aufgebaut!
D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:437
      throw err; // Rethrow non-MySQL errors
      ^

TypeError: Cannot read property '0' of undefined
    at Query.<anonymous> (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:525:10)
    at Query._callback (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:491:16)
    at Query.Sequence.end (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24)
    at Query.ErrorPacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Query.js:90:8)
    at Protocol._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:91:28)
PS D:\workspace\statelife-server> ^C
PS D:\workspace\statelife-server> .\altv-server.exe
[07:18:22] alt:V Server, build #879, branch beta
[07:18:22] Starting [GER] Statelife - Roleplay on 0.0.0.0:7788
[07:18:22] Loading resource statelife
[07:18:22] Loading resource chat
[07:18:22] Loaded resource chat
[07:18:22] Loaded resource statelife
[07:18:22] Starting HTTP server on 0.0.0.0:7788
[07:18:22] Server started
[07:18:23] Connected to master server
Der Spieler Franky Smith hat den Server betreten! SocialID: 351754652
Datenbankverbindng aufgebaut!
Connection 968 released
SQL: SELECT * FROM accounts WHERE `Username`=Test
D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:437
      throw err; // Rethrow non-MySQL errors
      ^

ReferenceError: error2 is not defined
    at Ping.onOperationComplete (D:\workspace\statelife-server\node_modules\mysql\lib\Pool.js:110:5)
    at Ping.<anonymous> (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:525:10)
    at Ping._callback (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:491:16)
    at Ping.Sequence.end (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24)
    at Ping.Sequence.OkPacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Sequence.js:92:8)
    at Protocol._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:38:16)
PS D:\workspace\statelife-server> ^C
PS D:\workspace\statelife-server> .\altv-server.exe
[07:18:51] alt:V Server, build #879, branch beta
[07:18:51] Starting [GER] Statelife - Roleplay on 0.0.0.0:7788
[07:18:51] Loading resource statelife
[07:18:51] Loading resource chat
[07:18:51] Loaded resource chat
[07:18:51] Loaded resource statelife
[07:18:51] Starting HTTP server on 0.0.0.0:7788
[07:18:51] Server started
[07:18:51] Connected to master server
Der Spieler Franky Smith hat den Server betreten! SocialID: 351754652
Datenbankverbindng aufgebaut!
Connection 969 released
SQL: SELECT * FROM accounts WHERE `Username`=Test
Connection 969 released
undefined
D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:437
      throw err; // Rethrow non-MySQL errors
      ^

Error: ER_BAD_FIELD_ERROR: Unknown column 'Test' in 'where clause'
    at Query.Sequence._packetToError (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Query.ErrorPacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Query.js:77:18)
    at Protocol._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:91:28)
    at Socket.<anonymous> (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:525:10)
    at Socket.emit (events.js:200:13)
    at addChunk (_stream_readable.js:294:12)
    --------------------
    at Protocol._enqueue (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at PoolConnection.query (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:201:25)
    at file:///D:/workspace/statelife-server/resources/statelife/server/AccountSystem/AccountSystem.mjs:21:14
    at Ping.onOperationComplete (D:\workspace\statelife-server\node_modules\mysql\lib\Pool.js:110:5)
    at Ping.<anonymous> (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:525:10)
    at Ping._callback (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:491:16)
    at Ping.Sequence.end (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24)
    at Ping.Sequence.OkPacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Sequence.js:92:8)
    at Protocol._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:433:10) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sqlMessage: "Unknown column 'Test' in 'where clause'",
  sqlState: '42S22',
  index: 0,
  sql: 'SELECT * FROM accounts WHERE `Username`=Test'
}

alt.onClient('SQL:AccountLogin', (player, username, password) => {
    pool.getConnection(function(err, con) {
        if(err) throw err;
        var sql = mysql.format('SELECT * FROM accounts WHERE Username=' + username);
        con.query(sql, function(error, results) {
            console.log(results[0]);
        });
    });
});


alt.onClient('SQL:AccountRegister', (player, username, password) => {
    pool.getConnection(function(err2, con2) {
        if(err2) throw err2;
        var sql2 = mysql.format('SELECT * FROM accounts WHERE `Username`=' + username);
        console.log('SQL: ' + sql2)
        con2.query(sql2, function(error2, results2, fields2) {
            console.log(results2);
            if(error2) throw error2;
        });
        con2.release();
    });
});

SELECT * from accounts WHERE SocialClub=XXXXXXXXXXX
D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:437
      throw err; // Rethrow non-MySQL errors
      ^

TypeError: Cannot read property 'SocialClub' of undefined
    at Query.<anonymous> (file:///D:/workspace/statelife-server/resources/statelife/server/AccountSystem/AccountVerify.mjs:13:36)
    at Query.<anonymous> (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:525:10)
    at Query._callback (D:\workspace\statelife-server\node_modules\mysql\lib\Connection.js:491:16)
    at Query.Sequence.end (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24)
    at Query._handleFinalResultPacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Query.js:139:8)
    at Query.EofPacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\sequences\Query.js:123:8)
    at Protocol._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (D:\workspace\statelife-server\node_modules\mysql\lib\protocol\Protocol.js:38:16)

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);
        console.log(sql);
        con.query(sql, function(error, results, fields) {

            console.log(results[0].SocialClub);


            if(results[0].SocialClub == player.socialId) {
                //Login
                alt.log("Login");
                alt.emitClient(player, 'AccountVerifyLogin');
            } else {
                //Register
                alt.log("Register");
                alt.emitClient(player, 'AccountVerifyRegister');
            }
            if(error) throw error;
            con.release();
        });
    });
});