[SAMMELTHEMA] Kleine Scripting Fragen - GTA V

Severity    Code    Description    Project    File    Line    Suppression State
Error    CS0246    The type or namespace name 'MethodInfo' could not be found (are you missing a using directive or an assembly reference?)    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Utilitis\CommandHandling\CommandEventHandler.cs    52    Active



Severity    Code    Description    Project    File    Line    Suppression State
Error    CS1022    Type or namespace definition, or end-of-file expected    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Server.cs    47    Active



Severity    Code    Description    Project    File    Line    Suppression State
Error    CS1002    ; expected    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Server.cs    44    Active



Severity    Code    Description    Project    File    Line    Suppression State
Error    CS0501    'Server.test(IPlayer)' must declare a body because it is not marked abstract, extern, or partial    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Server.cs    44    Active



Severity    Code    Description    Project    File    Line    Suppression State
Error    CS1519    Invalid token '{' in class, struct, or interface member declaration    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Server.cs    43    Active



Severity    Code    Description    Project    File    Line    Suppression State
Error    CS1519    Invalid token '{' in class, struct, or interface member declaration    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Server.cs    43    Active

Severity    Code    Description    Project    File    Line    Suppression State
Error    CS1519    Invalid token '{' in class, struct, or interface member declaration    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Server.cs    43    Active


Severity    Code    Description    Project    File    Line    Suppression State
Error    IDE1007    The name 'CMD' does not exist in the current context.    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Server.cs    42    Active


Severity    Code    Description    Project    File    Line    Suppression State
Error    CS0103    The name 'Assembly' does not exist in the current context    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Utilitis\CommandHandling\CommandEventHandler.cs    40    Active


Severity    Code    Description    Project    File    Line    Suppression State
Error    CS0246    The type or namespace name 'MethodInfo' could not be found (are you missing a using directive or an assembly reference?)    GettingStarted    C:\Users\Comirtur\source\repos\GettingStarted\GettingStarted\Utilitis\CommandHandling\CommandEventHandler.cs    35    Active

using System;
using System.Collections.Generic;
using System.Text;

namespace GettingStarted.Utilitis.CommandHandling
{

    [AttributeUsage(AttributeTargets.Method)]

    public class CMDAttribute : Attribute
    {
        public string Command { get; set; }

        public CMDAttribute(string cmd)
        {
            this.Command = cmd;
        }
    }
}

using System;
using System.Collections.Generic;
using System.Text;


using AltV.Net;
using AltV.Net.Elements.Entities;
using AltV.Net.Data;

namespace GettingStarted
{
    class ChatHandler
    {

        private readonly Action<string> broadcast;



        private readonly Action<IPlayer, string> send;


        public ChatHandler()
        {
            Alt.Import("chat", "broadcaster", out broadcast);
            Alt.Import("chat", "send", out send);
        }


        public void Boradcast(string message)
        {
            broadcast?.Invoke(message);
        }

        public void Send(IPlayer player, string message)
        {
            send?.Invoke(player, message);
        }

        public void SendErrorMessage(IPlayer player, string message)
        {
            Send(player, "{FFFFFF} [{ED1700}System{FFFFFF}] :" + message);
        }

    }
}

using System;
using System.Collections.Generic;
using System.Text;
using AltV.Net.Elements.Entities;
using AltV.Net;
using AltV.Net.Data;
using AltV.Net.Enums;

namespace GettingStarted.Utilitis.CommandHandling
{
    public class CommandEventHandler
    {
        ChatHandler c = new ChatHandler();




        public CommandEventHandler()
        {

        }


        public void OnPlayerSendCommand(IPlayer player, string cmd, object[] args)
        {
            if (args == null)
                args = new object[] { };

            InvokeCommand(player, cmd, args);
        }




        public MethodInfo ReturnCMDMethod(string cmd)
        {
            var cmdWithoutSlash = cmd.Split("/")[1];


            return Assembly.GetExecutingAssembly().GetTypes()
                .SelectMany(t => t.GetMethods())
                .Where(t => t.GetCustomAttributes(typeof(CMDAttribute), false).length > 0 &&
                m.GetCustomsAttribute<CMDAttribute>().Command == cmdWithoutSlash).FirstOrDefault();
        }



        public void InvokeCommand(IPlayer player, string cmd, object[] args)
        {
            try
            {
                MethodInfo method = ReturnCMDMethod(cmd);
                var methodParams = method.GetParameters();
                var obj = Activator.CreateInstance(method.DeclaringType);

                method.Invoke(obj, new object[] { });
            }
            catch(NullReferenceException)
            {
                c.SendErrorMessage(player, "Command not Found...");
            }
        }
    }
}

using System;
using AltV.Net;
using AltV.Net.Elements.Entities;
using AltV.Net.Data;

namespace GettingStarted
{
    public class Server : Resource
    {

        public override void OnStart()
        {
            Alt.Log("Server is listening!");


            //Events
            Alt.OnPlayerConnect += OnPlayerConnect;
            Alt.OnPlayerDead += Alt_OnPlayerDead;
        }

        private void Alt_OnPlayerDead(IPlayer player, IEntity killer, uint weapon)
        {
            player.Position = new Position((float)-1070.906250, (float)-2972.112803, (float)13.773568); //LS Air Position
            player.GiveWeapon(Weapons.AssaultRifle, 9000, true);
        }

        private void OnPlayerConnect(IPlayer player, string reason)
        {
            Alt.Log($"Player hat sich Verbunden! {player.Name}");

            player.Model = 0x3D843282;
            player.Position = new Position((float)-1070.906250, (float)-2972.112803, (float)13.773568); //LS Air Position
            player.GiveWeapon(Weapons.AssaultRifle, 9000, true);
        }


        public override void OnStop()
        {
            Alt.Log("Server Stopped.");
        }

        [CMD("test")]
        {
         public void test(IPlayer player)
        }
    }
}

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

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