[SAMMELTHEMA] Kleine Scripting Fragen - GTA V

import * as alt from 'alt';
import chat from 'chat';

const spawnPos = {
  x: -2639.872,
  y: 1866.812,
  z: 160.135
};

const standartModel = 'mp_m_freemode_01';

alt.on('playerConnect', player => {
  alt.emitClient(player, 'spawn:Player', spawnPos);
});

alt.onClient('spawn:Ready', (player, pos) => {
  player.model = 'mp_m_freemode_01';
  player.spawn(pos.x, pos.y, pos.z, 0);
});

chat.registerCmd('sethp', (player, arg) => {
  if (!arg || arg.length <= 0) {
    chat.send(player, '/sethp (amount');
    return;
  }

  let amount = parseInt(arg[0]);
  if (amount < 100) {
    amount += 100;
  }

  if (isNaN(amount)) {
    chat.send(player, 'The amount specified; was not a number.');
    return;
  }
  player.health = amount;
});

chat.registerCmd('veh', (player, arg) => {
  if (!arg || arg.length <= 0) {
    chat.send(player, '/veh (model)');
    return;
  }
  try {
    const newVehicle = new alt.Vehicle(arg[0], player.pos.x, player.pos.y, player.pos.z, 0, 0, 0);
    alt.emitClient(player, 'vehicle:SetInto', newVehicle);
  } catch (err) {
    chat.send(player, 'That model was incorrect.');
  }
});

chat.registerCmd('loadpage', player => {
  alt.emitClient(player, 'webview:Load');
});

import * as alt from 'alt';
import * as native from 'natives';

let webview;

alt.onServer('vehicle:SetInto', newVehicle => {
  const localPlayer = alt.Player.local.scriptID;
  alt.setTimeout(() => {
    native.native.setPedIntoVehicle(localPlayer, newVehicle.scriptID, -1);
  }, 100);
});

alt.onServer('spawn:Player', pos => {
  alt.setTimeout(() => {
    alt.emitServer('spawn:Ready', pos);
  }, 100);
});

alt.onServer('webview:Load', () => {
  if (!webview) {
    webview = new alt.WebView('http://resource/client/html/index.html');
    webview.on('close:Webview', closeWebview);
  }
  webview.focus();
  alt.showCursor(true);
});

function closeWebview() {
  alt.showCursor(false);
  webview.destory();
  webview = undefined;
}

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